• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 334
  • Last Modified:

save changes C# - LINQ - ASP.NET

Consider this code for filling in the data for a record:

  string[] aflidsid = Session["afa_agentformlistidsid"].ToString().Split('-');
            
            using (AgentFormsDataContext dc = new AgentFormsDataContext())
            {
                getOneAgentForm = dc.AgentFormEdit_AgentForm_Get(Convert.ToInt32(aflidsid[0]), Convert.ToInt32(aflidsid[1])).ToList<Models.AgentFormEdit_AgentForm_GetResult>();                
            }     

            foreach (Models.AgentFormEdit_AgentForm_GetResult agentfield in getOneAgentForm)
            {
                ddlLookupFormType.LookupID = agentfield.FormTypeID;
                TextBoxSequence.Text = agentfield.Sequence.ToString();
                TextBoxFormName.Text = agentfield.FormName;
                TextBoxColist.Text = agentfield.ColistFlag.ToString();
                RadioButtonAcceptanceRequiredFalse.Checked = agentfield.AcceptanceReqd == true ?  false : true;
                RadioButtonAcceptanceRequiredTrue.Checked = !RadioButtonAcceptanceRequiredFalse.Checked;
                RadioButtonDuplicatesAllowedFalse.Checked = agentfield.DuplicatesAllowed == true ? false : true;
                RadioButtonDuplicatesAllowedTrue.Checked = !RadioButtonDuplicatesAllowedFalse.Checked;                
                TextBoxExternalLink.Text = agentfield.ExternalLink;
                TextBoxTaskCode.Text = agentfield.TaskCode;
             //   TextBoxAMFirm.Text = agentfield.AMFID.ToString();
             //   TextBoxClient.Text = agentfield.ClientID.ToString();
                ddlProducts.SelectedValue = agentfield.ProductID.ToString();
                RadioButtonActiveFalse.Checked = agentfield.Active == true ? false : true;
                RadioButtonActiveTrue.Checked = !RadioButtonActiveFalse.Checked;

                //ternary operator syntax example
                //int ystep = y0 < y1 ? 1 : -1;
            }         

Open in new window




How to I then save any changes using the same construct at a later time?

In other words:

Models.AgentFormEdit_AgentForm_GetResult

is how I get my data

so I need the analog:

Models.AgentFormEdit_AgentForm_Update?


I can write a stored procedure to do the update...not sure of the C# ( LINQ? ) syntax...
0
Tom Knowlton
Asked:
Tom Knowlton
1 Solution
 
Gary DavisDir Internet SvcsCommented:
You can execute a stored proc out of the datacontext using ExecuteCommand() or if the SP is part of the AgentFormsDataContext, it will be available to call directly as a method of the context.

Alternatively, you could issue your dc.AgentFormEdit_AgentForm_Get() call to initialize the context with the data, update the fields in the loop similar to above (the datacontext will track the changed properties) and finally, call SubmitChanges().
0
 
Tom KnowltonWeb developerAuthor Commented:
Thank you!
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now