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