public static void actualizarDireccion(string newadress, string adress)
{
string sql = String.Format(
"update adress set address='{0}' where idadress ='{1}';",
newadress, adress);
ConexionDB.RealizarAccion(sql);
}
public static void actualizarContra(string username, string newpassword)
{
string sql = String.Format(
"update appuser set password='******' where iduser ='******';",
newpassword, username);
ConexionDB.RealizarAccion(sql);
}
public static void eliminar(string idbusiness)
{
string sql = String.Format(
"delete from product where idbusiness ='{0}'; " +
"delete from business where idbusiness ='{0}';",
idbusiness);
ConexionDB.RealizarAccion(sql);
}
public static void crearNuevo(string name, string description)
{
string sql = String.Format(
"insert into business(name,description) " +
"values('{0}', '{1}');",
name, description);
ConexionDB.RealizarAccion(sql);
}
public static void eliminar(string idorder)
{
string sql = String.Format(
"delete from apporder where idorder ='{0}';",
idorder);
ConexionDB.RealizarAccion(sql);
}
public static void crearNuevo(string Fecha, string idproduct, string idaddress)
{
string sql = String.Format(
"insert into apporder(createDate,idproduct,idadress) " +
"values('{0}','{1}','{2}');",
Fecha, idproduct, idaddress);
ConexionDB.RealizarAccion(sql);
}
public static void crearNuevo(string iduser, string address)
{
string sql = String.Format(
"insert into adress(iduser, address) " +
"values('{0}', '{1}');",
iduser, address);
ConexionDB.RealizarAccion(sql);
}
public static void eliminar(string username)
{
string sql = String.Format(
"delete from adress where iduser ='******'; " +
"delete from appuser where iduser ='******';",
username);
ConexionDB.RealizarAccion(sql);
}
public static void crearNuevo(string fullname, string username)
{
string sql = String.Format(
"insert into appuser(fullname, username, password, usertype) " +
"values('{0}', '{1}', '{2}', false);",
fullname, username, Encriptador.CrearMD5(username));
ConexionDB.RealizarAccion(sql);
}
public static void eliminar(string idproduct)
{
string sql = String.Format(
"delete from apporder where idproduct = {0}; " +
"delete from product where idproduct= {0}; ",
idproduct);
ConexionDB.RealizarAccion(sql);
}
public static void crearNuevo(string idbusiness, string name)
{
string sql = String.Format(
"insert into product( idbusiness, name) " +
"values('{0}', '{1}');",
idbusiness, name);
ConexionDB.RealizarAccion(sql);
}
