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