public int AddOrder(Order order) { try { var dborder = new DbOrder() { customer_id = order.CustomerId , order_status_id = order.OrderStatusId , payment_method_id = order.PaymentMethodId , payment_method = order.PaymentMethod , payment_firstname = order.PaymentFirstname , payment_lastname = order.PaymentLastname , payment_address_1 = order.PaymentAddress1 , payment_address_2 = order.PaymentAddress2 , payment_city = order.PaymentCity , payment_postcode = order.PaymentPostcode , payment_country = order.PaymentCountry , shipping_firstname = order.ShippingFirstname, shipping_lastname = order.ShippingLastname , shipping_address_1 = order.ShippingAddress1 , shipping_address_2 = order.ShippingAddress2 , shipping_city = order.ShippingCity , shipping_postcode = order.ShippingPostcode , shipping_country = order.ShippingCountry , comment = order.Comment , total = order.Total , }; dborder = _dbEntities.Orders.Add(dborder); _dbEntities.SaveChanges(); return dborder.order_id; } catch (Exception ex) { throw; } }
public void UpdateOrder(Order order) { var dborder = _dbEntities.Orders.SingleOrDefault(x => x.order_id == order.OrderId); if (dborder == null) { throw new ObjectNotFoundException(string.Format(" Order Id of :{0} was not found", order.OrderId)); } try { dborder.customer_id = order.CustomerId ; dborder.order_status_id = order.OrderStatusId ; dborder.payment_method_id = order.PaymentMethodId ; dborder.payment_method = order.PaymentMethod ; dborder.payment_firstname = order.PaymentFirstname ; dborder.payment_lastname = order.PaymentLastname ; dborder.payment_address_1 = order.PaymentAddress1 ; dborder.payment_address_2 = order.PaymentAddress2 ; dborder.payment_city = order.PaymentCity ; dborder.payment_postcode = order.PaymentPostcode ; dborder.payment_country = order.PaymentCountry ; dborder.shipping_firstname = order.ShippingFirstname; dborder.shipping_lastname = order.ShippingLastname ; dborder.shipping_address_1 = order.ShippingAddress1 ; dborder.shipping_address_2 = order.ShippingAddress2 ; dborder.shipping_city = order.ShippingCity ; dborder.shipping_postcode = order.ShippingPostcode ; dborder.shipping_country = order.ShippingCountry ; dborder.comment = order.Comment ; dborder.total = order.Total; dborder.date_modified = DateTime.Now; _dbEntities.SaveChanges(); } catch (Exception) { throw; } }