private void GetEmpDet(int empid) { Attendance.BAL.EmployeeBL obj = new EmployeeBL(); try { comanyname.Text = CommonFiles.ComapnyName; 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)); DataTable dt = obj.GetEmployyeDetailsByUserID(empid); 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(); hdnScID.Value = dt.Rows[0]["ScheduleId"].ToString(); 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() == "NULL" ? "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(); lblShift.Text = dt.Rows[0]["Shiftname"].ToString(); hdnShiftID.Value = dt.Rows[0]["ShiftID"].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(); DataTable dsChange = obj.GetEmpChangesEffectiveData(empid); grdEffectChanges.DataSource = dsChange; grdEffectChanges.DataBind(); } catch (Exception ex) { } }