public object FindBy(string criteria, params int[] value) { CustomRepository <int> repo = new CustomRepository <int>(); repo.FindByGlossary(value[0], criteria); return(CustomerAccess.GetData()); }
public override object Execute() { foreach (NewCriteria <T> criteria in _criterias) { if (criteria != null) { switch (criteria.Criteria) { case Utilites.QueryCriteria.ID: CustomerAccess.GetCustomersByID(Convert.ToInt32(criteria.First)); break; case Utilites.QueryCriteria.Bithday: if (criteria.Predicate == "Between") { CustomerAccess.GetCustomersByBirthdayBetween(Convert.ToDateTime(criteria.First), Convert.ToDateTime(criteria.Second)); } else { CustomerAccess.GetCustomersByBirthOfDay(Convert.ToDateTime(criteria.First), criteria.Predicate); } break; default: CustomerAccess.GetDataByCriteria(criteria.Criteria, criteria.Values.Cast <object>().ToArray(), criteria.Predicate); break; } } } return(CustomerAccess.GetData()); }
public void CustomerAccess_FillGlossary_TestMethod() { SqlConnection connection = ConnectionManager.Connection; connection.Open(); CustomerAccess.FillDictionary(); DataSet dataSet = (DataSet)CustomerAccess.GetData(); Assert.IsTrue(dataSet.Tables["Gender"].Rows.Count > 0); }
public bool InsertCustomer(Customer customerToSave) { bool wasInsertedCorrectly; CustomerAccess customerDB = new CustomerAccess(); wasInsertedCorrectly = customerDB.SaveCustomer(customerToSave); return(wasInsertedCorrectly); }
public bool LoginCustomer(string emailToLookUp, string passwordToVerify) { bool wasIdentified; CustomerAccess customberDb = new CustomerAccess(); wasIdentified = customberDb.LoginCustomer(emailToLookUp, passwordToVerify); return(wasIdentified); }
public Customer GetCustomerByEmail(string emailToFind) { Customer foundCustomer; CustomerAccess customerDb = new CustomerAccess(); foundCustomer = customerDb.GetCustomerByEmail(emailToFind); return(foundCustomer); }
public void CustomerAccess_GetCustomersByBirthdayBetween_TestMethod() { SqlConnection connection = ConnectionManager.Connection; connection.Open(); CustomerAccess.FillDictionary(); CustomerAccess.FillCustomerData(); CustomerAccess.GetCustomersByBirthdayBetween(new DateTime(1970, 1, 1), new DateTime(2016, 01, 01)); DataSet dataSet = (DataSet)CustomerAccess.GetData(); Assert.IsTrue(dataSet.Tables["Customer"].Rows.Count > 0); }
public void CustomerAccess_GetCustomersByBirthday_TestMethod(int year, int m, int day) { SqlConnection connection = ConnectionManager.Connection; connection.Open(); CustomerAccess.FillDictionary(); CustomerAccess.FillCustomerData(); CustomerAccess.GetCustomersByBirthOfDay(new DateTime(year, m, day)); DataSet dataSet = (DataSet)CustomerAccess.GetData(); Assert.IsTrue(dataSet.Tables["Customer"].Rows.Count > 0); }
public void CustomerAccess_GetCustomersByGlossary_TestMethod(string name, string glossary, int Id) { SqlConnection connection = ConnectionManager.Connection; connection.Open(); CustomerAccess.FillDictionary(); CustomerAccess.FillCustomerData(); CustomerAccess.GetCustomersByGlossary(name, glossary, Id); DataSet dataSet = (DataSet)CustomerAccess.GetData(); Assert.IsTrue(dataSet.Tables["Customer"].Rows.Count > 0); }
public override object Execute() { foreach (NewCriteria <int> criteria in _criterias) { if (criteria != null) { CustomerAccess.GetCustomersByGlossary("Customer", criteria.Criteria, criteria.Values[0]); } break; } return(CustomerAccess.GetData()); }
public void CustomerAccess_GetByAddress_TestMethod(string addr) { SqlConnection connection = ConnectionManager.Connection; connection.Open(); CustomerAccess.FillDictionary(); CustomerAccess.FillCustomerData(); CustomerAccess.GetDataByCriteria("Address", new[] { "Славянск", addr }); DataSet dataSet = (DataSet)CustomerAccess.GetData(); Assert.IsTrue(dataSet.Tables["Customer"].Rows.Count > 0); }
public void CustomerAccess_GetCustomersByID_TestMethod(int id) { SqlConnection connection = ConnectionManager.Connection; connection.Open(); CustomerAccess.FillDictionary(); CustomerAccess.FillCustomerData(); CustomerAccess.GetCustomersByID(id); DataSet dataSet = (DataSet)CustomerAccess.GetData(); Assert.IsTrue(dataSet.Tables["Customer"].Rows.Count > 0); }
public void Query_CustomerQuery_ExecuteMethod_TestMethod() { SqlConnection connection = ConnectionManager.Connection; connection.Open(); CustomerAccess.FillDictionary(); DataSet dataSet; NewCriteria <int> criteria = new NewCriteria <int>("=", "ID", 1); CustomerQuery <int> customerQuery = new CustomerQuery <int>(); customerQuery.Criterias(criteria); dataSet = (DataSet)customerQuery.Execute(); Assert.IsTrue(dataSet.Tables["Customer"].Rows.Count > 0); }
public void Query_GlossaryQuery_ExecuteMethod_TestMethod(string nameGlossary, int id) { SqlConnection connection = ConnectionManager.Connection; connection.Open(); CustomerAccess.FillDictionary(); CustomerAccess.FillCustomerData(); DataSet dataSet = (DataSet)CustomerAccess.GetData(); NewCriteria <int> criteria = new NewCriteria <int>("=", nameGlossary, id); GlossaryQuery glossary = new GlossaryQuery(); glossary.Criterias(criteria); dataSet = (DataSet)glossary.Execute(); Assert.IsTrue(dataSet.Tables["Customer"].Rows.Count > 0); }
public void CustomerAccess_GetDataByCriteria_TestMethod(string lastname1, string addr1, string lastName2, string addr2) { SqlConnection connection = ConnectionManager.Connection; connection.Open(); CustomerAccess.FillDictionary(); CustomerAccess.FillCustomerData(); CustomerAccess.GetDataByCriteria("LastName", new[] { lastname1 }, "="); CustomerAccess.GetDataByCriteria("Address", new [] { "Славянск", addr1 }, "="); CustomerAccess.GetDataByCriteria("LastName", new[] { lastName2, }, "="); CustomerAccess.GetDataByCriteria("Address", new[] { "Славянск", addr2 }, "="); DataSet dataSet = (DataSet)CustomerAccess.GetData(); Assert.IsTrue(dataSet.Tables["Customer"].Rows.Count > 0); }
static void Main(string[] args) { CustomerAccess customerAccess = new CustomerAccess(); List <CustomerRelationship> crs = new List <CustomerRelationship>(); crs.Add(new GoldCustomer() { }); crs.Add(new PlatinumCustomer() { }); crs.Add(new TitaniumCustomer() { }); customerAccess.GetResortAccessCustomer(crs); }
public void CreateProjectModelFromProjectEntity_Test() { // Arrange int sampleCustomerId = 3; string sampleCustomerName = "someCustomerName"; string sampleCustomerAddress = "someAddress"; string sampleCustomerCity = "someCity"; Customer customer = new Customer { Id = sampleCustomerId, Name = sampleCustomerName, Address = sampleCustomerAddress, City = sampleCustomerCity }; int sampleId = 4; string sampleName = "sampleName"; string sampleStatus = "Open"; string sampleComment = "someComment"; Project project = new Project { Id = sampleId, Name = sampleName, Status = sampleStatus, Comment = sampleComment, Customer = customer }; var customerAccess = new CustomerAccess(); // Act var projectModel = new ProjectModel(project, customerAccess); // Assert Assert.Equal(sampleId, projectModel.Id); Assert.Equal(sampleName, projectModel.Name); Assert.Equal(sampleStatus, projectModel.Status); Assert.Equal(sampleComment, projectModel.Comment); Assert.Equal(sampleCustomerName, projectModel.CustomerName); Assert.True(projectModel.GetType() == typeof(Warehouse_Manage_WPF.UserInterface.Models.ProjectModel)); }
public void Validation() { CustomerAccess.Vapidated(); }
public CustomerController(IConfiguration config) { _customerAccess = new CustomerAccess(config); }
public object GetGlossaryByName(string name) { return(CustomerAccess.GetByEntityName(name)); }
public void Validated(DataRowView row) { CustomerAccess.Vapidated(row); }
public object FindBy(string criteria, params object[] values) { CustomerAccess.GetDataByCriteria(criteria, values); return(CustomerAccess.GetData()); }
public void SaveGlossary(string nameGlossary) { CustomerAccess.SaveEntity(nameGlossary); }
public object FindByGlossary(int id, string name) { CustomerAccess.GetCustomersByGlossary(name, id); return(CustomerAccess.GetData()); }
/// <summary> /// Main entry point of the application /// </summary> /// <param name="args">are not needed</param> static void Main(string[] args) { var doc = new Document { Title = "Test Title", Content = "Test Content" }; doc.Print(); var gustav = new Customer { Id = new Guid("471619aa-5941-4086-a05c-32a4bb46e394"), FirstName = "Gustav", LastName = "Ganz", CustomerNumber = "Test1234" }; var hans = new Customer { Id = new Guid("38b85e88-5611-423e-b9b4-7d651e404845"), FirstName = "Hans", LastName = "Wurst", CustomerNumber = "Test12345" }; var toiletPaper = new Article { Name = "Toilet paper", BasePrice = 2.0M }; var toothBrush = new Article { Name = "Toothbrush", Description = "electric", BasePrice = 40.0M }; var articleAcc = new ArticleAccess(); articleAcc.Create(toiletPaper); articleAcc.Create(toothBrush); var order = new Order { Customer = hans, OrderItems = new List <OrderItem> { new OrderItem { Article = toothBrush, Amount = 2 }, new OrderItem { Article = toiletPaper, Amount = 3 } } }; var orderAcc = new OrderAccess(); orderAcc.Create(order); var acc = new CustomerAccess(); acc.Create(hans); acc.Create(gustav); acc.Delete(gustav); acc.Update(gustav); hans.LastName = "Wursterich"; acc.Update(hans); var customers = acc.GetList(); Console.ReadKey(); }
public object FindByID(int id) { CustomerAccess.GetCustomersByID(id); return(CustomerAccess.GetData()); }
public object FillAll() { CustomerAccess.FillDictionary(); CustomerAccess.FillCustomerData(); return(CustomerAccess.GetData()); }
public void Update(IList <T> list) { CustomerAccess.Update(); }
public void ExportToExcel(string[] columns) { CustomerAccess.ExportToExcel(); }
internal void Validated() { CustomerAccess.Vapidated(); }