protected void btn_report_Click(object sender, EventArgs e)
{
btnExport.Visible = true;
ManageReports objManageReports = new ManageReports();
TimeSpan relaxationTime = new TimeSpan();
relaxationTime = TimeSpan.Parse(ddlRelaxation.SelectedValue.ToString());
int EmployeeId = 0;
Int32.TryParse(txtEmployeeId.Text, out EmployeeId);
MonthlyReportOfEmployee objMonthlyReportOfEmployee = new MonthlyReportOfEmployee();
var data = objManageReports.GetDataForMonthlyAttendanceReportByEmployeeId(EmployeeId, Calendar1.SelectedDate.Date, Calendar2.SelectedDate.Date, relaxationTime, out objMonthlyReportOfEmployee);
grid_monthly_attendanceDetailed.DataSource = data;
grid_monthly_attendanceDetailed.DataBind();
if (data.Count != 0)
{
lblName.Text = "Name : " + data[0].Name;
}
else
{
lblName.Text = "No Data";
}
lblTotalDuration.Text = "TotalDuration : " + objMonthlyReportOfEmployee.TotalDuration.ToString();
lblPresentDays.Text = "PresentDays : " + objMonthlyReportOfEmployee.PresentDays.ToString();
lblLeaves.Text = "Leaves : " + objMonthlyReportOfEmployee.Leaves.ToString();
lblHolidays.Text = "Holidays : " + objMonthlyReportOfEmployee.Holidays.ToString();
lblAbsentDays.Text = objMonthlyReportOfEmployee.AbsentDays.ToString();
lblAbsentDays.Text = "AbsentDays : " + objMonthlyReportOfEmployee.AbsentDays.ToString();
lblWeeklyOff.Text = "WeeklyOff : " + objMonthlyReportOfEmployee.WeeklyOff.ToString();
}
protected void btn_report_Click(object sender, EventArgs e)
{
btnExport.Visible = true;
ManageReports objManageReports = new ManageReports();
TimeSpan relaxationTime = new TimeSpan();
relaxationTime = TimeSpan.Parse(ddlRelaxation.SelectedValue.ToString());
int EmployeeId = 0;
//Int32.TryParse(txtEmployeeId.Text, out EmployeeId);
ManageEmployees objEmployee = new ManageEmployees();
lstEmployees = objEmployee.GetAllEmployees();
EmployeeId = lstEmployees.Where(y => y.Name == txtEmployeeId.Text).Select(x => x.Id).FirstOrDefault();
DateTime StartDate = DateTime.Parse(txtStartDate.Text);
DateTime EndDate = DateTime.Parse(txtEndDate.Text);
MonthlyReportOfEmployee objMonthlyReportOfEmployee = new MonthlyReportOfEmployee();
var data = objManageReports.GetMonthlyAttendanceDetailedReport(EmployeeId, StartDate,EndDate, relaxationTime, out objMonthlyReportOfEmployee);
grid_monthly_attendanceBasic.DataSource = data;
grid_monthly_attendanceBasic.DataBind();
if (data.Count != 0)
{
lblName.Text = "Name : " + data[0].Name;
lblDepartment.Text = "Department : " + data[0].DepartmentName;
}
else
{
lblName.Text = "No Data";
}
lblTotalDuration.Text = "TotalDuration : " + objMonthlyReportOfEmployee.TotalDuration.ToString();
lblPresentDays.Text = "PresentDays : " + objMonthlyReportOfEmployee.PresentDays.ToString();
lblLeaves.Text = "Leaves : " + objMonthlyReportOfEmployee.Leaves.ToString();
lblHolidays.Text = "Holidays : " + objMonthlyReportOfEmployee.Holidays.ToString();
lblAbsentDays.Text = objMonthlyReportOfEmployee.AbsentDays.ToString();
lblAbsentDays.Text = "AbsentDays : " + objMonthlyReportOfEmployee.AbsentDays.ToString();
lblWeeklyOff.Text = "WeeklyOff : " + objMonthlyReportOfEmployee.WeeklyOff.ToString();
}
protected void btn_report_Click(object sender, EventArgs e)
{
btnExport.Visible = true;
ManageReports objManageReports = new ManageReports();
TimeSpan relaxationTime = new TimeSpan();
relaxationTime = TimeSpan.Parse(ddlRelaxation.SelectedValue.ToString());
int EmployeeId = 0;
ManageEmployees objEmployee = new ManageEmployees();
lstEmployees = objEmployee.GetAllEmployees();
EmployeeId = lstEmployees.Where(y => y.Name == txtEmployeeId.Text).Select(x => x.Id).FirstOrDefault();
DateTime StartDate = DateTime.Parse(txtStartDate.Text);
DateTime EndDate = DateTime.Parse(txtEndDate.Text);
MonthlyReportOfEmployee objMonthlyReportOfEmployee = new MonthlyReportOfEmployee();
var data = objManageReports.GetMonthlyAttendanceDetailedReport(EmployeeId, StartDate, EndDate, relaxationTime, out objMonthlyReportOfEmployee);
grid_monthly_attendanceDetailed.DataSource = data;
grid_monthly_attendanceDetailed.DataBind();
if (data.Count != 0)
{
lblName.Text = "Name : " + data[0].Name;
}
else
{
lblName.Text = "No Data";
}
lblTotalDuration.Text = "TotalDuration : " + objMonthlyReportOfEmployee.TotalDuration.ToString();
lblPresentDays.Text = "PresentDays : " + objMonthlyReportOfEmployee.PresentDays.ToString();
lblLeaves.Text = "Leaves : " + objMonthlyReportOfEmployee.Leaves.ToString();
lblHolidays.Text = "Holidays : " + objMonthlyReportOfEmployee.Holidays.ToString();
lblAbsentDays.Text = objMonthlyReportOfEmployee.AbsentDays.ToString();
lblAbsentDays.Text = "AbsentDays : " + objMonthlyReportOfEmployee.AbsentDays.ToString();
lblWeeklyOff.Text = "WeeklyOff : " + objMonthlyReportOfEmployee.WeeklyOff.ToString();
}
public List<DailyAttendanceReportViewModel> GetDataForMonthlyAttendanceReportByEmployeeId(int EmployeeId, DateTime StartDate, DateTime EndDate, TimeSpan relaxation, out MonthlyReportOfEmployee objMonthlyReportOfEmployee)
{
List<DailyAttendanceReportViewModel> lstDailyAttendanceReportViewModel = new List<DailyAttendanceReportViewModel>();
for (DateTime date = StartDate.Date; date.Date <= EndDate.Date; date = date.AddDays(1))
{
List<DailyAttendanceReportViewModel> varLst = GetDataForDailyAttendanceByEmployeeId(EmployeeId, date, relaxation);
lstDailyAttendanceReportViewModel = lstDailyAttendanceReportViewModel.Concat(varLst).ToList();
}
objMonthlyReportOfEmployee = new MonthlyReportOfEmployee();
foreach (DailyAttendanceReportViewModel item in lstDailyAttendanceReportViewModel)
{
objMonthlyReportOfEmployee.TotalDuration += item.Duration;
DayStatus daystatus = GetStatusOfDay(item.Date, EmployeeId);
if (daystatus == DayStatus.Active)
{
if (item.Status == Status.Present || item.Status == Status.PresentWithNoOutPunch)
{
objMonthlyReportOfEmployee.PresentDays++;
}
else
{
objMonthlyReportOfEmployee.AbsentDays++;
}
}
else if (daystatus == DayStatus.WeeklyOff)
{
if (item.Status == Status.Present)
{
item.Status = Status.WeeklyOffPresent;
objMonthlyReportOfEmployee.PresentDays++;
}
else if (item.Status == Status.PresentWithNoOutPunch)
{
item.Status = Status.WeeklyOffPresentWithNoOutPunch;
objMonthlyReportOfEmployee.PresentDays++;
}
else
{
item.Status = Status.WeeklyOff;
}
}
else //Holiday
{
objMonthlyReportOfEmployee.Holidays++;
item.Status = Status.Holiday;
}
}
return lstDailyAttendanceReportViewModel;
}
public List<DailyAttendanceReportViewModel> GetMonthlyAttendanceDetailedReport(int employeeId, DateTime startDate, DateTime endDate, TimeSpan relaxation, out MonthlyReportOfEmployee objMonthlyReportOfEmployee)// aspx file mai check kar lena ki startDate < endDate
{
List<DailyAttendanceReportViewModel> lstMonthlyAttendanceReportViewModel = new List<DailyAttendanceReportViewModel>();
objMonthlyReportOfEmployee = new MonthlyReportOfEmployee();
for (DateTime date = startDate; date <= endDate; date = date.AddDays(1))
{
DailyAttendanceReportViewModel objMonthlyAttendanceReportViewModel = new DailyAttendanceReportViewModel();
objMonthlyAttendanceReportViewModel = GetDataForReportEmployeeWise(employeeId, date, relaxation);
objMonthlyAttendanceReportViewModel.Date = date;
lstMonthlyAttendanceReportViewModel.Add(objMonthlyAttendanceReportViewModel);
}
foreach (var item in lstMonthlyAttendanceReportViewModel)
{
objMonthlyReportOfEmployee.TotalDuration += item.Duration;
DayStatus daystatus = GetStatusOfDay(item.Date, employeeId);
if (daystatus == DayStatus.Active)
{
if (item.Status == Status.Present || item.Status == Status.PresentWithNoOutPunch)
{
objMonthlyReportOfEmployee.PresentDays++;
}
else
{
objMonthlyReportOfEmployee.AbsentDays++;
}
}
else if (daystatus == DayStatus.WeeklyOff)
{
if (item.Status == Status.Present)
{
item.Status = Status.WeeklyOffPresent;
objMonthlyReportOfEmployee.PresentDays++;
}
else if (item.Status == Status.PresentWithNoOutPunch)
{
item.Status = Status.WeeklyOffPresentWithNoOutPunch;
objMonthlyReportOfEmployee.PresentDays++;
}
else
{
item.Status = Status.WeeklyOff;
objMonthlyReportOfEmployee.WeeklyOff++;
}
}
else //Holiday
{
objMonthlyReportOfEmployee.Holidays++;
item.Status = Status.Holiday;
}
}
return lstMonthlyAttendanceReportViewModel;
}