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