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