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