public static OrderDetails GetOrderfromBranch(int id_branch) { using (DB_shoesEntities5 db = new DB_shoesEntities5()) { try { OrderDetails order = new OrderDetails(); OrdersFromBranch order_from = db.OrdersFromBranches.First(o => o.from_branch == id_branch && o.status == false); CustomersToOrder cust = db.CustomersToOrders.First(c => c.id_customer == order_from.id_cust); order.id_shoe = order_from.id_shoe; order.color = order_from.color; order.size = (Int32)order_from.size; order.name_customer = cust.name_customer; order.picture = db.Shoes.First(s => s.id_shoe == order_from.id_shoe).picture; order_from.status = true; order.phone = cust.phone; order.email = cust.email; order.order_id = order_from.id_order; order.order_date = order_from.order_date.ToString(); db.SaveChanges(); return(order); } catch (Exception e) { return(null); } } }
public static int AddCustomerToOrder(string mail, string phone, string name) { using (DB_shoesEntities5 db = new DB_shoesEntities5()) { CustomersToOrder cust = new CustomersToOrder(); cust.email = mail; cust.phone = phone; cust.name_customer = name; db.CustomersToOrders.Add(cust); db.SaveChanges(); int x = cust.id_customer; return(x); } }