public ActionResult SaveFNMCAT(FNMCAT_VM FC) { List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>; if (list == null) { return(Redirect("Login/InLogin")); } else { FC.CMPYCODE = list[0].CmpyCode; FC.UserName = list[0].user_name; return(Json(_FNMCATService.SaveFNMCAT(FC), JsonRequestBehavior.AllowGet)); } }
public FNMCAT_VM SaveFNMCAT(FNMCAT_VM FC) { return(_FNMCATRepo.SaveFMHEAD(FC)); }
public FNMCAT_VM SaveFMHEAD(FNMCAT_VM FC) { try { if (!FC.EditFlag) { var Drecord = new List <string>(); List <FNMCATDetailnew> ObjList = new List <FNMCATDetailnew>(); ObjList.AddRange(FC.FNMCATDetailnew.Select(m => new FNMCATDetailnew { CMPYCODE = m.CMPYCODE, FNMSLCAT_CODE = m.FNMSLCAT_CODE, DESCRIPTION = m.DESCRIPTION, }).ToList()); int n = 0; n = ObjList.Count; while (n > 0) { int Stats1 = _EzBusinessHelper.ExecuteScalar("Select count(*) as [count1] from FNMSLCAT where CmpyCode='" + FC.CMPYCODE + "' and FNMSLCAT_CODE='" + ObjList[n - 1].FNMSLCAT_CODE + "'"); if (Stats1 == 0) { StringBuilder sb = new StringBuilder(); sb.Append("'" + FC.CMPYCODE + "',"); sb.Append("'" + ObjList[n - 1].FNMSLCAT_CODE + "',"); sb.Append("'" + ObjList[n - 1].DESCRIPTION + "')"); _EzBusinessHelper.ExecuteNonQuery("insert into FNMSLCAT(CMPYCODE,FNMSLCAT_CODE,DESCRIPTION) values(" + sb.ToString() + ""); _EzBusinessHelper.ActivityLog(FC.CMPYCODE, FC.UserName, "Add FN Category", ObjList[n - 1].FNMSLCAT_CODE, Environment.MachineName); FC.SaveFlag = true; FC.ErrorMessage = string.Empty; } else { Drecord.Add(ObjList[n - 1].FNMSLCAT_CODE.ToString()); FC.Drecord = Drecord; FC.SaveFlag = false; FC.ErrorMessage = "Duplicate Record"; } n = n - 1; } return(FC); } var StatsEdit = _EzBusinessHelper.ExecuteScalarDec("Select count(*) from FNMSLCAT where CmpyCode='" + FC.CMPYCODE + "' and FNMSLCAT_CODE='" + FC.FNMSLCAT_CODE + "'and Flag=0"); if (StatsEdit != 0) { _EzBusinessHelper.ExecuteNonQuery("update FNMSLCAT set CmpyCode='" + FC.CMPYCODE + "',FNMSLCAT_CODE='" + FC.FNMSLCAT_CODE + "',DESCRIPTION='" + FC.DESCRIPTION + "' where CmpyCode='" + FC.CMPYCODE + "' and FNMSLCAT_CODE='" + FC.FNMSLCAT_CODE + "'"); _EzBusinessHelper.ActivityLog(FC.CMPYCODE, FC.UserName, "Update FMHead", FC.FNMSLCAT_CODE, Environment.MachineName); FC.SaveFlag = true; FC.ErrorMessage = string.Empty; } else { FC.SaveFlag = false; FC.ErrorMessage = "Record not available"; } } catch (Exception ex) { FC.SaveFlag = false; } return(FC); }