public ActionResult AddExamClass(mst_exam_class mst)
{
try
{
mst_exam_classMain main = new mst_exam_classMain();
main.AddExamClass(mst);
return(RedirectToAction("AllExamClassList"));
}
catch
{
mst_classMain mstClass = new mst_classMain();
mst_examMain mstsubject = new mst_examMain();
mst_sessionMain sess = new mst_sessionMain();
var class_list = mstClass.AllClassList(sess.findFinal_Session());
var exam_list = mstsubject.AllExamList();
IEnumerable <SelectListItem> list = new SelectList(class_list, "class_id", "class_name");
IEnumerable <SelectListItem> list1 = new SelectList(exam_list, "exam_id", "exam_name");
ViewData["class_id"] = list;
ViewData["exam_id"] = list1;
ModelState.AddModelError(String.Empty, "Class Already Assigned");
return(View(mst));
}
}
public ActionResult AddSection(mst_section mst)
{
try
{
mst_sectionMain mstMain = new mst_sectionMain();
mstMain.AddSection(mst);
return(RedirectToAction("AllSectionList"));
}
catch (Exception ex)
{
mst_classMain mstClass = new mst_classMain();
mst_sessionMain sess = new mst_sessionMain();
var class_list = mstClass.AllClassList(sess.findActive_Session());
IEnumerable <SelectListItem> list = new SelectList(class_list, "class_id", "class_name");
ViewData["class_id"] = list;
if (mst.Section_name == null || mst.class_id == 0)
{
ModelState.AddModelError(String.Empty, "Fields cannot be empty.");
}
else
{
ModelState.AddModelError(String.Empty, "Section Already Created.");
}
return(View(mst));
}
}
public ActionResult AddRemarks()
{
mst_classMain mstClass = new mst_classMain();
bool flag;
if (User.IsInRole("superadmin") || User.IsInRole("principal"))
{
flag = true;
}
else
{
flag = false;
}
var class_list = mstClass.AllClassListByTeacher(Int32.Parse(Request.Cookies["loginUserId"].Value.ToString()), flag);
IEnumerable <SelectListItem> list = new SelectList(class_list, "class_id", "class_name");
ViewData["class_id"] = list;
mst_termMain mst_term = new mst_termMain();
var term_list = mst_term.AllTermList();
IEnumerable <SelectListItem> list1 = new SelectList(term_list, "term_id", "term_name");
ViewData["term_id"] = list1;
return(View());
}
public ActionResult addExamMarks()
{
mst_classMain mstClass = new mst_classMain();
bool flag;
if (User.IsInRole("superadmin") || User.IsInRole("principal"))
{
flag = true;
}
else
{
flag = false;
}
var class_list = mstClass.AllClassListByTeacher(Int32.Parse(Request.Cookies["loginUserId"].Value.ToString()), flag);
IEnumerable <SelectListItem> list = new SelectList(class_list, "class_id", "class_name");
emp_detailMain empMain = new emp_detailMain();
var emp_list = empMain.DDFacultyList();
IEnumerable <SelectListItem> list1 = new SelectList(emp_list, "user_id", "user_name");
ViewData["class_id"] = list;
ViewData["marks_assigned_user_id"] = list1;
return(View());
}
public ActionResult AddClassCoScholastic(mst_class_coscholastic mst)
{
try
{
mst_class_coscholasticMain main = new mst_class_coscholasticMain();
main.AddClassCoscholastic(mst);
return(RedirectToAction("AllClassCoScholasticList"));
}
catch
{
mst_classMain mstClass = new mst_classMain();
mst_co_scholasticMain mstcoscholastic = new mst_co_scholasticMain();
mst_sessionMain sess = new mst_sessionMain();
var class_list = mstClass.AllClassList(sess.findFinal_Session());
var coscholastic_list = mstcoscholastic.AllCoScholasticList();
IEnumerable <SelectListItem> list = new SelectList(class_list, "class_id", "class_name");
IEnumerable <SelectListItem> list1 = new SelectList(coscholastic_list, "co_scholastic_id", "co_scholastic_name");
ViewData["class_id"] = list;
ViewData["coscholastic_id"] = list1;
ModelState.AddModelError(String.Empty, "Co-Scholastic area Already Assigned");
return(View(mst));
}
}
public ActionResult report_card(int section_id, int class_id, string session)
{
repReport_cardMain report_card = new repReport_cardMain();
report_card.pdfReportCard(class_id, section_id, session);
mst_classMain mstClass = new mst_classMain();
bool flag;
if (User.IsInRole("superadmin") || User.IsInRole("principal"))
{
flag = true;
}
else
{
flag = false;
}
var class_list = mstClass.AllClassListByTeacher(Int32.Parse(Request.Cookies["loginUserId"].Value.ToString()), flag);
IEnumerable <SelectListItem> list = new SelectList(class_list, "class_id", "class_name");
ViewData["class_id"] = list;
DDsession_name();
return(View());
}
public ActionResult AddClassDiscipline(mst_class_discipline mst)
{
try
{
mst_class_disciplineMain main = new mst_class_disciplineMain();
main.AddClassDiscipline(mst);
return(RedirectToAction("AllClassDisciplineList"));
}
catch
{
mst_classMain mstClass = new mst_classMain();
mst_disciplineMain mstdescipline = new mst_disciplineMain();
mst_sessionMain sess = new mst_sessionMain();
var class_list = mstClass.AllClassList(sess.findFinal_Session());
var discipline_list = mstdescipline.AllDisciplineList();
IEnumerable <SelectListItem> list = new SelectList(class_list, "class_id", "class_name");
IEnumerable <SelectListItem> list1 = new SelectList(discipline_list, "discipline_id", "discipline_name");
ViewData["class_id"] = list;
ViewData["discipline_id"] = list1;
ModelState.AddModelError(String.Empty, "Discipline Area Already Assigned");
return(View(mst));
}
}
public async Task <ActionResult> AddRegistration(std_registration mst)
{
std_registrationMain mstMain = new std_registrationMain();
mst.reg_date = System.DateTime.Now.AddMinutes(dateTimeOffSet);
if (mst.std_contact == null)
{
ModelState.AddModelError(String.Empty, "Primary contact is mandatory.");
mst_classMain mstClass = new mst_classMain();
mst_sessionMain sess = new mst_sessionMain();
var class_list = mstClass.AllClassList(sess.findActive_Session());
IEnumerable <SelectListItem> list1 = new SelectList(class_list, "class_id", "class_name");
ViewData["class_id"] = list1;
return(View(mst));
}
await mstMain.AddRegistration(mst);
return(RedirectToAction("AllRegistrationList"));
}
public ActionResult AddClass(mst_class mst)
{
mst_classMain mstMain = new mst_classMain();
mstMain.AddClass(mst);
return(RedirectToAction("AllClassList"));
}
public ActionResult EditClass(mst_class mst)
{
mst_classMain stdMain = new mst_classMain();
stdMain.EditClass(mst);
return(RedirectToAction("AllClassList"));
}
public ActionResult AllClassList()
{
mst_classMain stdMain = new mst_classMain();
mst_sessionMain sess = new mst_sessionMain();
return(View(stdMain.AllClassList(sess.findActive_Session())));
}
public void DDclass_name(string session)
{
mst_classMain mstClass = new mst_classMain();
var class_list = mstClass.AllClassListWithSection(session);
IEnumerable <SelectListItem> list1 = new SelectList(class_list, "class_id", "class_name");
ViewData["class_id"] = list1;
}
public ActionResult AddFees(mst_fees mst)
{
try
{
using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
string query = "select session_finalize from mst_session where session_active = 'Y'";
string id1 = con.ExecuteScalar <string>(query);
if (id1 == "Y")
{
mst_classMain mstClass = new mst_classMain();
mst_feesMain mstfess = new mst_feesMain();
mst_sessionMain sess = new mst_sessionMain();
var class_list = mstClass.AllClassList(sess.findActive_Session());
var acc_head = mstfess.account_head();
IEnumerable <SelectListItem> list = new SelectList(class_list, "class_id", "class_name");
IEnumerable <SelectListItem> list1 = new SelectList(acc_head, "acc_id", "acc_name");
ViewData["class_id"] = list;
ViewData["acc_id"] = list1;
ModelState.AddModelError(String.Empty, "Session is already finalized cannot add new fees.");
return(View(mst));
}
else
{
mst_feesMain mstMain = new mst_feesMain();
mstMain.AddFees(mst);
return(RedirectToAction("AllFeesList"));
}
}
}
catch (Exception ex)
{
mst_classMain mstClass = new mst_classMain();
mst_sessionMain sess = new mst_sessionMain();
var class_list = mstClass.AllClassList(sess.findActive_Session());
IEnumerable <SelectListItem> list = new SelectList(class_list, "class_id", "class_name");
ViewData["class_id"] = list;
ModelState.AddModelError(String.Empty, "Section Already Created");
return(View(mst));
}
}
public void DDclass_name(std_registration obj)
{
mst_classMain mstClass = new mst_classMain();
mst_sessionMain sess = new mst_sessionMain();
var class_list = mstClass.AllClassList(sess.findActive_Session());
IEnumerable <SelectListItem> list1 = new SelectList(class_list, "class_id", "class_name", obj.std_class_id);
ViewData["class_id"] = list1;
}
public void DDclass_name()
{
mst_classMain mstClass = new mst_classMain();
mst_sessionMain sess = new mst_sessionMain();
var class_list = mstClass.AllClassList(sess.findFinal_Session());
IEnumerable <SelectListItem> list1 = new SelectList(class_list, "class_id", "class_name");
ViewData["class_id"] = list1;
}
public ActionResult AddRegistration()
{
mst_classMain mstClass = new mst_classMain();
mst_sessionMain sess = new mst_sessionMain();
var class_list = mstClass.AllClassList(sess.findActive_Session());
IEnumerable <SelectListItem> list1 = new SelectList(class_list, "class_id", "class_name");
ViewData["class_id"] = list1;
return(View());
}
public ActionResult DeleteClass(int id, FormCollection collection)
{
try
{
mst_classMain stdMain = new mst_classMain();
stdMain.DeleteClass(id);
return(RedirectToAction("AllClassList"));
}
catch (Exception ex)
{
ModelState.AddModelError(String.Empty, "Sections are created cannot delete");
return(RedirectToAction("AllClassList"));
}
}
public void DDclass_name(sr_register obj)
{
mst_classMain mstClass = new mst_classMain();
mst_sessionMain sess = new mst_sessionMain();
var class_list = mstClass.AllClassList(sess.findFinal_Session());
var adm_class_list = mstClass.AllClassList(obj.adm_session);
IEnumerable <SelectListItem> list1 = new SelectList(class_list, "class_id", "class_name", obj.class_id);
IEnumerable <SelectListItem> list = new SelectList(adm_class_list, "class_name", "class_name");
ViewData["class_id"] = list1;
ViewData["class_name"] = list;
}
public ActionResult AddClassCoScholastic()
{
mst_classMain mstClass = new mst_classMain();
mst_co_scholasticMain mstcoscholastic = new mst_co_scholasticMain();
mst_sessionMain sess = new mst_sessionMain();
var class_list = mstClass.AllClassList(sess.findFinal_Session());
var coscholastic_list = mstcoscholastic.AllCoScholasticList();
IEnumerable <SelectListItem> list = new SelectList(class_list, "class_id", "class_name");
IEnumerable <SelectListItem> list1 = new SelectList(coscholastic_list, "co_scholastic_id", "co_scholastic_name");
ViewData["class_id"] = list;
ViewData["coscholastic_id"] = list1;
return(View());
}
public ActionResult AddFees()
{
mst_classMain mstClass = new mst_classMain();
mst_feesMain mstfess = new mst_feesMain();
mst_sessionMain sess = new mst_sessionMain();
var class_list = mstClass.AllClassList(sess.findActive_Session());
var acc_head = mstfess.account_head();
IEnumerable <SelectListItem> list = new SelectList(class_list, "class_id", "class_name");
IEnumerable <SelectListItem> list1 = new SelectList(acc_head, "acc_id", "acc_name");
ViewData["class_id"] = list;
ViewData["acc_id"] = list1;
return(View());
}
public ActionResult AddClassDiscipline()
{
mst_classMain mstClass = new mst_classMain();
mst_disciplineMain mstdiscipline = new mst_disciplineMain();
mst_sessionMain sess = new mst_sessionMain();
var class_list = mstClass.AllClassList(sess.findFinal_Session());
var discipline_list = mstdiscipline.AllDisciplineList();
IEnumerable <SelectListItem> list = new SelectList(class_list, "class_id", "class_name");
IEnumerable <SelectListItem> list1 = new SelectList(discipline_list, "discipline_id", "discipline_name");
ViewData["class_id"] = list;
ViewData["discipline_id"] = list1;
return(View());
}
public ActionResult AddExamClass()
{
mst_classMain mstClass = new mst_classMain();
mst_examMain mstsubject = new mst_examMain();
mst_sessionMain sess = new mst_sessionMain();
var class_list = mstClass.AllClassList(sess.findFinal_Session());
var exam_list = mstsubject.AllExamList();
IEnumerable <SelectListItem> list = new SelectList(class_list, "class_id", "class_name");
IEnumerable <SelectListItem> list1 = new SelectList(exam_list, "exam_id", "exam_name");
ViewData["class_id"] = list;
ViewData["exam_id"] = list1;
return(View());
}
public ActionResult AddTermRules()
{
mst_classMain mstClass = new mst_classMain();
mst_termMain mstterm = new mst_termMain();
var term_list = mstterm.AllTermList();
mst_sessionMain sess = new mst_sessionMain();
var class_list = mstClass.AllClassList(sess.findFinal_Session());
IEnumerable <SelectListItem> list = new SelectList(class_list, "class_id", "class_name");
IEnumerable <SelectListItem> list1 = new SelectList(term_list, "term_id", "term_name");
ViewData["class_id"] = list;
ViewData["term_id"] = list1;
return(View());
}
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 ActionResult AddSubjectTeacher()
{
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;
return(View());
}
public ActionResult AddClassSubject()
{
mst_classMain mstClass = new mst_classMain();
mst_subjectMain mstsubject = new mst_subjectMain();
mst_sessionMain sess = new mst_sessionMain();
var class_list = mstClass.AllClassList(sess.findFinal_Session());
var subject_list = mstsubject.AllSubjectList();
IEnumerable <SelectListItem> list = new SelectList(class_list, "class_id", "class_name");
IEnumerable <SelectListItem> list1 = new SelectList(subject_list, "subject_id", "subject_name");
ViewData["class_id"] = list;
ViewData["subject_id"] = list1;
return(View());
}
public ActionResult studentList(teacher_exam_remark mst)
{
if (mst.term_id == 0 || mst.section_id == 0)
{
ModelState.AddModelError(String.Empty, "Check for required field.");
mst_classMain mstClass = new mst_classMain();
bool flag;
if (User.IsInRole("superadmin") || User.IsInRole("principal"))
{
flag = true;
}
else
{
flag = false;
}
var class_list = mstClass.AllClassListByTeacher(Int32.Parse(Request.Cookies["loginUserId"].Value.ToString()), flag);
IEnumerable <SelectListItem> list3 = new SelectList(class_list, "class_id", "class_name");
ViewData["class_id"] = list3;
mst_termMain mst_term = new mst_termMain();
var term_list = mst_term.AllTermList();
IEnumerable <SelectListItem> list1 = new SelectList(term_list, "term_id", "term_name");
ViewData["term_id"] = list1;
return(View("AddRemarks"));
}
teacher_exam_remarkMain main = new teacher_exam_remarkMain();
List <teacher_exam_remark> list = new List <teacher_exam_remark>();
IEnumerable <teacher_exam_remark> remark;
remark = main.FindRemarks(mst.class_id, mst.section_id, mst.term_id);
if (remark.Count() > 0)
{
foreach (var i in remark)
{
list.Add(new teacher_exam_remark {
remark = i.remark, class_id = i.class_id, term_id = mst.term_id, section_id = i.section_id, roll_no = i.roll_no, sr_number = i.sr_number, std_name = i.std_name, user_id = Int32.Parse(Request.Cookies["loginUserId"].Value.ToString())
});
}
}
else
{
var std_list = main.student_list_for_remark(mst.class_id, mst.section_id);
foreach (var i in std_list)
{
list.Add(new teacher_exam_remark {
class_id = i.class_id, term_id = mst.term_id, section_id = i.section_id, roll_no = i.roll_no, sr_number = i.sr_number, std_name = i.std_name, user_id = Int32.Parse(Request.Cookies["loginUserId"].Value.ToString())
});
}
}
return(View(list));
}
public ActionResult DeleteClass(int id)
{
mst_classMain stdMain = new mst_classMain();
return(View(stdMain.FindClass(id)));
}
