void CargarLista() { try { NAsignatura n = new NAsignatura(); List <EAsignatura> l = n.ListaAsignatura(); dataGridView1.DataSource = l; dataGridView1.Columns[0].Visible = false; for (int i = 0; i < dataGridView1.RowCount; i++) { if (Convert.ToBoolean(dataGridView1.Rows[i].Cells["Activo"].Value.ToString()) == false) { dataGridView1.Rows[i].DefaultCellStyle.ForeColor = Color.Red; } else { dataGridView1.Rows[i].DefaultCellStyle.ForeColor = Color.Black; } } } catch (Exception ex) { throw ex; } }
void CargarAsignaturas() { try { NAsignatura n = new NAsignatura(); List <EAsignatura> listaAsignatura = n.ListaAsignatura(); listBox1.DataSource = listaAsignatura; listBox1.DisplayMember = "Asignatura"; listBox1.ValueMember = "AsignaturaId"; } catch (Exception ex) { throw ex; } }
private void btningresar_Click(object sender, EventArgs e) { try { if (Bandera == 0) { EAsignatura E = new EAsignatura(); NAsignatura n = new NAsignatura(); E.Asignatura = txtasignatura.Text; n.IngresarAsignatura(E); txtasignatura.Clear(); chkEditar.Checked = false; MessageBox.Show("Asignatura Ingresado con exito", "SGA", MessageBoxButtons.OK, MessageBoxIcon.Information); txtasignatura.Focus(); chkEditar.Visible = false; CargarLista(); } if (Bandera == 1) { EAsignatura E = new EAsignatura(); NAsignatura n = new NAsignatura(); E.AsignaturaId = Convert.ToInt32(txtasignatura.Tag); E.Asignatura = txtasignatura.Text; E.Activo = Convert.ToBoolean(rbtnactivo.Checked ? 1 : 0); n.ModificarAsignatura(E); txtasignatura.Clear(); chkEditar.Checked = false; rbtnactivo.Visible = false; rbtnCancelar.Visible = false; MessageBox.Show("Asignatura Modificada con exito", "SGA", MessageBoxButtons.OK, MessageBoxIcon.Information); Bandera = 0; txtasignatura.Focus(); chkEditar.Visible = false; CargarLista(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "SGA", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
void CargarAsignatura() { try { NAsignatura n = new NAsignatura(); List <EAsignatura> Lista = n.ListaAsignatura(); var NuevaLista = (from i in Lista select new { i.AsignaturaId, i.Asignatura }).ToList(); listBox1.DataSource = NuevaLista; listBox1.DisplayMember = "Asignatura"; listBox1.ValueMember = "AsignaturaId"; } catch (Exception ex) { throw ex; } }
private void eliminarToolStripMenuItem_Click(object sender, EventArgs e) { try { EAsignatura a = new EAsignatura(); NAsignatura n = new NAsignatura(); a.AsignaturaId = Convert.ToInt32(dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["AsignaturaId"].Value.ToString()); var As = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["Asignatura"].Value.ToString(); DialogResult o = MessageBox.Show("¿Realmente deseas elliminar la asignatura " + As + " ?", "SGA", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (o == DialogResult.OK) { n.Eliminarsignatura(a); MessageBox.Show("Asignatura eliminada con exito", "SGA", MessageBoxButtons.OK, MessageBoxIcon.Information); CargarLista(); } } catch (Exception ex) { throw ex; } }