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); }
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); }