protected void btnUpdatePwd_Click(object sender, EventArgs e) { try { string location = Session["LocationName"].ToString(); string EmpName = Session["EmpName"].ToString().Trim(); int userid = Convert.ToInt32(Session["UserID"]); string oldPwd = txtOldpwd.Text.Trim(); string NewPwd = txtNewPwd.Text.Trim(); Attendance.BAL.EmployeeBL obj = new EmployeeBL(); bool bnew = obj.UpdatePasswordByUserID(userid, oldPwd, NewPwd); if (bnew) { txtOldpwd.Text = ""; txtNewPwd.Text = ""; txtConfirmPwd.Text = ""; mdlChangePwd.Hide(); System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "Script", "alert('Password changed successfully..');", true); } else { txtOldpwd.Text = ""; txtNewPwd.Text = ""; txtConfirmPwd.Text = ""; System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "Script", "alert('Invalid userid and password..');", true); txtOldpwd.Focus(); } } catch (Exception ex) { } }
protected void btnApply_Click(object sender, EventArgs e) { try { int holidayID =hdnHolidayID.Value==""?0:Convert.ToInt32(hdnHolidayID.Value); DateTime HolidayDt = Convert.ToDateTime(hdnHolidayDt.Value); string Holidayname =GeneralFunction.ToProper(txtHolidayName.Text.Trim()); bool IsHoliday = true; if (rdWorkingday.Checked) { IsHoliday = false; } int DeptID = 0; if (ddlPopDept.SelectedItem.Value != "0") { DeptID = Convert.ToInt32(ddlPopDept.SelectedItem.Value); } int LocationID = 0; if (ddlPopLoc.SelectedItem.Value != "0") { LocationID = Convert.ToInt32(ddlPopLoc.SelectedItem.Value); } string shiftName ="0"; if (ddlHolshift.SelectedItem.Value != "0") { shiftName = ddlHolshift.SelectedItem.Value.ToString(); } int EnterBy = Convert.ToInt32(Session["UserID"]); string timezone = ""; if (Convert.ToInt32(Session["TimeZoneID"]) == 2) { timezone = "Eastern Standard Time"; } else { timezone = "India Standard Time"; } DateTime Enterdate = TimeZoneInfo.ConvertTime(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById(timezone)); String strHostName = Request.UserHostAddress.ToString(); string IpAddress = System.Net.Dns.GetHostAddresses(strHostName).GetValue(0).ToString(); EmployeeBL obj = new EmployeeBL(); if (holidayID == 0) { bool bnew = obj.SaveandGetHolidayDet(IsHoliday, HolidayDt, LocationID, DeptID, shiftName, EnterBy, Enterdate, IpAddress, Holidayname, false); } else { bool bnew = obj.UpdateHolidayDet(IsHoliday, holidayID, LocationID, DeptID, shiftName, EnterBy, Enterdate, IpAddress); } GetCalender(Convert.ToDateTime(Session["MonthHolStart"]),Convert.ToDateTime(Session["MonthHolEnd"]),Convert.ToInt32(ddlLocation.SelectedItem.Value),Convert.ToInt32(ddlShift.SelectedValue),Convert.ToInt32(ddlDepartment.SelectedValue)); mdlHoliday.Hide(); } catch (Exception ex) { } }
protected void grdUsers_RowCommand(object sender, GridViewCommandEventArgs e) { EmployeeBL obj = new EmployeeBL(); PayrollEditHistory objPay = new PayrollEditHistory(); try { if (e.CommandName == "Effective") { int EffectiveID = Convert.ToInt32(e.CommandArgument.ToString()); DataTable dt = obj.GetEmpChangesEffectiveByID(EffectiveID); hdnEffectID.Value = dt.Rows[0]["EffectiveID"].ToString(); lblEmpName.Text = dt.Rows[0]["empname"].ToString() + " - " + dt.Rows[0]["empID"].ToString(); lblFieldname.Text = dt.Rows[0]["ChangeField"].ToString(); lblEditFieldName.Text = dt.Rows[0]["ChangeField"].ToString(); lblOldValue.Text = objPay.GetName(dt.Rows[0]["ChangeField"].ToString(), dt.Rows[0]["OldValue"].ToString()); lblEditOldValue.Text = objPay.GetName(dt.Rows[0]["ChangeField"].ToString(), dt.Rows[0]["OldValue"].ToString()); lblNewvalue.Text = objPay.GetName(dt.Rows[0]["ChangeField"].ToString(), dt.Rows[0]["NewValue"].ToString()); lblEffectiveDt.Text = Convert.ToDateTime(dt.Rows[0]["EffectiveDt"].ToString()).ToString("MM/dd/yyyy"); txtEffectiveDate.Text = Convert.ToDateTime(dt.Rows[0]["EffectiveDt"].ToString()).ToString("MM/dd/yyyy"); lblStatus.Text = dt.Rows[0]["ChangeStatus"].ToString(); ddlEditStatus.SelectedIndex = ddlEditStatus.Items.IndexOf(ddlEditStatus.Items.FindByValue(dt.Rows[0]["StatusID"].ToString())); dvView.Style["display"] = "block"; dvEdit.Style["display"] = "none"; if (lblFieldname.Text == "Salary") { lblOldValue.Text = GeneralFunction.FormatCurrency(lblOldValue.Text, ddlLocation.SelectedItem.Text); lblEditOldValue.Text = GeneralFunction.FormatCurrency(lblEditOldValue.Text, ddlLocation.SelectedItem.Text); lblNewvalue.Text = GeneralFunction.FormatCurrency(lblNewvalue.Text, ddlLocation.SelectedItem.Text); } GetNamesList(lblEditFieldName.Text, dt); mdlAddPopUp.Show(); } } catch (Exception ex) { } }
protected void btnUpdate_Click(object sender, EventArgs e) { try { EmployeeBL obj = new EmployeeBL(); string oldValue = ""; string newValue = ""; int effectID = Convert.ToInt32(hdnEffectID.Value); oldValue = lblEditOldValue.Text; if (txtEditNewValue.Text != "") { newValue = txtEditNewValue.Text; } else { newValue = ddlNewValue.SelectedValue; } DateTime effectDt = txtEffectiveDate.Text == "" ? Convert.ToDateTime("01/01/1900") : Convert.ToDateTime(txtEffectiveDate.Text); int statusID = Convert.ToInt32(ddlEditStatus.SelectedValue); bool bnew = obj.UpdateEfectiveChangesByID(effectDt, oldValue, statusID, newValue, effectID); mdlAddPopUp.Hide(); DateTime Start = Convert.ToDateTime(ViewState["StartMonth"]); DateTime End = Convert.ToDateTime(ViewState["EndMonth"]); GetEffectiveData(Convert.ToInt32(ddlLocation.SelectedValue), Convert.ToInt32(ddlgridShift.SelectedValue),Start, End, Convert.ToInt32(ddlSelect.SelectedValue)); } catch (Exception ex) { } }
private void GetYear() { try { EmployeeBL obj = new EmployeeBL(); ddlFromYear.DataSource = obj.GetYear(); ddlFromYear.DataTextField = "year"; ddlFromYear.DataValueField = "year"; ddlFromYear.DataBind(); ddlFromYear.Items.Insert(0, new ListItem("Select", "Select")); ddlFromYear.SelectedIndex = ddlFromYear.Items.IndexOf(ddlFromYear.Items.FindByText(System.DateTime.Now.ToString("yyyy"))); ddlToYear.DataSource = obj.GetYear(); ddlToYear.DataTextField = "year"; ddlToYear.DataValueField = "year"; ddlToYear.DataBind(); ddlToYear.Items.Insert(0, new ListItem("Select", "Select")); ddlToYear.SelectedIndex = ddlToYear.Items.IndexOf(ddlToYear.Items.FindByText(System.DateTime.Now.ToString("yyyy"))); } catch (Exception ex) { } }
private void GetLeavesDetails(string p, DateTime startdate, DateTime Enddate, int AppovedStatusID,int shiftID) { try { EmployeeBL obj = new EmployeeBL(); DataTable dt = obj.GetLeaveDetailsByLoction(p, startdate, Enddate, AppovedStatusID,shiftID); lblMonthRep.Text = "(" + startdate.ToString("MM/dd/yyyy") + " - " + Enddate.ToString("MM/dd/yyyy") + ")"; if (dt.Rows.Count > 0) { grdUsers.DataSource = dt; grdUsers.DataBind(); Session["AllLeaveRequestData"] = dt; lblError.Visible = false; } else { lblError.Text = "No records found"; lblError.Visible = true; } BizUtility.GridSortInitail("Ascending", "Firstname", grdUsers, 0, dt); } catch (Exception ex) { } }
private void GetEmpDet(int empid) { Attendance.BAL.EmployeeBL obj = new EmployeeBL(); try { DataTable dt = obj.GetEmployyeDetailsByUserID(empid); hdnUserID.Value = dt.Rows[0]["UserID"].ToString(); lblEmpID.Text = dt.Rows[0]["EmpID"].ToString(); lblFirstname.Text = dt.Rows[0]["FirstName"].ToString() + " " + dt.Rows[0]["LastName"].ToString(); lblBusinessName.Text = dt.Rows[0]["ProfessionalFirstName"].ToString() + " " + dt.Rows[0]["ProfessionalLastName"].ToString(); hdnFirst.Value = dt.Rows[0]["FirstName"].ToString(); hdnLastname.Value = dt.Rows[0]["LastName"].ToString(); hdnBusinessFirst.Value = dt.Rows[0]["ProfessionalFirstName"].ToString(); hdnBusinessLast.Value = dt.Rows[0]["ProfessionalLastName"].ToString(); lblEmpType.Text = dt.Rows[0]["MasterEmpType"].ToString(); lbldepartment.Text = dt.Rows[0]["DeptName"].ToString(); lblDesignation.Text = dt.Rows[0]["designation"].ToString(); lblStartDate.Text = dt.Rows[0]["startdate"].ToString().Trim() == "" ? "" : Convert.ToDateTime(dt.Rows[0]["startdate"].ToString()).ToString("MM/dd/yyyy") == "01/01/1900" ? "" : Convert.ToDateTime(dt.Rows[0]["startdate"].ToString()).ToString("MM/dd/yyyy"); lblActive.Text = dt.Rows[0]["Isactive"].ToString() == "True" ? "Yes" : "No"; string img = dt.Rows[0]["PhotoLink"].ToString() == "" ? "defaultUSer.jpg" : dt.Rows[0]["PhotoLink"].ToString().Trim(); imgPhoto.ImageUrl = "~/Photos/" + img; if (lblActive.Text == "No") { lbltextTermReason.Visible = true; lbltextTermReason.Text = "<b>Term Reason</b>"; lblTextTermDt.Visible = true; lblTextTermDt.Text = "<b>Term Dt</b>"; lblTermdate.Visible = true; lblTermdate.Text = dt.Rows[0]["TermDate"].ToString().Trim() == "" ? "" : Convert.ToDateTime(dt.Rows[0]["TermDate"].ToString()).ToString("MM/dd/yyyy") == "01/01/1900" ? "" : Convert.ToDateTime(dt.Rows[0]["TermDate"].ToString()).ToString("MM/dd/yyyy"); txtTermReason.Visible = true; txtTermReason.Text = dt.Rows[0]["TermReason"].ToString(); } else { lbltextTermReason.Visible = false; lblTextTermDt.Visible = false; lblTermdate.Visible = false; txtTermReason.Visible = false; } lblWageType.Text = dt.Rows[0]["WageType"].ToString(); ViewState["Salary"] = dt.Rows[0]["Salary"].ToString() == "" ? "" : dt.Rows[0]["Salary"].ToString() == "0.00" ? "" : dt.Rows[0]["Salary"].ToString(); lblSalary.Text = dt.Rows[0]["Salary"].ToString() == "" ? "" : dt.Rows[0]["Salary"].ToString() == "0.00" ? "" : dt.Rows[0]["Salary"].ToString(); lblSalary.Text = lblSalary.Text == "" ? "" : GeneralFunction.FormatCurrency(lblSalary.Text, ViewState["Location"].ToString().Trim()); lblDeuctions.Text = dt.Rows[0]["Deductions"].ToString(); lblGender.Text = dt.Rows[0]["gender"].ToString(); lblFilling.Text = dt.Rows[0]["MaritalStatus"].ToString(); hdnScID.Value = dt.Rows[0]["ScheduleId"].ToString(); lblSchedule.Text = dt.Rows[0]["StartTime"].ToString() + "-" + dt.Rows[0]["EndTime"].ToString() + " " + "<b>Lunch break: </b>" + dt.Rows[0]["LunchBreakStart"].ToString() + "-" + dt.Rows[0]["LunchBreakEnd"].ToString(); lblDateofBirth.Text = dt.Rows[0]["dateofbirth"].ToString() == "" ? "" : Convert.ToDateTime(dt.Rows[0]["dateofbirth"].ToString().Trim()).ToString("MM/dd/yyyy") == "01/01/1900" ? "" : Convert.ToDateTime(dt.Rows[0]["dateofbirth"].ToString()).ToString("MM/dd/yyyy"); lblPhoneNum.Text = dt.Rows[0]["phoneNum"].ToString() == "" ? "" : GeneralFunction.FormatUsTelephoneNo(dt.Rows[0]["phoneNum"].ToString()); lblMobileNum.Text = dt.Rows[0]["mobileNum"].ToString() == "" ? "" : GeneralFunction.FormatUsTelephoneNo(dt.Rows[0]["mobileNum"].ToString()); lblBusinessemail.Text = dt.Rows[0]["businessEmail"].ToString(); lblPersonalEmail.Text = dt.Rows[0]["personalEmail"].ToString(); lblSSN.Text = GeneralFunction.FormatUsSSN(dt.Rows[0]["ssn"].ToString()); lblAddress.Text = dt.Rows[0]["Address1"].ToString() == "" ? "" : GeneralFunction.ToProperNotes(dt.Rows[0]["Address1"].ToString()); txtAddress1.Text = dt.Rows[0]["Address1"].ToString() == "" ? "" : GeneralFunction.ToProperNotes(dt.Rows[0]["Address1"].ToString()); lblAddress.Text = lblAddress.Text + (dt.Rows[0]["Address2"].ToString() == "" ? "" : "<br/>" + GeneralFunction.ToProperNotes(dt.Rows[0]["Address2"].ToString())); txtAddress2.Text = dt.Rows[0]["Address2"].ToString() == "" ? "" : GeneralFunction.ToProperNotes(dt.Rows[0]["Address2"].ToString()); lblAddress.Text = lblAddress.Text + (dt.Rows[0]["StateCode"].ToString() == "UN" ? "" : "<br/>" + dt.Rows[0]["StateCode"].ToString()); ddlState.SelectedIndex = ddlState.Items.IndexOf(ddlState.Items.FindByValue(dt.Rows[0]["StateID"].ToString())); lblAddress.Text = lblAddress.Text + (dt.Rows[0]["zip"].ToString() == "" ? "" : " " + dt.Rows[0]["zip"].ToString()); txtZip.Text = dt.Rows[0]["zip"].ToString() == "" ? "" : dt.Rows[0]["zip"].ToString(); lblLicense.Text = dt.Rows[0]["drivingLicenceNum"].ToString(); lblCn1Address.Text = dt.Rows[0]["P1Address1"].ToString() == "" ? "" : GeneralFunction.ToProperNotes(dt.Rows[0]["P1Address1"].ToString()); txtCn1Address1.Text = dt.Rows[0]["P1Address1"].ToString() == "" ? "" : GeneralFunction.ToProperNotes(dt.Rows[0]["P1Address1"].ToString()); lblCn1Address.Text = lblCn1Address.Text + (lblCn1Address.Text != "" ? (dt.Rows[0]["P1Address2"].ToString() == "" ? "" : "<br/>" + GeneralFunction.ToProperNotes(dt.Rows[0]["P1Address2"].ToString())) : (dt.Rows[0]["P1Address2"].ToString() == "" ? "" : GeneralFunction.ToProperNotes(dt.Rows[0]["P1Address2"].ToString()))); txtCn1Address2.Text = dt.Rows[0]["P1Address2"].ToString() == "" ? "" : GeneralFunction.ToProperNotes(dt.Rows[0]["P1Address2"].ToString()); lblCn1Address.Text = lblCn1Address.Text + (lblCn1Address.Text != "" ? (dt.Rows[0]["state1"].ToString() == "UN" ? "" : "<br/>" + dt.Rows[0]["state1"].ToString()) : dt.Rows[0]["state1"].ToString() == "UN" ? "" : dt.Rows[0]["state1"].ToString()); ddlCn1State.SelectedIndex = ddlCn1State.Items.IndexOf(ddlCn1State.Items.FindByValue(dt.Rows[0]["stateID1"].ToString())); lblCn1Address.Text = lblCn1Address.Text + (lblCn1Address.Text != "" ? (dt.Rows[0]["zip1"].ToString() == "" ? "" : " " + dt.Rows[0]["zip1"].ToString()) : (dt.Rows[0]["zip1"].ToString() == "" ? "" : dt.Rows[0]["zip1"].ToString())); txtCn1Zip.Text = dt.Rows[0]["zip1"].ToString(); lblCn1Name.Text = dt.Rows[0]["Person1"].ToString(); txtCn1Name.Text = dt.Rows[0]["Person1"].ToString(); lblCn1Phone.Text = dt.Rows[0]["phone1"].ToString() == "" ? "" : GeneralFunction.FormatUsTelephoneNo(dt.Rows[0]["phone1"].ToString()); txtCn1Phone.Text = lblCn1Phone.Text.Replace("-", "").Trim(); lblCn1Email.Text = dt.Rows[0]["email1"].ToString(); txtCn1Email.Text = dt.Rows[0]["email1"].ToString(); lblCn1Relation.Text = dt.Rows[0]["relation1"].ToString(); txtCn1Relation.Text = dt.Rows[0]["relation1"].ToString(); lblCn2Address.Text = dt.Rows[0]["P2Address1"].ToString() == "" ? "" : GeneralFunction.ToProperNotes(dt.Rows[0]["P2Address1"].ToString()); txtCn2Address1.Text = dt.Rows[0]["P2Address1"].ToString() == "" ? "" : GeneralFunction.ToProperNotes(dt.Rows[0]["P2Address1"].ToString()); lblCn2Address.Text = lblCn2Address.Text + (lblCn2Address.Text != "" ? (dt.Rows[0]["P2Address2"].ToString() == "" ? "" : "<br/>" +GeneralFunction.ToProperNotes(dt.Rows[0]["P2Address2"].ToString())) : (dt.Rows[0]["P2Address2"].ToString() == "" ? "" : GeneralFunction.ToProperNotes(dt.Rows[0]["P2Address2"].ToString()))); txtCn2Address2.Text = dt.Rows[0]["P2Address2"].ToString() == "" ? "" : GeneralFunction.ToProperNotes(dt.Rows[0]["P2Address2"].ToString()); ddlCn2State.SelectedIndex = ddlCn1State.Items.IndexOf(ddlCn2State.Items.FindByValue(dt.Rows[0]["stateID2"].ToString())); lblCn2Address.Text = lblCn2Address.Text + (lblCn2Address.Text != "" ? (dt.Rows[0]["state2"].ToString() == "UN" ? "" : "<br/>" + dt.Rows[0]["state2"].ToString()) : dt.Rows[0]["state2"].ToString() == "UN" ? "" : dt.Rows[0]["state2"].ToString()); lblCn2Address.Text = lblCn2Address.Text + (lblCn2Address.Text != "" ? (dt.Rows[0]["zip2"].ToString() == "" ? "" : " " + dt.Rows[0]["zip2"].ToString()) : (dt.Rows[0]["zip2"].ToString() == "" ? "" : dt.Rows[0]["zip2"].ToString())); txtCn2Zip.Text = dt.Rows[0]["zip2"].ToString(); lblCn2Name.Text = dt.Rows[0]["Person2"].ToString(); txtCn2Name.Text = dt.Rows[0]["Person2"].ToString(); lblCn2Phone.Text = dt.Rows[0]["phone2"].ToString() == "" ? "" : GeneralFunction.FormatUsTelephoneNo(dt.Rows[0]["phone2"].ToString()); txtCn2Phone.Text = lblCn2Phone.Text.Replace("-", "").Trim(); lblCn2Relation.Text = dt.Rows[0]["relation2"].ToString(); txtCn2Relation.Text = dt.Rows[0]["relation2"].ToString(); lblCn2Email.Text = dt.Rows[0]["email2"].ToString(); txtCn2Email.Text = dt.Rows[0]["email2"].ToString(); lblCn3Address.Text = dt.Rows[0]["P3Address1"].ToString() == "" ? "" : GeneralFunction.ToProperNotes(dt.Rows[0]["P3Address1"].ToString()); txtCn3Address1.Text = dt.Rows[0]["P3Address1"].ToString() == "" ? "" : GeneralFunction.ToProperNotes(dt.Rows[0]["P3Address1"].ToString()); lblCn3Address.Text = lblCn3Address.Text + (lblCn2Address.Text != "" ? (dt.Rows[0]["P3Address2"].ToString() == "" ? "" : "<br/>" +GeneralFunction.ToProperNotes(dt.Rows[0]["P3Address2"].ToString())) : (dt.Rows[0]["P3Address2"].ToString() == "" ? "" : GeneralFunction.ToProperNotes(dt.Rows[0]["P3Address2"].ToString()))); txtCn3Address2.Text = dt.Rows[0]["P3Address2"].ToString() == "" ? "" : GeneralFunction.ToProperNotes(dt.Rows[0]["P3Address2"].ToString()); lblCn3Address.Text = lblCn3Address.Text + (lblCn2Address.Text != "" ? (dt.Rows[0]["state3"].ToString() == "UN" ? "" : "<br/>" + dt.Rows[0]["state3"].ToString()) : dt.Rows[0]["state3"].ToString() == "UN" ? "" : dt.Rows[0]["state3"].ToString()); ddlCn3State.SelectedIndex = ddlCn1State.Items.IndexOf(ddlCn3State.Items.FindByValue(dt.Rows[0]["stateID3"].ToString())); lblCn3Address.Text = lblCn3Address.Text + (lblCn2Address.Text != "" ? (dt.Rows[0]["zip3"].ToString() == "" ? "" : " " + dt.Rows[0]["zip3"].ToString()) : (dt.Rows[0]["zip3"].ToString() == "" ? "" : dt.Rows[0]["zip3"].ToString())); txtCn2Zip.Text = dt.Rows[0]["zip3"].ToString(); lblCn3Name.Text = dt.Rows[0]["Person3"].ToString(); txtCn3Name.Text = dt.Rows[0]["Person3"].ToString(); txtCn3Phone.Text = dt.Rows[0]["phone3"].ToString(); lblCn3Phone.Text = dt.Rows[0]["phone3"].ToString() == "" ? "" : GeneralFunction.FormatUsTelephoneNo(dt.Rows[0]["phone3"].ToString()); lblCn3Relation.Text = dt.Rows[0]["relation3"].ToString(); txtCn3Relation.Text = dt.Rows[0]["relation3"].ToString(); lblCn3Email.Text = dt.Rows[0]["email3"].ToString(); txtCn3Email.Text = dt.Rows[0]["email3"].ToString(); } catch (Exception ex) { } }
private void GetNamesList(string Fieldname, DataTable dt) { try { if (Fieldname == "Department") { Attendance.BAL.Report obj = new Report(); DataTable ds = obj.GetAllDepartments(); ddlNewValue.DataSource = ds; ddlNewValue.DataTextField = "DeptName"; ddlNewValue.DataValueField = "DeptID"; ddlNewValue.DataBind(); ddlNewValue.SelectedIndex = ddlNewValue.Items.IndexOf(ddlNewValue.Items.FindByValue(dt.Rows[0]["NewValue"].ToString())); txtEditNewValue.Visible = false; ddlNewValue.Visible = true; } else if (Fieldname == "Location") { Attendance.BAL.Report obj = new Report(); DataTable ds = obj.GetLocations(); ddlNewValue.DataSource = ds; ddlNewValue.DataTextField = "LocationName"; ddlNewValue.DataValueField = "LocationId"; ddlNewValue.DataBind(); ddlNewValue.SelectedIndex = ddlNewValue.Items.IndexOf(ddlNewValue.Items.FindByValue(dt.Rows[0]["NewValue"].ToString())); txtEditNewValue.Visible = false; ddlNewValue.Visible = true; } else if (Fieldname == "Schedule") { Attendance.BAL.Report obj = new Attendance.BAL.Report(); DataTable ds = obj.GetAllScheduleTypes(); ddlNewValue.DataSource = ds; ddlNewValue.DataValueField = "ScheduleID"; ddlNewValue.DataTextField = "ScheduleType"; ddlNewValue.DataBind(); ddlNewValue.SelectedIndex = ddlNewValue.Items.IndexOf(ddlNewValue.Items.FindByValue(dt.Rows[0]["NewValue"].ToString())); txtEditNewValue.Visible = false; ddlNewValue.Visible = true; } else if (Fieldname == "State") { Attendance.BAL.Business obj = new Attendance.BAL.Business(); DataTable ds = obj.GetState(); ddlNewValue.DataSource = ds; ddlNewValue.DataValueField = "StateID"; ddlNewValue.DataTextField = "StateName"; ddlNewValue.DataBind(); ddlNewValue.SelectedIndex = ddlNewValue.Items.IndexOf(ddlNewValue.Items.FindByValue(dt.Rows[0]["NewValue"].ToString())); txtEditNewValue.Visible = false; ddlNewValue.Visible = true; } else if (Fieldname == "Wage") { Attendance.BAL.Report obj = new Attendance.BAL.Report(); DataTable ds = obj.GetAllWages(); ddlNewValue.DataSource = ds; ddlNewValue.DataValueField = "WageID"; ddlNewValue.DataTextField = "WageType"; ddlNewValue.DataBind(); txtEditNewValue.Visible = false; ddlNewValue.Visible = true; ddlNewValue.SelectedIndex = ddlNewValue.Items.IndexOf(ddlNewValue.Items.FindByValue(dt.Rows[0]["NewValue"].ToString())); } else if (Fieldname == "Employee type") { Attendance.BAL.Report obj = new Attendance.BAL.Report(); DataTable ds = obj.GetAllEmployeetypes(); ddlNewValue.DataSource = ds; ddlNewValue.DataValueField = "EmpType"; ddlNewValue.DataTextField = "EmpTypeID"; ddlNewValue.DataBind(); ddlNewValue.SelectedIndex = ddlNewValue.Items.IndexOf(ddlNewValue.Items.FindByValue(dt.Rows[0]["NewValue"].ToString())); txtEditNewValue.Visible = false; ddlNewValue.Visible = true; } else if (Fieldname == "Shift") { Attendance.BAL.EmployeeBL obj = new Attendance.BAL.EmployeeBL(); DataTable ds = obj.GetShifts(); DataView dv = ds.DefaultView; dv.RowFilter = "locationID=" + Convert.ToInt32(dt.Rows[0]["locationID"].ToString()); DataTable dt1 = dv.ToTable(); ddlNewValue.DataSource = dt1; ddlNewValue.DataTextField = "ShiftName"; ddlNewValue.DataValueField = "ShiftID"; ddlNewValue.DataBind(); ddlNewValue.SelectedIndex = ddlNewValue.Items.IndexOf(ddlNewValue.Items.FindByValue(dt.Rows[0]["NewValue"].ToString())); txtEditNewValue.Visible = false; ddlNewValue.Visible = true; } else if (Fieldname == "Filling status") { ddlNewValue.DataSource = null; ddlNewValue.DataBind(); ddlNewValue.Items.Insert(0, new ListItem("Single", "1")); ddlNewValue.Items.Insert(1, new ListItem("Married", "2")); txtEditNewValue.Visible = false; ddlNewValue.Visible = true; ddlNewValue.SelectedIndex = ddlNewValue.Items.IndexOf(ddlNewValue.Items.FindByValue(dt.Rows[0]["NewValue"].ToString())); } else { txtEditNewValue.Text = dt.Rows[0]["NewValue"].ToString(); txtEditNewValue.Visible = true; ddlNewValue.Visible = false; } } catch (Exception ex) { } }
protected void btnLeaveReqSubmit_Click(object sender, EventArgs e) { try { Business obj = new Business(); int userid = Convert.ToInt32(Session["UserID"]); DateTime FromDate = Convert.ToDateTime(txtLeaveFrom.Text); DateTime ToDate = Convert.ToDateTime(txtLeaveTo.Text); string Reason = txtReason.Text == "" ? "" : GeneralFunction.ToProperNotes(txtReason.Text); string timezone = ""; if (Convert.ToInt32(Session["TimeZoneID"]) == 2) { timezone = "Eastern Standard Time"; } else { timezone = "India Standard Time"; } DateTime ISTTime = TimeZoneInfo.ConvertTime(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById(timezone)); DataSet ds = obj.SaveLeaveRequestDetails(userid, "", FromDate, ToDate, ISTTime, Reason, ""); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["LeaveID"].ToString() == "Applied") { lblLeaveError.Text = "You have already applied leave for these days"; lblLeaveError.Visible = true; txtReason.Text = ""; txtLeaveFrom.Text = ""; txtLeaveTo.Text = ""; } else { System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "Script", "alert('Leave request updated successfully');", true); mdlNewLeaveRequest.Hide(); DateTime startDate = Convert.ToDateTime(Session["TodayDate"]); DateTime endDate = startDate.AddDays(7); EmployeeBL objLeave = new EmployeeBL(); DataTable datas = objLeave.GetLeaveRequestDetByUserID(Convert.ToInt32(Session["UserID"]), startDate, endDate); grdSingleLeaveReq.DataSource = datas; grdSingleLeaveReq.DataBind(); objLeave = null; } } } } catch (Exception ex) { } }
private void GetCalender(DateTime MonthStart, DateTime MonthEnd, int locationID) { EmployeeBL obj = new EmployeeBL(); DataTable dtAttandence = new DataTable(); try { DataTable dt = obj.GetHolidayDetByLoc(MonthStart, MonthEnd, locationID,0,0); Session["HolidayMgmt"] = dt; dtAttandence.Columns.Add("Sunday", typeof(string)); dtAttandence.Columns.Add("Monday", typeof(string)); dtAttandence.Columns.Add("Tuesday", typeof(string)); dtAttandence.Columns.Add("Wednesday", typeof(string)); dtAttandence.Columns.Add("Thursday", typeof(string)); dtAttandence.Columns.Add("Friday", typeof(string)); dtAttandence.Columns.Add("Saturday", typeof(string)); DateTime current = Convert.ToDateTime("01/01/1900"); bool first = true; DayOfWeek GetDay = Convert.ToDateTime(MonthStart).DayOfWeek; int days = 1; for (int j = 0; j < 7; j++) { dtAttandence.Rows.Add(); if (first) { first = false; switch (GetDay) { case DayOfWeek.Sunday: current = MonthStart; dtAttandence.Rows[j]["Sunday"] = current; days++; current = current.AddDays(1); dtAttandence.Rows[j]["Monday"] = current; days++; current = current.AddDays(1); dtAttandence.Rows[j]["Tuesday"] = current; days++; current = current.AddDays(1); dtAttandence.Rows[j]["Wednesday"] = current; days++; current = current.AddDays(1); dtAttandence.Rows[j]["Thursday"] = current; days++; current = current.AddDays(1); dtAttandence.Rows[j]["Friday"] = current; days++; current = current.AddDays(1); dtAttandence.Rows[j]["Saturday"] = current; days++; break; case DayOfWeek.Monday: current = MonthStart; dtAttandence.Rows[j]["Monday"] = current; days++; current = current.AddDays(1); dtAttandence.Rows[j]["Tuesday"] = current; days++; current = current.AddDays(1); dtAttandence.Rows[j]["Wednesday"] = current; days++; current = current.AddDays(1); dtAttandence.Rows[j]["Thursday"] = current; days++; current = current.AddDays(1); dtAttandence.Rows[j]["Friday"] = current; days++; current = current.AddDays(1); dtAttandence.Rows[j]["Saturday"] = current; days++; break; case DayOfWeek.Tuesday: current = MonthStart; dtAttandence.Rows[j]["Tuesday"] = current; days++; current = current.AddDays(1); dtAttandence.Rows[j]["Wednesday"] = current; days++; current = current.AddDays(1); dtAttandence.Rows[j]["Thursday"] = current; days++; current = current.AddDays(1); dtAttandence.Rows[j]["Friday"] = current; days++; current = current.AddDays(1); dtAttandence.Rows[j]["Saturday"] = current; days++; break; // TODO: might not be correct. Was : Exit Select case DayOfWeek.Wednesday: current = MonthStart; dtAttandence.Rows[j]["Wednesday"] = current; days++; current = current.AddDays(1); dtAttandence.Rows[j]["Thursday"] = current; days++; current = current.AddDays(1); dtAttandence.Rows[j]["Friday"] = current; days++; current = current.AddDays(1); dtAttandence.Rows[j]["Saturday"] = current; days++; break; case DayOfWeek.Thursday: current = MonthStart; dtAttandence.Rows[j]["Thursday"] = current; days++; current = current.AddDays(1); dtAttandence.Rows[j]["Friday"] = current; days++; current = current.AddDays(1); dtAttandence.Rows[j]["Saturday"] = current; days++; break; case DayOfWeek.Friday: current = MonthStart; dtAttandence.Rows[j]["Friday"] = current; days++; current = current.AddDays(1); dtAttandence.Rows[j]["Saturday"] = current; days++; break; case DayOfWeek.Saturday: current = MonthStart; dtAttandence.Rows[j]["Saturday"] = current; days++; break; } } else { if (days <= Convert.ToInt32(MonthEnd.ToString("dd"))) { current = current.AddDays(1); dtAttandence.Rows[j]["Sunday"] = current; days++; } if (days <= Convert.ToInt32(MonthEnd.ToString("dd"))) { current = current.AddDays(1); dtAttandence.Rows[j]["Monday"] = current; days++; } if (days <= Convert.ToInt32(MonthEnd.ToString("dd"))) { current = current.AddDays(1); dtAttandence.Rows[j]["Tuesday"] = current; days++; } if (days <= Convert.ToInt32(MonthEnd.ToString("dd"))) { current = current.AddDays(1); dtAttandence.Rows[j]["Wednesday"] = current; days++; } if (days <= Convert.ToInt32(MonthEnd.ToString("dd"))) { current = current.AddDays(1); dtAttandence.Rows[j]["Thursday"] = current; days++; } if (days <= Convert.ToInt32(MonthEnd.ToString("dd"))) { current = current.AddDays(1); dtAttandence.Rows[j]["Friday"] = current; days++; } if (days <= Convert.ToInt32(MonthEnd.ToString("dd"))) { current = current.AddDays(1); dtAttandence.Rows[j]["Saturday"] = current; days++; } if (days >= Convert.ToInt32(MonthEnd.ToString("dd"))) { j = 6; } } } DataTable dsMonth = GetMonthlyRepByuserID(MonthStart, MonthEnd, Convert.ToInt32(Session["userID"])); Session["MonthRep"] = dsMonth; grdMonthlyRep.DataSource = dtAttandence; grdMonthlyRep.DataBind(); } catch (Exception ex) { } }
private DataTable GetReportIndia1(DateTime StartDate, DateTime EndTime, int LocationID, int shiftID) { DataTable dtPayroll = new DataTable(); dtPayroll.Columns.Add("empid", typeof(string)); dtPayroll.Columns.Add("Empname", typeof(string)); dtPayroll.Columns.Add("PEmpname", typeof(string)); dtPayroll.Columns.Add("Termdate", typeof(DateTime)); dtPayroll.Columns.Add("Startdate", typeof(DateTime)); dtPayroll.Columns.Add("DeptName", typeof(string)); dtPayroll.Columns.Add("LocationName", typeof(string)); dtPayroll.Columns.Add("MasterEmpType", typeof(string)); dtPayroll.Columns.Add("LocDescriptiom", typeof(string)); dtPayroll.Columns.Add("userid", typeof(string)); dtPayroll.Columns.Add("Workingdays", typeof(int)); dtPayroll.Columns.Add("Present", typeof(double)); dtPayroll.Columns.Add("paidLeaves", typeof(int)); dtPayroll.Columns.Add("Leaves", typeof(int)); dtPayroll.Columns.Add("Holidays", typeof(int)); dtPayroll.Columns.Add("LeavesAvailable", typeof(int)); dtPayroll.Columns.Add("PaidLeaveStartDt", typeof(DateTime)); dtPayroll.Columns.Add("PaidLeavesBalanced", typeof(int)); dtPayroll.Columns.Add("PaidLeavesUsed", typeof(int)); dtPayroll.Columns.Add("CalLeaves", typeof(int)); dtPayroll.Columns.Add("Salary", typeof(double)); dtPayroll.Columns.Add("Noshow", typeof(int)); dtPayroll.Columns.Add("CalSalary", typeof(double)); dtPayroll.Columns.Add("Bonus", typeof(double)); dtPayroll.Columns.Add("Incentives", typeof(double)); dtPayroll.Columns.Add("PrevUnpaid", typeof(double)); dtPayroll.Columns.Add("AdvancePaid", typeof(double)); dtPayroll.Columns.Add("Expenses", typeof(double)); dtPayroll.Columns.Add("LoanDeduct", typeof(double)); dtPayroll.Columns.Add("TotalPay", typeof(double)); try { DataSet ds = new DataSet(); SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["AttendanceConn"].ToString()); SqlCommand cmd = new SqlCommand(); SqlDataAdapter da = new SqlDataAdapter("[USP_FnAdmin]", con); da.SelectCommand.Parameters.Add(new SqlParameter("@shiftID", shiftID)); da.SelectCommand.Parameters.Add(new SqlParameter("@LocationID", LocationID)); da.SelectCommand.Parameters.Add(new SqlParameter("@startdate", StartDate)); da.SelectCommand.Parameters.Add(new SqlParameter("@EndDate", EndTime)); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.Fill(ds); EmployeeBL obj = new EmployeeBL(); // DataTable dtPaid = GetPayrollDataByLoc(LocationID, StartDate.AddMonths(-1), StartDate.AddSeconds(-1)); DataTable dtPaid1 = obj.Usp_GetEmployeePayrollDataByLocation(LocationID, StartDate, EndTime,Convert.ToInt32(ddlShift.SelectedValue)); DataTable dtPaid = obj.GetEmpPaidleavesDetailsByLocation(LocationID, StartDate.AddMonths(-1), StartDate.AddSeconds(-1),Convert.ToInt32(ddlShift.SelectedValue)); int days = (Convert.ToInt32(EndTime.ToString("dd")) - Convert.ToInt32(StartDate.ToString("dd"))) + 1; if (ds.Tables.Count > 0) { if (ds.Tables.Count > 1) { for (int j = 0; j < ds.Tables[0].Rows.Count; j++) { dtPayroll.Rows.Add(); if (dtPaid1.Rows.Count > 0) { DataView dvP = dtPaid1.DefaultView; DataTable dtPaidLev = new DataTable(); dvP.RowFilter = "empid='" + ds.Tables[0].Rows[j]["empid"].ToString() + "'"; dtPaidLev = dvP.ToTable(); dtPayroll.Rows[j]["userid"] = ds.Tables[0].Rows[j]["userid"].ToString(); dtPayroll.Rows[j]["empid"] = ds.Tables[0].Rows[j]["empid"].ToString(); dtPayroll.Rows[j]["Empname"] = ds.Tables[0].Rows[j]["firstName"].ToString() + " " + ds.Tables[0].Rows[j]["lastname"].ToString(); dtPayroll.Rows[j]["PEmpname"] = ds.Tables[0].Rows[j]["PfirstName"].ToString() + " " + ds.Tables[0].Rows[j]["Plastname"].ToString(); dtPayroll.Rows[j]["Termdate"] = ds.Tables[0].Rows[j]["Termdate"].ToString() == "NULL" ? Convert.ToDateTime("01/01/1900") : ds.Tables[0].Rows[j]["Termdate"].ToString() == "" ? Convert.ToDateTime("01/01/1900") : Convert.ToDateTime(Convert.ToDateTime(ds.Tables[0].Rows[j]["Termdate"]).ToString("MM/dd/yyyy")); dtPayroll.Rows[j]["Startdate"] = ds.Tables[0].Rows[j]["Startdate"].ToString() == "NULL" ? Convert.ToDateTime("01/01/1900") : ds.Tables[0].Rows[j]["Startdate"].ToString() == "" ? Convert.ToDateTime("01/01/1900") : Convert.ToDateTime(Convert.ToDateTime(ds.Tables[0].Rows[j]["Startdate"]).ToString("MM/dd/yyyy")); dtPayroll.Rows[j]["DeptName"] = ds.Tables[0].Rows[j]["DeptName"].ToString() == "NULL" ? "" : ds.Tables[0].Rows[j]["DeptName"].ToString(); dtPayroll.Rows[j]["LocationName"] = ds.Tables[0].Rows[j]["LocationName"].ToString() == "NULL" ? "" : ds.Tables[0].Rows[j]["LocationName"].ToString(); dtPayroll.Rows[j]["MasterEmpType"] = ds.Tables[0].Rows[j]["EmpType"].ToString() == "NULL" ? "" : ds.Tables[0].Rows[j]["EmpType"].ToString(); dtPayroll.Rows[j]["LocDescriptiom"] = ds.Tables[0].Rows[j]["LocDescriptiom"].ToString() == "NULL" ? "" : ds.Tables[0].Rows[j]["LocDescriptiom"].ToString(); dtPayroll.Rows[j]["Salary"] = ds.Tables[0].Rows[j]["Salary"].ToString() == "" ? 0.0 : ds.Tables[0].Rows[j]["Salary"].ToString() == "NULL" ? 0.0 : Convert.ToDouble(ds.Tables[0].Rows[j]["Salary"].ToString()); dtPayroll.Rows[j]["Workingdays"] = dtPaidLev.Rows[0]["WkngDays"].ToString() == "" ? 0.0 : dtPaidLev.Rows[0]["WkngDays"].ToString() == "NULL" ? 0.0 : Convert.ToDouble(dtPaidLev.Rows[0]["WkngDays"].ToString()); dtPayroll.Rows[j]["Present"] = dtPaidLev.Rows[0]["Atndays"].ToString() == "" ? 0.0 : dtPaidLev.Rows[0]["Atndays"].ToString() == "NULL" ? 0.0 : Convert.ToDouble(dtPaidLev.Rows[0]["Atndays"].ToString()); dtPayroll.Rows[j]["Leaves"] = dtPaidLev.Rows[0]["Leaves"].ToString() == "" ? 0.0 : dtPaidLev.Rows[0]["Leaves"].ToString() == "NULL" ? 0.0 : Convert.ToDouble(dtPaidLev.Rows[0]["Leaves"].ToString()); dtPayroll.Rows[j]["Noshow"] = dtPaidLev.Rows[0]["Noshow"].ToString() == "" ? 0.0 : dtPaidLev.Rows[0]["Noshow"].ToString() == "NULL" ? 0.0 : Convert.ToDouble(dtPaidLev.Rows[0]["Noshow"].ToString()); dtPayroll.Rows[j]["LeavesAvailable"] = dtPaidLev.Rows[0]["PaidLeaves"].ToString() == "" ? 0.0 : dtPaidLev.Rows[0]["PaidLeaves"].ToString() == "NULL" ? 0.0 : Convert.ToDouble(dtPaidLev.Rows[0]["PaidLeaves"].ToString()); dtPayroll.Rows[j]["PaidLeavesUsed"] = dtPaidLev.Rows[0]["PaidLeavesUsed"].ToString() == "" ? 0.0 : dtPaidLev.Rows[0]["PaidLeavesUsed"].ToString() == "NULL" ? 0.0 : Convert.ToDouble(dtPaidLev.Rows[0]["PaidLeavesUsed"].ToString()); dtPayroll.Rows[j]["PaidLeavesBalanced"] = dtPaidLev.Rows[0]["PaidLeavesBalanced"].ToString() == "" ? 0.0 : dtPaidLev.Rows[0]["PaidLeavesBalanced"].ToString() == "NULL" ? 0.0 : Convert.ToDouble(dtPaidLev.Rows[0]["PaidLeavesBalanced"].ToString()); dtPayroll.Rows[j]["CalLeaves"] = dtPaidLev.Rows[0]["TotalCalLeaves"].ToString() == "" ? 0.0 : dtPaidLev.Rows[0]["TotalCalLeaves"].ToString() == "NULL" ? 0.0 : Convert.ToDouble(dtPaidLev.Rows[0]["TotalCalLeaves"].ToString()); dtPayroll.Rows[j]["CalSalary"] = dtPaidLev.Rows[0]["CalSalary"].ToString() == "" ? 0.0 : dtPaidLev.Rows[0]["CalSalary"].ToString() == "NULL" ? 0.0 : Convert.ToDouble(dtPaidLev.Rows[0]["CalSalary"].ToString()); dtPayroll.Rows[j]["Bonus"] = dtPaidLev.Rows[0]["Bonus"].ToString() == "" ? 0.0 : dtPaidLev.Rows[0]["Bonus"].ToString() == "NULL" ? 0.0 : Convert.ToDouble(dtPaidLev.Rows[0]["Bonus"].ToString()); dtPayroll.Rows[j]["Incentives"] = dtPaidLev.Rows[0]["Incentives"].ToString() == "" ? 0.0 : dtPaidLev.Rows[0]["Incentives"].ToString() == "NULL" ? 0.0 : Convert.ToDouble(dtPaidLev.Rows[0]["Incentives"].ToString()); dtPayroll.Rows[j]["PrevUnpaid"] = dtPaidLev.Rows[0]["PrevUnpaid"].ToString() == "" ? 0.0 : dtPaidLev.Rows[0]["PrevUnpaid"].ToString() == "NULL" ? 0.0 : Convert.ToDouble(dtPaidLev.Rows[0]["PrevUnpaid"].ToString()); dtPayroll.Rows[j]["AdvancePaid"] = dtPaidLev.Rows[0]["Advancepaid"].ToString() == "" ? 0.0 : dtPaidLev.Rows[0]["Advancepaid"].ToString() == "NULL" ? 0.0 : Convert.ToDouble(dtPaidLev.Rows[0]["Advancepaid"].ToString()); dtPayroll.Rows[j]["Expenses"] = dtPaidLev.Rows[0]["ExpensesRecieved"].ToString() == "" ? 0.0 : dtPaidLev.Rows[0]["ExpensesRecieved"].ToString() == "NULL" ? 0.0 : Convert.ToDouble(dtPaidLev.Rows[0]["ExpensesRecieved"].ToString()); dtPayroll.Rows[j]["LoanDeduct"] = dtPaidLev.Rows[0]["LoanDeduct"].ToString() == "" ? 0.0 : dtPaidLev.Rows[0]["LoanDeduct"].ToString() == "NULL" ? 0.0 : Convert.ToDouble(dtPaidLev.Rows[0]["LoanDeduct"].ToString()); dtPayroll.Rows[j]["TotalPay"] = dtPaidLev.Rows[0]["TotalPay"].ToString() == "" ? 0.0 : dtPaidLev.Rows[0]["TotalPay"].ToString() == "NULL" ? 0.0 : Convert.ToDouble(dtPaidLev.Rows[0]["TotalPay"].ToString()); } else { DataTable dt = ds.Tables[1]; DataView dv = dt.DefaultView; DataTable dtname = new DataTable(); DateTime NextDate = GeneralFunction.GetNextDayOfWeekDate(StartDate); DataTable dtL = ds.Tables[2]; DataView dvL = dtL.DefaultView; DataTable dtLeave = new DataTable(); DataTable dtH = ds.Tables[3]; DataView dvH = dtH.DefaultView; DataTable dtHoliday = new DataTable(); DataView dvP = dtPaid.DefaultView; DataTable dtPaidLev = new DataTable(); dv.RowFilter = "empid='" + ds.Tables[0].Rows[j]["empid"].ToString() + "'"; dtname = dv.ToTable(); dvL.RowFilter = "empid='" + ds.Tables[0].Rows[j]["empid"].ToString() + "'"; dtLeave = dvL.ToTable(); dvH.RowFilter = "empid='" + ds.Tables[0].Rows[j]["empid"].ToString() + "'"; dtHoliday = dvH.ToTable(); dvP.RowFilter = "empid='" + ds.Tables[0].Rows[j]["empid"].ToString() + "'"; dtPaidLev = dvP.ToTable(); int holidays = 0; int leaves = 0; double present = 0.0; int noshow = 0; dtPayroll.Rows[j]["userid"] = ds.Tables[0].Rows[j]["userid"].ToString(); dtPayroll.Rows[j]["empid"] = ds.Tables[0].Rows[j]["empid"].ToString(); dtPayroll.Rows[j]["Empname"] = ds.Tables[0].Rows[j]["firstName"].ToString() + " " + ds.Tables[0].Rows[j]["lastname"].ToString(); dtPayroll.Rows[j]["PEmpname"] = ds.Tables[0].Rows[j]["PfirstName"].ToString() + " " + ds.Tables[0].Rows[j]["Plastname"].ToString(); dtPayroll.Rows[j]["Termdate"] = ds.Tables[0].Rows[j]["Termdate"].ToString() == "NULL" ? Convert.ToDateTime("01/01/1900") : ds.Tables[0].Rows[j]["Termdate"].ToString() == "" ? Convert.ToDateTime("01/01/1900") : Convert.ToDateTime(Convert.ToDateTime(ds.Tables[0].Rows[j]["Termdate"]).ToString("MM/dd/yyyy")); dtPayroll.Rows[j]["Startdate"] = ds.Tables[0].Rows[j]["Startdate"].ToString() == "NULL" ? Convert.ToDateTime("01/01/1900") : ds.Tables[0].Rows[j]["Startdate"].ToString() == "" ? Convert.ToDateTime("01/01/1900") : Convert.ToDateTime(Convert.ToDateTime(ds.Tables[0].Rows[j]["Startdate"]).ToString("MM/dd/yyyy")); dtPayroll.Rows[j]["DeptName"] = ds.Tables[0].Rows[j]["DeptName"].ToString() == "NULL" ? "" : ds.Tables[0].Rows[j]["DeptName"].ToString(); dtPayroll.Rows[j]["LocationName"] = ds.Tables[0].Rows[j]["LocationName"].ToString() == "NULL" ? "" : ds.Tables[0].Rows[j]["LocationName"].ToString(); dtPayroll.Rows[j]["MasterEmpType"] = ds.Tables[0].Rows[j]["EmpType"].ToString() == "NULL" ? "" : ds.Tables[0].Rows[j]["EmpType"].ToString(); dtPayroll.Rows[j]["LocDescriptiom"] = ds.Tables[0].Rows[j]["LocDescriptiom"].ToString() == "NULL" ? "" : ds.Tables[0].Rows[j]["LocDescriptiom"].ToString(); dtPayroll.Rows[j]["Salary"] = ds.Tables[0].Rows[j]["Salary"].ToString() == "" ? 0.0 : ds.Tables[0].Rows[j]["Salary"].ToString() == "NULL" ? 0.0 : Convert.ToDouble(ds.Tables[0].Rows[j]["Salary"].ToString()); dtPayroll.Rows[j]["LeavesAvailable"] = 0; if (dtPaidLev.Rows.Count > 0) { if (dtPaidLev.Rows[0]["PaidLeavesStartDt"].ToString()!="NULL" && dtPaidLev.Rows[0]["PaidLeavesStartDt"].ToString() != "" && Convert.ToDateTime(dtPaidLev.Rows[0]["PaidLeavesStartDt"]).ToString("MM/dd/yyyy") != "01/01/1900") { if (Convert.ToDateTime(dtPaidLev.Rows[0]["PaidLeavesStartDt"].ToString()) <= StartDate.AddSeconds(-1)) { int PaidLeaves = dtPaidLev.Rows[0]["PaidLeavesBalanced"].ToString() == "" ? 0 : dtPaidLev.Rows[0]["PaidLeavesBalanced"].ToString() == "NULL" ? 0 : Convert.ToInt32(dtPaidLev.Rows[0]["PaidLeavesBalanced"].ToString()); dtPayroll.Rows[j]["LeavesAvailable"] = PaidLeaves + (dtPaidLev.Rows[0]["MonthlyEligible"].ToString() == "" ? 0 : dtPaidLev.Rows[0]["MonthlyEligible"].ToString() == "NULL" ? 0 : Convert.ToInt32(dtPaidLev.Rows[0]["MonthlyEligible"].ToString())); dtPayroll.Rows[j]["PaidLeaveStartDt"] = dtPaidLev.Rows[0]["PaidLeavesStartDt"].ToString() == "" ? Convert.ToDateTime("01/01/1900") : dtPaidLev.Rows[0]["PaidLeavesStartDt"].ToString() == "NULL" ? Convert.ToDateTime("01/01/1900") : Convert.ToDateTime(dtPaidLev.Rows[0]["PaidLeavesStartDt"].ToString()); } else { dtPayroll.Rows[j]["LeavesAvailable"] = "0"; } } else { dtPayroll.Rows[j]["LeavesAvailable"] = "0"; } } else { if (ds.Tables[0].Rows[j]["PaidLeavesStartDt"].ToString() != "NULL" && ds.Tables[0].Rows[j]["PaidLeavesStartDt"].ToString() != "" && Convert.ToDateTime(ds.Tables[0].Rows[j]["PaidLeavesStartDt"]).ToString("MM/dd/yyyy") != "01/01/1900") { if (Convert.ToDateTime(ds.Tables[0].Rows[j]["PaidLeavesStartDt"].ToString()) <= StartDate.AddSeconds(-1)) { int PaidLeaves = 0; dtPayroll.Rows[j]["LeavesAvailable"] = PaidLeaves + (ds.Tables[0].Rows[j]["MonthlyEligible"].ToString() == "" ? 0 : ds.Tables[0].Rows[j]["MonthlyEligible"].ToString() == "NULL" ? 0 : Convert.ToInt32(ds.Tables[0].Rows[j]["MonthlyEligible"].ToString())); dtPayroll.Rows[j]["PaidLeaveStartDt"] = ds.Tables[0].Rows[j]["PaidLeavesStartDt"].ToString() == "" ? Convert.ToDateTime("01/01/1900") : ds.Tables[0].Rows[j]["PaidLeavesStartDt"].ToString() == "NULL" ? Convert.ToDateTime("01/01/1900") : Convert.ToDateTime(ds.Tables[0].Rows[j]["PaidLeavesStartDt"].ToString()); } else { dtPayroll.Rows[j]["LeavesAvailable"] = "0"; } } else { dtPayroll.Rows[j]["LeavesAvailable"] = "0"; } } if (dtname.Rows.Count > 0) { DateTime startDate = StartDate; DateTime nextdate = NextDate; for (int i = 0; i < days; i++) { DataView dv1 = dtname.DefaultView; dv1.RowFilter = "Logindate >= #" + startDate + "# and Logindate<#" + nextdate + "#"; DataTable dt1 = dv1.ToTable(); DataView dL = dtLeave.DefaultView; dL.RowFilter = "Fromdate<=#" + startDate + "# and #" + startDate + "#<=Todate"; DataTable dtLvResult = dL.ToTable(); DataView dH = dtHoliday.DefaultView; dH.RowFilter = "HolidayDate >= #" + startDate + "# and HolidayDate<#" + nextdate + "#"; DataTable dtHolResult = dH.ToTable(); if (dtHolResult.Rows.Count > 0) { holidays += 1; } if (dt1.Rows.Count > 0) { double dayhrs = 0.0; for (int k = 0; k < dt1.Rows.Count; k++) { if (dt1.Rows[k]["logoutdate"].ToString().Trim() != "") { if (dt1.Rows[k]["total hours worked"].ToString() == "") { dayhrs += 0.0; } else { dayhrs += Convert.ToDouble(dt1.Rows[k]["total hours worked"].ToString()); } } else { noshow += 1; } } if (dayhrs > 5) { present += 1; } else if (dayhrs > 3 && dayhrs < 5) { present += 0.5; } else if (dayhrs > 0.0 && dayhrs < 3) { leaves += 1; } } else if (dtHolResult.Rows.Count <= 0 && dtLvResult.Rows.Count > 0) { leaves += 1; } else if (dtHolResult.Rows.Count <= 0 && dtLvResult.Rows.Count <= 0 && dt1.Rows.Count <= 0) { noshow += 1; } else { noshow += 1; } dL.RowFilter = null; dH.RowFilter = null; dv1.RowFilter = null; startDate = nextdate; nextdate = GeneralFunction.GetNextDayOfWeekDate(nextdate); } } if (dtHoliday.Rows.Count > 0) { DateTime startDate = StartDate; DateTime nextdate = NextDate; for (int i = 0; i < days; i++) { DataView dH = dtHoliday.DefaultView; dH.RowFilter = "HolidayDate >= #" + startDate + "# and HolidayDate<#" + nextdate + "#"; DataTable dtHolResult = dH.ToTable(); DataView dL = dtLeave.DefaultView; dL.RowFilter = "Fromdate<=#" + startDate + "# and #" + startDate + "#<=Todate"; DataTable dtLvResult = dL.ToTable(); if (dtHolResult.Rows.Count > 0) { holidays += 1; } else if (dtLvResult.Rows.Count > 0) { leaves += 1; } else { noshow += 1; } dL.RowFilter = null; dH.RowFilter = null; startDate = nextdate; nextdate = GeneralFunction.GetNextDayOfWeekDate(nextdate); } } dtPayroll.Rows[j]["Present"] = present; dtPayroll.Rows[j]["Workingdays"] = days - holidays; dtPayroll.Rows[j]["Leaves"] = leaves; dtPayroll.Rows[j]["Holidays"] = holidays; if (Convert.ToInt32(dtPayroll.Rows[j]["LeavesAvailable"]) > Convert.ToInt32(dtPayroll.Rows[j]["leaves"])) { dtPayroll.Rows[j]["PaidLeavesBalanced"] = Convert.ToInt32(dtPayroll.Rows[j]["LeavesAvailable"]) - Convert.ToInt32(dtPayroll.Rows[j]["leaves"]); dtPayroll.Rows[j]["PaidLeavesUsed"] = Convert.ToInt32(dtPayroll.Rows[j]["LeavesAvailable"]) - Convert.ToInt32(dtPayroll.Rows[j]["PaidLeavesBalanced"]); dtPayroll.Rows[j]["CalLeaves"] = 0; } else if (Convert.ToInt32(dtPayroll.Rows[j]["leaves"]) > Convert.ToInt32(dtPayroll.Rows[j]["LeavesAvailable"])) { dtPayroll.Rows[j]["CalLeaves"] = Convert.ToInt32(dtPayroll.Rows[j]["leaves"]) - Convert.ToInt32(dtPayroll.Rows[j]["LeavesAvailable"]); dtPayroll.Rows[j]["PaidLeavesUsed"] = Convert.ToInt32(dtPayroll.Rows[j]["leaves"]) - Convert.ToInt32(dtPayroll.Rows[j]["CalLeaves"]); dtPayroll.Rows[j]["PaidLeavesBalanced"] = 0; } else { dtPayroll.Rows[j]["PaidLeavesBalanced"] = Convert.ToInt32(dtPayroll.Rows[j]["LeavesAvailable"]) - Convert.ToInt32(dtPayroll.Rows[j]["leaves"]); dtPayroll.Rows[j]["PaidLeavesUsed"] = Convert.ToInt32(dtPayroll.Rows[j]["LeavesAvailable"]) - Convert.ToInt32(dtPayroll.Rows[j]["PaidLeavesBalanced"]); dtPayroll.Rows[j]["CalLeaves"] = Convert.ToInt32(dtPayroll.Rows[j]["LeavesAvailable"]) - Convert.ToInt32(dtPayroll.Rows[j]["leaves"]); } //salary calculation CalSalary CalLeaves double CurntSalary = Convert.ToDouble(dtPayroll.Rows[j]["Salary"]); int wrkDays = Convert.ToInt32(dtPayroll.Rows[j]["Workingdays"]); double CalSalary = 0.0; if (Convert.ToInt32(dtPayroll.Rows[j]["Present"]) > 0) { double perdaySal = wrkDays == 0 ? 0 : Math.Round(CurntSalary / Convert.ToDouble(wrkDays)); double paiddaysOff = perdaySal * (dtPayroll.Rows[j]["PaidLeavesUsed"].ToString() == "" ? 0 : dtPayroll.Rows[j]["PaidLeavesUsed"].ToString() == "NULL" ? 0 : Convert.ToInt32(dtPayroll.Rows[j]["PaidLeavesUsed"])); double ActualSalary = perdaySal * Convert.ToInt32(dtPayroll.Rows[j]["Present"]); CalSalary = paiddaysOff + ActualSalary; dtPayroll.Rows[j]["CalSalary"] = CalSalary; dtPayroll.Rows[j]["TotalPay"] = CalSalary; } else { dtPayroll.Rows[j]["CalSalary"] = 0.0; dtPayroll.Rows[j]["TotalPay"] = 0.0; } } } } } } catch (Exception ex) { } return dtPayroll; }
private void GetDeafualtHolidays(int shiftID, int locationID, int departmentID) { try { EmployeeBL objemp = new EmployeeBL(); DataTable dt = objemp.GetDefaultHolidays(shiftID, locationID, departmentID); if (dt.Rows.Count > 0) { rptDefaultHoliday.DataSource = dt; rptDefaultHoliday.DataBind(); lblDefLoc1.Text = ddlLocation.SelectedItem.Text; lblDefShift1.Text = ddlShift.SelectedItem.Text; lblNoDefault.Text = ""; divNodefault.Style["display"] = "none"; } else { lblDefLoc1.Text = ddlLocation.SelectedItem.Text; lblDefShift1.Text = ddlShift.SelectedItem.Text; lblNoDefault.Text = "No default holidays found"; divNodefault.Style["display"] = "block"; rptDefaultHoliday.DataSource = null; rptDefaultHoliday.DataBind(); } } catch (Exception ex) { } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { string DefaultDay = ddlDay.SelectedItem.Text; int fromYr = Convert.ToInt32(ddlFromYear.SelectedItem.Text.ToString().Trim()); int toYr = Convert.ToInt32(ddlToYear.SelectedItem.Text.ToString().Trim()); int LocationID = Convert.ToInt32(ddlDefaultlocation.SelectedItem.Value); string shiftName = ddlDefaultShift.SelectedItem.Value; DateTime startDate = new DateTime(fromYr, 1, 1); DateTime endDate = new DateTime(toYr, 12, 31); int EnterBy = Convert.ToInt32(Session["UserID"]); string timezone = ""; if (Convert.ToInt32(Session["TimeZoneID"]) == 2) { timezone = "Eastern Standard Time"; } else { timezone = "India Standard Time"; } DateTime Enterdate = TimeZoneInfo.ConvertTime(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById(timezone)); String strHostName = Request.UserHostAddress.ToString(); string IpAddress = System.Net.Dns.GetHostAddresses(strHostName).GetValue(0).ToString(); //TimeSpan diff = endDate - startDate; //int days = diff.Days; EmployeeBL obj = new EmployeeBL(); //for (var i = 0; i <= days; i++) //{ // var testDate = startDate.AddDays(i); // if (testDate.DayOfWeek.ToString() == DefaultDay) // { // bool bnew = obj.SaveandGetHolidayDet(true, testDate, LocationID, 0, shiftName, EnterBy, Enterdate, IpAddress, "Default", true); // } //} bool bnew = obj.SaveDefaultHolidayDet(startDate, endDate, true, LocationID, 0, shiftName, EnterBy, Enterdate, IpAddress, DefaultDay, true, DefaultDay); mdlAddDefault.Hide(); System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "Script", "alert('Default holidays updated successfully..');", true); EmployeeBL objemp = new EmployeeBL(); GetDeafualtHolidays(Convert.ToInt32(ddlShift.SelectedValue), Convert.ToInt32(ddlLocation.SelectedItem.Value), Convert.ToInt32(ddlDepartment.SelectedValue)); DateTime Start = Convert.ToDateTime(Session["MonthHolStart"]); DateTime EndDt = Convert.ToDateTime(Session["MonthHolEnd"]); int shiftID = Convert.ToInt32(ddlShift.SelectedValue); int Location = Convert.ToInt32(ddlLocation.SelectedItem.Value); int departmentID = Convert.ToInt32(ddlDepartment.SelectedValue); GetCalender(Start, EndDt, Location, shiftID, departmentID); mdlDefaultmgmt.Show(); } catch (Exception ex) { } }
protected void btnSaveDefault_Click(object sender, EventArgs e) { EmployeeBL obj = new EmployeeBL(); try { int LocationID=Convert.ToInt32(ddlLocation.SelectedValue); int deptID=0; string shiftName=ddlShift.SelectedItem.Text; int EnterBy = Convert.ToInt32(Session["UserID"]); string timezone = ""; if (Convert.ToInt32(Session["TimeZoneID"]) == 2) { timezone = "Eastern Standard Time"; } else { timezone = "India Standard Time"; } DateTime Enterdate = TimeZoneInfo.ConvertTime(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById(timezone)); String strHostName = Request.UserHostAddress.ToString(); string IpAddress = System.Net.Dns.GetHostAddresses(strHostName).GetValue(0).ToString(); for (int i = 0; i<rptDefaultHoliday.Items.Count; i++) { CheckBox chkDefaultDay = (CheckBox)rptDefaultHoliday.Items[i].FindControl("chkDefaultDay"); if (!chkDefaultDay.Checked) { int fromYr =Convert.ToInt32(chkDefaultDay.Attributes["FromYr"]); int toyr = Convert.ToInt32(chkDefaultDay.Attributes["ToYr"]); DateTime startDate = new DateTime(fromYr, 1, 1); DateTime endDate = new DateTime(toyr, 12, 31); obj.UpdateDefaultHolidayDet(startDate,endDate,false, chkDefaultDay.Text.Trim(), LocationID, deptID, shiftName, EnterBy, Enterdate, IpAddress); } } GetDeafualtHolidays(Convert.ToInt32(ddlShift.SelectedValue), LocationID, deptID); DateTime Start = Convert.ToDateTime(Session["MonthHolStart"]); DateTime EndDt = Convert.ToDateTime(Session["MonthHolEnd"]); int shiftID = Convert.ToInt32(ddlShift.SelectedValue); int departmentID = Convert.ToInt32(ddlDepartment.SelectedValue); GetCalender(Start, EndDt, LocationID, shiftID, departmentID); } catch (Exception ex) { } }
private void GetEffectiveChangeStatus() { try { EmployeeBL obj = new EmployeeBL(); DataTable dt = obj.GetEffectiveChangeStatus(); ddlSelect.DataSource = dt; ddlSelect.DataTextField = "ChangeStatus"; ddlSelect.DataValueField = "ChangeStatusID"; ddlSelect.DataBind(); ddlSelect.Items.Insert(0, new ListItem("ALL", "0")); ddlEditStatus.DataSource = dt; ddlEditStatus.DataTextField = "ChangeStatus"; ddlEditStatus.DataValueField = "ChangeStatusID"; ddlEditStatus.DataBind(); ddlEditStatus.Items.Insert(0, new ListItem("Select", "0")); } catch (Exception ex) { } }
protected void ddlReportType_SelectedIndexChanged(object sender, EventArgs e) { try { int userid = Convert.ToInt32(Session["UserID"]); EmployeeBL obj = new EmployeeBL(); if (ddlReportType.SelectedValue == "1") { DateTime monthStart = Convert.ToDateTime(ViewState["MonthSatrt"]); DateTime monthEnd = monthStart.AddMonths(1).AddSeconds(-1); GetCalender(monthStart, monthEnd, 1); grdSingleLeaveReq.DataSource = null; grdSingleLeaveReq.DataBind(); dvSingle.Style["display"] = "none"; dvMonthrep.Style["display"] = "block"; if (monthStart.ToString("MM/dd/yyyy") == Convert.ToDateTime(ViewState["CurrentMonth"]).ToString("MM/dd/yyyy")) { btnNext.CssClass = "btn btn-danger btn-small disabled"; btnNext.Enabled = false; } else { btnNext.CssClass = "btn btn-danger btn-small enabled"; btnNext.Enabled = true; } } else { DateTime TodayDate = Convert.ToDateTime(Session["TodayDate"]); if (GeneralFunction.GetFirstDayOfWeekDate(TodayDate).ToString("MM/dd/yyyy") == GeneralFunction.GetFirstDayOfWeekDate(DateTime.Now).ToString("MM/dd/yyyy")) { btnNext.CssClass = "btn btn-danger btn-small disabled"; btnNext.Enabled = false; } else { btnNext.CssClass = "btn btn-danger btn-small enabled"; btnNext.Enabled = true; } DateTime Start = GeneralFunction.GetFirstDayOfWeekDate(TodayDate); DateTime End = GeneralFunction.GetLastDayOfWeekDate(TodayDate); DataTable ds = new DataTable(); ds = GetReportSingle(Start, End, userid); Session["AtnDetails"] = ds; if (ds.Rows.Count > 0) { grdAttendanceSingle.DataSource = ds; grdAttendanceSingle.DataBind(); dvSingle.Style["display"] = "block"; dvMonthrep.Style["display"] = "none"; grdSingleLeaveReq.DataSource = null; grdSingleLeaveReq.DataBind(); } } } catch (Exception ex) { } }
private void GetEffectiveData(int LocationID, int shiftID, DateTime StartDt, DateTime EndDt,int stausID) { try { EmployeeBL obj = new EmployeeBL(); DataTable dt = obj.GetEffectivedataByLocation(LocationID, StartDt, EndDt, shiftID,stausID); lblMonthRep.Text = "(" + StartDt.ToString("MM/dd/yyyy") + " - " + EndDt.ToString("MM/dd/yyyy") + ")"; if (dt.Rows.Count > 0) { grdUsers.DataSource = dt; grdUsers.DataBind(); lblNodata.Text = ""; dvNodata.Style["display"] = "none"; } else { grdUsers.DataSource = null; grdUsers.DataBind(); lblNodata.Text = "No data found"; dvNodata.Style["display"] = "block"; } } catch (Exception ex) { } }
protected void lnkLeaveReq_Click(object sender, EventArgs e) { try { EmployeeBL obj = new EmployeeBL(); if (ddlReportType.SelectedValue.ToString() == "0") { DateTime startDate = Convert.ToDateTime(Session["TodayDate"]); DateTime endDate = startDate.AddDays(7); DataTable ds = obj.GetLeaveRequestDetByUserID(Convert.ToInt32(Session["UserID"]), startDate, endDate); grdSingleLeaveReq.DataSource = ds; grdSingleLeaveReq.DataBind(); } else { DateTime startDate = Convert.ToDateTime(ViewState["MonthSatrt"]); DateTime endDate = startDate.AddMonths(1).AddSeconds(-1); DataTable ds = obj.GetLeaveRequestDetByUserID(Convert.ToInt32(Session["UserID"]), startDate, endDate); grdSingleLeaveReq.DataSource = ds; grdSingleLeaveReq.DataBind(); } } catch (Exception ex) { } }
protected void btnResetPassword_Click(object sender, EventArgs e) { try { string password = txtResetNewPassword.Text.Trim(); string EmpID = lblEmpID.Text.Trim(); String strHostName = Request.UserHostAddress.ToString(); int userid = Convert.ToInt32(Session["UserID"]); string strIp = System.Net.Dns.GetHostAddresses(strHostName).GetValue(0).ToString(); string timezone = ""; if (Convert.ToInt32(Session["TimeZoneID"]) == 2) { timezone = "Eastern Standard Time"; } else { timezone = "India Standard Time"; } DateTime ISTTime = TimeZoneInfo.ConvertTime(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById(timezone)); var CurentDatetime = ISTTime; EmployeeBL obj = new EmployeeBL(); bool bnew = obj.ResetPassWordByAdmin(userid, strIp, password, CurentDatetime, EmpID); mdlResetPassword.Hide(); } catch (Exception ex) { } }
private void CreateNewEmployeeList(int EmpID) { try { Attendance.BAL.EmployeeBL obj = new EmployeeBL(); DataTable dt = obj.GetEmployyeDetailsByUserID(EmpID); dtNewEmp.Merge(dt); } catch (Exception ex) { } }
protected void btnSchUpdate_Click(object sender, EventArgs e) { try { string SchStartTime = txtSheduleStart.Text.ToString().Trim(); string SchEndTime = txtScheduleEnd.Text.ToString().Trim(); string LunchStartime = txtLunchStart.Text.ToString().Trim(); string LunchEndtime = txtLunchEnd.Text.ToString().Trim(); bool Fivedays = false; bool Sixdays = false; bool Sevendays = false; if (rdFive.Checked) { Fivedays = true; } else if (rdSix.Checked) { Sixdays = true; } else if (rdSeven.Checked) { Sevendays = true; } int UserID = Convert.ToInt32(Session["UserID"]); string timezone = ""; if (Convert.ToInt32(Session["TimeZoneID"]) == 2) { timezone = "Eastern Standard Time"; } else { timezone = "India Standard Time"; } DateTime ISTTime = TimeZoneInfo.ConvertTime(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById(timezone)); String strHostName = Request.UserHostAddress.ToString(); string strIp = System.Net.Dns.GetHostAddresses(strHostName).GetValue(0).ToString(); EmployeeBL obj = new EmployeeBL(); string ID = obj.AddNewSchedule(SchStartTime, SchEndTime, LunchStartime, LunchEndtime, Fivedays, Sixdays, Sevendays, strIp, ISTTime, UserID); mdlSchedulepopup.Hide(); GetSchedules(); ddlSchedule.SelectedIndex =ddlSchedule.Items.IndexOf(ddlSchedule.Items.FindByValue(ID==""?"0":ID)); mdlAddPopUp.Show(); } catch (Exception ex) { } }
protected void grdUsers_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { EmployeeBL obj = new EmployeeBL(); int PaidLeaveID = 0; if (grdUsers.DataKeys[e.RowIndex].Value.ToString().Trim()!= "") { PaidLeaveID = Convert.ToInt32(grdUsers.DataKeys[e.RowIndex].Value); } HiddenField hdnUserid = (HiddenField)grdUsers.Rows[e.RowIndex].FindControl("hdnUserid"); int PaidLeaveUserID = Convert.ToInt32(hdnUserid.Value); TextBox txtLeavesStartDt = (TextBox)grdUsers.Rows[e.RowIndex].FindControl("txtLeavesStartDt"); TextBox txtLevAvail = (TextBox)grdUsers.Rows[e.RowIndex].FindControl("txtLeavAvailable"); TextBox txtLeavesUsed = (TextBox)grdUsers.Rows[e.RowIndex].FindControl("txtLeavesUsed"); TextBox txtLeavBalanced = (TextBox)grdUsers.Rows[e.RowIndex].FindControl("txtLeavBalanced"); //TextBox txtMAxLevAvail = (TextBox)grdUsers.Rows[e.RowIndex].FindControl("txtMaxEligible"); TextBox txtNotes = (TextBox)grdUsers.Rows[e.RowIndex].FindControl("txtNotes"); string timezone = ""; if (Convert.ToInt32(Session["TimeZoneID"]) == 2) { timezone = "Eastern Standard Time"; } else { timezone = "India Standard Time"; } DateTime StartDate = Convert.ToDateTime(ViewState["PaidStartDate"]); DateTime CurrentDate = TimeZoneInfo.ConvertTime(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById(timezone)); int LeaveAvail =txtLevAvail.Text==""?0:Convert.ToInt32(txtLevAvail.Text); // int MaxLeaveAvail = Convert.ToInt32(txtMAxLevAvail.Text); int LeavesUsed =txtLeavesUsed.Text==""?0:Convert.ToInt32(txtLeavesUsed.Text); int LeavesBalanced =txtLeavBalanced.Text==""?0:Convert.ToInt32(txtLeavBalanced.Text); DateTime LeavesStartDt =txtLeavesStartDt.Text==""?Convert.ToDateTime("01/01/1900"): Convert.ToDateTime(txtLeavesStartDt.Text); string notes = txtNotes.Text.Trim() == "" ? "" : GeneralFunction.ToProperNotes(txtNotes.Text) + "<br>" + "-------------------------------------<br>" + "Updated by " + Session["EmpName"].ToString().Trim() + " at " + CurrentDate + "<br>" + "***********************************" + "<br>"; int userid = Convert.ToInt32(Session["UserID"]); String strHostName = Request.UserHostAddress.ToString(); string strIp = System.Net.Dns.GetHostAddresses(strHostName).GetValue(0).ToString(); bool bnew = obj.UpdatePaidLeaveByLeaveID(LeaveAvail, LeavesUsed, LeavesBalanced, PaidLeaveID, userid, notes, StartDate, LeavesStartDt, strIp, PaidLeaveUserID, CurrentDate); grdUsers.EditIndex = -1; DateTime EndDate = Convert.ToDateTime(ViewState["PaidEndDate"]); GetpaidLeavesData(Convert.ToInt32(ddlLocation.SelectedItem.Value), StartDate, EndDate, Convert.ToInt32(ddlShift.SelectedValue)); } catch (Exception ex) { } }
protected void btnUpdatePassCode_Click(object sender, EventArgs e) { try { //string location = ddlLocation.SelectedItem.Text.ToString().Trim(); string EmpName = Session["EmpName"].ToString().Trim(); int userid = Convert.ToInt32(Session["UserID"]); string oldPasscode = txtOldpasscode.Text.Trim(); string NewPasscode = txtNewPasscode.Text.Trim(); Attendance.BAL.EmployeeBL obj = new EmployeeBL(); bool bnew = obj.UpdatePasscodeByUserID(userid, oldPasscode, NewPasscode); if (bnew) { txtOldpasscode.Text = ""; txtNewPasscode.Text = ""; txtConfirmPasscode.Text = ""; mdlChangePasscode.Hide(); System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "Script", "alert('Passcode changed successfully..');", true); } } catch (Exception ex) { } }
private void GetpaidLeavesData(int locationID, DateTime startDt, DateTime EndDt,int shiftID) { try { EmployeeBL obj = new EmployeeBL(); DataTable dt = obj.GetEmpPaidleavesDetailsByLocation(locationID,startDt,EndDt,shiftID); lblLeaveReport.Text = "(" + startDt.ToString("MM/dd/yyyy") + "-" + EndDt.ToString("MM/dd/yyyy") + ")"; if (dt.Rows.Count > 0) { grdUsers.DataSource = dt; Session["AllPaidLeavesData"] = dt; grdUsers.DataBind(); lblTotal.Visible = true; lblTotal.Text = "Total Employee(s) :" + dt.Rows.Count; lblNodata.Visible = false; dvlblNodata.Style["display"] = "none"; } else { lblNodata.Visible = true; dvlblNodata.Style["display"] = "block"; lblNodata.Text = "No data found"; lblTotal.Text = ""; grdUsers.DataSource = null; grdUsers.DataBind(); } } catch (Exception ex) { } }
protected void btnLeeaveApproveUpdate_Click(object sender, EventArgs e) { try { string Records = hdnChkRecords.Value.ToString(); if (Records.Trim().Length > 0) { string[] recordID = Records.Split(','); for (int i = 0; i < recordID.Length-1; i++) { string timezone = ""; if (Convert.ToInt32(Session["TimeZoneID"]) == 2) { timezone = "Eastern Standard Time"; } else { timezone = "India Standard Time"; } DateTime ISTTime = TimeZoneInfo.ConvertTime(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById(timezone)); int LeaveID = Convert.ToInt32(recordID[i]); string notes = txtLeaveNotes.Text.Trim() == "" ? "" : GeneralFunction.ToProperNotes(txtLeaveNotes.Text) + "<br>" + " <br>" + ddlLeaveApprove.SelectedItem.Text+" by " + Session["EmpName"].ToString().Trim() + " at " + ISTTime + "<br>" + "------------------------------------<br>"; int ApprovedStatusID = Convert.ToInt32(ddlLeaveApprove.SelectedValue); int ApprovedBy = Convert.ToInt32(Session["UserID"]); EmployeeBL obj = new EmployeeBL(); bool bnew = obj.UpdateLeaveRequest(LeaveID, ApprovedBy, ApprovedStatusID, notes, ISTTime); } } mdlLeaveStatusUpdate.Hide(); int StatusID = Convert.ToInt32(ddlSelect.SelectedValue); GetLeavesDetails(ddlGrdLocation.SelectedItem.Text.ToString().Trim(), Convert.ToDateTime(ViewState["StartMonth"]), Convert.ToDateTime(ViewState["EndMonth"]), StatusID, Convert.ToInt32(ddlShift.SelectedValue)); } catch (Exception ex) { } }
private void GetdepartmentsByshiftLoc(string shiftname, int locationID) { try { EmployeeBL obj = new EmployeeBL(); DataTable dt = obj.GetDepartmentByShifts(shiftname, locationID); ddlPopDept.DataSource = dt; ddlPopDept.DataTextField = "Deptname"; ddlPopDept.DataValueField = "DeptID"; ddlPopDept.DataBind(); ddlPopDept.Items.Insert(0, new ListItem("Select", "Select")); ddlPopDept.Items.Insert(1, new ListItem("ALL", "0")); } catch (Exception ex) { } }