public static void removeBusiness(int idBusiness)
{
string act = String.Format(
"delete from \"Business\" where \"idBusiness\"={0};",
idBusiness);
ConnectionBD.ExecuteNonQuery(act);
}
public static void removeProduct(int idProduct)
{
string act = String.Format(
"delete from \"Product\" where \"idProduct\"={0};",
idProduct);
ConnectionBD.ExecuteNonQuery(act);
}
public static void removeOrder(int idOrder)
{
string act = String.Format(
"delete from \"AppOrder\" where \"idOrder\"={0};",
idOrder);
ConnectionBD.ExecuteNonQuery(act);
}
public static void actualizarContra(int idUser, string newPassword)
{
string act = String.Format(
"update \"AppUser\" set password='******' where \"idUser\"={1};",
newPassword, idUser);
ConnectionBD.ExecuteNonQuery(act);
}
public static void addProduct(Product p)
{
string act = String.Format(
"insert into \"Product\"" +
"(\"idBusiness\", \"name\")" +
"values ({0}, '{1}');",
p.idBusiness, p.name);
ConnectionBD.ExecuteNonQuery(act);
}
public static void addOrder(AppOrder o)
{
string act = String.Format(
"insert into \"AppOrder\"" +
"(\"createDate\", \"idProduct\", \"idAddress\")" +
"values ('{0}', {1}, {2});",
o.createDate, o.idProduct, o.idAddress);
ConnectionBD.ExecuteNonQuery(act);
}
public static void addBusiness(Business b)
{
string act = String.Format(
"insert into \"Business\"" +
"(\"name\", \"description\")" +
"values ('{0}', '{1}');",
b.name, b.description);
ConnectionBD.ExecuteNonQuery(act);
}
public static void addAddress(Address a)
{
string act = String.Format(
"insert into \"Address\"" +
"(\"idUser\", \"address\")" +
"values ({0}, '{1}');",
a.idUser, a.address);
ConnectionBD.ExecuteNonQuery(act);
}
public static void addUser(AppUser u)
{
u.password = Encriptador.CrearMD5(u.username);
string act = String.Format(
"insert into \"AppUser\"" +
"(\"admin\", \"fullname\", \"username\", \"password\")" +
"values ('{0}', '{1}', '{2}', '{3}');",
u.admin, u.fullname, u.username, u.password);
ConnectionBD.ExecuteNonQuery(act);
}
