/// <summary>
        /// Wprowadź do bazy danych nowe dane pochodzącę z Tabe
        /// </summary>
        void FillDataBase(int ID)
        {
            string _IDPackage = dtableOrder.Rows[0][Title.IDPackage].ToString();

            //Jezeli brak IDPackage - Insert Jezeli IDPackage =! 0 - Update
            if (_IDPackage == "")
            {
                int    _IDOrderItem = (int)dtableOrder.Rows[0][Title.ID];
                string _netPrice    = dtableOrder.Rows[0][Title.netPrice].ToString();
                _netPrice = Protected.Dot(_netPrice);
                string _amount = dtableOrder.Rows[0][Title.amount].ToString();
                _amount = Protected.Dot(_amount);

                //Stworz nowe zamowienie
                Connection.Execute("INSERT INTO  [Moj_Sklep].[dbo].[Package] (IDOrder, IDOrderItem, NetPrice,Amount)  VALUES (" + ID + "," + _IDOrderItem + "," + _netPrice + "," + _amount + ");");
                //Usun przepisany wiersz
                gridOrder.Rows.RemoveAt(0);
            }
            else
            {
                int _intIDPackage = (int)dtableOrder.Rows[0][Title.IDPackage];
                //Edytuj
                int _IDOrderItem = (int)dtableOrder.Rows[0][Title.ID];

                string _netPrice = dtableOrder.Rows[0][Title.netPrice].ToString();
                _netPrice = Protected.Dot(_netPrice);
                string _amount = dtableOrder.Rows[0][Title.amount].ToString();
                _amount = Protected.Dot(_amount);

                Connection.Execute("UPDATE [Moj_Sklep].[dbo].[Package] SET Amount=" + _amount + " WHERE IDPackage =" + _intIDPackage + "    ");
                gridOrder.Rows.RemoveAt(0);
            }
        }
Exemple #2
0
        void EditProducts(int i)
        {
            Connection.Execute("UPDATE [Moj_Sklep].[dbo].[OrderItem] SET [ProductName]= '"
                               + Protected.Apostrophe(txtProductsName.Text) + "',[Amount]='"
                               + Protected.Dot(Protected.Apostrophe(txtAmount.Text)) + "',[NetPrice]="
                               + Protected.Dot(Protected.Apostrophe(txtNetPrice.Text)) + " WHERE IDOrderItem = "

                               + ID + " ");
        }
Exemple #3
0
 void AddNewProducts()
 {
     Connection.Execute("INSERT INTO [Moj_Sklep].[dbo].[OrderItem] (ProductName,Amount,NetPrice) VALUES ('" + Protected.Apostrophe(txtProductsName.Text) + "','" + Protected.Dot(Protected.Apostrophe(txtAmount.Text)) + "', " + Protected.Dot(Protected.Apostrophe(txtNetPrice.Text)) + ")");
 }