private void Button_DeleteCaseEntirely_Click(object sender, EventArgs e)
        {
            UpdatePersonalControl upd = new UpdatePersonalControl();

            DialogResult dialogResult = MessageBox.Show("Are you sure you want to delete this case from the database?", "Delete Case", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Warning);

            if (dialogResult == DialogResult.Yes)
            {
                if (Combo_UpdatePersonal.SelectedIndex != 0)
                {
                    int keyy = ((KeyValuePair <int, string>)Combo_UpdatePersonal.SelectedItem).Key;
                    upd.deleteEntireCase(keyy);
                    MessageBox.Show(upd.error);

                    this.Close();
                    FormMainProfile.updateCase = null;
                    new FormMainProfile().Show();
                }
                else
                {
                    MessageBox.Show("Please select a Case from the dropdown");
                }
            }
            else if (dialogResult == DialogResult.No)
            {
                //do something else
            }
            else if (dialogResult == DialogResult.Cancel)
            {
            }
        }
        private void Combo_UpdatePersonal_SelectionChangeCommitted_1(object sender, EventArgs e)
        {
            if (Combo_UpdatePersonal.SelectedIndex != 0)
            {
                int keyy = ((KeyValuePair <int, string>)Combo_UpdatePersonal.SelectedItem).Key;
                UpdatePersonalControl person_control = new UpdatePersonalControl();
                Case_Personal_Info    person         = person_control.getPersonalData(keyy);

                TextBox_FullName.Text      = person.fullname;
                TextBox_Guardian.Text      = person.guardian;
                TextBox_pAddress.Text      = person.p_address;
                TextBox_cAddress.Text      = person.c_address;
                TextBox_ContactNumber.Text = person.contact;
                TextBox_Age.Text           = person.age;
                TextBox_Aadhaar.Text       = person.aadhaar;

                byte[]       imageData = person.picture;
                MemoryStream ms        = new MemoryStream(imageData);
                ms.Seek(0, SeekOrigin.Begin);
                Picture_UpdatePhoto.Image = Image.FromStream(ms);
                ms.Flush();
                //Primary Verifier
                //Secodary Verifier

                LabelError_Personl.Text = person.message;
            }
        }
        private void Button_UpdatePersonal_Click(object sender, EventArgs e)
        {
            if (Combo_UpdatePersonal.SelectedIndex != 0)
            {
                int key = ((KeyValuePair <int, string>)Combo_UpdatePersonal.SelectedItem).Key;

                Case_Personal_Info personalModel = new Case_Personal_Info();

                personalModel.fullname  = TextBox_FullName.Text;
                personalModel.guardian  = TextBox_Guardian.Text;
                personalModel.p_address = TextBox_pAddress.Text;
                personalModel.c_address = TextBox_cAddress.Text;
                personalModel.contact   = TextBox_ContactNumber.Text;
                personalModel.age       = TextBox_Age.Text;
                personalModel.aadhaar   = TextBox_Aadhaar.Text;
                personalModel.caseKey   = key;

                MemoryStream stream = new MemoryStream();
                Image        img    = ImageController.ReduceImg(Picture_UpdatePhoto.Image, 4);
                img.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
                personalModel.picture = stream.ToArray();
                stream.Flush();


                UpdatePersonalControl updateControl = new UpdatePersonalControl();
                if (updateControl.updateDetails(personalModel))
                {
                    MessageBox.Show(personalModel.message);
                }
                else
                {
                    MessageBox.Show(personalModel.message);
                }
            }
            else
            {
                MessageBox.Show("Please Select a Case from the Dropdwn", "Case not Selected", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }