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));
}
