public ActionResult SaveDis(DisciplineVM Dis)
{
List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>;
if (list == null)
{
return(Redirect("Login/InLogin"));
}
else
{
Dis.CmpyCode = list[0].CmpyCode;
Dis.UserName = list[0].user_name;
return(Json(_DiService.SaveDis(Dis), JsonRequestBehavior.AllowGet));
}
}
public DisciplineVM SaveDis(DisciplineVM Dis)
{
try
{
if (!Dis.EditFlag)
{
var Drecord = new List <string>();
List <DisciplineDetailnew> ObjList = new List <DisciplineDetailnew>();
ObjList.AddRange(Dis.DisciplineDetailnew.Select(m => new DisciplineDetailnew
{
CmpyCode = m.CmpyCode,
Code = m.Code,
Name = m.Name,
UniCodeName = m.UniCodeName
}).ToList());
int n = 0;
n = ObjList.Count;
while (n > 0)
{
int Dis1 = _EzBusinessHelper.ExecuteScalar("Select count(*) as [count1] from MDISC010 where CmpyCode='" + Dis.CmpyCode + "' and Code='" + ObjList[n - 1].Code + "'");
if (Dis1 == 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("'" + Dis.CmpyCode + "',");
sb.Append("'" + ObjList[n - 1].Code + "',");
sb.Append("'" + ObjList[n - 1].Name + "',");
sb.Append("'" + ObjList[n - 1].UniCodeName + "')");
_EzBusinessHelper.ExecuteNonQuery("insert into MDISC010(CmpyCode,Code,Name,UniCodeName) values(" + sb.ToString() + "");
Dis.SaveFlag = true;
Dis.ErrorMessage = string.Empty;
}
else
{
Drecord.Add(ObjList[n - 1].Code.ToString());
Dis.Drecord = Drecord;
Dis.SaveFlag = false;
Dis.ErrorMessage = "Duplicate Record";
}
n = n - 1;
}
return(Dis);
}
var StatsEdit = _EzBusinessHelper.ExecuteScalar("Select count(*) from MDISC010 where CmpyCode='" + Dis.CmpyCode + "' and Code='" + Dis.Code + "'");
if (StatsEdit != 0)
{
_EzBusinessHelper.ExecuteNonQuery("update MDISC010 set CmpyCode='" + Dis.CmpyCode + "',Code='" + Dis.Code + "',Name='" + Dis.Name + "',UniCodeName='" + Dis.UniCodeName + "' where CmpyCode='" + Dis.CmpyCode + "' and Code='" + Dis.Code + "'");
Dis.SaveFlag = true;
Dis.ErrorMessage = string.Empty;
}
else
{
Dis.SaveFlag = false;
Dis.ErrorMessage = "Record not available";
}
}
catch (Exception ex)
{
Dis.SaveFlag = false;
// unit.ErrorMessage = exceptionMessage;
}
return(Dis);
}
public DisciplineVM SaveDis(DisciplineVM Dis)
{
return(_DiRepo.SaveDis(Dis));
}