public ActionResult SaveFunctionalArea(string Code, string Title, string Location)
{
Int32 FunctionalAreaId = 0;
try
{
SETUP_FunctionalArea setupFunctionalAreaRow = new SETUP_FunctionalArea();
if (String.IsNullOrEmpty(Code))
{
if (DALCommon.AutoCodeGeneration("SETUP_FunctionalArea") == 1)
{
Code = DALCommon.GetMaximumCode("SETUP_FunctionalArea");
}
}
if (!String.IsNullOrEmpty(Code))
{
setupFunctionalAreaRow.FA_Id = Code;
setupFunctionalAreaRow.FA_Code = Code;
setupFunctionalAreaRow.FA_Title = Title;
setupFunctionalAreaRow.Loc_Id = Location;
setupFunctionalAreaRow.FA_SortOrder = 1;
setupFunctionalAreaRow.FA_Active = 1;
FunctionalAreaId = objDALFunctionalArea.SaveFunctionalArea(setupFunctionalAreaRow);
ViewData["SaveResult"] = FunctionalAreaId;
}
return PartialView("GridData");
}
catch
{
return PartialView("GridData");
}
}
public int SaveFunctionalArea(SETUP_FunctionalArea newSetupFunctionalArea)
{
try
{
SCMSDataContext dbSCMS = Connection.Create();
SETUP_FunctionalArea existingSetupFunctionalArea = dbSCMS.SETUP_FunctionalAreas.Where(c => c.FA_Id.Equals(newSetupFunctionalArea.FA_Id)).SingleOrDefault();
if (existingSetupFunctionalArea != null)
{
existingSetupFunctionalArea.FA_Title = newSetupFunctionalArea.FA_Title;
existingSetupFunctionalArea.Cmp_Id = newSetupFunctionalArea.Cmp_Id;
existingSetupFunctionalArea.Loc_Id = newSetupFunctionalArea.Loc_Id;
existingSetupFunctionalArea.FA_SortOrder = newSetupFunctionalArea.FA_SortOrder;
existingSetupFunctionalArea.FA_Active = newSetupFunctionalArea.FA_Active;
}
else
{
dbSCMS.SETUP_FunctionalAreas.InsertOnSubmit(newSetupFunctionalArea);
}
dbSCMS.SubmitChanges();
return Convert.ToInt32(newSetupFunctionalArea.FA_Id);
}
catch
{
return 0;
}
}
