private void GetEmpDetails()
{
objsql = new SQLDB();
objHrinfo = new HRInfo();
DataSet dsPhoto = new DataSet();
DataTable dt = new DataTable();
try
{
dt = objHrinfo.Get_Adhar_MasterDetails(Convert.ToInt32(txtEcodeSearch.Text.ToString())).Tables[0];
dsPhoto = objsql.ExecuteDataSet("SELECT HAPS_PHOTO_SIG FROM HR_APPL_PHOTO_SIG WHERE HAPS_EORA_CODE = " + txtEcodeSearch.Text);
if (dt.Rows.Count > 0)
{
txtApplNo.Text = dt.Rows[0]["AppNo"].ToString();
txtEName.Text = dt.Rows[0]["EmpName"].ToString();
txtFatherName.Text = dt.Rows[0]["FatherName"].ToString();
txtDob.Text = Convert.ToDateTime(dt.Rows[0]["EmpDob"].ToString()).ToShortDateString();
txtDoj.Text = Convert.ToDateTime(dt.Rows[0]["EmpDoj"].ToString()).ToShortDateString();
if (dt.Rows[0]["Status"].Equals("W"))
{
txtStatus.Text = "WORKING";
}
if (dt.Rows[0]["Status"].Equals("P"))
{
txtStatus.Text = "PENDING";
}
if (dt.Rows[0]["Status"].Equals("L"))
{
txtStatus.Text = "LEFT";
}
txtDept.Text = dt.Rows[0]["EmpDept"].ToString();
txtDesig.Text = dt.Rows[0]["EmpDesig"].ToString();
txtadharNo.Text = dt.Rows[0]["AdharNo"].ToString();
txtPanNo.Text = dt.Rows[0]["PancardNo"].ToString();
txtPassportNo.Text = dt.Rows[0]["PassportNo"].ToString();
txtDrivingLinceNo.Text = dt.Rows[0]["DrivingLinceNO"].ToString();
if (dsPhoto.Tables[0].Rows.Count > 0)
{
GetImage((byte[])dsPhoto.Tables[0].Rows[0]["HAPS_PHOTO_SIG"]);
}
else
{
picEmpPhoto.BackgroundImage = null;
}
}
else
{
txtEName.Text = "";
txtFatherName.Text = "";
txtDept.Text = "";
txtDesig.Text = "";
txtDob.Text = "";
txtDoj.Text = "";
txtStatus.Text = "";
txtPassportNo.Text = "";
txtDrivingLinceNo.Text = "";
txtadharNo.Text = "";
txtApplNo.Text = "";
txtPanNo.Text = "";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objsql = null;
dt = null;
}
}