Exemplo n.º 1
0
 public ActionResult addShippingAddress(DetailOrderModel detailOrderModel)
 {
     try
     {
         if (detailOrderModel.ShippingAddress != null && detailOrderModel.OrderID > 0)
         {
             Country country = countryService.GetByPrimaryKey(SNumber.ToNumber(detailOrderModel.ShippingAddress.CountryID));
             if (country != null)
             {
                 detailOrderModel.ShippingAddress.CountryName = country.CountryName;
             }
             int shippingAddressID = shippingAddressService.Insert(detailOrderModel.ShippingAddress);
             if (shippingAddressID > 0)
             {
                 TblOrder order = orderService.GetByPrimaryKey(detailOrderModel.OrderID);
                 order.ShippingAddressID = shippingAddressID;
                 order.ModifiedDateTime  = SDateTime.GetYYYYMMddHmmSSNow();
                 if (orderService.Update(order))
                 {
                     return(RedirectToAction("detail", "orders", new { id = detailOrderModel.OrderID, strMessage = "addShippingAddress1" }));
                 }
             }
         }
         return(RedirectToAction("detail", "orders", new { id = detailOrderModel.OrderID, strMessage = "addShippingAddress0" }));
     }
     catch (Exception ex)
     {
         LogService.WriteException(ex);
         return(RedirectToAction("detail", "orders", new { id = detailOrderModel.OrderID, strMessage = "addShippingAddress0" }));
     }
 }
Exemplo n.º 2
0
        public long Update(OrderModel entity)
        {
            TblOrder obj = _mapper.Map <OrderModel, TblOrder>(entity);

            _repository.Update(obj);
            return(obj.OrderId);
        }
Exemplo n.º 3
0
 public bool Update(TblOrder order)
 {
     try
     {
         string query = "update TblOrder set OrderNote = @OrderNote, OrderStatus = @OrderStatus, CustomerEmail = @CustomerEmail," +
                        " CustomerID=@CustomerID,ModifiedDateTime=@ModifiedDateTime,TotalCount=@TotalCount,TotalShipping=@TotalShipping," +
                        " ShippingStatus = @ShippingStatus, BillingStatus = @BillingStatus, Number = @Number, ShippingAddressID = @ShippingAddressID, BillingAddressID = @BillingAddressID, Tags = @Tags " +
                        " where OrderID = @OrderID ";
         return(0 < connect.Execute(query, new
         {
             order.OrderNote,
             order.OrderStatus,
             order.CustomerEmail,
             order.CustomerID,
             order.ModifiedDateTime,
             order.TotalCount,
             order.TotalShipping,
             order.ShippingStatus,
             order.BillingStatus,
             order.Number,
             order.ShippingAddressID,
             order.BillingAddressID,
             order.Tags,
             OrderID = order.OrderID
         }));
     }
     catch (Exception ex)
     {
         LogService.WriteException(ex);
         return(false);
     }
 }
Exemplo n.º 4
0
 public int GetQuantityInOrder(int orderID)
 {
     try
     {
         LineItemService lineItemService = new LineItemService();
         int             quantity        = 0;
         TblOrder        order           = GetByPrimaryKey(orderID);
         if (order != null)
         {
             List <LineItem> cartItems = lineItemService.GetByOrderID(orderID);
             if (cartItems != null && cartItems.Count > 0)
             {
                 foreach (var item in cartItems)
                 {
                     quantity += item.Quantity;
                 }
             }
         }
         return(quantity);
     }
     catch (Exception ex)
     {
         LogService.WriteException(ex);
         return(0);
     }
 }
