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