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 DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (DropDownList1.SelectedIndex != 0)
{
int intProdId = Convert.ToInt32(DropDownList1.SelectedValue);
DataSet ds = clsProducts.GetProductDataByProductId(intProdId);
if (ds.Tables[0].Rows.Count != 0)
{
TextBox1.Text = ds.Tables[0].Rows[0][1].ToString();
txtAbbr.Text = ds.Tables[0].Rows[0][2].ToString();
txtDesc.Text = ds.Tables[0].Rows[0][3].ToString();
BrowseImage1.LoadFileName = ds.Tables[0].Rows[0][4].ToString();
BrowseImage1.LaodImageByte = (byte[])ds.Tables[0].Rows[0][5];
BrowseImage1.GetImage();
}
}
else
{
ClearData();
}
}
catch (Exception ex)
{
throw new ArgumentException(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 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 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 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;
}
}
protected void btnClear_Click(object sender, EventArgs e)
{
txtChildName.Text = "";
txtDateOfBirth.Text = "";
txtClass.Text = "";
txtStory.Text = "";
txtYearOfEnroll.Text = "";
//BrowseImage1.DefaultImageUrl = "~/Photos/NoImage.jpg";
BrowseImage1.LoadDefaultImage();
}
protected void btnClear_Click(object sender, EventArgs e)
{
txtMemberName.Text = "";
txtAddress.Text = "";
txtMobileNo.Text = "";
txtPassword.Text = "";
txtUserName.Text = "";
txtEmailId.Text = "";
ddlMemberType.SelectedIndex = 0;
BrowseImage1.LoadDefaultImage();
}
void ClearData()
{
txtDesc.Text = "";
txtAbbr.Text = "";
TextBox1.Text = "";
if (DropDownList1.Items.Count != 0)
{
DropDownList1.SelectedIndex = 0;
}
BrowseImage1.GetDefaultImage();
}
void ClearData()
{
txtName.Text = "";
txtPass.Text = "";
txt_confirm.Text = "";
txt_Des.Text = "";
txt_edu.Text = "";
txt_emailFac.Text = "";
txt_ph_no.Text = "";
ddlGender.SelectedIndex = 0;
dd_type.SelectedIndex = 0;
BrowseImage1.Clearimage();
}
void GetPersonalDetails()
{
objUser.RegUserId = Convert.ToInt32(Session["ConsumerId"]);
DataSet ds = objUser.GetUserDetails();
DataRow dr = ds.Tables[0].Rows[0];
if (ds.Tables[0].Rows.Count > 0)
{
txtEmail.Text = dr["Email"].ToString();
txtAddress.Text = dr["Address"].ToString();
txtPhone.Text = dr["PhoneNo"].ToString();
BrowseImage1.BindImage(dr["FileName"].ToString(), (byte[])dr["Image"]);
}
}
void ClearData()
{
txtName.Text = "";
txtMName.Text = "";
txtLName.Text = "";
txtAddress.Text = "";
txtEmail.Text = "";
txtPhone.Text = "";
txtUserName.Text = "";
txtPassword.Text = "";
txtDOB.Text = "";
ddlDistrict.SelectedIndex = 0;
ddlStateName.SelectedIndex = 0;
ddlCity.SelectedIndex = 0;
BrowseImage1.Clearimage();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
clsGallery objGellery = new clsGallery();
objGellery.ProgramCode = Session["ProgCode"].ToString();
objGellery.Photo = (byte[])Session["Photo"];
objGellery.FileName = Session["FileName"].ToString();
int i = objGellery.UploadProgramGallery();
if (i > 0)
{
lblMsg.Visible = true;
lblMsg.Text = "Gallery Uploaded";
BrowseImage1.LoadDefaultImage();
}
}
catch (Exception ex)
{
lblMsg.Visible = true;
lblMsg.Text = ex.Message;
}
}
protected void ddlProdMaster_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
int ProdId = Convert.ToInt32(ddlProdMaster.SelectedValue);
if (ProdId != 0)
{
DataSet dsData = objProd.GetProductDataByProId(ProdId);
if (dsData.Tables[0].Rows.Count != 0)
{
txtAbbr.Text = dsData.Tables[0].Rows[0][2].ToString();
txtDesc.Text = dsData.Tables[0].Rows[0][3].ToString();
BrowseImage1.LoadFileName = dsData.Tables[0].Rows[0][4].ToString();
BrowseImage1.LaodImageByte = (byte[])dsData.Tables[0].Rows[0][5];
BrowseImage1.GetImage();
}
}
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
