public JsonResult <List <ContactPersonViewModel> > ContactPersons(int cid)
{
DefTblContactPersons tblDef = model.TblContactPersons;
List <ContactPersonViewModel> contactPersons = new List <ContactPersonViewModel>();
ContactPersonViewModel cp;
model.LoadContactPersons(cid);
foreach (DataRow dr in model.ContactPersons.Table.AsEnumerable())
{
cp = new ContactPersonViewModel();
cp.Id = int.Parse(dr[tblDef.Id.Name].ToString());
cp.Cid = int.Parse(dr[tblDef.Cid.Name].ToString());
cp.Forename = dr[tblDef.Forename.Name].ToString();
cp.Surname = dr[tblDef.Surname.Name].ToString();
cp.Gender = dr[tblDef.Gender.Name].ToString();
cp.Email = dr[tblDef.Email.Name].ToString();
cp.Phone = dr[tblDef.Phone.Name].ToString();
cp.MainContact = (bool)dr[tblDef.MainContact.Name];
contactPersons.Add(cp);
}
return(Json(contactPersons));
}
public void SubmitContactPerson()
{
// ---- Arrange ----
// set up model
DefTblContactPersons def = new DefTblContactPersons();
CRM_web.Models.Model.Model m = CRM_web.Models.Model.Model.GetModel();
TestCase.CleanUp();
m.ExecuteActionQuery(String.Format("DELETE FROM {0} WHERE {1} = {2};", def.TblName, def.Cid.Name, TestContactPerson.cid));
TestCase.PopulateTestData();
m.Cid = TestContactPerson.cid;
m.LoadCustomers();
m.LoadContactPersons(TestCustomer.cid);
//Thread.Sleep(1000);
// set up controller and view model
FrmContactPersonController controller = new FrmContactPersonController();
ContactPersonViewModel vm = new ContactPersonViewModel();
vm.Id = TestContactPerson.id;
vm.Cid = TestContactPerson.cid;
vm.Forename = TestContactPerson.forename;
vm.Surname = TestContactPerson.surname;
vm.Gender = TestContactPerson.gender;
vm.Email = TestContactPerson.email;
vm.Phone = TestContactPerson.phone;
vm.MainContact = TestContactPerson.mainContact;
// ---- Act ----
RedirectToRouteResult result = controller.Submit(vm) as RedirectToRouteResult;
Thread.Sleep(1000);
m.LoadContactPersons(TestCustomer.cid);
Thread.Sleep(1000);
// ---- Assert ----
Assert.IsNotNull(result);
// check new entries in database
int lastEntry = 0;
int max = 0;
for (int i = 0; i < m.ContactPersons.Count; i++)
{
if (int.Parse(m.ContactPersons[i][def.Id.Name].ToString()) > max)
{
max = int.Parse(m.ContactPersons[i][def.Id.Name].ToString());
lastEntry = i;
}
}
Assert.AreEqual(m.ContactPersons[lastEntry][def.Cid.Name], TestContactPerson.cid);
Assert.AreEqual(m.ContactPersons[lastEntry][def.Forename.Name], TestContactPerson.forename);
Assert.AreEqual(m.ContactPersons[lastEntry][def.Surname.Name], TestContactPerson.surname);
Assert.AreEqual(m.ContactPersons[lastEntry][def.Gender.Name], TestContactPerson.gender);
Assert.AreEqual(m.ContactPersons[lastEntry][def.Email.Name], TestContactPerson.email);
Assert.AreEqual(m.ContactPersons[lastEntry][def.Phone.Name], TestContactPerson.phone);
Assert.AreEqual(m.ContactPersons[lastEntry][def.MainContact.Name], TestContactPerson.mainContact);
// clean up model
m.ExecuteActionQuery(String.Format("DELETE FROM {0} WHERE {1} = {2};", def.TblName, def.Cid.Name, TestContactPerson.cid));
TestCase.CleanUp();
}
public Dictionary <ColDef, object> getMap()
{
DefTblContactPersons tblDef = Model.Model.GetModel().TblContactPersons;
Dictionary <ColDef, object> map = new Dictionary <ColDef, object>();
map.Add(tblDef.Id, Id);
map.Add(tblDef.Cid, Cid);
map.Add(tblDef.Forename, Forename);
map.Add(tblDef.Surname, Surname);
map.Add(tblDef.Gender, Gender);
map.Add(tblDef.Email, Email);
map.Add(tblDef.Phone, Phone);
map.Add(tblDef.MainContact, MainContact);
return(map);
}
public static void InsertTestContactPerson()
{
DefTblContactPersons def = new DefTblContactPersons();
Dictionary <ColDef, object> map = new Dictionary <ColDef, object>();
map.Add(def.Id, TestContactPerson.id);
map.Add(def.Cid, TestContactPerson.cid);
map.Add(def.Forename, TestContactPerson.forename);
map.Add(def.Surname, TestContactPerson.surname);
map.Add(def.Gender, TestContactPerson.gender);
map.Add(def.Email, TestContactPerson.email);
map.Add(def.Phone, TestContactPerson.phone);
map.Add(def.MainContact, TestContactPerson.mainContact);
String sql = SqlStatements.BuildInsert(def.TblName, map);
CRM_web.Models.Model.Model.GetModel().ExecuteActionQuery(sql);
}
