public ActionResult DeleteSubjectTeacher(mst_class_subject_teacher instance) { mst_class_subject_teacherMain main = new mst_class_subject_teacherMain(); main.DeleteSubjectTeacher(instance); return(RedirectToAction("AllSubjectTeacher")); }
public void DeleteSubjectTeacher(mst_class_subject_teacher mst) { try { string query = @"DELETE FROM `mst_class_subject_teacher` WHERE session = @session AND class_id = @class_id AND section_id = @section_id AND subject_id = @subject_id AND subject_teacher_id = @subject_teacher_id"; con.Execute(query, mst); } catch (Exception ex) { Console.Write(ex.ToString()); } }
public ActionResult AddSubjectTeacher(mst_class_subject_teacher mst) { try { mst_class_subject_teacherMain main = new mst_class_subject_teacherMain(); main.AddSubjectTeacher(mst); return(RedirectToAction("AllSubjectTeacher")); } catch { mst_classMain mstClass = new mst_classMain(); emp_detailMain mstFaculty = new emp_detailMain(); mst_sessionMain sess = new mst_sessionMain(); var class_list = mstClass.AllClassList(sess.findFinal_Session()); var emp_list = mstFaculty.DDFacultyList(); IEnumerable <SelectListItem> list = new SelectList(class_list, "class_id", "class_name"); IEnumerable <SelectListItem> list2 = new SelectList(emp_list, "user_id", "user_name"); ViewData["class_id"] = list; ViewData["subject_teacher_id"] = list2; ModelState.AddModelError(String.Empty, "Subject Already Assigned"); return(View(mst)); } }
public void AddSubjectTeacher(mst_class_subject_teacher mst) { try { mst_sessionMain sess = new mst_sessionMain(); string query = @"INSERT INTO `mst_class_subject_teacher` (`session`, `class_id`, `section_id`, `subject_id`, `subject_teacher_id`) VALUES (@session, @class_id, @section_id, @subject_id, @subject_teacher_id)"; mst.session = sess.findFinal_Session(); con.Execute(query, new { mst.session, mst.class_id, mst.section_id, mst.subject_id, mst.subject_teacher_id }); } catch (Exception ex) { throw ex; } }