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);
}
}
private void FillGrid(DateTime Start, DateTime End)
{
dsAttendance ds = new dsAttendance();
dsAttendanceTableAdapters.AttendanceTableAdapter taAttendance = new dsAttendanceTableAdapters.AttendanceTableAdapter();
DataTable dt = taAttendance.GetDataByGivenDates(Start.ToString(), End.ToString());
grdAttendanceList.Rows.Clear();
grdAttendanceList.AutoGenerateColumns = false;
int SrNo = 0;
foreach (DataRow item in dt.Rows)
{
SrNo++;
DateTime date = Convert.ToDateTime(item[1].ToString());
string Day = date.ToString("dddd");
string Month = date.ToString("MMMM");
grdAttendanceList.Rows.Add(item[0], SrNo, date.ToString("dd,MMMM,yyyy"), Day, Month);
}
tbxCount.Text = SrNo.ToString();
}
