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