public AdressDTO GetAdressByID(int id)
{
using (var e = new EntityTC())
{
var add = e.Adress.SingleOrDefault(a => a.AdressID == id);
if (add == null)
{
return(null);
}
return(_mapper.Map <AdressDTO>(add));
}
}
public ItemDTO GetItemByID(int id)
{
using (var e = new EntityTC())
{
var i = e.Item.SingleOrDefault(a => a.ItemID == id);
if (i == null)
{
return(null);
}
return(_mapper.Map <ItemDTO>(i));
}
}
public OrderDTO GetOrderByID(int id)
{
using (var e = new EntityTC())
{
var o = e.Order.SingleOrDefault(a => a.OrderID == id);
if (o == null)
{
return(null);
}
return(_mapper.Map <OrderDTO>(o));
}
}
public CardInfoDTO GetCardInfoById(int id)
{
using (var e = new EntityTC())
{
var info = e.CardInfo.SingleOrDefault(a => a.CardInfoID == id);
if (info == null)
{
return(null);
}
return(_mapper.Map <CardInfoDTO>(info));
}
}
public CategoryDTO GetCategoryByID(int id)
{
using (var e = new EntityTC())
{
var c = e.Category.SingleOrDefault(a => a.CategoryID == id);
if (c == null)
{
return(null);
}
return(_mapper.Map <CategoryDTO>(c));
}
}
public bool DeleteAdress(int id)
{
using (var e = new EntityTC())
{
var add = e.Adress.SingleOrDefault(a => a.AdressID == id);
if (add == null)
{
return(false);
}
e.Adress.Remove(add);
e.SaveChanges();
return(true);
}
}
public bool DeleteItem(int id)
{
using (var e = new EntityTC())
{
var i = e.Item.SingleOrDefault(a => a.ItemID == id);
if (i == null)
{
return(false);
}
e.Item.Remove(i);
e.SaveChanges();
return(true);
}
}
public bool DeleteOrder(int id)
{
using (var e = new EntityTC())
{
var o = e.Order.SingleOrDefault(a => a.OrderID == id);
if (o == null)
{
return(false);
}
e.Order.Remove(o);
e.SaveChanges();
return(true);
}
}
public List <OrderedDTO> GetOrderedListByID(int id)
{
using (var e = new EntityTC())
{
var ordered = e.Ordered.Where(o => o.OrderID == id);
var to_ret = new List <OrderedDTO>();
foreach (var ord in ordered)
{
to_ret.Add(_mapper.Map <OrderedDTO>(ord));
}
return(to_ret);
}
}
public bool DeleteCardInfoById(int id)
{
using (var e = new EntityTC())
{
var info = e.CardInfo.SingleOrDefault(a => a.CardInfoID == id);
if (info == null)
{
return(false);
}
e.CardInfo.Remove(info);
e.SaveChanges();
return(true);
}
}
public bool DeleteCategory(int id)
{
using (var e = new EntityTC())
{
var c = e.Category.SingleOrDefault(a => a.CategoryID == id);
if (c == null)
{
return(false);
}
e.Category.Remove(c);
e.SaveChanges();
return(true);
}
}
public bool DeleteUserInfoById(int id)
{
using (var e = new EntityTC())
{
UserInfo user = e.UserInfo.SingleOrDefault(p => p.UserID == id);
if (user == null)
{
return(false);
}
e.UserInfo.Remove(user);
e.SaveChanges();
return(true);
}
}
