private void actualizar()
{
SqlConnection conexion = DBConnection.getConnection();
SqlCommand command = new SqlCommand("select r.rol_habilitado, r.rol_id, r.rol_nombre from SOCORRO.Rol r order by rol_id", conexion);
command.CommandType = CommandType.Text;
DBConnection.fill_grid(dataGridView1, command, adapter1, table1);
SqlCommand command2 = new SqlCommand("select rol_nombre,r.rol_id,f.func_id, func_descripcion from SOCORRO.Rol r join(SOCORRO.FuncionalidadxRol fxr join SOCORRO.Funcionalidad f on fxr.func_id = f.func_id) on r.rol_id = fxr.rol_id order by r.rol_id", conexion);
command2.CommandType = CommandType.Text;
DBConnection.fill_grid(dataGridView2, command2, adapter2, table2);
List <Rol> roles = DBConnection.getRoles();
comboBox_roles.Items.Clear();
foreach (Rol r in roles)
{
comboBox_roles.Items.Add(r.nombre);
}
if (comboBox_roles.Items.Count > 0)
{
comboBox_roles.SelectedIndex = 0;
}
dataGridView1.Columns["rol_id"].ReadOnly = true;
}
private void MisCupones_Load(object sender, EventArgs e)
{
SqlConnection conexion = DBConnection.getConnection();
SqlCommand command = new SqlCommand("SOCORRO.sp_mostrar_mis_cupones", conexion);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@user_id", usuActivo.id);
command.ExecuteNonQuery();
SqlDataAdapter adapter1 = new SqlDataAdapter();
DataTable table1 = new DataTable();
DBConnection.fill_grid(dataGridView1, command, adapter1, table1);
comboBox1.Visible = false;
label3.Visible = false;
button3.Visible = false;
foreach (Rol r in usuActivo.roles)
{
if (DBConnection.isAdmin(r))
{
comboBox1.Visible = true;
List <Cliente> clientes = ClienteDAO.getClientes();
foreach (Cliente c in clientes)
{
comboBox1.Items.Add(c.id);
}
label3.Visible = true;
button3.Visible = true;
comboBox1.SelectedItem = ClienteDAO.obtenerIdCliente(usuActivo);
return;
}
}
}
void actualizar()
{
SqlConnection conexion = DBConnection.getConnection();
SqlCommand command = new SqlCommand("select * from SOCORRO.Usuario", conexion);
command.CommandType = CommandType.Text;
DBConnection.fill_grid(dataGridView1, command, adapter1, table1);
dataGridView1.Columns["user_id"].ReadOnly = true;
dataGridView1.Columns["user_pass"].ReadOnly = true;
dataGridView1.Columns["user_username"].ReadOnly = true;
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
// if (textBox1.Text == "")
// return;
SqlConnection conexion = DBConnection.getConnection();
SqlCommand command = new SqlCommand("select * from SOCORRO.Usuario where user_username LIKE '%'+@nombre+'%'", conexion);
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@nombre", textBox1.Text);
DBConnection.fill_grid(dataGridView1, command, adapter1, table1);
}
private void actualizar()
{
SqlConnection conexion = DBConnection.getConnection();
SqlCommand command = new SqlCommand("select p.prov_id,p.prov_user_id, p.prov_cuit,p.prov_razon_social,p.prov_nombre_contacto,r.rubro_descripcion, p.prov_ciudad,p.prov_codigo_postal,p.prov_direccion,p.prov_telefono,p.prov_email, p.prov_habilitado, p.prov_rubro_id from (SOCORRO.Proveedor p join SOCORRO.Rubro r on p.prov_rubro_id = r.rubro_id) join SOCORRO.RolxUsuario ro on p.prov_user_id = ro.user_id where ro.rol_id = 2", conexion);
command.CommandType = CommandType.Text;
DBConnection.fill_grid(dataGridView1, command, adapter1, table1);
dataGridView1.Columns["prov_rubro_id"].Visible = false;
dataGridView1.Columns["prov_id"].ReadOnly = true;
dataGridView1.Columns["prov_user_id"].ReadOnly = true;
}
private void actualizar()
{
SqlConnection conexion = DBConnection.getConnection();
SqlCommand command = new SqlCommand("select * from SOCORRO.Cliente c join SOCORRO.RolxUsuario r on c.clie_user_id = r.user_id where rol_id = 1", conexion);
command.CommandType = CommandType.Text;
DBConnection.fill_grid(dataGridView1, command, adapter1, table1);
dataGridView1.Columns["clie_id"].ReadOnly = true;
dataGridView1.Columns["clie_user_id"].ReadOnly = true;
dataGridView1.Columns["clie_saldo"].ReadOnly = true;
dataGridView1.Columns["rol_id"].Visible = false;
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection conexion = DBConnection.getConnection();
SqlCommand command = new SqlCommand("SOCORRO.sp_cupones_cliente", conexion);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@clie_id", Convert.ToInt16(comboBox1.SelectedItem));
command.ExecuteNonQuery();
SqlDataAdapter adapter1 = new SqlDataAdapter();
DataTable table1 = new DataTable();
DBConnection.fill_grid(dataGridView1, command, adapter1, table1);
}
private void AbmRol_Load(object sender, EventArgs e)
{
SqlConnection conexion = DBConnection.getConnection();
SqlCommand command = new SqlCommand("select r.rol_id,r.rol_habilitado, r.rol_nombre from SOCORRO.Rol r order by r.rol_id", conexion);
command.CommandType = CommandType.Text;
adapter1 = new SqlDataAdapter();
table1 = new DataTable();
adapter1.UpdateCommand = new SqlCommand("SOCORRO.sp_modificar_rol", conexion);
adapter1.UpdateCommand.CommandType = CommandType.StoredProcedure;
adapter1.UpdateCommand.Parameters.Add("@rol_habilitado", SqlDbType.Bit, 1, "rol_habilitado");
adapter1.UpdateCommand.Parameters.Add("@rol_nombre", SqlDbType.NVarChar, 20, "rol_nombre");
SqlParameter parameter = adapter1.UpdateCommand.Parameters.Add("@rol_id", SqlDbType.Int);
parameter.SourceColumn = "rol_id";
parameter.SourceVersion = DataRowVersion.Original;
DBConnection.fill_grid(dataGridView1, command, adapter1, table1);
SqlCommand command2 = new SqlCommand("select r.rol_id,r.rol_nombre, f.func_id,f.func_descripcion from SOCORRO.Rol r join SOCORRO.FuncionalidadxRol fxr on fxr.rol_id = r.rol_id join SOCORRO.Funcionalidad f on f.func_id = fxr.func_id order by r.rol_id,f.func_id", conexion);
command2.CommandType = CommandType.Text;
adapter2 = new SqlDataAdapter();
table2 = new DataTable();
DBConnection.fill_grid(dataGridView2, command2, adapter2, table2);
List <Funcionalidad> funcs = DBConnection.getFuncs();
foreach (Funcionalidad f in funcs)
{
comboBox_funcionalidades.Items.Add(f.nombre);
}
comboBox_funcionalidades.SelectedIndex = 0;
List <Rol> roles = DBConnection.getRoles();
comboBox_roles.Items.Clear();
foreach (Rol r in roles)
{
comboBox_roles.Items.Add(r.nombre);
}
if (comboBox_roles.Items.Count > 0)
{
comboBox_roles.SelectedIndex = 0;
}
dataGridView1.Columns["rol_id"].ReadOnly = true;
}
private void button3_Click(object sender, EventArgs e)
{
comboBox1.SelectedIndex = -1;
SqlConnection conexion = DBConnection.getConnection();
SqlCommand command = new SqlCommand("SOCORRO.sp_mostrar_mis_cupones", conexion);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@user_id", usuActivo.id);
command.ExecuteNonQuery();
SqlDataAdapter adapter1 = new SqlDataAdapter();
DataTable table1 = new DataTable();
DBConnection.fill_grid(dataGridView1, command, adapter1, table1);
}
public static void filtros_clientes(DataGridView grid, string filtroNombre, string filtroApellido, int filtroDNI, string filtroemail, SqlDataAdapter adapter1, DataTable table1)
{
SqlConnection conn = DBConnection.getConnection();
SqlCommand comando = new SqlCommand("SOCORRO.sp_buscar_clientes", conn);
comando.CommandType = CommandType.StoredProcedure;
comando.Parameters.AddWithValue("@apellido", filtroApellido);
comando.Parameters.AddWithValue("@email", filtroemail);
comando.Parameters.AddWithValue("@dni", filtroDNI);
comando.Parameters.AddWithValue("@nombre", filtroNombre);
DBConnection.fill_grid(grid, comando, adapter1, table1);
comando.Dispose();
conn.Close();
conn.Dispose();
}
private void EstadoUsuarios_Load(object sender, EventArgs e)
{
SqlConnection conexion = DBConnection.getConnection();
SqlCommand command = new SqlCommand("select * from SOCORRO.Usuario", conexion);
command.CommandType = CommandType.Text;
adapter1 = new SqlDataAdapter();
table1 = new DataTable();
adapter1.UpdateCommand = new SqlCommand("SOCORRO.sp_modificar_usuario", conexion);
adapter1.UpdateCommand.CommandType = CommandType.StoredProcedure;
SqlParameter parametro1 = new SqlParameter();
parametro1.ParameterName = "@user_id";
parametro1.SqlDbType = SqlDbType.Int;
parametro1.SourceVersion = DataRowVersion.Original;
parametro1.SourceColumn = "user_id";
adapter1.UpdateCommand.Parameters.Add(parametro1);
SqlParameter parametro2 = new SqlParameter();
parametro2.ParameterName = "@user_username";
parametro2.SourceColumn = "user_username";
adapter1.UpdateCommand.Parameters.Add(parametro2);
SqlParameter parametro3 = new SqlParameter();
parametro3.ParameterName = "@user_pass";
parametro3.SourceColumn = "user_pass";
adapter1.UpdateCommand.Parameters.Add(parametro3);
SqlParameter parametro4 = new SqlParameter();
parametro4.ParameterName = "@user_intentos";
parametro4.SourceColumn = "user_intentos";
adapter1.UpdateCommand.Parameters.Add(parametro4);
SqlParameter parametro5 = new SqlParameter();
parametro5.ParameterName = "@user_habilitado";
parametro5.SourceColumn = "user_habilitado";
adapter1.UpdateCommand.Parameters.Add(parametro5);
DBConnection.fill_grid(dataGridView1, command, adapter1, table1);
dataGridView1.Columns["user_id"].ReadOnly = true;
dataGridView1.Columns["user_pass"].ReadOnly = true;
dataGridView1.Columns["user_username"].ReadOnly = true;
}
public static void filtros_proveedores(DataGridView grid, string razonSocial, string cuit, string email, SqlDataAdapter adapter1, DataTable table1)
{
SqlConnection conn = DBConnection.getConnection();
SqlCommand comando = new SqlCommand("SOCORRO.sp_buscar_proveedores", conn);
comando.CommandType = CommandType.StoredProcedure;
comando.Parameters.AddWithValue("@rs", razonSocial);
comando.Parameters.AddWithValue("@cuit", cuit);
comando.Parameters.AddWithValue("@mail", email);
adapter1 = new SqlDataAdapter();
table1 = new DataTable();
DBConnection.fill_grid(grid, comando, adapter1, table1);
comando.Dispose();
conn.Close();
conn.Dispose();
}
public void mostrar_items(int prov_id)
{
SqlConnection conexion = DBConnection.getConnection();
SqlCommand command = new SqlCommand("SELECT cupon_ofer_id, ofer_descripcion, COUNT(cupon_ofer_id) cantidad, ofer_precio_oferta, (ofer_precio_oferta*COUNT(cupon_ofer_id)) precioxcantidad FROM SOCORRO.Cupon cup JOIN SOCORRO.Oferta o ON o.ofer_id = cup.cupon_ofer_id where ofer_prov_id = @prov_id and @fecha_desde < cupon_fecha_compra and cupon_fecha_compra<@fecha_hasta group by cupon_ofer_id, ofer_descripcion,ofer_precio_oferta order by cantidad desc", conexion);
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@prov_id", prov_id);
dateTimePicker1.Value = new DateTime(dateTimePicker1.Value.Year, dateTimePicker1.Value.Month, dateTimePicker1.Value.Day, 0, 0, 0);
dateTimePicker2.Value = new DateTime(dateTimePicker2.Value.Year, dateTimePicker2.Value.Month, dateTimePicker2.Value.Day, 23, 59, 59);
command.Parameters.AddWithValue("@fecha_desde", dateTimePicker1.Value);
command.Parameters.AddWithValue("@fecha_hasta", dateTimePicker2.Value);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(command);
DBConnection.fill_grid(dataGridView1, command, da, dt);
dataGridView1.EditMode = DataGridViewEditMode.EditProgrammatically;
command.ExecuteReader();
command.Dispose();
conexion.Close();
conexion.Dispose();
}
private void btn_mayorFactr_Click(object sender, EventArgs e)
{
if (!utils.validarEntradaSoloNumeros(textBox1) || !utils.validarNoVacio(textBox1) || textBox1.Text.Length != 4)
{
MessageBox.Show("Hubo un error con la entrada del año ");
return;
}
SqlConnection conexion = DBConnection.getConnection();
SqlCommand command = new SqlCommand("SOCORRO.sp_lista_prov_mayor_facturacion", conexion);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@semestre", comboBox1.SelectedIndex + 1);
command.Parameters.AddWithValue("@anio", Convert.ToInt16(textBox1.Text));
DBConnection.fill_grid(dataGridView1, command, adapter1, table1);
adapter1.Dispose();
table1 = new DataTable();
adapter1 = new SqlDataAdapter();
conexion.Close();
conexion.Dispose();
}
