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