Esempio n. 1
0
    private void DDL_Cat_Bind(sbyte Index)
    {
        //Getting Connection String

        //Connect To database

        switch (Index)
        {
        //Simple
        case 1:
            DDL_Religion.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Religion);
            DDL_Religion.DataTextField  = "Item";
            DDL_Religion.DataValueField = "Value";
            DDL_Religion.DataBind();
            break;

        // Education
        case 2:
            DDL_Cat_1.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Education);
            DDL_Cat_1.DataTextField  = "Item";
            DDL_Cat_1.DataValueField = "Value";
            DDL_Cat_1.DataBind();

            DDL_Religion.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Religion);
            DDL_Religion.DataTextField  = "Item";
            DDL_Religion.DataValueField = "Value";
            DDL_Religion.DataBind();
            break;

        //Occupation
        case 3:
            DDL_Cat_1.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Occupation);
            DDL_Cat_1.DataTextField  = "Item";
            DDL_Cat_1.DataValueField = "Value";
            DDL_Cat_1.DataBind();


            DDL_Religion.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Religion);
            DDL_Religion.DataTextField  = "Item";
            DDL_Religion.DataValueField = "Value";
            DDL_Religion.DataBind();
            break;

        default:

            DDL_Religion.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Religion);
            DDL_Religion.DataTextField  = "Item";
            DDL_Religion.DataValueField = "Value";
            DDL_Religion.DataBind();
            break;
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            // Adding meta Discription
            HtmlMeta objMeta = new HtmlMeta();
            objMeta.Name    = "Description";
            objMeta.Content = WebConfig.GetValues("MetaDiscription");
            this.Header.Controls.Add(objMeta);

            // Adding meta KeyWords
            objMeta         = new HtmlMeta();
            objMeta.Name    = "keywords";
            objMeta.Content = WebConfig.GetValues("MetaKeword");
            this.Header.Controls.Add(objMeta);

            //Loading Controls

            // ----------------------------------------------------------------------------------------------
            DDL_Education.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Education);
            DDL_Education.DataTextField  = "Item";
            DDL_Education.DataValueField = "Value";
            DDL_Education.DataBind();
            // ----------------------------------------------------------------------------------------------
            DDL_EduDetails.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.EduDetails);
            DDL_EduDetails.DataTextField  = "Item";
            DDL_EduDetails.DataValueField = "Value";
            DDL_EduDetails.DataBind();
            // ----------------------------------------------------------------------------------------------
            DDL_AnnualIncome.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.AnnualIncomeRange);
            DDL_AnnualIncome.DataTextField  = "Item";
            DDL_AnnualIncome.DataValueField = "Value";
            DDL_AnnualIncome.DataBind();
            // ----------------------------------------------------------------------------------------------
            DDL_Currency.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Currency);
            DDL_Currency.DataTextField  = "Item";
            DDL_Currency.DataValueField = "Value";
            DDL_Currency.DataBind();
            // ----------------------------------------------------------------------------------------------
            DDL_Occupation.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Occupation);
            DDL_Occupation.DataTextField  = "Item";
            DDL_Occupation.DataValueField = "Value";
            DDL_Occupation.DataBind();
            // ----------------------------------------------------------------------------------------------
            DDL_EmpIn.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.EmployedIn);
            DDL_EmpIn.DataTextField  = "Item";
            DDL_EmpIn.DataValueField = "Value";
            DDL_EmpIn.DataBind();
            // ----------------------------------------------------------------------------------------------
            DDL_BGroup.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.BloodGroup);
            DDL_BGroup.DataTextField  = "Item";
            DDL_BGroup.DataValueField = "Value";
            DDL_BGroup.DataBind();

            DDL_Diet.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Diet);
            DDL_Diet.DataTextField  = "Item";
            DDL_Diet.DataValueField = "Value";
            DDL_Diet.DataBind();
            // ----------------------------------------------------------------------------------------------
            DDL_Country.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Country);;
            DDL_Country.DataTextField  = "Item";
            DDL_Country.DataValueField = "Value";
            DDL_Country.DataBind();
            // ----------------------------------------------------------------------------------------------
            DDL_ResidenceIn.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Country);;
            DDL_ResidenceIn.DataTextField  = "Item";
            DDL_ResidenceIn.DataValueField = "Value";
            DDL_ResidenceIn.DataBind();
            // ----------------------------------------------------------------------------------------------
            DDL_State.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.State);;
            DDL_State.DataTextField  = "Item";
            DDL_State.DataValueField = "Value";
            DDL_State.DataBind();
            // ----------------------------------------------------------------------------------------------
            DDL_ResidentialStatus.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.ResidenceStatus);;
            DDL_ResidentialStatus.DataTextField  = "Item";
            DDL_ResidentialStatus.DataValueField = "Value";
            DDL_ResidentialStatus.DataBind();
            // ----------------------------------------------------------------------------------------------
            short shortCounter;
            DDL_Weight.Items.Insert(0, "-- Select --");
            for (shortCounter = 40; shortCounter <= 140; ++shortCounter)
            {
                DDL_Weight.Items.Add(shortCounter + " KG");
            }


            // ----------------------------------------------------------------------------------------------
            // Lodig selections
            // ----------------------------------------------------------------------------------------------
            // Getting applicationID from Cookie
            HttpCookieCollection objHttpCookieCollection = Request.Cookies;
            HttpCookie           objHttpCookie           = objHttpCookieCollection.Get("MatCookie5639sb");

            string strApplicationID = Crypto.DeCrypto(objHttpCookie.Values["ApplicationID"]);
            //If Cookie is working
            if (strApplicationID != null)
            {
                //Get Member Informations
                MatMember objMember = new MatMember(true, strApplicationID, false, false, false, true, true, true, false, false, false, false);
                DDL_Education.SelectedIndex    = objMember.Education;
                DDL_EduDetails.SelectedIndex   = objMember.EduDetails;
                DDL_AnnualIncome.SelectedIndex = objMember.AnualIncome;
                DDL_Currency.SelectedIndex     = objMember.IncomeIn;
                DDL_Occupation.SelectedIndex   = objMember.Occupation;
                DDL_EmpIn.SelectedIndex        = objMember.EmployedIn;
                // ----------------------------------------------------------------------------------------------
                L_Height.Text            = objMember.Height.ToString() + " Cm";;
                DDL_Weight.SelectedIndex = objMember.Weight - 40;
                DDL_BGroup.SelectedIndex = objMember.BloodGroup;
                L_Complexion.Text        = ControlDataLoader.GetIndexValue(ControlDataLoader.ControlType.Complexion, objMember.Complexion);
                switch (objMember.BodyType)
                {
                case 1:
                    RB_BType_Slim.Checked = true;
                    break;

                case 2:
                    RB_BType_Avg.Checked = true;
                    break;

                case 3:
                    RB_BType_Ath.Checked = true;
                    break;

                case 4:
                    RB_BType_Heavy.Checked = true;
                    break;

                default:
                    break;
                }
                // ----------------------------------------------------------------------------------------------
                DDL_Diet.SelectedIndex = objMember.Diet;

                switch (objMember.Smoke)
                {
                case 1:
                    RB_Smoke_no.Checked = true;
                    break;

                case 2:
                    RB_Smoke_Yes.Checked = true;
                    break;

                case 3:
                    RB_Smoke_Occ.Checked = true;
                    break;

                default:
                    break;
                }
                // ----------------------------------------------------------------------------------------------
                switch (objMember.Drink)
                {
                case 1:
                    RB_Drink_No.Checked = true;
                    break;

                case 2:
                    RB_Drink_Yes.Checked = true;
                    break;

                case 3:
                    RB_Drink_Occ.Checked = true;
                    break;

                default:
                    break;
                }
                // ----------------------------------------------------------------------------------------------
                //Contact Details
                // ----------------------------------------------------------------------------------------------
                TB_Address.Text = objMember.Address;

                DDL_Country.SelectedIndex = objMember.Country;

                DDL_State.SelectedIndex = objMember.State;

                TB_City.Text = objMember.City;

                DDL_ResidenceIn.SelectedIndex = objMember.Residence;

                DDL_ResidentialStatus.SelectedIndex = objMember.ResidenceType;

                TB_Phone_ISD.Text = "+" + objMember.ISDCode.ToString();
                TB_Phone_STD.Text = objMember.AreaCode.ToString();
                TB_Phone_NO.Text  = objMember.PhoneNo.ToString();

                TB_Phone_Mobile.Text = objMember.MobileNO.ToString();

                TB_RCity.Text = objMember.ResidenceCity;

                objMember = null;
                // ----------------------------------------------------------------------------------------------
            }//If StrApplicationID != Null
        }   //if
        else
        {
            sbyte  sbyteFlag = 0;
            string strApplicationID;
            try
            {
                HttpCookieCollection objHttpCookieCollection = Request.Cookies;
                HttpCookie           objHttpCookie           = objHttpCookieCollection.Get("MatCookie5639sb");

                strApplicationID = Crypto.DeCrypto(objHttpCookie.Values["ApplicationID"]);
                if (strApplicationID != null)
                {
                    //Inserting  Education and Occupation
                    sbyteFlag = MatrimonialProfileManager.UpdateEducationalInfo(strApplicationID, (sbyte)DDL_Education.SelectedIndex,
                                                                                (sbyte)DDL_EduDetails.SelectedIndex, (sbyte)DDL_AnnualIncome.SelectedIndex,
                                                                                (short)DDL_Currency.SelectedIndex, (sbyte)DDL_Occupation.SelectedIndex,
                                                                                (sbyte)DDL_EmpIn.SelectedIndex);

                    // setting Physical Attributes

                    sbyte sbyteBodyType = 0;
                    sbyte sbyteSmoke    = 0;
                    sbyte sbyteDrink    = 0;

                    if (RB_BType_Slim.Checked)
                    {
                        sbyteBodyType = 1;
                    }
                    else if (RB_BType_Avg.Checked)
                    {
                        sbyteBodyType = 2;
                    }
                    else if (RB_BType_Ath.Checked)
                    {
                        sbyteBodyType = 3;
                    }
                    else if (RB_BType_Heavy.Checked)
                    {
                        sbyteBodyType = 4;
                    }

                    //Smoking Habite
                    if (RB_Smoke_no.Checked)
                    {
                        sbyteSmoke = 1;
                    }
                    else if (RB_Smoke_Yes.Checked)
                    {
                        sbyteSmoke = 2;
                    }
                    else if (RB_Smoke_Occ.Checked)
                    {
                        sbyteSmoke = 3;
                    }

                    //Drinking Habit
                    if (RB_Drink_No.Checked)
                    {
                        sbyteDrink = 1;
                    }
                    else if (RB_Drink_Yes.Checked)
                    {
                        sbyteDrink = 2;
                    }
                    else if (RB_Drink_Occ.Checked)
                    {
                        sbyteDrink = 3;
                    }

                    // ----------------------------------------------------------------------------------------------
                    //Inserting Physical Attributes
                    sbyteFlag += MatrimonialProfileManager.UpdatePhysicalInfo(strApplicationID,
                                                                              (short)DDL_Weight.SelectedIndex, (sbyte)DDL_BGroup.SelectedIndex, sbyteBodyType,
                                                                              (sbyte)DDL_Diet.SelectedIndex, sbyteSmoke, sbyteDrink);
                    // ----------------------------------------------------------------------------------------------
                    //Setting Contact Details
                    sbyteFlag += MatrimonialProfileManager.UpdateContactInfo(strApplicationID, TB_Address.Text, (short)DDL_Country.SelectedIndex,
                                                                             (sbyte)DDL_State.SelectedIndex, TB_City.Text, TB_Phone_NO.Text, TB_Phone_STD.Text, TB_Phone_ISD.Text,
                                                                             TB_Phone_Mobile.Text, (sbyte)DDL_ResidenceIn.SelectedIndex, (sbyte)DDL_ResidentialStatus.SelectedIndex,
                                                                             TB_RCity.Text);
                    // ----------------------------------------------------------------------------------------------
                }

                if (sbyteFlag == 3)// Every module is updated correctly
                {
                    Response.Redirect("EditProfile-S3.aspx");
                }
                else// Some have some error
                {
                    Server.Transfer("../Extras/ErrorReport.aspx");
                }
            }
            catch (Exception Ex)//Oops Some Error Happend
            {
                ErrorLog.WriteErrorLog("Member-EditProfile S2-PB", Ex);
                Server.Transfer("../Extras/ErrorReport.aspx?id=Cookie");
            }
        }//postbak
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            //-------------------------------------------------------------------------------------------------------------------
            // Adding meta Discription
            HtmlMeta objMeta = new HtmlMeta();
            objMeta.Name    = "Description";
            objMeta.Content = WebConfig.GetValues("MetaDiscription");
            this.Header.Controls.Add(objMeta);
            //-------------------------------------------------------------------------------------------------------------------
            // Adding meta KeyWords
            objMeta         = new HtmlMeta();
            objMeta.Name    = "keywords";
            objMeta.Content = WebConfig.GetValues("MetaKeword");
            this.Header.Controls.Add(objMeta);
            //-------------------------------------------------------------------------------------------------------------------
            //Connect To database
            //Laod Religion
            //-------------------------------------------------------------------------------------------------------------------
            LB_Religion.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Religion);;
            LB_Religion.DataTextField  = "Item";
            LB_Religion.DataValueField = "Value";
            LB_Religion.DataBind();
            LB_Religion.Items.RemoveAt(0);
            //Laod Caste
            //-------------------------------------------------------------------------------------------------------------------
            LB_Caste.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Cast);;
            LB_Caste.DataTextField  = "Item";
            LB_Caste.DataValueField = "Value";
            LB_Caste.DataBind();
            LB_Caste.Items.RemoveAt(0);
            //Load Education
            //-------------------------------------------------------------------------------------------------------------------
            LB_Education.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Education);;
            LB_Education.DataTextField  = "Item";
            LB_Education.DataValueField = "Value";
            LB_Education.DataBind();
            LB_Education.Items.RemoveAt(0);
            //Load Occupation
            //-------------------------------------------------------------------------------------------------------------------
            LB_Occupation.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Occupation);;
            LB_Occupation.DataTextField  = "Item";
            LB_Occupation.DataValueField = "Value";
            LB_Occupation.DataBind();
            LB_Occupation.Items.RemoveAt(0);
            //Load Country
            //-------------------------------------------------------------------------------------------------------------------
            LB_Country.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Country);;
            LB_Country.DataTextField  = "Item";
            LB_Country.DataValueField = "Value";
            LB_Country.DataBind();
            LB_Country.Items.RemoveAt(0);
            //-------------------------------------------------------------------------------------------------------------------
            Int16 Int16Counter;
            DDL_Height_Min.Items.Insert(0, "-- Select --");
            DDL_Height_Max.Items.Insert(0, "-- Select --");
            for (Int16Counter = 90; Int16Counter <= 185; ++Int16Counter)
            {
                DDL_Height_Min.Items.Insert(Int16Counter - 89, Int16Counter + " CM");
                DDL_Height_Max.Items.Insert(Int16Counter - 89, Int16Counter + 1 + " CM");
            }
            //-------------------------------------------------------------------------------------------------------------------
        }
        else
        {
            //Adding Select
            //-------------------------------------------------------------------------------------------------------------------
            string strSQL = "SELECT MatrimonialMemberShip.MatrimonialID ";
            //-------------------------------------------------------------------------------------------------------------------
            // Adding Innerjoining statment depending on Photo
            //-------------------------------------------------------------------------------------------------------------------
            if (CB_needPhoto.Checked)
            {
                strSQL += "   FROM  UserAuthentication INNER JOIN "
                          + " UserBasicInformation ON MatrimonialMemberShip.ApplicationID = UserBasicInformation.ApplicationID INNER JOIN"
                          + " UserContactInformations ON MatrimonialMemberShip.ApplicationID = UserContactInformations.ApplicationID INNER JOIN"
                          + " UserEducationAndOccupation ON MatrimonialMemberShip.ApplicationID = UserEducationAndOccupation.ApplicationID INNER JOIN"
                          + " UserPhysicalAttributes ON MatrimonialMemberShip.ApplicationID = UserPhysicalAttributes.ApplicationID INNER JOIN"
                          + " UserAlbum ON MatrimonialMemberShip.ApplicationID = UserAlbum.ApplicationID";
            }
            else//-------------------------------------------------------------------------------------------------------------------
            {
                strSQL += "    FROM  UserAuthentication INNER JOIN"
                          + " UserBasicInformation ON MatrimonialMemberShip.ApplicationID = UserBasicInformation.ApplicationID INNER JOIN"
                          + " UserContactInformations ON MatrimonialMemberShip.ApplicationID = UserContactInformations.ApplicationID INNER JOIN"
                          + " UserEducationAndOccupation ON MatrimonialMemberShip.ApplicationID = UserEducationAndOccupation.ApplicationID INNER JOIN"
                          + " UserPhysicalAttributes ON MatrimonialMemberShip.ApplicationID = UserPhysicalAttributes.ApplicationID";
            }
            //-------------------------------------------------------------------------------------------------------------------
            // Adding Filter
            //-------------------------------------------------------------------------------------------------------------------
            string SQLWHERE = " WHERE (";
            //-------------------------------------------------------------------------------------------------------------------
            SQLWHERE += " ( ";
            //-------------------------------------------------------------------------------------------------------------------
            // Basic Deteils
            //-------------------------------------------------------------------------------------------------------------------
            SQLWHERE += " (( MatrimonialMemberShip.Membership = 5)OR(MatrimonialMemberShip.Membership = 6 ))  AND (MatrimonialMemberShip.Hidden IS NULL) ";
            //-------------------------------------------------------------------------------------------------------------------
            if (RB_Looking_male.Checked)
            {
                SQLWHERE += " AND ( UserBasicInformation.Gender = 1) ";
            }
            else
            {
                SQLWHERE += " AND ( UserBasicInformation.Gender = 0) ";
            }
            //-------------------------------------------------------------------------------------------------------------------
            SQLWHERE += " AND (DATEDIFF(year,UserBasicInformation.DOB, getdate()) BETWEEN " + TB_Age_Min.Text + " AND " + TB_Age_Max.Text + ") ";

            //-------------------------------------------------------------------------------------------------------------------
            SQLWHERE += " )"
                        + " AND";
            //-------------------------------------------------------------------------------------------------------------------

            // NonBasic Details
            SQLWHERE += " ( ";
            //-------------------------------------------------------------------------------------------------------------------
            //Height
            //-------------------------------------------------------------------------------------------------------------------
            string strOptionalAnd = " ";
            if (DDL_Height_Max.SelectedIndex > 0)
            {
                SQLWHERE      += "( UserPhysicalAttributes.Height BETWEEN " + (DDL_Height_Min.SelectedIndex + 90).ToString() + " AND " + (DDL_Height_Max.SelectedIndex + 90).ToString() + " )";
                strOptionalAnd = " AND "; //Setting Flag
            }
            //-------------------------------------------------------------------------------------------------------------------
            //          Maritals Status
            //-------------------------------------------------------------------------------------------------------------------
            if ((CB_MaritalStatus_UM.Checked) || (CB_MaritalStatus_Div.Checked) || (CB_MaritalStatus_WW.Checked) || (CB_MaritalStatus_Sep.Checked))
            {
                //Setting Flag
                string strOptionalOr = " ";
                SQLWHERE += strOptionalAnd + " ( ";
                if (CB_MaritalStatus_UM.Checked)
                {
                    SQLWHERE     += " UserBasicInformation.MaritalStatus = 1 ";
                    strOptionalOr = " OR ";//Setting Flag
                }
                if (CB_MaritalStatus_WW.Checked)
                {
                    SQLWHERE     += strOptionalOr + " UserBasicInformation.MaritalStatus = 2 ";
                    strOptionalOr = " OR ";//Setting Flag
                }
                if (CB_MaritalStatus_Div.Checked)
                {
                    SQLWHERE     += strOptionalOr + " UserBasicInformation.MaritalStatus = 3 ";
                    strOptionalOr = " OR ";//Setting Flag
                }
                if (CB_MaritalStatus_Sep.Checked)
                {
                    SQLWHERE += strOptionalOr + " UserBasicInformation.MaritalStatus = 4 ";
                }
                SQLWHERE      += " ) ";
                strOptionalAnd = " AND ";
            } //End OF MaritalStatus
            //-------------------------------------------------------------------------------------------------------------------
            //          SubCast
            //-------------------------------------------------------------------------------------------------------------------
            if (TB_Subcast.Text == null)
            {
                SQLWHERE      += " AND ( FREETEXT(UserBasicInformation.SubCast,'" + TB_Subcast.Text + "' )";
                strOptionalAnd = " AND "; //Setting Flag
            }
            //-------------------------------------------------------------------------------------------------------------------
            //Adding Religion
            //-------------------------------------------------------------------------------------------------------------------
            if (!CB_Religion_Any.Checked)
            {
                SQLWHERE += strOptionalAnd;
                SQLWHERE += " ( ";
                string strOptionalOr = " ";
                foreach (ListItem listItem in LB_Religion.Items)
                {
                    if (listItem.Selected)
                    {
                        strOptionalAnd = " AND ";
                        SQLWHERE      += strOptionalOr + " UserBasicInformation.Religion = " + listItem.Value;
                        strOptionalOr  = " OR ";
                    }
                }
                SQLWHERE += " ) ";
            }
            //-------------------------------------------------------------------------------------------------------------------
            //   Caste
            //-------------------------------------------------------------------------------------------------------------------
            if (!CB_Caste_Any.Checked)
            {
                SQLWHERE += strOptionalAnd;
                SQLWHERE += " ( ";
                string strOptionalOr = " ";
                foreach (ListItem listItem in LB_Caste.Items)
                {
                    if (listItem.Selected)
                    {
                        strOptionalAnd = " AND ";
                        SQLWHERE      += strOptionalOr + " UserBasicInformation.Cast = " + listItem.Value;
                        strOptionalOr  = " OR ";
                    }
                }
                SQLWHERE += " ) ";
            }

            //-------------------------------------------------------------------------------------------------------------------
            //      Education
            //-------------------------------------------------------------------------------------------------------------------

            if (!CB_Education_Any.Checked)
            {
                SQLWHERE += strOptionalAnd;
                SQLWHERE += " ( ";
                string strOptionalOr = " ";
                foreach (ListItem listItem in LB_Education.Items)
                {
                    if (listItem.Selected)
                    {
                        strOptionalAnd = " AND ";
                        SQLWHERE      += strOptionalOr + " UserEducationAndOccupation.Education = " + listItem.Value;
                        strOptionalOr  = " OR ";
                    }
                }
                SQLWHERE += " ) ";
            }
            //-------------------------------------------------------------------------------------------------------------------
            //  Occupation
            //-------------------------------------------------------------------------------------------------------------------
            if (!CB_Occupation_any.Checked)
            {
                SQLWHERE += strOptionalAnd;
                SQLWHERE += " ( ";
                string strOptionalOr = " ";
                foreach (ListItem listItem in LB_Occupation.Items)
                {
                    if (listItem.Selected)
                    {
                        strOptionalAnd = " AND ";
                        SQLWHERE      += strOptionalOr + "  UserEducationAndOccupation.Occupation = " + listItem.Value;
                        strOptionalOr  = " OR ";
                    }
                }
                SQLWHERE += " ) ";
            }
            //-------------------------------------------------------------------------------------------------------------------
            //      Country
            //-------------------------------------------------------------------------------------------------------------------
            if (!CB_Country_Any.Checked)
            {
                SQLWHERE += strOptionalAnd;
                SQLWHERE += " ( ";
                string strOptionalOr = " ";
                foreach (ListItem listItem in LB_Country.Items)
                {
                    if (listItem.Selected)
                    {
                        strOptionalAnd = " AND ";
                        SQLWHERE      += strOptionalOr + "  UserContactInformations.Country = " + listItem.Value;
                        strOptionalOr  = " OR ";
                    }
                }
                SQLWHERE += " ) ";
            }
            //-------------------------------------------------------------------------------------------------------------------
            //      Closing Query
            //-------------------------------------------------------------------------------------------------------------------
            SQLWHERE += " ) ) ";
            strSQL   += SQLWHERE;
            //-------------------------------------------------------------------------------------------------------------------
            string strRandom = RandomString.Generate(5, 7);
            Session.Add(strRandom, strSQL);
            //-------------------------------------------------------------------------------------------------------------------
            //Server.Transfer("" + strRandom);
            Response.Redirect("SearchResult.aspx?typ=5&str=" + strRandom);
            //-------------------------------------------------------------------------------------------------------------------
        }
    }
    private void LoadStep4()
    {
        L_Success.Visible = true;

        txtCount.Text = TB_Expectations.MaxLength.ToString();

        /// Text Counter Initiallisation

        TB_Expectations.Attributes.Add("onKeyUp",
                                       "javascript:document.getElementById('" + txtCount.ClientID +
                                       "').setAttribute('value', (" + TB_Expectations.MaxLength +
                                       " - parseInt(document.getElementById('" + TB_Expectations.ClientID +
                                       "').getAttribute('value').length)));");


        //load ddls
        //Getting Connection String

        LB_MaritalStatus.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.MaritalStatus);
        LB_MaritalStatus.DataTextField  = "Item";
        LB_MaritalStatus.DataValueField = "Value";
        LB_MaritalStatus.DataBind();
        LB_MaritalStatus.Items.RemoveAt(0);

        LB_Complexion.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Complexion);
        LB_Complexion.DataTextField  = "Item";
        LB_Complexion.DataValueField = "Value";
        LB_Complexion.DataBind();
        LB_Complexion.Items.RemoveAt(0);

        LB_MotherTongue.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.MotherTongue);
        LB_MotherTongue.DataTextField  = "Item";
        LB_MotherTongue.DataValueField = "Value";
        LB_MotherTongue.DataBind();
        LB_MotherTongue.Items.RemoveAt(0);

        LB_Religion.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Religion);
        LB_Religion.DataTextField  = "Item";
        LB_Religion.DataValueField = "Value";
        LB_Religion.DataBind();
        LB_Religion.Items.RemoveAt(0);

        LB_Caste.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Cast);
        LB_Caste.DataTextField  = "Item";
        LB_Caste.DataValueField = "Value";
        LB_Caste.DataBind();
        LB_Caste.Items.RemoveAt(0);
        LB_Caste.Items.RemoveAt(0);

        LB_Education.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Education);
        LB_Education.DataTextField  = "Item";
        LB_Education.DataValueField = "Value";
        LB_Education.DataBind();
        LB_Education.Items.RemoveAt(0);

        LB_Edudetails.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.EduDetails);;
        LB_Edudetails.DataTextField  = "Item";
        LB_Edudetails.DataValueField = "Value";
        LB_Edudetails.DataBind();
        LB_Edudetails.Items.RemoveAt(0);

        LB_AnnulIncome.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.AnnualIncomeRange);
        LB_AnnulIncome.DataTextField  = "Item";
        LB_AnnulIncome.DataValueField = "Value";
        LB_AnnulIncome.DataBind();
        LB_AnnulIncome.Items.RemoveAt(0);

        LB_Occupation.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Occupation);
        LB_Occupation.DataTextField  = "Item";
        LB_Occupation.DataValueField = "Value";
        LB_Occupation.DataBind();
        LB_Occupation.Items.RemoveAt(0);

        LB_Citizenship.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Country);
        LB_Citizenship.DataTextField  = "Item";
        LB_Citizenship.DataValueField = "Value";
        LB_Citizenship.DataBind();
        LB_Citizenship.Items.RemoveAt(0);

        LB_CountryLiving.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Country);
        LB_CountryLiving.DataTextField  = "Item";
        LB_CountryLiving.DataValueField = "Value";
        LB_CountryLiving.DataBind();
        LB_CountryLiving.Items.RemoveAt(0);

        LB_Rasident_State.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.State);
        LB_Rasident_State.DataTextField  = "Item";
        LB_Rasident_State.DataValueField = "Value";
        LB_Rasident_State.DataBind();
        LB_Rasident_State.Items.RemoveAt(0);
        LB_Rasident_State.Items.Insert(0, "Any");

        LB_Rasident_Status.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.ResidenceStatus);
        LB_Rasident_Status.DataTextField  = "Item";
        LB_Rasident_Status.DataValueField = "Value";
        LB_Rasident_Status.DataBind();
        LB_Rasident_Status.Items.RemoveAt(0);
        LB_Rasident_Status.Items.Insert(0, "Any");

        DDL_ChDosham.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.HoroManglic);
        DDL_ChDosham.DataTextField  = "Item";
        DDL_ChDosham.DataValueField = "Value";
        DDL_ChDosham.DataBind();
        DDL_ChDosham.Items.RemoveAt(5);

        DDL_EathingHabits.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Diet);
        DDL_EathingHabits.DataTextField  = "Item";
        DDL_EathingHabits.DataValueField = "Value";
        DDL_EathingHabits.DataBind();

        Int16 Int16Counter;

        DDL_Height_min.Items.Insert(0, "-- Select --");
        DDL_Height_Max.Items.Insert(0, "-- Select --");
        for (Int16Counter = 90; Int16Counter <= 185; ++Int16Counter)
        {
            DDL_Height_min.Items.Insert(Int16Counter - 89, Int16Counter + " CM");
            DDL_Height_Max.Items.Insert(Int16Counter - 89, Int16Counter + 1 + " CM");
        }


        // Loading Values From DataBase
        //---------------------------------------------------------------------------------------------------
        string strApplicationID = MatrimonialMemberShip.GetApplicationID(HF_MatID.Value);
        //---------------------------------------------------------------------------------------------------
        MatMember objMember = new MatMember(true, strApplicationID, false, false, false, false, false, false, false, false, false, true);
        //---------------------------------------------------------------------------------------------------
        int i;

        //---------------------------------------------------------------------------------------------------
        string[] strARRAY = objMember.PP_LookingFor.Split('%');
        if (strARRAY[0].Length != 0)
        {
            foreach (string index in strARRAY)
            {
                i = int.Parse(index);
                LB_MaritalStatus.Items[i - 1].Selected = true;
            }
        }
        //---------------------------------------------------------------------------------------------------
        TB_Age_min.Text = objMember.PP_AgeMin.ToString();
        TB_Age_Max.Text = objMember.PP_AgeMax.ToString();
        //---------------------------------------------------------------------------------------------------
        strARRAY = objMember.PP_Complexion.Split('%');
        if (strARRAY[0].Length != 0)
        {
            foreach (string index in strARRAY)
            {
                i = int.Parse(index);
                LB_Complexion.Items[i - 1].Selected = true;
            }
        }
        //---------------------------------------------------------------------------------------------------
        switch (objMember.PP_HaveChildren)
        {
        case 1: RB_ChildrenDM.Checked = true;
            break;

        case 2: RB_ChildrenNO.Checked = true;
            break;

        case 3: RB_ChildrenYesLT.Checked = true;
            break;

        case 4: RB_ChildrenYesNLT.Checked = true;
            break;
        }
        //---------------------------------------------------------------------------------------------------
        DDL_Height_min.SelectedIndex = objMember.PP_HeightMin;
        DDL_Height_Max.SelectedIndex = objMember.PP_HeightMax;
        //---------------------------------------------------------------------------------------------------
        switch (objMember.PP_PhysicalStatus)
        {
        case 1: RB_phy_nor.Checked = true;
            break;

        case 2: RB_phy_Dis.Checked = true;
            break;

        case 3: RB_phy_DMater.Checked = true;
            break;
        }
        //---------------------------------------------------------------------------------------------------
        strARRAY = objMember.PP_MotherTongue.Split('%');

        if (strARRAY[0].Length != 0)
        {
            foreach (string index in strARRAY)
            {
                i = int.Parse(index);
                LB_MotherTongue.Items[i - 1].Selected = true;
            }
        }
        //---------------------------------------------------------------------------------------------------
        TB_Expectations.Text = objMember.MyExpectations;
        //---------------------------------------------------------------------------------------------------
        if (objMember.PP_Religion.IndexOf("##") >= 0)
        {
            CB_Religion_Any.Checked = true;
        }
        else
        {
            CB_Caste_Any.Checked = false;
            strARRAY             = objMember.PP_Religion.Split('%');
            if (strARRAY[0].Length != 0)
            {
                foreach (string index in strARRAY)
                {
                    i = int.Parse(index);
                    LB_Religion.Items[i - 1].Selected = true;
                }
                CB_Religion_Any.Checked = false;
            }
            else
            {
                CB_Religion_Any.Checked = true;
            }
        }
        //---------------------------------------------------------------------------------------------------
        if (objMember.PP_Caste.IndexOf("##") >= 0)
        {
            CB_Caste_Any.Checked = true;
        }
        else
        {
            strARRAY = objMember.PP_Caste.Split('%');
            if (strARRAY[0].Length != 0)
            {
                foreach (string index in strARRAY)
                {
                    i = int.Parse(index);
                    LB_Caste.Items[i - 1].Selected = true;
                }
                CB_Caste_Any.Checked = false;
            }
            else
            {
                CB_Caste_Any.Checked = true;
            }
        }
        //---------------------------------------------------------------------------------------------------
        DDL_ChDosham.SelectedIndex      = objMember.PP_Manglik;
        DDL_EathingHabits.SelectedIndex = objMember.Diet;
        //---------------------------------------------------------------------------------------------------
        if (objMember.PP_Education.IndexOf("##") >= 0)
        {
            CB_Education_Any.Checked = true;
        }
        else
        {
            strARRAY = objMember.PP_Education.Split('%');
            if (strARRAY[0].Length != 0)
            {
                foreach (string index in strARRAY)
                {
                    i = int.Parse(index);
                    LB_Education.Items[i - 1].Selected = true;
                }
                CB_Education_Any.Checked = false;
            }
            else
            {
                CB_Education_Any.Checked = true;
            }
        }
        //---------------------------------------------------------------------------------------------------
        if (objMember.PP_EducationDetails.IndexOf("##") >= 0)
        {
            CB_EduDet.Checked = true;
        }
        else
        {
            strARRAY = objMember.PP_EducationDetails.Split('%');
            if (strARRAY[0].Length != 0)
            {
                foreach (string index in strARRAY)
                {
                    i = int.Parse(index);
                    LB_Edudetails.Items[i - 1].Selected = true;
                }
                CB_EduDet.Checked = false;
            }
            else
            {
                CB_EduDet.Checked = true;
            }
        }
        //---------------------------------------------------------------------------------------------------
        LB_AnnulIncome.SelectedIndex = objMember.PP_AnnualIncome;
        //---------------------------------------------------------------------------------------------------
        if (objMember.PP_Occupation.IndexOf("##") >= 0)
        {
            CB_Occupation_any.Checked = true;
        }
        else
        {
            strARRAY = objMember.PP_Occupation.Split('%');
            if (strARRAY[0].Length != 0)
            {
                foreach (string index in strARRAY)
                {
                    i = int.Parse(index);
                    LB_Occupation.Items[i - 1].Selected = true;
                }
                CB_Occupation_any.Checked = false;
            }
            else
            {
                CB_Occupation_any.Checked = true;
            }
        }
        //---------------------------------------------------------------------------------------------------
        if (objMember.PP_Citizenship.IndexOf("##") >= 0)
        {
            CB_IndianX.Checked = true;
        }
        else
        {
            strARRAY = objMember.PP_Citizenship.Split('%');
            if (strARRAY[0].Length != 0)
            {
                foreach (string index in strARRAY)
                {
                    i = int.Parse(index);
                    LB_Citizenship.Items[i - 1].Selected = true;
                }
                CB_IndianX.Checked = false;
            }
            else
            {
                CB_IndianX.Checked = true;
            }
        }
        //---------------------------------------------------------------------------------------------------
        if (objMember.PP_LivingIn.IndexOf("##") >= 0)
        {
            CB_Indian.Checked = true;
        }
        else
        {
            strARRAY = objMember.PP_LivingIn.Split('%');
            if (strARRAY[0].Length != 0)
            {
                foreach (string index in strARRAY)
                {
                    i = int.Parse(index);
                    LB_CountryLiving.Items[i - 1].Selected = true;
                }
                CB_Indian.Checked = false;
            }
            else
            {
                CB_Indian.Checked = true;
            }
        }
        //---------------------------------------------------------------------------------------------------
        if (objMember.PP_ResidingState.IndexOf("##") >= 0)
        {
            CB_StatesInIndia.Checked = false;
            TB_NonIndianState.Text   = objMember.PP_ResidingState.Replace("##", "");
        }
        else
        {
            if (objMember.PP_ResidingState.ToLower().IndexOf("any") >= 0)
            {
                LB_Rasident_State.Items[0].Selected = true;
                CB_StatesInIndia.Checked            = true;
            }
            else
            {
                strARRAY = objMember.PP_ResidingState.Split('%');
                if (strARRAY[0].Length != 0)
                {
                    foreach (string index in strARRAY)
                    {
                        i = int.Parse(index);
                        LB_Rasident_State.Items[i - 1].Selected = true;
                    }
                    CB_StatesInIndia.Checked = true;
                }
                else
                {
                    CB_StatesInIndia.Checked = false;
                }
            }
        }
        //---------------------------------------------------------------------------------------------------
        if (objMember.PP_ResidingState.ToLower().IndexOf("any") >= 0)
        {
            LB_Rasident_Status.Items[0].Selected = true;
        }
        else
        {
            strARRAY = objMember.PP_ResStatus.Split('%');
            if (strARRAY[0].Length != 0)
            {
                foreach (string index in strARRAY)
                {
                    i = int.Parse(index);
                    LB_Rasident_Status.Items[i - 1].Selected = true;
                }
            }
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            //---------------------------------------------------------------------------------------------------
            // Adding meta Discription
            HtmlMeta objMeta = new HtmlMeta();
            objMeta.Name    = "Description";
            objMeta.Content = WebConfig.GetValues("MetaDiscription");
            this.Header.Controls.Add(objMeta);
            //---------------------------------------------------------------------------------------------------
            // Adding meta KeyWords
            objMeta         = new HtmlMeta();
            objMeta.Name    = "keywords";
            objMeta.Content = WebConfig.GetValues("MetaKeword");
            this.Header.Controls.Add(objMeta);
            //---------------------------------------------------------------------------------------------------
            /// Text Counter Initiallisation
            //---------------------------------------------------------------------------------------------------
            txtCount.Text = TB_AboutME.MaxLength.ToString();
            //---------------------------------------------------------------------------------------------------
            TB_AboutME.Attributes.Add("onKeyUp",
                                      "javascript:document.getElementById('" + txtCount.ClientID +
                                      "').setAttribute('value', (" + TB_AboutME.MaxLength +
                                      " - parseInt(document.getElementById('" + TB_AboutME.ClientID +
                                      "').getAttribute('value').length)));");
            //---------------------------------------------------------------------------------------------------
            //Loading Controls
            //Connect To database
            //---------------------------------------------------------------------------------------------------
            DDL_FamilyStatus.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.FamilyStatus);
            DDL_FamilyStatus.DataTextField  = "Item";
            DDL_FamilyStatus.DataValueField = "Value";
            DDL_FamilyStatus.DataBind();
            //---------------------------------------------------------------------------------------------------
            DDL_FamilyType.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Familytype);
            DDL_FamilyType.DataTextField  = "Item";
            DDL_FamilyType.DataValueField = "Value";
            DDL_FamilyType.DataBind();
            //---------------------------------------------------------------------------------------------------
            DDL_FamilyValues.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.FamilyValue);
            DDL_FamilyValues.DataTextField  = "Item";
            DDL_FamilyValues.DataValueField = "Value";
            DDL_FamilyValues.DataBind();
            //---------------------------------------------------------------------------------------------------
            LB_Hobbies.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Hobbies);
            LB_Hobbies.DataTextField  = "Item";
            LB_Hobbies.DataValueField = "Value";
            LB_Hobbies.DataBind();
            LB_Hobbies.Items.RemoveAt(0);
            //---------------------------------------------------------------------------------------------------
            LB_Interests.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Interests);
            LB_Interests.DataTextField  = "Item";
            LB_Interests.DataValueField = "Value";
            LB_Interests.DataBind();
            LB_Interests.Items.RemoveAt(0);
            //---------------------------------------------------------------------------------------------------
            //Loading Member Informations
            HttpCookieCollection objHttpCookieCollection = Request.Cookies;
            HttpCookie           objHttpCookie           = objHttpCookieCollection.Get("MatCookie5639sb");
            //---------------------------------------------------------------------------------------------------
            string strApplicationID = Crypto.DeCrypto(objHttpCookie.Values["ApplicationID"]);
            //---------------------------------------------------------------------------------------------------
            MatMember objMember = new MatMember(true, strApplicationID, false, false, false, false, false, false, true, true, true, false);
            //---------------------------------------------------------------------------------------------------
            TB_AboutME.Text       = objMember.AboutMe;
            TB_FamilyDetails.Text = objMember.FamilyDetails;
            TB_familyOrigin.Text  = objMember.FamilyOrigin;
            TB_Father_Occ.Text    = objMember.FatherOccupation;
            TB_Mother_Occ.Text    = objMember.MotherOccupation;
            //---------------------------------------------------------------------------------------------------
            L_FatherName.Text  = objMember.FathersName;
            L_MotherName.Text  = objMember.MothersName;
            L_NoOfBrother.Text = objMember.NoOfBrothers.ToString();
            //---------------------------------------------------------------------------------------------------
            DDL_FamilyStatus.SelectedIndex = objMember.FamilyStatus;
            DDL_FamilyType.SelectedIndex   = objMember.FamilyType;
            DDL_FamilyValues.SelectedIndex = objMember.FamilyValues;
            //---------------------------------------------------------------------------------------------------
            if (objMember.FatherAlive)
            {
                RB_Father_Alive.Checked = true;
            }
            else
            {
                RB_Father_NAlive.Checked = true;
            }

            if (objMember.MotherAlive)
            {
                RB_Mother_Alive.Checked = true;
            }
            else
            {
                RB_Mother_NAlive.Checked = true;
            }
            //---------------------------------------------------------------------------------------------------
            if (objMember.NoOfBrothers != 6)
            {
                if (objMember.NoOfBrothers == objMember.BrothersMarried)
                {
                    L_BMarried.Visible = true;
                    L_BMarried.Text    = objMember.NoOfBrothers.ToString();
                    L_NoOfBrother.Text = objMember.NoOfBrothers.ToString();
                    DDL_NoOfBrothersMarried.Visible = false;
                }
                else
                {
                    L_NoOfBrother.Text = objMember.NoOfBrothers.ToString();
                    DDL_NoOfBrothersMarried.SelectedIndex = objMember.BrothersMarried;
                }
            }
            else
            {
                L_NoOfBrother.Text = "Nill";
                L_BMarried.Visible = true;
                DDL_NoOfBrothersMarried.Visible = false;
                L_BMarried.Text = "Not Applicable";
            }
            //---------------------------------------------------------------------------------------------------
            if (objMember.NoOfSisters != 6)
            {
                if (objMember.NoOfSisters == objMember.SistersMarried)
                {
                    L_SMarried.Visible             = true;
                    L_SMarried.Text                = objMember.NoOfSisters.ToString();
                    L_NoOfSister.Text              = objMember.NoOfSisters.ToString();
                    DDL_NoOFSistersMarried.Visible = false;
                }
                else
                {
                    L_NoOfSister.Text = objMember.NoOfSisters.ToString();
                    DDL_NoOFSistersMarried.SelectedIndex = objMember.SistersMarried;
                }
            }
            else
            {
                L_NoOfSister.Text              = "Nill";
                L_SMarried.Visible             = true;
                DDL_NoOFSistersMarried.Visible = false;
                L_SMarried.Text = "Not Applicable";
            }
            //---------------------------------------------------------------------------------------------------
            string[] strAHobbies = objMember.HobbiesList.Split('%');
            int      i;
            if (strAHobbies[0].Length != 0)
            {
                foreach (string index in strAHobbies)
                {
                    i = int.Parse(index);
                    LB_Hobbies.Items[i - 1].Selected = true;
                }
            }
            //---------------------------------------------------------------------------------------------------
            string[] strAIntrests = objMember.IntrestList.Split('%');
            if (strAIntrests[0].Length != 0)
            {
                foreach (string index in strAIntrests)
                {
                    i = int.Parse(index);
                    LB_Interests.Items[i - 1].Selected = true;
                }
            }
            //---------------------------------------------------------------------------------------------------
            TB_OtherHobbies.Text   = objMember.OtherHobbies;
            TB_OtherInterests.Text = objMember.OtherIntrests;
            //---------------------------------------------------------------------------------------------------
            objMember = null;
        }    //if!postback
        //---------------------------------------------------------------------------------------------------
        else // postback
        //---------------------------------------------------------------------------------------------------
        {
            sbyte sbyteBrotherToMarry;
            sbyte sbyteSisterToMarry;

            sbyte sbyteFlage = 0;
            //try
            //{
            HttpCookieCollection objHttpCookieCollection = Request.Cookies;
            HttpCookie           objHttpCookie           = objHttpCookieCollection.Get("MatCookie5639sb");

            string strApplicationID = Crypto.DeCrypto(objHttpCookie.Values["ApplicationID"]);

            if (strApplicationID != null)
            {
                //Updating About Me
                //---------------------------------------------------------------------------------------------------
                sbyteFlage = MatrimonialProfileManager.UpdateAboutMe(strApplicationID, TB_AboutME.Text);
                //---------------------------------------------------------------------------------------------------
                // Setting data for Family Informations

                if (DDL_NoOfBrothersMarried.SelectedIndex != 0)
                {
                    sbyteBrotherToMarry = (sbyte)DDL_NoOfBrothersMarried.SelectedIndex;
                }
                else
                {
                    sbyteBrotherToMarry = sbyte.Parse(L_BMarried.Text);
                }

                if (DDL_NoOFSistersMarried.SelectedIndex != 0)
                {
                    sbyteSisterToMarry = (sbyte)DDL_NoOFSistersMarried.SelectedIndex;
                }
                else
                {
                    sbyteSisterToMarry = sbyte.Parse(L_SMarried.Text);
                }

                //Updating Family Informations
                //---------------------------------------------------------------------------------------------------
                sbyteFlage += MatrimonialProfileManager.UpdateFamilyInfo(strApplicationID, TB_FamilyDetails.Text, (sbyte)DDL_FamilyValues.SelectedIndex,
                                                                         (sbyte)DDL_FamilyType.SelectedIndex, (sbyte)DDL_FamilyStatus.SelectedIndex, TB_familyOrigin.Text,
                                                                         sbyteBrotherToMarry, sbyteSisterToMarry, RB_Father_Alive.Checked, RB_Mother_Alive.Checked,
                                                                         TB_Father_Occ.Text, TB_Mother_Occ.Text);
                //---------------------------------------------------------------------------------------------------
                string strHobbiesList = "";
                string Flag           = "";
                foreach (ListItem objListItem in LB_Hobbies.Items)
                {
                    if (objListItem.Selected)
                    {
                        strHobbiesList += Flag + objListItem.Value;
                        Flag            = "%";
                    }
                }
                Flag = "";
                //Intrests
                string strInterestList = "";
                foreach (ListItem objListItem in LB_Interests.Items)
                {
                    if (objListItem.Selected)
                    {
                        strInterestList += Flag + objListItem.Value;
                        Flag             = "%";
                    }
                }
                //---------------------------------------------------------------------------------------------------
                //Inserting Into Database
                sbyteFlage += MatrimonialProfileManager.InsertHobiesNInterests(strApplicationID, strHobbiesList, TB_OtherHobbies.Text, strInterestList, TB_OtherInterests.Text);

                //---------------------------------------------------------------------------------------------------
                if (sbyteFlage == 3)
                {
                    Response.Redirect("EditProfile-S4.aspx");
                }
                else
                {
                    Response.Redirect("../Extras/ErrorReport.aspx");
                }
            }
            else
            {
                Response.Redirect("../Extras/ErrorReport.aspx");
            }
            //}
            //catch (Exception)
            //{ }
            //---------------------------------------------------------------------------------------------------
        }
    }
