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