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