private List <SubjectResults> fetchSubjectsResultTitle(SqlCommand cmd)
{
SqlConnection con = cmd.Connection;
List <SubjectResults> subjectresults = null;
con.Open();
using (con)
{
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
subjectresults = new List <SubjectResults>();
while (dr.Read())
{
SubjectResults sr = new SubjectResults();
sr.Id = Convert.ToString(dr["id"]);
sr.Sub_r_id = Convert.ToString(dr["sub_r_id"]);
sr.Student_id = Convert.ToString(dr["student_id"]);
sr.Subject_name = new SubjectsDAL().SelectById(Convert.ToInt32(dr["subject_id"]));
sr.Total_marks = new ResultsDAL().SelectSubjectTotalMarksWithIds(Convert.ToInt32(dr["subject_id"]), Convert.ToInt32(dr["sub_r_id"]));
sr.Obtn_marks = Convert.ToDouble(dr["obtain_marks"]);
sr.Status = Convert.ToInt32(dr["status"]);
subjectresults.Add(sr);
}
subjectresults.TrimExcess();
}
}
return(subjectresults);
}
public ActionResult UpdtSubjectsResult(List <SubjectResult> Add)
{
if (Session["Username"] == null && Session["Password"] == null)
{
return(RedirectToAction("Index", "Admin", new { area = "" }));
}
else
{
if (ModelState.IsValid)
{
List <SubjectResults> subjectsresult = new List <SubjectResults>();
foreach (SubjectResult gdfc in Add)
{
SubjectResults dbr = new SubjectResults();
dbr.Obtn_marks = gdfc.Obtn_marks;
dbr.Id = gdfc.Id;
dbr.Status = gdfc.Status;
subjectsresult.Add(dbr);
}
new Cateloge().UpdtSubjectsObtnMarks(subjectsresult);
TempData["Msg"] = "Subjects Result Have Updated Successfully";
return(RedirectToAction("View", new { id = Add[0].Student_id }));
}
return(RedirectToAction("Index"));
}
}
public ActionResult AddSubjectResult(List <SubjectResult> Add)
{
if (Session["Username"] == null && Session["Password"] == null)
{
return(RedirectToAction("Index", "Admin", new { area = "" }));
}
else
{
if (ModelState.IsValid)
{
List <SubjectResults> subjectsresult = new List <SubjectResults>();
foreach (SubjectResult gdfc in Add)
{
SubjectResults dbr = new SubjectResults();
dbr.Obtn_marks = gdfc.Obtn_marks;
dbr.Sub_r_id = gdfc.Sub_r_id;
dbr.Student_id = gdfc.Student_id;
dbr.Status = gdfc.Status;
dbr.Subject_id = gdfc.Subject_id;
dbr.Date = DateTime.Today.ToString("dd-MM-yyyy");
dbr.Month = DateTime.Today.ToString("MMM");
dbr.Year = DateTime.Today.ToString("yyyy");
dbr.Time = DateTime.Now.ToString("HH:mm:ss");
subjectsresult.Add(dbr);
}
new Cateloge().AddSubjectsObtnMarks(subjectsresult);
TempData["Msg"] = "New Subjects Result Have Added Successfully";
return(RedirectToAction("View", new { id = Add[0].Student_id }));
}
return(RedirectToAction("Index"));
}
}
private List <SubjectResults> fetchResultTitle(SqlCommand cmd)
{
SqlConnection con = cmd.Connection;
List <SubjectResults> subjectresults = null;
con.Open();
using (con)
{
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
subjectresults = new List <SubjectResults>();
while (dr.Read())
{
SubjectResults sr = new SubjectResults();
sr.Sub_r_id = Convert.ToString(dr["sub_r_id"]);
sr.Subresult = SelectResultTitleById(Convert.ToInt32(dr["sub_r_id"]));
subjectresults.Add(sr);
}
subjectresults.TrimExcess();
}
}
return(subjectresults);
}
