public Boolean DeleteItemByKey(Int32 key)
{
try
{
using (SpendingHelperDBEntities context = new SpendingHelperDBEntities())
{
CSubCategoryDto subCategory = context.CSubCategoriesDto.Where(s => s.SubCategoryID == key).FirstOrDefault();
if (subCategory == null)
{
log.Info("Can't delete subCategory because it doesn't exist in database (SubCategoryid = {0})", key);
return(false);
}
context.CSubCategoriesDto.Remove(subCategory);
context.SaveChanges();
}
}
catch (Exception ex)
{
log.Error(ex, "Some error occure while trying to delete subCategory (SubCategoryId = {1}). Message: {0}", ex.Message, key);
return(false);
}
return(true);
}
public Boolean UpdateItem(CSubCategoryDto item)
{
try
{
using (SpendingHelperDBEntities context = new SpendingHelperDBEntities())
{
CSubCategoryDto subCategory = context.CSubCategoriesDto.Where(s => s.SubCategoryID == item.SubCategoryID).FirstOrDefault();
if (subCategory == null)
{
log.Info("Can't update subCategory because it doesn't exist in database (SubCategoryid = {0})", item.SubCategoryID);
return(false);
}
subCategory.ParentCategoryID = item.ParentCategoryID;
subCategory.Title = item.Title;
subCategory.Description = item.Description;
context.SaveChanges();
}
}
catch (Exception ex)
{
log.Error(ex, "Some error occure while trying to update subCategory (SubCategoryid = {1}). Message: {0}", ex.Message, item.SubCategoryID);
return(false);
}
return(true);
}
public Boolean TryDeleteSubCategory(Int32 personId, Int32 subCategoryId)
{
try
{
using (SpendingHelperDBEntities context = new SpendingHelperDBEntities())
{
CSubCategoryDto subCategoryDto = context.CSubCategoriesDto.Where(s => s.SubCategoryID == subCategoryId).FirstOrDefault();
if (subCategoryDto == null)
{
log.Warn("Can't find subCategory (id = {0}) to delete)", subCategoryId);
return(false);
}
if (subCategoryDto.PersonID != personId)
{
log.Warn("Can't delete subCategory because person (id = {0}) not an owner of subCategory (id = {1})", personId, subCategoryId);
return(false);
}
}
return(DeleteItemByKey(subCategoryId));
}
catch (Exception ex)
{
log.Error(ex, "Some error occure while trying to edit subCategory (id = {1}) into DB. Message: {0}", ex.Message, subCategoryId);
return(false);
}
}
public Boolean AddItem(CSubCategoryDto item)
{
try
{
using (SpendingHelperDBEntities context = new SpendingHelperDBEntities())
{
context.CSubCategoriesDto.Add(item);
context.SaveChanges();
}
}
catch (Exception ex)
{
log.Error(ex, "Some error occure while trying to add subCategory into DB. Message: {0}", ex.Message);
return(false);
}
return(true);
}
public Boolean TyrEditSubCategory(Int32 personId, Int32 subCategoryId, String newCategoryTitle, String newSubCategoryTitle, String newSubCategoryDescription)
{
try
{
using (SpendingHelperDBEntities context = new SpendingHelperDBEntities())
{
CSubCategoryDto subCategoryDto = context.CSubCategoriesDto.Where(s => s.SubCategoryID == subCategoryId).FirstOrDefault();
if (subCategoryDto == null)
{
log.Warn("Can't find subCategory (id = {0}) to edit)", subCategoryId);
return(false);
}
if (subCategoryDto.PersonID != personId)
{
log.Warn("Can't edit subCategory because person (id = {0}) not an owner of subCategory (id = {1})", personId, subCategoryId);
return(false);
}
if (newCategoryTitle != subCategoryDto.Category.Title)
{
CCategoryDto newCategoryDto = context.CCategoriesDto.Where(c => c.Title == newCategoryTitle).FirstOrDefault();
if (newCategoryDto == null)
{
log.Warn("Can't find new category (title = {0}) to edit subCategory(id = {1}))", newCategoryTitle, subCategoryId);
return(false);
}
subCategoryDto.ParentCategoryID = newCategoryDto.CategoryID;
}
subCategoryDto.Title = newSubCategoryTitle;
subCategoryDto.Description = newSubCategoryDescription;
context.SaveChanges();
}
}
catch (Exception ex)
{
log.Error(ex, "Some error occure while trying to edit subCategory (id = {1}) into DB. Message: {0}", ex.Message, subCategoryId);
return(false);
}
return(true);
}
public Int32 AddPayment(Int32 personId, DateTime date, String categoryTitle, String subCategoryTitle, Decimal spended)
{
try
{
using (SpendingHelperDBEntities context = new SpendingHelperDBEntities())
{
CPersonDto personDto = context.CPeopleDto
.Include("SubCategories.Category")
.Include("SubCategories.Payments")
.Where(p => p.PersonID == personId)
.FirstOrDefault();
if (personDto == null)
{
log.Info("Can't add payment because person (id = {0}) doesn't exist", personId);
return(0);
}
CSubCategoryDto subCategoryDto = personDto.SubCategories.Where(s => s.Title.Equals(subCategoryTitle) && s.Category.Title.Equals(categoryTitle)).FirstOrDefault();
if (subCategoryDto == null)
{
log.Info("Can't add payment because person (id = {0}) doesn't have subCategory (title = {1}) with category (title = {2})",
personId, subCategoryTitle, categoryTitle);
return(0);
}
CPaymentDto paymentDto = new CPaymentDto();
paymentDto.Date = date;
paymentDto.SubCategoryID = subCategoryDto.SubCategoryID;
paymentDto.Spended = spended;
//AddItem(paymentDto);
subCategoryDto.Payments.Add(paymentDto);
context.SaveChanges();
return(paymentDto.PaymentID);
}
}
catch (Exception ex)
{
log.Error(ex, "Some error occure while trying to add new payment into DB. Message: {0}", ex.Message);
return(0);
}
}
public Boolean EditPayment(Int32 personId, Int32 paymentId, DateTime newDate, String newCategoryTitle, String newSubCategoryTitle, Decimal newSum)
{
try
{
using (SpendingHelperDBEntities context = new SpendingHelperDBEntities())
{
if (context.CPaymentsDto.Where(p => p.PaymentID == paymentId).First().SubCategory.PersonID != personId)
{
log.Warn("Can't edit payment because person (id = {0}) not a owner of payment (id = {1})", personId, paymentId);
return(false);
}
CPersonDto personDto = context.CPeopleDto.Where(p => p.PersonID == personId).FirstOrDefault();
if (personDto == null)
{
log.Info("Can't edit payment because person (id = {0}) doesn't exist", personId);
return(false);
}
CSubCategoryDto subCategoryDto = personDto.SubCategories.Where(s => s.Title.Equals(newSubCategoryTitle) && s.Category.Title.Equals(newCategoryTitle)).FirstOrDefault();
if (subCategoryDto == null)
{
log.Info("Can't add payment because person (id = {0}) doesn't have subCategory (title = {1}) with category (title = {2})",
personId, newSubCategoryTitle, newCategoryTitle);
return(false);
}
CPaymentDto paymentDto = new CPaymentDto();
paymentDto.PaymentID = paymentId;
paymentDto.SubCategoryID = subCategoryDto.SubCategoryID;
paymentDto.Date = newDate;
paymentDto.Spended = newSum;
return(UpdateItem(paymentDto));
}
}
catch (Exception ex)
{
log.Error(ex, "Some error occure while trying to edit payment in DB. Message: {0}", ex.Message);
return(false);
}
}
public Int32 TryAddSubCategory(Int32 personId, String categoryTitle, String subCategoryTitle, String subCategoryDescription)
{
try
{
using (SpendingHelperDBEntities context = new SpendingHelperDBEntities())
{
CPersonDto personDto = context.CPeopleDto
.Include("SubCategories.Category")
.Where(p => p.PersonID == personId)
.FirstOrDefault();
if (personDto == null)
{
log.Info("Can't add payment because person (id = {0}) doesn't exist", personId);
return(0);
}
CCategoryDto category = context.CCategoriesDto.Where(c => c.Title.Equals(categoryTitle)).FirstOrDefault();
if (category == null)
{
log.Info("Can't add SubCategory because category (title = {0}) doesn't exist", categoryTitle);
return(0);
}
CSubCategoryDto subCatDto = new CSubCategoryDto();
subCatDto.Person = personDto;
subCatDto.Title = subCategoryTitle;
subCatDto.Description = subCategoryDescription;
subCatDto.Category = category;
context.CSubCategoriesDto.Add(subCatDto);
context.SaveChanges();
return(subCatDto.SubCategoryID);
}
}
catch (Exception ex)
{
log.Error(ex, "Some error occure while trying to add subCategory into DB. Message: {0}", ex.Message);
return(0);
}
}