public static void DeliveryBag(string username)
{
opendb();
cmd.CommandText = "SELECT OrderDetail.CakeID, OrderDetail.Finish, OrderDetail.UserName, User.Address, User.Telephone, OrderDetail.Price, OrderDetail.Payment, OrderDetail.CakeFace, OrderDetail.DeliverBy " +
"FROM[User] INNER JOIN OrderDetail ON User.UserName = OrderDetail.UserName " +
"WHERE(((OrderDetail.Finish) = 'Y') AND((OrderDetail.Payment) = 'N') AND((OrderDetail.DeliverBy) = '" + username + "'))";
OleDbDataReader dr = cmd.ExecuteReader();
dtdeliverybag.Rows.Clear();
bag.Clear();
dtdeliverybag.Load(dr);
foreach (DataRow row in dtdeliverybag.Rows)
{
cake tmp = new cake();
tmp.cakeid = row["CakeID"].ToString();
tmp.cakeusername = row["UserName"].ToString();
tmp.cakeaddress = row["Address"].ToString();
tmp.tel = row["Telephone"].ToString();
tmp.cakeprice = (double)row["Price"];
tmp.cakeimg = (Byte[])row["CakeFace"];
bag.Add(tmp);
}
closedb();
}
public static void DeliveryInfo()
{
opendb();
cmd.CommandText = "SELECT * FROM[CopyDeliveryQuery]";
OleDbDataReader dr = cmd.ExecuteReader();
dtdelivery.Rows.Clear();
cake.Clear();
dtdelivery.Load(dr);
foreach (DataRow row in dtdelivery.Rows)
{
cake tmp = new cake();
tmp.cakeid = row["CakeID"].ToString();
tmp.cakeusername = row["UserName"].ToString();
tmp.cakeaddress = row["Address"].ToString();
tmp.tel = row["Telephone"].ToString();
tmp.cakeprice = (double)row["Price"];
tmp.cakeimg = (Byte[])row["CakeFace"];
cake.Add(tmp);
}
closedb();
}
