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 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 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;
}
}