Exemple #1
0
        public List <Models.MOrderViewOfPayment> ShowClientOrderViewForPayment()
        {
            COrders      co  = new COrders();
            COrderOnline col = new COrderOnline();
            CClients     cc  = new CClients();
            List <Models.MOrderViewOfPayment> ClientPayments = new List <Models.MOrderViewOfPayment>();
            List <Models.MPayments>           Payments       = this.GetAll();
            List <Models.MOrders>             Orders         = co.GetAll();

            List <Models.MOrdersLine> OrderLine = col.GetAll();

            var query = from o in Payments
                        where o.OrderId != 0 &&
                        o.VendorId == -1 &&
                        o.ClientId != -1 &&
                        o.Paymentstate != Common.Constants.PaymentState.Paid.ToString()
                        select o;

            foreach (var item in query)
            {
                Models.MOrderViewOfPayment mop = new Models.MOrderViewOfPayment();
                mop.PaymentId = item.id.ToString();
                mop.ClientId  = item.ClientId.ToString();
                string clientName = cc.ReturnClientNameById(mop.ClientId);
                string OrderId    = item.OrderId.ToString();
                mop.OrderId = item.OrderId.ToString();
                string OrderDate = (from o in Orders
                                    where o.id == OrderId
                                    select o.Orderdate).FirstOrDefault();
                mop.OrderDate = OrderDate;
                mop.OrderName = (from o in Orders
                                 where o.id == OrderId
                                 select o.OrderName).FirstOrDefault();
                mop.OrderCode = (from o in Orders
                                 where o.id == OrderId
                                 select o.OrdersNo).FirstOrDefault();
                mop.PaidAmount = item.Paid;
                mop.TotalCost  = item.TotalCost;
                mop.ClientName = clientName;
                ClientPayments.Add(mop);
            }

            return(ClientPayments);
        }
            public List <Models.MViewModels.MViewOrderDetails> GetAllDetails(int OrderId)
            {
                List <Models.MViewModels.MViewOrderDetails> OrderDetails = new List <Models.MViewModels.MViewOrderDetails>();
                List <Models.MOrdersLine> OrderLine = new List <Models.MOrdersLine>();

                Models.MViewModels.MViewOrderDetails mvo = new Models.MViewModels.MViewOrderDetails();
                Classes.COrderOnline coo = new COrderOnline();
                Classes.COrders      co  = new COrders();
                Classes.CProducts    cp  = new CProducts();
                OrderLine = coo.GetAll();
                OrderLine = OrderLine.Where(o => o.OrderId == OrderId.ToString()).ToList();
                for (int i = 0; i < OrderLine.Count; i++)
                {
                    mvo = new Models.MViewModels.MViewOrderDetails();
                    string CurrentProductPrice = string.Empty, ProductName = string.Empty;
                    ProductName = cp.GetProductNameWithTagsById(Convert.ToInt32(OrderLine[i].ProductId));
                    string OrderType = co.ReturnOrderTypeById(OrderId);
                    switch (OrderType)
                    {
                    case "Client":
                    {
                        CurrentProductPrice = cp.ReturnSalePrice(Convert.ToInt32(OrderLine[i].ProductId));
                        break;
                    }

                    case "Vendor":
                    {
                        CurrentProductPrice = cp.ReturnCostPrice(Convert.ToInt32(OrderLine[i].ProductId));
                        break;
                    }

                    default:
                        break;
                    }
                    mvo.CurrentProductPrice = CurrentProductPrice;
                    mvo.OrderProductPrice   = OrderLine[i].SalePrice;
                    mvo.ProductCost         = OrderLine[i].totalProductCost;
                    mvo.ProductName         = ProductName;
                    mvo.Units = OrderLine[i].unit;
                    OrderDetails.Add(mvo);
                }
                return(OrderDetails);
            }
Exemple #3
0
        public List <Models.MRevertInventory.RevertConfirm> GetAllConfirm(int OrderId)
        {
            List <Models.MRevertInventory.RevertConfirm> RevertConfirm = new List <Models.MRevertInventory.RevertConfirm>();
            List <Models.MOrdersLine> OrdersLine = new List <Models.MOrdersLine>();

            Classes.COrderOnline coo = new COrderOnline();
            Classes.CProducts    cp  = new CProducts();
            OrdersLine = coo.GetAll();
            OrdersLine = OrdersLine.Where(o => o.OrderId == OrderId.ToString()).ToList();
            for (int i = 0; i < OrdersLine.Count; i++)
            {
                Models.MRevertInventory.RevertConfirm mrc = new Models.MRevertInventory.RevertConfirm();
                mrc.Price       = OrdersLine[i].SalePrice;
                mrc.ProductId   = OrdersLine[i].ProductId;
                mrc.ProductName = cp.GetProductNameWithTagsById(Convert.ToInt32(mrc.ProductId));
                mrc.Units       = OrdersLine[i].unit;
                RevertConfirm.Add(mrc);
            }
            return(RevertConfirm);
        }