public static void actualizarContra(string usuario, string nuevaContra)
{
string sql = String.Format(
"update APPUSER set password='******' where username='******';",
nuevaContra, usuario);
ConnectionBD.ExecuteNonQuery(sql);
}
public static List <Product> getLista()
{
string sql = "select * from PRODUCT ";
DataTable dt = ConnectionBD.ExecuteQuery(sql);
List <Product> listaa = new List <Product>();
foreach (DataRow fila in dt.Rows)
{
Product b = new Product();
b.name = fila[2].ToString();
listaa.Add(b);
}
return(listaa);
}
public static List <Business> getLista()
{
string sql = "select * from BUSINESS";
DataTable dt = ConnectionBD.ExecuteQuery(sql);
List <Business> listab = new List <Business>();
foreach (DataRow fila in dt.Rows)
{
Business b = new Business();
b.name = fila[1].ToString();
listab.Add(b);
}
return(listab);
}
public static List <Usuario> getLista()
{
string sql = "select * from APPUSER where activo=true";
DataTable dt = ConnectionBD.ExecuteQuery(sql);
List <Usuario> lista = new List <Usuario>();
foreach (DataRow fila in dt.Rows)
{
Usuario u = new Usuario();
u.fullname = fila[1].ToString();
u.username = fila[2].ToString();
u.password = Convert.ToString(fila[3].ToString());
u.userType = Convert.ToBoolean(fila[4].ToString());
lista.Add(u);
}
return(lista);
}
