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