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