// Insertion public ActionResult SaveRecord(String ps_Code, String Location, String Title) { Int32 li_ReturnValue = 0; try { SETUP_CodeAnalysis3 lrow_CodeAnalysis3 = new SETUP_CodeAnalysis3(); if (String.IsNullOrEmpty(ps_Code)) { if (DALCommon.AutoCodeGeneration("SETUP_CodeAnalysis3") == 1) { ps_Code = DALCommon.GetMaximumCode("SETUP_CodeAnalysis3"); } } if (!String.IsNullOrEmpty(ps_Code)) { lrow_CodeAnalysis3.CA_Id = ps_Code; lrow_CodeAnalysis3.CA_Code = ps_Code; lrow_CodeAnalysis3.CA_Title = Title; lrow_CodeAnalysis3.Loc_Id = Location; lrow_CodeAnalysis3.CA_Active = 1; li_ReturnValue = objDALCodeAnalysis3.SaveRecord(lrow_CodeAnalysis3); ViewData["SaveResult"] = li_ReturnValue; } return PartialView("GridData"); } catch { return PartialView("GridData"); } }
public int SaveRecord(SETUP_CodeAnalysis3 lrow_CodeAnalysis3) { int li_ReturnValue = 0; try { SCMSDataContext dbSCMS = Connection.Create(); SETUP_CodeAnalysis3 lRow_ExistingData = dbSCMS.SETUP_CodeAnalysis3s.Where(c => c.CA_Id.Equals(lrow_CodeAnalysis3.CA_Id)).SingleOrDefault(); if (lRow_ExistingData != null) { lRow_ExistingData.CA_Title = lrow_CodeAnalysis3.CA_Title; lRow_ExistingData.Loc_Id = lrow_CodeAnalysis3.Loc_Id; } else { dbSCMS.SETUP_CodeAnalysis3s.InsertOnSubmit(lrow_CodeAnalysis3); } dbSCMS.SubmitChanges(); li_ReturnValue = Convert.ToInt32(lrow_CodeAnalysis3.CA_Id); } catch { return 0; } return li_ReturnValue; }