private void TabPage3_Click(object sender, EventArgs e)
{
AttendanceClass a = new AttendanceClass();
DataTable dt = a.Select();
dataGridView.DataSource = dt;
}
private void BtnInsert_Click(object sender, EventArgs e)
{
if (txtEmployeeId.Text == string.Empty)
{
MessageBox.Show("Plaese fill the empty fields!");
}
else if (txtEmployeeId.Text == string.Empty)
{
MessageBox.Show("Please enter an Employee Id!");
}
/* else if(txtArrivedTime.Text == string.Empty)
* {
* MessageBox.Show("Plaese enter the arrived time");
* }*/
else if (!int.TryParse(txtEmployeeId.Text, out Id))
{
MessageBox.Show("Employee ID is invaid");
}
else
{
a.EmployeeId = Int32.Parse(txtEmployeeId.Text);
a.Date = dateTimePicker1.Text;
// lblInTime.Text = DateTime.Now.ToString("HH:mm");
a.ArrivedTime = lblInTime.Text;
//a.ArrivedTime = lblInTime.Text;
// a.ArrivedTime = txtArrivedTime.Text;
// a.LeftTime = int.Parse(txtLeaftTime.Text);
bool success = a.Insert(a);
if (success == true)
{
MessageBox.Show("Successfully inserted");
}
else
{
MessageBox.Show("Cannot insert");
}
DataTable dt = a.Select();
dataGridView.DataSource = dt;
}
}
private void AttendanceUserControl_Load(object sender, EventArgs e)
{
dateTimePickerSearch.Format = DateTimePickerFormat.Custom;
dateTimePickerSearch.CustomFormat = "dd-MM-yyyy";
dateTimePicker1.Format = DateTimePickerFormat.Custom;
dateTimePicker1.CustomFormat = "dd-MM-yyyy";
AttendanceClass a = new AttendanceClass();
DataTable dt = a.Select();
dataGridView.DataSource = dt;
lblInTime.Text = DateTime.Now.ToString("HH:mm");
a.ArrivedTime = lblInTime.Text;
}
private void AttendanceReport_Load(object sender, EventArgs e)
{
DataTable dt = a.Select();
dataGridViewReport.DataSource = dt;
}
