private void button1_Click(object sender, EventArgs e)
{
try
{
bool verify = true;
String type = "";
var tab = ConnectionDB.ExecuteQuery("SELECT name FROM BUSINESS");
var names = new List <String>();
foreach (DataRow dr in tab.Rows)
{
names.Add(dr[0].ToString());
}
foreach (String bar in names)
{
if (bar.Equals(textBox1.Text))
{
MessageBox.Show("El negocio ya esta registrado");
verify = false;
}
}
if (verify)
{
ConnectionDB.ExecuteNonQuery("INSERT INTO BUSINESS(name, description)" +
$"VALUES ('{textBox1.Text}', '{textBox2.Text}');");
MessageBox.Show("Negocio ingresado exitosamente.");
}
}
catch (Exception ex)
{
Console.WriteLine("Ha ocurrido un error");
throw;
}
}
private void btnAgregar_Click_1(object sender, EventArgs e)
{
var dataUser = ConnectionDB.ExecuteQuery(("SELECT * FROM APPUSER"));
if (dataUser == null || txtAgregar.Text.Equals(""))
{
MessageBox.Show("Verifica los datos por favor");
}
else
{
try
{
var User = ConnectionDB.ExecuteQuery("SELECT idUser FROM APPUSER " +
$"WHERE username='******'");
var idUser = User.Rows[0];
string NonQuery = "INSERT INTO ADDRESS(idUser,address) " +
$"VALUES({Convert.ToInt32(idUser[0])},'{txtAgregar.Text}')";
ConnectionDB.ExecuteNonQuery(NonQuery);
MessageBox.Show("Nueva direccion agregada");
}
catch (Exception)
{
MessageBox.Show("Direccion no agregada, intente mas tarde");
}
}
}
private void btnCrearProducct_Click(object sender, EventArgs e)
{
try
{
var dataBusiness = ConnectionDB.ExecuteQuery("SELECT * FROM BUSINESS");
if (dataBusiness == null || txtCrearProduct.Text.Equals(""))
{
MessageBox.Show($"Por favor rellena de manera correcta los datos{"ARG"}");
}
else
{
string Query = "SELECT idBusiness " +
"FROM BUSINESS " +
$"WHERE name='{cbNegociosProduct.SelectedItem}'";
var dataIdBusiness = ConnectionDB.ExecuteQuery(Query);
var IdBusiness = dataIdBusiness.Rows[0];
string NonQuery = "INSERT INTO PRODUCT(idBusiness,name) " +
$"VALUES({Convert.ToInt32(IdBusiness[0])},'{txtCrearProduct.Text}')";
ConnectionDB.ExecuteNonQuery(NonQuery);
MessageBox.Show("Agregado");
}
}
catch (Exception)
{
MessageBox.Show("Ha ocurrido un error");
}
}
private void btnActualizarPedidos_Click(object sender, EventArgs e)
{
try
{
var UserTable = ConnectionDB.ExecuteQuery($"SELECT idUser FROM APPUSER WHERE username='******'");
var UserRow = UserTable.Rows[0];
var idNew = Convert.ToInt32(UserRow[0]);
var Address =
ConnectionDB.ExecuteQuery("SELECT idAddress FROM ADDRESS " +
$"WHERE idUser={Convert.ToInt32(UserRow[0])}");
var idAddress = Address.Rows[0];
var idOrder = ConnectionDB.ExecuteQuery("SELECT idOrder FROM APPORDER " +
$"WHERE idAddress={Convert.ToInt32(idAddress[0])}");
var idCombo = new List <int>();
foreach (DataRow id in idOrder.Rows)
{
idCombo.Add(Convert.ToInt32(id[0]));
}
cbEliminar.DataSource = idCombo;
}
catch (Exception)
{
MessageBox.Show("Ha ocurrido un error");
}
}
private void admin()
{
try
{
//DATA GRID VIEW APPORDER
var dt2 = ConnectionDB.ExecuteQuery($"SELECT ord.idOrder, use.fullname, nego.name, pro.name, " +
$"dir.address " +
"FROM APPORDER ord, APPUSER use, BUSINESS nego, PRODUCT pro, ADDRESS dir " +
$"WHERE use.idUser = dir.idUser " +
$"AND pro.idProduct = ord.idProduct " +
$"AND dir.idAddress = ord.idAddress");
dgrOrdenes.DataSource = dt2;
//DATA GRID WIEW BUSINESS
var dt = ConnectionDB.ExecuteQuery("SELECT * FROM BUSINESS");
dgrNegocios.DataSource = dt;
//DATA GRID WIEW PRODUCT
var dt3 = ConnectionDB.ExecuteQuery("SELECT * FROM PRODUCT");
dgrProductos.DataSource = dt3;
//DATA GRID WIEW APPUSER
var dt4 = ConnectionDB.ExecuteQuery("SELECT * FROM APPUSER");
dgrUsuarios.DataSource = dt4;
}catch (Exception ex)
{
MessageBox.Show("Ha ocurrido un error");
}
}
private void btnActualizarDirecciones_Click(object sender, EventArgs e)
{
try {
var idUserTable = ConnectionDB.ExecuteQuery($"SELECT idUser FROM APPUSER WHERE username= '******'");
var idUser = idUserTable.Rows[0];
string Query = "SELECT address " +
"FROM ADDRESS " +
$"WHERE idUser='******'";
var Address = ConnectionDB.ExecuteQuery(Query);
var AddressCombo = new List <string>();
foreach (DataRow addressRow in Address.Rows)
{
AddressCombo.Add(addressRow[0].ToString());
}
cbEliminarDireccion.DataSource = AddressCombo;
}catch (Exception)
{
MessageBox.Show("Ha ocurrido un error");
}
}
private void TabPedidos_Load(object sender, EventArgs e)
{
var dataProduct = ConnectionDB.ExecuteQuery("SELECT name FROM PRODUCT");
var productCombo = new List <string>();
foreach (DataRow dr in dataProduct.Rows)
{
productCombo.Add(dr[0].ToString());
}
cbOrdenar.DataSource = productCombo;
}
private void btnActualizarDir_Click(object sender, EventArgs e)
{
var dateId = ConnectionDB.ExecuteQuery($"SELECT idUser FROM APPUSER WHERE username='******'");
var idUser = dateId.Rows[0];
string Query = "SELECT address " +
"FROM ADDRESS " +
$"WHERE idUser='******'";
var dataAddress = ConnectionDB.ExecuteQuery(Query);
dataGridView2.DataSource = dataAddress;
}
private void AgregarProducto_Load(object sender, EventArgs e)
{
var business = ConnectionDB.ExecuteQuery("SELECT name FROM BUSINESS");
var businessComboBox = new List <String>();
foreach (DataRow dr in business.Rows)
{
businessComboBox.Add(dr[0].ToString());
}
comboBox1.DataSource = businessComboBox;
}
private void button1_Click(object sender, EventArgs e)
{
try
{
var dt = ConnectionDB.ExecuteQuery($"SELECT ad.idAddress, ad.address FROM ADDRESS ad WHERE idUser = {Convert.ToInt32(textBox1.Text)};");
dataGridView1.DataSource = dt;
MessageBox.Show("Datos obtenidos exitosamente");
}
catch (Exception ex)
{
MessageBox.Show("Ha ocurrido un error");
}
}
private void btnActualizar_Click(object sender, EventArgs e)
{
var dataApporder = ConnectionDB.ExecuteQuery("SELECT idUser FROM APPUSER " +
$"WHERE username='******'");
var iduser = dataApporder.Rows[0];
var dataAddress = ConnectionDB.ExecuteQuery("SELECT idAddress FROM ADDRESS " +
$"WHERE idUser={Convert.ToInt32(iduser[0])}");
var address = dataAddress.Rows[0];
var dataApp = ConnectionDB.ExecuteQuery("SELECT * FROM APPORDER " +
$"WHERE idAddress={Convert.ToInt32(address[0])}");
dataGridView1.DataSource = dataApp;
}
private void btnVerDirecciones_Click(object sender, EventArgs e)
{
try
{
string query2 = $"SELECT idUser FROM APPUSER WHERE username = '******'";
var dt2 = ConnectionDB.ExecuteQuery(query2);
var dr2 = dt2.Rows[0];
var idUser = Convert.ToInt32(dr2[0].ToString());
var dt = ConnectionDB.ExecuteQuery($"SELECT * FROM ADDRESS WHERE idUser = {idUser}");
dgrDireccion.DataSource = dt;
}catch (Exception ex)
{
MessageBox.Show("Ha ocurrido un error");
}
}
//boton actualizar todas las ordenes
private void button1_Click(object sender, EventArgs e)
{
try
{
string Query = "SELECT pro.name " +
"FROM PRODUCT pro, APPORDER appo " +
"WHERE pro.idproduct=appo.idproduct ";
var dataApporder = ConnectionDB.ExecuteQuery(Query);
dataGridView1.DataSource = dataApporder;
}
catch (Exception)
{
MessageBox.Show("Ha ocurrido un error");
}
}
public static DataTable userVerDirecciones(Usuario u)
{
DataTable dt = null;
try
{
dt = ConnectionDB.ExecuteQuery(string.Format("SELECT ad.idAddress, ad.idUser, ad.address FROM ADDRESS ad, APPUSER us " +
"WHERE us.username = '******' and ad.idUser = us.idUser ", u.username));
}
catch (Exception)
{
return(null);
}
return(dt);
}
private void FrmPrincipal_Load(object sender, EventArgs e)
{
label1.Text = "Bienvenido " + user.user + " [" + (user.admin ? "Administrador" : "Usuario") + "]";
if (user.admin)
{
admin();
tabControl1.TabPages[0].Parent = null;
tabControl1.TabPages[0].Parent = null;
}
else
{
tabControl1.TabPages[2].Parent = null;
tabControl1.TabPages[2].Parent = null;
tabControl1.TabPages[2].Parent = null;
tabControl1.TabPages[2].Parent = null;
}
var products = ConnectionDB.ExecuteQuery("SELECT name FROM PRODUCT");
var productsCombo = new List <string>();
foreach (DataRow dr in products.Rows)
{
productsCombo.Add(dr[0].ToString());
}
cmbProductos.DataSource = productsCombo;
string user2 = this.user.user;
try
{
var dt = ConnectionDB.ExecuteQuery($"SELECT ord.idOrder, use.username, nego.name, pro.name, " +
$"dir.address " +
"FROM APPORDER ord, APPUSER use, BUSINESS nego, PRODUCT pro, ADDRESS dir " +
$"WHERE use.idUser = dir.idUser " +
$"AND pro.idProduct = ord.idProduct " +
$"AND dir.idAddress = ord.idAddress " +
$"AND use.username = '******'");
dgrPedidos.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show("Ha ocurrido un error");
}
}
public static DataTable adminVerPedidos()
{
DataTable dt = null;
try
{
dt = ConnectionDB.ExecuteQuery("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;");
}
catch (Exception)
{
return(null);
}
return(dt);
}
private void button1_Click(object sender, EventArgs e)
{
try
{
string Query = "SELECT password FROM APPUSER " +
$"WHERE username='******'";
var dataPass = ConnectionDB.ExecuteQuery(Query);
var userPass = dataPass.Rows[0];
if (!userPass[0].ToString().Equals(txtContraseña.Text) || txtContraseña.Text.Equals(""))
{
MessageBox.Show("Ingresa los datos de manera");
}
else
{
Query = "SELECT userType FROM APPUSER " +
$"WHERE username='******'";
var dataType = ConnectionDB.ExecuteQuery(Query);
var userType = dataType.Rows[0];
bool admin = Convert.ToBoolean(userType[0]);
if (admin)
{
AdminUser newAdminUser = new AdminUser(cbUsuarios.SelectedItem.ToString());
newAdminUser.Show();
Hide();
}
else
{
NormalUser newUser = new NormalUser(cbUsuarios.SelectedItem.ToString());
newUser.Show();
Hide();
}
}
}
catch (Exception)
{
MessageBox.Show("Ocurrio un error");
}
}
private void Ordenes_Load(object sender, EventArgs e)
{
try
{
var dt = ConnectionDB.ExecuteQuery("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;");
dataGridView1.DataSource = dt;
MessageBox.Show("Datos obtenidos exitosamente");
}
catch (Exception ex)
{
MessageBox.Show("Ha ocurrido un error");
}
}
private void btnEliminarDireccion_Click(object sender, EventArgs e)
{
try
{
string Query = "SELECT adr.idAddress " +
$"FROM ADDRESS adr, APPUSER apu " +
$"WHERE adr.address='{cbEliminarDireccion.SelectedItem}' AND apu.username='******'";
var tableIdAddress = ConnectionDB.ExecuteQuery(Query);
var idAddress = tableIdAddress.Rows[0];
ConnectionDB.ExecuteNonQuery($"DELETE FROM ADDRESS WHERE idAddress='{Convert.ToInt32(idAddress[0])}'");
MessageBox.Show("Direccion eliminada");
}
catch (Exception)
{
MessageBox.Show("No se pudo eliminar esta direccion");
}
}
public static DataTable verMisOrdenes(Usuario us)
{
DataTable dt = null;
try
{
dt = ConnectionDB.ExecuteQuery(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 AND au.idUser = {0};",
us.idUser));
}
catch (Exception)
{
return(null);
}
return(dt);
}
private void btnEliminarProducto_Click(object sender, EventArgs e)
{
try
{
string query2 = $"SELECT idProduct FROM PRODUCT WHERE name = '{txtNombreProducto.Text.ToString()}'";
var dt2 = ConnectionDB.ExecuteQuery(query2);
var dr2 = dt2.Rows[0];
var idProduct = Convert.ToInt32(dr2[0].ToString());
string nonQuery = $"DELETE FROM PRODUCT WHERE idProduct = {idProduct}";
ConnectionDB.ExecuteNonQuery(nonQuery);
MessageBox.Show("Se ha eliminado el producto");
}catch (Exception ex)
{
MessageBox.Show("Ha ocurrido un error");
}
}
private void btnEliminarNegocio_Click(object sender, EventArgs e)
{
try
{
string query2 = $"SELECT idBusiness FROM BUSINESS WHERE name = '{txtNegocio.Text.ToString()}'";
var dt2 = ConnectionDB.ExecuteQuery(query2);
var dr2 = dt2.Rows[0];
var idBusiness = Convert.ToInt32(dr2[0].ToString());
string nonQuery = $"DELETE FROM BUSINESS WHERE idBusiness = {idBusiness}";
ConnectionDB.ExecuteNonQuery(nonQuery);
MessageBox.Show("Se ha eliminado su negocio");
}catch (Exception ex)
{
MessageBox.Show("Ha ocurrido un error");
}
}
private void btnEliminarDireccion_Click(object sender, EventArgs e)
{
try
{
string query2 = $"SELECT idAddress FROM ADDRESS WHERE address = '{txtDireccionEliminar.Text.ToString()}'";
var dt2 = ConnectionDB.ExecuteQuery(query2);
var dr2 = dt2.Rows[0];
var idAddress = Convert.ToInt32(dr2[0].ToString());
string nonQuery = $"DELETE FROM ADDRESS WHERE idAddress = {idAddress}";
ConnectionDB.ExecuteNonQuery(nonQuery);
MessageBox.Show("Se ha eliminado su dirección");
}catch (Exception ex)
{
MessageBox.Show("Ha ocurrido un error");
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
bool verify = true;
String type = "";
var tab = ConnectionDB.ExecuteQuery("SELECT username FROM APPUSER");
var usernames = new List <String>();
foreach (DataRow dr in tab.Rows)
{
usernames.Add(dr[0].ToString());
}
foreach (String bar in usernames)
{
if (bar.Equals(textBox1.Text))
{
MessageBox.Show("El usuario ya esta registrado");
verify = false;
}
}
if (comboBox1.SelectedIndex == 0)
{
type = "false";
}
else
{
type = "true";
}
if (verify)
{
ConnectionDB.ExecuteNonQuery("INSERT INTO APPUSER(fullname, username, password, userType)" +
$"VALUES('{textBox2.Text}', '{textBox1.Text}', '{textBox1.Text}', {type});");
MessageBox.Show("Usuario ingresado exitosamente.");
}
}
catch (Exception ex)
{
Console.WriteLine("Ha ocurrido un error");
throw;
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
bool verify = true;
String type = "";
var tab = ConnectionDB.ExecuteQuery("SELECT name FROM PRODUCT");
var names = new List <String>();
foreach (DataRow dr in tab.Rows)
{
names.Add(dr[0].ToString());
}
foreach (String bar in names)
{
if (bar.Equals(textBox1.Text))
{
MessageBox.Show("El producto ya esta registrado");
verify = false;
}
}
var tabl = ConnectionDB.ExecuteQuery("SELECT idbusiness FROM BUSINESS");
var ids = new List <int>();
foreach (DataRow dr in tabl.Rows)
{
ids.Add(Convert.ToInt32(dr[0].ToString()));
}
int number = ids[comboBox1.SelectedIndex];
if (verify)
{
ConnectionDB.ExecuteNonQuery("INSERT INTO PRODUCT(idBusiness, name)" +
$"VALUES({number}, '{textBox1.Text}');");
MessageBox.Show("Producto ingresado exitosamente.");
}
}
catch (Exception ex)
{
Console.WriteLine("Ha ocurrido un error");
throw;
}
}
private void btnEliminarUsuario_Click(object sender, EventArgs e)
{
try
{
string query = $"SELECT idUser FROM APPUSER WHERE username = '******'";
var dt = ConnectionDB.ExecuteQuery(query);
var dr = dt.Rows[0];
var idUser = Convert.ToInt32(dr[0].ToString());
string nonQuery = $"DELETE FROM APPUSER WHERE idUser = {idUser}";
ConnectionDB.ExecuteNonQuery(nonQuery);
MessageBox.Show("Se ha eliminado al usuario correctamente");
}
catch (Exception ex)
{
MessageBox.Show("Ha ocurrido un error");
}
}
private void btnActProducto_Click(object sender, EventArgs e)
{
try
{
var dataBusiness = ConnectionDB.ExecuteQuery("SELECT name FROM BUSINESS");
var BusinessCombo = new List <string>();
foreach (DataRow dataUsersRow in dataBusiness.Rows)
{
BusinessCombo.Add(dataUsersRow[0].ToString());
}
cbNegociosProduct.DataSource = BusinessCombo;
}
catch (Exception)
{
MessageBox.Show("Ocurrio un error");
}
}
private void btnActualizarProduct_Click(object sender, EventArgs e)
{
try
{
var dateProduct = ConnectionDB.ExecuteQuery("SELECT name FROM PRODUCT");
var ProductCombo = new List <string>();
foreach (DataRow dataUsersRow in dateProduct.Rows)
{
ProductCombo.Add(dataUsersRow[0].ToString());
}
cbElimProduct.DataSource = ProductCombo;
}
catch (Exception)
{
MessageBox.Show("Ocurrio un error");
}
}
public static List <Negocio> getLista()
{
string sql = "select * from business";
DataTable dt = ConnectionDB.ExecuteQuery(sql);
List <Negocio> lista = new List <Negocio>();
foreach (DataRow fila in dt.Rows)
{
Negocio business = new Negocio();
business.idBusiness = Convert.ToInt32(fila[0].ToString());
business.name = fila[1].ToString();
business.descripcion = fila[2].ToString();
lista.Add(business);
}
return(lista);
}
private void Login_Load(object sender, EventArgs e)
{
try
{
var dataUsers = ConnectionDB.ExecuteQuery("SELECT username FROM APPUSER");
var UserCombo = new List <string>();
foreach (DataRow dataUsersRow in dataUsers.Rows)
{
UserCombo.Add(dataUsersRow[0].ToString());
}
cbUsuarioNew.DataSource = UserCombo;
}
catch (Exception)
{
MessageBox.Show("Ocurrio un error");
}
}