public string insertOrder(OrderObj o)
{
string query = @"INSERT INTO orders VALUES('" + o.getOid() + "','" + o.getUid() + "','" + o.getDetails() + "','" + o.getStatus() + "');";
Console.WriteLine(query);
return(query);
}
public List <OrderObj> getUserOrders(string uid)
{
List <OrderObj> orders = new List <OrderObj>();
string query = @"SELECT oid,uid,details,status FROM orders WHERE uid='" + uid + "';";
if (this.OpenConnection() == true)
{
MySqlCommand cmd = new MySqlCommand(query, connection);
//Create a data reader and Execute the command
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
OrderObj o = new OrderObj();
o.setOid(dataReader["oid"].ToString());
o.setUid(dataReader["uid"].ToString());
o.setDetails(dataReader["details"].ToString());
o.setStatus((int)dataReader["status"]);
orders.Add(o);
}
dataReader.Close();
this.CloseConnection();
return(orders);
}
else
{
return(null);
}
}
public adminViewOrder(OrderObj o)
{
InitializeComponent();
this.o = o;
conn = new DbConnection();
oid.Text = o.getOid();
uid.Text = o.getUid();
details.Text = o.getDetails();
setCB();
}
public adminViewOrder(OrderObj o, bool isAdmin)
{
InitializeComponent();
this.o = o;
conn = new DbConnection();
oid.Text = o.getOid();
uid.Text = o.getUid();
details.Text = o.getDetails();
setCB();
update.Visible = false;
deleteOrder.Visible = false;
comboBox1.Enabled = false;
}
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();
}
}
}
