public static void eliminar(string nombre) { string sql = String.Format( "DELETE FROM BUSINESS WHERE name='{0}';", nombre); ConnectioDB.ExecuteNonQuery(sql); }
public static void eliminar(int idPed) { string sql = String.Format( "DELETE FROM APPORDER WHERE idOrder='{0}';", idPed); ConnectioDB.ExecuteNonQuery(sql); }
public static void eliminar(string prod) { string sql = String.Format( "DELETE FROM PRODUCT WHERE name='{0}';", prod); ConnectioDB.ExecuteNonQuery(sql); }
public static void eliminar(string uname) { string sql = String.Format( "DELETE FROM APPUSER WHERE username='******';", uname); ConnectioDB.ExecuteNonQuery(sql); }
public static void actualizarContra(string usuario, string nuevaContra) { string sql = String.Format( "UPDATE APPUSER set password='******' where username='******';", nuevaContra, usuario); ConnectioDB.ExecuteNonQuery(sql); }
public static void eliminar(string prod) { string sql = String.Format( "DELETE FROM ADDRESS WHERE address='{0}';", prod); ConnectioDB.ExecuteNonQuery(sql); }
public static void actualizar(string dir, int idUser) { string sql = String.Format( "UPDATE ADDRESS SET address='{0}' WHERE iduser = {1};", dir, idUser); ConnectioDB.ExecuteNonQuery(sql); }
public static void Nuevo(string nombre, string desc) { string sql = String.Format( "INSERT INTO BUSINESS(name, description) " + "VALUES('{0}', '{1}');", nombre, desc); ConnectioDB.ExecuteNonQuery(sql); }
public static void Nuevo(DateTime fecha, int idprod, int iddir) { string sql = String.Format( "INSERT INTO APPORDER(createDate, idProduct, idAddress) " + "VALUES('{0}', {1}, {2});", fecha, idprod, iddir); ConnectioDB.ExecuteNonQuery(sql); }
public static void Nuevo(int idprod, string nombre) { string sql = String.Format( "INSERT INTO Product(idbusiness, name) " + "VALUES({0}, '{1}');", idprod, nombre); ConnectioDB.ExecuteNonQuery(sql); }
public static void Nuevo(string name, string uname, string passwd, bool admin) { string sql = String.Format( "INSERT INTO APPUSER(fullname, username, password, userType) " + "VALUES('{0}', '{1}', '{2}' , {3});", name, uname, passwd, admin ? "true" : "false"); ConnectioDB.ExecuteNonQuery(sql); }
public static void Nuevo(int idUser, string dir) { string sql = String.Format( "INSERT INTO ADDRESS(iduser, address) " + "VALUES({0}, '{1}');", idUser, dir); ConnectioDB.ExecuteNonQuery(sql); }