public int AddEdit(ExamGrades entity)
{
entity.DateCreated = DateTime.Now;
entity.DateModified = DateTime.Now;
User objUser = null;
if (eSchoolSession.IsInSession(SessionKeys.CurrentUser))
objUser = (User)eSchoolSession.GetDirectValue(SessionKeys.CurrentUser);
if (string.IsNullOrEmpty(entity.ExamGradeID))
{
entity.ExamGradeID = Utility.GeneratorUniqueId("EXMGRD_");
if (objUser != null && !string.IsNullOrEmpty(objUser.UserID))
{
entity.CreatedByID = objUser.UserID;
entity.ModifiedByID = objUser.UserID;
}
else
{
entity.CreatedByID = "1";
entity.ModifiedByID = "1";
}
}
else
{
if (objUser != null && !string.IsNullOrEmpty(objUser.UserID))
entity.ModifiedByID = objUser.UserID;
else
entity.ModifiedByID = "1";
}
string[] addParams = new string[] { ExamGrades_Constant.EXAM_GRADE_ID, ExamGrades_Constant.EXAM_ID, ExamGrades_Constant.MARKS_PERCENT_FROM, ExamGrades_Constant.MARKS_PERCENT_TO, ExamGrades_Constant.GRADE, ExamGrades_Constant.CREATED_BY_ID, ExamGrades_Constant.MODIFIED_BY_ID };
return _IExamGradesRepository.ExecuteNonQuery(entity, addParams, ExamGrades_Constant.SPROC_EXAMGRADES_UPS);
}
private SelectList GetGradesForExam(string ExamID)
{
List<ExamGrades> lstExamGrade = new List<ExamGrades>();
ExamGrades obj = new ExamGrades();
obj.ExamID = ExamID;
lstExamGrade = _IExamGradesService.GetGradesForExam(obj).ToList();
SelectList retList = new SelectList(lstExamGrade, "ExamGradeID", "Grade");
return retList;
}
public ActionResult DeleteExamGrades(string ExamGradeID, string ExamID = "")
{
ExamGrades model = new ExamGrades();
model.ExamGradeID = ExamGradeID;
model.ExamID = ExamID;
_IExamGradesService.Delete(model);
return RedirectToAction("ManageExamGrades", "Exam", new { ExamId = model.ExamID });
}
public ActionResult AddEditExamGrades(ExamGrades model)
{
_IExamGradesService.AddEdit(model);
return RedirectToAction("ManageExamGrades", "Exam", new { ExamID = model.ExamID });
}
public ActionResult AddEditExamGrades(string ExamGradeID = "", string ExamId = "")
{
ExamGrades model = new ExamGrades();
if (!string.IsNullOrEmpty(ExamGradeID))
{
model.ExamGradeID = ExamGradeID;
model = _IExamGradesService.Get(model);
}
model.ExamID = ExamId;
ViewBag.GradeList = GetLookupValues("Grade");
return PartialView("_AddEditExamGrades", model);
}
public object GetScalar(ExamGrades obj)
{
throw new NotImplementedException();
}
public IEnumerable<ExamGrades> GetGradesForExam(ExamGrades obj)
{
string[] addParams = new string[] { ExamGrades_Constant.EXAM_ID};
return _IExamGradesRepository.GetAll(obj, addParams, ExamGrades_Constant.SPROC_EXAMGRADES_FOREXAM);
}
public IEnumerable<ExamGrades> GetAll(ExamGrades entity)
{
string[] addParams = new string[] { ExamGrades_Constant.EXAM_ID, Constants.PAGEINDEX, Constants.PAGESIZE, Constants.SORTEXP };
return _IExamGradesRepository.GetAll(entity, addParams, ExamGrades_Constant.SPROC_EXAMGRADES_LSTALL);
}
public ExamGrades Get(ExamGrades obj)
{
string[] addParams = new string[] { ExamGrades_Constant.EXAM_GRADE_ID};
return _IExamGradesRepository.Get(obj, addParams, ExamGrades_Constant.SPROC_EXAMGRADES_SEL);
}
public int Delete(ExamGrades entity)
{
string[] addParams = new string[] { ExamGrades_Constant.EXAM_GRADE_ID};
return _IExamGradesRepository.ExecuteNonQuery(entity, addParams, ExamGrades_Constant.SPROC_EXAMGRADES_DEL);
}
