public DataTable CRUDAddExams(StudentsExams stdExam, string action)
{
DataTable dtResult = new DataTable();
try
{
SqlParameter objSqlParameter = new SqlParameter("StudentExamId", stdExam.ExamTimesId);
SqlParameter objSqlParameter1 = new SqlParameter("StudentId", stdExam.StudentId);
SqlParameter objSqlParameter2 = new SqlParameter("Description", stdExam.Description);
SqlParameter objSqlParameter3 = new SqlParameter("CourseId", stdExam.CourseId);
SqlParameter objSqlParameter4 = new SqlParameter("ExamTime", stdExam.ExamTimesId);
SqlParameter objSqlParameter5 = new SqlParameter("ExamDate", stdExam.ExamDate);
SqlParameter objSqlParameter6 = new SqlParameter("Fees", stdExam.Fees);
SqlParameter objSqlParameter7 = new SqlParameter("IsExpired", stdExam.IsExpired);
SqlParameter objSqlParameter8 = new SqlParameter("ExamResult", stdExam.ExamResult);
SqlParameter objSqlParameter9 = new SqlParameter("IsAppeared", stdExam.IsAppeared);
SqlParameter objSqlParameter10 = new SqlParameter("LoggedInUser", stdExam.LoggedInUser);
SqlParameter objSqlParameter11 = new SqlParameter("Action", action);
List <SqlParameter> lstSqlParams = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1, objSqlParameter2, objSqlParameter3, objSqlParameter4, objSqlParameter5, objSqlParameter6, objSqlParameter7, objSqlParameter8, objSqlParameter9, objSqlParameter10, objSqlParameter11 });
dtResult = DBCommon.ExecuteDataAdapterDataTable("CRUDExams", lstSqlParams);
}
catch (Exception ex)
{
}
return(dtResult);
}
public async Task <IActionResult> Edit(int id, [Bind("Ppkfkstudent,Ppkfkexam,Grade")] StudentsExams studentsExams)
{
if (id != studentsExams.Ppkfkstudent)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(studentsExams);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!StudentsExamsExists(studentsExams.Ppkfkstudent))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["Ppkfkexam"] = new SelectList(_context.Exams, "Pkexam", "Subject", studentsExams.Ppkfkexam);
ViewData["Ppkfkstudent"] = new SelectList(_context.Students, "Pkstudent", "Name", studentsExams.Ppkfkstudent);
return(View(studentsExams));
}
public ActionResult AddStudentExam(long?id)
{
StudentsExams exam = new StudentsExams();
exam.ListCourse = new SelectList(GetDropdownList(objCourseBL.CRUDCourses(new CourseMaster(), "L"), "CourseName", "CourseId", "Select Course"), "Value", "Text");
exam.ExamTimeList = new SelectList(GetDropdownList(objExamBL.CRUDExamTimes(new ExamTimes(), "L"), "ExamTime", "ExamTimesId", "Select Exam Time"), "Value", "Text");
return(View(exam));
}
public ActionResult StudentDashboard()
{
StudentsExams objExam = new StudentsExams();
objExam.StudentId = long.Parse("0" + Request.Cookies["UserId"].Value);
List <StudentsExams> examList = examBL.CRUDAddExams(objExam, "L");
return(View(examList));
}
public ActionResult ViewStudentExams(long id)
{
StudentsExams objExam = new StudentsExams();
objExam.StudentId = id;
List <StudentsExams> examList = objExamBL.CRUDAddExams(objExam, "L");
return(View(examList));
}
public async Task <IActionResult> Create([Bind("Ppkfkstudent,Ppkfkexam,Grade")] StudentsExams studentsExams)
{
if (ModelState.IsValid)
{
_context.Add(studentsExams);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["Ppkfkexam"] = new SelectList(_context.Exams, "Pkexam", "Subject", studentsExams.Ppkfkexam);
ViewData["Ppkfkstudent"] = new SelectList(_context.Students, "Pkstudent", "Name", studentsExams.Ppkfkstudent);
return(View(studentsExams));
}
public List <StudentsExams> CRUDAddExams(StudentsExams exams, string action)
{
List <StudentsExams> examList = new List <StudentsExams>();
try
{
DataTable dtResponse = examDA.CRUDAddExams(exams, action);
if (dtResponse != null && dtResponse.Rows.Count > 0)
{
examList = dtResponse.ConvertToListOf <StudentsExams>();
}
}
catch (Exception ex)
{
throw;
}
return(examList);
}
public ActionResult AddStudentExam(StudentsExams objExam)
{
try
{
objExam.LoggedInUser = long.Parse("0" + Request.Cookies["UserId"].Value);
StudentsExams objUserDetails = objExamBL.CRUDAddExams(objExam, (objExam.StudentExamId > 0 ? "U" : "I")).FirstOrDefault();
if (objUserDetails.CRUDStatus == "success" || objUserDetails.StudentExamId > 0)
{
TempData["SuccessMessage"] = "You have " + (objExam.StudentExamId > 0 ? "updated" : "added") + " one Student Exam successfully";
return(RedirectToAction("Students", "Student"));
}
else
{
TempData["ErrorMessage"] = objUserDetails.CRUDStatus;
return(RedirectToAction("Students", "Student"));
}
}
catch (Exception ex)
{
TempData["ErrorMessage"] = ex.Message;
return(RedirectToAction("Students", "Student"));
}
}