public List <OrderTransport> convertOrderTransport(DataTable table) { List <OrderTransport> listOrder = new List <OrderTransport>(); OrderTransport order = new OrderTransport(); DateTime createdDate = new DateTime(); if (table != null) { foreach (DataRow row in table.Rows) { if (row[order.createdDate.Key] != DBNull.Value) { createdDate = Convert.ToDateTime(row[order.createdDate.Key]); } listOrder.Add(new OrderTransport( Convert.ToInt32(row[order.id.Key]), createdDate, new Location(Convert.ToInt32(row[order.pickupLocation.Key])), new Location(Convert.ToInt32(row[order.destination.Key])), new Package(Convert.ToInt32(row[order.package.Key])), new Customer(Convert.ToInt32(row[order.customer.Key])), new Invoice(Convert.ToInt32(row[order.invoice.Key])) )); } } return(listOrder); }
public ActionResult PickupAssignments() { OrderTransport order = new OrderTransport(); List <OrderTransport> deliverys = bo.getPickupOrder(); return(View(deliverys)); }
public void generateOrderTransportSelection(List <Data> data, ref String Query, ref MySqlParameter[] parameters) { OrderTransport ot = new OrderTransport(); Query = "select * from order_transport"; if (data.Count == 0) { return; } else { parameters = new MySqlParameter[data.Count]; for (int i = 0; i < data.Count; i++) { if (i == 0) { Query += " where "; } else { Query += " and "; } if (data[i].Key == ot.pickupLocation.Key) { Location l = (Location)data[i].Value; Query += data[i].Key + "=@" + data[i].Key; parameters[i] = new MySqlParameter("@" + data[i].Key, l.id.Value); } else if (data[i].Key == ot.destination.Key) { Location l = (Location)data[i].Value; Query += data[i].Key + "=@" + data[i].Key; parameters[i] = new MySqlParameter("@" + data[i].Key, l.id.Value); } else if (data[i].Key == ot.customer.Key) { Customer c = (Customer)data[i].Value; Query += data[i].Key + "=@" + data[i].Key; parameters[i] = new MySqlParameter("@" + data[i].Key, c.ctmId.Value); } else if (data[i].Key == ot.package.Key) { Package p = (Package)data[i].Value; Query += data[i].Key + "=@" + data[i].Key; parameters[i] = new MySqlParameter("@" + data[i].Key, p.id.Value); } else if (data[i].Key == ot.invoice.Key) { Invoice invoice = (Invoice)data[i].Value; Query += data[i].Key + "=@" + data[i].Key; parameters[i] = new MySqlParameter("@" + data[i].Key, invoice.id.Value); } else { Query += data[i].Key + "=@" + data[i].Key; parameters[i] = new MySqlParameter("@" + data[i].Key, data[i].Value); } } } }
protected override void Execute() { AppJournal.Write(GetType().Name + ":" + System.Reflection.MethodBase.GetCurrentMethod(), "Started..."); if (!OrderTransport.HasNew()) { return; } List <OrderDocument> orderDocuments = OrderTransport.GetNew(); foreach (var orderDocument in orderDocuments) { var eventArgs = new NewOrderEventArgs(orderDocument); if (CustomerSpecifics.IsVostokOrder(orderDocument)) { eventArgs.OrderDocument.Customer = CustomersEnum.Vostok; } if (CustomerSpecifics.IsInkayOrder(orderDocument)) { eventArgs.OrderDocument.Customer = CustomersEnum.Inkay; } OnNewOrderEvent(eventArgs); } }
public async Task <Order> SendOrderTransport(OrderTransport orderTransport) { var url = string.Format("{0}order/post", AppData.Host); var data = JsonConvert.SerializeObject(orderTransport); return(await ConnectionService.Post <Order>(url, new StringContent(data, Encoding.UTF8, "application/json"), "Не удалось загрузить данные о заказе")); }
public IHttpActionResult Post(OrderViewModel model) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var order = new OrderTransport { UserId = model.UserId, ServiceDescription = model.ServiceDescription, ServiceClassiferDescription = model.ServiceClassiferDescription, Header = model.Header, Description = model.Description, City = model.City, Address = model.Address, Price = model.Price, Name = model.Name, PhoneNumber = model.PhoneNumber, CompletedOn = model.CompletedOn, CreatedAt = DateTime.UtcNow.ToString("d"), }; OrderManager.CreateOrder(order); return(Ok()); }
public ActionResult AvailableDrivers(int?id) { int ids = 0; ids = (int)id; OrderTransport order = new OrderTransport(ids); return(View(order)); }
public ActionResult PickupDetails(int?id) { int ids = 0; ids = (int)id; OrderTransport order = bo.FilteringBy(new OrderTransport(ids).id).getOrderTransport()[0]; return(View(order)); }
public Task <int> SaveItemAsync(OrderTransport item) { if (item.TransportID != 0) { return(database.UpdateAsync(item)); } else { return(database.InsertAsync(item)); } }
public void generateAssignmentSelection(List <Data> data, ref String Query, ref MySqlParameter[] parameters) { Assignment a = new Assignment(); Query = "select * from assignment"; if (data.Count == 0) { return; } else { parameters = new MySqlParameter[data.Count]; for (int i = 0; i < data.Count; i++) { if (i == 0) { Query += " where "; } else { Query += " and "; } if (data[i].Key == a.order.Key) { OrderTransport ot = (OrderTransport)data[i].Value; Query += data[i].Key + "=@" + data[i].Key; parameters[i] = new MySqlParameter("@" + data[i].Key, ot.id.Value); } else if (data[i].Key == a.employee.Key) { Employee e = (Employee)data[i].Value; Query += data[i].Key + "=@" + data[i].Key; parameters[i] = new MySqlParameter("@" + data[i].Key, e.empId.Value); } else if (data[i].Key == a.driver.Key) { Driver d = (Driver)data[i].Value; Query += data[i].Key + "=@" + data[i].Key; parameters[i] = new MySqlParameter("@" + data[i].Key, d.dvrId.Value); } else { Query += data[i].Key + "=@" + data[i].Key; parameters[i] = new MySqlParameter("@" + data[i].Key, data[i].Value); } } } }
protected int insertAssignment(Assignment assignment) { OrderTransport order = (OrderTransport)assignment.order.Value; Employee employee = (Employee)assignment.employee.Value; Driver driver = (Driver)assignment.driver.Value; MySqlParameter[] parameters = new MySqlParameter[5]; parameters[0] = new MySqlParameter("@" + assignment.assignmentDate.Key, assignment.assignmentDate.Value); parameters[1] = new MySqlParameter("@" + assignment.order.Key, order.id.Value); parameters[2] = new MySqlParameter("@" + assignment.employee.Key, employee.empId.Value); parameters[3] = new MySqlParameter("@" + assignment.driver.Key, driver.dvrId.Value); parameters[4] = new MySqlParameter("@" + assignment.assignmentType.Key, assignment.assignmentType.Value); return(insertProcedureCall("ADD_ASSIGNMENT", parameters)); }
public ActionResult DeliveryHistory() { OrderTransport order = new OrderTransport(); List <OrderTransport> listDeliverys = new List <OrderTransport>(); try { order.customer.Value = bo.FilteringBy(new User((int)Session["Customer"]).id).getCustomer()[0]; listDeliverys = bo.FilteringBy(order.customer).getOrderTransport(); } catch (Exception) { } return(View(listDeliverys)); }
protected int insertOrderTransport(OrderTransport ordertransport) { Location pickup = (Location)ordertransport.pickupLocation.Value; Location destination = (Location)ordertransport.destination.Value; Customer customer = (Customer)ordertransport.customer.Value; Package package = (Package)ordertransport.package.Value; Invoice invoice = (Invoice)ordertransport.invoice.Value; MySqlParameter[] parameters = new MySqlParameter[6]; parameters[0] = new MySqlParameter("@" + ordertransport.createdDate.Key, ordertransport.createdDate.Value); parameters[1] = new MySqlParameter("@" + ordertransport.pickupLocation.Key, pickup.id.Value); parameters[2] = new MySqlParameter("@" + ordertransport.destination.Key, destination.id.Value); parameters[3] = new MySqlParameter("@" + ordertransport.customer.Key, customer.ctmId.Value); parameters[4] = new MySqlParameter("@" + ordertransport.package.Key, package.id.Value); parameters[5] = new MySqlParameter("@" + ordertransport.invoice.Key, invoice.id.Value); return(insertProcedureCall("ADD_ORDER_TRANSPORT", parameters)); }
public FinishPage(PotentialCustomer Customer1, Transport TransportToSend, List <string> GoodsName, List <CartGoods> GoodsInCart, List <int> Piece1) { InitializeComponent(); Piece = Piece1; Address Address = new Address(); Address.Street = Customer1.Street; Address.Town = Customer1.Town; Address.PostNumber = int.Parse(Customer1.PostCode.ToString()); AddressDatabase.SaveItemAsync(Address); DebugMethod(); ContactInformation Contact = new ContactInformation(); Contact.Email = Customer1.Mail; Contact.Phone = Customer1.Phone; ContactInformationDatabase.SaveItemAsync(Contact); DebugMethod(); Customer Customer = new Customer(); Customer.AddressID = Address.AddressID; Customer.ContactInformationID = Contact.ContactInformationID; Customer.Name = Customer1.Name; Customer.Surname = Customer1.Surname; CustomerDatabase.SaveItemAsync(Customer); DebugMethod(); OrderTransport Transport = new OrderTransport(); Transport.TypeOfTransport = TransportToSend.Name; Transport.Price = TransportToSend.Price; OrderTransportDatabase.SaveItemAsync(Transport); DebugMethod(); Random r = new Random(); int rnd = r.Next(); int TotalPrice = 0; for (int i = 0; i < GoodsInCart.Count; i++) { TotalPrice += GoodsInCart[i].TotalPrice; } TotalPrice += Transport.Price; Order Order = new Order(); Order.CustomerID = Customer.CustomerID; Order.TransportID = Transport.TransportID; Order.OrderNumber = rnd; Order.OrderPrice = TotalPrice; OrderDatabase.SaveItemAsync(Order); DebugMethod(); Number.Text = Order.OrderNumber.ToString(); List <Customer> clist = new List <Customer>(); clist = CustomerDatabase.GetItemsAsync().Result; for (int i = 0; i < GoodsName.Count; i++) { OrderGoods OrderGoods = new OrderGoods(); OrderGoods.OrderID = Order.OrderID; Goods goods = GoodsDatabase.GetItemAsync(GoodsName[i]).Result; OrderGoods.GoodsQauntity = GoodsInCart[i].GoodsQauntity; OrderGoods.GoodsID = goods.GoodsID; OrderGoodsDatabase.SaveItemAsync(OrderGoods); DebugMethod(); } var ordergoods = OrderGoodsDatabase.GetItemsAsync().Result; var order = OrderDatabase.GetItemsAsync().Result; }
public int addOrderTransport(OrderTransport order) { return(insertOrderTransport(order)); }