Esempio n. 6
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            // Adding meta Discription
            HtmlMeta objMeta = new HtmlMeta();
            objMeta.Name    = "Description";
            objMeta.Content = WebConfig.GetValues("MetaDiscription");
            this.Header.Controls.Add(objMeta);

            // Adding meta KeyWords
            objMeta         = new HtmlMeta();
            objMeta.Name    = "keywords";
            objMeta.Content = WebConfig.GetValues("MetaKeword");
            this.Header.Controls.Add(objMeta);

            txtCount.Text = TB_AboutME.MaxLength.ToString();

            TB_AboutME.Attributes.Add("onKeyUp",
                                      "javascript:document.getElementById('" + txtCount.ClientID +
                                      "').setAttribute('value', (" + TB_AboutME.MaxLength +
                                      " - parseInt(document.getElementById('" + TB_AboutME.ClientID +
                                      "').getAttribute('value').length)));");

            //Loading DDLs

            //Getting Connection String

            DDL_FamilyStatus.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.FamilyStatus);
            DDL_FamilyStatus.DataTextField  = "Item";
            DDL_FamilyStatus.DataValueField = "Value";
            DDL_FamilyStatus.DataBind();

            DDL_FamilyType.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Familytype);
            DDL_FamilyType.DataTextField  = "Item";
            DDL_FamilyType.DataValueField = "Value";
            DDL_FamilyType.DataBind();

            DDL_FamilyValues.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.FamilyValue);
            DDL_FamilyValues.DataTextField  = "Item";
            DDL_FamilyValues.DataValueField = "Value";
            DDL_FamilyValues.DataBind();

            LB_Hobbies.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Hobbies);
            LB_Hobbies.DataTextField  = "Item";
            LB_Hobbies.DataValueField = "Value";
            LB_Hobbies.DataBind();
            LB_Hobbies.Items.RemoveAt(0);

            LB_Interests.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Interests);
            LB_Interests.DataTextField  = "Item";
            LB_Interests.DataValueField = "Value";
            LB_Interests.DataBind();
            LB_Interests.Items.RemoveAt(0);
        }
        else        // Not postback
        {
            sbyte sbyteFlage = 0;
            //try
            //{
            HttpCookieCollection objHttpCookieCollection = Request.Cookies;
            HttpCookie           objHttpCookie           = objHttpCookieCollection.Get("MatRegInfo");

            strApplicationID = Crypto.DeCrypto(objHttpCookie.Values["ApplicationID"]);
            if (strApplicationID != null)
            {
                //About Me
                sbyteFlage = MatrimonialProfileManager.InsertAboutMe(strApplicationID, TB_AboutME.Text);
                // Family Details
                sbyteFlage += MatrimonialProfileManager.InsertFamilyInfo(strApplicationID, TB_FamilyDetails.Text, (sbyte)DDL_FamilyValues.SelectedIndex,
                                                                         (sbyte)DDL_FamilyType.SelectedIndex, (sbyte)DDL_FamilyStatus.SelectedIndex, TB_familyOrigin.Text,
                                                                         (sbyte)DDL_NoOfBrothers.SelectedIndex, (sbyte)DDL_NoOFSisters.SelectedIndex, (sbyte)DDL_NoOfBrothersMarried.SelectedIndex,
                                                                         (sbyte)DDL_NoOFSistersMarried.SelectedIndex, TB_Father_Name.Text, TB_Mother_name.Text,
                                                                         RB_FLIve.Checked, RB_MLive.Checked, TB_Father_Occ.Text, TB_Mother_Occ.Text);

                //Hobbies And Interests
                string strHobbiesList = "";
                string Flag           = "";
                foreach (ListItem objListItem in LB_Hobbies.Items)
                {
                    if (objListItem.Selected)
                    {
                        strHobbiesList += Flag + objListItem.Value;
                        Flag            = "%";
                    }
                }
                Flag = "";
                //Intrests
                string strInterestList = "";
                foreach (ListItem objListItem in LB_Interests.Items)
                {
                    if (objListItem.Selected)
                    {
                        strInterestList += Flag + objListItem.Value;
                        Flag             = "%";
                    }
                }
                //Inserting Into Database
                sbyteFlage += MatrimonialProfileManager.InsertHobiesNInterests(strApplicationID, strHobbiesList, TB_OtherHobbies.Text, strInterestList, TB_OtherInterests.Text);

                if (sbyteFlage == 3)
                {
                    MatrimonialMemberShip.UpdateIndex(strApplicationID);
                    Server.Transfer("RegistrationStep4.aspx");
                }
                else
                {
                    Response.Redirect("../Extras/ErrorReport.aspx");
                }
            }
            else
            {
                Response.Redirect("../Extras/ErrorReport.aspx");
            }
            //}
            //catch (Exception)
            //{ }
        }
    }
