public static void updateOrderStatus(int id, string str)
{
string quary = string.Format($"update Ordr set orderStatus='{str}' where orderID='{id}'");
DBManager.ExecuteNonQuery(quary);
}
public static string GetStatus(string _email)
{
string query = $"select Status from Orders";
return(DBManager.ExecuteQuery(query).Rows[0]["Status"].ToString());
}
public static DataTable GettPendedOrder()
{
string str = "select orderID,userFname+' '+userLname FullName,Date,delivaryAddress,totalPrice from Users u ,Ordr o where u.userID=o.userID and o.orderStatus='pended'";
return(DBManager.ExecuteQuery(str));
}
