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;
     }
 }
Beispiel #2
0
 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;
     }
 }
Beispiel #3
0
    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;
        }
    }