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)); }