public ActionResult PublishSubResult(Sub_Result Update, int id) { if (Session["Username"] == null && Session["Password"] == null) { return(RedirectToAction("Index", "Admin", new { area = "" })); } else { if (ModelState.IsValid) { Sub_Results SubResult = new Sub_Results(); SubResult.Publish = Update.Publish; new Cateloge().PublishSubResults(SubResult, id); if (Update.Publish == "2") { TempData["Msg"] = "Sub Result Have Published Successfully"; } else { TempData["Msg"] = "Sub Result Have Blocked Successfully"; } return(RedirectToAction("View", new { id = id })); } return(RedirectToAction("Index")); } }
public ActionResult AddResultPosition(int id) { if (Session["Username"] == null && Session["Password"] == null) { return(RedirectToAction("Index", "Admin", new { area = "" })); } else { List <Sub_Results> sub_results = new Cateloge().SelectAllSubResults(); AllClasses Data = new AllClasses(); Data.Sub_Result_s = new List <Sub_Result>(); if (sub_results == null) { ViewBag.StatusMessage = " No Any Result Founded ! "; } else { foreach (var gdfc in sub_results) { Sub_Result dbr = new Sub_Result(); dbr.id = gdfc.id; dbr.name = gdfc.name; Data.Sub_Result_s.Add(dbr); } return(PartialView("_ResultPositionForm", Data)); } return(RedirectToAction("Index")); } }
public ActionResult View(int id) { if (Session["Username"] == null && Session["Password"] == null) { return(RedirectToAction("Index", "Admin", new { area = "" })); } else { List <Sub_Results> sub_results = new Cateloge().SelectSubResults(id); Results result = new Cateloge().SelectResults(id); if (result == null) { ViewBag.StatusMessage = " No Any Result Founded ! "; } else { AllClasses Data = new AllClasses(); Data.Sub_Result_s = new List <Sub_Result>(); if (sub_results == null) { ViewBag.StatusMessage = " No Any Result Founded ! "; } else { foreach (var gdfc in sub_results) { Sub_Result dbr = new Sub_Result(); dbr.id = gdfc.id; dbr.name = gdfc.name; dbr.Publish = gdfc.Publish; Data.Sub_Result_s.Add(dbr); } } Data.Result = new Result { Id = result.db_Id, Name = result.Session_year }; TempData["p"] = "Published On Web"; TempData["b"] = "Blocked On Web"; return(View(Data)); } return(RedirectToAction("Index")); } }
public ActionResult SubResults(Sub_Result Add, int id) { if (Session["Username"] == null && Session["Password"] == null) { return(RedirectToAction("Index", "Admin", new { area = "" })); } else { if (ModelState.IsValid) { Sub_Results AddSubResult = new Sub_Results(); AddSubResult.name = Add.name; AddSubResult.Date = DateTime.Today.ToString("dd-MM-yyyy"); AddSubResult.Month = DateTime.Today.ToString("MMM"); AddSubResult.Year = DateTime.Today.ToString("yyyy"); AddSubResult.Time = DateTime.Now.ToString("HH:mm:ss"); new Cateloge().AddSubResult(AddSubResult, id); TempData["Msg"] = "New Sub Result Have Added Successfully"; return(RedirectToAction("View", new { id = id })); } return(RedirectToAction("Index")); } }
public ActionResult Results() { List <Sub_Results> ResultsForWeb = new Cateloge().SelectAllSubResultsForWeb(); if (ResultsForWeb == null) { TempData["Message"] = "No Any Result Published !"; } else { WebAllClass Data = new WebAllClass(); Data.Sub_Result_s = new List <Sub_Result>(); foreach (var gdfc in ResultsForWeb) { Sub_Result dbr = new Sub_Result(); dbr.id = gdfc.id; dbr.name = gdfc.name; Data.Sub_Result_s.Add(dbr); } return(View(Data)); } return(View()); }
public ActionResult ViewSub(int?id, int?zid) { if (Session["Username"] == null && Session["Password"] == null) { return(RedirectToAction("Index", "Admin", new { area = "" })); } else { AllClasses Data = new AllClasses(); if (!id.HasValue) { return(RedirectToAction("Index")); } else { Sub_Results ResultForPanel = new Cateloge().SelectSubResult(id); if (ResultForPanel == null) { return(RedirectToAction("Index")); } else { Data.Sub_Result = new Sub_Result { id = ResultForPanel.id, name = ResultForPanel.name }; if (!zid.HasValue) { TempData["Message"] = "Please Enter A Valid Registration Number Of Student !"; } else { Students SelectforPanel = new Cateloge().SelectStudentForPanel(Convert.ToInt32(zid)); if (SelectforPanel == null) { TempData["Message"] = "No Any Student Founded Against This Regsitration Number !"; } else { List <SubjectResults> SelectSubjectsResultForWeb = new Cateloge().SelectAllSubjectsResultForWeb(Convert.ToInt32(SelectforPanel.db_Id), id); ResultsPositions SelectResultPosition = new Cateloge().SelectResultPositionByRidSid(Convert.ToInt32(SelectforPanel.db_Id), id); Data.Student = new Student { Aplicnt_Id = SelectforPanel.Aplicnt_Id, Aplicnt_name = SelectforPanel.Aplicnt_name, Aplicnt_f_name = SelectforPanel.Aplicnt_f_name, ClassName = SelectforPanel.ClassName.Name }; if (SelectSubjectsResultForWeb == null) { TempData["Message"] = "No Any Result Founded Against This Regsitration Number !"; } else { Data.SubjectResult_s = new List <SubjectResult>(); Data.SubjectResult_s_ = new List <SubjectResult>(); foreach (var gdfc in SelectSubjectsResultForWeb) { SubjectResult dbr = new SubjectResult(); dbr.Subject_name = gdfc.Subject_name.Name; dbr.Total_marks = gdfc.Total_marks.Total_marks; dbr.Obtn_marks = gdfc.Obtn_marks; dbr.Status = gdfc.Status; Data.SubjectResult_s.Add(dbr); } if (SelectResultPosition == null) { //TempData["Message"] = "The Student Position By Section Of This Result Not Posted Yet !"; } else { Data.Result_Position = new ResultPosition { Id = SelectResultPosition.Id, Class_Section = SelectResultPosition.Class_Section, Obtn_Pstn = SelectResultPosition.Obtn_Pstn }; } List <Sub_Results> SelectAllSubResults = new Cateloge().SelectSubResultsWithDetail(Convert.ToInt32(ResultForPanel.S_id.db_Id), Convert.ToInt32(SelectforPanel.db_Id)); //List<Sub_Results> SelectAllSubResults = new Cateloge().SelectSubResultsWithDetail(Convert.ToInt32(1), Convert.ToInt32(1)); if (SelectAllSubResults == null) { TempData["Message"] = " Overall Report Is Empty !"; } else { Data.Sub_Result_s = new List <Sub_Result>(); Data.SubjectResult_s_ = new List <SubjectResult>(); //Data.Sub_Result_s = new List<Sub_Result>(); foreach (var gdfc in SelectAllSubResults) { Sub_Result dbr = new Sub_Result(); dbr.id = gdfc.id; dbr.name = gdfc.name; dbr.Percentage = gdfc.Percentage; if (gdfc.S_r == null) { ViewBag.StatusMessage = " No Any Result Founded ! "; } else { foreach (var llgdfc in gdfc.S_r.Where(a => a.Sub_r_id.Equals(dbr.id))) { } foreach (var lgdfc in gdfc.S_r) { //SubjectResult ldbr = new SubjectResult(); //ldbr.Id = lgdfc.Id; //ldbr.Obtn_marks = lgdfc.Obtn_marks; //ldbr.Total_marks = lgdfc.Total_marks; //ldbr.Status = lgdfc.Status; //Data.SubjectResult_s_.Add(ldbr); //dbr.S_r.Add(ldbr); SubjectResult ldbr = new SubjectResult(); ldbr.Sub_r_id = lgdfc.Sub_r_id; ldbr.Obtn_marks = lgdfc.Obtn_marks; //ldbr.Total_marks = lgdfc.Total_marks; Data.SubjectResult_s_.Add(ldbr); } } Data.Sub_Result_s.Add(dbr); } } } } } } return(View(Data)); } } }
public ActionResult ViewResult(int?id, int?zid) { WebAllClass Data = new WebAllClass(); if (!id.HasValue) { return(RedirectToAction("Index")); } else { Sub_Results ResultForWeb = new Cateloge().SelectAllSubResultForWeb(id); if (ResultForWeb == null) { return(RedirectToAction("Index")); } else { Data.Sub_Result = new Sub_Result { id = ResultForWeb.id, name = ResultForWeb.name }; if (!zid.HasValue) { TempData["Message"] = "Please Enter A Valid Registration Number Of Student !"; } else { Students SelectforWeb = new Cateloge().SelectAllStudentForWeb(Convert.ToInt32(zid)); if (SelectforWeb == null) { TempData["Message"] = "No Any Student Founded Against This Regsitration Number !"; } else { List <SubjectResults> SelectSubjectsResultForWeb = new Cateloge().SelectAllSubjectsResultForWeb(Convert.ToInt32(SelectforWeb.db_Id), id); Data.Student = new Student { Aplicnt_Id = SelectforWeb.Aplicnt_Id, Aplicnt_name = SelectforWeb.Aplicnt_name, Aplicnt_f_name = SelectforWeb.Aplicnt_f_name, ClassName = SelectforWeb.ClassName.Name }; if (SelectSubjectsResultForWeb == null) { TempData["Message"] = "No Any Result Founded Against This Regsitration Number !"; } else { Data.SubjectResult_s = new List <SubjectResult>(); foreach (var gdfc in SelectSubjectsResultForWeb) { SubjectResult dbr = new SubjectResult(); dbr.Subject_name = gdfc.Subject_name.Name; dbr.Total_marks = gdfc.Total_marks.Total_marks; dbr.Obtn_marks = gdfc.Obtn_marks; dbr.Status = gdfc.Status; Data.SubjectResult_s.Add(dbr); } List <Sub_Results> SelectAllSubResultsForWeb = new Cateloge().SelectSubResultsWithDetailForWeb(Convert.ToInt32(ResultForWeb.S_id.db_Id), Convert.ToInt32(SelectforWeb.db_Id)); if (SelectAllSubResultsForWeb == null) { TempData["Message"] = " Overall Report Is Empty !"; } else { Data.Sub_Result_s = new List <Sub_Result>(); Data.SubjectResult_s_ = new List <SubjectResult>(); foreach (var gdfc in SelectAllSubResultsForWeb) { Sub_Result dbr = new Sub_Result(); dbr.id = gdfc.id; dbr.name = gdfc.name; dbr.Percentage = gdfc.Percentage; if (gdfc.S_r == null) { } else { foreach (var lgdfc in gdfc.S_r) { SubjectResult ldbr = new SubjectResult(); ldbr.Sub_r_id = lgdfc.Sub_r_id; ldbr.Obtn_marks = lgdfc.Obtn_marks; //ldbr.Total_marks = lgdfc.Total_marks; Data.SubjectResult_s_.Add(ldbr); } } Data.Sub_Result_s.Add(dbr); } } } } } } return(View(Data)); } }
public ActionResult View(int id) { if (Session["Username"] == null && Session["Password"] == null) { return(RedirectToAction("Index", "Admin", new { area = "" })); } else { Students Student_s = new Cateloge().SelectStudent(id); List <Sub_Results> subresultstitle = new Cateloge().SelectSubResultsTitles(); List <SubjectResults> subjectresults = new Cateloge().SelectStudentResultById(id); if (Student_s == null) { ViewBag.StatusMessage = " No Any Result Founded ! "; } else { AllClasses Data = new AllClasses(); Data.Sub_Result_s = new List <Sub_Result>(); Data.SubjectResult_s = new List <SubjectResult>(); if (subresultstitle == null) { TempData["NoData"] = " No Any Result Founded ! "; } else { foreach (var gdfc in subresultstitle) { Sub_Result dbr = new Sub_Result(); dbr.id = gdfc.id; dbr.name = gdfc.name; //if (subjectresults.Where(a => a.Sub_r_id.Equals(gdfc.id)).Count() > 0) // { // TempData["msg_"] = "Not Null"; // } // else // { // TempData["msg_"] = null; //} Data.Sub_Result_s.Add(dbr); } } if (subjectresults == null) { TempData["NoData"] = " No Any Result Founded ! "; } else { foreach (var gdfc in subjectresults) { SubjectResult dbr = new SubjectResult(); dbr.Sub_r_id = gdfc.Sub_r_id; Data.SubjectResult_s.Add(dbr); } } Data.Student = new Student { db_Id = Student_s.db_Id, Aplicnt_Id = Student_s.Aplicnt_Id, Aplicnt_name = Student_s.Aplicnt_name, Aplicnt_nnlty = Student_s.Aplicnt_nnlty, Aplicnt_c_grade = Student_s.Aplicnt_c_grade, Aplicnt_dob = Student_s.Aplicnt_dob, Aplicnt_pob = Student_s.Aplicnt_pob, Aplicnt_gender = Student_s.Aplicnt_gender, Aplicnt_c_addr = Student_s.Aplicnt_c_addr, Aplicnt_p_addr = Student_s.Aplicnt_p_addr, Aplicnt_h_phone = Student_s.Aplicnt_h_phone, Aplicnt_pp_photo = Student_s.Aplicnt_pp_photo, Aplicnt_emrgncy_p_name = Student_s.Aplicnt_emrgncy_p_name, Aplicnt_emrgncy_p_rltn = Student_s.Aplicnt_emrgncy_p_rltn, Aplicnt_emrgncy_p_cell = Student_s.Aplicnt_emrgncy_p_cell, Aplicnt_emrgncy_p_ldln = Student_s.Aplicnt_emrgncy_p_ldln, Aplicnt_emrgncy_p_addr = Student_s.Aplicnt_emrgncy_p_addr, Aplicnt_emrgncy_p_email = Student_s.Aplicnt_emrgncy_p_email, Aplicnt_f_name = Student_s.Aplicnt_f_name, Aplicnt_f_ocptn = Student_s.Aplicnt_f_ocptn, Aplicnt_f_title = Student_s.Aplicnt_f_title, Aplicnt_f_cell = Student_s.Aplicnt_f_cell, Aplicnt_f_bsns_name = Student_s.Aplicnt_f_bsns_name, Aplicnt_f_bsns_addr = Student_s.Aplicnt_f_bsns_addr, Aplicnt_f_email = Student_s.Aplicnt_f_email, Aplicnt_f_phone = Student_s.Aplicnt_f_phone, Aplicnt_m_name = Student_s.Aplicnt_m_name, Aplicnt_m_cell = Student_s.Aplicnt_m_cell, Aplicnt_m_ldln = Student_s.Aplicnt_m_ldln, Aplicnt_b_one_name = Student_s.Aplicnt_b_one_name, Aplicnt_b_one_grade = Student_s.Aplicnt_b_one_grade, Aplicnt_b_two_name = Student_s.Aplicnt_b_two_name, Aplicnt_b_two_grade = Student_s.Aplicnt_b_two_grade, Aplicnt_b_thr_name = Student_s.Aplicnt_b_thr_name, Aplicnt_b_thr_grade = Student_s.Aplicnt_b_thr_grade, Aplicnt_b_fou_name = Student_s.Aplicnt_b_fou_name, Aplicnt_b_fou_grade = Student_s.Aplicnt_b_fou_grade, Aplicnt_b_prsnt_schl = Student_s.Aplicnt_b_prsnt_schl, Aplicnt_b_date_atdnc = Student_s.Aplicnt_b_date_atdnc, Aplicnt_b_lng_ins = Student_s.Aplicnt_b_lng_ins, Aplicnt_p_schl_name_o = Student_s.Aplicnt_p_schl_name_o, Aplicnt_p_schl_strt_date_o = Student_s.Aplicnt_p_schl_strt_date_o, Aplicnt_p_schl_end_date_o = Student_s.Aplicnt_p_schl_end_date_o, Aplicnt_p_schl_name_t = Student_s.Aplicnt_p_schl_name_t, Aplicnt_p_schl_strt_date_t = Student_s.Aplicnt_p_schl_strt_date_t, Aplicnt_p_schl_end_date_t = Student_s.Aplicnt_p_schl_end_date_t, Aplicnt_phycl_emo_cndtn_ackwlg = Student_s.Aplicnt_phycl_emo_cndtn_ackwlg, Aplicnt_spcl_intrst_hobby = Student_s.Aplicnt_spcl_intrst_hobby, Source_of_acknwlge_abt_da = Student_s.Source_of_acknwlge_abt_da, Publish_result = Student_s.Publish_result, ClassName = (Student_s.ClassName != null) ? Student_s.ClassName.Name : null }; return(View(Data)); } return(RedirectToAction("Index")); } }