public static void Eliminar(int iduser) { string sql = String.Format( "DELETE FROM ADDRESS WHERE idUser = {0}; " + "DELETE FROM APPUSER WHERE idUser ={0};", iduser); Conexion.realizarAccion(sql); }
public static void Eliminar(int idorder) { string sql = String.Format( "DELETE FROM APPORDER WHERE idOrder = {0}; ", idorder); Conexion.realizarAccion(sql); }
public static void Eliminar(int idProduct) { string sql = String.Format( "DELETE FROM APPORDER WHERE idProduct = {0}; " + "DELETE FROM PRODUCT WHERE idProduct = {0}; ", idProduct); Conexion.realizarAccion(sql); }
public static void Eliminar(int idaddress) { string sql = String.Format( "DELETE FROM APPORDER WHERE idAddress = {0}; " + "DELETE FROM ADDRESS WHERE idAddress = {0}; ", idaddress); Conexion.realizarAccion(sql); }
public static void Eliminar(int idBusiness) { string sql = String.Format( "DELETE FROM PRODUCT WHERE idBusiness = {0}; " + "DELETE FROM BUSINESS WHERE idBusiness = {0}; ", idBusiness); Conexion.realizarAccion(sql); }
public static void ModificarContra(string username, string newcontra) { string sql = String.Format("UPDATE APPUSER SET password = '******' WHERE username = '******';", newcontra, username); Conexion.realizarAccion(sql); }
public static void Agregar(int idproduct, int address, string date) { string sql = String.Format("INSERT INTO APPORDER(createDate, idProduct, idAddress)" + "VALUES('{0}', {1},{2});", date, idproduct, address); Conexion.realizarAccion(sql); }
public static void Agregar(int idBusiness, string name) { string sql = String.Format("INSERT INTO PRODUCT(idBusiness, name)" + "VALUES({0}, '{1}');", idBusiness, name); Conexion.realizarAccion(sql); }
public static void Agregar(int iduser, string address) { string sql = String.Format("INSERT INTO ADDRESS(idUser, address)" + "VALUES({0}, '{1}');", iduser, address); Conexion.realizarAccion(sql); }
public static void Agregar(string name, string des) { string sql = String.Format("INSERT INTO BUSINESS(name, description)" + "VALUES('{0}', '{1}');", name, des); Conexion.realizarAccion(sql); }