public bool DeleteItemByKey(CReminderKey key)
{
try
{
using (SpendingHelperDBEntities context = new SpendingHelperDBEntities())
{
CReminderDto reminder = context.CRemindersDto.Where(r => r.PersonID == key.PersonId && r.Title.Equals(key.Title)).FirstOrDefault();
if (reminder == null)
{
log.Info("Can't delete reminder because it doesn't exist in database id = {0}, Title: {1}", key.PersonId, key.Title);
return(false);
}
context.CRemindersDto.Remove(reminder);
context.SaveChanges();
}
}
catch (Exception ex)
{
log.Error(ex, "Some error occure while trying to delete CReminders (id = {1} title: {2}). Message: {0}", ex.Message, key.PersonId, key.Title);
return(false);
}
return(true);
}
public CReminderDto FindItemByKey(CReminderKey key)
{
try
{
using (SpendingHelperDBEntities context = new SpendingHelperDBEntities())
{
return(context.CRemindersDto.Where(r => r.PersonID == key.PersonId && r.Title.Equals(key.Title)).FirstOrDefault());
}
}
catch (Exception ex)
{
log.Error(ex, "Some error occure while trying to find CReminders by key (id = {1} title: {2}). Message: {0}", ex.Message, key.PersonId, key.Title);
return(null);
}
}
