private void button_List_Click(object sender, EventArgs e)
{
var nameEm = comboBox_EmList.SelectedItem.ToString();
var buiss = ConectionBD.ExexuteQuery($"SELECT \"idBussiness\" FROM \"BUSSINESS\"" +
$" WHERE \"name\" = '{nameEm}'");
var buisID = buiss.Rows[0][0].ToString();
var productoDT = ConectionBD.ExexuteQuery($"SELECT \"idProduct\",\"name\" FROM \"PRODUCT\"" +
$" WHERE \"idBussiness\" = {buisID};");
dataGridView1.DataSource = productoDT;
}
private void Products_Load(object sender, EventArgs e)
{
var buiss = ConectionBD.ExexuteQuery("SELECT name FROM \"BUSSINESS\"");
var buisCombo = new List <string>();
foreach (DataRow dr in buiss.Rows)
{
buisCombo.Add(dr[0].ToString());
}
comboBox_EmNew.DataSource = buisCombo;
comboBox_EmDelete.DataSource = buisCombo;
comboBox_EmList.DataSource = buisCombo;
}
private void IniciarSesion_button_Click(object sender, EventArgs e)
{
if (Usuario_textBox.Text.Equals("") ||
Contraseña_textBox.Text.Equals(""))
{
MessageBox.Show("No se puede dejar datos vacios");
}
else
{
try
{
var txtUsuario = Usuario_textBox.Text;
var txtContra = Contraseña_textBox.Text;
var Select = ConectionBD.ExexuteQuery($"SELECT username, password, \"userType\" FROM" +
$" \"APPUSER\" WHERE username = '******' " +
$"AND password = '******'");
foreach (DataRow dr in Select.Rows)
{
if (dr[2].ToString().Equals("Admin"))
{
AdminForm AF = new AdminForm();
AF.Show();
}
else if (dr[2].ToString().Equals("Normal"))
{
NormalForm NF = new NormalForm();
NF.Show();
}
}
}
catch (Exception ex)
{
MessageBox.Show("Ocurrio un error");
}
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox_NameProduct.Text.Equals(""))
{
MessageBox.Show("No dejar campos vacios");
}
else
{
try
{
var select = comboBox_EmNew.SelectedItem.ToString();
var buiss = ConectionBD.ExexuteQuery($"SELECT \"idBussiness\" FROM \"BUSSINESS\" " +
$"WHERE \"name\" = '{select}'");
var buisID = buiss.Rows[0][0].ToString();
ConectionBD.ExecuteNonQuiery($"INSERT INTO \"PRODUCT\" (name,\"idBussiness\")" +
$" VALUES ('{textBox_NameProduct.Text}',{buisID})");
MessageBox.Show("Se creo el nuevo producto");
}
catch (Exception ex)
{
MessageBox.Show("Ocurrio un error");
}
}
}
private void button_CargarUsuarios_Click(object sender, EventArgs e)
{
var dat = ConectionBD.ExexuteQuery("SELECT * FROM \"APPUSER\"");
dataGridView1.DataSource = dat;
}
private void button1_Click(object sender, EventArgs e)
{
var dat = ConectionBD.ExexuteQuery("SELECT * FROM \"BUSSINESS\"");
dataGridView1.DataSource = dat;
}