Esempio n. 7
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            // Adding meta Discription
            HtmlMeta objMeta = new HtmlMeta();
            objMeta.Name    = "Description";
            objMeta.Content = WebConfig.GetValues("MetaDiscription");
            this.Header.Controls.Add(objMeta);

            // Adding meta KeyWords
            objMeta         = new HtmlMeta();
            objMeta.Name    = "keywords";
            objMeta.Content = WebConfig.GetValues("MetaKeword");
            this.Header.Controls.Add(objMeta);

            /// Text Counter Initiallisation

            txtCount.Text = TB_Expectations.MaxLength.ToString();

            TB_Expectations.Attributes.Add("onKeyUp", "javascript:document.getElementById('" + txtCount.ClientID + "').setAttribute('value', (" + TB_Expectations.MaxLength +
                                           " - parseInt(document.getElementById('" + TB_Expectations.ClientID + "').getAttribute('value').length)));");

            //load ddls
            //Getting Connection String

            //Connect To database
            LB_MaritalStatus.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.MaritalStatus);
            LB_MaritalStatus.DataTextField  = "Item";
            LB_MaritalStatus.DataValueField = "Value";
            LB_MaritalStatus.DataBind();
            LB_MaritalStatus.Items.RemoveAt(0);

            LB_Complexion.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Complexion);
            LB_Complexion.DataTextField  = "Item";
            LB_Complexion.DataValueField = "Value";
            LB_Complexion.DataBind();
            LB_Complexion.Items.RemoveAt(0);

            LB_MotherTongue.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.MotherTongue);
            LB_MotherTongue.DataTextField  = "Item";
            LB_MotherTongue.DataValueField = "Value";
            LB_MotherTongue.DataBind();
            LB_MotherTongue.Items.RemoveAt(0);

            LB_Religion.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Religion);
            LB_Religion.DataTextField  = "Item";
            LB_Religion.DataValueField = "Value";
            LB_Religion.DataBind();
            LB_Religion.Items.RemoveAt(0);

            LB_Caste.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Cast);
            LB_Caste.DataTextField  = "Item";
            LB_Caste.DataValueField = "Value";
            LB_Caste.DataBind();
            LB_Caste.Items.RemoveAt(0);
            LB_Caste.Items.RemoveAt(0);
            LB_Caste.Items.Insert(0, "Any");

            LB_Education.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Education);
            LB_Education.DataTextField  = "Item";
            LB_Education.DataValueField = "Value";
            LB_Education.DataBind();
            LB_Education.Items.RemoveAt(0);
            LB_Education.Items.Insert(0, "Any");


            LB_Edudetails.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.EduDetails);
            LB_Edudetails.DataTextField  = "Item";
            LB_Edudetails.DataValueField = "Value";
            LB_Edudetails.DataBind();
            LB_Edudetails.Items.RemoveAt(0);
            LB_Edudetails.Items.Insert(0, "Any");

            LB_AnnulIncome.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.AnnualIncomeRange);
            LB_AnnulIncome.DataTextField  = "Item";
            LB_AnnulIncome.DataValueField = "Value";
            LB_AnnulIncome.DataBind();
            LB_AnnulIncome.Items.RemoveAt(0);

            LB_Occupation.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Occupation);
            LB_Occupation.DataTextField  = "Item";
            LB_Occupation.DataValueField = "Value";
            LB_Occupation.DataBind();
            LB_Occupation.Items.RemoveAt(0);
            LB_Occupation.Items.Insert(0, "Any");

            LB_Citizenship.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Country);
            LB_Citizenship.DataTextField  = "Item";
            LB_Citizenship.DataValueField = "Value";
            LB_Citizenship.DataBind();
            LB_Citizenship.Items.RemoveAt(0);
            LB_Citizenship.Items.Insert(0, "Any");

            LB_CountryLiving.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Country);
            LB_CountryLiving.DataTextField  = "Item";
            LB_CountryLiving.DataValueField = "Value";
            LB_CountryLiving.DataBind();
            LB_CountryLiving.Items.RemoveAt(0);
            LB_CountryLiving.Items.Insert(0, "Any");

            LB_Rasident_State.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.State);
            LB_Rasident_State.DataTextField  = "Item";
            LB_Rasident_State.DataValueField = "Value";
            LB_Rasident_State.DataBind();
            LB_Rasident_State.Items.RemoveAt(0);
            LB_Rasident_State.Items.Insert(0, "Any");

            LB_Rasident_Status.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.ResidenceStatus);
            LB_Rasident_Status.DataTextField  = "Item";
            LB_Rasident_Status.DataValueField = "Value";
            LB_Rasident_Status.DataBind();
            LB_Rasident_Status.Items.RemoveAt(0);
            LB_Rasident_Status.Items.Insert(0, "Any");

            DDL_ChDosham.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.HoroManglic);
            DDL_ChDosham.DataTextField  = "Item";
            DDL_ChDosham.DataValueField = "Value";
            DDL_ChDosham.DataBind();
            DDL_ChDosham.Items.RemoveAt(5);


            DDL_EathingHabits.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Diet);
            DDL_EathingHabits.DataTextField  = "Item";
            DDL_EathingHabits.DataValueField = "Value";
            DDL_EathingHabits.DataBind();

            Int16 Int16Counter;
            DDL_Height_min.Items.Insert(0, "-- Select --");
            DDL_Height_Max.Items.Insert(0, "-- Select --");
            for (Int16Counter = 90; Int16Counter <= 185; ++Int16Counter)
            {
                DDL_Height_min.Items.Insert(Int16Counter - 89, Int16Counter + " CM");
                DDL_Height_Max.Items.Insert(Int16Counter - 89, Int16Counter + 1 + " CM");
            }


            TB_NonIndianState.Attributes.Add("visible", "false");
        }
        else
        {
            HttpCookieCollection objHttpCookieCollection = Request.Cookies;
            HttpCookie           objHttpCookie           = objHttpCookieCollection.Get("MatRegInfo");

            strApplicationID = Crypto.DeCrypto(objHttpCookie.Values["ApplicationID"]);

            // Inserting data into database
            if (strApplicationID != null)
            {
                sbyte sbyteFlag = 0;
                sbyte sbyteChildrenStatus;
                sbyte sbytePhysicalStatus;

                //-------------------------------------------------------------------------------------------------------------
                if (RB_ChildrenNO.Checked)
                {
                    sbyteChildrenStatus = 1;
                }
                else if (RB_ChildrenYesLT.Checked)
                {
                    sbyteChildrenStatus = 2;
                }
                else if (RB_ChildrenYesNLT.Checked)
                {
                    sbyteChildrenStatus = 3;
                }
                else if (RB_ChildrenDM.Checked)
                {
                    sbyteChildrenStatus = 4;
                }
                else
                {
                    sbyteChildrenStatus = 0;
                }

                //-------------------------------------------------------------------------------------------------------------

                if (RB_phy_nor.Checked)
                {
                    sbytePhysicalStatus = 1;
                }
                else if (RB_phy_Dis.Checked)
                {
                    sbytePhysicalStatus = 2;
                }
                else if (RB_phy_DMater.Checked)
                {
                    sbytePhysicalStatus = 3;
                }
                else
                {
                    sbytePhysicalStatus = 0;
                }

                //-------------------------------------------------------------------------------------------------------------

                // Loading Values From LB

                string strMaritalStatusList = "";
                string Flag = "";
                // Marital Status
                foreach (ListItem objListItem in LB_MaritalStatus.Items)
                {
                    if (objListItem.Selected)
                    {
                        strMaritalStatusList += Flag + objListItem.Value;
                        Flag = "%";
                    }
                }
                //-------------------------------------------------------------------------------------------------------------
                // Complexion
                string strComplexionList = "";

                Flag = "";

                foreach (ListItem objListItem in LB_Complexion.Items)
                {
                    if (objListItem.Selected)
                    {
                        strComplexionList += Flag + objListItem.Value;
                        Flag = "%";
                    }
                }
                //-------------------------------------------------------------------------------------------------------------
                // Mother Tongue
                string strMotherTongueList = "";

                Flag = "";

                foreach (ListItem objListItem in LB_MotherTongue.Items)
                {
                    if (objListItem.Selected)
                    {
                        strMotherTongueList += Flag + objListItem.Value;
                        Flag = "%";
                    }
                }
                //-------------------------------------------------------------------------------------------------------------
                // Religion
                string strReligionList = "";
                if (CB_Religion_Any.Checked)
                {
                    strReligionList = "##";
                }
                else
                {
                    Flag = "";

                    foreach (ListItem objListItem in LB_Religion.Items)
                    {
                        if (objListItem.Selected)
                        {
                            strReligionList += Flag + objListItem.Value;
                            Flag             = "%";
                        }
                    }
                }
                //-------------------------------------------------------------------------------------------------------------
                //Caste
                string strCasteList = "";
                if (CB_Caste_Any.Checked)
                {
                    strCasteList = "##";
                }
                else
                {
                    Flag = "";

                    foreach (ListItem objListItem in LB_Caste.Items)
                    {
                        if (objListItem.Selected)
                        {
                            strCasteList += Flag + objListItem.Value;
                            Flag          = "%";
                        }
                    }
                }
                //-------------------------------------------------------------------------------------------------------------
                // Education
                string strEducationList = "";
                if (CB_Education_Any.Checked)
                {
                    strEducationList = "##";
                }
                else
                {
                    Flag = "";

                    foreach (ListItem objListItem in LB_Education.Items)
                    {
                        if (objListItem.Selected)
                        {
                            strEducationList += Flag + objListItem.Value;
                            Flag              = "%";
                        }
                    }
                }
                //-------------------------------------------------------------------------------------------------------------
                // EduDetails
                string strEduDetailsList = "";
                if (CB_EduDet.Checked)
                {
                    strEduDetailsList = "##";
                }
                else
                {
                    Flag = "";

                    foreach (ListItem objListItem in LB_Edudetails.Items)
                    {
                        if (objListItem.Selected)
                        {
                            strEduDetailsList += Flag + objListItem.Value;
                            Flag = "%";
                        }
                    }
                }
                //-------------------------------------------------------------------------------------------------------------
                // Occupation
                string strOccupationList = "";
                if (CB_Occupation_any.Checked)
                {
                    strOccupationList = "##";
                }
                else
                {
                    Flag = "";

                    foreach (ListItem objListItem in LB_Occupation.Items)
                    {
                        if (objListItem.Selected)
                        {
                            strOccupationList += Flag + objListItem.Value;
                            Flag = "%";
                        }
                    }
                }
                //-------------------------------------------------------------------------------------------------------------
                // Citizenship
                string strCitizenshipList = "";
                if (CB_IndianX.Checked)
                {
                    strCitizenshipList = "##";
                }
                else
                {
                    Flag = "";

                    foreach (ListItem objListItem in LB_Citizenship.Items)
                    {
                        if (objListItem.Selected)
                        {
                            strCitizenshipList += Flag + objListItem.Value;
                            Flag = "%";
                        }
                    }
                }
                //-------------------------------------------------------------------------------------------------------------
                // Country Living in
                string strCountryLivinginList = "";
                if (CB_Indian.Checked)
                {
                    strCountryLivinginList = "##";
                }
                else
                {
                    Flag = "";

                    foreach (ListItem objListItem in LB_Citizenship.Items)
                    {
                        if (objListItem.Selected)
                        {
                            strCountryLivinginList += Flag + objListItem.Value;
                            Flag = "%";
                        }
                    }
                }
                //-------------------------------------------------------------------------------------------------------------
                // Country Living in
                string strStateList = "";
                if (!CB_StatesInIndia.Checked)
                {
                    strStateList = TB_NonIndianState.Text + "#";
                }
                else
                {
                    Flag = "";

                    foreach (ListItem objListItem in LB_Rasident_State.Items)
                    {
                        if (objListItem.Selected)
                        {
                            strStateList += Flag + objListItem.Value;
                            Flag          = "%";
                        }
                    }
                }
                //-------------------------------------------------------------------------------------------------------------
                //Residential Status
                string strResidentStatus = "";
                Flag = "";
                foreach (ListItem objListItem in LB_Rasident_Status.Items)
                {
                    if (objListItem.Selected)
                    {
                        strResidentStatus += Flag + objListItem.Value;
                        Flag = "%";
                    }
                }
                //--------------------------------------------------------------------------------------------------------------
                sbyteFlag = MatrimonialProfileManager.InsertMyExpectation(strApplicationID, TB_Expectations.Text);
                //--------------------------------------------------------------------------------------------------------------
                sbyteFlag += MatrimonialProfileManager.InsertPartnerPreferance(strApplicationID, strMaritalStatusList, sbyte.Parse(TB_Age_min.Text),
                                                                               sbyte.Parse(TB_Age_Max.Text), strComplexionList, sbyteChildrenStatus, (DDL_Height_min.SelectedIndex + 89), (DDL_Height_Max.SelectedIndex + 89),
                                                                               sbytePhysicalStatus, strMotherTongueList, strReligionList, strCasteList, DDL_ChDosham.SelectedIndex, DDL_EathingHabits.SelectedIndex,
                                                                               strEducationList, strEduDetailsList, LB_AnnulIncome.SelectedIndex, strOccupationList, strCitizenshipList, strCountryLivinginList,
                                                                               strStateList, strResidentStatus);
                //--------------------------------------------------------------------------------------------------------------

                if (sbyteFlag == 2)
                {
                    MatrimonialMemberShip.UpdateIndex(strApplicationID);
                    Server.Transfer("RegistrationConfirm.aspx");
                }
                else
                {
                    Server.Transfer("../Extras/ErrorReport.aspx");
                }
            }
            else
            {
            }
        }
    }