Exemplo n.º 5
0
        public static OrderModel Insert(OrderModel order)
        {
            try
            {
                using (RoundTheCornerEntities rc = new RoundTheCornerEntities())
                {
                    PL.TblOrder newRow = new TblOrder()
                    {
                        OrderID   = rc.TblOrders.Any() ? rc.TblOrders.Max(u => u.OrderID) + 1 : 1,
                        VendorID  = order.VendorID,
                        UserID    = order.UserID,
                        OrderDate = order.OrderDate
                    };

                    order.OrderID = newRow.OrderID;
                    rc.TblOrders.Add(newRow);
                    rc.SaveChanges();
                    return(order);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Exemplo n.º 6
0
 public int Insert(TblOrder order)
 {
     try
     {
         string query = "insert into TblOrder(OrderNote,OrderStatus,CustomerEmail," +
                        " CustomerID,CreatedDateTime,ModifiedDateTime,TotalCount,TotalShipping,ShippingStatus," +
                        " BillingStatus,Number,ShippingAddressID,BillingAddressID,Tags)" +
                        " values (@OrderNote,@OrderStatus,@CustomerEmail,@CustomerID,@CreatedDateTime,@ModifiedDateTime,@TotalCount,@TotalShipping,@ShippingStatus," +
                        " @BillingStatus,@Number,@ShippingAddressID,@BillingAddressID,@Tags)" +
                        " SELECT @@IDENTITY";
         int orderID = connect.Query <int>(query, new
         {
             order.OrderNote,
             order.OrderStatus,
             order.CustomerEmail,
             order.CustomerID,
             order.CreatedDateTime,
             order.ModifiedDateTime,
             order.TotalCount,
             order.TotalShipping,
             order.ShippingStatus,
             order.BillingStatus,
             order.Number,
             order.ShippingAddressID,
             order.BillingAddressID,
             order.Tags
         }).Single();
         return(orderID);
     }
     catch (Exception ex)
     {
         LogService.WriteException(ex);
         return(0);
     }
 }
Exemplo n.º 7
0
 public string deliveryLineItem(int id)
 {
     try
     {
         TblOrder order = orderService.GetByPrimaryKey(id);
         if (order != null)
         {
             order.ShippingStatus   = "fulfilled";
             order.ModifiedDateTime = SDateTime.GetYYYYMMddHmmSSNow();
             if (orderService.Update(order))
             {
                 List <LineItem> lineItems = lineItemService.GetByOrderID(id);
                 if (lineItems != null && lineItems.Count > 0)
                 {
                     foreach (var item in lineItems)
                     {
                         item.ShippingStatus = Common.Fulfilled;
                         lineItemService.Update(item);
                     }
                 }
                 return("delivery1");
             }
         }
         return("delivery0");
     }
     catch (Exception ex)
     {
         LogService.WriteException(ex);
     }
     return("delivery0");
 }
Exemplo n.º 8
0
 public string billingOrder(int id)
 {
     try
     {
         TblOrder order = orderService.GetByPrimaryKey(id);
         if (order != null)
         {
             order.BillingStatus    = "paid";
             order.ModifiedDateTime = SDateTime.GetYYYYMMddHmmSSNow();
             if (orderService.Update(order))
             {
                 if (SNumber.ToNumber(order.CustomerID) > 0)
                 {
                     Customer customer = customerService.GetByPrimaryKey(SNumber.ToNumber(order.CustomerID));
                     customer.TotalCount      += order.TotalCount;
                     customer.TotalOrder      += 1;
                     customer.ModifiedDateTime = SDateTime.GetYYYYMMddHmmSSNow();
                     customerService.Update(customer);
                 }
                 return("bill1");
             }
         }
         return("bill0");
     }
     catch (Exception ex)
     {
         LogService.WriteException(ex);
     }
     return("bill0");
 }
Exemplo n.º 9
0
        public async Task <TblOrder> AddOrder(TblOrder tblOrder)
        {
            await _context.TblOrder.AddAsync(tblOrder);

            await _context.SaveChangesAsync();

            return(tblOrder);
        }
Exemplo n.º 10
0
        public ActionResult ActiveOrder(int id)
        {
            TblOrder tbldetail = db.TblOrder.Find(id);

            tbldetail.Status = true;
            db.SaveChanges();
            return(View());
        }
        public TblPerson GetPerson([FromBody] TblOrder order)
        {
            var findUser = _ctx.TblOrder.FirstOrDefault(x => x.OrderId == order.OrderId);

            var person = _ctx.TblPerson.FirstOrDefault(x => x.PersonId == findUser.PersonID);

            return(person);
        }
        public IActionResult Checkout()
        {
            if (!ModelState.IsValid)
            {
                return(View("Cart"));
            }
            var rawUser  = HttpContext.Session.GetString("USER");
            var user     = JsonConvert.DeserializeObject <TblUser>(rawUser);
            var products = GetCartItems(); //get products in cart session


            var newOrder = new TblOrder();

            newOrder.CreatedDate = DateTime.Now;
            newOrder.IdUser      = user.Id;
            newOrder.Payment     = "COD";
            newOrder.Status      = "Pending";

            _context.TblOrder.Add(newOrder);
            _context.SaveChanges();

            foreach (var product in products)
            {
                var orderDetail = new TblOrderDetail();

                orderDetail.IdOrder        = newOrder.Id;
                orderDetail.IdProduct      = product.product.Id;
                orderDetail.BoughtQuantity = product.quantity;

                //Update quantity
                var boughtItem = _context.TblProduct.Where(item => item.Id == product.product.Id).FirstOrDefault();
                if (boughtItem.Quantity < product.quantity || product.quantity < 0)
                {
                    if (product.quantity < 0)
                    {
                        TempData["ErrorQtt"] = "Quantity > 0 ";
                    }
                    else
                    {
                        TempData["ErrorQtt"] = "Not enough quantity for " + boughtItem.Name;
                    }
                    return(RedirectToAction("Cart", "Products"));
                }
                boughtItem.Quantity = Convert.ToInt32(boughtItem.Quantity - product.quantity);
                _context.TblProduct.Update(boughtItem);

                orderDetail.Tax = 10; //default
                _context.TblOrderDetail.Add(orderDetail);
            }

            _context.SaveChanges();

            SaveCartSession(new List <CartItem>());

            TempData["success"] = "Order successfully";

            return(RedirectToAction("Cart"));
        }
Exemplo n.º 13
0
        /*
         * //This code was to try to send multiple cartlines to database; it did not work.
         * public JsonResult AddOrder(List<TblOrder> items)
         * {
         * foreach (var item in items)
         * {
         *     repository.Add(item);
         * }
         * return Json(items, JsonRequestBehavior.AllowGet);
         * }
         */
        public JsonResult EditOrder(int id, TblOrder product)
        {
            product.Id = id;
            if (repository.Update(product))
            {
                return(Json(repository.GetAll(), JsonRequestBehavior.AllowGet));
            }

            return(Json(null));
        }
Exemplo n.º 14
0
        public long InsertOrder(OrderShipModel order)
        {
            long     res    = 0;
            TblOrder entity = new TblOrder();
            CommonDa da     = new CommonDa();

            entity.DEL_FLG = DeleteFlag.NON_DELETE;
            entity.USER_ID = CmnEntityModel.USER_ID;
            int maxOrder = da.getMaxOrder(entity.USER_ID) + 1;

            entity.SHIP_CODE         = "T" + CmnEntityModel.USER_ID.ToString("D4") + maxOrder.ToString("D7");
            entity.PRODUCT_NAME      = order.PRODUCT_NAME;
            entity.PRODUCT_TYPE      = order.PRODUCT_TYPE;
            entity.CREATE_DATE       = UtilityService.Utility.GetCurrentDateTime();
            entity.PRODUCT_WEIGHT    = order.PRODUCT_WEIGHT.HasValue? order.PRODUCT_WEIGHT.Value : 0;
            entity.RECEIVED_NAME     = order.RECEIVED_NAME;
            entity.RECEIVED_PHONE    = order.RECEIVED_PHONE;
            entity.RECEIVED_CITY     = order.RECEIVED_CITY;
            entity.RECEIVED_DISTRICT = order.RECEIVED_DISTRICT;
            entity.RECEIVED_TOWN     = order.RECEIVED_TOWN;
            entity.RECEIVED_ADDRESS  = order.RECEIVED_ADDRESS;
            entity.RECEIVE_HOUR_FROM = order.RECEIVE_HOUR_FROM;
            entity.RECEIVE_HOUR_TO   = order.RECEIVE_HOUR_TO;
            entity.RECEIVE_TIME_DATE = order.RECEIVE_TIME_DATE;
            entity.SHIP_TYPE         = order.SHIP_TYPE;
            entity.PRICE_PRODUCT     = order.PRICE_PRODUCT.HasValue ? order.PRICE_PRODUCT.Value : 0;
            entity.PRICE_SHIP        = order.PRICE_SHIP;
            entity.DISCOUNT          = order.DISCOUNT;
            entity.USER_PAYMENT      = order.USER_PAYMENT;
            entity.ORDER_STATUS      = OrderStatus.Create;
            entity.OTHER_REQUIREMENT = order.OTHER_REQUIREMENT;
            entity.PRODUCT_HEIGHT    = order.PRODUCT_HEIGHT.HasValue ? order.PRODUCT_HEIGHT.Value : 0;
            entity.PRODUCT_LENGTH    = order.PRODUCT_LENGTH.HasValue ? order.PRODUCT_LENGTH.Value : 0;
            entity.PRODUCT_WIDTH     = order.PRODUCT_WIDTH.HasValue ? order.PRODUCT_WIDTH.Value : 0;

            // Declare new DataAccess object
            OrderShipDa dataAccess = new OrderShipDa();

            using (var transaction = new TransactionScope())
            {
                res = dataAccess.InsertOrder(entity);
                if (res <= 0)
                {
                    transaction.Dispose();
                }

                if (res > 0)
                {
                    res = da.getShipID(entity.SHIP_CODE);

                    transaction.Complete();
                }
            }
            return(res);
        }
        public JsonResult SendOrder([FromBody] TblOrder order)
        {
            var value = (HttpContext.Session.GetString("Varukorg"));

            var cookie = Request.Cookies["User"];

            var person = Convert.ToInt32(cookie);

            if (value != null)
            {
                FoodList = JsonConvert.DeserializeObject <List <TblPizza> >(value);

                int?newOrderId = _ctx.TblOrder.Max(x => (int?)x.OrderId);
                newOrderId++;
                var addToOrder = new TblOrder
                {
                    OrderId     = newOrderId ?? 1,
                    Delivered   = false,
                    Date        = DateTime.Now,
                    TotalAmount = order.TotalAmount,
                    CardOrCash  = order.CardOrCash,
                    PersonID    = person
                };

                _ctx.TblOrder.Add(addToOrder);
                _ctx.SaveChanges();

                foreach (var items in FoodList)
                {
                    int?newOrderInfoId = _ctx.TblOrderInfo.Max(x => (int?)x.OrderInfoId);
                    newOrderInfoId++;
                    var addToOrderInfo = new TblOrderInfo
                    {
                        OrderId     = newOrderId ?? 1,
                        OrderInfoId = (int)newOrderInfoId,
                        PizzaId     = items.PizzaId,
                        AmountPerId = items.Price,
                        CategoryId  = items.CategoryId,
                        Ordered     = DateTime.Now,
                        Name        = items.Name
                    };
                    _ctx.TblOrderInfo.Add(addToOrderInfo);
                    _ctx.SaveChanges();
                }

                foreach (var item in FoodList) //Raderar efter köp
                {
                    FoodList.Remove(item);
                }

                return(Json(new { result = "Success" }));
            }

            return(Json(new { result = "Fail" }));
        }
Exemplo n.º 16
0
        public bool Delete(int id)
        {
            // TO DO : Code to remove the records from database

            TblOrder orders = OrderDb.TblOrders.Find(id);

            OrderDb.TblOrders.Remove(orders);
            OrderDb.SaveChanges();

            return(true);
        }
Exemplo n.º 17
0
        public bool AddOrder(TblOrder Order)
        {
            string StoreProc = "spAddOrder";

            object[] parms =
            {
                "@CustomerID", Order.CustomerID,
                "@EmployeeID", Order.EmployeeID,
                "@TotalPrice", Order.TotalPrice
            };
            return(db.Update(StoreProc, parms) > 0);
        }
Exemplo n.º 18
0
        public IGernalResult AddOrder(OrderDto dto)
        {
            IGernalResult result = new GernalResult();

            try
            {
                int totalplaceOrderquantiy = 0;

                TblItem         Item  = _dbContext.TblItem.Where(w => w.Id == dto.ItemId).FirstOrDefault();
                List <TblOrder> order = _dbContext.TblOrder.Where(w => w.ItemId == dto.ItemId && w.IsCanceled == false).ToList();
                if (order != null)
                {
                    foreach (var item in order)
                    {
                        int v = item.Quantity + totalplaceOrderquantiy;
                        totalplaceOrderquantiy = v;
                    }
                }
                int avilableNow = Convert.ToInt32(Item.Quantity) - totalplaceOrderquantiy;
                if (totalplaceOrderquantiy == Convert.ToInt32(Item.Quantity))
                {
                    result.Succsefully = false;
                    result.Message     = "Item not availablenow plz try some time later.";
                }
                else if (avilableNow < dto.Quantity)
                {
                    result.Succsefully = false;
                    result.Message     = "Now we have avilable only" + avilableNow;
                }
                else
                {
                    TblOrder Order = new TblOrder
                    {
                        IsCanceled   = false,
                        OrderDate    = DateTime.UtcNow,
                        UserId       = dto.UserId,
                        ItemId       = dto.ItemId,
                        PricePerItem = Convert.ToInt32(Item.Price),
                        PriceTotal   = Convert.ToInt32(Item.Price) * dto.Quantity,
                    };
                    _dbContext.Add(Order);
                    int save = _dbContext.SaveChanges();
                    result.Message     = save > 0 ? "Order add Succsefully" : "Order not add";
                    result.Succsefully = save > 0 ? true : false;
                }
            }
            catch
            {
                result.Message     = "server error";
                result.Succsefully = false;
            }
            return(result);
        }
Exemplo n.º 19
0
        public ActionResult Detail(int id)
        {
            TblOrder tbldetail = db.TblOrder.Find(id);

            tbldetail.Status = true;
            db.SaveChanges();

            string chuoi = "";

            chuoi += "<table align=\"left\" cellpadding=\"2\">";
            chuoi += "<tr class=\"top\">";
            chuoi += "<td class=\"Name\">Tên sản phẩm</td>";
            chuoi += "<td class=\"Price\">Đơn giá</td>";
            chuoi += "<td class=\"Ord\">SL</td>";
            chuoi += "<td class=\"PriceSale\">Thành tiền</td>";
            chuoi += "</tr>";
            var listOrrder = db.TblOrderDetail.Where(p => p.IdOrder == id).ToList();

            for (int i = 0; i < listOrrder.Count; i++)
            {
                chuoi += "<tr class=\"row" + listOrrder[i].Id + "\" >";
                chuoi += "<td class=\"Name\" >";
                int idPro   = int.Parse(listOrrder[i].IdProduct.ToString());
                var product = db.TblProduct.Find(idPro);
                chuoi += "<a href=\"/San-pham/" + product.Tag + "\" title=\"" + product.Name + "\" target=\"_blank\" id=\"UpdateOrd" + product.Id + "\"><img src=\"" + product.ImageLinkThumb + "\" alt=\"" + product.Name + "\" title=\"" + product.Name + "\" /></a>";
                chuoi += "<a href=\"/San-pham/" + product.Tag + "\" title=\"" + product.Name + "\" target=\"_blank\" class=\"Namepd\">" + product.Name + "</a>";
                chuoi += "</td>";
                chuoi += "<td class=\"Price\"><span>" + string.Format("{0:#,#}", listOrrder[i].Price) + " vnđ</span></td>";
                chuoi += "<td class=\"Ord\"><input type=\"number\" name=\"Ord\"  class=\"txtOrd" + listOrrder[i].Id + "\" value=\"" + listOrrder[i].Quantily + "\"  /></td>";
                chuoi += "<td class=\"PriceSale\"><span id=\"Gia" + listOrrder[i].Id + "\">" + string.Format("{0:#,#}", listOrrder[i].SumPrice) + " vnđ</span></td>";
                chuoi += "</tr>";
            }

            chuoi += "</table>";
            chuoi += "  <div class=\"Sum\">";
            chuoi += "  <div class=\"LeftSUM\">";
            chuoi += "      <span>Bạn có <span class=\"count\">" + listOrrder.Count + "</span> sản phẩm trong giỏ hàng</span>";
            chuoi += " </div>";
            chuoi += " <div class=\"RightSUM\">";
            chuoi += "  <span class=\"Sum1\">Tổng cộng :  <span class=\"tt\">" + string.Format("{0:#,#}", db.TblOrder.Find(id).Tolar) + "</span> vnđ </span>";
            chuoi += "  <span class=\"Sum2\">Thành tiền: <span class=\"tt\">" + string.Format("{0:#,#}", db.TblOrder.Find(id).Tolar) + "</span> vnđ </span>";
            chuoi += "  </div>";


            chuoi += "</div>";
            chuoi += "<div class=\"OrderNows\">";



            chuoi        += "  </div>";
            ViewBag.chuoi = chuoi;
            return(View(db.TblOrder.Find(id)));
        }
Exemplo n.º 20
0
        public TblOrder Add(TblOrder item)
        {
            if (item == null)
            {
                throw new ArgumentNullException("item");
            }
            // TO DO : Code to save record into database
            ProductsDbEntities OrderDb = new ProductsDbEntities();

            OrderDb.TblOrders.Add(item);
            OrderDb.SaveChanges();
            return(item);
        }
Exemplo n.º 21
0
        public long Insert(OrderModel entity)
        {
            TblOrder obj = _mapper.Map <OrderModel, TblOrder>(entity);

            obj.OrderNo       = "";
            obj.Day           = entity.OrderDate.Day;
            obj.Month         = entity.OrderDate.Month;
            obj.Year          = entity.OrderDate.Year;
            obj.SequenceNo    = 0;
            obj.OrderStatusId = (short)Enums.OrderStatus.Pending;
            _repository.Insert(obj);
            return(obj.OrderId);
        }
Exemplo n.º 22
0
        public ActionResult thankyou(int id)
        {
            try
            {
                TblOrder order = orderService.GetByPrimaryKey(id);
                if (order == null)
                {
                    return(RedirectToAction("index", "cart"));
                }

                List <LineItem> lineItems = lineItemService.GetByOrderID(order.OrderID);
                foreach (var item in lineItems)
                {
                    if (item.VariantName == "Default Title")
                    {
                        var thumb = ImageService.GetPathImageFirstOfProduct(item.ProductID);
                        item.ImageUrl = thumb;
                    }
                    else
                    {
                        Variant variant = variantService.GetByPrimaryKey(item.VariantID);
                        if (variant != null)
                        {
                            TblImage image = imageService.GetByPrimaryKey(variant.ImageID);
                            if (image != null)
                            {
                                item.ImageUrl = image.ImageUrl;
                            }
                        }
                    }
                }

                ThankyouViewModel thankyouViewModel = new ThankyouViewModel();
                thankyouViewModel.CustomerEmail     = order.CustomerEmail;
                thankyouViewModel.LineItems         = lineItems;
                thankyouViewModel.ShippingAddressID = order.ShippingAddressID;
                thankyouViewModel.ShippingAddress   = shippingAddressService.GetByPrimaryKey(thankyouViewModel.ShippingAddressID == null ? 0 : thankyouViewModel.ShippingAddressID.Value);
                thankyouViewModel.BillingAddresID   = order.BillingAddressID;
                thankyouViewModel.BillingAddress    = billingAddressService.GetByPrimaryKey(thankyouViewModel.BillingAddresID == null ? 0 : thankyouViewModel.BillingAddresID.Value);
                thankyouViewModel.TotalSubPrice     = order.TotalCount;
                thankyouViewModel.TotalShipping     = order.TotalShipping;
                thankyouViewModel.TotalPrice        = order.TotalCount + order.TotalShipping;
                return(View(thankyouViewModel));
            }
            catch (Exception ex)
            {
                LogService.WriteException(ex);
                throw;
            }
        }
Exemplo n.º 23
0
 public TblOrder GetByPrimaryKey(int orderID)
 {
     try
     {
         string   query    = "select * from TblOrder where OrderID = " + orderID;
         TblOrder tblOrder = connect.Query <TblOrder>(query).FirstOrDefault <TblOrder>();
         return(tblOrder);
     }
     catch (Exception ex)
     {
         LogService.WriteException(ex);
         return(null);
     }
 }
        public JsonResult IsDelivered([FromBody] TblOrder order)
        {
            if (order != null)
            {
                var findOrder = _ctx.TblOrder.FirstOrDefault(x => x.OrderId == order.OrderId);

                findOrder.Delivered = true;

                _ctx.TblOrder.Update(findOrder);
                _ctx.SaveChanges();

                return(Json(new { result = "Success" }));
            }

            return(Json(new { result = "Fail" }));
        }
Exemplo n.º 25
0
        private void LoadGridOrder(int selectedIndex = -1)
        {
            TblOrder tbl = new TblOrder(_unitOfWork, _orderSearch);

            this.gridOrder.DataSource = tbl;
            if (selectedIndex < 0)
            {
                this.gridOrder.ClearSelection();
                this.EnableOrderButton(false);
            }
            else
            {
                this.gridOrder.Rows[selectedIndex].Selected = true;
            }
            SetUpGridOrder();
        }
Exemplo n.º 26
0
        public IGernalResult CancelOrder(int orderId)
        {
            IGernalResult result = new GernalResult();

            try
            {
                TblOrder order = _dbContext.TblOrder.Where(w => w.Id == orderId).FirstOrDefault();
                order.IsCanceled = true;
                int save = _dbContext.SaveChanges();
                result.Message     = save > 0 ? "Order cancel Succsefully" : "Order not cancel";
                result.Succsefully = save > 0 ? true : false;
            }
            catch
            {
                result.Message     = "server error";
                result.Succsefully = false;
            }
            return(result);
        }
Exemplo n.º 27
0
        public ActionResult DeleteOrder(int id)
        {
            if (ClsCheckRole.CheckQuyen(12, 3, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true)
            {
                TblOrder TblOrder = db.TblOrder.Find(id);
                var      result   = string.Empty;
                db.TblOrder.Remove(TblOrder);
                db.SaveChanges();

                result = "Bạn đã xóa thành công.";
                return(Json(new { result = result }));
            }
            else
            {
                var result = string.Empty;
                result = "Bạn không có quyền thay đổi tính năng này";
                return(Json(new { result = result }));
            }
        }
Exemplo n.º 28
0
        public bool Update(TblOrder item)
        {
            if (item == null)
            {
                throw new ArgumentNullException("item");
            }

            // TO DO : Code to update record into database

            var orders = OrderDb.TblOrders.Single(a => a.Id == item.Id);

            orders.Product  = item.Product;
            orders.Category = item.Category;
            orders.Subtotal = item.Subtotal;
            orders.Quantity = item.Quantity;
            OrderDb.SaveChanges();

            return(true);
        }
Exemplo n.º 29
0
        public async Task GivenAValidOrder_WhenIPostANewOrder_ThenItReturnsOkWithResponse()
        {
            TblOrder expectedorder = new TblOrder
            {
                ACustomerId  = 3,
                AMovieId     = 18,
                ARentalOrNot = false,
                AOrderedDate = DateTime.Now
            };

            //Arrange

            _mockOrderMapper.Setup(mapper => mapper.Map <TblOrder>(It.IsAny <OrderForMappingDto>()))
            .Returns(expectedorder);


            _mockOrderRepository.Setup(repo => repo.AddOrder(It.IsAny <TblOrder>()))
            .ReturnsAsync((TblOrder order) => order);

            var SUT = new OrdersController(_mockOrderRepository.Object, _mockOrderMapper.Object);

            //Act
            var contentResult = await SUT.AddOrder(new OrderForMappingDto
            {
                ACustomerId  = 3,
                AMovieId     = 18,
                ARentalOrNot = false,
                AOrderedDate = DateTime.Now
            });

            var okResult = contentResult as OkObjectResult;

            //Assert
            Assert.AreEqual(200, okResult.StatusCode);
            Assert.NotNull(contentResult);
            Assert.IsAssignableFrom <OkObjectResult>(contentResult);

            var result = ((OkObjectResult)contentResult).Value;

            Assert.NotNull(result);
            Assert.IsAssignableFrom <TblOrder>(result);
            Assert.AreEqual(result, expectedorder);
        }
Exemplo n.º 30
0
        public ActionResult detail(DetailOrderModel detailOrderModel)
        {
            try
            {
                if (detailOrderModel != null)
                {
                    TblOrder order = orderService.GetByPrimaryKey(detailOrderModel.OrderID);
                    order.OrderNote = detailOrderModel.OrderNote;
                    order.Tags      = detailOrderModel.Tags;
                    if (orderService.Update(order))
                    {
                        string orderName = "#" + (Common.BaseNumberOrder + order.Number).ToString();
                        LogService.WriteLog2DB(accountService.GetUserId(User.Identity.GetUserName()), (int)Common.ActionID.Update, detailOrderModel.OrderID, SDateTime.GetYYYYMMddHmmSSNow(), General.GetIPAddress(), TableNameID, orderName);

                        if (!string.IsNullOrEmpty(detailOrderModel.Tags))
                        {
                            string[] tags = detailOrderModel.Tags.Split(',');
                            foreach (var item in tags)
                            {
                                if (!tagService.CheckExistTag(item, (int)Common.TableName.TblOrder))
                                {
                                    Tag tag = new Tag();
                                    tag.TagName     = item;
                                    tag.TableNameID = (int)Common.TableName.TblOrder;

                                    int tagID = tagService.Insert(tag);
                                }
                            }
                        }
                        return(RedirectToAction("detail", "orders", new { id = detailOrderModel.OrderID, strMessage = "update1" }));
                    }
                }
                return(RedirectToAction("detail", "orders", new { id = detailOrderModel.OrderID, strMessage = "update0" }));
            }
            catch (Exception ex)
            {
                LogService.WriteException(ex);
                return(RedirectToAction("detail", "orders", new { id = detailOrderModel.OrderID, strMessage = "update0" }));
            }
        }