public JsonResult <List <CustomerViewModel> > Customers()
{
DefTblCustomers tblDef = model.TblCustomers;
List <CustomerViewModel> customers = new List <CustomerViewModel>();
CustomerViewModel c;
model.LoadCustomers();
foreach (DataRow dr in model.Customers.Table.AsEnumerable())
{
c = new CustomerViewModel();
c.Cid = int.Parse(dr[tblDef.Cid.Name].ToString());
c.Company = dr[tblDef.Company.Name].ToString();
c.Address = dr[tblDef.Address.Name].ToString();
c.Zip = dr[tblDef.Zip.Name].ToString();
c.City = dr[tblDef.City.Name].ToString();
c.Country = dr[tblDef.Country.Name].ToString();
c.ContractId = dr[tblDef.ContractId.Name].ToString();
c.ContractDate = dr[tblDef.ContractDate.Name] as DateTime?;
customers.Add(c);
}
return(Json(customers));
}
public void BuildInsertTest()
{
DefTblCustomers def = new DefTblCustomers();
Dictionary <ColDef, object> map = new Dictionary <ColDef, object>();
map.Add(def.Cid, 1);
map.Add(def.Company, "test");
String sql = SqlStatements.BuildInsert(def.TblName, map);
Assert.AreEqual(String.Format("INSERT INTO {0}({1},{2}) VALUES(1,'test');", def.TblName, def.Cid.Name, def.Company.Name), sql);
}
public void BuildUpdateTest()
{
DefTblCustomers def = new DefTblCustomers();
Dictionary <ColDef, object> map = new Dictionary <ColDef, object>();
map.Add(def.Cid, TestCustomer.cid);
map.Add(def.Company, TestCustomer.company);
map.Add(def.Address, TestCustomer.address);
String sql = SqlStatements.BuildUpdate(def.TblName, map, new Tuple <ColDef, object>(def.Cid, TestCustomer.cid));
Assert.AreEqual(String.Format("UPDATE {0} SET {1} = '{2}',{3} = '{4}' WHERE {5} = {6};", def.TblName, def.Company.Name, TestCustomer.company, def.Address.Name, TestCustomer.address, def.Cid.Name, TestCustomer.cid), sql);
}
public Dictionary <ColDef, object> getMap()
{
DefTblCustomers tblDef = Model.Model.GetModel().TblCustomers;
Dictionary <ColDef, object> map = new Dictionary <ColDef, object>();
map.Add(tblDef.Cid, Cid);
map.Add(tblDef.Company, Company);
map.Add(tblDef.Address, Address);
map.Add(tblDef.Zip, Zip);
map.Add(tblDef.City, City);
map.Add(tblDef.Country, Country);
map.Add(tblDef.ContractId, ContractId);
map.Add(tblDef.ContractDate, ContractDate);
return(map);
}
public static void InsertTestCustomer()
{
DefTblCustomers def = new DefTblCustomers();
Dictionary <ColDef, object> map = new Dictionary <ColDef, object>();
map.Add(def.Cid, TestCustomer.cid);
map.Add(def.Company, TestCustomer.company);
map.Add(def.Address, TestCustomer.address);
map.Add(def.Zip, TestCustomer.zip);
map.Add(def.City, TestCustomer.city);
map.Add(def.Country, TestCustomer.country);
map.Add(def.ContractId, TestCustomer.contractId);
map.Add(def.ContractDate, TestCustomer.contractDate);
String sql = SqlStatements.BuildInsert(def.TblName, map);
CRM_web.Models.Model.Model.GetModel().ExecuteActionQuery(sql);
}
public void SubmitCustomer()
{
// ---- Arrange ----
// set up model state
CRM_web.Models.Model.Model m = CRM_web.Models.Model.Model.GetModel();
DefTblCustomers def = new DefTblCustomers();
TestCase.PopulateTestData();
// set up controller and view model
FrmCustomerController controller = new FrmCustomerController();
CustomerViewModel vm = new CustomerViewModel();
vm.Cid = TestCustomer.cid;
vm.Company = TestCustomer.company;
vm.Address = TestCustomer.address;
vm.Zip = TestCustomer.zip;
vm.City = TestCustomer.city;
vm.Country = TestCustomer.country;
vm.ContractId = TestCustomer.contractId;
vm.ContractDate = TestCustomer.contractDate;
// ---- Act ----
RedirectToRouteResult result = controller.Submit(vm) as RedirectToRouteResult;
Thread.Sleep(1000);
// ---- Assert ----
DataRow dr = (from d in m.GetCustomer(TestCustomer.cid).Table.AsEnumerable()
select d).First();
// check new entries
Assert.AreEqual(TestCustomer.cid, dr[def.Cid.Name]);
Assert.AreEqual(TestCustomer.company, dr[def.Company.Name]);
Assert.AreEqual(TestCustomer.address, dr[def.Address.Name]);
Assert.AreEqual(TestCustomer.zip, dr[def.Zip.Name]);
Assert.AreEqual(TestCustomer.city, dr[def.City.Name]);
Assert.AreEqual(TestCustomer.country, dr[def.Country.Name]);
Assert.AreEqual(TestCustomer.contractId, dr[def.ContractId.Name]);
Assert.AreEqual(TestCustomer.contractDate, dr[def.ContractDate.Name]);
TestCase.CleanUp();
}