Esempio n. 8
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            HttpCookieCollection objHttpCookieCollection = Request.Cookies;
            HttpCookie           objHttpCookie           = objHttpCookieCollection.Get("MatRegInfo");

            //Getting ApplicationID Value

            // <Meta tag>

            // Adding meta Discription
            HtmlMeta objMeta = new HtmlMeta();
            objMeta.Name    = "Description";
            objMeta.Content = WebConfig.GetValues("MetaDiscription");
            this.Header.Controls.Add(objMeta);

            // Adding meta KeyWords
            objMeta         = new HtmlMeta();
            objMeta.Name    = "keywords";
            objMeta.Content = WebConfig.GetValues("MetaKeword");
            this.Header.Controls.Add(objMeta);


            //Loading DDL

            //Getting Connection String

            //Connect To database

            DDL_Education.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Education);
            DDL_Education.DataTextField  = "Item";
            DDL_Education.DataValueField = "Value";
            DDL_Education.DataBind();

            DDL_EduDetails.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.EduDetails);
            DDL_EduDetails.DataTextField  = "Item";
            DDL_EduDetails.DataValueField = "Value";
            DDL_EduDetails.DataBind();

            DDL_AnnualIncome.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.AnnualIncomeRange);
            DDL_AnnualIncome.DataTextField  = "Item";
            DDL_AnnualIncome.DataValueField = "Value";
            DDL_AnnualIncome.DataBind();

            DDL_Currency.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Currency);
            DDL_Currency.DataTextField  = "Item";
            DDL_Currency.DataValueField = "Value";
            DDL_Currency.DataBind();

            DDL_Occupation.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Occupation);
            DDL_Occupation.DataTextField  = "Item";
            DDL_Occupation.DataValueField = "Value";
            DDL_Occupation.DataBind();

            DDL_EmpIn.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.EmployedIn);
            DDL_EmpIn.DataTextField  = "Item";
            DDL_EmpIn.DataValueField = "Value";
            DDL_EmpIn.DataBind();

            DDL_BGroup.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.BloodGroup);
            DDL_BGroup.DataTextField  = "Item";
            DDL_BGroup.DataValueField = "Value";
            DDL_BGroup.DataBind();

            DDL_Complexion.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Complexion);
            DDL_Complexion.DataTextField  = "Item";
            DDL_Complexion.DataValueField = "Value";
            DDL_Complexion.DataBind();

            DDL_Diet.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Diet);
            DDL_Diet.DataTextField  = "Item";
            DDL_Diet.DataValueField = "Value";
            DDL_Diet.DataBind();

            DDL_Country.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Country);
            DDL_Country.DataTextField  = "Item";
            DDL_Country.DataValueField = "Value";
            DDL_Country.DataBind();

            DDL_ResidenceIn.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Country);
            DDL_ResidenceIn.DataTextField  = "Item";
            DDL_ResidenceIn.DataValueField = "Value";
            DDL_ResidenceIn.DataBind();

            DDL_State.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.State);
            DDL_State.DataTextField  = "Item";
            DDL_State.DataValueField = "Value";
            DDL_State.DataBind();

            DDL_ResidentialStatus.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.ResidenceStatus);
            DDL_ResidentialStatus.DataTextField  = "Item";
            DDL_ResidentialStatus.DataValueField = "Value";
            DDL_ResidentialStatus.DataBind();

            short shortCounter;
            DDL_Weight.Items.Insert(0, "-- Select --");
            for (shortCounter = 40; shortCounter <= 140; ++shortCounter)
            {
                DDL_Weight.Items.Insert(shortCounter - 39, shortCounter + " KG");
            }

            DDL_Height.Items.Insert(0, "-- Select --");
            for (shortCounter = 90; shortCounter <= 185; ++shortCounter)
            {
                DDL_Height.Items.Insert(shortCounter - 89, shortCounter + " CM");
            }
        }
        else
        {
            sbyte  sbyteFlag = 0;
            string strApplicationID;
            //try
            //{
            HttpCookieCollection objHttpCookieCollection = Request.Cookies;
            HttpCookie           objHttpCookie           = objHttpCookieCollection.Get("MatRegInfo");

            strApplicationID = Crypto.DeCrypto(objHttpCookie.Values[0]);

            if (strApplicationID != null)
            {
                //Inserting  Education and Occupation
                sbyteFlag = MatrimonialProfileManager.InsertEducationalInfo(strApplicationID, (sbyte)DDL_Education.SelectedIndex,
                                                                            (sbyte)DDL_EduDetails.SelectedIndex, (sbyte)DDL_AnnualIncome.SelectedIndex,
                                                                            (short)DDL_Currency.SelectedIndex, (sbyte)DDL_Occupation.SelectedIndex,
                                                                            (sbyte)DDL_EmpIn.SelectedIndex);


                // setting Physical Attributes

                sbyte sbyteBodyType = 0;
                sbyte sbyteSmoke    = 0;
                sbyte sbyteDrink    = 0;

                if (RB_BType_Slim.Checked)
                {
                    sbyteBodyType = 1;
                }
                else if (RB_BType_Avg.Checked)
                {
                    sbyteBodyType = 2;
                }
                else if (RB_BType_Ath.Checked)
                {
                    sbyteBodyType = 3;
                }
                else if (RB_BType_Heavy.Checked)
                {
                    sbyteBodyType = 4;
                }

                if (RB_Smoke_no.Checked)
                {
                    sbyteSmoke = 1;
                }
                else if (RB_Smoke_Yes.Checked)
                {
                    sbyteSmoke = 2;
                }
                else if (RB_Smoke_Occ.Checked)
                {
                    sbyteSmoke = 3;
                }

                if (RB_Drink_No.Checked)
                {
                    sbyteDrink = 1;
                }
                else if (RB_Drink_Yes.Checked)
                {
                    sbyteDrink = 2;
                }
                else if (RB_Drink_Occ.Checked)
                {
                    sbyteDrink = 3;
                }


                //Inserting Physical Attributes
                sbyteFlag += MatrimonialProfileManager.InsertPhysicalInfo(strApplicationID, (short)(DDL_Height.SelectedIndex + 89),
                                                                          (short)DDL_Weight.SelectedIndex, (sbyte)DDL_BGroup.SelectedIndex, sbyteBodyType,
                                                                          (sbyte)DDL_Diet.SelectedIndex, sbyteSmoke, sbyteDrink, (sbyte)DDL_Complexion.SelectedIndex);



                //Setting Contact Details
                sbyteFlag += MatrimonialProfileManager.InsertContactInfo(strApplicationID, TB_Address.Text, (short)DDL_Country.SelectedIndex,
                                                                         (sbyte)DDL_State.SelectedIndex, TB_City.Text, TB_Phone_NO.Text, TB_Phone_STD.Text, TB_Phone_ISD.Text,
                                                                         TB_Phone_Mobile.Text, (short)DDL_ResidenceIn.SelectedIndex, (sbyte)DDL_ResidentialStatus.SelectedIndex,
                                                                         TB_RCity.Text);
            }

            if (sbyteFlag == 3)
            {
                MatrimonialMemberShip.UpdateIndex(strApplicationID);
                Server.Transfer("RegistrationStep3.aspx");
            }
            else
            {
                Response.Redirect("../Extras/ErrorReport.aspx");
            }


            //}
            //catch (Exception)
            //{
            //    Response.Redirect("../Extras/ErrorReport.aspx?id=Cookie");
            //}
        }
    }
    private void LoadStep3()
    {
        txtCount.Text = TB_AboutME.MaxLength.ToString();

        TB_AboutME.Attributes.Add("onKeyUp",
                                  "javascript:document.getElementById('" + txtCount.ClientID +
                                  "').setAttribute('value', (" + TB_AboutME.MaxLength +
                                  " - parseInt(document.getElementById('" + TB_AboutME.ClientID +
                                  "').getAttribute('value').length)));");



        DDL_FamilyStatus.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.FamilyStatus);
        DDL_FamilyStatus.DataTextField  = "Item";
        DDL_FamilyStatus.DataValueField = "Value";
        DDL_FamilyStatus.DataBind();

        DDL_FamilyType.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Familytype);
        DDL_FamilyType.DataTextField  = "Item";
        DDL_FamilyType.DataValueField = "Value";
        DDL_FamilyType.DataBind();

        DDL_FamilyValues.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.FamilyValue);
        DDL_FamilyValues.DataTextField  = "Item";
        DDL_FamilyValues.DataValueField = "Value";
        DDL_FamilyValues.DataBind();

        LB_Hobbies.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Hobbies);
        LB_Hobbies.DataTextField  = "Item";
        LB_Hobbies.DataValueField = "Value";
        LB_Hobbies.DataBind();
        LB_Hobbies.Items.RemoveAt(0);

        LB_Interests.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Interests);
        LB_Interests.DataTextField  = "Item";
        LB_Interests.DataValueField = "Value";
        LB_Interests.DataBind();
        LB_Interests.Items.RemoveAt(0);


        //Loading Member Informations
        string    strApplicationID = MatrimonialMemberShip.GetApplicationID(HF_MatID.Value);
        MatMember objMember        = new MatMember(true, strApplicationID, false, false, false, false, false, false, true, true, true, false);

        TB_AboutME.Text       = objMember.AboutMe;
        TB_FamilyDetails.Text = objMember.FamilyDetails;
        TB_familyOrigin.Text  = objMember.FamilyOrigin;
        TB_Father_Occ.Text    = objMember.FatherOccupation;
        TB_Mother_Occ.Text    = objMember.MotherOccupation;

        L_FatherName.Text  = objMember.FathersName;
        L_MotherName.Text  = objMember.MothersName;
        L_NoOfBrother.Text = objMember.NoOfBrothers.ToString();

        DDL_FamilyStatus.SelectedIndex = objMember.FamilyStatus;
        DDL_FamilyType.SelectedIndex   = objMember.FamilyType;
        DDL_FamilyValues.SelectedIndex = objMember.FamilyValues;

        if (objMember.FatherAlive)
        {
            RB_Father_Alive.Checked = true;
        }
        else
        {
            RB_Father_NAlive.Checked = true;
        }

        if (objMember.MotherAlive)
        {
            RB_Mother_Alive.Checked = true;
        }
        else
        {
            RB_Mother_NAlive.Checked = true;
        }

        if (objMember.NoOfBrothers != 6)
        {
            if (objMember.NoOfBrothers == objMember.BrothersMarried)
            {
                L_BMarried.Visible = true;
                L_BMarried.Text    = objMember.NoOfBrothers.ToString();
                L_NoOfBrother.Text = objMember.NoOfBrothers.ToString();
                DDL_NoOfBrothersMarried.Visible = false;
            }
            else
            {
                L_NoOfBrother.Text = objMember.NoOfBrothers.ToString();
                DDL_NoOfBrothersMarried.SelectedIndex = objMember.BrothersMarried;
            }
        }
        else
        {
            L_NoOfBrother.Text = "Nill";
            L_BMarried.Visible = true;
            DDL_NoOfBrothersMarried.Visible = false;
            L_BMarried.Text = "Not Applicable";
        }



        if (objMember.NoOfSisters != 6)
        {
            if (objMember.NoOfSisters == objMember.SistersMarried)
            {
                L_SMarried.Visible             = true;
                L_SMarried.Text                = objMember.NoOfSisters.ToString();
                L_NoOfSister.Text              = objMember.NoOfSisters.ToString();
                DDL_NoOFSistersMarried.Visible = false;
            }
            else
            {
                L_NoOfSister.Text = objMember.NoOfSisters.ToString();
                DDL_NoOFSistersMarried.SelectedIndex = objMember.SistersMarried;
            }
        }
        else
        {
            L_NoOfSister.Text              = "Nill";
            L_SMarried.Visible             = true;
            DDL_NoOFSistersMarried.Visible = false;
            L_SMarried.Text = "Not Applicable";
        }
        //---------------------------------------------------------------------------------------------------
        string[] strAHobbies = objMember.HobbiesList.Split('%');
        int      i;

        if (strAHobbies[0].Length != 0)
        {
            foreach (string index in strAHobbies)
            {
                i = int.Parse(index);
                LB_Hobbies.Items[i - 1].Selected = true;
            }
        }
        //---------------------------------------------------------------------------------------------------
        string[] strAIntrests = objMember.IntrestList.Split('%');
        if (strAIntrests[0].Length != 0)
        {
            foreach (string index in strAIntrests)
            {
                i = int.Parse(index);
                LB_Interests.Items[i - 1].Selected = true;
            }
        }
        //---------------------------------------------------------------------------------------------------
        TB_OtherHobbies.Text   = objMember.OtherHobbies;
        TB_OtherInterests.Text = objMember.OtherIntrests;
        //---------------------------------------------------------------------------------------------------


        objMember = null;
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            //---------------------------------------------------------------------------------------------------
            // Adding meta Discription
            HtmlMeta objMeta = new HtmlMeta();
            objMeta.Name    = "Description";
            objMeta.Content = WebConfig.GetValues("MetaDiscription");
            this.Header.Controls.Add(objMeta);
            // Adding meta KeyWords
            objMeta         = new HtmlMeta();
            objMeta.Name    = "keywords";
            objMeta.Content = WebConfig.GetValues("MetaKeword");
            this.Header.Controls.Add(objMeta);
            //---------------------------------------------------------------------------------------------------
            txtCount.Text = TB_Expectations.MaxLength.ToString();
            /// Text Counter Initiallisation
            TB_Expectations.Attributes.Add("onKeyUp",
                                           "javascript:document.getElementById('" + txtCount.ClientID +
                                           "').setAttribute('value', (" + TB_Expectations.MaxLength +
                                           " - parseInt(document.getElementById('" + TB_Expectations.ClientID +
                                           "').getAttribute('value').length)));");
            //---------------------------------------------------------------------------------------------------
            //load ddls
            //Getting Connection String
            LB_MaritalStatus.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.MaritalStatus);
            LB_MaritalStatus.DataTextField  = "Item";
            LB_MaritalStatus.DataValueField = "Value";
            LB_MaritalStatus.DataBind();
            LB_MaritalStatus.Items.RemoveAt(0);
            //---------------------------------------------------------------------------------------------------
            LB_Complexion.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Complexion);
            LB_Complexion.DataTextField  = "Item";
            LB_Complexion.DataValueField = "Value";
            LB_Complexion.DataBind();
            LB_Complexion.Items.RemoveAt(0);
            //---------------------------------------------------------------------------------------------------
            LB_MotherTongue.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.MotherTongue);
            LB_MotherTongue.DataTextField  = "Item";
            LB_MotherTongue.DataValueField = "Value";
            LB_MotherTongue.DataBind();
            LB_MotherTongue.Items.RemoveAt(0);
            //---------------------------------------------------------------------------------------------------
            LB_Religion.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Religion);
            LB_Religion.DataTextField  = "Item";
            LB_Religion.DataValueField = "Value";
            LB_Religion.DataBind();
            LB_Religion.Items.RemoveAt(0);
            //---------------------------------------------------------------------------------------------------
            LB_Caste.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Cast);
            LB_Caste.DataTextField  = "Item";
            LB_Caste.DataValueField = "Value";
            LB_Caste.DataBind();
            LB_Caste.Items.RemoveAt(0);
            //---------------------------------------------------------------------------------------------------
            LB_Education.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Education);
            LB_Education.DataTextField  = "Item";
            LB_Education.DataValueField = "Value";
            LB_Education.DataBind();
            LB_Education.Items.RemoveAt(0);
            //---------------------------------------------------------------------------------------------------
            LB_Edudetails.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.EduDetails);;
            LB_Edudetails.DataTextField  = "Item";
            LB_Edudetails.DataValueField = "Value";
            LB_Edudetails.DataBind();
            LB_Edudetails.Items.RemoveAt(0);
            //---------------------------------------------------------------------------------------------------
            LB_AnnulIncome.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.AnnualIncomeRange);
            LB_AnnulIncome.DataTextField  = "Item";
            LB_AnnulIncome.DataValueField = "Value";
            LB_AnnulIncome.DataBind();
            LB_AnnulIncome.Items.RemoveAt(0);
            //---------------------------------------------------------------------------------------------------
            LB_Occupation.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Occupation);
            LB_Occupation.DataTextField  = "Item";
            LB_Occupation.DataValueField = "Value";
            LB_Occupation.DataBind();
            LB_Occupation.Items.RemoveAt(0);
            //---------------------------------------------------------------------------------------------------
            LB_Citizenship.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Country);
            LB_Citizenship.DataTextField  = "Item";
            LB_Citizenship.DataValueField = "Value";
            LB_Citizenship.DataBind();
            LB_Citizenship.Items.RemoveAt(0);
            //---------------------------------------------------------------------------------------------------
            LB_CountryLiving.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Country);
            LB_CountryLiving.DataTextField  = "Item";
            LB_CountryLiving.DataValueField = "Value";
            LB_CountryLiving.DataBind();
            LB_CountryLiving.Items.RemoveAt(0);
            //---------------------------------------------------------------------------------------------------
            LB_Rasident_State.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.State);
            LB_Rasident_State.DataTextField  = "Item";
            LB_Rasident_State.DataValueField = "Value";
            LB_Rasident_State.DataBind();
            LB_Rasident_State.Items.RemoveAt(0);
            LB_Rasident_State.Items.Insert(0, "Any");
            //---------------------------------------------------------------------------------------------------
            LB_Rasident_Status.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.ResidenceStatus);
            LB_Rasident_Status.DataTextField  = "Item";
            LB_Rasident_Status.DataValueField = "Value";
            LB_Rasident_Status.DataBind();
            LB_Rasident_Status.Items.RemoveAt(0);
            LB_Rasident_Status.Items.Insert(0, "Any");
            //---------------------------------------------------------------------------------------------------
            DDL_ChDosham.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.HoroManglic);
            DDL_ChDosham.DataTextField  = "Item";
            DDL_ChDosham.DataValueField = "Value";
            DDL_ChDosham.DataBind();
            DDL_ChDosham.Items.RemoveAt(5);
            //---------------------------------------------------------------------------------------------------
            DDL_EathingHabits.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Diet);
            DDL_EathingHabits.DataTextField  = "Item";
            DDL_EathingHabits.DataValueField = "Value";
            DDL_EathingHabits.DataBind();
            //---------------------------------------------------------------------------------------------------
            Int16 Int16Counter;
            DDL_Height_min.Items.Insert(0, "-- Select --");
            DDL_Height_Max.Items.Insert(0, "-- Select --");
            for (Int16Counter = 90; Int16Counter <= 185; ++Int16Counter)
            {
                DDL_Height_min.Items.Insert(Int16Counter - 89, Int16Counter + " CM");
                DDL_Height_Max.Items.Insert(Int16Counter - 89, Int16Counter + 1 + " CM");
            }

            //---------------------------------------------------------------------------------------------------
            //Loading Member Informations
            HttpCookieCollection objHttpCookieCollection = Request.Cookies;
            HttpCookie           objHttpCookie           = objHttpCookieCollection.Get("MatCookie5639sb");
            //---------------------------------------------------------------------------------------------------
            string strApplicationID = Crypto.DeCrypto(objHttpCookie.Values["ApplicationID"]);
            //---------------------------------------------------------------------------------------------------
            MatMember objMember = new MatMember(true, strApplicationID, false, false, false, false, false, false, false, false, false, true);
            //---------------------------------------------------------------------------------------------------
            int i;
            //---------------------------------------------------------------------------------------------------
            string[] strARRAY = objMember.PP_LookingFor.Split('%');
            if (strARRAY[0].Length != 0)
            {
                foreach (string index in strARRAY)
                {
                    i = int.Parse(index);
                    LB_MaritalStatus.Items[i - 1].Selected = true;
                }
            }
            //---------------------------------------------------------------------------------------------------
            TB_Age_min.Text = objMember.PP_AgeMin.ToString();
            TB_Age_Max.Text = objMember.PP_AgeMax.ToString();
            //---------------------------------------------------------------------------------------------------
            strARRAY = objMember.PP_Complexion.Split('%');
            if (strARRAY[0].Length != 0)
            {
                foreach (string index in strARRAY)
                {
                    i = int.Parse(index);
                    LB_Complexion.Items[i - 1].Selected = true;
                }
            }
            //---------------------------------------------------------------------------------------------------
            switch (objMember.PP_HaveChildren)
            {
            case 1: RB_ChildrenDM.Checked = true;
                break;

            case 2: RB_ChildrenNO.Checked = true;
                break;

            case 3: RB_ChildrenYesLT.Checked = true;
                break;

            case 4: RB_ChildrenYesNLT.Checked = true;
                break;
            }
            //---------------------------------------------------------------------------------------------------
            DDL_Height_min.SelectedIndex = objMember.PP_HeightMin;
            DDL_Height_Max.SelectedIndex = objMember.PP_HeightMax;
            //---------------------------------------------------------------------------------------------------
            switch (objMember.PP_PhysicalStatus)
            {
            case 1: RB_phy_nor.Checked = true;
                break;

            case 2: RB_phy_Dis.Checked = true;
                break;

            case 3: RB_phy_DMater.Checked = true;
                break;
            }
            //---------------------------------------------------------------------------------------------------
            strARRAY = objMember.PP_MotherTongue.Split('%');

            if (strARRAY[0].Length != 0)
            {
                foreach (string index in strARRAY)
                {
                    i = int.Parse(index);
                    LB_MotherTongue.Items[i - 1].Selected = true;
                }
            }
            //---------------------------------------------------------------------------------------------------
            TB_Expectations.Text = objMember.MyExpectations;
            //---------------------------------------------------------------------------------------------------
            if (objMember.PP_Religion.IndexOf("##") >= 0)
            {
                CB_Religion_Any.Checked = true;
            }
            else
            {
                CB_Caste_Any.Checked = false;
                strARRAY             = objMember.PP_Religion.Split('%');
                if (strARRAY[0].Length != 0)
                {
                    foreach (string index in strARRAY)
                    {
                        i = int.Parse(index);
                        LB_Religion.Items[i - 1].Selected = true;
                    }
                    CB_Religion_Any.Checked = false;
                }
                else
                {
                    CB_Religion_Any.Checked = true;
                }
            }
            //---------------------------------------------------------------------------------------------------
            if (objMember.PP_Caste.IndexOf("##") >= 0)
            {
                CB_Caste_Any.Checked = true;
            }
            else
            {
                strARRAY = objMember.PP_Caste.Split('%');
                if (strARRAY[0].Length != 0)
                {
                    foreach (string index in strARRAY)
                    {
                        i = int.Parse(index);
                        LB_Caste.Items[i - 1].Selected = true;
                    }
                    CB_Caste_Any.Checked = false;
                }
                else
                {
                    CB_Caste_Any.Checked = true;
                }
            }
            //---------------------------------------------------------------------------------------------------
            DDL_ChDosham.SelectedIndex      = objMember.PP_Manglik;
            DDL_EathingHabits.SelectedIndex = objMember.Diet;
            //---------------------------------------------------------------------------------------------------
            if (objMember.PP_Education.IndexOf("##") >= 0)
            {
                CB_Education_Any.Checked = true;
            }
            else
            {
                strARRAY = objMember.PP_Education.Split('%');
                if (strARRAY[0].Length != 0)
                {
                    foreach (string index in strARRAY)
                    {
                        i = int.Parse(index);
                        LB_Education.Items[i - 1].Selected = true;
                    }
                    CB_Education_Any.Checked = false;
                }
                else
                {
                    CB_Education_Any.Checked = true;
                }
            }
            //---------------------------------------------------------------------------------------------------
            if (objMember.PP_EducationDetails.IndexOf("##") >= 0)
            {
                CB_EduDet.Checked = true;
            }
            else
            {
                strARRAY = objMember.PP_EducationDetails.Split('%');
                if (strARRAY[0].Length != 0)
                {
                    foreach (string index in strARRAY)
                    {
                        i = int.Parse(index);
                        LB_Edudetails.Items[i - 1].Selected = true;
                    }
                    CB_EduDet.Checked = false;
                }
                else
                {
                    CB_EduDet.Checked = true;
                }
            }
            //---------------------------------------------------------------------------------------------------
            LB_AnnulIncome.SelectedIndex = objMember.PP_AnnualIncome;
            //---------------------------------------------------------------------------------------------------
            if (objMember.PP_Occupation.IndexOf("##") >= 0)
            {
                CB_Occupation_any.Checked = true;
            }
            else
            {
                strARRAY = objMember.PP_Occupation.Split('%');
                if (strARRAY[0].Length != 0)
                {
                    foreach (string index in strARRAY)
                    {
                        i = int.Parse(index);
                        LB_Occupation.Items[i - 1].Selected = true;
                    }
                    CB_Occupation_any.Checked = false;
                }
                else
                {
                    CB_Occupation_any.Checked = true;
                }
            }
            //---------------------------------------------------------------------------------------------------
            if (objMember.PP_Citizenship.IndexOf("##") >= 0)
            {
                CB_IndianX.Checked = true;
            }
            else
            {
                strARRAY = objMember.PP_Citizenship.Split('%');
                if (strARRAY[0].Length != 0)
                {
                    foreach (string index in strARRAY)
                    {
                        i = int.Parse(index);
                        LB_Citizenship.Items[i - 1].Selected = true;
                    }
                    CB_IndianX.Checked = false;
                }
                else
                {
                    CB_IndianX.Checked = true;
                }
            }
            //---------------------------------------------------------------------------------------------------
            if (objMember.PP_LivingIn.IndexOf("##") >= 0)
            {
                CB_Indian.Checked = true;
            }
            else
            {
                strARRAY = objMember.PP_LivingIn.Split('%');
                if (strARRAY[0].Length != 0)
                {
                    foreach (string index in strARRAY)
                    {
                        i = int.Parse(index);
                        LB_CountryLiving.Items[i - 1].Selected = true;
                    }
                    CB_Indian.Checked = false;
                }
                else
                {
                    CB_Indian.Checked = true;
                }
            }
            //---------------------------------------------------------------------------------------------------
            if (objMember.PP_ResidingState.IndexOf("##") >= 0)
            {
                CB_StatesInIndia.Checked = false;
                TB_NonIndianState.Text   = objMember.PP_ResidingState.Replace("##", "");
            }
            else
            {
                if (objMember.PP_ResidingState.ToLower().IndexOf("any") >= 0)
                {
                    LB_Rasident_State.Items[0].Selected = true;
                    CB_StatesInIndia.Checked            = true;
                }
                else
                {
                    strARRAY = objMember.PP_ResidingState.Split('%');
                    if (strARRAY[0].Length != 0)
                    {
                        foreach (string index in strARRAY)
                        {
                            i = int.Parse(index);
                            LB_Rasident_State.Items[i - 1].Selected = true;
                        }
                        CB_StatesInIndia.Checked = true;
                    }
                    else
                    {
                        CB_StatesInIndia.Checked = false;
                    }
                }
            }
            //---------------------------------------------------------------------------------------------------
            if (objMember.PP_ResStatus.ToLower().IndexOf("any") >= 0)
            {
                LB_Rasident_Status.Items[0].Selected = true;
            }
            else
            {
                strARRAY = objMember.PP_ResStatus.Split('%');
                if (strARRAY[0].Length != 0)
                {
                    foreach (string index in strARRAY)
                    {
                        i = int.Parse(index);
                        LB_Rasident_Status.Items[i - 1].Selected = true;
                    }
                }
            }

            ////---------------------------------------------------------------------------------------------------
        }//if
        ////---------------------------------------------------------------------------------------------------
        else            // PostBack
        ////---------------------------------------------------------------------------------------------------
        {
            HttpCookieCollection objHttpCookieCollection = Request.Cookies;
            HttpCookie           objHttpCookie           = objHttpCookieCollection.Get("MatCookie5639sb");

            string strApplicationID = Crypto.DeCrypto(objHttpCookie.Values["ApplicationID"]);

            // Inserting data into database
            if (strApplicationID != null)
            {
                sbyte sbyteFlag = 0;
                sbyte sbyteChildrenStatus;
                sbyte sbytePhysicalStatus;

                //-------------------------------------------------------------------------------------------------------------
                if (RB_ChildrenNO.Checked)
                {
                    sbyteChildrenStatus = 1;
                }
                else if (RB_ChildrenYesLT.Checked)
                {
                    sbyteChildrenStatus = 2;
                }
                else if (RB_ChildrenYesNLT.Checked)
                {
                    sbyteChildrenStatus = 3;
                }
                else if (RB_ChildrenDM.Checked)
                {
                    sbyteChildrenStatus = 4;
                }
                else
                {
                    sbyteChildrenStatus = 0;
                }

                //-------------------------------------------------------------------------------------------------------------

                if (RB_phy_nor.Checked)
                {
                    sbytePhysicalStatus = 1;
                }
                else if (RB_phy_Dis.Checked)
                {
                    sbytePhysicalStatus = 2;
                }
                else if (RB_phy_DMater.Checked)
                {
                    sbytePhysicalStatus = 3;
                }
                else
                {
                    sbytePhysicalStatus = 0;
                }

                //-------------------------------------------------------------------------------------------------------------

                // Loading Values From LB

                string strMaritalStatusList = "";
                string Flag = "";
                // Marital Status
                foreach (ListItem objListItem in LB_MaritalStatus.Items)
                {
                    if (objListItem.Selected)
                    {
                        strMaritalStatusList += Flag + objListItem.Value;
                        Flag = "%";
                    }
                }
                //-------------------------------------------------------------------------------------------------------------
                // Complexion
                string strComplexionList = "";

                Flag = "";

                foreach (ListItem objListItem in LB_Complexion.Items)
                {
                    if (objListItem.Selected)
                    {
                        strComplexionList += Flag + objListItem.Value;
                        Flag = "%";
                    }
                }
                //-------------------------------------------------------------------------------------------------------------
                // Mother Tongue
                string strMotherTongueList = "";

                Flag = "";

                foreach (ListItem objListItem in LB_MotherTongue.Items)
                {
                    if (objListItem.Selected)
                    {
                        strMotherTongueList += Flag + objListItem.Value;
                        Flag = "%";
                    }
                }
                //-------------------------------------------------------------------------------------------------------------
                // Religion
                string strReligionList = "";
                if (CB_Religion_Any.Checked)
                {
                    strReligionList = "##";
                }
                else
                {
                    Flag = "";

                    foreach (ListItem objListItem in LB_Religion.Items)
                    {
                        if (objListItem.Selected)
                        {
                            strReligionList += Flag + objListItem.Value;
                            Flag             = "%";
                        }
                    }
                }
                //-------------------------------------------------------------------------------------------------------------
                //Caste
                string strCasteList = "";
                if (CB_Caste_Any.Checked)
                {
                    strCasteList = "##";
                }
                else
                {
                    Flag = "";

                    foreach (ListItem objListItem in LB_Caste.Items)
                    {
                        if (objListItem.Selected)
                        {
                            strCasteList += Flag + objListItem.Value;
                            Flag          = "%";
                        }
                    }
                }
                //-------------------------------------------------------------------------------------------------------------
                // Education
                string strEducationList = "";
                if (CB_Education_Any.Checked)
                {
                    strEducationList = "##";
                }
                else
                {
                    Flag = "";

                    foreach (ListItem objListItem in LB_Education.Items)
                    {
                        if (objListItem.Selected)
                        {
                            strEducationList += Flag + objListItem.Value;
                            Flag              = "%";
                        }
                    }
                }
                //-------------------------------------------------------------------------------------------------------------
                // EduDetails
                string strEduDetailsList = "";
                if (CB_EduDet.Checked)
                {
                    strEduDetailsList = "##";
                }
                else
                {
                    Flag = "";

                    foreach (ListItem objListItem in LB_Edudetails.Items)
                    {
                        if (objListItem.Selected)
                        {
                            strEduDetailsList += Flag + objListItem.Value;
                            Flag = "%";
                        }
                    }
                }
                //-------------------------------------------------------------------------------------------------------------
                // Occupation
                string strOccupationList = "";
                if (CB_Occupation_any.Checked)
                {
                    strOccupationList = "##";
                }
                else
                {
                    Flag = "";

                    foreach (ListItem objListItem in LB_Occupation.Items)
                    {
                        if (objListItem.Selected)
                        {
                            strOccupationList += Flag + objListItem.Value;
                            Flag = "%";
                        }
                    }
                }
                //-------------------------------------------------------------------------------------------------------------
                // Citizenship
                string strCitizenshipList = "";
                if (CB_IndianX.Checked)
                {
                    strCitizenshipList = "##";
                }
                else
                {
                    Flag = "";

                    foreach (ListItem objListItem in LB_Citizenship.Items)
                    {
                        if (objListItem.Selected)
                        {
                            strCitizenshipList += Flag + objListItem.Value;
                            Flag = "%";
                        }
                    }
                }
                //-------------------------------------------------------------------------------------------------------------
                // Country Living in
                string strCountryLivinginList = "";
                if (CB_Indian.Checked)
                {
                    strCountryLivinginList = "##";
                }
                else
                {
                    Flag = "";

                    foreach (ListItem objListItem in LB_Citizenship.Items)
                    {
                        if (objListItem.Selected)
                        {
                            strCountryLivinginList += Flag + objListItem.Value;
                            Flag = "%";
                        }
                    }
                }
                //-------------------------------------------------------------------------------------------------------------
                // Country Living in
                string strStateList = "";
                if (!CB_StatesInIndia.Checked)
                {
                    strStateList = TB_NonIndianState.Text + "##";
                }
                else
                {
                    Flag = "";

                    foreach (ListItem objListItem in LB_Rasident_State.Items)
                    {
                        if (objListItem.Selected)
                        {
                            strStateList += Flag + objListItem.Value;
                            Flag          = "%";
                        }
                    }
                }
                //-------------------------------------------------------------------------------------------------------------
                //Residential Status
                string strResidentStatus = "";
                Flag = "";
                foreach (ListItem objListItem in LB_Rasident_Status.Items)
                {
                    if (objListItem.Selected)
                    {
                        strResidentStatus += Flag + objListItem.Value;
                        Flag = "%";
                    }
                }
                //--------------------------------------------------------------------------------------------------------------
                sbyteFlag = MatrimonialProfileManager.InsertMyExpectation(strApplicationID, TB_Expectations.Text);
                //--------------------------------------------------------------------------------------------------------------
                sbyteFlag += MatrimonialProfileManager.InsertPartnerPreferance(strApplicationID, strMaritalStatusList, sbyte.Parse(TB_Age_min.Text),
                                                                               sbyte.Parse(TB_Age_Max.Text), strComplexionList, sbyteChildrenStatus, (DDL_Height_min.SelectedIndex + 89), (DDL_Height_Max.SelectedIndex + 89),
                                                                               sbytePhysicalStatus, strMotherTongueList, strReligionList, strCasteList, DDL_ChDosham.SelectedIndex, DDL_EathingHabits.SelectedIndex,
                                                                               strEducationList, strEduDetailsList, LB_AnnulIncome.SelectedIndex, strOccupationList, strCitizenshipList, strCountryLivinginList,
                                                                               strStateList, strResidentStatus);
                //--------------------------------------------------------------------------------------------------------------

                if (sbyteFlag == 2)
                {
                    Response.Redirect("MyAlbum.aspx");
                }
                else
                {
                    Server.Transfer("../Extras/ErrorReport.aspx");
                }
            }  //postbak
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            //Setting UserID

            HF_UaerID.Value = Crypto.DeCrypto(Request.QueryString["key"]);

            if (HF_UaerID.Value == null)
            {
                Response.Redirect("../Extras/ErrorReport.aspx?id=WrongKey");
            }


            //Getting Connection String

            //Connect To database

            //load all the DDLs

            //Loading IndexMotherTongue

            DDL_MotherTongue.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.MotherTongue);
            DDL_MotherTongue.DataTextField  = "Item";
            DDL_MotherTongue.DataValueField = "Value";
            DDL_MotherTongue.DataBind();

            // Loading Religion

            DDL_Religion.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Religion);
            DDL_Religion.DataTextField  = "Item";
            DDL_Religion.DataValueField = "Value";
            DDL_Religion.DataBind();


            // Loading Cast
            DDL_Cast.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Cast);
            DDL_Cast.DataTextField  = "Item";
            DDL_Cast.DataValueField = "Value";
            DDL_Cast.DataBind();


            // Loading Profile Created by
            DDL_ProfieCreated.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.ProfileCreatedBy);
            DDL_ProfieCreated.DataTextField  = "Item";
            DDL_ProfieCreated.DataValueField = "Value";
            DDL_ProfieCreated.DataBind();


            // Loading Reference by

            DDL_Reference.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.ReferenceBy);
            DDL_Reference.DataTextField  = "Item";
            DDL_Reference.DataValueField = "Value";
            DDL_Reference.DataBind();


            // Loading Star

            DDL_Star.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Star);
            DDL_Star.DataTextField  = "Item";
            DDL_Star.DataValueField = "Value";
            DDL_Star.DataBind();


            // Loading MoonSign

            DDL_Moon.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.MoonSign);
            DDL_Moon.DataTextField  = "Item";
            DDL_Moon.DataValueField = "Value";
            DDL_Moon.DataBind();

            DDL_SEqt.DataSource     = ControlDataLoader.DataForLoadingControls(ControlDataLoader.ControlType.Sequrity);
            DDL_SEqt.DataTextField  = "SequrityQuestion";
            DDL_SEqt.DataValueField = "Value";
            DDL_SEqt.DataBind();


            int intThisYear = DateTime.Now.Year - 18;
            for (int i = 0; i <= 32; ++i)
            {
                DDL_dobYear.Items.Add((intThisYear - i).ToString());
            }
        }
        else
        {
            if (CB_Accept.Checked)
            {
                //save details into data base

                sbyte sbyteFlag = 0;

                //Inserting AccountInformations
                strApplicationID = MatrimonialMemberShip.InsertAccountInfo(HF_UaerID.Value,
                                                                           FormsAuthentication.HashPasswordForStoringInConfigFile(TB_Password.Text, "MD5"), (sbyte)DDL_SEqt.SelectedIndex, TB_Answer.Text);
                //If Inserted
                Response.Write(strApplicationID);
                if (strApplicationID != null)
                {
                    // Basic member Informations
                    DateTime dtDOB;
                    sbyte    sbyteMaritalStatus = 0;
                    string   strPhysicalStatus;
                    string   strChildrenLivingStatus;


                    // Setting Date of birth
                    dtDOB = DateTime.Parse(DDL_dobMonth.SelectedIndex + " " + DDL_dobYear.SelectedIndex + "," + DDL_dobDay.SelectedIndex);


                    // Setting   MaritalStatus
                    if (RB_MS_UM.Checked)
                    {
                        sbyteMaritalStatus = 1;
                    }
                    else if (RB_MS_Div.Checked)
                    {
                        sbyteMaritalStatus = 2;
                    }
                    else if (RB_MS_Sep.Checked)
                    {
                        sbyteMaritalStatus = 3;
                    }
                    else if (RB_MS_WW.Checked)
                    {
                        sbyteMaritalStatus = 4;
                    }

                    //Setting NoOfChildren

                    if (RB_phy_nor.Checked)
                    {
                        strPhysicalStatus = true.ToString();
                    }
                    else if (RB_phy_Dis.Checked)
                    {
                        strPhysicalStatus = false.ToString();
                    }
                    else
                    {
                        strPhysicalStatus = null;
                    }

                    // setting Children Living With

                    if (RB_CH_LWM.Checked)
                    {
                        strChildrenLivingStatus = true.ToString();
                    }
                    else if (RB_CH_NWM.Checked)
                    {
                        strChildrenLivingStatus = false.ToString();
                    }
                    else
                    {
                        strChildrenLivingStatus = null;
                    }

                    //Inserting Basic Informations
                    sbyteFlag = MatrimonialProfileManager.InsertBasicInfo(strApplicationID,
                                                                          TB_Name.Text, RB_Male.Checked, dtDOB,
                                                                          (sbyte)DDL_MotherTongue.SelectedIndex,
                                                                          (sbyte)DDL_ProfieCreated.SelectedIndex,
                                                                          (sbyte)DDL_Cast.SelectedIndex, sbyteMaritalStatus,
                                                                          (sbyte)DDL_Religion.SelectedIndex,
                                                                          (sbyte)DDL_NoOfChildren.SelectedIndex,
                                                                          strPhysicalStatus, strChildrenLivingStatus,
                                                                          TB_SubCast.Text);

                    // SociaReligious member Informations

                    sbyte  sbyteHoroscopeMatch = 0;
                    string strTimeOfBirth      = null;
                    sbyte  sbyteManglik        = 0;

                    if (RB_Horoscope_NO.Checked)
                    {
                        sbyteHoroscopeMatch = 1;
                    }
                    else if (RB_Horoscope_Yes.Checked)
                    {
                        sbyteHoroscopeMatch = 2;
                    }
                    else if (RB_Horoscope_NoMatters.Checked)
                    {
                        sbyteHoroscopeMatch = 3;
                    }


                    if (RB_Manglik_No.Checked)
                    {
                        sbyteManglik = 1;
                    }
                    else if (RB_Manglik_Yes.Checked)
                    {
                        sbyteManglik = 2;
                    }
                    else if (RB_Manglik_DKnow.Checked)
                    {
                        sbyteManglik = 3;
                    }
                    else if (RB_Manglik_NA.Checked)
                    {
                        sbyteManglik = 4;
                    }

                    if ((TB_Time_H.Text != null) && (TB_Time_M.Text != null))
                    {
                        strTimeOfBirth = TB_Time_H.Text + ":" + TB_Time_M.Text + " " + DDL_Time.SelectedValue;
                    }

                    //Inserting SociaReligious Informations
                    sbyteFlag += MatrimonialProfileManager.InsertSocioReligiousInfo(strApplicationID, (sbyte)DDL_Star.SelectedIndex,
                                                                                    (sbyte)DDL_Moon.SelectedIndex, sbyteHoroscopeMatch, TB_POB.Text, strTimeOfBirth, sbyteManglik);

                    sbyteFlag += MatrimonialMessanger.SetMailingSettings(HF_UaerID.Value);
                }
                else
                {
                    Response.Redirect("../Extras/ErrorReport.aspx");
                }

                if (sbyteFlag == 3)
                {
                    MatrimonialMemberShip.UpdateIndex(strApplicationID);
                    HttpCookie objHttpCookie = new HttpCookie("MatRegInfo");
                    objHttpCookie.Values["ApplicationID"] = Crypto.EnCrypto(strApplicationID);
                    objHttpCookie.Expires = DateTime.MaxValue; //<<<<<<<<<<<<<< ForTesting >>>>>>>>>>>
                    Response.Cookies.Add(objHttpCookie);

                    Server.Transfer("RegistrationStep2.aspx");
                }
                else
                {
                    Response.Write(strApplicationID);
                    //Response.Redirect("../Extras/ErrorReport.aspx");<< ForTesting >>
                }
            }
            else
            {
                LabelDisplay.Visible = true;
                LabelDisplay.Text    = "You Need to accept terms and conditions";
            }
        }
    }