using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using SRIS_WebPortal.BusinessLogic; using System.Globalization; using System.Text.RegularExpressions; public partial class PublicViewPrivateHujjajSearch : System.Web.UI.Page { srisBO objAdmin = new srisBO(); protected void Page_Load(object sender, EventArgs e) { } public void LoadCombo(DropDownList ddl, string Query, string value, string text) { DataSet ds = new DataSet(); ds = objAdmin.GetQuery(Query); ddl.Items.Clear(); ddl.Items.Add(new ListItem("--- Please Select ---", "0")); ddl.DataValueField = value; ddl.DataTextField = text; ddl.DataSource = ds; ddl.DataBind(); } protected bool CustomValidation() { bool bValidation; bValidation = true; System.Web.UI.ValidatorCollection validatorCollection; validatorCollection = this.Validators; IEnumerator iEnumerator = validatorCollection.GetEnumerator(); RequiredFieldValidator requiredFieldValidator = new RequiredFieldValidator(); RegularExpressionValidator regularExpressionValidator = new RegularExpressionValidator(); CompareValidator compareValidator = new CompareValidator(); while (iEnumerator.MoveNext()) { if (iEnumerator.Current.GetType().ToString().Equals("System.Web.UI.WebControls.RequiredFieldValidator")) { requiredFieldValidator = (RequiredFieldValidator)iEnumerator.Current; if (!requiredFieldValidator.IsValid) { lblError.Text = requiredFieldValidator.ErrorMessage; bValidation = false; break; } } else if (iEnumerator.Current.GetType().ToString().Equals("System.Web.UI.WebControls.RegularExpressionValidator")) { regularExpressionValidator = (RegularExpressionValidator)iEnumerator.Current; if (!regularExpressionValidator.IsValid) { lblError.Text = regularExpressionValidator.ErrorMessage; bValidation = false; break; } } else if (iEnumerator.Current.GetType().ToString().Equals("System.Web.UI.WebControls.CompareValidator")) { compareValidator = (CompareValidator)iEnumerator.Current; if (!compareValidator.IsValid) { lblError.Text = compareValidator.ErrorMessage; bValidation = false; break; } } } return bValidation; } protected void BindHajjiRecord() { try { DataSet ds = new DataSet(); //ds = objAdmin.GetQuery("SELECT Hajj_Application_ID AS id, Company_HGO_ID, Hajj_Year_ID, Hajj_Year, Hajj_Application_No, Group_Coordinators_Application_No, For_Office_Use1, CNIC_No, CONVERT(varchar, Date_of_Birth, 103) AS Date_of_Birth, Is_Passport, Passport_No, CONVERT(varchar, Date_of_Expiry, 103) AS Date_of_Expiry, Applicant_Sur_Name_As_per_Passport, Applicant_Name_As_per_Passport, Fathers_Husband_Name, Present_Postal_Address, HGO_Enrollment_No, For_Office_Use2, Stay_Duration_ID, Stay_Duration, Tehsil_Code_ID, Tehsil_Code, Tehsil_Code_Name, Telephone_No_with_Code_or_Mobile_No, Telephone_No_with_Code, Gender_ID, Gender, (CASE WHEN Are_you_Shia = 1 THEN 'JAFRIA' ELSE 'HANFIA' END) AS Are_you_Shia, (CASE WHEN Are_you_Married = 1 THEN 'YES' ELSE 'NO' END) AS Are_you_Married, Blood_Group_ID, Applicant_Blood_Group, Mehram_ID, Mehram_Code, Mehram_Code_Name, (CASE WHEN Performed_Hajj_in_Last_Five_Years = 1 THEN 'YES' ELSE 'NO' END) AS Performed_Hajj_in_Last_Five_Years, (CASE WHEN Want_to_perform_Hajj_e_Badal = 1 THEN 'YES' ELSE 'NO' END) AS Want_to_perform_Hajj_e_Badal, (CASE WHEN Want_to_perform_Hajj_as_Group_Worker = 1 THEN 'YES' ELSE 'NO' END) AS Want_to_perform_Hajj_as_Group_Worker, Mehrams_Application_No, Relationship_ID, Relationship_with_Mehram, Nominee_Type_ID, Adult_Relative, Nominee_Relationship_ID, Nominee_Relationship, Nominee_in_Case_of_Death, Nominee_CNIC_No, Nominees_Telephone_No_with_Code_or_Mobile_No, Nominees_Telephone_No_with_Code, Name_of_HGO_Company, Substituted_against_Application_ID, Substituted_against_Application_No, HGO_Company_Verification_Certificate, Hajj_Package_Detail_ID, Hajj_Package_Type_ID, Hajj_Package_Type_Name, Hajj_Package_Name, Hajj_Package_Amount, REPLACE(CONVERT(varchar, CAST(Hajj_Package_Offer_Amount AS money), 1), '.00', '') AS Hajj_Package_Offer_Amount, Hajj_Package_CHD_Type_ID, Hajj_Package_CHD_Type, REPLACE(CONVERT(varchar, CAST(CHD_Amount AS money), 1), '.00', '') AS CHD_Amount, CHD_Amount_Dollar, CHD_Amount_Saudi_Riyals, Service_Charges, Hujjaj_Mohafiz_Fund, Total_service_Charges, REPLACE(CONVERT(varchar, CAST(Amount_of_Extra_Facilities AS money), 1), '.00', '') AS Amount_of_Extra_Facilities, REPLACE(CONVERT(varchar, CAST(CHD_Rebate_Amount + Rebate_Amount AS money), 1), '.00', '') AS Rebate_Amount, REPLACE(CONVERT(varchar, CAST(Total_Amount AS money), 1), '.00', '') AS Total_Amount, Receipt_No, Date, Hajj_Duration_Type_ID, Hajj_Duration_Type, Hajj_Duration_Days, (CASE WHEN Is_Qurbani_included_in_Package = 1 THEN 'YES' ELSE 'NO' END) AS Is_Qurbani_included_in_Package, (CASE WHEN Is_Food_included_in_Package = 1 THEN 'YES' ELSE 'NO' END) AS Is_Food_included_in_Package, Food_included_in_Package_for_Days, (CASE WHEN Is_Residence_included_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc = 1 THEN 'YES' ELSE 'NO' END) AS Is_Residence_included_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc, Residence_included_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc_for_Days, Residence_Distance_from_Haram_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc, (CASE WHEN Is_Food_included_in_Package_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc = 1 THEN 'YES' ELSE 'NO' END) AS Is_Food_included_in_Package_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc, Residence_Type_ID_in_MKM, Residence_Type_in_MKM, Residence_Distance_from_Haram_in_MKM, (CASE WHEN Is_Food_included_in_Package_in_MKM = 1 THEN 'YES' ELSE 'NO' END) AS Is_Food_included_in_Package_in_MKM, Food_included_in_Package_for_Days_in_MKM, Residence_Type_ID_in_MDM, Residence_Type_in_MDM, Residence_Distance_from_Masj_e_de_Nabvi_in_MDM, Madina_Accommodation_Area_ID, Madina_Accommodation_Area, (CASE WHEN Is_Food_included_in_Package_in_MDM = 1 THEN 'YES' ELSE 'NO' END) AS Is_Food_included_in_Package_in_MDM, Food_included_in_Package_for_Days_in_MDM, (CASE WHEN Is_Ziaraat_of_MKM_MDM_included = 1 THEN 'YES' ELSE 'NO' END) AS Is_Ziaraat_of_MKM_MDM_included, Mina_Maktab_Category_ID, Mina_Maktab_Category, (CASE WHEN Is_Food_included_in_Package_in_Mina = 1 THEN 'YES' ELSE 'NO' END) AS Is_Food_included_in_Package_in_Mina, Food_included_in_Package_for_Days_in_Mina, Maktab_No, Carrier_ID, Carrier, Carrier_Other, POD_ID, POD_Name, Any_Other, Detail_of_Extra_Facilities_If_other_than_Package, Give_Aways_Gifts_If_any, Amount_of_CHD_Received_and_credited_to_MoRA_AC_by_PO_DD_No, Training_Session_Detail_ID, Training_Session_ID, Training_Session, CONVERT(varchar, Training_Date, 103) AS Training_Date, Training_Venue, Name_of_Trainer, Haji_Declaration, HGO_Company_Cheif_Executive_Declaration, Affidavit_by_Haji, Is_Agreement_Signed_with_Haji, Reason_in_Case_of_No_Agreement_Signed, Is_Medical_Certificate_Filled, Doctor_Name, Hospital_Name, District_ID, District_Name, Tehsil_ID, Tehsil_Name, Landline_No, Cell_No, Doctor_Registration_No_with_PMorDC, Certified_Examined_Haji_Name, Of_Type_ID, Of_Type, Of_Name, MC_Age, MC_Blood_Group_ID, MC_Blood_Group, CONVERT(varchar, MC_LMP_Female, 103) AS MC_LMP_Female, Allergy_to_Following_Medicines, Allergy_Medicine1, Allergy_Medicine2, Allergy_Medicine3, Chronic_Diseases_Requiring_Regular_Medication, Chronic_Disease1, Chronic_Disease2, Chronic_Disease3, Is_Applicant_Fit_for_Hajj_Journey, Doctor_Declaration1, Can_perform_Hajj_with_a_Helper, Requires_the_Help_of_Wheel_Chair, Doctor_Declaration2, Picture_Image_File_Path, ReasonToChangePackage, Hajj_Application_Status_ID, Hajj_Application_Status, Hajj_Application_Status_By, Hajj_Application_Status_Date_Time, Is_Checked_Verified, Checking_Verification_By, Checking_Verification_Date_Time, Final_Print_Status, Final_Print_Status_By, Final_Print_Date_Time, Created_By, Creation_Date, Last_Updated_By, Last_Updated_Date, Flight_Type_ID, Flight_Type, Transport_Type_ID, Transport_Type, Private_Bus_Model_No, Transport_Type_Within_City_ID, Transport_Type_Within_City, Private_Bus_Model_No_Within_City, Training_Time_Span_ID, Training_Time_Span, Accommodation_ID, Accommodation, Accommodation_Location_ID, Accommodation_Location, Food_Package_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc_ID, Food_Package_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc, Load_Per_Room_Bed_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc, Load_Per_Wash_Room_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc, Residence_in_MKM_for_Days, Food_Package_in_MKM_ID, Food_Package_in_MKM, Load_Per_Room_Bed_in_MKM, Load_Per_Wash_Room_in_MKM, Residence_in_MDM_for_Days, Food_Package_in_MDM, Food_Package_in_MDM_ID, Load_Per_Room_Bed_in_MDM, Load_Per_Wash_Room_in_MDM, Food_Package_in_Mina_ID, Food_Package_in_Mina, Flight_Class_ID, Flight_Class, Emergency_Type_ID, Emergency_Adult_Relative, Emergency_Relationship_ID, Emergency_Relationship, Emergency_in_Case_of_Death, Emergency_CNIC_No, Emergency_Telephone_No_with_Code_or_Mobile_No, Emergency_Telephone_No_with_Code, Shifting_Area_ID_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc, Shifting_Area_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc, Residence_Type_ID_Hotel_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc, Residence_Type_Hotel_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc, Residence_Type_ID_Hotel_in_MKM, Residence_Type_Hotel_in_MKM, (CASE WHEN Is_Ziaraat_of_MKM_included = 1 THEN 'YES' ELSE 'NO' END) AS Is_Ziaraat_of_MKM_included, Arrival_at_Madinah_Munawwarah_ID, Arrival_at_Madinah_Munawwarah, Residence_Type_ID_Hotel_in_MDM, Residence_Type_Hotel_in_MDM, Sleeping_Arrangement_in_Mina_ID, Sleeping_Arrangement_in_Mina, Food_Type_Provided_By_Mina_ID, Food_Type_Provided_By_Mina, Maktab_Location_Mina_ID, Maktab_Location_Mina, Maktab_Location_Distance_From_Jamarat, No_of_Persons_in_Tent, Transport_Type_Makkah_Mashair_Makkah_ID, Transport_Type_Makkah_Mashair_Makkah, Private_Bus_Model_No_Makkah_Mashair_Makkah, Transport_Type_Airport_Building_Airport_ID, Transport_Type_Airport_Building_Airport, Private_Bus_Model_No_Airport_Building_Airport, (CASE WHEN Give_Aways_Gifts_Date = 1 THEN 'YES' ELSE 'NO' END) AS Give_Aways_Gifts_Date, (CASE WHEN Give_Aways_Gifts_ZamZam = 1 THEN 'YES' ELSE 'NO' END) AS Give_Aways_Gifts_ZamZam, (CASE WHEN Give_Aways_Gifts_Umbrella = 1 THEN 'YES' ELSE 'NO' END) AS Give_Aways_Gifts_Umbrella, (CASE WHEN Give_Aways_Gifts_WaterBottle_Bag_Hand_carry = 1 THEN 'YES' ELSE 'NO' END) AS Give_Aways_Gifts_WaterBottle_Bag_Hand_carry, (CASE WHEN Give_Aways_Gifts_Other = 1 THEN 'YES' ELSE 'NO' END) AS Give_Aways_Gifts_Other, (CASE WHEN Air_Ticket_Included = 1 THEN 'YES' ELSE 'NO' END) AS Air_Ticket_Included, Mina_Maktab_Facilities_ID, Mina_Maktab_Facilities, Arafat_Facilities_ID, Arafat_Facilities, (CASE WHEN Helper_in_Azizia = 1 THEN 'YES' ELSE 'NO' END) AS Helper_in_Azizia, (CASE WHEN Transport_Azizia = 1 THEN 'YES' ELSE 'NO' END) AS Transport_Azizia, (CASE WHEN Gifts_to_be_provided_Ahram = 1 THEN 'YES' ELSE 'NO' END) AS Gifts_to_be_provided_Ahram, (CASE WHEN Gifts_to_be_provided_Abaya = 1 THEN 'YES' ELSE 'NO' END) AS Gifts_to_be_provided_Abaya, (CASE WHEN Gifts_to_be_provided_Bag = 1 THEN 'YES' ELSE 'NO' END) AS Gifts_to_be_provided_Bag, (CASE WHEN Gifts_to_be_provided_Bottle = 1 THEN 'YES' ELSE 'NO' END) AS Gifts_to_be_provided_Bottle, (CASE WHEN Gifts_to_be_provided_Shoe_Bag = 1 THEN 'YES' ELSE 'NO' END) AS Gifts_to_be_provided_Shoe_Bag, (CASE WHEN Gifts_to_be_provided_Prayer_Mat = 1 THEN 'YES' ELSE 'NO' END) AS Gifts_to_be_provided_Prayer_Mat, (CASE WHEN Ziaraat_of_MKM_Mina = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MKM_Mina , (CASE WHEN Ziaraat_of_MKM_Muzdalfa = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MKM_Muzdalfa , (CASE WHEN Ziaraat_of_MKM_Arafat = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MKM_Arafat , (CASE WHEN Ziaraat_of_MKM_Jamarat = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MKM_Jamarat , (CASE WHEN Ziaraat_of_MKM_Jable_Noor = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MKM_Jable_Noor , (CASE WHEN Ziaraat_of_MKM_Janat_ul_Muallah = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MKM_Janat_ul_Muallah , (CASE WHEN Ziaraat_of_MKM_Other = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MKM_Other , Ziaraat_of_MKM_Other_Details , (CASE WHEN Ziaraat_of_MDM_Masjid_Qiblatain = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MDM_Masjid_Qiblatain , (CASE WHEN Ziaraat_of_MDM_Masjid_Quba = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MDM_Masjid_Quba , (CASE WHEN Ziaraat_of_MDM_Saba_Masajid = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MDM_Saba_Masajid , (CASE WHEN Ziaraat_of_MDM_Shohada_Ohad = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MDM_Shohada_Ohad , (CASE WHEN Ziaraat_of_MDM_Other = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MDM_Other , Ziaraat_of_MDM_Other_Details, ISNULL(Hajj_Application_Group_ID,0) as Hajj_Application_Group_ID FROM dbo.tbl_Pvt_Scheme_Hajj_Application WHERE Hajj_Application_ID = '" + txtGroupLeaderHajjApplicantionNoID.Text + "' Order by Hajj_Application_Status_ID "); ds = objAdmin.GetQuery(@"SELECT Hajj_Application_ID AS id, Company_HGO_ID, Hajj_Year_ID, Hajj_Year, Hajj_Application_No, Group_Coordinators_Application_No, For_Office_Use1, CNIC_No, CONVERT(varchar, Date_of_Birth, 103) AS Date_of_Birth, Is_Passport, Passport_No, CONVERT(varchar, Date_of_Expiry, 103) AS Date_of_Expiry, Applicant_Sur_Name_As_per_Passport, Applicant_Name_As_per_Passport, Fathers_Husband_Name, Present_Postal_Address, HGO_Enrollment_No, For_Office_Use2, Stay_Duration_ID, Stay_Duration, Tehsil_Code_ID, Tehsil_Code, Tehsil_Code_Name, Telephone_No_with_Code_or_Mobile_No, Telephone_No_with_Code, Gender_ID, Gender, (CASE WHEN Are_you_Shia = 1 THEN 'JAFRIA' ELSE 'HANFIA' END) AS Are_you_Shia, (CASE WHEN Are_you_Married = 1 THEN 'YES' ELSE 'NO' END) AS Are_you_Married, Blood_Group_ID, Applicant_Blood_Group, Mehram_ID, Mehram_Code, Mehram_Code_Name, (CASE WHEN Performed_Hajj_in_Last_Five_Years = 1 THEN 'YES' ELSE 'NO' END) AS Performed_Hajj_in_Last_Five_Years, (CASE WHEN Want_to_perform_Hajj_e_Badal = 1 THEN 'YES' ELSE 'NO' END) AS Want_to_perform_Hajj_e_Badal, (CASE WHEN Want_to_perform_Hajj_as_Group_Worker = 1 THEN 'YES' ELSE 'NO' END) AS Want_to_perform_Hajj_as_Group_Worker, (CASE WHEN Are_you_Mehram_of_a_Lady = 1 THEN 'YES' ELSE 'NO' END) Are_you_Mehram_of_a_Lady , Lady_CNIC_No_Not_Performed_Hajj_in_Last_Five_Years, Mehrams_Application_No, Relationship_ID, Relationship_with_Mehram, Nominee_Type_ID, Adult_Relative, Nominee_Relationship_ID, Nominee_Relationship, Nominee_in_Case_of_Death, Nominee_CNIC_No, Nominees_Telephone_No_with_Code_or_Mobile_No, Nominees_Telephone_No_with_Code, Name_of_HGO_Company, Substituted_against_Application_ID, Substituted_against_Application_No, HGO_Company_Verification_Certificate, Hajj_Package_Detail_ID, Hajj_Package_Type_ID, Hajj_Package_Type_Name, Hajj_Package_Name, Hajj_Package_Amount, REPLACE(CONVERT(varchar, CAST(Hajj_Package_Offer_Amount AS money), 1), '.00', '') AS Hajj_Package_Offer_Amount, Hajj_Package_CHD_Type_ID, Hajj_Package_CHD_Type, REPLACE(CONVERT(varchar, CAST(CHD_Amount AS money), 1), '.00', '') AS CHD_Amount, CHD_Amount_Dollar, CHD_Amount_Saudi_Riyals, Service_Charges, Hujjaj_Mohafiz_Fund, Total_service_Charges, REPLACE(CONVERT(varchar, CAST(Amount_of_Extra_Facilities AS money), 1), '.00', '') AS Amount_of_Extra_Facilities, REPLACE(CONVERT(varchar, CAST(CHD_Rebate_Amount + Rebate_Amount AS money), 1), '.00', '') AS Rebate_Amount, REPLACE(CONVERT(varchar, CAST(Total_Amount AS money), 1), '.00', '') AS Total_Amount, Receipt_No, Date, Hajj_Duration_Type_ID, Hajj_Duration_Type, Hajj_Duration_Days, (CASE WHEN Is_Qurbani_included_in_Package = 1 THEN 'YES' ELSE 'NO' END) AS Is_Qurbani_included_in_Package, (CASE WHEN Is_Food_included_in_Package = 1 THEN 'YES' ELSE 'NO' END) AS Is_Food_included_in_Package, Food_included_in_Package_for_Days, (CASE WHEN Is_Residence_included_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc = 1 THEN 'YES' ELSE 'NO' END) AS Is_Residence_included_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc, Residence_included_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc_for_Days, Residence_Distance_from_Haram_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc, (CASE WHEN Is_Food_included_in_Package_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc = 1 THEN 'YES' ELSE 'NO' END) AS Is_Food_included_in_Package_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc, Residence_Type_ID_in_MKM, Residence_Type_in_MKM, Residence_Distance_from_Haram_in_MKM, (CASE WHEN Is_Food_included_in_Package_in_MKM = 1 THEN 'YES' ELSE 'NO' END) AS Is_Food_included_in_Package_in_MKM, Food_included_in_Package_for_Days_in_MKM, Residence_Type_ID_in_MDM, Residence_Type_in_MDM, Residence_Distance_from_Masj_e_de_Nabvi_in_MDM, Madina_Accommodation_Area_ID, Madina_Accommodation_Area, (CASE WHEN Is_Food_included_in_Package_in_MDM = 1 THEN 'YES' ELSE 'NO' END) AS Is_Food_included_in_Package_in_MDM, Food_included_in_Package_for_Days_in_MDM, (CASE WHEN Is_Ziaraat_of_MKM_MDM_included = 1 THEN 'YES' ELSE 'NO' END) AS Is_Ziaraat_of_MKM_MDM_included, Mina_Maktab_Category_ID, Mina_Maktab_Category, (CASE WHEN Is_Food_included_in_Package_in_Mina = 1 THEN 'YES' ELSE 'NO' END) AS Is_Food_included_in_Package_in_Mina, Food_included_in_Package_for_Days_in_Mina, Maktab_No, Carrier_ID, Carrier, Carrier_Other, POD_ID, POD_Name, Any_Other, Detail_of_Extra_Facilities_If_other_than_Package, Give_Aways_Gifts_If_any, Amount_of_CHD_Received_and_credited_to_MoRA_AC_by_PO_DD_No, Training_Session_Detail_ID, Training_Session_ID, Training_Session, CONVERT(varchar, Training_Date, 103) AS Training_Date, Training_Venue, Name_of_Trainer, Haji_Declaration, HGO_Company_Cheif_Executive_Declaration, Affidavit_by_Haji, Is_Agreement_Signed_with_Haji, Reason_in_Case_of_No_Agreement_Signed, Is_Medical_Certificate_Filled, Doctor_Name, Hospital_Name, District_ID, District_Name, Tehsil_ID, Tehsil_Name, Landline_No, Cell_No, Doctor_Registration_No_with_PMorDC, Certified_Examined_Haji_Name, Of_Type_ID, Of_Type, Of_Name, MC_Age, MC_Blood_Group_ID, MC_Blood_Group, CONVERT(varchar, MC_LMP_Female, 103) AS MC_LMP_Female, Allergy_to_Following_Medicines, Allergy_Medicine1, Allergy_Medicine2, Allergy_Medicine3, Chronic_Diseases_Requiring_Regular_Medication, Chronic_Disease1, Chronic_Disease2, Chronic_Disease3, Is_Applicant_Fit_for_Hajj_Journey, Doctor_Declaration1, Can_perform_Hajj_with_a_Helper, Requires_the_Help_of_Wheel_Chair, Doctor_Declaration2, Picture_Image_File_Path, ReasonToChangePackage, Hajj_Application_Status_ID, Hajj_Application_Status, Hajj_Application_Status_By, Hajj_Application_Status_Date_Time, Is_Checked_Verified, Checking_Verification_By, Checking_Verification_Date_Time, Final_Print_Status, Final_Print_Status_By, Final_Print_Date_Time, Created_By, Creation_Date, Last_Updated_By, Last_Updated_Date, Flight_Type_ID, Flight_Type, Transport_Type_ID, Transport_Type, Private_Bus_Model_No, Transport_Type_Within_City_ID, Transport_Type_Within_City, Private_Bus_Model_No_Within_City, Training_Time_Span_ID, Training_Time_Span, Accommodation_ID, Accommodation, Accommodation_Location_ID, Accommodation_Location, Food_Package_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc_ID, Food_Package_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc, Load_Per_Room_Bed_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc, Load_Per_Wash_Room_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc, Residence_in_MKM_for_Days, Food_Package_in_MKM_ID, Food_Package_in_MKM, Load_Per_Room_Bed_in_MKM, Load_Per_Wash_Room_in_MKM, Residence_in_MDM_for_Days, Food_Package_in_MDM, Food_Package_in_MDM_ID, Load_Per_Room_Bed_in_MDM, Load_Per_Wash_Room_in_MDM, Food_Package_in_Mina_ID, Food_Package_in_Mina, Flight_Class_ID, Flight_Class, Emergency_Type_ID, Emergency_Adult_Relative, Emergency_Relationship_ID, Emergency_Relationship, Emergency_in_Case_of_Death, Emergency_CNIC_No, Emergency_Telephone_No_with_Code_or_Mobile_No, Emergency_Telephone_No_with_Code, Shifting_Area_ID_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc, Shifting_Area_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc, Residence_Type_ID_Hotel_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc, Residence_Type_Hotel_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc, Residence_Type_ID_Hotel_in_MKM, Residence_Type_Hotel_in_MKM, (CASE WHEN Is_Ziaraat_of_MKM_included = 1 THEN 'YES' ELSE 'NO' END) AS Is_Ziaraat_of_MKM_included, Arrival_at_Madinah_Munawwarah_ID, Arrival_at_Madinah_Munawwarah, Residence_Type_ID_Hotel_in_MDM, Residence_Type_Hotel_in_MDM, Sleeping_Arrangement_in_Mina_ID, Sleeping_Arrangement_in_Mina, Food_Type_Provided_By_Mina_ID, Food_Type_Provided_By_Mina, Maktab_Location_Mina_ID, Maktab_Location_Mina, Maktab_Location_Distance_From_Jamarat, No_of_Persons_in_Tent, Transport_Type_Makkah_Mashair_Makkah_ID, Transport_Type_Makkah_Mashair_Makkah, Private_Bus_Model_No_Makkah_Mashair_Makkah, Transport_Type_Airport_Building_Airport_ID, Transport_Type_Airport_Building_Airport, Private_Bus_Model_No_Airport_Building_Airport, (CASE WHEN Give_Aways_Gifts_Date = 1 THEN 'YES' ELSE 'NO' END) AS Give_Aways_Gifts_Date, (CASE WHEN Give_Aways_Gifts_ZamZam = 1 THEN 'YES' ELSE 'NO' END) AS Give_Aways_Gifts_ZamZam, (CASE WHEN Give_Aways_Gifts_Umbrella = 1 THEN 'YES' ELSE 'NO' END) AS Give_Aways_Gifts_Umbrella, (CASE WHEN Give_Aways_Gifts_WaterBottle_Bag_Hand_carry = 1 THEN 'YES' ELSE 'NO' END) AS Give_Aways_Gifts_WaterBottle_Bag_Hand_carry, (CASE WHEN Give_Aways_Gifts_Other = 1 THEN 'YES' ELSE 'NO' END) AS Give_Aways_Gifts_Other, (CASE WHEN Air_Ticket_Included = 1 THEN 'YES' ELSE 'NO' END) AS Air_Ticket_Included, Mina_Maktab_Facilities_ID, Mina_Maktab_Facilities, Arafat_Facilities_ID, Arafat_Facilities, (CASE WHEN Helper_in_Azizia = 1 THEN 'YES' ELSE 'NO' END) AS Helper_in_Azizia, (CASE WHEN Transport_Azizia = 1 THEN 'YES' ELSE 'NO' END) AS Transport_Azizia, (CASE WHEN Gifts_to_be_provided_Ahram = 1 THEN 'YES' ELSE 'NO' END) AS Gifts_to_be_provided_Ahram, (CASE WHEN Gifts_to_be_provided_Abaya = 1 THEN 'YES' ELSE 'NO' END) AS Gifts_to_be_provided_Abaya, (CASE WHEN Gifts_to_be_provided_Bag = 1 THEN 'YES' ELSE 'NO' END) AS Gifts_to_be_provided_Bag, (CASE WHEN Gifts_to_be_provided_Bottle = 1 THEN 'YES' ELSE 'NO' END) AS Gifts_to_be_provided_Bottle, (CASE WHEN Gifts_to_be_provided_Shoe_Bag = 1 THEN 'YES' ELSE 'NO' END) AS Gifts_to_be_provided_Shoe_Bag, (CASE WHEN Gifts_to_be_provided_Prayer_Mat = 1 THEN 'YES' ELSE 'NO' END) AS Gifts_to_be_provided_Prayer_Mat, (CASE WHEN Ziaraat_of_MKM_Mina = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MKM_Mina , (CASE WHEN Ziaraat_of_MKM_Muzdalfa = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MKM_Muzdalfa , (CASE WHEN Ziaraat_of_MKM_Arafat = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MKM_Arafat , (CASE WHEN Ziaraat_of_MKM_Jamarat = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MKM_Jamarat , (CASE WHEN Ziaraat_of_MKM_Jable_Noor = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MKM_Jable_Noor , (CASE WHEN Ziaraat_of_MKM_Janat_ul_Muallah = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MKM_Janat_ul_Muallah , (CASE WHEN Ziaraat_of_MKM_Other = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MKM_Other , Ziaraat_of_MKM_Other_Details , (CASE WHEN Ziaraat_of_MDM_Masjid_Qiblatain = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MDM_Masjid_Qiblatain , (CASE WHEN Ziaraat_of_MDM_Masjid_Quba = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MDM_Masjid_Quba , (CASE WHEN Ziaraat_of_MDM_Saba_Masajid = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MDM_Saba_Masajid , (CASE WHEN Ziaraat_of_MDM_Shohada_Ohad = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MDM_Shohada_Ohad , (CASE WHEN Ziaraat_of_MDM_Other = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MDM_Other , Ziaraat_of_MDM_Other_Details , Mina_Arafat_Extra_Facilities_Amount,Hajj_Package_Additional_Facilities_Amount, Hajj_Package_Total_Amount, (CASE WHEN Ziaraat_of_MKM_Ghar_e_Hira_Ghar_e_Sour = 1 THEN 'YES' ELSE 'NO' END) AS Ziaraat_of_MKM_Ghar_e_Hira_Ghar_e_Sour , Air_Ticket_Period_ID, Air_Ticket_Period, Air_Ticket_Amount, Sleeping_Arrangement_in_Mina_Amount, Mina_Maktab_Facilities_Amount, Mina_Maktab_Other_Facilities_ID, Mina_Maktab_Other_Facilities, Mina_Maktab_Other_Facilities_Amount, Mina_Extra_Facilities_ID_Array, Mina_Extra_Facilities_Detail_Array, Arafat_Facilities_Amount, Arafat_Other_Facilities_ID, Arafat_Other_Facilities, Arafat_Other_Facilities_Amount, Arafat_Tenting_ID, Arafat_Tenting, Arafat_Tenting_Amount, Arafat_Bedding_ID, Arafat_Bedding, Arafat_Bedding_Amount, Arafat_Extra_Facilities_ID_Array, Arafat_Extra_Facilities_Detail_Array, (CASE WHEN Gifts_to_be_provided_Stone_Bag = 1 THEN 'YES' ELSE 'NO' END) AS Gifts_to_be_provided_Stone_Bag FROM dbo.tbl_Pvt_Scheme_Hajj_Application WHERE Hajj_Application_ID = '" + txtGroupLeaderHajjApplicantionNoID.Text + "' AND Hajj_Application_Status_ID = '1' AND Hajj_Year_id = '16' "); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Is_Checked_Verified"].ToString() == "True") { lblError.Text = string.Empty; lblError.Visible = false; LabHajjApplicationID.Text = ds.Tables[0].Rows[0]["id"].ToString(); int Hajj_Application_ID = int.Parse(LabHajjApplicationID.Text); int Company_HGO_ID = int.Parse(ds.Tables[0].Rows[0]["Company_HGO_ID"].ToString()); int Hajj_Year_ID = int.Parse(ds.Tables[0].Rows[0]["Hajj_Year_ID"].ToString()); int Hajj_Package_Detail_ID = int.Parse(ds.Tables[0].Rows[0]["Hajj_Package_Detail_ID"].ToString()); LabHajjApplicationID.Text = ds.Tables[0].Rows[0]["id"].ToString(); LabHajjApplication.Text = ds.Tables[0].Rows[0]["Hajj_Application_No"].ToString(); LabHGOName.Text = ds.Tables[0].Rows[0]["Name_of_HGO_Company"].ToString(); LabGroupLeaderAppNo.Text = ds.Tables[0].Rows[0]["Group_Coordinators_Application_No"].ToString(); LabHGOEnrollmentNo.Text = ds.Tables[0].Rows[0]["HGO_Enrollment_No"].ToString(); LabStayDuration.Text = ds.Tables[0].Rows[0]["Stay_Duration"].ToString(); LabHajjApplicationSubstituted.Text = ds.Tables[0].Rows[0]["Substituted_against_Application_No"].ToString(); LabSurname.Text = ds.Tables[0].Rows[0]["Applicant_Sur_Name_As_per_Passport"].ToString(); LabGivenName.Text = ds.Tables[0].Rows[0]["Applicant_Name_As_per_Passport"].ToString(); LabFatherName.Text = ds.Tables[0].Rows[0]["Fathers_Husband_Name"].ToString(); //LabPassportNo.Text = ds.Tables[0].Rows[0]["Passport_No"].ToString(); //LabDateofExpiry.Text = ds.Tables[0].Rows[0]["Date_of_Expiry"].ToString(); //LabDOB.Text = ds.Tables[0].Rows[0]["Date_of_Birth"].ToString(); //LabCNICNo.Text = ds.Tables[0].Rows[0]["CNIC_No"].ToString(); //LabBloodGroup.Text = ds.Tables[0].Rows[0]["Applicant_Blood_Group"].ToString(); //LabGender.Text = ds.Tables[0].Rows[0]["Gender"].ToString(); //LabSect.Text = ds.Tables[0].Rows[0]["Are_you_Shia"].ToString(); //LabMaritalstatus.Text = ds.Tables[0].Rows[0]["Are_you_Married"].ToString(); //LabHomeAddress.Text = ds.Tables[0].Rows[0]["Present_Postal_Address"].ToString(); // LabTehsilCode.Text = ds.Tables[0].Rows[0]["Tehsil_Code"].ToString(); //LabTehsilCode.Text = ds.Tables[0].Rows[0]["Tehsil_Code_Name"].ToString(); //LabHajjMobileNo.Text = ds.Tables[0].Rows[0]["Telephone_No_with_Code_or_Mobile_No"].ToString(); //LabHajjTelephoneNo.Text = ds.Tables[0].Rows[0]["Telephone_No_with_Code"].ToString(); //LabHajjPerformed.Text = ds.Tables[0].Rows[0]["Performed_Hajj_in_Last_Five_Years"].ToString(); //LabHajjeBadal.Text = ds.Tables[0].Rows[0]["Want_to_perform_Hajj_e_Badal"].ToString(); //LabGroupWorker.Text = ds.Tables[0].Rows[0]["Want_to_perform_Hajj_as_Group_Worker"].ToString(); //LabNomineeName.Text = ds.Tables[0].Rows[0]["Nominee_in_Case_of_Death"].ToString(); //LabNomineeRelationship.Text = ds.Tables[0].Rows[0]["Nominee_Relationship"].ToString(); //LabNomineeCNICNo.Text = ds.Tables[0].Rows[0]["Nominee_CNIC_No"].ToString(); //LabNomineeMobileNo.Text = ds.Tables[0].Rows[0]["Nominees_Telephone_No_with_Code_or_Mobile_No"].ToString(); //LabNomineeTelephoneNo.Text = ds.Tables[0].Rows[0]["Nominees_Telephone_No_with_Code"].ToString(); //LabEmergencyNameofPerson.Text = ds.Tables[0].Rows[0]["Emergency_in_Case_of_Death"].ToString(); //LabEmergencyPersonRelation.Text = ds.Tables[0].Rows[0]["Emergency_Relationship"].ToString(); //LabEmwegencyContactNo.Text = ds.Tables[0].Rows[0]["Emergency_Telephone_No_with_Code_or_Mobile_No"].ToString(); //LabMehramAppNo.Text = ds.Tables[0].Rows[0]["Mehrams_Application_No"].ToString(); //LabMehramCode.Text = ds.Tables[0].Rows[0]["Mehram_Code"].ToString(); //LabMehramRelationship.Text = ds.Tables[0].Rows[0]["Relationship_with_Mehram"].ToString(); LabHajjPackageName.Text = ds.Tables[0].Rows[0]["Hajj_Package_Name"].ToString(); LabHajjPackageDues.Text = ds.Tables[0].Rows[0]["Hajj_Package_Offer_Amount"].ToString(); // LabHajjCompulsoryDues.Text = ds.Tables[0].Rows[0]["CHD_Amount"].ToString(); LabAdditionalFacilitiesCharges.Text = ds.Tables[0].Rows[0]["Amount_of_Extra_Facilities"].ToString(); LabeRebate.Text = ds.Tables[0].Rows[0]["Rebate_Amount"].ToString(); LabAmountReceived.Text = ds.Tables[0].Rows[0]["Total_Amount"].ToString(); LabStayDays.Text = ds.Tables[0].Rows[0]["Hajj_Duration_Days"].ToString(); LabMadinaMove.Text = ds.Tables[0].Rows[0]["Arrival_at_Madinah_Munawwarah"].ToString(); //LabQurbani.Text = ds.Tables[0].Rows[0]["Is_Qurbani_included_in_Package"].ToString(); //LabFood.Text = ds.Tables[0].Rows[0]["Is_Food_included_in_Package"].ToString(); LabZiarat.Text = ds.Tables[0].Rows[0]["Is_Ziaraat_of_MKM_MDM_included"].ToString(); LabNameofAirline.Text = ds.Tables[0].Rows[0]["Flight_Type"].ToString(); LabFlightClass.Text = ds.Tables[0].Rows[0]["Flight_Class"].ToString(); LabPOD.Text = ds.Tables[0].Rows[0]["POD_Name"].ToString(); LabAirTicket.Text = ds.Tables[0].Rows[0]["Air_Ticket_Included"].ToString(); if (LabAirTicket.Text.Trim().ToUpper() == "YES") { LabAirTicketPeriod.Text = ds.Tables[0].Rows[0]["Air_Ticket_Period"].ToString(); LabAirTicketAmount.Text = ds.Tables[0].Rows[0]["Air_Ticket_Amount"].ToString(); } LabTransportType.Text = ds.Tables[0].Rows[0]["Transport_Type"].ToString(); LabTransportPrivateBus.Text = ds.Tables[0].Rows[0]["Private_Bus_Model_No"].ToString(); LabelTransportTypeWithCity.Text = ds.Tables[0].Rows[0]["Transport_Type_Within_City"].ToString(); LabelTransportTypeWithCityPrivateBus.Text = ds.Tables[0].Rows[0]["Private_Bus_Model_No_Within_City"].ToString(); LabMakkahMashairMakkah.Text = ds.Tables[0].Rows[0]["Transport_Type_Makkah_Mashair_Makkah"].ToString(); LabMakkahMashairMakkahPrivateBus.Text = ds.Tables[0].Rows[0]["Private_Bus_Model_No_Makkah_Mashair_Makkah"].ToString(); LabAirportBuildingAirport.Text = ds.Tables[0].Rows[0]["Transport_Type_Airport_Building_Airport"].ToString(); LabAirportBuildingAirportPrivateBus.Text = ds.Tables[0].Rows[0]["Private_Bus_Model_No_Airport_Building_Airport"].ToString(); LabTrainingSessionNo.Text = ds.Tables[0].Rows[0]["Training_Session"].ToString(); LabTrainingSessionDate.Text = ds.Tables[0].Rows[0]["Training_Time_Span"].ToString(); LabTrainingSessionvenue.Text = ds.Tables[0].Rows[0]["Training_Venue"].ToString(); LabAccommnodation.Text = ds.Tables[0].Rows[0]["Accommodation"].ToString(); LabAccommnodationLocation.Text = ds.Tables[0].Rows[0]["Accommodation_Location"].ToString(); if (ds.Tables[0].Rows[0]["Accommodation_Location_ID"].ToString() != "2") { LabMakkahHotel.Text = ds.Tables[0].Rows[0]["Residence_Type_in_MKM"].ToString(); LabCategoryArea.Text = ds.Tables[0].Rows[0]["Residence_Type_Hotel_in_MKM"].ToString(); LabMakkahDays.Text = ds.Tables[0].Rows[0]["Residence_in_MKM_for_Days"].ToString(); LabMakkahDistance.Text = ds.Tables[0].Rows[0]["Residence_Distance_from_Haram_in_MKM"].ToString(); LabMakkahFood.Text = ds.Tables[0].Rows[0]["Is_Food_included_in_Package_in_MKM"].ToString(); LabMakkahFoodPackage.Text = ds.Tables[0].Rows[0]["Food_Package_in_MKM"].ToString(); LabMakkahLoadPerRoom.Text = ds.Tables[0].Rows[0]["Load_Per_Room_Bed_in_MKM"].ToString(); //LabMakkahLoadWashRoom.Text = ds.Tables[0].Rows[0]["Load_Per_Wash_Room_in_MKM"].ToString(); LabMakkahISZiaratInculded.Text = ds.Tables[0].Rows[0]["Is_Ziaraat_of_MKM_included"].ToString(); } LabMadinaHotel.Text = ds.Tables[0].Rows[0]["Residence_Type_in_MDM"].ToString(); LabMadinaCategoryArea.Text = ds.Tables[0].Rows[0]["Residence_Type_Hotel_in_MDM"].ToString(); LabMadinaDays.Text = ds.Tables[0].Rows[0]["Residence_in_MDM_for_Days"].ToString(); LabMadinaDistance.Text = ds.Tables[0].Rows[0]["Residence_Distance_from_Masj_e_de_Nabvi_in_MDM"].ToString(); LabMadinaFood.Text = ds.Tables[0].Rows[0]["Is_Food_included_in_Package_in_MDM"].ToString(); LabMadinaFoodPackage.Text = ds.Tables[0].Rows[0]["Food_Package_in_MDM"].ToString(); LabMadinaLoadPerRoom.Text = ds.Tables[0].Rows[0]["Load_Per_Room_Bed_in_MDm"].ToString(); LabMadinaAccomodation.Text = ds.Tables[0].Rows[0]["Madina_Accommodation_Area"].ToString(); //LabMadinaLoadPerWashRoom.Text = ds.Tables[0].Rows[0]["Load_Per_Wash_Room_in_MDM"].ToString(); if (ds.Tables[0].Rows[0]["Accommodation_Location_ID"].ToString() != "1") { LabAziziaShiftingArea.Text = ds.Tables[0].Rows[0]["Shifting_Area_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc"].ToString(); LabAziziaCategoryArea.Text = ds.Tables[0].Rows[0]["Residence_Type_Hotel_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc"].ToString(); LabAziziaDays.Text = ds.Tables[0].Rows[0]["Residence_included_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc_for_Days"].ToString(); LabAziziaDistance.Text = ds.Tables[0].Rows[0]["Residence_Distance_from_Haram_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc"].ToString(); LabAziziaFood.Text = ds.Tables[0].Rows[0]["Is_Food_included_in_Package_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc"].ToString(); LabAziziaFoodPackage.Text = ds.Tables[0].Rows[0]["Food_Package_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc"].ToString(); LabAziziaLoadPerRoom.Text = ds.Tables[0].Rows[0]["Load_Per_Room_Bed_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc"].ToString(); //LabAziziaLoadPerWashRoom.Text = ds.Tables[0].Rows[0]["Load_Per_Wash_Room_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc"].ToString(); LabHelperinAzizia.Text = ds.Tables[0].Rows[0]["Helper_in_Azizia"].ToString(); LabTransportAzizia.Text = ds.Tables[0].Rows[0]["Transport_Azizia"].ToString(); } LabMinaMaktab.Text = ds.Tables[0].Rows[0]["Mina_Maktab_Category"].ToString(); LabMinaFoodProvidedBy.Text = ds.Tables[0].Rows[0]["Food_Type_Provided_By_Mina"].ToString(); LabMinaFood.Text = ds.Tables[0].Rows[0]["Is_Food_included_in_Package_in_Mina"].ToString(); LabMinaFoodPackage.Text = ds.Tables[0].Rows[0]["Food_Package_in_Mina"].ToString(); LabMaktabFacilities.Text = ds.Tables[0].Rows[0]["Mina_Maktab_Facilities"].ToString(); LabMinaBeddingFacilities.Text = ds.Tables[0].Rows[0]["Sleeping_Arrangement_in_Mina"].ToString(); LabMinaOtherFacilities.Text = ds.Tables[0].Rows[0]["Mina_Maktab_Other_Facilities"].ToString(); LabMinaExtraFacilities.Text = ds.Tables[0].Rows[0]["Mina_Extra_Facilities_Detail_Array"].ToString(); LabArafatFacilities.Text = ds.Tables[0].Rows[0]["Arafat_Facilities"].ToString(); LabArafatOtherFacilities.Text = ds.Tables[0].Rows[0]["Arafat_Other_Facilities"].ToString(); LabArafatTentingFacilities.Text = ds.Tables[0].Rows[0]["Arafat_Tenting"].ToString(); LabArafatExtraFacilities.Text = ds.Tables[0].Rows[0]["Arafat_Extra_Facilities_Detail_Array"].ToString(); LabAhram.Text = ds.Tables[0].Rows[0]["Gifts_to_be_provided_Ahram"].ToString(); LabAbaya.Text = ds.Tables[0].Rows[0]["Gifts_to_be_provided_Abaya"].ToString(); LabBag.Text = ds.Tables[0].Rows[0]["Gifts_to_be_provided_Bag"].ToString(); LabWaterBottle.Text = ds.Tables[0].Rows[0]["Gifts_to_be_provided_Bottle"].ToString(); LabShoeBag.Text = ds.Tables[0].Rows[0]["Gifts_to_be_provided_Shoe_Bag"].ToString(); LabStoneBag.Text = ds.Tables[0].Rows[0]["Gifts_to_be_provided_Stone_Bag"].ToString(); LabPrayerMat.Text = ds.Tables[0].Rows[0]["Gifts_to_be_provided_Prayer_Mat"].ToString(); LabGiftDates.Text = ds.Tables[0].Rows[0]["Give_Aways_Gifts_Date"].ToString(); LabGiftZamZam.Text = ds.Tables[0].Rows[0]["Give_Aways_Gifts_ZamZam"].ToString(); LabGiftUmbrella.Text = ds.Tables[0].Rows[0]["Give_Aways_Gifts_Umbrella"].ToString(); LabGiftOther.Text = ds.Tables[0].Rows[0]["Give_Aways_Gifts_Other"].ToString(); LabGifts.Text = ds.Tables[0].Rows[0]["Give_Aways_Gifts_If_any"].ToString(); LabAdditionalFacilities.Text = ds.Tables[0].Rows[0]["Detail_of_Extra_Facilities_If_other_than_Package"].ToString(); //LabMKMZiaraatMina.Text = ds.Tables[0].Rows[0]["Ziaraat_of_MKM_Mina"].ToString(); //LabMKZiaraatMuzdalfa.Text = ds.Tables[0].Rows[0]["Ziaraat_of_MKM_Muzdalfa"].ToString(); //LabMKMZiaraatArafat.Text = ds.Tables[0].Rows[0]["Ziaraat_of_MKM_Arafat"].ToString(); LabMKMZiaraatJamarat.Text = ds.Tables[0].Rows[0]["Ziaraat_of_MKM_Jamarat"].ToString(); LabMKMZiaraatJableNoor.Text = ds.Tables[0].Rows[0]["Ziaraat_of_MKM_Jable_Noor"].ToString(); LabMKMZiaraatJanatulMuallah.Text = ds.Tables[0].Rows[0]["Ziaraat_of_MKM_Janat_ul_Muallah"].ToString(); LabMKMOtherZiaraat.Text = ds.Tables[0].Rows[0]["Ziaraat_of_MKM_Other"].ToString(); LabMKMOtherZiaraatDetails.Text = ds.Tables[0].Rows[0]["Ziaraat_of_MKM_Other_Details"].ToString(); LabMDMMasjidQiblatain.Text = ds.Tables[0].Rows[0]["Ziaraat_of_MDM_Masjid_Qiblatain"].ToString(); LabMDMMasjidQuba.Text = ds.Tables[0].Rows[0]["Ziaraat_of_MDM_Masjid_Quba"].ToString(); LabMDMSabaMasajid.Text = ds.Tables[0].Rows[0]["Ziaraat_of_MDM_Saba_Masajid"].ToString(); LabMDMShohadaOhad.Text = ds.Tables[0].Rows[0]["Ziaraat_of_MDM_Shohada_Ohad"].ToString(); LabMDMOtherZiaraat.Text = ds.Tables[0].Rows[0]["Ziaraat_of_MDM_Other"].ToString(); LabMDMOtherZiaraatDetails.Text = ds.Tables[0].Rows[0]["Ziaraat_of_MDM_Other_Details"].ToString(); AdditionalFacilitiesPackage(Hajj_Application_ID, Company_HGO_ID, Hajj_Year_ID, Hajj_Package_Detail_ID); AdditionalFacilitiesIndividual(Hajj_Application_ID, Company_HGO_ID, Hajj_Year_ID); string ToPicPath; ToPicPath = ds.Tables[0].Rows[0]["Picture_Image_File_Path"].ToString(); //if (ToPicPath == "") //{ // ImgHajjiPic.ImageUrl = "~/Haji_Picture/people-icon.png"; //} //else //{ // ImgHajjiPic.ImageUrl = "http://103.226.216.173/hgos/" + ds.Tables[0].Rows[0]["Picture_Image_File_Path"].ToString(); //} if (ds.Tables[0].Rows[0]["Hajj_Application_Status_ID"].ToString() == "1") { lblError.Visible = true; lblError.Text = "Application Status, Successful."; lblError.ForeColor = System.Drawing.Color.Green; } else { lblError.Visible = true; lblError.Text = "Application Status, Canceled."; lblError.ForeColor = System.Drawing.Color.Red; } //LabDirectConnectFlight.Text = ds.Tables[0].Rows[0]["Flight_Type"].ToString(); //DataSet ds1, ds2, ds3; //ds1 = objAdmin.GetQuery("SELECT HGO_Flight_ID, Company_HGO_ID, HGO_Enrollment_No, Hajj_Application_Group_ID, Group_No, Group_Size, Group_Coordinator_Hajj_Application_No, No_of_Hujjaj_Travel, Convert(varchar,Travel_Date,103) as Travel_Date, POD_ID, POD_Name, KSA_Destination_ID, KSA_Destination, Carrier_ID, (Case When Carrier = 'PIA' then 'PAKISTAN INTERNATIONAL AIRLINE (PK)'When Carrier = 'SV' then 'SAUDI ARABIAN AIRLINES (SV)'When Carrier = 'NL' then 'SHAHEEN AIRLINE (NL)'When Carrier = 'PA' then 'Air Blue (PA)'else 'OTHER AIRLINE' END) as Carrier , Flight_No, Convert(varchar,Return_Date,103) as Return_Date, Carrier_Return_ID, (Case When Carrier_Return = 'PIA' then 'PAKISTAN INTERNATIONAL AIRLINE (PK)'When Carrier_Return = 'SV' then 'SAUDI ARABIAN AIRLINES (SV)'When Carrier_Return = 'NL' then 'SHAHEEN AIRLINE (NL)'When Carrier_Return = 'PA' then 'Air Blue (PA)'else 'OTHER AIRLINE' END) as Carrier_Return , Return_Flight_No, Return_From_ID, Return_From, PNR_No, PNR_Copy_File_Path, Hajj_Year_ID, Hajj_Year, Created_By, Creation_Date, Last_Updated_By, Last_Updated_Date FROM tbl_HGO_Company_Flights_Detail Where Company_HGO_ID = '" + ds.Tables[0].Rows[0]["Company_HGO_ID"].ToString() + "' AND Hajj_Application_Group_ID = '" + ds.Tables[0].Rows[0]["Hajj_Application_Group_ID"].ToString() + "' AND Hajj_Year_id = '15' "); //if (ds1.Tables[0].Rows.Count > 0) //{ // LabAirline.Text = ds1.Tables[0].Rows[0]["Carrier"].ToString(); // LabPODPakistan.Text = ds1.Tables[0].Rows[0]["POD_Name"].ToString(); // LabDateofDeparture.Text = ds1.Tables[0].Rows[0]["Travel_Date"].ToString(); // LabDestinationinKSA.Text = ds1.Tables[0].Rows[0]["KSA_Destination"].ToString(); // LabFlightNoPakistan.Text = ds1.Tables[0].Rows[0]["Flight_No"].ToString(); // LabPODKsa.Text = ds1.Tables[0].Rows[0]["Return_From"].ToString(); // LabDateofDepartureKSA.Text = ds1.Tables[0].Rows[0]["Return_Date"].ToString(); // LabFlightNoKSA.Text = ds1.Tables[0].Rows[0]["Return_Flight_No"].ToString(); //} //ds2 = objAdmin.GetQuery("SELECT HGO_Accommodation_ID, Company_HGO_ID, HGO_Enrollment_No, Hajj_Application_Group_ID, Group_No, Group_Size, Group_Coordinator_Hajj_Application_No, Accommodation_City_Area_ID, Accommodation_City_Area, Accommodation_Name, Accommodation_Haram_Distance, Accommodation_Location, No_of_Hujjaj, Accommodation_Tasreeh_No, Convert(varchar,Accommodation_From_Date,103) as Accommodation_From_Date, Convert(varchar,Accommodation_To_Date,103) as Accommodation_To_Date, Hajj_Package_ID, Hajj_Package_Name, Stay_Duration_ID, Stay_Duration, Hajj_Year_ID, Hajj_Year, Created_By, Creation_Date, Last_Updated_By, Last_Updated_Date FROM tbl_HGO_Company_Accommodation_Detail Where Company_HGO_ID = '" + ds.Tables[0].Rows[0]["Company_HGO_ID"].ToString() + "' AND Hajj_Application_Group_ID = '" + ds.Tables[0].Rows[0]["Hajj_Application_Group_ID"].ToString() + "' AND Hajj_Year_id = '15' "); //if (ds2.Tables[0].Rows.Count > 0) //{ // DataTable dt = new DataTable(); // dt = new DataTable(); // dt.Columns.Add("Lab_Building_Location"); // dt.Columns.Add("Lab_Building_Hotel"); // dt.Columns.Add("Lab_Building_Name"); // dt.Columns.Add("Lab_Typeof_Hotel"); // dt.Columns.Add("Lab_Distance_from_Haram"); // dt.Columns.Add("Lab_Per_Person_Room"); // dt.Columns.Add("Lab_Stay_Duration_Building"); // dt.Columns.Add("Lab_From"); // dt.Columns.Add("Lab_To"); // dt.Columns.Add("Lab_FoodBuilding_YesNo"); // dt.Columns.Add("Lab_FoodType_Building"); // for (int i = 0; i < ds2.Tables[0].Rows.Count; i++) // { // DataRow dr = dt.NewRow(); // dr["Lab_Building_Location"] = ds2.Tables[0].Rows[i]["Accommodation_City_Area"].ToString(); // dr["Lab_Building_Name"] = ds2.Tables[0].Rows[i]["Accommodation_Name"].ToString() + ' ' + ds2.Tables[0].Rows[i]["Accommodation_Location"].ToString(); // dr["Lab_Distance_from_Haram"] = ds2.Tables[0].Rows[i]["Accommodation_Haram_Distance"].ToString(); // dr["Lab_Stay_Duration_Building"] = ds2.Tables[0].Rows[i]["Stay_Duration"].ToString(); // dr["Lab_From"] = ds2.Tables[0].Rows[i]["Accommodation_From_Date"].ToString(); // dr["Lab_To"] = ds2.Tables[0].Rows[i]["Accommodation_To_Date"].ToString(); // if (ds2.Tables[0].Rows[i]["Accommodation_City_Area_ID"].ToString() == "1") // { // dr["Lab_Building_Hotel"] = ds.Tables[0].Rows[0]["Residence_Type_in_MDM"].ToString(); // dr["Lab_Typeof_Hotel"] = ds.Tables[0].Rows[0]["Residence_Type_Hotel_in_MDM"].ToString(); // dr["Lab_Per_Person_Room"] = ds.Tables[0].Rows[0]["Load_Per_Room_Bed_in_MDM"].ToString(); // dr["Lab_FoodBuilding_YesNo"] = ds.Tables[0].Rows[0]["Is_Food_included_in_Package_in_MDM"].ToString(); // dr["Lab_FoodType_Building"] = ds.Tables[0].Rows[0]["Food_Package_in_MDM"].ToString(); // } // if (ds2.Tables[0].Rows[i]["Accommodation_City_Area_ID"].ToString() == "2") // { // dr["Lab_Building_Hotel"] = ds.Tables[0].Rows[0]["Residence_Type_in_MKM"].ToString(); // dr["Lab_Typeof_Hotel"] = ds.Tables[0].Rows[0]["Residence_Type_Hotel_in_MKM"].ToString(); // dr["Lab_Per_Person_Room"] = ds.Tables[0].Rows[0]["Load_Per_Room_Bed_in_MKM"].ToString(); // dr["Lab_FoodBuilding_YesNo"] = ds.Tables[0].Rows[0]["Is_Food_included_in_Package_in_MKM"].ToString(); // dr["Lab_FoodType_Building"] = ds.Tables[0].Rows[0]["Food_Package_in_MKM"].ToString(); // } // if (ds2.Tables[0].Rows[i]["Accommodation_City_Area_ID"].ToString() != "1" && ds2.Tables[0].Rows[i]["Accommodation_City_Area_ID"].ToString() != "2") // { // dr["Lab_Building_Hotel"] = ""; // dr["Lab_Typeof_Hotel"] = ds.Tables[0].Rows[0]["Residence_Type_Hotel_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc"].ToString(); // dr["Lab_Per_Person_Room"] = ds.Tables[0].Rows[0]["Load_Per_Room_Bed_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc"].ToString(); // dr["Lab_FoodBuilding_YesNo"] = ds.Tables[0].Rows[0]["Is_Food_included_in_Package_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc"].ToString(); // dr["Lab_FoodType_Building"] = ds.Tables[0].Rows[0]["Food_Package_in_Azizia_Ghusala_Khaldiya_Shoqiya_etc"].ToString(); // } // dt.Rows.Add(dr); // } // Repeater1.DataSource = dt; // Repeater1.DataBind(); //} /////Mina Details //LabMaktabFacilitiesMina.Text = ds.Tables[0].Rows[0]["Mina_Maktab_Facilities"].ToString(); //LabSleepingArrangmentMina.Text = ds.Tables[0].Rows[0]["Sleeping_Arrangement_in_Mina"].ToString(); ////ds3 = objAdmin.GetQuery("SELECT Hajj_Package_Detail_ID, Company_HGO_ID, HGO_Enrollment_No, Hajj_Package_Type_ID, Hajj_Package_Type_Name, Hajj_Package_Name, Hajj_Package_Amount, Mina_Maktab_Category_ID, Mina_Maktab_Category, Is_Food_included_in_Package_in_Mina, Food_included_in_Package_for_Days_in_Mina, Food_Package_in_Mina_ID, Food_Package_in_Mina, Load_Per_Room_Bed_Mina, Load_Per_Wash_Room_Mina, Maktab_No, Sleeping_Arrangement_in_Mina_ID, Sleeping_Arrangement_in_Mina, Food_Type_Provided_By_Mina_ID, Food_Type_Provided_By_Mina, Maktab_Location_Mina_ID, Maktab_Location_Mina, Maktab_Location_Distance_From_Jamarat, No_of_Persons_in_Tent, Carrier_ID, Carrier, Carrier_Other, Flight_Type_ID, Flight_Type, Flight_Class_ID, Flight_Class, POD_ID, POD_Name, Transport_Type_ID, Transport_Type, Private_Bus_Model_No, Transport_Type_Within_City_ID, Transport_Type_Within_City, Private_Bus_Model_No_Within_City, Transport_Type_Makkah_Mashair_Makkah_ID, Transport_Type_Makkah_Mashair_Makkah, Private_Bus_Model_No_Makkah_Mashair_Makkah, Transport_Type_Airport_Building_Airport_ID, Transport_Type_Airport_Building_Airport, Private_Bus_Model_No_Airport_Building_Airport, Arrival_at_Madinah_Munawwarah_ID, Arrival_at_Madinah_Munawwarah, Air_Ticket_Included, Mina_Maktab_Facilities_ID, Mina_Maktab_Facilities, Arafat_Facilities_ID, Arafat_Facilities, Helper_in_Azizia, Transport_Azizia, Actual_Maktab_Category_ID, Actual_Maktab_Category FROM tbl_Company_HGO_Hajj_Package_Detail Where Company_HGO_ID = '" + ds.Tables[0].Rows[0]["Company_HGO_ID"].ToString() + "' AND Hajj_Package_Detail_ID = '" + ds.Tables[0].Rows[0]["Hajj_Package_Detail_ID"].ToString() + "' AND Hajj_Year_id = '15' "); ////if (ds3.Tables[0].Rows.Count > 0) ////{ //// LabMaktabNoMina.Text = ds3.Tables[0].Rows[0]["Maktab_No"].ToString(); //// LabMaktabCategoryMina.Text = ds3.Tables[0].Rows[0]["Actual_Maktab_Category"].ToString(); ////} Record.Visible = true; } else { lblError.Visible = true; lblError.Text = "Your Hajj Application Information is not Verified by the respective HGO! Kindly consult respective HGO where you have submitted your application."; lblError.ForeColor = System.Drawing.Color.Red; Record.Visible = false; } } } catch { } } protected void AdditionalFacilitiesPackage(int Hajj_Application_ID, int Company_HGO_ID, int Hajj_Year_ID, int Hajj_Package_Detail_ID) { try { DataSet ds = new DataSet(); ds = objAdmin.GetQuery(@"SELECT Hajj_Application_Additional_Facilities_Detail_ID, Hajj_Application_ID, Company_HGO_ID, HGO_Enrollment_No, Hajj_Year_ID, Hajj_Year, Hajj_Package_Detail_ID, Hajj_Package_Additional_Facilities_Detail_ID, Hajj_Package_Additional_Facilities_Type_ID, Hajj_Package_Additional_Facilities_Type, Hajj_Package_Additional_Facilities_ID, Hajj_Package_Additional_Facilities, Is_Hajj_Package_Additional_Facilities_included_in_Package, Hajj_Package_Additional_Facilities_Amount, Is_Active, Created_By, Creation_Date, Last_Updated_By, Last_Updated_Date FROM tbl_Pvt_Scheme_Hajj_Application_Additional_Facilities_Detail Where Is_Active = 1 AND Hajj_Package_Additional_Facilities_Type_ID = 2 AND Hajj_Application_ID = '" + Hajj_Application_ID + "' AND Company_HGO_ID = '" + Company_HGO_ID + "' AND Hajj_Year_ID = '" + Hajj_Year_ID + "' "); if (ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0]; string Additional_Facilities = ""; foreach (DataRow dr in dt.Rows) { if (String.IsNullOrEmpty(Additional_Facilities)) { Additional_Facilities = dr["Hajj_Package_Additional_Facilities"].ToString(); } else { Additional_Facilities = Additional_Facilities + ",
" + dr["Hajj_Package_Additional_Facilities"].ToString(); } } LabAdditionalFacilitiesPackage.Text = Additional_Facilities; } } catch { } } protected void AdditionalFacilitiesIndividual(int Hajj_Application_ID, int Company_HGO_ID, int Hajj_Year_ID) { try { DataSet ds = new DataSet(); ds = objAdmin.GetQuery(@"SELECT Hajj_Application_Additional_Facilities_Detail_ID, Hajj_Application_ID, Company_HGO_ID, HGO_Enrollment_No, Hajj_Year_ID, Hajj_Year, Hajj_Package_Detail_ID, Hajj_Package_Additional_Facilities_Detail_ID, Hajj_Package_Additional_Facilities_Type_ID, Hajj_Package_Additional_Facilities_Type, Hajj_Package_Additional_Facilities_ID, Hajj_Package_Additional_Facilities, Is_Hajj_Package_Additional_Facilities_included_in_Package, Hajj_Package_Additional_Facilities_Amount, Is_Active, Created_By, Creation_Date, Last_Updated_By, Last_Updated_Date FROM tbl_Pvt_Scheme_Hajj_Application_Additional_Facilities_Detail Where Is_Active = 1 AND Hajj_Package_Additional_Facilities_Type_ID = 1 AND Hajj_Application_ID = '" + Hajj_Application_ID + "' AND Company_HGO_ID = '" + Company_HGO_ID + "' AND Hajj_Year_ID = '" + Hajj_Year_ID + "' "); if (ds.Tables[0].Rows.Count > 0) { DataTable dt = ds.Tables[0]; string Additional_Facilities = ""; foreach (DataRow dr in dt.Rows) { if (String.IsNullOrEmpty(Additional_Facilities)) { Additional_Facilities = dr["Hajj_Package_Additional_Facilities"].ToString(); } else { Additional_Facilities = Additional_Facilities + ",
" + dr["Hajj_Package_Additional_Facilities"].ToString(); } } LabAdditionalFacilitiesIndividual.Text = Additional_Facilities; } } catch { } } protected void btnSearch_Click(object sender, EventArgs e) { try { if (txtCNICNo.Text == "" && txtHajjApplicationNo.Text == "" && txtPassportNo.Text == "") { lblError.Text = "Please Enter either CNIC No. or Hajj Application No. or Passport No."; lblError.Visible = true; Record.Visible = false; } else { string code = CaptchaCodeTextBox.Text.Trim().ToUpper(); bool isHuman = SampleCaptcha.Validate(code); CaptchaCodeTextBox.Text = null; // clear previous user input if (isHuman) { lblError.Text = ""; lblError.Visible = false; DataSet ds = new DataSet(); ds = objAdmin.GetQuery("SELECT Hajj_Application_ID as id from tbl_Pvt_Scheme_Hajj_Application WHERE CNIC_No = '" + txtCNICNo.TextWithLiterals + "' AND Hajj_Application_Status_ID = '1' AND Hajj_Year_id = '16' "); if (txtCNICNo.Text != "") { if (txtCNICNo.Text.Length == 13) { ds = objAdmin.GetQuery("SELECT Hajj_Application_ID as id from tbl_Pvt_Scheme_Hajj_Application WHERE CNIC_No = '" + txtCNICNo.TextWithLiterals + "' AND Hajj_Year_id = '16' Order by Hajj_Application_Status_ID "); if (ds.Tables[0].Rows.Count > 0) { txtGroupLeaderHajjApplicantionNoID.Text = ds.Tables[0].Rows[0]["id"].ToString(); BindHajjiRecord(); objAdmin.Val1 = txtCNICNo.Text == "" ? null : txtCNICNo.TextWithLiterals.ToUpper().Trim(); objAdmin.Val2 = txtHajjApplicationNo.Text == "" ? null : (txtHajjApplicationNo.Text.ToUpper().Trim()); objAdmin.Val3 = txtPassportNo.Text == "" ? null : (txtPassportNo.Text.ToUpper().Trim()); objAdmin.Ival1 = int.Parse("1"); objAdmin.Ival2 = int.Parse("16"); objAdmin.Val4 = "HAJJ-2019"; int Rtn = objAdmin.InsertHajjApplicationInquiryLog("sp_Insert_tbl_Hajj_Application_Inquiry_Log"); } else { objAdmin.Val1 = txtCNICNo.Text == "" ? null : txtCNICNo.TextWithLiterals.ToUpper().Trim(); objAdmin.Val2 = txtHajjApplicationNo.Text == "" ? null : (txtHajjApplicationNo.Text.ToUpper().Trim()); objAdmin.Val3 = txtPassportNo.Text == "" ? null : (txtPassportNo.Text.ToUpper().Trim()); objAdmin.Ival1 = int.Parse("0"); objAdmin.Ival2 = int.Parse("16"); objAdmin.Val4 = "HAJJ-2019"; int Rtn = objAdmin.InsertHajjApplicationInquiryLog("sp_Insert_tbl_Hajj_Application_Inquiry_Log"); lblError.Text = "Record Not Found. Kindly consult respective HGO where you have submitted your application."; lblError.Visible = true; Record.Visible = false; } } else { lblError.Text = "The given CNIC No. length is not correct. Please Enter 13 digits CNIC No."; lblError.Visible = true; } } else if (txtHajjApplicationNo.Text != "") { if (txtHajjApplicationNo.Text.Length == 9) { ds = objAdmin.GetQuery("SELECT Hajj_Application_ID as id from tbl_Pvt_Scheme_Hajj_Application WHERE Hajj_Application_No = '" + txtHajjApplicationNo.Text + "' AND Hajj_Year_id = '16' Order by Hajj_Application_Status_ID "); if (ds.Tables[0].Rows.Count > 0) { txtGroupLeaderHajjApplicantionNoID.Text = ds.Tables[0].Rows[0]["id"].ToString(); BindHajjiRecord(); objAdmin.Val1 = txtCNICNo.Text == "" ? null : txtCNICNo.TextWithLiterals.ToUpper().Trim(); objAdmin.Val2 = txtHajjApplicationNo.Text == "" ? null : (txtHajjApplicationNo.Text.ToUpper().Trim()); objAdmin.Val3 = txtPassportNo.Text == "" ? null : (txtPassportNo.Text.ToUpper().Trim()); objAdmin.Ival1 = int.Parse("1"); objAdmin.Ival2 = int.Parse("16"); objAdmin.Val4 = "HAJJ-2019"; int Rtn = objAdmin.InsertHajjApplicationInquiryLog("sp_Insert_tbl_Hajj_Application_Inquiry_Log"); } else { objAdmin.Val1 = txtCNICNo.Text == "" ? null : txtCNICNo.TextWithLiterals.ToUpper().Trim(); objAdmin.Val2 = txtHajjApplicationNo.Text == "" ? null : (txtHajjApplicationNo.Text.ToUpper().Trim()); objAdmin.Val3 = txtPassportNo.Text == "" ? null : (txtPassportNo.Text.ToUpper().Trim()); objAdmin.Ival1 = int.Parse("0"); objAdmin.Ival2 = int.Parse("16"); objAdmin.Val4 = "HAJJ-2019"; int Rtn = objAdmin.InsertHajjApplicationInquiryLog("sp_Insert_tbl_Hajj_Application_Inquiry_Log"); lblError.Text = "Record Not Found. Kindly consult respective HGO where you have submitted your application."; lblError.Visible = true; Record.Visible = false; } } else { lblError.Text = "The given Hajj Application No. length is not correct. Please Enter 9 digits Hajj Application No."; lblError.Visible = true; } } else if (txtPassportNo.Text != "") { if (txtPassportNo.Text.Length == 9) { ds = objAdmin.GetQuery("SELECT Hajj_Application_ID as id from tbl_Pvt_Scheme_Hajj_Application WHERE Passport_No = '" + txtPassportNo.Text + "' AND Hajj_Year_id = '16' Order by Hajj_Application_Status_ID "); if (ds.Tables[0].Rows.Count > 0) { txtGroupLeaderHajjApplicantionNoID.Text = ds.Tables[0].Rows[0]["id"].ToString(); BindHajjiRecord(); objAdmin.Val1 = txtCNICNo.Text == "" ? null : txtCNICNo.TextWithLiterals.ToUpper().Trim(); objAdmin.Val2 = txtHajjApplicationNo.Text == "" ? null : (txtHajjApplicationNo.Text.ToUpper().Trim()); objAdmin.Val3 = txtPassportNo.Text == "" ? null : (txtPassportNo.Text.ToUpper().Trim()); objAdmin.Ival1 = int.Parse("1"); objAdmin.Ival2 = int.Parse("16"); objAdmin.Val4 = "HAJJ-2019"; int Rtn = objAdmin.InsertHajjApplicationInquiryLog("sp_Insert_tbl_Hajj_Application_Inquiry_Log"); } else { objAdmin.Val1 = txtCNICNo.Text == "" ? null : txtCNICNo.TextWithLiterals.ToUpper().Trim(); objAdmin.Val2 = txtHajjApplicationNo.Text == "" ? null : (txtHajjApplicationNo.Text.ToUpper().Trim()); objAdmin.Val3 = txtPassportNo.Text == "" ? null : (txtPassportNo.Text.ToUpper().Trim()); objAdmin.Ival1 = int.Parse("0"); objAdmin.Ival2 = int.Parse("16"); objAdmin.Val4 = "HAJJ-2019"; int Rtn = objAdmin.InsertHajjApplicationInquiryLog("sp_Insert_tbl_Hajj_Application_Inquiry_Log"); lblError.Text = "Record Not Found. Kindly consult respective HGO where you have submitted your application."; lblError.Visible = true; Record.Visible = false; } } else { lblError.Text = "The given Passport No. length is not correct. Please Enter 9 digits Passport No."; lblError.Visible = true; } } else { lblError.Text = "Record Not Found. Kindly consult respective HGO where you have submitted your application."; lblError.Visible = true; Record.Visible = false; } } else { lblError.Text = "Please enter the letters as they are shown in the image. Letters are not case-sensitive."; lblError.Visible = true; Record.Visible = false; } } } catch { } } }