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