public static List <Product> getLista(int idBusiness) { string sql = String.Format("SELECT p.idProduct, p.name FROM PRODUCT p WHERE idBusiness = {0}", idBusiness); DataTable dt = Conexion.realizarConsulta(sql); List <Product> lista = new List <Product>(); foreach (DataRow fila in dt.Rows) { Product p = new Product(); p.idProduct = Convert.ToInt32(fila[0]); p.name = fila[1].ToString(); lista.Add(p); } return(lista); }
public static List <Address> getLista(int iduser) { string sql = String.Format("SELECT ad.idAddress, ad.address FROM ADDRESS ad WHERE idUser = {0}", iduser); DataTable dt = Conexion.realizarConsulta(sql); List <Address> lista = new List <Address>(); foreach (DataRow fila in dt.Rows) { Address a = new Address(); a.idAddress = Convert.ToInt32(fila[0]); a.address = fila[1].ToString(); lista.Add(a); } return(lista); }
public static List <Business> getLista() { string sql = String.Format("SELECT * FROM BUSINESS"); DataTable dt = Conexion.realizarConsulta(sql); List <Business> lista = new List <Business>(); foreach (DataRow fila in dt.Rows) { Business b = new Business(); b.idBusiness = Convert.ToInt32(fila[0]); b.name = fila[1].ToString(); b.description = fila[2].ToString(); lista.Add(b); } return(lista); }
public static List <Order> getLista() { string sql = String.Format("SELECT ao.idOrder, ao.createDate, pr.name, au.fullname, ad.address FROM APPORDER ao, ADDRESS ad, PRODUCT pr, APPUSER au WHERE ao.idProduct = pr.idProduct AND ao.idAddress = ad.idAddress AND ad.idUser = au.idUser;"); DataTable dt = Conexion.realizarConsulta(sql); List <Order> lista = new List <Order>(); foreach (DataRow fila in dt.Rows) { Order o = new Order(); o.idOrder = Convert.ToInt32(fila[0]); o.createDate = fila[1].ToString(); o.name = fila[2].ToString(); o.fullname = fila[3].ToString(); o.address = fila[4].ToString(); lista.Add(o); } return(lista); }
public static List <Usuario> getLista() { string sql = "SELECT * FROM APPUSER;"; DataTable dt = Conexion.realizarConsulta(sql); List <Usuario> lista = new List <Usuario>(); foreach (DataRow fila in dt.Rows) { Usuario u = new Usuario(); u.idUser = Convert.ToInt32(fila[0].ToString()); u.fullname = fila[1].ToString(); u.username = fila[2].ToString(); u.password = fila[3].ToString(); u.userType = fila[4].ToString(); lista.Add(u); } return(lista); }
private void button1_Click(object sender, EventArgs e) { try { if (textBox2.Text == "") { throw new EmptyException("Campos Vacios"); } if (comboBox1.SelectedValue.Equals(textBox2.Text)) { Usuario u = (Usuario)comboBox1.SelectedItem; if (u.userType.Equals("True")) { MessageBox.Show("¡Bienvenido!", "Hugo", MessageBoxButtons.OK, MessageBoxIcon.Information); Administrador form = new Administrador(); form.Show(); this.Hide(); } else { string query = $"SELECT idUser FROM APPUSER WHERE username ='******';"; var dt = Conexion.realizarConsulta(query); var dr = dt.Rows[0]; int idUser = Convert.ToInt32(dr[0].ToString()); MessageBox.Show("¡Bienvenido!", "Hugo", MessageBoxButtons.OK, MessageBoxIcon.Information); Normal form = new Normal(idUser); form.Show(); this.Hide(); } } else { MessageBox.Show("¡Contraseña incorrecta!", "Hugo", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } catch (EmptyException exception) { MessageBox.Show("Ingrese todos los campos solicitados", exception.Message, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }