private void RefreshData(bool listflag,int select) { routes = mysql_routes.GetRouteInfo(viewdate); for (int i = 0; i < routes.Count; i++) { routes[i].invoicerouteinfo = mysql_invoiceroutes.GetRouteInfo(routes[i]); if (driver.number == routes[i].drivernumber) { viewroute = routes[i]; } } viewinvoices = new List<Invoice>(); viewlineitems = new List<LineItem>(); //set date this.Text = "Configure Driver Route - "+driver.name +" - "+ viewdate.Month + "/" + viewdate.Day + "/" + viewdate.Year + " - " + viewdate.DayOfWeek; //zero out areas //add in the route time??? currentnumberofstops = 0; textEstimatedCost.Text = ""; textValueMain.Text = ""; textTotalMiles.Text = ""; textTotalTime.Text = ""; textCostPercentage.Text = ""; listRouteItems.Items.Clear(); listAllItems.Items.Clear(); textInvoice.Text = ""; textCustomer.Text = ""; textStreet.Text = ""; textCity.Text = ""; textZip.Text = ""; textState.Text = ""; textValue.Text = ""; listLineItems.Items.Clear(); counter = 0; buttonPrint.Enabled = false; RefreshInvoices(listflag,select); RefreshMap(); }
private void addRoute_Click(object sender, EventArgs e) { RouteInfo routeinfo = new RouteInfo(0, viewdate, companydrivers[listCompanyDrivers.SelectedIndex].number,0); mysql_routes.AddRouteInfo(routeinfo); NextDayRefresh(0); }
public RouteInfo GetRouteInfo(InvoiceRouteInfo invoicerouteinfo) { try { MySqlConnection theconnection = Connect(); MySqlDataReader rdr = Select("SELECT * FROM delivery_route_data WHERE DR_ROUTE_NUMBER=" + invoicerouteinfo.routenumber.ToString() + " ;", theconnection); rdr.Read(); RouteInfo toinsert = new RouteInfo((int)rdr[2], DateTime.Parse((String)rdr[0]), (int)rdr[1], (int)rdr[3]); Disconnect(); return (toinsert); } catch { Disconnect(); return null; } }
public bool updateMileage(RouteInfo routeinfo) { try { MySqlConnection theconnection = Connect(); string updatequery = "UPDATE delivery_route_data SET `DR_MILES`=" + routeinfo.miles + " WHERE DR_ROUTE_NUMBER="+routeinfo.number+";"; Update(updatequery, theconnection); Disconnect(); return true; } catch { Disconnect(); return false; } }
public List<RouteInfo> GetRouteInfo(int ID) { try { MySqlConnection theconnection = Connect(); List<RouteInfo> routeinfo = new List<RouteInfo>(); MySqlDataReader rdr = Select("SELECT * FROM delivery_route_data WHERE DR_DRV_NUMBER=" + ID.ToString() + " ;", theconnection); while (rdr.Read()) { RouteInfo toinsert = new RouteInfo((int)rdr[2], DateTime.Parse((String)rdr[0]),(int)rdr[1], (int)rdr[3]); routeinfo.Add(toinsert); } Disconnect(); return (routeinfo); } catch { Disconnect(); return null; } }
public List<RouteInfo> GetRouteInfo(DateTime date) { try { MySqlConnection theconnection = Connect(); List<RouteInfo> routeinfo = new List<RouteInfo>(); string selectquery = "SELECT * FROM delivery_route_data WHERE DR_DATE LIKE '%" + date.ToShortDateString() + "%' OR DR_DATE LIKE '%" + date.ToString("M/d/yy") + "%' OR DR_DATE LIKE '%" + date.ToString("M/d/yyyy") + "%' OR DR_DATE LIKE '%" + date.ToString("MM/d/yy") + "%';"; MySqlDataReader rdr = Select(selectquery, theconnection); while (rdr.Read()) { RouteInfo toinsert = new RouteInfo((int)rdr[2], DateTime.Parse((String)rdr[0]), (int)rdr[1],(int)rdr[3]); routeinfo.Add(toinsert); } Disconnect(); return (routeinfo); } catch { Disconnect(); return null; } }
public bool AddRouteInfo(RouteInfo routeinfo) { try { MySqlConnection theconnection = Connect(); string insertquery = "INSERT INTO delivery_route_data (`DR_DATE`, `DR_DRV_NUMBER`, `DR_ROUTE_NUMBER`,DR_MILES) VALUES ('" + routeinfo.date + "', " + routeinfo.drivernumber + ", NULL,"+routeinfo.miles+");"; Insert(insertquery, theconnection); Disconnect(); return true; } catch { Disconnect(); return false; } }
public List<InvoiceRouteInfo> GetRouteInfo(RouteInfo route) { try { MySqlConnection theconnection=Connect(); MySqlDataReader rdr = Select("SELECT * FROM invoice_route_data WHERE IR_ROUTE_NUMBER=" + route.number + " ;", theconnection); List<InvoiceRouteInfo> routeinfo= new List<InvoiceRouteInfo>(); while (rdr.Read()) { InvoiceRouteInfo input = new InvoiceRouteInfo((int)rdr[0], (int)rdr[1], (int)rdr[2]); routeinfo.Add(input); } Disconnect(); return (routeinfo); } catch { Disconnect(); return null; } }
private void button2_Click(object sender, EventArgs e) { try { //DialogResult result = MessageBox.Show("Saving changes will remove all configured routes for the current day and replace them with optimized routes. Are you sure?", "Warning", MessageBoxButtons.YesNo); //if (result == DialogResult.Yes) //{ // for (int i = 0; i < driverassignments.Count; i++) //{ // mysql_routes.DeleteRouteInfo(companydrivers[driverassignments[i]].number, viewdate); //} for (int i = 0; i < driverassignments.Count; i++) { RouteInfo toadd = new RouteInfo(0, viewdate, companydrivers[driverassignments[i]].number, distances[i]); mysql_routes.AddRouteInfo(toadd); } List<RouteInfo> currentroutes = mysql_routes.GetRouteInfo(viewdate); for (int i = 0; i < driverassignments.Count; i++) { int routenumber = 0; for (int j = 0; j < currentroutes.Count; j++) { if (currentroutes[j].drivernumber == companydrivers[driverassignments[i]].number) { routenumber = currentroutes[j].number; } } for (int j = 0; j < optimizedroutes[i].Count; j++) { optimizedroutes[i][j].routenumber = routenumber; InvoiceRouteInfo toadd = new InvoiceRouteInfo(optimizedroutes[i][j].invoicenumber, optimizedroutes[i][j].routenumber, optimizedroutes[i][j].stop); mysql_invoiceroutes.AddRouteInfo(toadd); } } DeliverySchedule deliveryschedule = new DeliverySchedule(); deliveryschedule.SetDate(viewdate,0); deliveryschedule.Show(); this.Close(); } //} catch { } }