public ActionResult DeleteConfirmed(int id) { tb_MemberNotes tb_MemberNotes = db.tb_MemberNotes.Find(id); db.tb_MemberNotes.Remove(tb_MemberNotes); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "MemberNotesID,MemberID,Notes,NoteTypeID,NoteDate,TakenBy,AddedBy,AddedDateTime,ModifiedBy,ModifiedDateTime")] tb_MemberNotes tb_MemberNotes) { if (ModelState.IsValid) { db.Entry(tb_MemberNotes).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.NoteTypeID = new SelectList(db.tb_NoteType, "NoteTypeID", "NoteType", tb_MemberNotes.NoteTypeID); ViewBag.MemberID = new SelectList(db.tb_MemberMaster, "MemberID", "LastName", tb_MemberNotes.MemberID); return(View(tb_MemberNotes)); }
public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tb_MemberNotes tb_MemberNotes = db.tb_MemberNotes.Find(id); if (tb_MemberNotes == null) { return(HttpNotFound()); } return(View(tb_MemberNotes)); }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tb_MemberNotes tb_MemberNotes = db.tb_MemberNotes.Find(id); if (tb_MemberNotes == null) { return(HttpNotFound()); } ViewBag.NoteTypeID = new SelectList(db.tb_NoteType, "NoteTypeID", "NoteType", tb_MemberNotes.NoteTypeID); ViewBag.MemberID = new SelectList(db.tb_MemberMaster, "MemberID", "LastName", tb_MemberNotes.MemberID); return(View(tb_MemberNotes)); }
public ActionResult AddNote([Bind(Include = "_MemberID,_Note,_NoteDate,_NoteTypeID,_TakenBy")] AddNoteModel model) { Error error = new Error(); error.errCode = ErrorDetail.Success; error.errMsg = ErrorDetail.GetMsg(error.errCode); List <string> errs = new List <string>(); try { tb_MemberNotes memberNote = new tb_MemberNotes() { MemberID = model._MemberID, Notes = model._Note, NoteDate = model._NoteDate, NoteTypeID = model._NoteTypeID, TakenBy = model._TakenBy, AddedDateTime = DateTime.UtcNow }; db.tb_MemberNotes.Add(memberNote); model._NoteTypes = new SelectList(db.tb_NoteType, "NoteTypeID", "NoteType"); ViewBag._TakenBy = new SelectList(db.AspNetUsers.OrderBy(s => s.LastFirstName), "Id", "LastFirstName"); tb_MemberMaster fm = db.tb_MemberMaster.Find(model._MemberID); ViewBag.MemberName = fm.FirstName + " " + fm.LastName; model._MemberNotes = db.tb_MemberNotes.Where(t => t.MemberID == model._MemberID).ToList(); //before db.SaveChanges(); model._MemberNotes = db.tb_MemberNotes.Where(t => t.MemberID == model._MemberID).ToList(); //after } catch (Exception ex) { error.errCode = ErrorDetail.DataImportError; error.errMsg = ErrorDetail.GetMsg(error.errCode); errs.Add("Error #" + error.errCode.ToString() + "!" + error.errMsg + ". " + ex.Message); ViewData["ErrorList"] = errs; return(View(model)); } return(View(model)); }