Exemplo n.º 1
0
        // DELETE api/Orders/{id}
        public HttpResponseMessage DeleteOrder(int id)
        {
            using (var context = new AngularReduxDemoEntities())
            {
                var response = new HttpResponseMessage(HttpStatusCode.OK);

                try
                {
                    var order      = context.Orders.FirstOrDefault(x => x.Id == id);
                    var mealItems  = context.MealItems.Where(x => x.OrderId == id).ToList();
                    var drinkItems = context.DrinkItems.Where(x => x.OrderId == id).ToList();

                    context.MealItems.RemoveRange(mealItems);
                    context.SaveChanges();

                    context.DrinkItems.RemoveRange(drinkItems);
                    context.SaveChanges();

                    context.Orders.Remove(order);
                    context.SaveChanges();

                    return(response);
                }
                catch (Exception ex)
                {
                    return(new HttpResponseMessage(HttpStatusCode.BadRequest));
                }
            }
        }
Exemplo n.º 2
0
        // GET api/Tables/{id}/Orders
        public TableOrdersViewModel GetTableOrders(int id)
        {
            using (var context = new AngularReduxDemoEntities())
            {
                Table        table  = context.Tables.FirstOrDefault(x => x.Id == id);
                Server       server = context.Servers.FirstOrDefault(x => x.Id == table.ServerId);
                List <Order> orders = context.Orders.Where(x => x.TableId == id).ToList();
                List <OrderDetailViewModel> orderDetails = new List <OrderDetailViewModel>();
                foreach (Order order in orders)
                {
                    List <MealItem>             mealItems        = context.MealItems.Where(x => x.OrderId == order.Id).ToList();
                    List <OrderItemDomainModel> mealItemsDetails = new List <OrderItemDomainModel>();
                    foreach (MealItem item in mealItems)
                    {
                        var mealItemDetail = new OrderItemDomainModel
                        {
                            Id      = item.Id,
                            Name    = item.Name,
                            OrderId = item.OrderId
                        };
                        mealItemsDetails.Add(mealItemDetail);
                    }

                    List <DrinkItem>            drinkItems        = context.DrinkItems.Where(x => x.OrderId == order.Id).ToList();
                    List <OrderItemDomainModel> drinkItemsDetails = new List <OrderItemDomainModel>();
                    foreach (DrinkItem item in drinkItems)
                    {
                        var drinkItemDetail = new OrderItemDomainModel
                        {
                            Id      = item.Id,
                            Name    = item.Name,
                            OrderId = item.OrderId
                        };
                        drinkItemsDetails.Add(drinkItemDetail);
                    }

                    var orderDetail = new OrderDetailViewModel
                    {
                        Id         = order.Id,
                        TableId    = order.TableId,
                        ServerId   = order.ServerId,
                        MealItems  = mealItemsDetails,
                        DrinkItems = drinkItemsDetails
                    };
                    orderDetails.Add(orderDetail);
                }

                var tableOrdersDetails = new TableOrdersViewModel
                {
                    Id         = table.Id,
                    SectionId  = table.SectionId,
                    ServerId   = table.ServerId,
                    ServerName = server.Name,
                    Orders     = orderDetails
                };

                return(tableOrdersDetails);
            }
        }
Exemplo n.º 3
0
        // POST api/Orders
        public async Task <HttpResponseMessage> PostOrder([FromBody] OrderDetailViewModel order)
        {
            using (var context = new AngularReduxDemoEntities())
            {
                var response = new HttpResponseMessage(HttpStatusCode.OK);

                try
                {
                    Order newOrder = new Order
                    {
                        TableId  = order.TableId,
                        ServerId = order.ServerId
                    };
                    context.Orders.Add(newOrder);
                    await Task.Run(() => context.SaveChanges());

                    List <MealItem> mealItems = new List <MealItem>();
                    foreach (OrderItemDomainModel item in order.MealItems)
                    {
                        var mealItem = new MealItem
                        {
                            Name    = item.Name,
                            OrderId = newOrder.Id
                        };
                        mealItems.Add(mealItem);
                    }
                    context.MealItems.AddRange(mealItems);
                    context.SaveChanges();

                    List <DrinkItem> drinkItems = new List <DrinkItem>();
                    foreach (OrderItemDomainModel item in order.DrinkItems)
                    {
                        var drinkItem = new DrinkItem
                        {
                            Name    = item.Name,
                            OrderId = newOrder.Id
                        };
                        drinkItems.Add(drinkItem);
                    }
                    context.DrinkItems.AddRange(drinkItems);
                    context.SaveChanges();

                    return(response);
                }
                catch (Exception ex)
                {
                    return(new HttpResponseMessage(HttpStatusCode.BadRequest));
                }
            }
        }
