protected void DdlPassportId_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
int PPId = Convert.ToInt32(DdlPassportId.SelectedValue);
DataSet ds = clsPassport.GetPassportDataByPassportId(PPId);
if (ds.Tables[0].Rows.Count != 0)
{
DataRow dRow = ds.Tables[0].Rows[0];
DdlPassportNo.SelectedItem.Text = dRow[1].ToString();
txtPlace.Text = dRow[3].ToString();
txtAddress.Text = dRow[4].ToString();
txtIssuedDate.Text = dRow[5].ToString();
txtExpiryDate.Text = dRow[6].ToString();
txtMarks.Text = dRow[8].ToString();
txtPages.Text = dRow[9].ToString();
txtCountry.Text = dRow[10].ToString();
txtCitizen.Text = dRow[11].ToString();
BrowseImage1.LaodImageByte = (byte[])dRow[12];
BrowseImage1.LoadFileName = Convert.ToString(dRow[13]);
BrowseImage1.LoadImage();
}
else
{
lblMsg.Text = "There is no data for the selected Passports";
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
protected void DdlCountryName_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
objVisaType.CountryId = Convert.ToInt32(DdlCountryName.SelectedValue);
DataSet ds = objVisaType.GetCountryDataByCountryId();
if (ds.Tables[0].Rows.Count != 0)
{
DataRow dRow = ds.Tables[0].Rows[0];
txtCountryAbbr.Text = dRow[2].ToString();
txtCountryDesc.Text = dRow[3].ToString();
BrowseImage1.LaodImageByte = (byte[])dRow[4];
BrowseImage1.LoadFileName = Convert.ToString(dRow[5]);
BrowseImage1.LoadImage();
BrowseImage2.LaodImageByte = (byte[])dRow[6];
BrowseImage2.LoadFileName = Convert.ToString(dRow[7]);
BrowseImage2.LoadImage();
if (Session["VideoFileContent"] == null || Session["VidoeFileName"] == null)
{
ViewState["VideoFileContent"] = (byte[])dRow[8];
ViewState["VideoFileName"] = (string)dRow[9];
}
}
else
{
lblMsg.Text = "There is no data";
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
protected void DdlCountryVisitedId_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
int CtId = Convert.ToInt32(DdlCountryVisitedId.SelectedValue);
DataSet ds = clsVisaType.GetCountryVisitedDataByCountryVisitedId(CtId);
if (ds.Tables[0].Rows.Count != 0)
{
DataRow dRow = ds.Tables[0].Rows[0];
txtStampedDate.Text = dRow[2].ToString();
txtEmbrasy.Text = dRow[3].ToString();
txtFromDate.Text = dRow[5].ToString();
txtTODate.Text = dRow[6].ToString();
txtCountryStamped.Text = dRow[7].ToString();
txtRemarks.Text = dRow[8].ToString();
BrowseImage1.LaodImageByte = (byte[])dRow[9];
BrowseImage1.LoadFileName = Convert.ToString(dRow[10]);
BrowseImage1.LoadImage();
BrowseImage2.LaodImageByte = (byte[])dRow[11];
BrowseImage2.LoadFileName = Convert.ToString(dRow[12]);
BrowseImage2.LoadImage();
}
else
{
lblMsg.Text = "There is no data for the selected Countries";
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
protected void DdlEmpStayId_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
int StId = Convert.ToInt32(DdlEmpStayId.SelectedValue);
DataSet ds = clsVisaType.GetEmployeeStayDataByEmployeeStayId(StId);
if (ds.Tables[0].Rows.Count != 0)
{
DataRow dRow = ds.Tables[0].Rows[0];
txtRoomNo.Text = dRow[3].ToString();
txtReservationNo.Text = dRow[4].ToString();
ChkStatus.Checked = Convert.ToBoolean(dRow[5]);
txtVehicleNo.Text = dRow[6].ToString();
txtContact.Text = dRow[9].ToString();
txtName.Text = dRow[8].ToString();
BrowseImage1.LaodImageByte = (byte[])dRow[10];
BrowseImage1.LoadFileName = dRow[11].ToString();
BrowseImage1.LoadImage();
}
else
{
lblMsg.Text = "There is no data for the selected Emp Stays";
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
protected void DdlEmpTIcketId_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
int TcId = Convert.ToInt32(DdlEmpTIcketId.SelectedValue);
DataSet ds = clsEmpFlightTicket.GetEmployeeDataByTicketId(TcId);
if (ds.Tables[0].Rows.Count != 0)
{
DataRow dRow = ds.Tables[0].Rows[0];
txtTicketNo.Text = dRow[3].ToString();
txtBookedDate.Text = dRow[4].ToString();
txtFromDate.Text = dRow[5].ToString();
txtTODate.Text = dRow[6].ToString();
txtTicketFrom.Text = dRow[7].ToString();
txtTicketTo.Text = dRow[8].ToString();
txtSeatNo.Text = dRow[9].ToString();
txtName.Text = dRow[10].ToString();
txtBit.Text = dRow[11].ToString();
txtAgent.Text = dRow[12].ToString();
txtInchargePerson.Text = dRow[13].ToString();
BrowseImage1.LaodImageByte = (byte[])dRow[14];
BrowseImage1.LoadFileName = Convert.ToString(dRow[15]);
BrowseImage1.LoadImage();
txtContactNo.Text = dRow[16].ToString();
}
else
{
lblMsg.Text = "There is no data for the selected Tickets";
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
protected void DdlDocumentId_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
int SpId = Convert.ToInt32(DdlDocumentId.SelectedValue);
DataSet ds = clsPassport.GetEmployeeDataBySupporativeDocumnetId(SpId);
if (ds.Tables[0].Rows.Count != 0)
{
DataRow dRow = ds.Tables[0].Rows[0];
BrowseImage1.LaodImageByte = (byte[])dRow[3];
BrowseImage1.LoadFileName = Convert.ToString(dRow[4]);
BrowseImage1.LoadImage();
BrowseImage2.LaodImageByte = (byte[])dRow[5];
BrowseImage2.LoadFileName = Convert.ToString(dRow[6]);
BrowseImage2.LoadImage();
txtRemarks.Text = dRow[7].ToString();
ChkStatus.Checked = Convert.ToBoolean(dRow[8]);
txtDate.Text = dRow[9].ToString();
}
else
{
lblMsg.Text = "There is no data for the selected Employees";
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}