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