public List <ItemStatusDTO> GetAllItemStatus()
{
List <ItemStatusDTO> statuses = new List <ItemStatusDTO>();
var data = dataContext.ItemStatus.ToList();
foreach (ItemStatus item in data)
{
statuses.Add(DTOConverter.ConvertItemStatus(item));
}
/*
* using (DbCommand cmd = db.GetSqlStringCommand("SELECT RecordID,Status FROM ItemStatus"))
* {
* using (IDataReader reader = db.ExecuteReader(cmd))
* {
* while (reader.Read())
* {
* ItemStatus s = new ItemStatus();
* s.RecordID = reader.GetInt32(0);
* s.Status = reader.GetString(1);
* statuses.Add(s);
* }
* }
* }
*/
return(statuses);
}
public List <PurchaseItemDTO> GetAll(int parentId)
{
List <PurchaseItemDTO> list = new List <PurchaseItemDTO>();
var data = dataContext.PurchaseItems.Where(c => c.PurchaseID == parentId);
foreach (PurchaseItem p in data)
{
list.Add(DTOConverter.ConvertPurchaseItem(p));
}
return(list);
}
public List <ReservationItemDTO> GetAllReservation()
{
List <ReservationItemDTO> items = new List <ReservationItemDTO>();
var data = dataContext.ReservationItems;
foreach (ReservationItem item in data)
{
items.Add(DTOConverter.ConvertReservationItem(item));
}
return(items);
}
public List <MerchantDTO> GetAllMerchant()
{
List <MerchantDTO> list = new List <MerchantDTO>();
var data = dataContext.Merchants;
foreach (Merchant item in data)
{
list.Add(DTOConverter.ConvertMerchant(item));
}
return(list);
}
public MerchantDTO GetOne(int id)
{
MerchantDTO m = null;
var result = dataContext.Merchants.Where(x => x.MerchantID == id).FirstOrDefault();
if (result != null)
{
m = DTOConverter.ConvertMerchant(result);
}
return(m);
}
public ReservationItemDTO GetOneReservation(int id)
{
ReservationItemDTO item = null;
var data = dataContext.ReservationItems.Where(c => c.ID == id);
foreach (ReservationItem d in data)
{
item = DTOConverter.ConvertReservationItem(d);
var rData = dataContext.Reservers.Where(x => x.ItemID == item.ID);
List <ReserverDTO> reservers = new List <ReserverDTO>();
foreach (Reserver r in rData)
{
reservers.Add(DTOConverter.ConvertReserver(r));
}
item.Reservers = reservers;
break;
}
return(item);
}
