示例#1
0
        private void saveBTN_Click(object sender, EventArgs e)
        {
            //sprawdzamy czy klient został wybrany
            if (klientTXT.Text == "")
            {
                var result = MessageBox.Show("Przed zapisem musisz wybrać klient!");
                if (result == DialogResult.OK)
                {
                    formsy.klients form = new formsy.klients(this);
                    form.Show();
                }
            }
            else
            {
                //zapis do bazy danych
                var MyIni = new INIFile("WektorSettings.ini");
                server   = MyIni.Read("server", "Okna");
                database = MyIni.Read("database", "Okna");
                uid      = MyIni.Read("login", "Okna");
                password = Decrypt(MyIni.Read("pass", "Okna"));

                string          MyConnectionString = "SERVER=" + server + ";" + "DATABASE=" + database + ";" + "UID=" + uid + ";" + "PASSWORD="******";";
                MySqlConnection connection         = new MySqlConnection(MyConnectionString);

                foreach (DataGridViewRow row in metroGrid1.Rows)
                {
                    try
                    {
                        int          id_user = Convert.ToInt32(userID.Text);
                        string       klient  = Form1.logged.Text;
                        int          nr      = Convert.ToInt32(numberBAZA.Text);
                        int          numer   = nr + 1;
                        string       str     = numer.ToString();
                        MySqlCommand cmd     = new MySqlCommand();
                        cmd = connection.CreateCommand();
                        if (row.IsNewRow)
                        {
                            continue;
                        }
                        cmd.Parameters.AddWithValue("@id", numerek.Text);
                        cmd.Parameters.AddWithValue("@indeks", row.Cells[0].Value);
                        cmd.Parameters.AddWithValue("@rabat", row.Cells[3].Value.ToString().Replace("%", "").Replace(",", "."));
                        cmd.Parameters.AddWithValue("@ilosc", row.Cells[5].Value);
                        cmd.Parameters.AddWithValue("@cena", row.Cells[4].Value.ToString().Replace("zł", "").Replace(",", "."));
                        cmd.Parameters.AddWithValue("@data", DateTime.Now);
                        cmd.Parameters.AddWithValue("@kwota", sumaTXT.Text.Replace("zł", "").Replace(",", "."));
                        cmd.CommandText = $"INSERT IGNORE INTO wyceny (nrw,user_id,wycena_user,numer,klient,kwota,data) VALUES (@id,'{id_user}','{nr}','{wycena_nr.Text}',(SELECT id FROM klienci WHERE nazwa = '{klientTXT.Text}'),@kwota,@data); " +
                                          $"INSERT INTO wyceny_detail (id,user_id,wycena_user,id_product,id_klient,rabat,ilosc,cena) VALUES (@id,'{id_user}','{nr}',(SELECT id FROM cenniki WHERE reference = @indeks),(SELECT id FROM klienci WHERE nazwa ='{klientTXT.Text}'),@rabat,@ilosc,@cena);" +
                                          $"UPDATE uzytkownicy SET wycena = '{str}' WHERE username = '******';";
                        connection.Open();
                        cmd.ExecuteNonQuery();
                        connection.Close();
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                }
                var result = MessageBox.Show("Wycena została zapisana pod numerem " + wycena_nr.Text);
                if (result == DialogResult.OK)
                {
                    Close();
                }
            }
        }
示例#2
0
 private void userBTN_Click(object sender, EventArgs e)
 {
     formsy.klients form = new formsy.klients(this);
     form.Show();
 }