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;
}
