public ItemDTO GetItemByTitle(string title)
{
using (var entities = new TradingCompanyEntities())
{
var item = entities.Items.SingleOrDefault(i => i.Title == title);
return(_mapper.Map <ItemDTO>(item));
}
}
public List <OrderDTO> GetAllOrders()
{
using (var entities = new TradingCompanyEntities())
{
var orders = entities.Orders.ToList();
return(_mapper.Map <List <OrderDTO> >(orders));
}
}
public int GetAccessLevel(string username)
{
using (var entities = new TradingCompanyEntities())
{
var user = entities.Users.SingleOrDefault(u => u.Username == username);
return(user.AccessLevel != null ? user.AccessLevel.Value : 0);
}
}
public UserDTO GetUserById(long id)
{
using (var entities = new TradingCompanyEntities())
{
var user = entities.Users.SingleOrDefault(u => u.UserID == id);
return(_mapper.Map <UserDTO>(user));
}
}
public string GetNameByID(long id)
{
using (var entities = new TradingCompanyEntities())
{
var item = entities.Items.SingleOrDefault(i => i.ItemID == id);
return(_mapper.Map <string>(item.Title));
}
}
public OrderDTO GetOrderByID(long orderID)
{
using (var entities = new TradingCompanyEntities())
{
var order = entities.Orders.SingleOrDefault(o => o.MainOrderID == orderID);
return(_mapper.Map <OrderDTO>(order));
}
}
public List <ItemDTO> GetAllItems()
{
using (var entities = new TradingCompanyEntities())
{
var items = entities.Items.ToList();
return(_mapper.Map <List <ItemDTO> >(items));
}
}
public ItemDTO GetItemById(long id)
{
using (var entities = new TradingCompanyEntities())
{
var item = entities.Items.SingleOrDefault(i => i.ItemID == id);
return(_mapper.Map <ItemDTO>(item));
}
}
public DeliveryStatuDTO GetDelStatusById(short id)
{
using (var entities = new TradingCompanyEntities())
{
var delStatus = entities.DeliveryStatus.SingleOrDefault(ds => ds.DeliveryStatusID == id);
return(_mapper.Map <DeliveryStatuDTO>(delStatus));
}
}
public string GetStatusNameById(short id)
{
using (var entities = new TradingCompanyEntities())
{
var status = entities.DeliveryStatus.SingleOrDefault(s => s.DeliveryStatusID == id);
return(_mapper.Map <string>(status.Status));
}
}
public List <DeliveryStatuDTO> GetAllStatuses()
{
using (var entities = new TradingCompanyEntities())
{
var statuses = entities.DeliveryStatus.ToList();
return(_mapper.Map <List <DeliveryStatuDTO> >(statuses));
}
}
public List <UserDTO> GetAllUsers()
{
using (var entities = new TradingCompanyEntities())
{
var users = entities.Users.ToList();
return(_mapper.Map <List <UserDTO> >(users));
}
}
public async void Add(dto entity)
{
using (var entities = new TradingCompanyEntities())
{
entities.Set <tbl>().Add(_mapper.Map <tbl>(entity));
await entities.SaveChangesAsync();
}
}
public List <OrderDTO> GetOrdersByUserId(long customerID)
{
using (var entities = new TradingCompanyEntities())
{
var my_orders = entities.Orders.ToList();
var new_ordersList = (my_orders.FindAll(o => o.CustomerID == customerID));
return(_mapper.Map <List <OrderDTO> >(new_ordersList));
}
}
public List <OrdersRefDTO> GetOrdersByItem(long itemID)
{
using (var entities = new TradingCompanyEntities())
{
var ordersRefs = entities.OrdersRefs.ToList();
var new_ordersRefs = (ordersRefs.FindAll(o => o.refItemID == itemID));
return(_mapper.Map <List <OrdersRefDTO> >(new_ordersRefs));
}
}
//?
public List <OrdersRefDTO> GetItemsInOrder(long orderID) //returns all items in order by orderID
{
using (var entities = new TradingCompanyEntities())
{
var ordersRefs = entities.OrdersRefs.ToList();
var new_ordersRefs = ordersRefs.FindAll(o => o.refOrderID == orderID);
return(_mapper.Map <List <OrdersRefDTO> >(new_ordersRefs));
}
}
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 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 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 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 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 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 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 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 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 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 long GetUserId(string username)
{
using (var entities = new TradingCompanyEntities())
{
var user = entities.Users.SingleOrDefault(u => u.Username == username);
if (user is null)
{
return(0);
}
return(user.UserID);
}
}
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 List <AddressDTO> GetByCountry(string country)
{
var entity = new List <AddressDTO>();
using (var entities = new TradingCompanyEntities())
{
entity = _mapper.Map <List <AddressDTO> >(entities.Set <tblAddress>().Where(adr => adr.Country.ToLower() == country.ToLower()).ToList());
}
if (entity.Count == 0)
{
throw new NullReferenceException(nameof(AddressDTO));
}
return(entity);
}
