public IList <Relatorio> Delete(long Id)
{
IList <Relatorio> relatorioList = null;
using (RelatorioDataBaseContext context = new RelatorioDataBaseContext(RelatorioDataBaseContext.ConnectionString))
{
try
{
IQueryable <Relatorio> query =
from c in context.RelatorioTable
where c.Id == Id
select c;
Relatorio relatorioToDelete = query.FirstOrDefault();
context.RelatorioTable.DeleteOnSubmit(relatorioToDelete);
context.SubmitChanges();
}
catch (Exception e)
{
Debug.WriteLine(e.StackTrace);
Debug.WriteLine(e.Message);
MessageBox.Show("PROBLEMA NA LISTAGEM POR DATA");
}
}
return(relatorioList);
}
public IList <Relatorio> ListaPorData(DateTime data)
{
IList <Relatorio> relatorioList = new List <Relatorio>();
using (RelatorioDataBaseContext context = new RelatorioDataBaseContext(RelatorioDataBaseContext.ConnectionString))
{
try
{
IQueryable <Relatorio> query =
from c in context.RelatorioTable
where c.Data.Month == data.Month && c.Data.Year == data.Year
orderby c.Data descending
select c;
relatorioList = query.ToList();
}
catch (Exception e)
{
Debug.WriteLine(e.StackTrace);
Debug.WriteLine(e.Message);
MessageBox.Show("PROBLEMA NA LISTAGEM POR DATA");
}
}
return(relatorioList);
}
public Estudo GetByDate(DateTime data)
{
IList <Estudo> resultList = new List <Estudo>();
using (RelatorioDataBaseContext context = new RelatorioDataBaseContext(RelatorioDataBaseContext.ConnectionString))
{
try
{
IQueryable <Estudo> query =
from c in context.EstudoTable
where c.Data.Month == data.Month && c.Data.Year == data.Year
orderby c.Data descending
select c;
resultList = query.ToList();
if (resultList != null && resultList.Count() > 0)
{
return(resultList.ElementAt(0));
}
}
catch (Exception e)
{
Debug.WriteLine(e.StackTrace);
Debug.WriteLine(e.Message);
MessageBox.Show("PROBLEMA NA LISTAGEM POR DATA");
}
}
return(null);
}
public void Clear()
{
using (RelatorioDataBaseContext context =
new RelatorioDataBaseContext(RelatorioDataBaseContext.ConnectionString))
{
try
{
context.DeleteDatabase();
}
catch (Exception e)
{
Debug.WriteLine(e.StackTrace);
Debug.WriteLine(e.Message);
MessageBox.Show("PROBLEMA AO APAGAR! ");
}
}
}
public void Add(Relatorio relatorio)
{
using (RelatorioDataBaseContext context =
new RelatorioDataBaseContext(RelatorioDataBaseContext.ConnectionString))
{
try
{
context.RelatorioTable.InsertOnSubmit(relatorio);
context.SubmitChanges();
}
catch (Exception e)
{
Debug.WriteLine(e.StackTrace);
Debug.WriteLine(e.Message);
MessageBox.Show("PROBLEMA AO ADICIONAR! ");
}
}
}
public IList <Relatorio> Lista()
{
IList <Relatorio> relatorioList = null;
using (RelatorioDataBaseContext context = new RelatorioDataBaseContext(RelatorioDataBaseContext.ConnectionString))
{
try
{
IQueryable <Relatorio> query = from c in context.RelatorioTable select c;
relatorioList = query.ToList();
}
catch (Exception e)
{
Debug.WriteLine(e.StackTrace);
Debug.WriteLine(e.Message);
MessageBox.Show("PROBLEMA NA LISTAGEM! ");
}
}
return(relatorioList);
}
public int CountPorData(DateTime data)
{
int count = 0;
using (RelatorioDataBaseContext context = new RelatorioDataBaseContext(RelatorioDataBaseContext.ConnectionString))
{
try
{
count =
(from c in context.EstudoTable
where c.Data.Month == data.Month && c.Data.Year == data.Year
select c).Count();
}
catch (Exception e)
{
Debug.WriteLine(e.StackTrace);
Debug.WriteLine(e.Message);
MessageBox.Show("PROBLEMA NA LISTAGEM POR DATA");
}
}
return(count);
}
public IList <Relatorio> ListaRelatorioAnual(DateTime data)
{
int mesReferencia = 9;
int anoReferencia = data.Year;
if (data.Month < mesReferencia)
{
anoReferencia = data.Year - 1;
}
IList <Relatorio> relatorioList = new List <Relatorio>();
using (RelatorioDataBaseContext context = new RelatorioDataBaseContext(RelatorioDataBaseContext.ConnectionString))
{
try
{
IQueryable <Relatorio> query =
from c in context.RelatorioTable
where
(c.Data.Month >= mesReferencia &&
c.Data.Year == anoReferencia) ||
(c.Data.Month <= data.Month &&
c.Data.Year == data.Year)
orderby c.Data descending
select c;
relatorioList = query.ToList();
}
catch (Exception e)
{
Debug.WriteLine(e.StackTrace);
Debug.WriteLine(e.Message);
MessageBox.Show("PROBLEMA NA LISTAGEM POR DATA");
}
}
return(relatorioList);
}
