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;
}
}
