public ItemDTO CreateItem(ItemDTO item)
{
using (var entities = new TradingCompanyEntities())
{
Item i = _mapper.Map <Item>(item);
entities.Items.Add(i);
entities.SaveChanges();
return(_mapper.Map <ItemDTO>(i));
}
}
public OrdersRefDTO UpdateOrderRef(OrdersRefDTO orderRef)
{
using (var entities = new TradingCompanyEntities())
{
entities.OrdersRefs.AddOrUpdate(_mapper.Map <OrdersRef>(orderRef));
var _orderRef = entities.OrdersRefs.Single(o => (o.refOrderID == orderRef.refOrderID & o.refItemID == orderRef.refItemID));
entities.SaveChanges();
return(_mapper.Map <OrdersRefDTO>(_orderRef));
}
}
public ItemDTO UpdateItem(ItemDTO item)
{
using (var entities = new TradingCompanyEntities())
{
entities.Items.AddOrUpdate(_mapper.Map <Item>(item));
var _item = entities.Items.Single(i => i.ItemID == item.ItemID);
entities.SaveChanges();
return(_mapper.Map <ItemDTO>(_item));
}
}
public OrdersRefDTO CreateOrderRef(OrdersRefDTO orderRef)
{
using (var entities = new TradingCompanyEntities())
{
OrdersRef o = _mapper.Map <OrdersRef>(orderRef);
entities.OrdersRefs.Add(o);
entities.SaveChanges();
return(_mapper.Map <OrdersRefDTO>(o));
}
}
public DeliveryStatuDTO UpdateDeliveryStatus(DeliveryStatuDTO delStatus)
{
using (var entities = new TradingCompanyEntities())
{
entities.DeliveryStatus.AddOrUpdate(_mapper.Map <DeliveryStatu>(delStatus));
var dstatus = entities.DeliveryStatus.Single(ds => ds.DeliveryStatusID == delStatus.DeliveryStatusID);
entities.SaveChanges();
return(_mapper.Map <DeliveryStatuDTO>(dstatus));
}
}
public UserDTO UpdateUser(UserDTO user)
{
using (var entities = new TradingCompanyEntities())
{
entities.Users.AddOrUpdate(_mapper.Map <User>(user));
var _user = entities.Users.Single(u => u.UserID == user.UserID);
entities.SaveChanges();
return(_mapper.Map <UserDTO>(_user));
}
}
public DeliveryStatuDTO CreateDeliveryStatus(DeliveryStatuDTO delStatus)
{
using (var entities = new TradingCompanyEntities())
{
DeliveryStatu ds = _mapper.Map <DeliveryStatu>(delStatus);
entities.DeliveryStatus.Add(ds);
entities.SaveChanges();
return(_mapper.Map <DeliveryStatuDTO>(ds));
}
}
public OrderDTO UpdateOrder(OrderDTO order)
{
using (var entities = new TradingCompanyEntities())
{
entities.Orders.AddOrUpdate(_mapper.Map <Order>(order));
var o = entities.Orders.Single(ord => ord.MainOrderID == order.MainOrderID);
entities.SaveChanges();
return(_mapper.Map <OrderDTO>(o));
}
}
public void DeleteItem(long id)
{
using (var entities = new TradingCompanyEntities())
{
var _item = entities.Items.SingleOrDefault(i => i.ItemID == id);
if (_item == null)
{
return;
}
entities.Items.Remove(_item);
entities.SaveChanges();
}
}
public void DeleteOrderRef(long orderID, long itemID)
{
using (var entities = new TradingCompanyEntities())
{
var o = entities.OrdersRefs.SingleOrDefault(oo => (oo.refOrderID == orderID & oo.refItemID == itemID));
if (o == null)
{
return;
}
entities.OrdersRefs.Remove(o);
entities.SaveChanges();
}
}
public void DeleteUser(long id)
{
using (var entities = new TradingCompanyEntities())
{
var u = entities.Users.SingleOrDefault(us => us.UserID == id);
if (u == null)
{
return;
}
entities.Users.Remove(u);
entities.SaveChanges();
}
}
public void DeleteDelStatus(short id)
{
using (var entities = new TradingCompanyEntities())
{
var ds = entities.DeliveryStatus.SingleOrDefault(_ds => _ds.DeliveryStatusID == id);
if (ds == null)
{
return;
}
entities.DeliveryStatus.Remove(ds);
entities.SaveChanges();
}
}
public UserDTO CreateUser(UserDTO user)
{
using (var entities = new TradingCompanyEntities())
{
User u = _mapper.Map <User>(user);
try
{
entities.Users.Add(u);
entities.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
System.Console.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
return(_mapper.Map <UserDTO>(u));
}
}