public int AddRoostedDayOff(RoostedDayOff roostedDayOff)
{
OleDbCommand odCom1 = BuildInsertCmd("RoostedDayOff",
new string[] { "EmployeeNumber"
,"Date"
,"TotalHours"
,"Note"
},
new object[] { roostedDayOff.EmployeeNumber
,roostedDayOff.Date
,roostedDayOff.TotalHours
,roostedDayOff.Note
}
);
if (odCom1.ExecuteNonQuery() == 1)
{
odCom1.CommandText = "SELECT @@IDENTITY";
return (int)odCom1.ExecuteScalar();
}
return -1;
}
public bool UpdateRoostedDayOff(RoostedDayOff roostedDayOff)
{
OleDbCommand odCom1 = BuildUpdateCmd("RoostedDayOff",
new string[] { "EmployeeNumber"
,"Date"
,"TotalHours"
,"Note"
},
new object[] { roostedDayOff.EmployeeNumber
,roostedDayOff.Date
,roostedDayOff.TotalHours
,roostedDayOff.Note
},
"ID=@ID", new object[] { "@ID", roostedDayOff.ID }
);
return odCom1.ExecuteNonQuery() > 0 ? true : false;
}
public RoostedDayOff GetRoostedDayOff(int id)
{
OleDbCommand odCom = BuildSelectCmd("RoostedDayOff", "TOP 1 *", "ID=@ID", new object[] { "@ID", id });
OleDbDataReader odRdr = odCom.ExecuteReader();
RoostedDayOff roostedDayOff = null;
if (odRdr.Read())
{
roostedDayOff = new RoostedDayOff();
roostedDayOff.ID = (int)odRdr["ID"];
roostedDayOff.EmployeeNumber = (int)odRdr["EmployeeNumber"];
roostedDayOff.Date = odRdr["Date"].GetType() != typeof(DBNull) ? Convert.ToDateTime(odRdr["Date"]) : Config.MinDate;
roostedDayOff.TotalHours = (int)odRdr["TotalHours"];
roostedDayOff.Note = odRdr["Note"].ToString();
}
odRdr.Close();
return roostedDayOff;
}
public List<RoostedDayOff> GetRoostedDayOffList()
{
OleDbCommand odCom = BuildSelectCmd("RoostedDayOff", "*", null);
OleDbDataReader odRdr = odCom.ExecuteReader();
List<RoostedDayOff> roostedDayOffList = new List<RoostedDayOff>();
RoostedDayOff roostedDayOff = null;
while (odRdr.Read())
{
roostedDayOff = new RoostedDayOff();
roostedDayOff.ID = (int)odRdr["ID"];
roostedDayOff.EmployeeNumber = (int)odRdr["EmployeeNumber"];
roostedDayOff.Date = odRdr["Date"].GetType() != typeof(DBNull) ? Convert.ToDateTime(odRdr["Date"]) : Config.MinDate;
roostedDayOff.TotalHours = (int)odRdr["TotalHours"];
roostedDayOff.Note = odRdr["Note"].ToString();
roostedDayOffList.Add(roostedDayOff);
}
odRdr.Close();
return roostedDayOffList;
}
private RoostedDayOff GetRoostedDayOffUserInput()
{
RoostedDayOff rDaysOff = new RoostedDayOff();
int employeeNumber = 0;
try
{
employeeNumber = Convert.ToInt32(cbxEmployeeNumber.SelectedValue);
if (employeeNumber <= 0)
throw new Exception();
}
catch
{
errProviders.SetError(cbxEmployeeNumber, "Invalid Employee number.");
return null;
}
DateTime dAttDate = (DateTime)dtpAttDate.Value.Date;
int totalHours = Convert.ToInt32(txtTotalHours.Text);
string sNote = txtNote.Text;
rDaysOff.EmployeeNumber = employeeNumber;
rDaysOff.Note = sNote;
rDaysOff.Date = dAttDate;
rDaysOff.TotalHours = totalHours;
return rDaysOff;
}