Exemplo n.º 4
0
 // GET api/Servers
 public IEnumerable <ServerDomainModel> GetSections()
 {
     using (var context = new AngularReduxDemoEntities())
     {
         List <Server> servers = context.Servers.Select(x => x).ToList();
         IEnumerable <ServerDomainModel> serverList = new List <ServerDomainModel>();
         serverList = from server in servers
                      select new ServerDomainModel
         {
             Id         = server.Id,
             Name       = server.Name,
             TableCount = server.TableCount
         };
         return(serverList);
     }
 }
Exemplo n.º 5
0
        // PUT api/Sections/{id}/Update
        public HttpResponseMessage UpdateSection(int id, [FromBody] CountChange tableCountChange)
        {
            using (var context = new AngularReduxDemoEntities())
            {
                var response = new HttpResponseMessage(HttpStatusCode.OK);

                try
                {
                    var section = context.Sections.FirstOrDefault(x => x.Id == id);
                    section.TableCount += Convert.ToInt32(tableCountChange.change);
                    context.SaveChanges();
                    return(response);
                }
                catch (Exception ex)
                {
                    return(new HttpResponseMessage(HttpStatusCode.BadRequest));
                }
            }
        }
Exemplo n.º 6
0
        // GET api/Sections
        public IEnumerable <SectionDetailViewModel> GetSections()
        {
            using (var context = new AngularReduxDemoEntities())
            {
                List <Section> sections = context.Sections.Select(x => x).ToList();
                List <SectionDetailViewModel> sectionList = new List <SectionDetailViewModel>();

                foreach (var section in sections)
                {
                    List <Table> tables = context.Tables.Where(x => x.SectionId == section.Id).ToList();
                    List <TableDetailViewModel> tableList = new List <TableDetailViewModel>();
                    foreach (var table in tables)
                    {
                        Server               server      = context.Servers.FirstOrDefault(x => x.Id == table.ServerId);
                        List <Order>         orders      = context.Orders.Where(x => x.TableId == table.Id).ToList();
                        TableDetailViewModel tableDetail = new TableDetailViewModel
                        {
                            Id         = table.Id,
                            SectionId  = table.SectionId,
                            ServerId   = table.ServerId,
                            ServerName = server.Name,
                            OrderIds   = orders.Select(x => x.Id).ToList()
                        };
                        tableList.Add(tableDetail);
                    }
                    SectionDetailViewModel sectionDetail = new SectionDetailViewModel
                    {
                        Id         = section.Id,
                        Name       = section.Name,
                        TableCount = section.TableCount,
                        Tables     = tableList
                    };
                    sectionList.Add(sectionDetail);
                }

                return(sectionList);
            }
        }
Exemplo n.º 7
0
        // POST api/Tables
        public HttpResponseMessage PostTable([FromBody] TableDomainModel table)
        {
            using (var context = new AngularReduxDemoEntities())
            {
                var response = new HttpResponseMessage(HttpStatusCode.OK);

                try
                {
                    Table newTable = new Table
                    {
                        SectionId = table.SectionId,
                        ServerId  = table.ServerId
                    };
                    context.Tables.Add(newTable);
                    context.SaveChanges();
                    return(response);
                }
                catch (Exception ex)
                {
                    return(new HttpResponseMessage(HttpStatusCode.BadRequest));
                }
            }
        }