public ActionResult Index() { tbl_Case tbl_Case = new tbl_Case(); using (dbLawCMSEntities db = new dbLawCMSEntities()) { } return(View()); }
public ActionResult EditCase(CaseModelClass cmc) { JurisprudenceDBEntities _db = new JurisprudenceDBEntities(); tbl_Case tb = _db.tbl_Case.Single(u => u.CaseID == cmc.CaseID); tb.CaseName = cmc.CaseName; tb.CaseType = cmc.CaseType; tb.CaseDetails = cmc.CaseDetails; _db.SaveChanges(); return(View("Cases")); }
public ActionResult EditCase(int id) { JurisprudenceDBEntities _db = new JurisprudenceDBEntities(); tbl_Case tb = _db.tbl_Case.Single(u => u.CaseID == id); CaseModelClass cmc = new CaseModelClass(); cmc.CaseID = tb.CaseID; cmc.CaseName = tb.CaseName; cmc.CaseType = tb.CaseType; cmc.CaseDetails = tb.CaseDetails; return(View(cmc)); }
public ActionResult Assign(CaseModelClass cmc, FormCollection fc) { if (cmc.Lawyer == "Choose Lawyer") { ViewBag.Message = "Please select Lawyer"; } JurisprudenceDBEntities _db = new JurisprudenceDBEntities(); tbl_Case tb = _db.tbl_Case.Single(u => u.CaseID == cmc.CaseID); int lid = Int32.Parse(fc["Lawyer"]); tbl_Lawyer tbl = _db.tbl_Lawyer.Single(v => v.LawyerID == lid); tb.Lawyer = tbl.Name; _db.SaveChanges(); return(RedirectToAction("AssignCase")); }
public ActionResult AddCase(FormCollection fc) { JurisprudenceDBEntities _db = new JurisprudenceDBEntities(); var User = Session["Username"]; tbl_User tb = _db.tbl_User.Single(u => u.Email == User); tbl_Case tbl = new tbl_Case(); tbl.CaseName = fc["casename"]; tbl.CaseDetails = fc["casedetails"]; tbl.CaseType = fc["casetype"]; tbl.UserID = tb.UserID; _db.tbl_Case.Add(tbl); _db.SaveChanges(); return(RedirectToAction("ViewCase")); }
public ActionResult Assign(int id) { JurisprudenceDBEntities db = new JurisprudenceDBEntities(); tbl_Case tb = db.tbl_Case.Single(u => u.CaseID == id); CaseModelClass cmc = new CaseModelClass(); cmc.CaseName = tb.CaseName; cmc.CaseID = tb.CaseID; cmc.CaseType = tb.CaseType; cmc.CaseDetails = tb.CaseDetails; cmc.Lawyer = tb.Lawyer; JurisprudenceDBEntities _db = new JurisprudenceDBEntities(); ViewBag.Lawyers = _db.tbl_Lawyer; return(View(cmc)); }