public void timeSheetSelect(string id)
{
d1.DBSetup();
d1.cmd = "Select * from EmpTime where EmpId ='" + id + "'";
d1.SqlDataAdapter.SelectCommand.CommandText = d1.cmd;
d1.SqlDataAdapter.SelectCommand.Connection = d1.SqlDbConection2;
try
{
d1.SqlDbConection2.Open();
System.Data.SqlClient.SqlDataReader dr;
dr = d1.SqlDataAdapter.SelectCommand.ExecuteReader();
Console.WriteLine(d1.cmd);
while (dr.Read())
{
TimeIO t1 = new TimeIO(((String)dr.GetValue(1)), (DateTime)dr.GetValue(2), (DateTime)dr.GetValue(3), (String)dr.GetValue(4), (int)dr.GetValue(0), (bool)dr.GetValue(5), (bool)dr.GetValue(7));
getTS().Add(t1);
}
}
catch (Exception e)
{
Console.WriteLine("Something happened: " + e);
}
finally
{
d1.SqlDbConection2.Close();
}
}
//====Update TimeIO/EmpTime====//
private void btnUpTimeIO_Click(object sender, EventArgs e)
{
TimeIO t1;
t1 = new TimeIO("900254666", new DateTime(2011, 2, 1, 2, 56, 00), new DateTime(2011, 2, 3, 3, 56, 00), "Lunch", 9, false, false);
t1.updateTime();
}
//====Delete TimeIO/EmpTime====//
private void btnDelTimeIO_Click(object sender, EventArgs e)
{
TimeIO t1;
t1 = new TimeIO("900254666", new DateTime(2011, 2, 1, 2, 56, 00), new DateTime(2011, 2, 3, 3, 56, 00), "Lunch", 23, true, false);
t1.deleteTime();
}
//Method for Selecting hours worked between two given DateTimes.
//Selects TimeWorked from EmpTime table between 2 DateTimes, sets double Total to figure out hours worked in that time frame.
public void selectOvertime(DateTime i, DateTime o)
{
TimeIO tio = new TimeIO();
for (int x = 0; x < emps.Count(); x++)
{
//selectHours for all employees
tio.selectHours(emps[x].getId(), i, o);
//if employee's hours are greater than 40 and not equal to zero, populate lists
if (tio.getTotal() > 40 && tio.getTotal() != 0)
{
//adds employee ids to empIds list
getEmpIds().Add(emps[x].getId());
//add total from TimeIO BO to hours list
getHours().Add(tio.getTotal());
}
}
//Display results
for (int x = 0; x < empIds.Count(); x++)
{
tio.selectHours(empIds[x], i, o);
Employee e1 = new Employee();
e1.selectEmp(empIds[x]);
Console.WriteLine("Hours worked between " + i + " and " + o + " for Employee " + e1.getFName() + " " + e1.getLName());
Console.WriteLine("Overtime Hours Worked: " + ((int)(hours[x]) - 40) + " Hours and " + ((hours[x] - (int)(hours[x])) * 60) + " minutes.");
Console.WriteLine(hours[x] - (int)hours[x] + "");
}
}
//====Insert TimeIO/EmpTime=====//
private void btnInsertTime_Click(object sender, EventArgs e)
{
TimeIO t1;
t1 = new TimeIO("900254666", new DateTime(2011, 2, 1, 2, 56, 00), new DateTime(2011, 2, 3, 3, 56, 00), "Lunch", 000, false, false);
t1.insertTime();
t1.Display();
}
//====Get Total Hours Worked for a given time span, not including Absence Hours===//
private void buttonSpan_Click(object sender, EventArgs e)
{
TimeIO t1;
t1 = new TimeIO();
t1.selectHours("900255666", new DateTime(2014, 5, 5, 0, 0, 0), new DateTime(2014, 5, 9, 23, 59, 59));
Console.WriteLine(t1.getTotal());
}
//===========Time==========//
private void btnTime_Click(object sender, EventArgs e)
{
TimeIO t1;
t1 = new TimeIO("900254666", new DateTime(2011, 2, 5, 4, 56, 00), new DateTime(2011, 2, 5, 6, 56, 00), "Doctor", 123, false, false);
t1.Display();
t1.insertTime();
t1.selectTime("900254666");
}
//Method for Selecting hours worked between two given DateTimes.
//Selects TimeWorked from EmpTime table between 2 DateTimes, sets double Total to figure out hours worked in that time frame.
public void selectOvertime(DateTime i, DateTime o)
{
TimeIO tio = new TimeIO();
for (int x = 0; x < emps.Count(); x++)
{
tio.selectHours(emps[x].getId(), i, o);
if (tio.getTotal() > 40 && tio.getTotal() != 0)
{
getEmpIds().Add(emps[x].getId());
getHours().Add(tio.getTotal());
}
}
}
