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; }