//finds the Job and adds the shift
public void AddShift(ContractShift add)
{
for (int i = 0; i < JobInformation.Count; i++)
{
if (JobInformation[i].ID == add.JobID)
{
JobInformation[i].Shifts.Add(add);
i = JobInformation.Count;
}
}
}
// Save the values related to a shift's start and end time whenever they are changed.
private void comboBox_shifts_SelectedIndexChanged(object sender, EventArgs e)
{
Job SelectedJob = p.JobInformation[comboBox_jobs.SelectedIndex];
List <ContractShift> Shifts = SelectedJob.Shifts;
if (comboBox_shifts.SelectedIndex >= 0)
{
int index = comboBox_shifts.SelectedIndex;
ContractShift Shift = Shifts[index];
dtp_ShiftStarted.Value = Shift.StartTime;
dtp_ShiftCompleted.Value = Shift.EndTime;
}
}
// Export data from the database into a file that is readable by the offline version of the program.
private void btn_export_Click(object sender, EventArgs e)
{
if (_homeMenuForm.IsOnline())
{
Package p = new Package();
DateTime Start = date_startTime.Value;
DateTime End = date_endTime.Value;
//fetches data from sql server
DataTable table = getShiftForEmployeeTableAdapter1.GetData(Convert.ToInt32(((ComboboxItem)comboBox_employeeID.SelectedItem).Value), Start, End);
//counting rows
Console.WriteLine(table.Rows.Count);
//for each row
for (int i = 0; i < table.Rows.Count; i++)
{
Console.WriteLine("Writing Shift");
//New Shift
ContractShift newShift = new ContractShift();
newShift.StartTime = DateTime.Parse(table.Rows[i][1].ToString());
newShift.EndTime = DateTime.Parse(table.Rows[i][2].ToString());
newShift.JobID = int.Parse(table.Rows[i][3].ToString());
Console.WriteLine(newShift.ToString());
//New Job if Job doesn't already exist
int JobID = int.Parse(table.Rows[i][3].ToString());
if (p.UniqueJobID(JobID))
{
Job newJob = new Job();
newJob.ID = JobID;
newJob.ShortDescription = (String)table.Rows[i][4].ToString();
newJob.Ordered = DateTime.Parse(table.Rows[i][5].ToString());
newJob.Location = (String)table.Rows[i][6].ToString();
newJob.priority = int.Parse(table.Rows[i][7].ToString());
newJob.StartTime = DateTime.Parse(table.Rows[i][8].ToString());
try
{
newJob.CompletionTime = DateTime.Parse(table.Rows[i][9].ToString());
}
catch { }//oops
newJob.Charged = decimal.Parse(table.Rows[i][10].ToString());
newJob.Paid = Boolean.Parse(table.Rows[i][11].ToString());
//Client info
Client client = new Client();
client.id = int.Parse(table.Rows[i][13].ToString());
client.name = (String)table.Rows[i][14].ToString();
client.BusinessName = (String)table.Rows[i][12].ToString();
client.address = (String)table.Rows[i][15].ToString();
try
{
client.SetLandLine(int.Parse(table.Rows[i][16].ToString()));
}
catch { client.SetLandLine(0); } // Default value.
try
{
client.SetMobile(int.Parse(table.Rows[i][17].ToString()));
}
catch { client.SetMobile(0); }
client.email = (String)table.Rows[i][18].ToString();
p.AddClient(client);
//add client to Job
newJob.client = p.getClient(client.id);
//setting values of the new Job
p.AddJob(newJob);
}
p.AddShift(newShift);
}
//get contractor info here
DataTable employeeTable = getEmployeesTableAdapter.GetData();
DataRow employeeRow = null;
for (int i = 0; i < employeeTable.Rows.Count; i++)
{
if (employeeTable.Rows[i][0].ToString() == ((ComboboxItem)comboBox_employeeID.SelectedItem).Value.ToString())
{
employeeRow = employeeTable.Rows[i];
i = employeeTable.Rows.Count;
}
}
//attempt to fix issue
p.Contractor.EmployeeID = int.Parse(table.Rows[0][0].ToString());
p.Contractor.name = employeeRow[2].ToString();
//save file
p.Serialise();
}
}
