public static void EliminarDir(int idDir) { string sql = String.Format("DELETE FROM ADDRESS WHERE idAddress = {0};", idDir); ConnectionDB.ExecuteNonQuery(sql); }
public static void EliminarProd(int idProd) { string sql = String.Format("DELETE FROM PRODUCT WHERE idProduct = {0};", idProd); ConnectionDB.ExecuteNonQuery(sql); }
public static void EliminarOrder(int idOrder) { string sql = String.Format("DELETE FROM apporder WHERE idorder = '{0}';", idOrder); ConnectionDB.ExecuteNonQuery(sql); }
public static void EliminarUser(string username) { string sql = String.Format("DELETE FROM appuser WHERE username = '******';", username); ConnectionDB.ExecuteNonQuery(sql); }
public static void UpdatePass(string newPass, AppUser user) { string sql = String.Format("UPDATE appuser SET password = '******' WHERE idUser = {1};", newPass, user.idUser); ConnectionDB.ExecuteNonQuery(sql); }
public static void EliminarBus(int id) { string sql = String.Format("DELETE FROM business WHERE idBusiness = '{0}';", id); ConnectionDB.ExecuteNonQuery(sql); }