private void AddInvoice_Load(object sender, EventArgs e)
{
try
{
latitude = 0;
longitude = 0;
textInvoice.Text = "";
textValue.Text = "";
textCustomer.Text = "";
textStreet.Text = "";
textCity.Text = "";
textZip.Text = "";
textState.Text = "";
listItems.Items.Clear();
Add.Enabled = true;
toolStripStatusLabel2.Text = "";
mysql_invoices = new MySQL_Invoices(GlobalVar.sqlhost, GlobalVar.sqlport, GlobalVar.sqldatabase, GlobalVar.sqlusername, "");
mysql_lineitems = new MySQL_LineItems(GlobalVar.sqlhost, GlobalVar.sqlport, GlobalVar.sqldatabase, GlobalVar.sqlusername, "");
}
catch
{
Cancel_Click(null, null);
}
}
public ConfigureTruckRoute()
{
this.TopLevel = true;
this.MaximizeBox = false;
mysql_invoices = new MySQL_Invoices(GlobalVar.sqlhost, GlobalVar.sqlport, GlobalVar.sqldatabase, GlobalVar.sqlusername, "");
mysql_drivers = new MySQL_Drivers(GlobalVar.sqlhost, GlobalVar.sqlport, GlobalVar.sqldatabase, GlobalVar.sqlusername, "");
mysql_lineitems = new MySQL_LineItems(GlobalVar.sqlhost, GlobalVar.sqlport, GlobalVar.sqldatabase, GlobalVar.sqlusername, "");
mysql_routes = new MySQL_Routes(GlobalVar.sqlhost, GlobalVar.sqlport, GlobalVar.sqldatabase, GlobalVar.sqlusername, "");
mysql_invoiceroutes = new MySQL_InvoiceRoute(GlobalVar.sqlhost, GlobalVar.sqlport, GlobalVar.sqldatabase, GlobalVar.sqlusername, "");
InitializeComponent();
}
public DeliverySchedule()
{
InitializeComponent();
this.MaximizeBox = false;
mysql_invoices = new MySQL_Invoices(GlobalVar.sqlhost, GlobalVar.sqlport, GlobalVar.sqldatabase, GlobalVar.sqlusername, "");
mysql_drivers = new MySQL_Drivers(GlobalVar.sqlhost, GlobalVar.sqlport, GlobalVar.sqldatabase, GlobalVar.sqlusername, "");
mysql_lineitems = new MySQL_LineItems(GlobalVar.sqlhost, GlobalVar.sqlport, GlobalVar.sqldatabase, GlobalVar.sqlusername, "");
mysql_routes = new MySQL_Routes(GlobalVar.sqlhost, GlobalVar.sqlport, GlobalVar.sqldatabase, GlobalVar.sqlusername, "");
mysql_invoiceroutes = new MySQL_InvoiceRoute(GlobalVar.sqlhost, GlobalVar.sqlport, GlobalVar.sqldatabase, GlobalVar.sqlusername, "");
viewdate = DateTime.Now;
scheduleddrivers = new List<DriverInfo>();
counter = 0;
}
//do one or the other (default invoice)
public List<Invoice> FilterInvoices(DateTime date,List<int> invoice)
{
try
{
List<Invoice> filteredinvoices = new List<Invoice>();
if (invoice != null)
{
for (int j = 0; j < invoice.Count; j++)
{
for (int i = 0; i < rawinvoices.Count; i++)
{
if (rawinvoices[i].number==invoice[j])
{
filteredinvoices.Add(rawinvoices[i]);
}
}
}
return (filteredinvoices);
}else{
mysql_invoices = new MySQL_Invoices(GlobalVar.sqlhost, GlobalVar.sqlport, GlobalVar.sqldatabase, GlobalVar.sqlusername, "");
List<Invoice> blockedinvoices= mysql_invoices.GetBlocks(date);
for (int i = 0; i < rawinvoices.Count; i++)
{
if (rawinvoices[i].due.Day == date.Day && rawinvoices[i].due.Month == date.Month && rawinvoices[i].due.Year == date.Year)
{
filteredinvoices.Add(rawinvoices[i]);
if (blockedinvoices != null)
{
for (int j = 0; j < blockedinvoices.Count; j++)
{
if (rawinvoices[i].number == blockedinvoices[j].number)
{
filteredinvoices.RemoveAt(filteredinvoices.Count - 1);
}
}
}
}
}
return (filteredinvoices);
}
}
catch
{
return null;
}
}
private void EditInvoice_Load(object sender, EventArgs e)
{
try
{
textInvoice.Text = "";
textValue.Text = "";
textCustomer.Text = "";
textStreet.Text = "";
textCity.Text = "";
textZip.Text = "";
textState.Text = "";
listAddresses.Items.Clear();
listAddresses.Enabled = false;
toolStripStatusLabel1.Text = "";
mysql_invoices = new MySQL_Invoices(GlobalVar.sqlhost, GlobalVar.sqlport, GlobalVar.sqldatabase, GlobalVar.sqlusername, "");
newinvoice = mysql_invoices.GetInvoice(inputinvoice.number);
if (newinvoice != null)
{
textInvoice.Text = newinvoice.number.ToString();
textValue.Text = DataFormat.FormatMoneyToString(newinvoice.value);
if(newinvoice.addr1!="")
{
textStreet.Text = newinvoice.addr1;
}
else
{
textStreet.Text = newinvoice.addr2;
}
textCustomer.Text = newinvoice.customername;
textCity.Text = newinvoice.city;
textZip.Text = newinvoice.zip;
textState.Text = newinvoice.state;
}
else { Cancel_Click(null, null); }
}
catch
{
Cancel_Click(null, null);
}
}
private void OptimizeWindow_Load(object sender, EventArgs e)
{
mysql_invoices = new MySQL_Invoices(GlobalVar.sqlhost, GlobalVar.sqlport, GlobalVar.sqldatabase, GlobalVar.sqlusername, "");
mysql_drivers = new MySQL_Drivers(GlobalVar.sqlhost, GlobalVar.sqlport, GlobalVar.sqldatabase, GlobalVar.sqlusername, "");
mysql_routes = new MySQL_Routes(GlobalVar.sqlhost, GlobalVar.sqlport, GlobalVar.sqldatabase, GlobalVar.sqlusername, "");
mysql_invoiceroutes = new MySQL_InvoiceRoute(GlobalVar.sqlhost, GlobalVar.sqlport, GlobalVar.sqldatabase, GlobalVar.sqlusername, "");
buttonSave.Enabled = false;
textDistance.Text = "600";
textCapacity.Text = "15";
textRadius.Text = "50";
textRate.Text = "";
textOvertime.Text = "";
textFuel.Text = "";
textMaitenance.Text = "";
listDrivers.Items.Clear();
listRoutes.Items.Clear();
optimized = false;
counter = 0;
radioButton1.Checked = true;
driverassignments = new List<int>();
textStatus.Text = "";
checkBox1.Checked = true;
DoRefresh();
toolStripStatusLabel1.Text = "";
}
private void EditInvoice_Load(object sender, EventArgs e)
{
try
{
textInvoice.Text = "";
textValue.Text = "";
textCustomer.Text = "";
textStreet.Text = "";
textCity.Text = "";
textZip.Text = "";
textState.Text = "";
listAddresses.Items.Clear();
button1.Enabled = false;
toolStripStatusLabel1.Text = "";
mysql_invoices = new MySQL_Invoices(GlobalVar.sqlhost, GlobalVar.sqlport, GlobalVar.sqldatabase, GlobalVar.sqlusername, "");
mysql_lineitems = new MySQL_LineItems(GlobalVar.sqlhost, GlobalVar.sqlport, GlobalVar.sqldatabase, GlobalVar.sqlusername, "");
newinvoice = mysql_invoices.GetInvoice(inputinvoice.number);
if (newinvoice != null)
{
lineitems = mysql_lineitems.GetLineItems(newinvoice);
textInvoice.Text = newinvoice.number.ToString();
textValue.Text = DataFormat.FormatMoneyToString(newinvoice.value);
if (newinvoice.addr1 != "")
{
textStreet.Text = newinvoice.addr1;
}
else
{
textStreet.Text = newinvoice.addr2;
}
textCustomer.Text = newinvoice.customername;
textCity.Text = newinvoice.city;
textZip.Text = newinvoice.zip;
textState.Text = newinvoice.state;
for (int i = 0; i < lineitems.Count; i++)
{
string toinsert = lineitems[i].description + " - " + DataFormat.FormatMoneyToString(lineitems[i].value);
listAddresses.Items.Add(toinsert);
}
DatePicker.Value = newinvoice.due;
button1.Enabled = true;
}
else { Cancel_Click(null, null); }
}
catch
{
Cancel_Click(null, null);
}
}
