private void button10_Click(object sender, EventArgs e)
{
try
{
string query = $"SELECT id_product FROM product WHERE name ='{comboBox6.Text}'";
var dt = ConnectionDB.ExecuteQuery(query);
var dr = dt.Rows[0];
var iduser = Convert.ToInt32(dr[0].ToString());
string query2 = $"SELECT id_address FROM address WHERE address ='{comboBox8.Text}'";
var dt2 = ConnectionDB.ExecuteQuery(query2);
var dr2 = dt2.Rows[0];
var idaddress = Convert.ToInt32(dr2[0].ToString());
ConnectionDB.ExecuteNonQuery($"INSERT INTO apporder(createdate, id_product, id_address) VALUES(" +
$"'{type.dia}'," +
$"{iduser}," +
$"{idaddress})");
MessageBox.Show("Orden Registrada");
DatosProduct();
DatosOrden();
DatosAddress();
}
catch (Exception)
{
MessageBox.Show("Ha ocurrido un error");
}
}
private void button7_Click(object sender, EventArgs e) //Agregar Productos
{
if (textBox3.Text.Equals(""))
{
MessageBox.Show("Digite los datos pedidos !");
}
else
{
try
{
var query2 = ConnectionDB.ExecuteQuery("select idbusiness from business " +
$"WHERE name ='{comboBox1.Text}'");
var query3 = query2.Rows[0];
var query4 = Convert.ToInt32(query3[0].ToString());
var query = "";
query = "INSERT INTO product(idBusiness,name)" +
$"VALUES ('{query4}', '{textBox3.Text}')";
ConnectionDB.ExecuteNonQuery(query);
MessageBox.Show("Producto Agregado");
}
catch (Exception exception)
{
MessageBox.Show("No se ha agregado");
throw;
}
}
}
public static void crearNuevo(int id, string direccion)
{
string nonQuery = String.Format("INSERT INTO address(idUser, address) " +
$"VALUES({id}, '{direccion}')");
ConnectionDB.ExecuteNonQuery(nonQuery);
}
private void button13_Click_1(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Esta seguro de CERRAR DIA ?", "Corte de caja", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
//Insertando ganancias en T3
try
{
ConnectionDB.ExecuteNonQuery($"INSERT INTO GANANCIADIA (select current_date, SUM(ganancia)FROM GANANCIADIAARTICULO);");
}
catch (Exception exception)
{
MessageBox.Show("Ha ocurrido un error actualizando suma de ganancias");
}
//Vaciando datos de T2
try
{
ConnectionDB.ExecuteNonQuery($"truncate table GANANCIADIAARTICULO;");
MessageBox.Show("Se ha cortado caja!!");
}
catch (Exception exception)
{
MessageBox.Show("Ha ocurrido un error BORRANDO T2");
}
}
}
public static void hacerOrden(string time, Product pro, Address ad)
{
var sql = string.Format("INSERT INTO APPORDER(createDate, idProduct, idAddress) " +
" VALUES('{0}', {1}, {2});", time, pro.idproduct, ad.addressID);
ConnectionDB.ExecuteNonQuery(sql);
}
private void button6_Click(object sender, EventArgs e) //nueva orden
{
try
{
var query2 = ConnectionDB.ExecuteQuery("select idproduct from product " +
$"WHERE name ='{comboBox7.Text}'");
var query3 = query2.Rows[0];
var query4 = Convert.ToInt32(query3[0].ToString());
var add = ConnectionDB.ExecuteQuery("select idaddress from address " +
$"WHERE address ='{comboBox2.Text}'");
var addre = add.Rows[0];
var address = Convert.ToInt32(addre[0].ToString());
var query = "";
query = "INSERT INTO APPORDER(createDate, idProduct, idAddress)" +
$" VALUES('{DateTime.UtcNow.ToString("d")}','{query4}','{address}')";
ConnectionDB.ExecuteNonQuery(query);
MessageBox.Show("Se ha hecho el pedido");
}
catch (Exception exception)
{
MessageBox.Show("No se ha hecho el pedido");
throw;
}
}
private void button5_Click(object sender, EventArgs e)
{
if (textBox7.Text.Equals(""))
{
MessageBox.Show("No se pueden dejar campos vacios");
}
else
{
try
{
string query = $"SELECT id_business from business WHERE name ='{comboBox1.Text}'";
var dt = ConnectionDB.ExecuteQuery(query);
var dr = dt.Rows[0];
var iduser = Convert.ToInt32(dr[0].ToString());
ConnectionDB.ExecuteNonQuery($"INSERT INTO product(id_business, name) VALUES(" +
$"{iduser}," +
$"'{textBox7.Text}')");
MessageBox.Show("Producto Registrado");
DatosProduct();
DatosBusiness();
}
catch (Exception)
{
MessageBox.Show("Ha ocurrido un error");
}
}
}
public static void actualizarPassword(string user, string newPassword)
{
string nonQuery = String.Format($"UPDATE appuser SET password = '******' " +
$"WHERE username = '******'");
ConnectionDB.ExecuteNonQuery(nonQuery);
}
private void button5_Click(object sender, EventArgs e) //Actualizar contraseña
{
if (textBox5.Text.Equals(""))
{
MessageBox.Show("Ingrese la nueva contraseña por favor");
}
else
{
var query2 = ConnectionDB.ExecuteQuery("select iduser from appuser " +
$"WHERE username ='******'");
var query3 = query2.Rows[0];
var query4 = Convert.ToInt32(query3[0].ToString());
var NonQuery = $"UPDATE appuser SET password= '******' WHERE iduser= '******'";
try
{
ConnectionDB.ExecuteNonQuery(NonQuery);
MessageBox.Show("Contraseña Actualizada");
}
catch (Exception exception)
{
MessageBox.Show("Usuario no eliminado");
}
}
}
public static void crearNuevo(string nombre, string descripcion)
{
string nonQuery = String.Format("INSERT INTO business(name, description) " +
$"VALUES('{nombre}', '{descripcion}')");
ConnectionDB.ExecuteNonQuery(nonQuery);
}
private void button3_Click(object sender, EventArgs e) //actualizar la ubicacion
{
if (textBox2.Text.Equals(""))
{
MessageBox.Show("Ingrese los datos requeridos.");
}
else
{
try
{
var add = ConnectionDB.ExecuteQuery("select idaddress from address " +
$"WHERE address ='{comboBox4.Text}'");
var addre = add.Rows[0];
var address = Convert.ToInt32(addre[0].ToString());
var query = "";
query =
$"UPDATE ADDRESS SET address = '{textBox2.Text}' WHERE idAddress = '{address}'";
ConnectionDB.ExecuteNonQuery(query);
MessageBox.Show("Se ha actualizado la direccion");
}
catch (Exception exception)
{
MessageBox.Show("No se ha actualizado la direccion.");
throw;
}
}
}
public static void UpdateUserPassword(string userName, string newPassword)
{
var lista = UserNonQuery.getLista();
foreach (var user in lista)
{
if (userName.Equals(user.userName))
{
try
{
ConnectionDB.ExecuteNonQuery($"UPDATE APPUSER " +
$"SET password = '******' " +
$"WHERE username = '******' ");
MessageBox.Show("Se ha modificado la contrasena con exito!!!");
}
catch (Exception exception)
{
MessageBox.Show("Ha ocurrido un error");
}
}
else
{
MessageBox.Show("Usuario Incorrecto");
}
}
}
public static void crearNuevo(int id, string nombre)
{
string nonQuery = String.Format("INSERT INTO product(idBusiness, name) " +
$"VALUES({id}, '{nombre}')");
ConnectionDB.ExecuteNonQuery(nonQuery);
}
public static void addPro(Negocio neg, string desc)
{
var sql = string.Format("INSERT INTO PRODUCT(idBusiness, name) " +
" VALUES({0}, '{1}');", neg.idneg, desc);
ConnectionDB.ExecuteNonQuery(sql);
}
private void btnCambiarContra_Click(object sender, EventArgs e)
{
try
{
string query = $"SELECT password from appuser WHERE username ='******'";
var dt = ConnectionDB.ExecuteQuery(query);
var dr = dt.Rows[0];
var iduser = Convert.ToString(dr[0].ToString());
if (txtActual.Text.Equals(iduser) && txtNueva.Text.Equals(txtRepetir.Text))
{
string actualizar =
$"UPDATE appuser SET password = '******' WHERE password = '******'";
ConnectionDB.ExecuteNonQuery(actualizar);
MessageBox.Show("Se ha actualizado la contra");
}
else
{
MessageBox.Show("Datos incorrectos");
}
}
catch (Exception)
{
MessageBox.Show("Ha ocurrido un Error");
}
}
public static void agregarDireccion(Usuario us, string address)
{
string sql = string.Format("INSERT INTO ADDRESS(idUser, address) " +
" VALUES({0},'{1}');", us.userID, address);
ConnectionDB.ExecuteNonQuery(sql);
}
public static void modificar(int id, string nueva)
{
string nonQuery = String.Format($"UPDATE address SET address = '{nueva}' " +
$"WHERE idAddress = {id}");
ConnectionDB.ExecuteNonQuery(nonQuery);
}
private void button3_Click(object sender, EventArgs e)
{
if (textBox3.Text.Equals(""))
{
MessageBox.Show("Error no se puede dejar vacio");
}
else
{
try
{
string query = $"SELECT id_user from appuser WHERE username ='******'";
var dt = ConnectionDB.ExecuteQuery(query);
var dr = dt.Rows[0];
var iduser = Convert.ToInt32(dr[0].ToString());
ConnectionDB.ExecuteNonQuery($"INSERT INTO address(id_user, address) VALUES(" +
$"{iduser}," +
$"'{textBox3.Text}')");
MessageBox.Show("Dirección Registrada");
DatosAddress();
}
catch (Exception)
{
MessageBox.Show("Ha ocurrido un error");
}
}
}
public static void addUser(string nombre, string usuario)
{
string sql = string.Format("INSERT INTO appuser(fullname, username, password, usertype) " +
" VALUES('{0}', '{1}', '{2}', false)", nombre, usuario, nombre);
ConnectionDB.ExecuteNonQuery(sql);
}
private void button4_Click(object sender, EventArgs e) //Nueva direccion
{
if (textBox3.Text.Equals(""))
{
MessageBox.Show("ingrese los datos requeridos.");
}
else
{
try
{
var query2 = ConnectionDB.ExecuteQuery("select iduser from appuser " +
$"WHERE username ='******'");
var query3 = query2.Rows[0];
var query4 = Convert.ToInt32(query3[0].ToString());
var query = "";
query = "INSERT INTO ADDRESS(iduser,address)" +
$"values('{query4}','{textBox3.Text}')";
ConnectionDB.ExecuteNonQuery(query);
MessageBox.Show("se ha guardado la nueva ubicacion.");
}
catch (Exception exception)
{
MessageBox.Show("No se ha registrado la ubicacion");
throw;
}
}
}
public static void crearNuevo(string nombre, string usuario)
{
string nonQuery = String.Format("INSERT INTO APPUSER(fullname, username, password, userType) " +
$"VALUES('{nombre}','{usuario}','{usuario}', false)");
ConnectionDB.ExecuteNonQuery(nonQuery);
}
public static void agregarNegocio(string nombreN, string description)
{
string sql = string.Format("INSERT INTO BUSINESS(name, description) " +
" VALUES('{0}', '{1}');", nombreN, description);
ConnectionDB.ExecuteNonQuery(sql);
}
public static void crearOrden(DateTime fecha, int idP, int idA)
{
string f = fecha.ToShortDateString();
string nonQuery = String.Format("INSERT INTO apporder(createDate, idProduct, idAddress) " +
$"VALUES('{f}', {idP}, {idA})");
ConnectionDB.ExecuteNonQuery(nonQuery);
}
private void button7_Click(object sender, EventArgs e)
{
if (MessageBox.Show("¿Seguro que quieres eliminar al usuario?",
"Parcial_02", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
ConnectionDB.ExecuteNonQuery($"DELETE FROM appuser WHERE username = '******'");
MessageBox.Show("Usuario Eliminado");
DatosAppUser();
}
}
private void button6_Click(object sender, EventArgs e)
{
if (MessageBox.Show("¿Seguro que quieres eliminar la dirección?",
"Parcial_02", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
ConnectionDB.ExecuteNonQuery($"DELETE FROM address WHERE address = '{comboBox2.Text}'");
MessageBox.Show("Dirección Eliminada");
DatosAddress();
}
}
private void button8_Click(object sender, EventArgs e)
{
if (MessageBox.Show("¿Seguro que quieres eliminar el negocio?",
"Parcial_02", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
ConnectionDB.ExecuteNonQuery($"DELETE FROM business WHERE name = '{comboBox4.Text}'");
MessageBox.Show("Negocio Eliminado");
DatosBusiness();
}
}
//Actualizando Producto (stock inicial, etc)
public static void UpdateProduct(string nombre)
{
try
{
ConnectionDB.ExecuteNonQuery($"UPDATE GANANCIA SET stock_actual = stock_ingresado, precio_compra_acumulado = (stock_ingresado*precio_unidad_compra) WHERE nombre = '{nombre}';");
}
catch (Exception exception)
{
MessageBox.Show("Ha ocurrido un error actualizando");
}
}
private void button13_Click(object sender, EventArgs e)
{
if (MessageBox.Show("¿Seguro que quieres eliminar la orden?",
"Parcial_02", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
ConnectionDB.ExecuteNonQuery($"DELETE FROM apporder WHERE id_order = '{comboBox7.Text}'");
MessageBox.Show("Orden Eliminada");
DatosProduct();
DatosOrden();
DatosAddress();
}
}
//Actualizando Producto (stock)
public static void UpdateProductStock(int id, int cantidad)
{
try
{
ConnectionDB.ExecuteNonQuery($"UPDATE GANANCIA SET stock_ingresado = stock_ingresado + '{cantidad}', stock_actual = stock_actual + '{cantidad}' WHERE idproducto = '{id}';");
MessageBox.Show("Se ha actualizado el stock", "Stock Actualizado");
}
catch (Exception exception)
{
MessageBox.Show("Ha ocurrido un error actualizando");
}
}
public static void DeleteUser(string userName)
{
try
{
ConnectionDB.ExecuteNonQuery($"DELETE FROM appuser " +
$"WHERE username = '******'");
MessageBox.Show("Se ha eliminado el usuario");
}
catch (Exception exception)
{
MessageBox.Show("Ha ocurrido un error");
}
}
