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"));
}
}
