public int AddEditBaiViet(AddBaiViet model)
{
int kq = 0;
bool isAdd = true;
BaiViet baiviet = new BaiViet();
baiviet.ID = model.ID.Value;
baiviet.IDLoaiBaiViet = model.IDLoaiBaiViet;
baiviet.TieuDe = model.TenBaiViet;
baiviet.NoiDung = model.NoiDung;
baiviet.linkIMG = model.linkIMG;
if (model.ID == null)
{
isAdd = false;
baiviet.isCapNhat = true;
baiviet.NgayCapNhat = DateTime.Now;
}
else
{
baiviet.IDNguoiTao = null;// nua cap nhat sau
baiviet.NgayTao = DateTime.Now;
}
using (var db = new DB_ForumEntities())
{
if (isAdd)
{
db.BaiViets.Add(baiviet);
}
db.SaveChanges();
}
return(kq);
}
public List <DanhMucViewModel> GetDanhMucLoai()
{
db = new DB_ForumEntities();
return(db.DM_Loai.Select(m => new DanhMucViewModel()
{
id = m.ID, ten = m.TenLoai, countbaiviet = m.BaiViets.Count
}).ToList());
}
public List <SelectListItem> GetDanhMucForSelect()
{
db = new DB_ForumEntities();
return(db.DM_Loai.Select(m => new SelectListItem()
{
Value = m.ID.ToString(),
Text = m.TenLoai,
}).ToList());
}
public List <ListBaiViet> GetDanhSachBaiViet()
{
db = new DB_ForumEntities();
var lst = db.BaiViets.Select(m => new ListBaiViet
{
ID = m.ID,
countCmt = m.Cmt_BaiViet.Count(),
countLike = m.Like_BaiViet.Count(),
IDNguoiDang = m.AspNetUser.Id,
linkIMG = m.linkIMG,
NgayDang = (m.NgayCapNhat.HasValue) ? m.NgayCapNhat : m.NgayTao,
TenBaiViet = m.TieuDe,
TenNguoiDang = m.AspNetUser.FullName
}).ToList();
return(lst);
}
