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 btnGetData_Click(object sender, EventArgs e)
{
ManageReports objManageReports = new ManageReports();
lstLeavesBalanceRecord = objManageReports.GetDataForMonthlyLeaveBalanceTable(Convert.ToInt32(ddlDepartments.SelectedValue.ToString()), Calendar1.SelectedDate.Date, Calendar2.SelectedDate.Date);
grid1.DataSource = lstLeavesBalanceRecord;
grid1.DataBind();
}
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 ddlShowDepartment_SelectedIndexChanged(object sender, EventArgs e)
{
int departmentId = Convert.ToInt32(ddlShowDepartment.SelectedValue);
ManageReports objManageReports = new ManageReports();
lstLeaveAssignedRecord = objManageReports.GetLeavesAssignedPerSession(departmentId, DateTime.Now);
grid1.DataSource = lstLeaveAssignedRecord;
grid1.DataBind();
}
protected void ddlShowDepartment_SelectedIndexChanged(object sender, EventArgs e)
{
int departmentId = Convert.ToInt32(ddlShowDepartment.SelectedValue);
ManageReports objManageReports = new ManageReports();
lstLeaveAssignedRecord = objManageReports.GetLeavesAssignedPerSession(departmentId, DateTime.Now);
grid1.DataSource = lstLeaveAssignedRecord;
grid1.DataBind();
}
protected void BindGrid()
{
TimeSpan relaxationTime = new TimeSpan();
relaxationTime = TimeSpan.Parse(ddlRelaxation.SelectedValue.ToString());
ManageReports objManageReports = new ManageReports();
var data = objManageReports.GetDataForMonthlyLateReport(Convert.ToInt32(ddlDepartments.SelectedValue.ToString()), Calendar1.SelectedDate.Date, Calendar2.SelectedDate.Date, relaxationTime);
grid_lateComers.DataSource = data;
grid_lateComers.DataBind();
}
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());
var data = objManageReports.GetDataForMonthlyAbsentReport(Convert.ToInt32(ddlDepartments.SelectedValue.ToString()), Calendar1.SelectedDate.Date, Calendar1.SelectedDate.Date, relaxationTime);
grid_dailyAbsent.DataSource = data;
grid_dailyAbsent.DataBind();
}
protected void lnkAddSession_Click(object sender, EventArgs e)
{
string confirmValue = Request.Form["confirm_value"];
if (confirmValue == "Yes")
{
#region Add_Session
DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
DateTime sessionStartDate = new DateTime(Int32.Parse(txtSessionStart.Text), 8, 1);
DateTime sessionEndDate = new DateTime(sessionStartDate.Year + 1, 7, 31);
string query = "Select Count(*) from tblSession Where SessionStartDate=@sessionStartDate";
List <SqlParameter> lstParams = new List <SqlParameter>();
lstParams.Add(new SqlParameter("@sessionStartDate", sessionStartDate));
DataTable ds = new DataTable();
using (DBDataHelper objDDBDataHelper = new DBDataHelper())
{
ds = objDDBDataHelper.GetDataTable(query, SQLTextType.Query, lstParams);
}
if (ds.Rows.Count != 0)
{
if (Int32.Parse(ds.Rows[0][0].ToString()) == 0)
{
string addSession = @"INSERT INTO [dbo].[tblSession]
([SessionStartDate]
,[SessionEndDate])
VALUES (@sessionStartDate,@sessionEndDate)";
List <SqlParameter> lstParams2 = new List <SqlParameter>();
lstParams2.Add(new SqlParameter("@sessionStartDate", sessionStartDate));
lstParams2.Add(new SqlParameter("@sessionEndDate", sessionEndDate));
using (DBDataHelper objDDBDataHelper = new DBDataHelper())
{
objDDBDataHelper.ExecSQL(addSession, SQLTextType.Query, lstParams2);
}
ManageReports objManageReprts = new ManageReports();
objManageReprts.AssignSessionWiseLeave(sessionStartDate);
objManageReprts.UpdateLeaveBalanceTable(sessionStartDate);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Session Added')", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Session Exists')", true);
}
}
#endregion
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('You Cancelled')", true);
}
}
protected void btnGetData_Click(object sender, EventArgs e)
{
var xy = txtStartDate.Text;
DateTime StartDate = DateTime.Parse(txtStartDate.Text);
var xyz = txtEndDate.Text;
DateTime EndDate = DateTime.Parse(txtEndDate.Text);
ManageReports objManageReports = new ManageReports();
lstLeavesBalanceRecord = objManageReports.GetDataForMonthlyLeaveBalanceTable(Convert.ToInt32(ddlDepartments.SelectedValue.ToString()), StartDate, EndDate);
grid1.DataSource = lstLeavesBalanceRecord;
grid1.DataBind();
}
//protected void Calendar1_SelectionChanged(object sender, EventArgs e)
//{
// txt_date.Text = Calendar1.SelectedDate.Date.ToString("d");
//}
protected void btn_report_Click(object sender, EventArgs e)
{
btnExport.Visible = true;
ManageReports objManageReports = new ManageReports();
TimeSpan relaxationTime = new TimeSpan();
DateTime date = DateTime.Parse(txtDate.Text);
relaxationTime = TimeSpan.Parse(ddlRelaxation.SelectedValue.ToString());
var data = objManageReports.GetDailyAbsent(date, relaxationTime);
grid_dailyAbsent.DataSource = data;
grid_dailyAbsent.DataBind();
}
protected void btnGetData_Click(object sender, EventArgs e)
{
var xy = txtStartDate.Text;
DateTime StartDate = DateTime.Parse(txtStartDate.Text);
var xyz = txtEndDate.Text;
DateTime EndDate = DateTime.Parse(txtEndDate.Text);
ManageReports objManageReports = new ManageReports();
lstLeavesBalanceRecord = objManageReports.GetDataForMonthlyLeaveBalanceTable(Convert.ToInt32(ddlDepartments.SelectedValue.ToString()), StartDate, EndDate);
grid1.DataSource = lstLeavesBalanceRecord;
grid1.DataBind();
}
//protected void Calendar1_SelectionChanged(object sender, EventArgs e)
//{
// txt_date.Text = Calendar1.SelectedDate.Date.ToString("d");
//}
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());
DateTime date = DateTime.Parse(txtDate.Text);
var data = objManageReports.GetDailyLateComers(date, relaxationTime);
grid_lateComers.DataSource = data;
grid_lateComers.DataBind();
}
protected void BindGrid()
{
TimeSpan relaxationTime = new TimeSpan();
relaxationTime = TimeSpan.Parse(ddlRelaxation.SelectedValue.ToString());
ManageReports objManageReports = new ManageReports();
var xy = txtStartDate.Text;
DateTime StartDate = DateTime.Parse(txtStartDate.Text);
var xyz = txtEndDate.Text;
DateTime EndDate = DateTime.Parse(txtEndDate.Text);
var data = objManageReports.GetMonthlyLateComers(StartDate,EndDate, relaxationTime);
grid_lateComers.DataSource = data;
grid_lateComers.DataBind();
}
protected void lkbEditLeaveAssinged_Click(object sender, EventArgs e)
{
popupEditLeaveAssigned.Show();
LinkButton b = (LinkButton)sender;
int departmentId = Convert.ToInt32(ddlShowDepartment.SelectedValue);
ManageReports objManageReports = new ManageReports();
lstLeaveAssignedRecord = objManageReports.GetLeavesAssignedPerSession(departmentId, DateTime.Now);
int Id = Convert.ToInt32(b.CommandArgument);
Session["empId"] = Id;
var y = lstLeaveAssignedRecord.Select(x => x).Where(d => d.EmployeeId == Id).FirstOrDefault();
EditgvLeaves.DataSource = y.lstAssignedRecord;
EditgvLeaves.DataBind();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
List <LeaveAssignedRecord> lstLeaveAssignedRecord = new List <LeaveAssignedRecord>();
DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
DataSet ds;
int leaveId;
LeaveAssignedPerSession objLeaveAssignedPerSession = new LeaveAssignedPerSession();
ManageReports objManageReports = new ManageReports();
foreach (RepeaterItem i in EditgvLeaves.Items)
{
TextBox txtLeaveCount = (TextBox)i.FindControl("txtLeaveCount");
Label txtLeaveName = (Label)i.FindControl("txtLeave");
string leaveName = txtLeaveName.Text;
List <SqlParameter> lstParams = new List <SqlParameter>();
lstParams.Add(new SqlParameter("@name", leaveName));
string query = "Select Id from tblTypeOfLeave where Name = @name";
using (DBDataHelper objDDBDataHelper = new DBDataHelper())
{
ds = objDDBDataHelper.GetDataSet(query, SQLTextType.Query, lstParams);
leaveId = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
}
DateTime SessionStartDate, SessionEndDate;
if (DateTime.Now.Month >= 8)
{
SessionStartDate = new DateTime(DateTime.Now.Year, 08, 01);
SessionEndDate = new DateTime(DateTime.Now.Year + 1, 07, 31);
}
else
{
SessionStartDate = new DateTime(DateTime.Now.Year - 1, 08, 01);
SessionEndDate = new DateTime(DateTime.Now.Year, 07, 31);
}
objLeaveAssignedPerSession.EmployeeId = Convert.ToInt32(Session["empId"]);
objLeaveAssignedPerSession.leaveCount = Convert.ToInt32(txtLeaveCount.Text);
objLeaveAssignedPerSession.leaveType = leaveId;
objManageReports.UpdateLeavesAssignedPerSessionEmployeeWise(objLeaveAssignedPerSession, SessionStartDate, SessionEndDate);
}
popupEditLeaveAssigned.Hide();
int departmentId = Convert.ToInt32(ddlShowDepartment.SelectedValue);
ManageReports objManageReports1 = new ManageReports();
lstLeaveAssignedRecord = objManageReports1.GetLeavesAssignedPerSession(departmentId, DateTime.Now);
//grid1.DataSource = lstLeaveAssignedRecord;
//grid1.DataBind();
}
protected void BindGrid()
{
TimeSpan relaxationTime = new TimeSpan();
relaxationTime = TimeSpan.Parse(ddlRelaxation.SelectedValue.ToString());
ManageReports objManageReports = new ManageReports();
var xy = txtStartDate.Text;
DateTime StartDate = DateTime.Parse(txtStartDate.Text);
var xyz = txtEndDate.Text;
DateTime EndDate = DateTime.Parse(txtEndDate.Text);
var data = objManageReports.GetMonthlyLateComers(StartDate, EndDate, relaxationTime);
grid_lateComers.DataSource = data;
grid_lateComers.DataBind();
}
protected void lkbEditLeaveAssinged_Click(object sender, EventArgs e)
{
popupEditLeaveAssigned.Show();
LinkButton b = (LinkButton)sender;
int departmentId = Convert.ToInt32(ddlShowDepartment.SelectedValue);
ManageReports objManageReports = new ManageReports();
lstLeaveAssignedRecord = objManageReports.GetLeavesAssignedPerSession(departmentId, DateTime.Now);
int Id = Convert.ToInt32(b.CommandArgument);
Session["empId"] = Id;
var y = lstLeaveAssignedRecord.Select(x => x).Where(d => d.EmployeeId == Id).FirstOrDefault();
EditgvLeaves.DataSource = y.lstAssignedRecord;
EditgvLeaves.DataBind();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
List<LeaveAssignedRecord> lstLeaveAssignedRecord = new List<LeaveAssignedRecord>();
DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
DataSet ds;
int leaveId;
LeaveAssignedPerSession objLeaveAssignedPerSession = new LeaveAssignedPerSession();
ManageReports objManageReports = new ManageReports();
foreach (RepeaterItem i in EditgvLeaves.Items)
{
TextBox txtLeaveCount = (TextBox)i.FindControl("txtLeaveCount");
Label txtLeaveName = (Label)i.FindControl("txtLeave");
string leaveName = txtLeaveName.Text;
List<SqlParameter> lstParams = new List<SqlParameter>();
lstParams.Add(new SqlParameter("@name", leaveName));
string query = "Select Id from tblTypeOfLeave where Name = @name";
using (DBDataHelper objDDBDataHelper = new DBDataHelper())
{
ds = objDDBDataHelper.GetDataSet(query, SQLTextType.Query, lstParams);
leaveId = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
}
DateTime SessionStartDate, SessionEndDate;
if (DateTime.Now.Month >= 8)
{
SessionStartDate = new DateTime(DateTime.Now.Year, 08, 01);
SessionEndDate = new DateTime(DateTime.Now.Year+1, 07, 31);
}
else
{
SessionStartDate = new DateTime(DateTime.Now.Year-1, 08, 01);
SessionEndDate = new DateTime(DateTime.Now.Year, 07, 31);
}
objLeaveAssignedPerSession.EmployeeId = Convert.ToInt32(Session["empId"]);
objLeaveAssignedPerSession.leaveCount = Convert.ToInt32(txtLeaveCount.Text);
objLeaveAssignedPerSession.leaveType = leaveId;
objManageReports.UpdateLeavesAssignedPerSessionEmployeeWise(objLeaveAssignedPerSession, SessionStartDate,SessionEndDate);
}
popupEditLeaveAssigned.Hide();
int departmentId = Convert.ToInt32(ddlShowDepartment.SelectedValue);
ManageReports objManageReports1 = new ManageReports();
lstLeaveAssignedRecord = objManageReports1.GetLeavesAssignedPerSession(departmentId, DateTime.Now);
//grid1.DataSource = lstLeaveAssignedRecord;
//grid1.DataBind();
}
protected void btnAddSession_Click(object sender, EventArgs e)
{
#region Add_Session
DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
DateTime sessionStartDate = new DateTime(Int32.Parse(DateTime.Now.Year.ToString()), 8, 1);
DateTime sessionEndDate = new DateTime(sessionStartDate.Year + 1, 7, 31);
string query = "Select Count(*) from tblSession Where SessionStartDate=@sessionStartDate";
List<SqlParameter> lstParams = new List<SqlParameter>();
lstParams.Add(new SqlParameter("@sessionStartDate", sessionStartDate));
DataTable ds = new DataTable();
using (DBDataHelper objDDBDataHelper = new DBDataHelper())
{
ds = objDDBDataHelper.GetDataTable(query, SQLTextType.Query, lstParams);
}
if (ds.Rows.Count != 0)
if (Int32.Parse(ds.Rows[0][0].ToString()) == 0)
{
string addSession = @"INSERT INTO [dbo].[tblSession]
([SessionStartDate]
,[SessionEndDate])
VALUES (@sessionStartDate,@sessionEndDate)";
List<SqlParameter> lstParams2 = new List<SqlParameter>();
lstParams2.Add(new SqlParameter("@sessionStartDate", sessionStartDate));
lstParams2.Add(new SqlParameter("@sessionEndDate", sessionEndDate));
using (DBDataHelper objDDBDataHelper = new DBDataHelper())
{
objDDBDataHelper.ExecSQL(addSession, SQLTextType.Query, lstParams2);
}
ManageReports objManageReprts = new ManageReports();
objManageReprts.AssignSessionWiseLeave(sessionStartDate);
objManageReprts.UpdateLeaveBalanceTable(sessionStartDate);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Session Added')", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Session Exists')", true);
}
#endregion
}
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();
}
