Exemplo n.º 1
0
 public static bool Insert(int MenuItemID, decimal Price, int Quantity)
 {
     try
     {
         using (RoundTheCornerEntities rc = new RoundTheCornerEntities())
         {
             PL.TblOrderItem newRow = new TblOrderItem()
             {
                 OrderItemID = rc.TblOrderItems.Any() ? rc.TblOrderItems.Max(u => u.OrderItemID) + 1 : 1,
                 MenuItemId  = MenuItemID,
                 Price       = Price,
                 Quantity    = Quantity
             };
             rc.TblOrderItems.Add(newRow);
             rc.SaveChanges();
             return(true);
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Exemplo n.º 2
0
        public static bool Update(OrderItemModel orderItem)
        {
            try
            {
                if (orderItem.OrderItemID != 0)
                {
                    using (RoundTheCornerEntities rc = new RoundTheCornerEntities())
                    {
                        TblOrderItem tblOrderItem = rc.TblOrderItems.FirstOrDefault(u => u.OrderItemID == orderItem.OrderItemID);

                        if (tblOrderItem != null)
                        {
                            tblOrderItem.OrderItemID = orderItem.OrderItemID;
                            tblOrderItem.Price       = orderItem.Price;
                            tblOrderItem.MenuItemId  = orderItem.MenuItemID;
                            tblOrderItem.Quantity    = orderItem.Quantity;


                            rc.SaveChanges();
                            return(true);
                        }
                        else
                        {
                            throw new Exception("Item was not found");
                        }
                    }
                }
                else
                {
                    throw new Exception("Must have a valid id");
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Exemplo n.º 3
0
 public static bool Insert(OrderItemModel orderItem)
 {
     try
     {
         using (RoundTheCornerEntities rc = new RoundTheCornerEntities())
         {
             PL.TblOrderItem newRow = new TblOrderItem()
             {
                 OrderItemID = rc.TblOrderItems.Any() ? rc.TblOrderItems.Max(u => u.OrderItemID) + 1 : 1,
                 OrderID     = orderItem.OrderID,
                 MenuItemId  = orderItem.MenuItemID,
                 Price       = orderItem.Price,
                 Quantity    = orderItem.Quantity
             };
             rc.TblOrderItems.Add(newRow);
             rc.SaveChanges();
             return(true);
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }