// Search in range with two parameters
        private void Search_In_Range_2P_button_Click(object sender, EventArgs e)
        {
            String Option1 = Search_In_Range_2P_P1_comboBox.Text;
            String Option2 = Search_In_Range_2P_P2_comboBox.Text;
            String SearchKeyFROM1, SearchKeyTO1, SearchKeyFROM2, SearchKeyTO2, SQLcommand;

            #region Data Validation
            if (!ValidateData.ValidateComboBoxItem(Option1, new List<String> { "Patient_ID", "Age", "Visit_date", "Birth_date", "DMF", "_dmf", "DEF" }))
            {
                Error.SetError(Search_In_Range_2P_P1_comboBox, "Please");
                return;
            }
            Error.Clear();

            if (!ValidateData.ValidateComboBoxItem(Option2, new List<String> { "Patient_ID", "Age", "Visit_date", "Birth_date", "DMF", "_dmf", "DEF" }))
            {
                Error.SetError(Search_In_Range_2P_P2_comboBox, "Please");
                return;
            }
            Error.Clear();

            if (Option1 == Option2)
            {
                MessageBox.Show("Please choose different Search Parameters");
                Error.SetError(Search_In_Range_2P_P1_comboBox, "plz");
                Error.SetError(Search_In_Range_2P_P2_comboBox, "plz");
                return;
            }
            Error.Clear();

            ///////////////////////////////////////////////

            SearchKeyFROM1 = Search_IR_2P_P1_from_textBox.Text;
            SearchKeyTO1 = Search_IR_2P_P1_to_textBox.Text;

            if (Option1 == "Patient_ID" && (!ValidateData.ValidateIDField(SearchKeyFROM1) || !ValidateData.ValidateIDField(SearchKeyTO1)))
            {
                Error.SetError(SIR_2P_P1_SK_Label, "Enter valid ID");
                return;
            }
            else if (Option1 == "Age" && (!ValidateData.ValidateAge(SearchKeyFROM1) || !ValidateData.ValidateAge(SearchKeyTO1)))
            {
                Error.SetError(SIR_2P_P1_SK_Label, "Enter Valid age");
                return;
            }
            else if (Option1 == "Visit_date" && (!ValidateData.ValidateDate(SearchKeyFROM1) || !ValidateData.ValidateDate(SearchKeyTO1)))
            {
                MessageBox.Show("Please enter valid Visit date, ex: 1/2/2002 ");
                Error.SetError(SIR_2P_P1_SK_Label, "Enter valid visit date");
                return;
            }
            else if (Option1 == "Birth_date" && (!ValidateData.ValidateDate(SearchKeyFROM1) || !ValidateData.ValidateDate(SearchKeyTO1)))
            {
                MessageBox.Show("Please enter valid Birth date, ex: 1/2/2002 ");
                Error.SetError(SIR_2P_P1_SK_Label, "Enter valid visit date");
                return;
            }
            else if (Option1 == "DMF" && (!ValidateData.ValidateDoubleSearchKEy(SearchKeyFROM1) || !ValidateData.ValidateDoubleSearchKEy(SearchKeyTO1)))
            {
                MessageBox.Show("Please enter valid DMF values");
                Error.SetError(SIR_2P_P1_SK_Label, "Enter valid DMF values");
                return;
            }
            else if (Option1 == "_dmf" && (!ValidateData.ValidateDoubleSearchKEy(SearchKeyFROM1) || !ValidateData.ValidateDoubleSearchKEy(SearchKeyTO1)))
            {
                MessageBox.Show("Please enter valid dmf values");
                Error.SetError(SIR_2P_P1_SK_Label, "Enter valid DMF values");
                return;
            }
            else if (Option1 == "DEF" && (!ValidateData.ValidateDoubleSearchKEy(SearchKeyFROM1) || !ValidateData.ValidateDoubleSearchKEy(SearchKeyTO1)))
            {
                MessageBox.Show("Please enter valid DEF values");
                Error.SetError(SIR_2P_P1_SK_Label, "Enter valid DEF values");
                return;
            }
            Error.Clear();

            // ---------------------------------------------------------
            SearchKeyFROM2 = Search_IR_2P_P2_from_textBox.Text;
            SearchKeyTO2 = Search_IR_2P_P2_to_textBox.Text;

            if (Option2 == "Patient_ID" && (!ValidateData.ValidateIDField(SearchKeyFROM2) || !ValidateData.ValidateIDField(SearchKeyTO2)))
            {
                Error.SetError(SIR_2P_P2_SK_Label, "Enter valid ID");
                return;
            }
            else if (Option2 == "Age" && (!ValidateData.ValidateAge(SearchKeyFROM2) || !ValidateData.ValidateAge(SearchKeyTO2)))
            {
                Error.SetError(SIR_2P_P2_SK_Label, "Enter Valid age");
                return;
            }
            else if (Option2 == "Visit_date" && (!ValidateData.ValidateDate(SearchKeyFROM2) || !ValidateData.ValidateDate(SearchKeyTO2)))
            {
                MessageBox.Show("Please enter valid Visit date, ex: 1/2/2002 ");
                Error.SetError(SIR_2P_P2_SK_Label, "Enter valid visit date");
                return;
            }
            else if (Option2 == "Birth_date" && (!ValidateData.ValidateDate(SearchKeyFROM2) || !ValidateData.ValidateDate(SearchKeyTO2)))
            {
                MessageBox.Show("Please enter valid Birth date, ex: 1/2/2002 ");
                Error.SetError(SIR_2P_P2_SK_Label, "Enter valid visit date");
                return;
            }
            else if (Option2 == "DMF" && (!ValidateData.ValidateDoubleSearchKEy(SearchKeyFROM2) || !ValidateData.ValidateDoubleSearchKEy(SearchKeyTO2)))
            {
                MessageBox.Show("Please enter valid DMF values");
                Error.SetError(SIR_2P_P2_SK_Label, "Enter valid DMF values");
                return;
            }
            else if (Option2 == "_dmf" && (!ValidateData.ValidateDoubleSearchKEy(SearchKeyFROM2) || !ValidateData.ValidateDoubleSearchKEy(SearchKeyTO2)))
            {
                MessageBox.Show("Please enter valid dmf values");
                Error.SetError(SIR_2P_P2_SK_Label, "Enter valid DMF values");
                return;
            }
            else if (Option2 == "DEF" && (!ValidateData.ValidateDoubleSearchKEy(SearchKeyFROM2) || !ValidateData.ValidateDoubleSearchKEy(SearchKeyTO2)))
            {
                MessageBox.Show("Please enter valid DEF values");
                Error.SetError(SIR_2P_P2_SK_Label, "Enter valid DEF values");
                return;
            }
            Error.Clear();
            #endregion

            /////////////////////////////////////
            // Fetch Data from DB

            SQLcommand = Get_Search_InRange_2P_SQLcommand(Option1,Option2, SearchKeyFROM1, SearchKeyTO1, SearchKeyFROM2, SearchKeyTO2);

            if (SQLcommand.Length != 0)
            {
                Search_Result newResult = new Search_Result(SQLcommand);

                if (newResult.ShowForm == true)
                    newResult.Show();
                else
                {
                    Error.SetError(Set_Search_2P_Button, "Search keys is not exist in your database");
                    return;
                }

            }
            else
            {
                MessageBox.Show("SQL COMMAND STRING IS EMPTY");
            }
            Error.Clear();
        }
        // Search for set of people with two parameters
        private void Set_Search_2P_Button_Click(object sender, EventArgs e)
        {
            String Option1 = Set_S_P1_comboBox.Text;
            String Option2 = Set_S_P2_comboBox.Text;
            String SearchKey1, SearchKey2, SQLcommand;

            #region Data Validation
            //Validate Options
            if (!ValidateData.ValidateComboBoxItem(Option1, SearchOptions))
            {
                Error.SetError(Set_S_P1_comboBox, "Please");
                return;
            }
            Error.Clear();

            if (!ValidateData.ValidateComboBoxItem(Option2, SearchOptions))
            {
                Error.SetError(Set_S_P2_comboBox, "Please");
                return;
            }
            Error.Clear();

            if (Option1 == Option2)
            {
                MessageBox.Show("Please choose different Search Parameters");
                Error.SetError(Set_S_P1_comboBox, "plz");
                Error.SetError(Set_S_P2_comboBox, "plz");
                return;
            }
            Error.Clear();

            // Get Search Keys Data
            if (Option1 == "Diagnose")
                SearchKey1 = SetK_P1_Diagnosis_comboBox.Text;
            else if (Option1 == "Procedures")
                SearchKey1 = SetK_P1_DAP_comboBox.Text;
            else if (Option1 == "Sex")
                SearchKey1 = SetK_P1_Sex_comboBox.Text;
            else if (Option1 == "Relative_marriage")
                SearchKey1 = SetK_P1_RM_comboBox.Text;
            else
                SearchKey1 = SetK_P1_textBox.Text;
            // ----------------------------------------
            if (Option2 == "Diagnose")
                SearchKey2 = SetK_P2_Diagnosis_comboBox.Text;
            else if (Option2 == "Procedures")
                SearchKey2 = SetK_P2_DAP_comboBox.Text;
            else if (Option2 == "Sex")
                SearchKey2 = SetK_P2_Sex_comboBox.Text;
            else if (Option2 == "Relative_marriage")
                SearchKey2 = SetK_P2_RM_comboBox.Text;
            else
                SearchKey2 = SetK_P2_textBox.Text;
            // -------------------------------------
            // Validate Search Keys
            if (!ValidateData.ValidateSetSearchKey(Option1, SearchKey1) || !Check_IfExist(Option1, SearchKey1))
            {
                if (Option1 == "Diagnose")
                    Error.SetError(SetK_P1_Diagnosis_comboBox, "Please enter valid data");
                else if (Option1 == "Procedures")
                    Error.SetError(SetK_P1_DAP_comboBox, "Please enter valid data");
                else if (Option1 == "Sex")
                    Error.SetError(SetK_P1_Sex_comboBox, "Please enter valid data");
                else if (Option1 == "Relative_marriage")
                    Error.SetError(SetK_P1_RM_comboBox, "Please enter valid data");
                else
                    Error.SetError(SetK_P1_textBox, "Please enter valid data");
                return;
            }
            Error.Clear();
            // ---------------------------------------
            if (!ValidateData.ValidateSetSearchKey(Option2, SearchKey2) || !Check_IfExist(Option2, SearchKey2))
            {
                if (Option2 == "Diagnose")
                    Error.SetError(SetK_P2_Diagnosis_comboBox, "Please enter valid data");
                else if (Option2 == "Procedures")
                    Error.SetError(SetK_P2_DAP_comboBox, "Please enter valid data");
                else if (Option2 == "Sex")
                    Error.SetError(SetK_P2_Sex_comboBox, "Please enter valid data");
                else if (Option2 == "Relative_marriage")
                    Error.SetError(SetK_P2_RM_comboBox, "Please enter valid data");
                else
                    Error.SetError(SetK_P2_textBox, "Please enter valid data");
                return;
            }
            Error.Clear();

            #endregion



            //--------------------------------------------------
            // Fetch data using SQL Commands

            SQLcommand = Get_Set_Search_2P_SQLcommand(Option1, Option2, SearchKey1, SearchKey2);

            if (SQLcommand.Length != 0)
            {
                Search_Result newResult = new Search_Result(SQLcommand);

                if (newResult.ShowForm == true)
                    newResult.Show();
                else
                {
                    Error.SetError(Set_Search_2P_Button, "Search keys is not exist in your database");
                    return;
                }
                    
            }
            else
            {
                MessageBox.Show("SQL COMMAND STRING IS EMPTY");
            }
            Error.Clear();



        }
        // Search for set of people
        private void Set_Search_button_Click(object sender, EventArgs e)
        {
            String Option = Set_Search_comboBox.Text;
            String SearchKey, SQLcommand;

            if (!ValidateData.ValidateComboBoxItem(Option, SearchOptions))
            {
                Error.SetError(Set_Search_comboBox, "Please");
                return;
            }
            Error.Clear();    

            if (Option == "Diagnose")
                SearchKey = Set_Search_Diagnosis_comboBox.Text;
            else if (Option == "Procedures")
                SearchKey = Set_Search_Procedures_comboBox.Text;
            else if (Option == "Sex")
                SearchKey = Set_Search_Sex_comboBox.Text;
            else if (Option == "Relative_marriage")
                SearchKey = Set_Search_RealativeM_comboBox.Text;
            else
                SearchKey = Set_Search_Key_textBox.Text;

            if (!ValidateData.ValidateSetSearchKey(Option, SearchKey) || !Check_IfExist(Option, SearchKey))
            {
                if (Option == "Diagnose")
                    Error.SetError(Set_Search_Diagnosis_comboBox, "Please enter valid data");
                else if (Option == "Procedures")
                    Error.SetError(Set_Search_Procedures_comboBox, "Please enter valid data");
                else if (Option == "Sex")
                     Error.SetError(Set_Search_Sex_comboBox, "Please enter valid data");
                else if (Option == "Relative_marriage")
                     Error.SetError(Set_Search_RealativeM_comboBox, "Please enter valid data");
                else
                    Error.SetError(Set_Search_Key_textBox, "Please enter valid data");
                return;
            }
            Error.Clear();
       
            ////////////////////////////////////////////////////////

            SQLcommand = Get_Set_Search_SQLcommand(Option, SearchKey);

            if (SQLcommand.Length != 0)
            {
                Search_Result newResult = new Search_Result(SQLcommand);

                if (newResult.ShowForm == true)
                    newResult.Show();
                else
                {
                    Error.SetError(Set_Search_2P_Button, "Search keys is not exist in your database");
                    return;
                }

            }
            else
            {
                MessageBox.Show("SQL COMMAND STRING IS EMPTY");
            }
            Error.Clear();
        }
Beispiel #4
0
        // Search in range with two parameters
        private void Search_In_Range_2P_button_Click(object sender, EventArgs e)
        {
            String Option1 = Search_In_Range_2P_P1_comboBox.Text;
            String Option2 = Search_In_Range_2P_P2_comboBox.Text;
            String SearchKeyFROM1, SearchKeyTO1, SearchKeyFROM2, SearchKeyTO2, SQLcommand;

            #region Data Validation
            if (!ValidateData.ValidateComboBoxItem(Option1, new List <String> {
                "Patient_ID", "Age", "Visit_date", "Birth_date", "DMF", "_dmf", "DEF"
            }))
            {
                Error.SetError(Search_In_Range_2P_P1_comboBox, "Please");
                return;
            }
            Error.Clear();

            if (!ValidateData.ValidateComboBoxItem(Option2, new List <String> {
                "Patient_ID", "Age", "Visit_date", "Birth_date", "DMF", "_dmf", "DEF"
            }))
            {
                Error.SetError(Search_In_Range_2P_P2_comboBox, "Please");
                return;
            }
            Error.Clear();

            if (Option1 == Option2)
            {
                MessageBox.Show("Please choose different Search Parameters");
                Error.SetError(Search_In_Range_2P_P1_comboBox, "plz");
                Error.SetError(Search_In_Range_2P_P2_comboBox, "plz");
                return;
            }
            Error.Clear();

            ///////////////////////////////////////////////

            SearchKeyFROM1 = Search_IR_2P_P1_from_textBox.Text;
            SearchKeyTO1   = Search_IR_2P_P1_to_textBox.Text;

            if (Option1 == "Patient_ID" && (!ValidateData.ValidateIDField(SearchKeyFROM1) || !ValidateData.ValidateIDField(SearchKeyTO1)))
            {
                Error.SetError(SIR_2P_P1_SK_Label, "Enter valid ID");
                return;
            }
            else if (Option1 == "Age" && (!ValidateData.ValidateAge(SearchKeyFROM1) || !ValidateData.ValidateAge(SearchKeyTO1)))
            {
                Error.SetError(SIR_2P_P1_SK_Label, "Enter Valid age");
                return;
            }
            else if (Option1 == "Visit_date" && (!ValidateData.ValidateDate(SearchKeyFROM1) || !ValidateData.ValidateDate(SearchKeyTO1)))
            {
                MessageBox.Show("Please enter valid Visit date, ex: 1/2/2002 ");
                Error.SetError(SIR_2P_P1_SK_Label, "Enter valid visit date");
                return;
            }
            else if (Option1 == "Birth_date" && (!ValidateData.ValidateDate(SearchKeyFROM1) || !ValidateData.ValidateDate(SearchKeyTO1)))
            {
                MessageBox.Show("Please enter valid Birth date, ex: 1/2/2002 ");
                Error.SetError(SIR_2P_P1_SK_Label, "Enter valid visit date");
                return;
            }
            else if (Option1 == "DMF" && (!ValidateData.ValidateDoubleSearchKEy(SearchKeyFROM1) || !ValidateData.ValidateDoubleSearchKEy(SearchKeyTO1)))
            {
                MessageBox.Show("Please enter valid DMF values");
                Error.SetError(SIR_2P_P1_SK_Label, "Enter valid DMF values");
                return;
            }
            else if (Option1 == "_dmf" && (!ValidateData.ValidateDoubleSearchKEy(SearchKeyFROM1) || !ValidateData.ValidateDoubleSearchKEy(SearchKeyTO1)))
            {
                MessageBox.Show("Please enter valid dmf values");
                Error.SetError(SIR_2P_P1_SK_Label, "Enter valid DMF values");
                return;
            }
            else if (Option1 == "DEF" && (!ValidateData.ValidateDoubleSearchKEy(SearchKeyFROM1) || !ValidateData.ValidateDoubleSearchKEy(SearchKeyTO1)))
            {
                MessageBox.Show("Please enter valid DEF values");
                Error.SetError(SIR_2P_P1_SK_Label, "Enter valid DEF values");
                return;
            }
            Error.Clear();

            // ---------------------------------------------------------
            SearchKeyFROM2 = Search_IR_2P_P2_from_textBox.Text;
            SearchKeyTO2   = Search_IR_2P_P2_to_textBox.Text;

            if (Option2 == "Patient_ID" && (!ValidateData.ValidateIDField(SearchKeyFROM2) || !ValidateData.ValidateIDField(SearchKeyTO2)))
            {
                Error.SetError(SIR_2P_P2_SK_Label, "Enter valid ID");
                return;
            }
            else if (Option2 == "Age" && (!ValidateData.ValidateAge(SearchKeyFROM2) || !ValidateData.ValidateAge(SearchKeyTO2)))
            {
                Error.SetError(SIR_2P_P2_SK_Label, "Enter Valid age");
                return;
            }
            else if (Option2 == "Visit_date" && (!ValidateData.ValidateDate(SearchKeyFROM2) || !ValidateData.ValidateDate(SearchKeyTO2)))
            {
                MessageBox.Show("Please enter valid Visit date, ex: 1/2/2002 ");
                Error.SetError(SIR_2P_P2_SK_Label, "Enter valid visit date");
                return;
            }
            else if (Option2 == "Birth_date" && (!ValidateData.ValidateDate(SearchKeyFROM2) || !ValidateData.ValidateDate(SearchKeyTO2)))
            {
                MessageBox.Show("Please enter valid Birth date, ex: 1/2/2002 ");
                Error.SetError(SIR_2P_P2_SK_Label, "Enter valid visit date");
                return;
            }
            else if (Option2 == "DMF" && (!ValidateData.ValidateDoubleSearchKEy(SearchKeyFROM2) || !ValidateData.ValidateDoubleSearchKEy(SearchKeyTO2)))
            {
                MessageBox.Show("Please enter valid DMF values");
                Error.SetError(SIR_2P_P2_SK_Label, "Enter valid DMF values");
                return;
            }
            else if (Option2 == "_dmf" && (!ValidateData.ValidateDoubleSearchKEy(SearchKeyFROM2) || !ValidateData.ValidateDoubleSearchKEy(SearchKeyTO2)))
            {
                MessageBox.Show("Please enter valid dmf values");
                Error.SetError(SIR_2P_P2_SK_Label, "Enter valid DMF values");
                return;
            }
            else if (Option2 == "DEF" && (!ValidateData.ValidateDoubleSearchKEy(SearchKeyFROM2) || !ValidateData.ValidateDoubleSearchKEy(SearchKeyTO2)))
            {
                MessageBox.Show("Please enter valid DEF values");
                Error.SetError(SIR_2P_P2_SK_Label, "Enter valid DEF values");
                return;
            }
            Error.Clear();
            #endregion

            /////////////////////////////////////
            // Fetch Data from DB

            SQLcommand = Get_Search_InRange_2P_SQLcommand(Option1, Option2, SearchKeyFROM1, SearchKeyTO1, SearchKeyFROM2, SearchKeyTO2);

            if (SQLcommand.Length != 0)
            {
                Search_Result newResult = new Search_Result(SQLcommand);

                if (newResult.ShowForm == true)
                {
                    newResult.Show();
                }
                else
                {
                    Error.SetError(Set_Search_2P_Button, "Search keys is not exist in your database");
                    return;
                }
            }
            else
            {
                MessageBox.Show("SQL COMMAND STRING IS EMPTY");
            }
            Error.Clear();
        }
Beispiel #5
0
        // Search for set of people with two parameters
        private void Set_Search_2P_Button_Click(object sender, EventArgs e)
        {
            String Option1 = Set_S_P1_comboBox.Text;
            String Option2 = Set_S_P2_comboBox.Text;
            String SearchKey1, SearchKey2, SQLcommand;

            #region Data Validation
            //Validate Options
            if (!ValidateData.ValidateComboBoxItem(Option1, SearchOptions))
            {
                Error.SetError(Set_S_P1_comboBox, "Please");
                return;
            }
            Error.Clear();

            if (!ValidateData.ValidateComboBoxItem(Option2, SearchOptions))
            {
                Error.SetError(Set_S_P2_comboBox, "Please");
                return;
            }
            Error.Clear();

            if (Option1 == Option2)
            {
                MessageBox.Show("Please choose different Search Parameters");
                Error.SetError(Set_S_P1_comboBox, "plz");
                Error.SetError(Set_S_P2_comboBox, "plz");
                return;
            }
            Error.Clear();

            // Get Search Keys Data
            if (Option1 == "Diagnose")
            {
                SearchKey1 = SetK_P1_Diagnosis_comboBox.Text;
            }
            else if (Option1 == "Procedures")
            {
                SearchKey1 = SetK_P1_DAP_comboBox.Text;
            }
            else if (Option1 == "Sex")
            {
                SearchKey1 = SetK_P1_Sex_comboBox.Text;
            }
            else if (Option1 == "Relative_marriage")
            {
                SearchKey1 = SetK_P1_RM_comboBox.Text;
            }
            else
            {
                SearchKey1 = SetK_P1_textBox.Text;
            }
            // ----------------------------------------
            if (Option2 == "Diagnose")
            {
                SearchKey2 = SetK_P2_Diagnosis_comboBox.Text;
            }
            else if (Option2 == "Procedures")
            {
                SearchKey2 = SetK_P2_DAP_comboBox.Text;
            }
            else if (Option2 == "Sex")
            {
                SearchKey2 = SetK_P2_Sex_comboBox.Text;
            }
            else if (Option2 == "Relative_marriage")
            {
                SearchKey2 = SetK_P2_RM_comboBox.Text;
            }
            else
            {
                SearchKey2 = SetK_P2_textBox.Text;
            }
            // -------------------------------------
            // Validate Search Keys
            if (!ValidateData.ValidateSetSearchKey(Option1, SearchKey1) || !Check_IfExist(Option1, SearchKey1))
            {
                if (Option1 == "Diagnose")
                {
                    Error.SetError(SetK_P1_Diagnosis_comboBox, "Please enter valid data");
                }
                else if (Option1 == "Procedures")
                {
                    Error.SetError(SetK_P1_DAP_comboBox, "Please enter valid data");
                }
                else if (Option1 == "Sex")
                {
                    Error.SetError(SetK_P1_Sex_comboBox, "Please enter valid data");
                }
                else if (Option1 == "Relative_marriage")
                {
                    Error.SetError(SetK_P1_RM_comboBox, "Please enter valid data");
                }
                else
                {
                    Error.SetError(SetK_P1_textBox, "Please enter valid data");
                }
                return;
            }
            Error.Clear();
            // ---------------------------------------
            if (!ValidateData.ValidateSetSearchKey(Option2, SearchKey2) || !Check_IfExist(Option2, SearchKey2))
            {
                if (Option2 == "Diagnose")
                {
                    Error.SetError(SetK_P2_Diagnosis_comboBox, "Please enter valid data");
                }
                else if (Option2 == "Procedures")
                {
                    Error.SetError(SetK_P2_DAP_comboBox, "Please enter valid data");
                }
                else if (Option2 == "Sex")
                {
                    Error.SetError(SetK_P2_Sex_comboBox, "Please enter valid data");
                }
                else if (Option2 == "Relative_marriage")
                {
                    Error.SetError(SetK_P2_RM_comboBox, "Please enter valid data");
                }
                else
                {
                    Error.SetError(SetK_P2_textBox, "Please enter valid data");
                }
                return;
            }
            Error.Clear();

            #endregion



            //--------------------------------------------------
            // Fetch data using SQL Commands

            SQLcommand = Get_Set_Search_2P_SQLcommand(Option1, Option2, SearchKey1, SearchKey2);

            if (SQLcommand.Length != 0)
            {
                Search_Result newResult = new Search_Result(SQLcommand);

                if (newResult.ShowForm == true)
                {
                    newResult.Show();
                }
                else
                {
                    Error.SetError(Set_Search_2P_Button, "Search keys is not exist in your database");
                    return;
                }
            }
            else
            {
                MessageBox.Show("SQL COMMAND STRING IS EMPTY");
            }
            Error.Clear();
        }
Beispiel #6
0
        // Search for set of people
        private void Set_Search_button_Click(object sender, EventArgs e)
        {
            String Option = Set_Search_comboBox.Text;
            String SearchKey, SQLcommand;

            if (!ValidateData.ValidateComboBoxItem(Option, SearchOptions))
            {
                Error.SetError(Set_Search_comboBox, "Please");
                return;
            }
            Error.Clear();

            if (Option == "Diagnose")
            {
                SearchKey = Set_Search_Diagnosis_comboBox.Text;
            }
            else if (Option == "Procedures")
            {
                SearchKey = Set_Search_Procedures_comboBox.Text;
            }
            else if (Option == "Sex")
            {
                SearchKey = Set_Search_Sex_comboBox.Text;
            }
            else if (Option == "Relative_marriage")
            {
                SearchKey = Set_Search_RealativeM_comboBox.Text;
            }
            else
            {
                SearchKey = Set_Search_Key_textBox.Text;
            }

            if (!ValidateData.ValidateSetSearchKey(Option, SearchKey) || !Check_IfExist(Option, SearchKey))
            {
                if (Option == "Diagnose")
                {
                    Error.SetError(Set_Search_Diagnosis_comboBox, "Please enter valid data");
                }
                else if (Option == "Procedures")
                {
                    Error.SetError(Set_Search_Procedures_comboBox, "Please enter valid data");
                }
                else if (Option == "Sex")
                {
                    Error.SetError(Set_Search_Sex_comboBox, "Please enter valid data");
                }
                else if (Option == "Relative_marriage")
                {
                    Error.SetError(Set_Search_RealativeM_comboBox, "Please enter valid data");
                }
                else
                {
                    Error.SetError(Set_Search_Key_textBox, "Please enter valid data");
                }
                return;
            }
            Error.Clear();

            ////////////////////////////////////////////////////////

            SQLcommand = Get_Set_Search_SQLcommand(Option, SearchKey);

            if (SQLcommand.Length != 0)
            {
                Search_Result newResult = new Search_Result(SQLcommand);

                if (newResult.ShowForm == true)
                {
                    newResult.Show();
                }
                else
                {
                    Error.SetError(Set_Search_2P_Button, "Search keys is not exist in your database");
                    return;
                }
            }
            else
            {
                MessageBox.Show("SQL COMMAND STRING IS EMPTY");
            }
            Error.Clear();
        }