private void MarkAttendance(int empId, DateTime attendanceDate) { dsAttendance ds = new dsAttendance(); dsAttendanceTableAdapters.AttendanceTableAdapter taAttendance = new dsAttendanceTableAdapters.AttendanceTableAdapter(); dsAttendanceTableAdapters.EmployeeTableAdapter taEmployee = new dsAttendanceTableAdapters.EmployeeTableAdapter(); taAttendance.FillByDate(ds.Attendance, attendanceDate.ToString()); if (ds.Attendance.Rows.Count <= 0) { AttendanceList.GenerateAttendanceSheet(attendanceDate); } dsAttendanceTableAdapters.AttendanceDetailTableAdapter taAttendanceDetail = new dsAttendanceTableAdapters.AttendanceDetailTableAdapter(); taAttendanceDetail.FillbyEmployeeDate(ds.AttendanceDetail, empId, attendanceDate.ToString()); taEmployee.FillById(ds.Employee, empId); var employee = ds.Employee.NewEmployeeRow(); var attendanceDetail = ds.AttendanceDetail.NewAttendanceDetailRow(); if (ds.AttendanceDetail.Rows.Count > 0) { attendanceDetail = ds.AttendanceDetail[0]; attendanceDetail.Status = GetStatus(); if (ds.Employee.Rows.Count > 0) { employee = ds.Employee[0]; } if (attendanceDetail.Status == 2) { employee.AL = employee.AL - 1; } else if (attendanceDetail.Status == 3) { employee.CL = employee.CL - 1; } else if (attendanceDetail.Status == 4) { employee.SL = employee.SL - 1; } if (attendanceDetail.Status == 1) { attendanceDetail.TimeIn = Convert.ToDateTime(dtpTimeIN.Text).TimeOfDay; attendanceDetail.TimeOut = Convert.ToDateTime(dtpTimeOut.Text).TimeOfDay; } attendanceDetail.ModifiedDate = SmartManger.BAL.Common.DateNow(); if (!attendanceDetail.IsSystemNotesNull()) { attendanceDetail.SystemNotes += "Marked by admin " + SmartManger.BAL.Common.DateNow(); } else { attendanceDetail.SystemNotes = "Modified by admin " + SmartManger.BAL.Common.DateNow(); } } taAttendanceDetail.Update(attendanceDetail); taEmployee.Update(employee); }
public static void GenerateAttendanceSheet(DateTime Date) { int RecordId; int Status; try { dsAttendance ds = new dsAttendance(); dsAttendanceTableAdapters.AttendanceTableAdapter taAttendance = new dsAttendanceTableAdapters.AttendanceTableAdapter(); dsAttendanceTableAdapters.AttendanceDetailTableAdapter taAttendanceDetail = new dsAttendanceTableAdapters.AttendanceDetailTableAdapter(); var attendance = ds.Attendance.NewAttendanceRow(); taAttendance.FillByDate(ds.Attendance, Date.ToString()); if (ds.Attendance.Rows.Count > 0) { MessageBox.Show("Attendance Sheet for this date Already Exist!"); } else { attendance.AttendanceDate = Date; attendance.CreatedOn = SmartManger.BAL.Common.DateNow(); attendance.SystemNotes = "Created by:Admin on" + SmartManger.BAL.Common.DateNow(); ds.Attendance.AddAttendanceRow(attendance); taAttendance.Update(attendance); RecordId = attendance.AttendanceId; dsAttendanceTableAdapters.EmployeeIDsTableAdapter taEmpId = new dsAttendanceTableAdapters.EmployeeIDsTableAdapter(); DataTable dt = taEmpId.GetData(); Status = GetAttendanceStatus(Date); foreach (DataRow item in dt.Rows) { var attendanceDetail = ds.AttendanceDetail.NewAttendanceDetailRow(); attendanceDetail.AttendanceId = RecordId; attendanceDetail.EmployeeId = Convert.ToInt32(item[0].ToString()); attendanceDetail.Status = Status; attendanceDetail.ModifiedDate = SmartManger.BAL.Common.DateNow(); attendanceDetail.IsByCamera = false; ds.AttendanceDetail.AddAttendanceDetailRow(attendanceDetail); taAttendanceDetail.Update(attendanceDetail); } MessageBox.Show("Attendance Sheet Generated!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static void MarkAttendanceByCamera(int empId, DateTime attendanceDate, bool isCamera) { try { dsAttendance ds = new dsAttendance(); dsAttendanceTableAdapters.AttendanceTableAdapter taAttendance = new dsAttendanceTableAdapters.AttendanceTableAdapter(); taAttendance.FillByDate(ds.Attendance, attendanceDate.ToString()); if (ds.Attendance.Rows.Count <= 0) { AttendanceList.GenerateAttendanceSheet(attendanceDate); } else { } dsAttendanceTableAdapters.AttendanceDetailTableAdapter taAttendanceDetail = new dsAttendanceTableAdapters.AttendanceDetailTableAdapter(); taAttendanceDetail.FillbyEmployeeDate(ds.AttendanceDetail, empId, attendanceDate.ToString()); var attendanceDetail = ds.AttendanceDetail.NewAttendanceDetailRow(); if (ds.AttendanceDetail.Rows.Count > 0) { attendanceDetail = ds.AttendanceDetail[0]; if (attendanceDetail.IsTimeInNull() && isCamera == true) { attendanceDetail.TimeIn = (SmartManger.BAL.Common.DateNow()).TimeOfDay; attendanceDetail.TimeOut = TimeSpan.Parse("16:00:00"); attendanceDetail.IsByCamera = true; attendanceDetail.Status = 1; attendanceDetail.ModifiedDate = SmartManger.BAL.Common.DateNow(); if (!attendanceDetail.IsSystemNotesNull()) { attendanceDetail.SystemNotes += "Marked by camerea on " + SmartManger.BAL.Common.DateNow(); } else { attendanceDetail.SystemNotes = "Marked by camerea on " + SmartManger.BAL.Common.DateNow(); } } taAttendanceDetail.Update(attendanceDetail); } else { //MessageBox.Show("Record not Found"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }