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 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! ");
}
}
}