public bool AddReservationItem(ReservationItemDTO item) { int result = 0; result = dataContext.ExecuteCommand(string.Format(DataResource.SQL_AddReservationItem, item.ItemName, item.QuantityOrdered, item.RemainingUnreserved)); return(result > 0); }
public static ReservationItem ConvertReservationItem(ReservationItemDTO item) { return(new ReservationItem() { ID = item.ID, ItemName = item.ItemName, QuantityOrdered = item.QuantityOrdered, RemainingUnreserved = item.RemainingUnreserved }); }
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); }