Пример #1
0
 private void bunifuFlatButton2_Click(object sender, EventArgs e)
 {
     if (userID != -1)
     {
         movePanel(btnContact);
         ShowBusinessContacts s = new ShowBusinessContacts(this);
         addcontroltopanel(s);
     }
     else
     {
         PopupNotifier popup = new PopupNotifier();
         popup.TitleText   = "Personal Dairy Application";
         popup.ContentText = "LOGIN FIRST PLZ! ";
         popup.Image       = Properties.Resources.icons8_Error_32px;
         popup.Popup();
     }
 }
        private void pictureBox8_Click(object sender, EventArgs e)
        {
            ShowBusinessContacts s = new ShowBusinessContacts(form1);

            if (option.Equals("update"))
            {
                if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "" || textBox4.Text == "" || listBox1.Items.Count < 1 || listBox2.Items.Count < 1 || listBox3.Items.Count < 1)
                {
                    MessageBox.Show("Invalid Input", "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else
                {
                    try
                    {
                        string noteName = selectedItem;
                        conn = new OracleConnection(ordb);
                        conn.Open();


                        OracleCommand action = new OracleCommand();
                        action.Connection  = conn;
                        action.CommandText = "select bn_id from bussines_note where bnname=:noteName";
                        action.CommandType = CommandType.Text;
                        action.Parameters.Add("noteName", noteName);
                        OracleDataReader drr = action.ExecuteReader();


                        drr.Read();
                        int noteID = Convert.ToInt32(drr[0]);
                        drr.Close();


                        OracleCommand cmd = new OracleCommand();
                        cmd.Connection  = conn;
                        cmd.CommandText = "UpadetBussinesNote";
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.Parameters.Add("massagee", textBox4.Text.ToString());
                        cmd.Parameters.Add("bnnamee", textBox1.Text.ToString());
                        cmd.Parameters.Add("idd", Convert.ToInt32(textBox2.Text));
                        cmd.Parameters.Add("bnid", noteID);
                        cmd.ExecuteNonQuery();

                        OracleCommand bankAcc = new OracleCommand();
                        bankAcc.Connection  = conn;
                        bankAcc.CommandText = "update bn_bankaccount set bankaccount=:bnba where bnid=:niid";
                        bankAcc.CommandType = CommandType.Text;
                        bankAcc.Parameters.Add("bnba", Convert.ToInt32(textBox3.Text));
                        bankAcc.Parameters.Add("niid", noteID);
                        bankAcc.ExecuteNonQuery();

                        OracleCommand addressDelete = new OracleCommand();
                        addressDelete.Connection  = conn;
                        addressDelete.CommandText = "delete from bn_addresses where bnid=:niid";
                        addressDelete.CommandType = CommandType.Text;
                        addressDelete.Parameters.Add("niid", noteID);
                        addressDelete.ExecuteNonQuery();

                        OracleCommand phoneDelete = new OracleCommand();
                        phoneDelete.Connection  = conn;
                        phoneDelete.CommandText = "delete from bn_phones where bnid=:niid";
                        phoneDelete.CommandType = CommandType.Text;
                        phoneDelete.Parameters.Add("niid", noteID);
                        phoneDelete.ExecuteNonQuery();

                        OracleCommand emailDelete = new OracleCommand();
                        emailDelete.Connection  = conn;
                        emailDelete.CommandText = "delete from bn_emails where bnid=:niid";
                        emailDelete.CommandType = CommandType.Text;
                        emailDelete.Parameters.Add("niid", noteID);
                        emailDelete.ExecuteNonQuery();

                        for (int i = 0; i < listBox1.Items.Count; i++)
                        {
                            OracleCommand bnAdreess = new OracleCommand();
                            bnAdreess.Connection  = conn;
                            bnAdreess.CommandText = "insert into bn_addresses values (:bnaddrees,:noteid)";
                            bnAdreess.CommandType = CommandType.Text;
                            bnAdreess.Parameters.Add("bnaddrees", listBox1.Items[i].ToString());
                            bnAdreess.Parameters.Add("noteid", noteID);
                            bnAdreess.ExecuteNonQuery();
                        }

                        for (int i = 0; i < listBox2.Items.Count; i++)
                        {
                            OracleCommand bnPhones = new OracleCommand();
                            bnPhones.Connection  = conn;
                            bnPhones.CommandText = "insert into bn_phones values (:bnphone,:noteid)";
                            bnPhones.CommandType = CommandType.Text;
                            bnPhones.Parameters.Add("bnphone", Convert.ToInt32(listBox2.Items[i]));
                            bnPhones.Parameters.Add("noteid", noteID);
                            bnPhones.ExecuteNonQuery();
                        }

                        for (int i = 0; i < listBox3.Items.Count; i++)
                        {
                            OracleCommand bnEmail = new OracleCommand();
                            bnEmail.Connection  = conn;
                            bnEmail.CommandText = "insert into bn_emails values (:bnemail,:noteid)";
                            bnEmail.CommandType = CommandType.Text;
                            bnEmail.Parameters.Add("bnemail", listBox3.Items[i].ToString());
                            bnEmail.Parameters.Add("noteid", noteID);
                            bnEmail.ExecuteNonQuery();
                        }
                        PopupNotifier popup = new PopupNotifier();
                        popup.TitleText = "Bussines Note Updated Successfully";
                        popup.Popup();
                        s.listBox1.Items.Remove(selectedItem);
                        s.listBox1.Items.Add(textBox1.Text);
                        addcontroltopanel(s);
                    }
                    catch
                    {
                        MessageBox.Show("invalid input", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                }
            }
            else if (option.Equals("insert"))
            {
                if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "" || textBox4.Text == "" || listBox1.Items.Count < 1 || listBox2.Items.Count < 1 || listBox3.Items.Count < 1)
                {
                    MessageBox.Show("Invalid Input", "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else
                {
                    string noteName = textBox1.Text.ToString();

                    int newid = 0;
                    conn = new OracleConnection(ordb);
                    conn.Open();
                    OracleCommand action = new OracleCommand();
                    action.Connection  = conn;
                    action.CommandText = "GetBNID";
                    action.CommandType = CommandType.StoredProcedure;
                    action.Parameters.Add("newid", OracleDbType.Int32, ParameterDirection.Output);
                    action.ExecuteNonQuery();

                    try
                    {
                        newid  = Convert.ToInt32(action.Parameters["newid"].Value.ToString());
                        newid += 1;
                    }
                    catch { newid = 1; }
                    bool isExit = false;
                    for (int i = 0; i < s.listBox1.Items.Count; i++)
                    {
                        if (s.listBox1.Items[i].Equals(noteName))
                        {
                            isExit = true;
                        }
                    }
                    if (isExit)
                    {
                        MessageBox.Show("Name is Already Exist", "Erorr", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                    else
                    {
                        try
                        {
                            OracleCommand cmd = new OracleCommand();
                            cmd.Connection  = conn;
                            cmd.CommandText = "CreateBussinesNote";
                            cmd.CommandType = CommandType.StoredProcedure;
                            cmd.Parameters.Add("bn_idd", newid);
                            cmd.Parameters.Add("massagee", textBox4.Text);
                            cmd.Parameters.Add("bnnamee", textBox1.Text);
                            cmd.Parameters.Add("useridd", userId);
                            cmd.Parameters.Add("idd", Convert.ToInt32(textBox2.Text));
                            cmd.ExecuteNonQuery();



                            OracleCommand bnBankAcc = new OracleCommand();
                            bnBankAcc.Connection  = conn;
                            bnBankAcc.CommandText = "insert into bn_bankaccount values (:bankacc,:noteid)";
                            bnBankAcc.CommandType = CommandType.Text;
                            bnBankAcc.Parameters.Add("bankacc", Convert.ToInt32(textBox3.Text));
                            bnBankAcc.Parameters.Add("noteid", newid);
                            bnBankAcc.ExecuteNonQuery();


                            for (int i = 0; i < listBox1.Items.Count; i++)
                            {
                                OracleCommand bnAdreess = new OracleCommand();
                                bnAdreess.Connection  = conn;
                                bnAdreess.CommandText = "insert into bn_addresses values (:bnaddrees,:noteid)";
                                bnAdreess.CommandType = CommandType.Text;
                                bnAdreess.Parameters.Add("bnaddrees", listBox1.Items[i].ToString());
                                bnAdreess.Parameters.Add("noteid", newid);
                                bnAdreess.ExecuteNonQuery();
                            }

                            for (int i = 0; i < listBox2.Items.Count; i++)
                            {
                                OracleCommand bnPhones = new OracleCommand();
                                bnPhones.Connection  = conn;
                                bnPhones.CommandText = "insert into bn_phones values (:bnphone,:noteid)";
                                bnPhones.CommandType = CommandType.Text;
                                bnPhones.Parameters.Add("bnphone", Convert.ToInt32(listBox2.Items[i]));
                                bnPhones.Parameters.Add("noteid", newid);
                                bnPhones.ExecuteNonQuery();
                            }

                            for (int i = 0; i < listBox3.Items.Count; i++)
                            {
                                OracleCommand bnEmail = new OracleCommand();
                                bnEmail.Connection  = conn;
                                bnEmail.CommandText = "insert into bn_emails values (:bnemail,:noteid)";
                                bnEmail.CommandType = CommandType.Text;
                                bnEmail.Parameters.Add("bnemail", listBox3.Items[i].ToString());
                                bnEmail.Parameters.Add("noteid", newid);
                                bnEmail.ExecuteNonQuery();
                            }
                            PopupNotifier popup = new PopupNotifier();
                            popup.TitleText = "Bussines Note Created Successfully";
                            popup.Popup();
                            form1.bunifuCustomLabel5.Text = (Convert.ToInt32(form1.bunifuCustomLabel5.Text) + 1).ToString();
                            s.listBox1.Items.Add(textBox1.Text);
                            addcontroltopanel(s);
                        }
                        catch
                        {
                            MessageBox.Show("invalid input", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        }
                    }
                }
            }
        }
        public ShowBusinessContact(ShowBusinessContacts Show, Form1 f, string o)
        {
            InitializeComponent();
            show     = Show;
            form1    = f;
            option   = o;
            userId   = f.userID;
            userName = f.userName.Text.ToString();
            if (show.listBox1.SelectedIndex > -1)
            {
                selectedItem = show.listBox1.SelectedItem.ToString();

                conn = new OracleConnection(ordb);
                conn.Open();

                OracleCommand cmd = new OracleCommand();
                cmd.Connection = conn;

                cmd.CommandText = "select massage, bnname,ID,bn_id from bussines_note where userid=:iid and bnname=:nname";
                cmd.CommandType = CommandType.Text;
                cmd.Parameters.Add("iid", userId);
                cmd.Parameters.Add("nnmae", selectedItem);
                OracleDataReader dr = cmd.ExecuteReader();
                dr.Read();
                textBox4.Text = dr[0].ToString();
                textBox1.Text = dr[1].ToString();
                textBox2.Text = dr[2].ToString();
                int noteID = Convert.ToInt32(dr[3]);
                dr.Close();

                OracleCommand c = new OracleCommand();
                c.Connection  = conn;
                c.CommandText = "select bankaccount from bn_bankaccount where bnid=:iid";
                c.CommandType = CommandType.Text;
                c.Parameters.Add("iid", noteID);

                OracleDataReader drr = c.ExecuteReader();
                while (drr.Read())
                {
                    textBox3.Text = drr[0].ToString();
                }
                drr.Close();


                OracleCommand address = new OracleCommand();
                address.Connection  = conn;
                address.CommandText = "select address from bn_addresses where bnid=:iid";
                address.CommandType = CommandType.Text;
                address.Parameters.Add("iid", noteID);
                OracleDataReader h = address.ExecuteReader();
                while (h.Read())
                {
                    listBox1.Items.Add(h[0].ToString());
                }
                h.Close();

                OracleCommand phone = new OracleCommand();
                phone.Connection  = conn;
                phone.CommandText = "select phone from bn_phones where bnid=:iid";
                phone.CommandType = CommandType.Text;
                phone.Parameters.Add("iid", noteID);
                OracleDataReader phone1 = phone.ExecuteReader();
                while (phone1.Read())
                {
                    listBox2.Items.Add(phone1[0].ToString());
                }
                phone1.Close();


                OracleCommand email = new OracleCommand();
                email.Connection  = conn;
                email.CommandText = "select email from bn_emails where bnid=:iid";
                email.CommandType = CommandType.Text;
                email.Parameters.Add("iid", noteID);
                OracleDataReader email1 = email.ExecuteReader();
                while (email1.Read())
                {
                    listBox3.Items.Add(email1[0].ToString());
                }
                email1.Close();
            }
            else if (show.listBox1.SelectedItem != null)
            {
                MessageBox.Show("No selected reminder to show ");
            }
        }
        private void pictureBox7_Click_1(object sender, EventArgs e)
        {
            ShowBusinessContacts s = new ShowBusinessContacts(form1);

            addcontroltopanel(s);
        }