public Operation <Movimiento> addRecord(Movimiento o)
{
try
{
EntitySingleton.Context.Movimientos.Add(o);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <Movimiento> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <Movimiento> .getFailOperation(e.Message));
}
}
public Operation <Cargo> deleteRecord(Cargo o)
{
try
{
EntitySingleton.Context.Cargos.Remove(o);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <Cargo> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <Cargo> .getFailOperation(e.Message));
}
}
public Operation <EventoSeccion> deleteRecord(EventoSeccion o)
{
try
{
EntitySingleton.Context.EventoSeccions.Remove(o);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <EventoSeccion> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <EventoSeccion> .getFailOperation(e.Message));
}
}
//Aquí encontrarán un método por cada una de las operaciones CRUD:
//Create: addRecord
//Read: getRecords (y su variante getActiveRecords que devuelve solamente registros con estado activo)
//Update: updateRecord
//Delete: deleteRecord (este realmente no se usa porque manejamos estados en cada tabla)
//Literal, solo copien y peguen estos métodos en sus controladores, y cámbien toda cosa que
//diga 'facultad' o derivados por el nombre del objeto que estén trabajando
public Operation <facultad> addRecord(facultad f)
{
try
{
EntitySingleton.Context.facultads.Add(f);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <facultad> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <facultad> .getFailOperation(e.Message));
}
}
public Operation <carrera> addRecord(carrera c)
{
try
{
EntitySingleton.Context.carreras.Add(c);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <carrera> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <carrera> .getFailOperation(e.Message));
}
}
public Operation <MiembroFuncion> addRecord(MiembroFuncion o)
{
try
{
EntitySingleton.Context.MiembroFuncions.Add(o);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <MiembroFuncion> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <MiembroFuncion> .getFailOperation(e.Message));
}
}
public Operation <plan> addRecord(plan p)
{
try
{
EntitySingleton.Context.plans.Add(p);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <plan> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <plan> .getFailOperation(e.Message));
}
}
public Operation <EstadoCivil> updateRecord(EstadoCivil o)
{
try
{
EstadoCivil civilStatus = EntitySingleton.Context.EstadoCivils.Find(o.idEstadoCivil);
EntitySingleton.Context.Entry(civilStatus).CurrentValues.SetValues(o);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <EstadoCivil> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <EstadoCivil> .getFailOperation(e.Message));
}
}
public Operation <FichasMedica> updateRecord(FichasMedica o)
{
try
{
FichasMedica fm = EntitySingleton.Context.FichasMedicas.Find(o.idFichas);
EntitySingleton.Context.Entry(fm).CurrentValues.SetValues(o);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <FichasMedica> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <FichasMedica> .getFailOperation(e.Message));
}
}
public Operation <escuela> updateRecord(escuela es)
{
try
{
escuela escuela = EntitySingleton.Context.escuelas.Find(es.id);
EntitySingleton.Context.Entry(escuela).CurrentValues.SetValues(es);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <escuela> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <escuela> .getFailOperation(e.Message));
}
}
public Operation <Departamento> updateRecord(Departamento o)
{
try
{
Departamento departamento = EntitySingleton.Context.Departamentos.Find(o.idDepartamento);
EntitySingleton.Context.Entry(departamento).CurrentValues.SetValues(o);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <Departamento> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <Departamento> .getFailOperation(e.Message));
}
}
public Operation <facultad> updateRecord(facultad f)
{
try
{
facultad facultad = EntitySingleton.Context.facultads.Find(f.id);
EntitySingleton.Context.Entry(facultad).CurrentValues.SetValues(f);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <facultad> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <facultad> .getFailOperation(e.Message));
}
}
// No se si vamos a eliminar, yo creo que si
public Operation <tournament> deleteRecord(tournament o)
{
try
{
tournament t = EntitySingleton.Context.tournament.Find(o.id);
EntitySingleton.Context.tournament.Remove(o);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <tournament> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <tournament> .getFailOperation(e.Message));
}
}
public Operation <pensum> updateRecord(pensum p)
{
try
{
pensum pensum = EntitySingleton.Context.pensums.Find(p.id);
EntitySingleton.Context.Entry(pensum).CurrentValues.SetValues(p);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <pensum> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <pensum> .getFailOperation(e.Message));
}
}
public Operation <materia> updateRecord(materia m)
{
try
{
materia materia = EntitySingleton.Context.materias.Find(m.id);
EntitySingleton.Context.Entry(materia).CurrentValues.SetValues(m);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <materia> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <materia> .getFailOperation(e.Message));
}
}
public Operation <Anuncio> updateRecord(Anuncio o)
{
try
{
Anuncio advertisement = EntitySingleton.Context.Anuncios.Find(o.idAnuncio);
EntitySingleton.Context.Entry(advertisement).CurrentValues.SetValues(o);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <Anuncio> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <Anuncio> .getFailOperation(e.Message));
}
}
public Operation <Usuario> updateRecord(Usuario o)
{
try
{
Usuario user = EntitySingleton.Context.Usuarios.Find(o.idUsuario);
EntitySingleton.Context.Entry(user).CurrentValues.SetValues(o);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <Usuario> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <Usuario> .getFailOperation(e.Message));
}
}
// No se si vamos a eliminar, yo creo que si
public Operation <player> deleteRecord(player o)
{
try
{
player t = EntitySingleton.Context.player.Find(o.id);
EntitySingleton.Context.player.Remove(o);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <player> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <player> .getFailOperation(e.Message));
}
}
public Operation <pensum> deleteRecord(long idPlan, int corr)
{
try
{
pensum pensum = EntitySingleton.Context.pensums.Where(x => x.idPlan == idPlan && x.corr == corr).FirstOrDefault();
EntitySingleton.Context.pensums.Remove(pensum);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <pensum> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <pensum> .getFailOperation(e.Message));
}
}
public Operation <Evento> updateRecord(Evento o)
{
try
{
Evento position = EntitySingleton.Context.Eventos.Find(o.idEvento);
EntitySingleton.Context.Entry(position).CurrentValues.SetValues(o);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <Evento> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <Evento> .getFailOperation(e.Message));
}
}
public Operation <ListaNegra> updateRecord(ListaNegra o)
{
try
{
ListaNegra blackList = EntitySingleton.Context.ListaNegras.Find(o.idListaNegra);
EntitySingleton.Context.Entry(blackList).CurrentValues.SetValues(o);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <ListaNegra> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <ListaNegra> .getFailOperation(e.Message));
}
}
public Operation <Perfile> updateRecord(Perfile o)
{
try
{
Perfile perfil = EntitySingleton.Context.Perfiles.Find(o.idPerfil);
EntitySingleton.Context.Entry(perfil).CurrentValues.SetValues(o);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <Perfile> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <Perfile> .getFailOperation(e.Message));
}
}
public Operation <Inscripcione> updateRecord(Inscripcione o)
{
try
{
Inscripcione i = EntitySingleton.Context.Inscripciones.Find(o.idInscripcion);
EntitySingleton.Context.Entry(i).CurrentValues.SetValues(o);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <Inscripcione> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <Inscripcione> .getFailOperation(e.Message));
}
}
public Operation <Miembro> updateRecord(Miembro o)
{
try
{
Miembro member = EntitySingleton.Context.Miembros.Find(o.idMiembro);
EntitySingleton.Context.Entry(member).CurrentValues.SetValues(o);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <Miembro> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <Miembro> .getFailOperation(e.Message));
}
}
public Operation <Religion> updateRecord(Religion o)
{
try
{
Religion religion = EntitySingleton.Context.Religions.Find(o.idReligion);
EntitySingleton.Context.Entry(religion).CurrentValues.SetValues(o);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <Religion> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <Religion> .getFailOperation(e.Message));
}
}
public Operation <Municipio> updateRecord(Municipio o)
{
try
{
Municipio municipio = EntitySingleton.Context.Municipios.Find(o.idMunicipio);
EntitySingleton.Context.Entry(municipio).CurrentValues.SetValues(o);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <Municipio> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <Municipio> .getFailOperation(e.Message));
}
}
public Operation <tipo_carrera> updateRecord(tipo_carrera c)
{
try
{
tipo_carrera tipo_carrera = EntitySingleton.Context.tipo_carrera.Find(c.id);
EntitySingleton.Context.Entry(tipo_carrera).CurrentValues.SetValues(c);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <tipo_carrera> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <tipo_carrera> .getFailOperation(e.Message));
}
}
public Operation <Escolaridad> updateRecord(Escolaridad o)
{
try
{
Escolaridad blackList = EntitySingleton.Context.Escolaridads.Find(o.idEscolaridad);
EntitySingleton.Context.Entry(blackList).CurrentValues.SetValues(o);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <Escolaridad> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <Escolaridad> .getFailOperation(e.Message));
}
}
public Operation <Provincia> updateRecord(Provincia o)
{
try
{
Provincia province = EntitySingleton.Context.Provincias.Find(o.idProvincia);
EntitySingleton.Context.Entry(province).CurrentValues.SetValues(o);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <Provincia> .getSuccessOperation());
}
catch (Exception e)
{
Trace.Write(e.InnerException);
return(FactoryOperation <Provincia> .getFailOperation(e.Message));
}
}
public Operation <Localidade> updateRecord(Localidade o)
{
try
{
Localidade localidade = EntitySingleton.Context.Localidades.Find(o.idLocalidad);
EntitySingleton.Context.Entry(localidade).CurrentValues.SetValues(o);
EntitySingleton.Context.SaveChanges();
return(FactoryOperation <Localidade> .getSuccessOperation());
}
catch (Exception e)
{
return(FactoryOperation <Localidade> .getFailOperation(e.Message));
}
}
