public JsonResult <List <NoteViewModel> > Notes(int cid)
{
DefTblNotes tblDef = model.TblNotes;
List <NoteViewModel> notes = new List <NoteViewModel>();
NoteViewModel note;
model.LoadNotes(cid);
foreach (DataRow dr in model.Notes.Table.AsEnumerable())
{
note = new NoteViewModel();
note.Id = int.Parse(dr[tblDef.Id.Name].ToString());
note.Cid = int.Parse(dr[tblDef.Cid.Name].ToString());
note.CreatedBy = dr[tblDef.CreatedBy.Name].ToString();
note.EntryDate = dr[tblDef.EntryDate.Name] as DateTime?;
note.Memo = dr[tblDef.Memo.Name].ToString();
note.Category = dr[tblDef.Category.Name].ToString();
note.Attachment = dr[tblDef.Attachment.Name].ToString();
notes.Add(note);
}
return(Json(notes));
}
public Dictionary<ColDef, object> getMap()
{
DefTblNotes tblDef = Model.Model.GetModel().TblNotes;
Dictionary<ColDef, object> map = new Dictionary<ColDef, object>();
map.Add(tblDef.Id, Id);
map.Add(tblDef.Cid, Cid);
map.Add(tblDef.CreatedBy, CreatedBy);
map.Add(tblDef.EntryDate, EntryDate);
map.Add(tblDef.Memo, Memo);
map.Add(tblDef.Category, Category);
map.Add(tblDef.Attachment, Attachment);
return map;
}
public static void InsertTestNote()
{
DefTblNotes def = new DefTblNotes();
Dictionary <ColDef, object> map = new Dictionary <ColDef, object>();
map.Add(def.Id, TestNote.id);
map.Add(def.Cid, TestNote.cid);
map.Add(def.CreatedBy, TestNote.createdBy);
map.Add(def.EntryDate, TestNote.entryDate);
map.Add(def.Memo, TestNote.memo);
map.Add(def.Category, TestNote.category);
map.Add(def.Attachment, TestNote.attachment);
String sql = SqlStatements.BuildInsert(def.TblName, map);
CRM_web.Models.Model.Model.GetModel().ExecuteActionQuery(sql);
}
public void SubmitNote()
{
// ---- Arrange ----
// set up model state
CRM_web.Models.Model.Model m = CRM_web.Models.Model.Model.GetModel();
DefTblNotes def = new DefTblNotes();
m.ExecuteActionQuery(String.Format("DELETE FROM {0} WHERE {1} = {2};", def.TblName, def.Cid.Name, TestNote.cid));
TestCase.PopulateTestData();
m.Cid = TestNote.cid;
m.LoadCustomers();
m.LoadNotes(TestNote.cid);
// set up controller and view model
FrmNoteController controller = new FrmNoteController();
NoteViewModel vm = new NoteViewModel();
vm.Id = TestNote.id;
vm.Cid = TestNote.cid;
vm.CreatedBy = TestNote.createdBy;
vm.EntryDate = TestNote.entryDate;
vm.Memo = TestNote.memo;
vm.Category = TestNote.category;
vm.Attachment = TestNote.attachment;
// ---- Act ----
RedirectToRouteResult result = controller.Submit(vm) as RedirectToRouteResult;
Thread.Sleep(1000);
// ---- Assert ----
Assert.AreEqual(TestNote.id, m.Notes[0][def.Id.Name]);
Assert.AreEqual(TestNote.cid, m.Notes[0][def.Cid.Name]);
Assert.AreEqual(TestNote.createdBy, m.Notes[0][def.CreatedBy.Name]);
Assert.AreEqual(TestNote.entryDate, m.Notes[0][def.EntryDate.Name]);
Assert.AreEqual(TestNote.memo, m.Notes[0][def.Memo.Name]);
Assert.AreEqual(TestNote.category, m.Notes[0][def.Category.Name]);
Assert.AreEqual(TestNote.attachment, m.Notes[0][def.Attachment.Name]);
TestCase.CleanUp();
}
