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