//grab the select report
private void showReport()
{
String date = LogDates.SelectedItem.ToString(), dsub = "";
Console.WriteLine("date: " + date);
//reformats the selected date text to match that of the database
if (!date.Equals(""))
{
dsub = date.Substring(date.IndexOf(' '));
date = date.Substring(0, date.IndexOf(' '));
String[] dateN = date.Split('/');
date = dateN[2] + "-" + dateN[0] + "-" + dateN[1];
//grabs the selected accident from the database
accidents = TTStruct.requestLog(date + dsub, id);
//parses the string into 3 sections for the cars, accident type, and the notes
String[] accident = accidents.Split('|');
//displays the accident report on the gui
numCars.Text = accident[0];
acciType.Text = accident[1];
LogNotes.Text = accident[2];
}
}
//reset the timer
private void resetTimer()
{
TTStruct.ResetTime(id);
count = 0;
Timer.Text = "00:00:00";
Console.WriteLine("Done.");
}
//grabs the info from the database and stores it in local variables
private void getInfo()
{
weight = TTStruct.getWeight(this.id);
mile = TTStruct.getMileage(this.id);
driveTime = TTStruct.GetTime(this.id);
date = TTStruct.getDate(this.id);
time = TTStruct.GetTimeSecs(this.id);
}
//the login algorithm decider for the process 1 of DFD
private void loginDecider()
{
int id = TTStruct.Login(usrnm.Text, pwrd.Text);
if (displayOutput(id))
{
mainMenu(id);
}
}
//end the timer and update the timer in the database
private void endTimer()
{
timer1.Stop();
int previousTime = TTStruct.GetTimeSecs(id);
int totalTime = previousTime + count;
TTStruct.UpdateTime(totalTime, id);
}
//remove an address that has been reached
private void RouteList_CellContentClick_1(object sender, DataGridViewCellEventArgs e)
{
var senderGrid = (DataGridView)sender;
//makes sure the route has stops to remove
if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn && e.RowIndex >= 0)
{
TTStruct.RemoveStop(e.RowIndex + 1, routeID);
toSetDataTable = TTStruct.LoadRoutes(routeID);
routeList.DataSource = toSetDataTable;
}
}
//the decider for the main menu form
private void mDecider(String m)
{
switch (m)
{
//displays the currently signed in user
case "display":
String name = TTStruct.GetName(id);
loggedIn.Text = "Logged in as: " + name;
break;
case "tw":
this.Hide();
Weight mm = new Weight(id);
mm.Show();
break;
case "ur":
this.Hide();
Receipt r = new Receipt(this.id);
r.Show();
break;
case "ti":
this.Hide();
Info i = new Info(id);
i.Show();
break;
case "sr":
this.Hide();
Route re = new Route(id);
re.Show();
break;
case "us":
this.Hide();
UpdateDate1 us = new UpdateDate1(id);
us.Show();
break;
case "a":
this.Hide();
Accident a = new Accident(id);
a.Show();
break;
case "um":
this.Hide();
UpdateMileage1 um = new UpdateMileage1(id);
um.Show();
break;
}
}
//display the dates
private void display()
{
LogDates.Items.Clear();
dates = "";
//grabs the accident dates of the user
dates = TTStruct.displayLogs(id);
//separates the dates and stores them in the listbox on the gui
String[] datesList = dates.Split('|');
for (int i = 0; i < datesList.Length; i++)
{
LogDates.Items.Add(datesList[i]);
}
}
//update the mileage in the db
private void updateMileage1()
{
bool test = TTStruct.updateDistance(textBox2.Value, id);
if (test)
{
//show erro message if update was successful and display new mileage
label3.Show();
displayNew();
}
else
{
//show error message if update failed
label4.Show();
}
}
//update the service date
private void updateServ()
{
bool test = TTStruct.setDate(calendar.SelectionStart.Year, calendar.SelectionStart.Month, calendar.SelectionStart.Day, this.id);
if (test)
{
//show if update was a success
label3.Show();
}
else
{
//show if update was a failure
label4.Show();
}
//display the new date
displayNew("" + TTStruct.getDate(this.id));
}
//upload pic to database
private void uploadPic()
{
if (fileNamePath != null && destination != null)
{
File.Copy(fileNamePath, destination);
TTStruct.UploadReceipt(filename, this.id);
label2.Text = "Your receipt has been uploaded";
label2.Visible = true;
fileNamePath = null;
destination = null;
}
else
{
//display error if wrong or no file was select
label2.Text = "ERROR: file not selected";
label2.Visible = true;
}
}
//displays the current mileage from the db
private void displayCurrent()
{
this.label2.Text = "Total Miles:" + TTStruct.getMileage(id);
}
//display current date
private void displayCur()
{
this.label2.Text = "Last Service Date:" + TTStruct.getDate(this.id);
}
