public ActionResult AddSbjctsTtlMrks(AllClasses Add)
{
if (Session["Username"] == null && Session["Password"] == null)
{
return(RedirectToAction("Index", "Admin", new { area = "" }));
}
else
{
if (ModelState.IsValid)
{
SubjectsTotalMarks addsubjectsmarks = new SubjectsTotalMarks();
addsubjectsmarks.Subject_id = Add.SubjectsTotalMarks_.Subject_id;
addsubjectsmarks.Total_marks = Add.SubjectsTotalMarks_.Total_marks;
addsubjectsmarks.R_id = Add.SubjectsTotalMarks_.R_id;
addsubjectsmarks.Class_id = Add.SubjectsTotalMarks_.Class_id;
addsubjectsmarks.Date = DateTime.Today.ToString("dd-MM-yyyy");
addsubjectsmarks.Month = DateTime.Today.ToString("MMM");
addsubjectsmarks.Year = DateTime.Today.ToString("yyyy");
addsubjectsmarks.Time = DateTime.Now.ToString("HH:mm:ss");
new Cateloge().AddSubjectsTotalMarks(addsubjectsmarks);
TempData["Msg"] = "New Subject Total Marks Have Added Successfully";
}
return(RedirectToAction("allsbjctsttlmrks", new { id = Add.SubjectsTotalMarks_.R_id }));
}
}
private List <SubjectsTotalMarks> fetchSubjectsTotalMarks(SqlCommand cmd)
{
SqlConnection con = cmd.Connection;
List <SubjectsTotalMarks> subjectstotalmarks = null;
con.Open();
using (con)
{
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
subjectstotalmarks = new List <SubjectsTotalMarks>();
while (dr.Read())
{
SubjectsTotalMarks sr = new SubjectsTotalMarks();
sr.Id = Convert.ToString(dr["id"]);
sr.Class_id = Convert.ToString(dr["class_id"]);
sr.R_id = Convert.ToString(dr["sub_r_id"]);
sr.Subject_id = Convert.ToString(dr["subject_id"]);
sr.Subject_name = new SubjectsDAL().SelectById(Convert.ToInt32(dr["subject_id"]));
sr.Total_marks = Convert.ToDouble(dr["total_marks"]);
subjectstotalmarks.Add(sr);
}
subjectstotalmarks.TrimExcess();
}
}
return(subjectstotalmarks);
}
public void AddSubjectsTotalMarksForResult(SubjectsTotalMarks r)
{
SqlCommand cmd = new SqlCommand("INSERT into rslt_sbjcts_ttl_mrks (class_id,sub_r_id,subject_id,total_marks,date,month,year,time) VALUES (@Class_id,@R_id,@Subject_id,@Total_marks,@Date,@Month,@Year,@Time)", DALUtil.getConnection());
cmd.Parameters.AddWithValue("@Subject_id", (r.Subject_id == null) ? Convert.DBNull : r.Subject_id);
cmd.Parameters.AddWithValue("@Class_id", (r.Class_id == null) ? Convert.DBNull : r.Class_id);
cmd.Parameters.AddWithValue("@R_id", (r.R_id == null) ? Convert.DBNull : r.R_id);
cmd.Parameters.AddWithValue("@Total_marks", r.Total_marks);
cmd.Parameters.AddWithValue("@Date", (r.Date == null) ? Convert.DBNull : r.Date);
cmd.Parameters.AddWithValue("@Month", (r.Month == null) ? Convert.DBNull : r.Month);
cmd.Parameters.AddWithValue("@Year", (r.Year == null) ? Convert.DBNull : r.Year);
cmd.Parameters.AddWithValue("@Time", (r.Time == null) ? Convert.DBNull : r.Time);
addresult(cmd);
}
public ActionResult EditSbjctsTtlMrks(List <SubjectTotalMark> p)
{
if (Session["Username"] == null && Session["Password"] == null)
{
return(RedirectToAction("Index", "Admin", new { area = "" }));
}
else
{
if (ModelState.IsValid)
{
List <SubjectsTotalMarks> updatesubjectsmarks = new List <SubjectsTotalMarks>();
foreach (SubjectTotalMark pdr in p)
{
SubjectsTotalMarks dbr = new SubjectsTotalMarks();
dbr.Id = pdr.Id;
dbr.Total_marks = pdr.Total_marks;
updatesubjectsmarks.Add(dbr);
}
new Cateloge().UpdateSubjectsTotalMarks(updatesubjectsmarks);
TempData["Msg"] = "Subjects Total Marks Have Updated Successfully";
}
return(RedirectToAction("allsbjctsttlmrks", new { id = p[0].R_id }));
}
}
public void AddSubjectsTotalMarks(SubjectsTotalMarks stm)
{
new AddAndUpdtResultDAL().AddSubjectsTotalMarksForResult(stm);
}
