internal IQueryable<Actividad> GetActividades()
{
using (CalendarClassEntitiesDataContext dc = new CalendarClassEntitiesDataContext(App.conexionString))
{
return dc.Actividads;
}
}
internal IQueryable<Nota> GetNotas()
{
using (CalendarClassEntitiesDataContext dc = new CalendarClassEntitiesDataContext(App.conexionString))
{
return dc.Notas;
}
}
internal IQueryable<Recurso> GetRecursos()
{
using (CalendarClassEntitiesDataContext dc = new CalendarClassEntitiesDataContext(App.conexionString))
{
return dc.Recurso;
}
}
internal void SaveActividad(Actividad objActividad)
{
using (CalendarClassEntitiesDataContext dc = new CalendarClassEntitiesDataContext(App.conexionString))
{
dc.Actividads.InsertOnSubmit(objActividad);
dc.SubmitChanges();
}
}
internal void SaveNota(Nota objNota)
{
using (CalendarClassEntitiesDataContext dc = new CalendarClassEntitiesDataContext(App.conexionString))
{
dc.Notas.InsertOnSubmit(objNota);
dc.SubmitChanges();
}
}
internal void SaveRecurso(Recurso objRecurso)
{
using (CalendarClassEntitiesDataContext dc = new CalendarClassEntitiesDataContext(App.conexionString))
{
dc.Recurso.InsertOnSubmit(objRecurso);
dc.SubmitChanges();
}
}
internal void UpdateRecurso(Recurso objRecurso)
{
using (CalendarClassEntitiesDataContext dc = new CalendarClassEntitiesDataContext(App.conexionString))
{
Recurso _objRecurso = dc.Recurso.Single(p => p.RecursoId == objRecurso.RecursoId);
dc.SubmitChanges();
}
}
internal void UpdateActividad(Actividad objActividad)
{
using (CalendarClassEntitiesDataContext dc = new CalendarClassEntitiesDataContext(App.conexionString))
{
Actividad _objActividad = dc.Actividads.Single(p => p.ActividadId == objActividad.ActividadId);
dc.SubmitChanges();
}
}
internal void DeleteNota(int NotaId)
{
using (CalendarClassEntitiesDataContext dc = new CalendarClassEntitiesDataContext(App.conexionString))
{
Nota _objNota = dc.Notas.Single(p => p.NotaId == NotaId);
dc.Notas.DeleteOnSubmit(_objNota);
dc.SubmitChanges();
}
}
internal void DeleteMateria(int materiaId)
{
using (CalendarClassEntitiesDataContext dc = new CalendarClassEntitiesDataContext(App.conexionString))
{
Materia _objMateria = dc.Materias.Single(p => p.MateriaId == materiaId);
dc.Materias.DeleteOnSubmit(_objMateria);
dc.SubmitChanges();
}
}
internal ObservableCollection<Materia> GetMaterias()
{
using (CalendarClassEntitiesDataContext dc = new CalendarClassEntitiesDataContext(App.conexionString))
{
//var query = from d in dc.Materias
// select d;
//return query;
return null;
}
}
internal void UpdateNota(Nota objNota)
{
using (CalendarClassEntitiesDataContext dc = new CalendarClassEntitiesDataContext(App.conexionString))
{
Nota _objNota = dc.Notas.Single(p => p.NotaId == objNota.NotaId);
_objNota.ValorNota = objNota.ValorNota;
_objNota.Porcentaje = objNota.Porcentaje;
dc.SubmitChanges();
}
}
void MainPage_Loaded(object sender, RoutedEventArgs e)
{
using (CalendarClassEntitiesDataContext dc = new CalendarClassEntitiesDataContext(App.conexionString))
{
App.Context.ListaMateria.Clear();
DataLoadOptions dl = new DataLoadOptions();
dl.LoadWith<Materia>(p => p.Recurso);
dl.LoadWith<Materia>(p => p.Actividads);
dc.LoadOptions = dl;
(from m in dc.Materias select m).ToList().ForEach(p => App.Context.ListaMateria.Add(p));
}
}
internal void UpdateMateria(Materia objMateria)
{
using (CalendarClassEntitiesDataContext dc = new CalendarClassEntitiesDataContext(App.conexionString))
{
Materia _objMateria = dc.Materias.Single(p => p.MateriaId == objMateria.MateriaId);
///Propiedades a actualizar
_objMateria.Nombre = objMateria.Nombre;
_objMateria.Dia = objMateria.Dia;
_objMateria.HoraDesde = objMateria.HoraDesde;
_objMateria.HoraHasta = objMateria.HoraHasta;
_objMateria.Aula = objMateria.Aula;
dc.SubmitChanges();
}
}
internal Materia GetMateriaById(int materiaId)
{
using (CalendarClassEntitiesDataContext dc = new CalendarClassEntitiesDataContext(App.conexionString))
{
DataLoadOptions dl = new DataLoadOptions();
dl.LoadWith<Materia>(p => p.Recurso);
dl.LoadWith<Materia>(p => p.Actividads);
dc.LoadOptions = dl;
var query = from m in dc.Materias
where m.MateriaId == materiaId
select m;
return query.SingleOrDefault();
}
}
void MateriaView_Loaded(object sender, RoutedEventArgs e)
{
using (CalendarClassEntitiesDataContext dc = new CalendarClassEntitiesDataContext(App.conexionString))
{
App.Context.ListaRecurso.Clear();
(from r in dc.Recurso select r).ToList().ForEach(p => App.Context.ListaRecurso.Add(p));
App.Context.ListaActividad.Clear();
(from a in dc.Actividads select a).ToList().ForEach(p => App.Context.ListaActividad.Add(p));
App.Context.ListaNota.Clear();
(from n in dc.Notas select n).ToList().ForEach(p => App.Context.ListaNota.Add(p));
}
}
private void CreateDataBase()
{
using (CalendarClassEntitiesDataContext dc = new CalendarClassEntitiesDataContext(conexionString))
{
if (!dc.DatabaseExists())
{
dc.CreateDatabase();
}
}
}
