public ActionResult Create(DCMNT_TBL docModel, FormCollection collection) { try { using (DMSDbEntities db = new DMSDbEntities()) { db.DCMNT_TBL.Add(docModel); db.SaveChanges(); return RedirectToAction("Index",db.DCMNT_TBL.ToList()); } } catch { return View(); } }
public ActionResult Edit(DCMNT_TBL docModel) { try { using (DMSDbEntities db = new DMSDbEntities()) { var entry = db.Entry<DCMNT_TBL>(docModel); if (entry.State.Equals(EntityState.Detached)) { db.DCMNT_TBL.Attach(docModel); } entry.State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index",db.DCMNT_TBL.ToList()); } } catch { return View(); } }
public ActionResult CreateScan(FormCollection fc, DCMNT_TBL dcmntTblModel) { if (ModelState.IsValid) { string path = dcmntTblModel.STRG_LOC.Replace(@"\", "_"); string[] parts = path.Split('_'); string[] name = parts[parts.Length - 1].Split('.'); try { using (DMSDbEntities db = new DMSDbEntities()) { dcmntTblModel.FILE_NME = name[0] + "." + name[1]; dcmntTblModel.USER_ID = Convert.ToInt32(Session["userid"]); dcmntTblModel.SCAN_DTE = DateTime.Now.Date.ToString().Split(' ')[0]; dcmntTblModel.SCAN_TME = DateTime.Now.TimeOfDay.ToString().Split('.')[0]; db.DCMNT_TBL.Add(dcmntTblModel); db.SaveChanges(); ViewBag.Message = "Saved successfully"; return RedirectToAction("DocumentScan"); } } catch { ModelState.AddModelError("", "Values not entered properly"); return View("DocumentScan", dcmntTblModel); } } else { ModelState.AddModelError("","Values not entered properly"); return View("DocumentScan", dcmntTblModel); } }
public ActionResult Delete(DCMNT_TBL docModel) { try { using (DMSDbEntities db = new DMSDbEntities()) { var entry = db.Entry<DCMNT_TBL>(docModel); entry.State=EntityState.Deleted; db.DCMNT_TBL.ToList().RemoveAll(p => p.DCMT_ID == docModel.DCMT_ID); db.SaveChanges(); return RedirectToAction("Index",db.DCMNT_TBL.ToList()); } } catch { return View(); } }