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