public static void Main() { var customer = new Customer { CustomerID = "PHPTH", CompanyName = "Telerik Academy", ContactName = "Pesho Petrov", ContactTitle = "Marketing Assistant", Address = "31 Al. Malinov", City = "Sofia", Region = null, PostalCode = "2100", Country = "Bulgaria", Phone = "(359) 2444444", Fax = null }; try { Console.WriteLine("INSERT:"); int affectedRowsAfterInsert = DAO.InsertCustomer(customer); Console.WriteLine("{0} row(s) affected", affectedRowsAfterInsert); Console.WriteLine("MODIFY:"); int affectedRowsAfterModify = DAO.ModifyCustomer(customer); Console.WriteLine("{0} row(s) affected", affectedRowsAfterModify); Console.WriteLine("DELETE"); int affectedRowsAfterDelete = DAO.DeleteCustomer(customer); Console.WriteLine("{0} row(s) affected", affectedRowsAfterDelete); } catch (InvalidOperationException e) { Console.WriteLine(e.Message); } }
public void AddCustomer_ShouldAddANewCustomer() { using (var db = new NorthwindEntities()) { string city = "City of angels"; var customersCountBeforeAdding = db.Customers .Select(c => c.City == city) .ToList() .Count; Customer newCustomer = new Customer() { CustomerID = "LBCDM", CompanyName = "Telerik", ContactName = "Alex Frost", ContactTitle = "Very special guy", Address = "31 Al.Malinov", City = city, Region = null, PostalCode = "2000", Country = "Bulgaria", Phone = "55555555", Fax = null }; DAO.InsertCustomer(newCustomer); var customersCountAfterAddingOne = db.Customers .Select(c => c.City == city) .ToList() .Count; Assert.AreEqual(customersCountBeforeAdding + 1, customersCountAfterAddingOne); DAO.DeleteCustomer(newCustomer); } }
public void AddCustomer_ShouldThrowAnExceptionWhenTryingToAddCustomersWithTheSameId() { using (var db = new NorthwindEntities()) { Customer newCustomer = new Customer() { CustomerID = "LBCDM", CompanyName = "Telerik", ContactName = "Alex Frost", ContactTitle = "Very special guy", Address = "31 Al.Malinov", City = "City of angels", Region = null, PostalCode = "2000", Country = "Bulgaria", Phone = "55555555", Fax = null }; DAO.InsertCustomer(newCustomer); DAO.InsertCustomer(newCustomer); } }
public void ModifyCustomer_ShouldModifyCustomersComapnyNameAndCompanyTitle() { using (var db = new NorthwindEntities()) { string id = "LBCDM"; string city = "City of angels"; Customer newCustomer = new Customer() { CustomerID = id, CompanyName = "Telerik", ContactName = "Alex Frost", ContactTitle = "Very special guy", Address = "31 Al.Malinov", City = city, Region = null, PostalCode = "2000", Country = "Bulgaria", Phone = "55555555", Fax = null }; DAO.InsertCustomer(newCustomer); DAO.ModifyCustomer(newCustomer); var customer = db.Customers .FirstOrDefault(c => c.CustomerID == id); Assert.AreNotEqual(newCustomer.ContactTitle, customer.ContactTitle); Assert.AreNotEqual(newCustomer.CompanyName, customer.CompanyName); DAO.DeleteCustomer(newCustomer); } }