public IEnumerable <copy_correction> AllUncheckedQuestions(copy_correction copy) { string query = @"SELECT session, class_id, section_id, subject_id, chapter_id, work_type, work_id, work_name, work_date FROM mst_class_notebook WHERE work_id NOT IN (SELECT work_id FROM copy_correction WHERE sr_number = @sr_number AND session = @session) AND session = @session AND subject_id = @subject_id AND class_id = @class_id AND section_id = @section_id AND chapter_id = @chapter_id ORDER BY work_date DESC , work_type"; var result = con.Query <copy_correction>(query, new { sr_number = copy.sr_number, session = copy.session, subject_id = copy.subject_id, class_id = copy.class_id, section_id = copy.section_id, chapter_id = copy.chapter_id }); return(result); }
public ActionResult AllUncheckedQuestions(int sr_number, string session, int class_id, int subject_id, int chapter_id, int section_id) { copy_correctionMain main = new copy_correctionMain(); copy_correction copy = new copy_correction(); copy.sr_number = sr_number; copy.session = session; copy.subject_id = subject_id; copy.class_id = class_id; copy.section_id = section_id; copy.chapter_id = chapter_id; ViewData["session"] = session; ViewData["subject_id"] = subject_id; ViewData["class_id"] = class_id; ViewData["section_id"] = section_id; ViewData["sr_number"] = sr_number; var result = main.AllUncheckedQuestions(copy); foreach (var corr in result) { corr.sr_number = sr_number; corr.chapter_id = chapter_id; corr.teacher_correctby = int.Parse(Request.Cookies["loginUserId"].Value.ToString()); corr.class_id = class_id; corr.section_id = section_id; corr.subject_id = subject_id; } return(View(result)); }
public ActionResult Student_Copy(copy_correction copy) { using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { string query = @"SELECT COUNT(*) FROM mst_std_class a, mst_std_section b WHERE a.session = b.session AND a.sr_num = b.sr_num AND a.class_id = @class_id AND b.section_id = @section_id AND a.sr_num = @sr_number"; int flag = con.Query <int>(query, new { sr_number = copy.sr_number, class_id = copy.class_id, section_id = copy.section_id }).SingleOrDefault(); if (flag == 0) { ModelState.AddModelError(String.Empty, "Student not found."); return(View(copy)); } return(RedirectToAction("AllUncheckedChapters", new { sr_number = copy.sr_number, session = copy.session, subject_id = copy.subject_id, class_id = copy.class_id, section_id = copy.section_id })); } }
public ActionResult Student_Copy(string session, int subject_id, int class_id, int section_id) { copy_correction copy = new copy_correction(); copy.subject_id = subject_id; copy.session = session; copy.class_id = class_id; copy.section_id = section_id; return(View(copy)); }
public ActionResult AllUncheckedChapters(int sr_number, string session, int subject_id, int class_id, int section_id) { copy_correctionMain main = new copy_correctionMain(); copy_correction copy = new copy_correction(); copy.sr_number = sr_number; copy.session = session; copy.subject_id = subject_id; copy.class_id = class_id; copy.section_id = section_id; ViewData["session"] = session; ViewData["subject_id"] = subject_id; ViewData["class_id"] = class_id; ViewData["section_id"] = section_id; ViewData["sr_number"] = sr_number; return(View(main.AllUncheckedChapterList(copy))); }
public IEnumerable <mst_chapter> AllUncheckedChapterList(copy_correction copy) { string query = @"SELECT session, class_id, section_id, subject_id, chapter_id, chapter_name, chapter_start_date, chapter_end_date FROM mst_chapter WHERE CONCAT(class_id, section_id, subject_id, chapter_id) IN (SELECT DISTINCT CONCAT(class_id, section_id, subject_id, chapter_id) FROM mst_class_notebook WHERE work_id NOT IN (SELECT work_id FROM copy_correction WHERE sr_number = @sr_number AND session = @session) AND session = @session) AND session = @session AND subject_id = @subject_id AND class_id = @class_id AND section_id = @section_id"; var result = con.Query <mst_chapter>(query, new { sr_number = copy.sr_number, session = copy.session, subject_id = copy.subject_id, class_id = copy.class_id, section_id = copy.section_id }); return(result); }