private int UpdateDB(string strSQL)
{
objDatabase Database = new objDatabase();
int intRows;
return(intRows = Database.AddData(strSQL));
}
private void LoadControl()
{
objDatabase Database = new objDatabase();
string strSQL;
cmbShift.Items.Clear();
strSQL = "Select Name, TimeIn, TimeOut";
strSQL = strSQL + " From Shift";
objTable = Database.ReturnDataTable(strSQL);
// Loading Shifts into combobox
foreach (DataRow objRow in objTable.Rows)
{
cmbShift.Items.Add(objRow[0].ToString());
}
cmbShift.SelectedIndex = -1;
cmbShift.Text = "<New Shift>";
dtStartTime.Text = "12:00 AM";
dtEndTime.Text = "12:00 AM";
cmbShift.Focus();
}
private int UpdateDatabase(string strSQL)
{
objDatabase Database = new objDatabase();
return(Database.AddData(strSQL));
}
private void butEnter_Click(object sender, EventArgs e)
{
string[] strSupervisor;
string[] strWorker;
int intRows = 0;
string strSQL;
objDatabase Database = new objDatabase();
strSupervisor = cmbSupervisor.SelectedItem.ToString().Split(' ');
//Loop through all entries in dtWorkers
foreach (DataRow objRow in dtWorkers.Rows)
{
strWorker = objRow["Name"].ToString().Split(' ');
if (objRow["Action"].ToString() == "Add")
{
strSQL = "spUpdateSupervisor " + "'" + strSupervisor[0] + "','" + strSupervisor[1] + "','" + strWorker[0] + "','" + strWorker[1] + "','" + dtDay.Text.ToString() + "','" + cmbShift.SelectedItem.ToString() + "'";
intRows = intRows + Database.AddData(strSQL);
}
else if (objRow["Action"].ToString() == "Delete")
{
strSQL = "spRemoveSupervisor " + "'" + strSupervisor[0] + "','" + strSupervisor[1] + "','" + strWorker[0] + "','" + strWorker[1] + "','" + dtDay.Text.ToString() + "','" + cmbShift.SelectedItem.ToString() + "'";
intRows = intRows + Database.AddData(strSQL);
}
}
MessageBox.Show(intRows.ToString() + " rows have been updated.");
strDtDay = dtDay.Value.ToShortDateString();
intCmbShift = cmbShift.SelectedIndex;
intCmbSupervisor = cmbSupervisor.SelectedIndex;
LoadControl();
}
private void update_ListBoxes()
{
if (dtDay.Value.ToShortDateString() != "")
{
lstScheduled.Items.Clear();
lstWorkers.Items.Clear();
objDatabase Database = new objDatabase();
string strSQL = "spReturnSchedule '" + dtDay.Value.ToShortDateString() + "'";
dtSchedule = Database.ReturnDataTable(strSQL);
dtSchedule.Columns.Add("Action", typeof(string));
foreach (DataRow objRow in dtSchedule.Rows)
{
if (objRow["Shift"].ToString() == cmbShift.Text)
{
lstScheduled.DrawMode = DrawMode.OwnerDrawFixed;
lstScheduled.Items.Add(objRow["Worker"]);
}
else if (objRow["Shift"].ToString() == "")
{
lstWorkers.DrawMode = DrawMode.OwnerDrawFixed;
strCurrentItem = strCurrentItem + "|" + objRow["Worker"];
lstWorkers.Items.Add(objRow["Worker"]);
}
}
}
}
private void butSearch_Click(object sender, EventArgs e)
{
objDatabase Database = new objDatabase();
string strSQL = CreateSQL();
DataTable objTable = new DataTable();
//objDataReader = Database.ReturnData(strSQL);
objTable = Database.ReturnDataTable(strSQL);
if (objTable.Rows.Count > 0)
{
objGrid.DataSource = objTable;
objGrid.Columns[0].Visible = false;
objGrid.Columns[4].Visible = false;
if (objTable.Rows.Count == 1)
{
Fill_Control(objGrid.Rows[0]);
}
}
else
{
MessageBox.Show("No rows were returned, for the given critera, please try again");
ClearControl();
}
}
private DataTable QueryDB(string strSQL)
{
objDatabase Database = new objDatabase();
DataTable objDTable;
return(objDTable = Database.ReturnDataTable(strSQL));
}
private void butEnter_Click(object sender, EventArgs e)
{
objDatabase Database = new objDatabase();
string strSQL;
string strMsg = "";
int intRows = 0, intDelete = 0, intAdd = 0;
Cursor.Current = Cursors.WaitCursor;
foreach (DataRow objRow in dtSchedule.Rows)
{
if (objRow["Action"].ToString().Length > 0)
{
strSQL = "spAddSchedule '" + objRow["Worker"] + "','" + objRow["shift"] + "','" + dtDay.Text + "','" + objRow["Action"] + "'";
//update database
intRows = Database.AddData(strSQL);
if (objRow["Action"].ToString() == "delete")
{
intDelete = intRows + intDelete;
}
else if (objRow["Action"].ToString() == "new")
{
intAdd = intRows + intAdd;
}
}
}
Cursor.Current = Cursors.Default;
if (intAdd > 0)
{
strMsg = intAdd.ToString() + " worker(s) have been added to the " + cmbShift.Text + ".";
}
if (intDelete > 0)
{
if (strMsg.Length > 0)
{
strMsg = strMsg + "\r\n";
}
strMsg = strMsg + intDelete.ToString() + " worker(s) have been removed from the " + cmbShift.Text + ".";
}
MessageBox.Show(strMsg);
intCmbShiftIndex = cmbShift.SelectedIndex;
strDtDay = dtDay.Value.ToLongDateString();
lstScheduled.Items.Clear();
lstWorkers.Items.Clear();
strAction = "";
LoadControl();
}
private void butRole_Click(object sender, EventArgs e)
{
objDatabase Database = new objDatabase();
string strSQL;
int intRows;
strSQL = "spUpdateRole '" + txtFirstName.Text + "','" + txtLastName.Text + "','" + cmbRole.Text + "'";
intRows = Database.AddData(strSQL);
if (intRows > 0)
{
MessageBox.Show(txtFirstName.Text + " " + txtLastName.Text + "'s role has been updated.");
}
ClearControl();
}
private void Load_cmbShift()
{
objDatabase Database = new objDatabase();
string strSQL = "Select Shift.Name from Shift";
SqlDataReader objReader;
cmbShift.Items.Clear();
objReader = Database.ReturnData(strSQL);
while (objReader.Read())
{
cmbShift.Items.Add(objReader[0].ToString());
cmbShift.SelectedIndex = 0;
}
}
private void LoadControl()
{
objDatabase Database = new objDatabase();
SqlDataReader objReader;
string strSQL = "Select Role.Description from Role";
objReader = Database.ReturnData(strSQL);
while (objReader.Read())
{
cmbRole.Items.Add(objReader[0].ToString());
}
cmbRole.SelectedIndex = 0;
txtFirstName.Focus();
}
private void butDelete_Click(object sender, EventArgs e)
{
objDatabase Database = new objDatabase();
string strSQL = "Delete From Shift Where Shift.Name = '" + cmbShift.Text + "'";
Cursor.Current = Cursors.WaitCursor;
int intRows = Database.AddData(strSQL);
LoadControl();
Cursor.Current = Cursors.Default;
if (intRows > 0)
{
MessageBox.Show("The shift has been deleted.");
}
}
private void butEnter_Click(object sender, EventArgs e)
{
if (VerifyData() == true)
{
objDatabase Database = new objDatabase();
string strSQL = "spAddShift '" + cmbShift.Text + "', '" + dtStartTime.Text + "', '" + dtEndTime.Text + "'";
Cursor.Current = Cursors.WaitCursor;
int intRows = Database.AddData(strSQL);
LoadControl();
Cursor.Current = Cursors.Default;
if (intRows > 0)
{
MessageBox.Show("The shift has been successfully updated.");
}
}
}
private void AddPerson()
{
string strSQL;
objDatabase Database = new objDatabase();
int intRows;
bool blReady;
blReady = CheckControl();
if (blReady == true)
{
strSQL = "spAddPerson '" + txtFirstName.Text + "','" + txtLastName.Text + "','" + cmbRole.SelectedItem.ToString() + "','" + strPicPath + "'";
intRows = Database.AddData(strSQL);
if (intRows > 0)
{
MessageBox.Show(txtFirstName.Text + " " + txtLastName.Text + " has been added to the database.");
ClearControl();
}
}
}
private void objTabs_SelectedIndexChanged(object sender, EventArgs e)
{
if (objTabs.SelectedIndex == 2)
{
cmbShift.Items.Clear();
// Filing cmbShifts
objDatabase DataBase = new objDatabase();
string strSQL = "Select Shift.Name From Shift";
DataTable objDTable = DataBase.ReturnDataTable(strSQL);
foreach (DataRow objRow in objDTable.Rows)
{
cmbShift.Items.Add(objRow[0]);
}
cmbReports.Items.Clear();
cmbReports.Items.Add("Schedule");
cmbReports.Items.Add("Accounting");
cmbReports.SelectedIndex = -1;
}
}
private void FillGrid()
{
objDatabase Database = new objDatabase();
string strSQL = "spReturnUserTime " + strID;
dtTimes = Database.ReturnDataTable(strSQL);
grdTimes.Columns.Clear();
grdTimes.DataSource = dtTimes;
grdTimes.Columns[0].Visible = false;
grdTimes.Columns[2].Visible = false;
grdTimes.Columns[4].Visible = false;
grdTimes.Columns[5].Visible = false;
SetupDateTime(dtStart, chkAddStartTime, false);
SetupDateTime(dtEnd, chkAddEndTime, false);
butAdjust.Enabled = false;
butAdd.Enabled = false;
}
private void FillDataTable()
{
objDatabase Database = new objDatabase();
}