public ValidationMsg SaveGradeRange(GradeRangeTitle model, int usrId)
{
try
{
if (model.GradeRangeId == 0)
{
Sys_GradeRange obGradeRange = new Sys_GradeRange();
obGradeRange.GradeRangeName = model.GradeRangeName;
obGradeRange.Description = model.GradeDescription;
obGradeRange.IsActive = Convert.ToBoolean(model.IsActiveGradeRange);
obGradeRange.IsDelete = false;
obGradeRange.SetOn = DateTime.Now;
obGradeRange.SetBy = usrId;
obGradeRange.ModifiedOn = DateTime.Now;
obGradeRange.ModifiedBy = usrId;
_context.Sys_GradeRange.Add(obGradeRange);
int id = obGradeRange.GradeRangeID;
foreach (var item in model.gradeData)
{
Sys_GradeRangeFormat obRangeFormat = new Sys_GradeRangeFormat();
obRangeFormat.GradeRangeID = Convert.ToInt16(id);
obRangeFormat.GradeIDFrom = Convert.ToInt16(item.GradeIDFrom);
obRangeFormat.GradeIDTo = Convert.ToInt16(item.GradeIDTo);
obRangeFormat.Description = item.Description;
obRangeFormat.IsActive = Convert.ToBoolean(item.IsActive);
obRangeFormat.IsDelete = false;
obRangeFormat.SetOn = DateTime.Now;
obRangeFormat.ModifiedOn = DateTime.Now;
obRangeFormat.ModifiedBy = usrId;
_context.Sys_GradeRangeFormat.Add(obRangeFormat);
}
_context.SaveChanges();
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Saved Successfully.";
}
else
{
Sys_GradeRange isGradeRangeExist = (from temp in _context.Sys_GradeRange where temp.GradeRangeID == model.GradeRangeId select temp).FirstOrDefault();
isGradeRangeExist.GradeRangeName = model.GradeRangeName;
isGradeRangeExist.Description = model.GradeDescription;
isGradeRangeExist.IsActive = model.IsActiveGradeRange;
isGradeRangeExist.IsDelete = false;
isGradeRangeExist.ModifiedOn = DateTime.Now;
isGradeRangeExist.ModifiedBy = usrId;
_context.SaveChanges();
var result = (from temp in _context.Sys_GradeRangeFormat where temp.GradeRangeID == isGradeRangeExist.GradeRangeID select temp).ToList();
foreach (var item in result)
{
_context.Sys_GradeRangeFormat.Remove(item);
}
foreach (var item in model.gradeData)
{
Sys_GradeRangeFormat obRangeFormat = new Sys_GradeRangeFormat();
obRangeFormat.GradeRangeID = Convert.ToInt16(isGradeRangeExist.GradeRangeID);
obRangeFormat.GradeIDFrom = Convert.ToInt16(item.GradeIDFrom);
obRangeFormat.GradeIDTo = Convert.ToInt16(item.GradeIDTo);
obRangeFormat.Description = item.Description;
obRangeFormat.IsActive = item.IsActive;
obRangeFormat.IsDelete = false;
obRangeFormat.SetOn = DateTime.Now;
obRangeFormat.SetBy = usrId;
obRangeFormat.ModifiedOn = DateTime.Now;
obRangeFormat.ModifiedBy = usrId;
_context.Sys_GradeRangeFormat.Add(obRangeFormat);
}
_context.SaveChanges();
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Updated Successfully.";
}
}
catch (Exception ex)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Save Faild.";
}
return(_vmMsg);
}
public JsonResult btnSaveGradeRange(GradeRangeTitle model)
{
var allGradeItem = _dalGradeRangeFormat.SaveGradeRange(model, Convert.ToInt32(Session["UserID"]));
return(Json(allGradeItem, JsonRequestBehavior.AllowGet));
}
