public void AddNewNotice(NoticeEntity notice)
{
using (var context = new UsersContext())
{
context.Notices.Add(notice);
context.SaveChanges();
}
}
public List<NoticeRepo> GetNoticesByCategoryId(int categoryId)
{
using (var context = new UsersContext())
{
var allNotices = context.Notices.Where(x => x.CategoryId == categoryId).ToList();
var result = allNotices.Select(x => new NoticeRepo()
{
Amount = x.Amount,
CreateDate = x.CreateDate,
Description = x.Description.Length > 250 ? x.Description.Substring(0, 250) : x.Description,
ExprireDate = x.ExprireDate,
Id = x.Id,
Title = x.Title
}).ToList();
return result;
}
}
public List<CategoryRepo> GetAllCategory()
{
using (var contex = new UsersContext())
{
var allCategory = contex.Categories.Where(x => x.ParentId == null).ToList();
var result = allCategory.Select(x => new CategoryRepo
{
Id = x.Id,
Name = x.Name,
SubCategory = x.CategoryItem.Select(y => new CategoryRepo
{
Id = y.Id,
Name = y.Name
}).ToList()
}).ToList();
return result;
}
}
public NoticeRepo GetNoticeById(int id)
{
using (var context = new UsersContext())
{
var notice = context.Notices.FirstOrDefault(x => x.Id == id);
var result = new NoticeRepo()
{
Amount = notice.Amount,
CreateDate = notice.CreateDate,
Description = notice.Description,
ExprireDate = notice.ExprireDate,
Id = notice.Id,
Title = notice.Title,
Place = notice.NoticePlace.City,
CategoryName = notice.Category.Name,
CategoryId = notice.CategoryId,
NoticePlaceId = notice.NoticePlaceId
};
return result;
}
}
public List<NoticeRepo> GetNoticesByUserId()
{
using (var context = new UsersContext())
{
var allNotices = context.Notices.Where(x => x.UserProfileId == WebSecurity.CurrentUserId).ToList();
var result = allNotices.Select(x => new NoticeRepo()
{
Amount = x.Amount,
CreateDate = x.CreateDate,
Description = x.Description,
ExprireDate = x.ExprireDate,
Id = x.Id,
Title = x.Title
}).ToList();
return result;
}
}
public void UpdateNotice(NoticeEntity noticeToUpdate)
{
using (var context = new UsersContext())
{
var notice = context.Notices.FirstOrDefault(x => x.Id == noticeToUpdate.Id);
notice.Amount = noticeToUpdate.Amount;
notice.CategoryId = noticeToUpdate.CategoryId;
notice.Description = noticeToUpdate.Description;
notice.NoticePlaceId = noticeToUpdate.NoticePlaceId;
notice.Title = noticeToUpdate.Title;
context.SaveChanges();
}
}