public find ( int id ) : |
||
id | int | |
return |
public ProductModel find(int id)
{
using (var db = new CustomerContext())
{
try
{
var product = db.Products.Find(id);
var productModel = new ProductModel();
if (product == null)
return null;
productModel.productID = product.productID;
productModel.productName = product.productName;
productModel.price = product.price;
productModel.imageURL = product.imageURL;
productModel.description = product.description;
productModel.category = product.category;
productModel.stock = product.stock;
return productModel;
}
catch (Exception ex)
{
_logging.logToDatabase(ex);
}
return null;
}
}
private OrderModel createOrderModel(Orders order) { var orderModel = new OrderModel(); using (var db = new CustomerContext()) { if (order == null)//tester om orderen finnes return null; try { orderModel.orderNr = order.orderNr; orderModel.customerID = order.personID; var productOrders = (from p in db.ProductOrders where p.orderNr == order.orderNr select p).ToList(); orderModel.total = 0; var productDAL = new ProductDAL(); foreach (var o in productOrders)//legger produktene til i order modellen { var productModel = productDAL.find(o.products.productID); productModel.quantity = o.quantity; orderModel.products.Add(productModel); orderModel.total += o.price; } return orderModel; } catch (Exception ex) { _logging.logToDatabase(ex); } } return null; }