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