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 CreateNewEmployeeList(int EmpID)
{
try
{
Attendance.BAL.EmployeeBL obj = new EmployeeBL();
DataTable dt = obj.GetEmployyeDetailsByUserID(EmpID);
dtNewEmp.Merge(dt);
}
catch (Exception ex)
{
}
}
