public bool DeleteItemByKey(CPersonalTargetKey key)
{
try
{
using (SpendingHelperDBEntities context = new SpendingHelperDBEntities())
{
CPersonalTargetDto target = context.CPersonalTargetsDto.Where(t => t.PersonID == key.PersonId &&
t.CategoryID == key.CategoryId &&
t.Month == key.Month)
.FirstOrDefault();
if (target == null)
{
log.Info("Can't delete CPersonalTarget because it doesn't exist in database (PersonId = {0}, categoryId = {1}, date = {2})",
key.PersonId, key.CategoryId, key.Month);
return(false);
}
context.CPersonalTargetsDto.Remove(target);
context.SaveChanges();
}
}
catch (Exception ex)
{
log.Error(ex, "Some error occure while trying to delete CPersonalTargets (PersonId = {1}, categoryId = {2}, date = {3}). Message: {0}",
ex.Message, key.PersonId, key.CategoryId, key.Month);
return(false);
}
return(true);
}
public CPersonalTargetDto FindItemByKey(CPersonalTargetKey key)
{
try
{
using (SpendingHelperDBEntities context = new SpendingHelperDBEntities())
{
return(context.CPersonalTargetsDto.Where(t => t.PersonID == key.PersonId &&
t.CategoryID == key.CategoryId &&
t.Month == key.Month)
.FirstOrDefault());
}
}
catch (Exception ex)
{
log.Error(ex, "Some error occure while trying to find CPersonalTargets by key (PersonId = {1}, categoryId = {2}, date = {3}). Message: {0}",
ex.Message, key.PersonId, key.CategoryId, key.Month);
return(null);
}
}