public List <Entities.OrderInTime> GetAllOrdersInTime() { List <Entities.OrderInTime> listOrdersIT = new List <Entities.OrderInTime>(); using (TeamProjectEntities6 entities = new TeamProjectEntities6()) { var ordersIT = from r in entities.OrderInTime select r; foreach (OrderInTime singleOrderIT in ordersIT) { Entities.OrderInTime ot = new Entities.OrderInTime(); ot.OrderID = singleOrderIT.id; ot.TableID = int.Parse(singleOrderIT.id_Table.ToString()); ot.WaiterID = int.Parse(singleOrderIT.id_Waiter.ToString()); listOrdersIT.Add(ot); } } return(listOrdersIT); }
public List <Entities.Waiter> GetAllWaiters() { List <Entities.Waiter> listWaiters = new List <Entities.Waiter>(); using (TeamProjectEntities6 entities = new TeamProjectEntities6()) { var waiters = from r in entities.Waiter select r; foreach (Waiter singleWaiter in waiters) { Entities.Waiter w = new Entities.Waiter(); w.WaiterID = singleWaiter.id; w.WaiterName = singleWaiter.name_Waiter; w.WaiterSurname = singleWaiter.surname_Waiter; listWaiters.Add(w); } } return(listWaiters); }
public List <Entities.Table> GetAllTables() { List <Entities.Table> listTables = new List <Entities.Table>(); using (TeamProjectEntities6 entities = new TeamProjectEntities6()) { var tables = from r in entities.Table select r; foreach (Table singleTable in tables) { Entities.Table t = new Entities.Table(); t.TableID = singleTable.id; t.TableLabel = int.Parse(singleTable.label_Table); t.TableLocation = singleTable.location_Table; t.TablePlaces = (int)singleTable.places_Table; listTables.Add(t); } } return(listTables); }
public List <Entities.BludoInOrder> GetAllBludosInOrder() { List <Entities.BludoInOrder> listBludosIO = new List <Entities.BludoInOrder>(); using (TeamProjectEntities6 entities = new TeamProjectEntities6()) { var bludosIO = from r in entities.BludoInOrder select r; foreach (BludoInOrder singleBludoIO in bludosIO) { Entities.BludoInOrder bo = new Entities.BludoInOrder(); bo.OrderID = singleBludoIO.id; bo.BludoID = int.Parse(singleBludoIO.id_Bludo.ToString()); bo.BludoAmount = int.Parse(singleBludoIO.number_Bludo.ToString()); bo.BludoStatus = singleBludoIO.status; bo.OrderTime = DateTime.Parse(singleBludoIO.ordertime.ToString()); listBludosIO.Add(bo); } } return(listBludosIO); }
public List <Entities.Bludo> GetAllBludos() { List <Entities.Bludo> listBludos = new List <Entities.Bludo>(); using (TeamProjectEntities6 entities = new TeamProjectEntities6()) { var bludos = from r in entities.Bludo select r; foreach (Bludo singleBludo in bludos) { Entities.Bludo b = new Entities.Bludo(); b.BludoID = singleBludo.id; b.BludoName = singleBludo.name_Bludo; b.BludoPrice = decimal.Parse(singleBludo.price_Bludo.ToString()); b.BludoWeight = double.Parse(singleBludo.weight_Bludo.ToString()); b.BludoCategory = singleBludo.category_Bludo; //b.BludoTime = int.Parse(singleBludo.time_Bludo.ToString()); listBludos.Add(b); } } return(listBludos); }