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