public bool SaveData(CourseList course) { cmd = new SqlCommand("insert into CourseDetail values (@cid,@cname,@cmarks)", con); cmd.Parameters.AddWithValue("@cid", course.CourseId); cmd.Parameters.AddWithValue("@cname", course.CourseName); cmd.Parameters.AddWithValue("@cmarks", course.CourseMarks); con.Open(); cmd.ExecuteNonQuery(); con.Close(); return true; }
public List<CourseList> GetCourseList() { List<CourseList> c = new List<CourseList>(); cmd = new SqlCommand("select * from courseDetail", con); con.Open(); dr = cmd.ExecuteReader(); while (dr.Read()) { CourseList course = new CourseList(); course.CourseId = dr.GetValue(0).ToString(); course.CourseName = dr.GetValue(1).ToString(); course.CourseMarks = int.Parse(dr.GetValue(2).ToString()); c.Add(course); } con.Close(); return c; }
public ActionResult ShowAll(FormCollection c) { CourseListModel obmodel = new CourseListModel(); obmodel.CourseListCollection = GetCourseList();////goTo method if (c["add"] != null) { ViewBag.Addmsg = "Yes"; return View(obmodel); } if (c["save"] != null) { CourseList cl = new CourseList(); cl.CourseId = c["cid1"].ToString().Substring(0,c["cid1"].ToString().Length-1); cl.CourseName = c["cname1"].ToString().Substring(0,c["cname1"].ToString().Length-1); cl.CourseMarks = int.Parse(c["cmarks1"].ToString()); if (SaveData(cl)) TempData["Msg"] = "Info added.."; else TempData["Msg"] = "Error"; return RedirectToAction("ShowAll","CourseDetails"); } if (c["show"] != null) { ViewBag.Addmsg1 = "ok"; return View(obmodel); } else if (c["Update"] != null) { string cid = c["cid1"].ToString(); string cname = c["cname1"].ToString(); int cmks = int.Parse(c["cmarks"].ToString()); if (UpdateMarks(cid, cname, cmks)) //ViewBag.Msg = "Updated CourseInfo"; TempData["Msg"] = "Info added.."; else ViewBag.Msg = "Not Updatted"; return RedirectToAction("ShowAll", "CourseDetails"); } else if (c["Remove"] != null) { string idd = c["cid1"].ToString(); if (DeleteCourse(idd)) ViewBag.Msg = "Deleted Course"; else ViewBag.Msg = "Not Deleted"; return RedirectToAction("ShowAll", "CourseDetails"); } return View(obmodel); }
public CourseList ShowData(string cid) { CourseList cl = new CourseList(); cmd = new SqlCommand("Select * from CourseDetail where courseId=@cid", con); cmd.Parameters.AddWithValue("@cid", cid); con.Open(); dr = cmd.ExecuteReader(); if (dr.Read()) { cl.CourseId = dr.GetValue(0).ToString(); cl.CourseName = dr.GetValue(1).ToString(); cl.CourseMarks = int.Parse(dr.GetValue(2).ToString()); } con.Close(); return cl; }
public bool SaveMarks(MarksInputList mi) { CourseList obmodel = new CourseList(); cmd = new SqlCommand("insert into MarksTb (InputMarks,id,courseid) values (@cmarks,@id,@cid) ", con); cmd.Parameters.AddWithValue("@cmarks", mi.MarksInput); cmd.Parameters.AddWithValue("@cid", mi.CourseId); cmd.Parameters.AddWithValue("@id", mi.StId); con.Open(); cmd.ExecuteNonQuery(); con.Close(); return true; }