public void Save(Business.Entities.Curso curso)
{
if (Validar(curso))
{
CursoData.Save(curso);
}
}
private void cmb_curso_SelectedValueChanged(object sender, EventArgs e)
{
if (cmb_curso.SelectedItem != null)
{
Business.Entities.Curso cur = (Business.Entities.Curso)cmb_curso.SelectedItem;
int idComision = Business.Logic.ABMcurso.buscarComisionCurso(cur.IdCurso);
int idMateria = Business.Logic.ABMcurso.buscarMateriaCurso(cur.IdCurso);
Business.Entities.Comision com = Business.Logic.ABMcomision.buscarComisionPorId(idComision);
if (com != null)
{
txtComision.Text = com.NombreComision;
}
else
{
txtComision.Text = "";
}
if (idMateria != -1)
{
Business.Entities.Materia mat = Business.Logic.ABMmateria.buscarMateriaPorId(idMateria);
if (mat != null)
{
txtMateria.Text = mat.Nombre;
}
else
{
txtMateria.Text = "";
}
}
this.actualizarGrilla();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if ((Session["tipoPersonaLogueada"] == null) || (Business.Entities.tipoUsuario)Session["tipoPersonaLogueada"] != Business.Entities.tipoUsuario.DOCENTE)
{
Response.Redirect("~/loguin.aspx");
}
if (!IsPostBack)
{
try
{
List <int> idCursos;
idCursos = Business.Logic.ABMdocente.listarCursosDocente((int)Session["idPersonaLogueada"]);
List <Business.Entities.Curso> cursos = new List <Business.Entities.Curso>();
foreach (int i in idCursos)
{
Business.Entities.Curso cur = Business.Logic.ABMcurso.buscarCursoPorId(i);
cursos.Add(cur);
}
this.ddl_Cursos.DataSource = cursos;
this.ddl_Cursos.DataTextField = "nombre";
this.ddl_Cursos.DataValueField = "idCurso";
this.ddl_Cursos.DataBind();
actualizarGrilla();
}
catch
{
this.ddl_Cursos.DataSource = null;
}
}
}
public frm_PuntuacionAlumno(Business.Entities.Curso cur, int id, string legajo, string nombre)
{
InitializeComponent();
curso = cur;
txtCurso.Text = cur.Nombre;
txtCurso.Enabled = false;
txtLegajo.Text = legajo;
txtLegajo.Enabled = false;
txtNombre.Text = nombre;
txtNombre.Enabled = false;
idAlumno = id;
cmb_Estado.Items.Add("Libre");
cmb_Estado.Items.Add("Regular");
cmb_Estado.Items.Add("Promovido");
cmb_Estado.SelectedItem = "Libre";
for (int i = 0; i < 11; i++)
{
cmbNota.Items.Add(i);
}
int nota = Business.Logic.ABMcurso.buscarNotaAlumnoCurso(cur.IdCurso, id);
if (nota != -1)
{
MessageBox.Show(this.Owner, "Ya has puntuado a este alumno en este curso", "Cuidado", MessageBoxButtons.OK);
this.cmbNota.SelectedItem = nota;
}
}
private void actualizarGrid()
{
try
{
List <int> idCursos;
if (frm_Principal.PersonaLogueada.TipoUsuario == Business.Entities.tipoUsuario.ADMIN)
{
idCursos = Business.Logic.ABMdocente.listarCursosDocente((int)comboBox1.SelectedValue);
}
else
{
idCursos = Business.Logic.ABMdocente.listarCursosDocente(frm_Principal.PersonaLogueada.IDPersona);
}
List <Business.Entities.Curso> cursos = new List <Business.Entities.Curso>();
foreach (int i in idCursos)
{
Business.Entities.Curso cur = Business.Logic.ABMcurso.buscarCursoPorId(i);
cursos.Add(cur);
}
this.grv_Cursos.DataSource = cursos;
}
catch
{
this.grv_Cursos.DataSource = null;
}
}
protected void baja()
{
try
{
DataGridViewRow row = grd_view.CurrentRow;
DataGridViewCellCollection celdas = row.Cells;
Business.Entities.Docente doc = new Business.Entities.Docente(
celdas["nombre"].Value.ToString(),
celdas["apellido"].Value.ToString(),
celdas["legajo"].Value.ToString(),
celdas["dni"].Value.ToString(),
celdas["email"].Value.ToString(),
celdas["telefono"].Value.ToString()
);
int idpersona = (int)celdas["IDPersona"].Value;
doc.IDPersona = idpersona;
Business.Entities.Curso cur = (Business.Entities.Curso) this.cmb_curso.SelectedItem;
new frm_BajaDocenteCurso(doc, cur).ShowDialog();
this.actualizarGrilla();
}
catch (Exception)
{
MessageBox.Show(this.Owner, "No se ha seleccionado ningun docente", "Alerta", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
protected void btn_agregar_Click(object sender, EventArgs e)
{
string nombre = this.txt_nombre.Text;
int cupo = int.Parse(this.txt_cupo.Text);
Business.Entities.Curso cur = new Business.Entities.Curso(nombre, cupo);
int idCom = int.Parse(ddl_comisiones.SelectedValue);
Business.Entities.Comision com = new Business.Entities.Comision();
com.IdComision = idCom;
cur.Comision = com;
int idMat = int.Parse(ddl_materias.SelectedValue);
Business.Entities.Materia mat = new Business.Entities.Materia();
mat.IdMateria = idMat;
cur.Materia = mat;
bool val = Business.Logic.ABMcurso.altaCurso(cur);
if (val)
{
Response.Write("<script type='text/javascript'> alert('Dado de alta correctamente'); location.href = '/ABMCurso.aspx' </script>");
}
else
{
Response.Write("<script type='text/javascript'> alert('No se ha podido dar de alta, es probable que ya exista otro curso con ese nombre') </script>");
}
}
public frm_BajaDocenteCurso(Business.Entities.Docente doc, Business.Entities.Curso cur)
{
InitializeComponent();
this.txt_legajo.Text = doc.Legajo;
this.txt_legajo.Enabled = false;
this.txt_nombreCurso.Enabled = false;
this.txt_nombreCurso.Text = cur.Nombre;
curso = cur;
docente = doc;
}
public bool borrarCurso(string nombre)
{
Business.Entities.Curso cur = buscarCurso(nombre);
if (cur == null)
{
return(false);
}
return(this.cursos.Remove(cur));
}
public static int buscarDocenteCurso(Business.Entities.Docente doc, Business.Entities.Curso cur)
{
Business.Entities.Docente docente = Business.Logic.ABMdocente.buscarDocentePorId(doc.IDPersona);
Business.Entities.Curso curso = Business.Logic.ABMcurso.buscarCursoPorId(cur.IdCurso);
if (curso != null && docente != null)
{
return(Data.Database.CursoDB.getInstance().buscarDocenteCurso(doc, cur));
}
return(-1);
}
public static int buscarAlumnoCurso(int al, int cur)
{
Business.Entities.Alumno alu = Business.Logic.ABMalumno.buscarAlumnoPorId(al);
Business.Entities.Curso curso = Business.Logic.ABMcurso.buscarCursoPorId(cur);
if (curso != null && alu != null)
{
return(Data.Database.CursoDB.getInstance().buscarAlumnoCurso(al, cur));
}
return(-1);
}
public frm_AltaDocenteCurso(Business.Entities.Curso cur)
{
InitializeComponent();
this.txt_NombreCurso.Text = cur.Nombre.Trim();
this.txt_NombreCurso.Enabled = false;
this.cmb_Legajos.DataSource = Business.Logic.ABMdocente.listarDocentes();
this.cmb_Legajos.DisplayMember = "legajo";
this.cmb_Legajos.ValueMember = "iDPersona";
curso = cur;
}
public CursoModel(Business.Entities.Curso Curso)
{
this.ID = Curso.ID;
this.Descripcion = Curso.Descripcion;
this.AnioCalendario = Curso.AnioCalendario;
this.IDMateria = Curso.IDMateria;
this.IDComision = Curso.IDComision;
this.DescripcionMateria = Curso.DescripcionMateria;
this.DescripcionComision = Curso.DescripcionComision;
this.Cupo = Curso.Cupo;
}
protected void alta()
{
System.Console.Write("ingrese el nombre: ");
string nombre = System.Console.ReadLine();
System.Console.Write("ingrese cupo: ");
int cupo = int.Parse(System.Console.ReadLine());
Business.Entities.Curso curso = new Business.Entities.Curso(nombre, cupo);
System.Console.Write("ingrese la comision: ");
string comision = System.Console.ReadLine();
bool valCom = Business.Logic.ABMcurso.validarComision(curso, comision);
if (valCom)
{
System.Console.Write("ingrese la materia: ");
string materia = System.Console.ReadLine();
bool valMat = Business.Logic.ABMcurso.validarMateria(curso, materia);
if (valMat)
{
while (opc != 0)
{
System.Console.Write("ingrese el legajo de un docente: ");
string docente = System.Console.ReadLine();
bool valDoc = Business.Logic.ABMcurso.validarDocente(curso, docente);
if (valDoc)
{
System.Console.Write("Docente agregado con exito");
}
else
{
System.Console.Write("Docente inexistente");
}
System.Console.Write("\n 0/Terminar \n 1/Ingresar otro docente \n opcion:");
opc = int.Parse(System.Console.ReadLine());
System.Console.Clear();
}
opc = -1;
Business.Logic.ABMcurso.altaCurso(curso);
System.Console.Write("Curso agregado con exito");
System.Console.ReadKey();
}
else
{
System.Console.Write("Materia inexistente");
System.Console.ReadKey();
}
}
else
{
System.Console.Write("Comision inexistente");
System.Console.ReadKey();
}
}
private void mostrar(Business.Entities.Curso cur)
{
System.Console.Write("| {0} | ", cur.Nombre);
System.Console.Write("| {0} | ", cur.Cupo);
System.Console.Write("| {0} | ", cur.Materia.Nombre);
System.Console.Write("| {0} | \n ", cur.Comision.NombreComision);
System.Console.Write(" Docentes:");
foreach (Business.Entities.Docente doc in cur.Docentes)
{
System.Console.Write(" {0} \n", doc.Nombre);
}
}
protected void modi()
{
Business.Entities.Curso cur = buscarCurso();
if (cur != null)
{
bool borrado = Business.Logic.ABMcurso.borrarCurso(cur.Nombre);
if (borrado)
{
alta();
}
}
}
public async Task <IActionResult> Post(CursoViewModelInput cursoViewModelInput)
{
Business.Entities.Curso curso = new Business.Entities.Curso();
curso.Nome = cursoViewModelInput.Nome;
curso.Descricao = cursoViewModelInput.Descricao;
var codidoUsuario = int.Parse((User.FindFirst(c => c.Type == ClaimTypes.NameIdentifier))?.Value !);
curso.CodigoUsuario = codidoUsuario;
_cursoRepository.Adicionar(curso);
_cursoRepository.Commit();
return(Created("", cursoViewModelInput));
}
public static bool validarComision(Business.Entities.Curso cur, string com)
{
Business.Entities.Comision comi = ABMcomision.buscarComision(com);
if (comi != null)
{
cur.agregarComision(comi);
return(true);
}
else
{
return(false);
}
}
public static bool validarDocente(Business.Entities.Curso cur, string doc)
{
Business.Entities.Docente doce = ABMdocente.buscarDocente(doc);
if (doce != null)
{
cur.agregarDocente(doce);
return(true);
}
else
{
return(false);
}
}
public Business.Entities.Curso CursoToBusiness(FormCollection collection, Business.Entities.BusinessEntity.States estado)
{
Business.Entities.Curso curso = new Business.Entities.Curso();
curso.IDComision = Convert.ToInt32(collection["IDComision"]);
curso.IDMateria = Convert.ToInt32(collection["IDMateria"]);
curso.Cupo = Convert.ToInt32(collection["Cupo"]);
curso.AnioCalendario = Convert.ToInt32(collection["AnioCalendario"]);
if (estado == Business.Entities.BusinessEntity.States.Modified)
{
curso.ID = Convert.ToInt32(collection["ID"]);
}
return(curso);
}
public static bool borrarDocenteCurso(Business.Entities.Docente doc, Business.Entities.Curso cur)
{
int val = Business.Logic.ABMcurso.buscarDocenteCurso(doc, cur);
if (val != -1 || val != 0)
{
return(Data.Database.CursoDB.getInstance().borrarDocenteCurso(doc, cur));
}
else
{
return(false);
}
}
public static bool validarMateria(Business.Entities.Curso cur, string mat)
{
Business.Entities.Materia mate = ABMmateria.buscarMateria(mat);
if (mate != null)
{
cur.agregarMateria(mate);
return(true);
}
else
{
return(false);
}
}
public static bool modificarCurso(Business.Entities.Curso cur)
{
Business.Entities.Comision com = Business.Logic.ABMcomision.buscarComisionPorId(cur.Comision.IdComision);
Business.Entities.Materia mat = Business.Logic.ABMmateria.buscarMateriaPorId(cur.Materia.IdMateria);
if (com != null && mat != null)
{
Business.Entities.Curso curso = buscarCursoPorNombre(cur.Nombre);
if (curso == null || curso.IdCurso == cur.IdCurso)
{
return(Data.Database.CursoDB.getInstance().modificarCurso(cur));
}
}
return(false);
}
override protected void buscar()
{
System.Console.Write("ingrese el nombre: ");
string nombre = System.Console.ReadLine();
Business.Entities.Curso cur = Business.Logic.ABMcurso.buscarCurso(nombre);
if (cur != null)
{
mostrar(cur);
}
else
{
System.Console.WriteLine("No se encontro el curso {0}", nombre);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if ((Session["tipoPersonaLogueada"] == null) || (Business.Entities.tipoUsuario)Session["tipoPersonaLogueada"] != Business.Entities.tipoUsuario.ADMIN)
{
Response.Redirect("~/loguin.aspx");
}
if (!IsPostBack)
{
Business.Entities.Curso cur = Business.Logic.ABMcurso.buscarCursoPorId((int)Session["idCurso"]);
Business.Entities.Docente doc = Business.Logic.ABMdocente.buscarDocentePorId((int)Session["idDocente"]);
this.txt_curso.Text = cur.Nombre;
this.txt_curso.Enabled = false;
this.txt_docente.Enabled = false;
this.txt_docente.Text = doc.Legajo;
}
}
protected void btn_agregar_Click(object sender, EventArgs e)
{
Business.Entities.Curso cur = Business.Logic.ABMcurso.buscarCursoPorId((int)Session["idCurso"]);
Business.Entities.Docente doc = Business.Logic.ABMdocente.buscarDocentePorId((int)Session["idDocente"]);
bool borrado = Business.Logic.ABMcurso.borrarDocenteCurso(doc, cur);
if (borrado)
{
Session.Remove("idCurso");
Session.Remove("idDocente");
Response.Write("<script type='text/javascript'> alert('docente eliminado del curso correctamente'); location.href = '/ABMDocenteCurso.aspx' </script>");
}
else
{
Response.Write("<script type='text/javascript'> alert('algo ha fallado') </script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if ((Session["tipoPersonaLogueada"] == null) || (Business.Entities.tipoUsuario)Session["tipoPersonaLogueada"] != Business.Entities.tipoUsuario.ADMIN)
{
Response.Redirect("~/loguin.aspx");
}
if (!IsPostBack)
{
Business.Entities.Curso curso = Business.Logic.ABMcurso.buscarCursoPorId((int)Session["idCurso"]);
this.txt_curso.Text = curso.Nombre;
this.txt_curso.Enabled = false;
this.ddl_Docentes.DataSource = Business.Logic.ABMdocente.listarDocentes();
this.ddl_Docentes.DataValueField = "idPersona";
this.ddl_Docentes.DataTextField = "legajo";
this.ddl_Docentes.DataBind();
}
}
public frm_AltaCurso(Business.Entities.Curso cur)
{
ismodi = true;
saved = false;
InitializeComponent();
cmbComision.DataSource = Business.Logic.ABMcomision.listarComisiones();
cmbMateria.DataSource = Business.Logic.ABMmateria.listarMaterias();
cmbComision.ValueMember = "idComision";
cmbComision.DisplayMember = "nombreComision";
cmbComision.SelectedValue = Business.Logic.ABMcurso.buscarComisionCurso(cur.IdCurso);
cmbMateria.ValueMember = "idMateria";
cmbMateria.DisplayMember = "nombre";
cmbMateria.SelectedValue = Business.Logic.ABMcurso.buscarMateriaCurso(cur.IdCurso);
this.txtNombre.Text = cur.Nombre.Trim();
this.txtCupo.Text = cur.Cupo.ToString();
curso = cur;
}
private void btn_Puntuar_Click(object sender, EventArgs e)
{
try
{
DataGridViewRow row = grv_Alumnos.CurrentRow;
DataGridViewCellCollection celdas = row.Cells;
int idAlumno = (int)celdas["idPersona"].Value;
string legajo = celdas["legajo"].Value.ToString();
string nombre = celdas["Nombre"].Value.ToString() + " " + celdas["Apellido"].Value.ToString();
Business.Entities.Curso curso = (Business.Entities.Curso)cmb_Cursos.SelectedItem;
new frm_PuntuacionAlumno(curso, idAlumno, nombre, legajo).ShowDialog();
}
catch (NullReferenceException ex)
{
MessageBox.Show("No ha seleccionado ningun alumno", "Cuidado", MessageBoxButtons.OK);
}
}
protected void modi()
{
try
{
DataGridViewRow row = grd_view.CurrentRow;
DataGridViewCellCollection celdas = row.Cells;
int idCurso = (int)celdas["idCurso"].Value;
string nombre = celdas["nombre"].Value.ToString();
int cupo = (int)celdas["cupo"].Value;
Business.Entities.Curso curso = new Business.Entities.Curso(nombre, cupo);
curso.IdCurso = idCurso;
new frm_AltaCurso(curso).ShowDialog();
grd_view.DataSource = Business.Logic.ABMcurso.listarCursos();
}
catch (Exception e)
{
MessageBox.Show("No ha seleccionado ningun curso", "Cuidado", MessageBoxButtons.OK);
}
}
