public ActionResult SaveNrs(NationRegionVM Nrs)
{
List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>;
if (list == null)
{
return(Redirect("Login/InLogin"));
}
else
{
Nrs.CmpyCode = list[0].CmpyCode;
Nrs.UserName = list[0].user_name;
return(Json(_NrService.SaveNrs(Nrs), JsonRequestBehavior.AllowGet));
}
}
public NationRegionVM SaveNrs(NationRegionVM Nrs)
{
return(_NrRepo.SaveNrs(Nrs));
}
public NationRegionVM SaveNrs(NationRegionVM Nrs)
{
try
{
if (!Nrs.EditFlag)
{
var Drecord = new List <string>();
List <NationNew> ObjList = new List <NationNew>();
ObjList.AddRange(Nrs.NationNew.Select(m => new NationNew
{
CmpyCode = m.CmpyCode,
Code = m.Code,
Name = m.Name,
}).ToList());
int n = 0;
n = ObjList.Count;
while (n > 0)
{
int Bbs1 = _EzBusinessHelper.ExecuteScalar("Select count(*) as [count1] from MNAT019 where CmpyCode='" + Nrs.CmpyCode + "' and Code='" + ObjList[n - 1].Code + "'");
if (Bbs1 == 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("'" + Nrs.CmpyCode + "',");
sb.Append("'" + ObjList[n - 1].Code + "',");
sb.Append("'" + ObjList[n - 1].Name + "',");
sb.Append("'')");
_EzBusinessHelper.ExecuteNonQuery("insert into MNAT019(CmpyCode,Code,Name,UniCodeName) values(" + sb.ToString() + "");
Nrs.SaveFlag = true;
Nrs.ErrorMessage = string.Empty;
}
else
{
Drecord.Add(ObjList[n - 1].Code.ToString());
Nrs.Drecord = Drecord;
Nrs.SaveFlag = false;
Nrs.ErrorMessage = "Duplicate Record";
}
n = n - 1;
}
//ds = _EzBusinessHelper.ExecuteDataSet("Select count(*) as [count1] from MNAT019 where CmpyCode='" + Nrs.CmpyCode + "' and Code='" + Nrs.Code + "'");
//dt = ds.Tables[0];
//int Nrs1 = 0;
//foreach (DataRow dr in dt.Rows)
//{
// Nrs1 = int.Parse(dr["count1"].ToString());
//}
//if (Nrs1 == 0)
//{
// StringBuilder sb = new StringBuilder();
// sb.Append("'" + Nrs.CmpyCode + "',");
// sb.Append("'" + Nrs.Code + "',");
// sb.Append("'" + Nrs.Name + "',");
// sb.Append("'" + Nrs.UniCodeName + "')");
// _EzBusinessHelper.ExecuteNonQuery("insert into MNAT019(CmpyCode,Code,Name,UniCodeName) values(" + sb.ToString() + "");
// Nrs.SaveFlag = true;
// Nrs.ErrorMessage = string.Empty;
//}
//else
//{
// Nrs.SaveFlag = false;
// Nrs.ErrorMessage = "Duplicate Record";
//}
return(Nrs);
}
var NrsEdit = _EzBusinessHelper.ExecuteScalarDec("Select COUNT(*) from MNAT019 where CmpyCode='" + Nrs.CmpyCode + "' and Code='" + Nrs.Code + "'");
if (NrsEdit != 0)
{
_EzBusinessHelper.ExecuteNonQuery("update MNAT019 set CmpyCode='" + Nrs.CmpyCode + "',Code='" + Nrs.Code + "',Name='" + Nrs.Name + "' where CmpyCode='" + Nrs.CmpyCode + "' and Code='" + Nrs.Code + "'");
Nrs.SaveFlag = true;
Nrs.ErrorMessage = string.Empty;
}
else
{
Nrs.SaveFlag = false;
Nrs.ErrorMessage = "Record not available";
}
}
catch (Exception ex)
{
Nrs.SaveFlag = false;
// unit.ErrorMessage = exceptionMessage;
}
return(Nrs);
}