private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
DatabaseHandle dbHandle = new DatabaseHandle();
DataTable dt;
if (dbHandle.UpdateStaffTimeSheet(_timeSheetID, dtpUpdateST.Value.ToString("yyyy-MM-dd HH:mm:ss"), dtpUpdateET.Value.ToString("yyyy-MM-dd HH:mm:ss")) > 0)
{
MessageBox.Show("Update Complete!");
dt = dbHandle.ListOfStaff();
if (dt == null)
{
dt = dbHandle.ListOfStaff();
}
dgvStaff.DataSource = dt;
InitializeDataGridView();
}
}
catch (Exception ex)
{
MessageBox.Show("Can not Update " + ex.Message);
}
}
private void MainForm_Load(object sender, EventArgs e)
{
DatabaseHandle dbHandle = new DatabaseHandle();
DataTable dt = dbHandle.ListOfStaff();
List <String> lstFirstName = dt.AsEnumerable().Select(r => r.Field <String>("first_name")).ToList();
lstFirstName = lstFirstName.Distinct().ToList();
cbFirstName.Items.Add("All");
foreach (String firstName in lstFirstName)
{
cbFirstName.Items.Add(firstName);
}
dgvStaff.DataSource = dt;
InitializeDataGridView();
}
private void btnSearch_Click(object sender, EventArgs e)
{
DatabaseHandle dbHandle = new DatabaseHandle();
DataTable dt;
if (cbFirstName.Text == "All")
{
dt = dbHandle.ListOfStaff();
}
else
{
dt = dbHandle.ListOfStaffByFirstName(cbFirstName.Text, dtpSearchST.Value.Date.ToLongTimeString(), dtpSearchET.Value.Date.ToLongTimeString());
}
//dt = dbHandle.ListOfStaffByFirstName(cbFirstName.Text, dtpSearchST.Value.ToLongTimeStringring("yyyy-MM-dd HH:mm:ss"), dtpSearchET.Value.Date.ToString("yyyy-MM-dd HH:mm:ss")) ;
if (dt == null)
{
dt = dbHandle.ListOfStaff();
}
dgvStaff.DataSource = dt;
InitializeDataGridView();
}
