internal int AddList(int userId)
{
using (DataContext)
{
try
{
SummeryList summeryList =
(from p in DataContext.SummeryLists where p.CREATED_BY == userId && p.ACTIVE select p).
SingleOrDefault();
if (summeryList == null)
{
summeryList = new SummeryList {
CREATED_BY = userId, CREATE_DATE = DateTime.Today, ACTIVE = true
};
DataContext.SummeryLists.InsertOnSubmit(summeryList);
DataContext.SubmitChanges();
}
return(summeryList.ID);
}
catch
{
return(-1);
}
}
}
internal void DeleteList(int listId)
{
using (DataContext)
{
try
{
SummeryList summeryList =
(from p in DataContext.SummeryLists where p.CREATED_BY == listId select p).Single();
DataContext.SummeryLists.DeleteOnSubmit(summeryList);
DataContext.SubmitChanges();
}
catch (Exception)
{
}
}
}
