public List <Order> GetOrders()
{
CRCDeveloperInterviewHandle handle = new CRCDeveloperInterviewHandle();
DataTable dt = handle.GetOrders();
List <Order> orderlist = new List <Order>();
foreach (DataRow dr in dt.Rows)
{
orderlist.Add(
new DeveloperInterview.BusinessLayer.Order
{
CustomerId = Convert.ToInt32(dr["CustomerId"]),
FirstName = Convert.ToString(dr["FirstName"]),
LastName = Convert.ToString(dr["LastName"]),
OrderId = Convert.ToInt32(dr["OrderId"]),
Quantity = Convert.ToInt32(dr["Quantity"]),
ProductName = Convert.ToString(dr["Name"]),
ProductId = Convert.ToInt32(dr["ProductId"]),
Price = Convert.ToDecimal(dr["Price"]),
OrderDate = Convert.ToDateTime(dr["AddedDate"])
});
}
return(orderlist);
}
public List <Product> GetProducts()
{
CRCDeveloperInterviewHandle handle = new CRCDeveloperInterviewHandle();
DataTable dt = handle.GetProducts();
List <Product> productlist = new List <Product>();
foreach (DataRow dr in dt.Rows)
{
productlist.Add(
new Product
{
ProductId = Convert.ToInt32(dr["Id"]),
ProductName = Convert.ToString(dr["Name"]),
Price = Convert.ToDecimal(dr["Price"])
});
}
return(productlist);
}
public int CreateOrder(string FirstName, string LastName, Dictionary <int, int> products)
{
CRCDeveloperInterviewHandle handle = new CRCDeveloperInterviewHandle();
return(handle.AddOrder(FirstName, LastName, products));
}