public int Save(SETUP_Gender newSetupGender) { try { SCMSDataContext dbSCMS = Connection.Create(); SETUP_Gender existingGender = dbSCMS.SETUP_Genders.Where(c => c.Gndr_Id.Equals(newSetupGender.Gndr_Id)).SingleOrDefault(); if (existingGender != null) { existingGender.Gndr_Title = newSetupGender.Gndr_Title; existingGender.Gndr_Abbreviation = newSetupGender.Gndr_Abbreviation; existingGender.Gndr_Active = newSetupGender.Gndr_Active; existingGender.Gndr_SortOrder = newSetupGender.Gndr_SortOrder; } else { dbSCMS.SETUP_Genders.InsertOnSubmit(newSetupGender); } dbSCMS.SubmitChanges(); return Convert.ToInt32(newSetupGender.Gndr_Id); } catch { return 0; } }
public ActionResult SaveRecord(string Code, string Title, string Abbreviation) { Int32 li_ReturnValue = 0; try { SETUP_Gender row_Gender = new SETUP_Gender(); if (String.IsNullOrEmpty(Code)) { if (DALCommon.AutoCodeGeneration("SETUP_Gender") == 1) { Code = DALCommon.GetMaximumCode("SETUP_Gender"); } } if (!String.IsNullOrEmpty(Code)) { row_Gender.Gndr_Id = Code; row_Gender.Gndr_Code = Code; row_Gender.Gndr_Title = Title; row_Gender.Gndr_Abbreviation = Abbreviation; row_Gender.Gndr_Active = 1; row_Gender.Gndr_SortOrder = 1; li_ReturnValue = objDalGender.Save(row_Gender); ViewData["SaveResult"] = li_ReturnValue; } return PartialView("GridData"); } catch { return PartialView("GridData"); } }