public ActionResult SaveRecord(String ps_Code, String ps_Title) { Int32 li_ReturnValue = 0; try { SECURITY_UserGroup lrow_Data = new SECURITY_UserGroup(); if (String.IsNullOrEmpty(ps_Code)) { if (DALCommon.AutoCodeGeneration("SECURITY_UserGroup") == 1) { ps_Code = DALCommon.GetMaximumCode("SECURITY_UserGroup"); } } if (!String.IsNullOrEmpty(ps_Code)) { lrow_Data.UsrGrp_Id = ps_Code; lrow_Data.UsrGrp_Code = ps_Code; lrow_Data.UsrGrp_Title = ps_Title; lrow_Data.UsrGrp_Active = 1; li_ReturnValue = objDal.SaveRecord(lrow_Data); ViewData["SaveResult"] = li_ReturnValue; } return PartialView("GridData"); } catch { return PartialView("GridData"); } }
public int SaveRecord(SECURITY_UserGroup pRow_NewData) { int li_ReturnValue = 0; try { SCMSDataContext dbSCMS = Connection.Create(); SECURITY_UserGroup lRow_ExistingData = dbSCMS.SECURITY_UserGroups.Where(c => c.UsrGrp_Id.Equals(pRow_NewData.UsrGrp_Id)).SingleOrDefault(); if (lRow_ExistingData != null) { lRow_ExistingData.UsrGrp_Title = pRow_NewData.UsrGrp_Title; } else { dbSCMS.SECURITY_UserGroups.InsertOnSubmit(pRow_NewData); } dbSCMS.SubmitChanges(); li_ReturnValue = Convert.ToInt32(pRow_NewData.UsrGrp_Id); } catch { return 0; } return li_ReturnValue; }