Example #1
0
        public List <AdressObj> getAdress(string pid)
        {
            string           query  = "SELECT pid,adress,aid FROM adress WHERE pid='" + pid + "';";
            List <AdressObj> adress = new List <AdressObj>();

            if (this.OpenConnection() == true)
            {
                MySqlCommand    cmd        = new MySqlCommand(query, connection);
                MySqlDataReader dataReader = cmd.ExecuteReader();
                while (dataReader.Read())
                {
                    AdressObj ao = new AdressObj();
                    ao.setPid(dataReader["pid"].ToString());
                    ao.setAdress(dataReader["adress"].ToString());
                    ao.setAid(dataReader["aid"].ToString());
                    adress.Add(ao);
                }
                this.CloseConnection();
                return(adress);
            }
            else
            {
                Console.WriteLine("Unsuccessful connection !");
                return(adress);
            }
        }
Example #2
0
 private void place_order_Click(object sender, EventArgs e)
 {
     if (cartList.Count <= 0)
     {
         MessageBox.Show("Your cart is empty !");
     }
     else
     {
         OrderObj o = new OrderObj();
         o.setOid(oidGenerator());
         o.setUid(f1.u.getUid());
         Dictionary <string, string> od = new Dictionary <string, string>();
         int    i;
         string pids       = "";
         int    totalPrice = 0;
         for (i = 0; i < cartList.Count; i++)
         {
             pids       += cartList[i].getPid() + ",";
             totalPrice += cartList[i].getPrice() * cartList[i].getProductCount();
         }
         od.Add("pids", pids);
         od.Add("totalPrice", totalPrice.ToString());
         AdressObj ao = (AdressObj)adressCB.SelectedItem;
         if (adressCB.SelectedIndex < 0)
         {
             MessageBox.Show("Please choose an adress");
         }
         else
         {
             od.Add("adress", ao.getAid());
             o.setDetails(generateDictionaryString(od));
             conn.sendCommand(conn.insertOrder(o));
             MessageBox.Show("Order send ! ");
             panel1.Controls.Clear();
             f1.clearCart();
         }
     }
 }