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