public ActionResult Detail(int id)
{
var baiviet = new BaiVietDAO().GetByID(id);
var nhatro = new NhaTroDAO().GetByID(baiviet.idNT);
var taikhoan = new UserDAO().GetByID(baiviet.idTK);
var result = new List <DetailModel>();
result.Add(new DetailModel
{
idBV = baiviet.idBV,
tieude = baiviet.TieuDe,
mota = baiviet.MoTa,
ngaydang = baiviet.NgayDang.ToString().Substring(0, 10),
hotentk = taikhoan.HoTen,
ngaythamgia = taikhoan.NgayTao.ToString().Substring(0, 10),
email = taikhoan.Email,
phone = taikhoan.SDT,
gia = nhatro.Gia,
lau = nhatro.Lau,
phongngu = nhatro.PhongNgu,
nhatam = nhatro.NhaTam,
dientich = nhatro.DienTich
});
ViewBag.comment = db.Comments.SqlQuery("Select * from Comment c where c.idBV = " + id);
ViewBag.Detail = result;
ViewBag.listnew = db.BaiViets.SqlQuery("select * from BaiViet where NgayDang >= GETDATE()").ToList();
return(View());
}
public ActionResult SuaBaiViet(PostingModel model)
{
BaiViet bv = db.BaiViets.Find(model.idBV);
NhaTro nt = db.NhaTroes.Find(bv.idNT);
bv.TieuDe = model.TieuDe;
bv.TieuDePhu = model.TieuDePhu;
bv.MoTa = model.MoTa;
nt.SoNha = model.SoNha;
nt.Gia = model.Gia;
nt.Lau = model.Lau;
nt.idPhuong = model.idPhuong;
nt.idQuan = model.idQuan;
nt.PhongNgu = model.PhongNgu;
nt.NhaTam = model.NhaTam;
var bvdao = new BaiVietDAO();
bvdao.Update(bv);
var ntdao = new NhaTroDAO();
int idnt = (int)bv.idNT;
ntdao.Update(nt, idnt);
return(RedirectToAction("PostsManager", "Posting"));
}
public ActionResult MyContent(int page = 1, int pagesize = 10)
{
if (Session[Common.CommonConstants.USER_SESSION] == null)
{
return(Redirect("/User/Login"));
}
else
{
var session = (UserLogin)Session[Common.CommonConstants.USER_SESSION];
var model = new BaiVietDAO().ListAllByUser(session.UserName, page, pagesize);
int totalRecord = 0;
ViewBag.Total = totalRecord;
ViewBag.Page = page;
//ViewBag.Tagid = new BaiVietDAO().getTag(tagid);
int maxPage = 10;
int totalPage = 0;
totalPage = (int)Math.Ceiling((double)(totalRecord / pagesize));
ViewBag.TotalPage = totalPage;
ViewBag.MaxPage = maxPage;
ViewBag.First = 1;
ViewBag.Last = totalPage;
ViewBag.Next = page + 1;
ViewBag.Prev = page - 1;
return(View(model));
}
}
// GET: Admin/BaiViet
public ActionResult Index(string searchString, int page = 1, int pageSize = 5)
{
var dao = new BaiVietDAO();
var model = dao.ListAllPaging(searchString, page, pageSize);
ViewBag.SearchString = searchString;
return(View(model));
}
public ActionResult EditContent(long id)
{
var dao = new BaiVietDAO();
var baiviet = dao.GetBaiVietByID(id);
setViewBag(baiviet.IDChuDe);
return(View(baiviet));
}
public ActionResult Index(string SearchBaiViet, int page = 1, int pagesize = 4)
{
var dao = new BaiVietDAO();
var model = dao.ListAllPaging(SearchBaiViet, page, pagesize);
ViewBag.SearchBaiViet = SearchBaiViet;
return(View(model));
}
public ActionResult ListBaiViet(long id, int page = 1, int pageSize = 6)
{
ViewBag.DanhMuc = new BaiVietDAO().ListAll();
var dao = new BaiVietDAO();
var model = new BaiVietDAO().DanhSachBaiViet(id, page, pageSize);
return(View(model));
}
public ActionResult Edit(long id)
{
var dao = new BaiVietDAO();
var content = dao.GetByID(id);
LoadDanhMuc(content.DanhMucID);
return(View(content));
}
public ActionResult BaiViet(long id)
{
ViewBag.BaiVietNew = new BaiVietDAO().ListbvNew(3);
ViewBag.DanhMuc = new BaiVietDAO().GetDanhMucBaiViet();
ViewBag.Bvlienquan = new BaiVietDAO().ListbvLienQuan(id);
var sp = new BaiVietDAO().GetByID(id);
return(View(sp));
}
public JsonResult ChangeStatus(long id)
{
var result = new BaiVietDAO().ChangeStatusBaiViet(id);
return(Json(new
{
status = result
}));
}
public ActionResult Detail(long id)
{
var model = new BaiVietDAO().GetBaiVietByID(id);
ViewBag.Tag = new BaiVietDAO().ListTags(id);
ViewBag.BaiVietCMT = new BaiVietCommentDAO().ListAll(id);
return(View(model));
}
// GET: Home
public ActionResult Index()
{
var sanphamdao = new SanPhamDAO();
var danhmucspdao = new DanhMucSPDAO();
var baivietdao = new BaiVietDAO();
ViewBag.newarrivals = sanphamdao.ListProductNewArrivals(10);
ViewBag.bestseller = sanphamdao.ListProductBestSeller(10);
ViewBag.productcategories = danhmucspdao.ListAll();
ViewBag.baiviethome = baivietdao.listHomeContent(3);
return(View());
}
public ActionResult Posting(PostingModel model)
{
if (ModelState.IsValid)
{
if (model.ImageUpload != null)
{
string fileName = Path.GetFileNameWithoutExtension(model.ImageUpload.FileName);
//string extension = Path.GetExtension(model.ImageUpload.FileName);
//file.SaveAs(Server.MapPath("~/Content/Images/" + file.FileName));
model.Images = "~/Content/Images/" + fileName;
}
var daoNT = new NhaTroDAO();
var daoPost = new BaiVietDAO();
var bv = new BaiViet();
var nt = new NhaTro();
nt.DienTich = model.DienTich;
nt.PhongNgu = model.PhongNgu;
nt.Lau = model.Lau;
nt.NhaTam = model.NhaTam;
nt.Gia = model.Gia;
nt.SoNha = model.SoNha;
nt.idPhuong = model.idPhuong;
nt.Image = model.Images;
nt.idQuan = model.idQuan;
daoNT.Insert(nt);
NhaTro temp = db.NhaTroes.OrderByDescending(p => p.idNT).FirstOrDefault();
bv.TieuDe = model.TieuDe;
bv.TieuDePhu = model.TieuDePhu;
bv.MoTa = model.MoTa;
bv.TrangThai = false;
DateTime now = DateTime.Now;
bv.NgayDang = now;
bv.idNT = temp.idNT;
var session = (DACN.Common.UserLogin)Session[DACN.Common.CommonConstants.USER_SESSION];
string ten = session.UserName;
TaiKhoan tk = db.TaiKhoans.Find(session.userID);
bv.idTK = tk.idTK;
daoPost.Insert(bv);
}
return(View("Posted", model));
}
public ActionResult ViewByTag(string tagid, int page = 1, int pagesize = 10)
{
var model = new BaiVietDAO().ListAllByTag(tagid, page, pagesize);
int totalRecord = 0;
ViewBag.Total = totalRecord;
ViewBag.Page = page;
ViewBag.Tagid = new BaiVietDAO().getTag(tagid);
int maxPage = 10;
int totalPage = 0;
totalPage = (int)Math.Ceiling((double)(totalRecord / pagesize));
ViewBag.TotalPage = totalPage;
ViewBag.MaxPage = maxPage;
ViewBag.First = 1;
ViewBag.Last = totalPage;
ViewBag.Next = page + 1;
ViewBag.Prev = page - 1;
return(View(model));
}
public ActionResult SuaBaiViet(DetailModel model)
{
var bv = db.BaiViets.Find(model.idBV);
var nt = new NhaTroDAO().GetByID(bv.idNT);
bv.TieuDe = model.tieude;
bv.TieuDePhu = model.tieudephu;
bv.MoTa = model.mota;
nt.Lau = model.lau;
nt.NhaTam = model.nhatam;
nt.PhongNgu = model.phongngu;
nt.DienTich = model.dientich;
var bvdao = new BaiVietDAO();
bvdao.Update(bv);
var ntdao = new NhaTroDAO();
int idnt = (int)bv.idNT;
ntdao.Update(nt, idnt);
return(RedirectToAction("QLBV", "Home"));
}
public ActionResult Index()
{
// List<PieChartModel> dataPoints = new List<PieChartModel>();
// dataPoints.Add(new PieChartModel("Samsung", 25));
// dataPoints.Add(new PieChartModel("Micromax", 13));
// dataPoints.Add(new PieChartModel("Lenovo", 8));
// dataPoints.Add(new PieChartModel("Intex", 7));
// dataPoints.Add(new PieChartModel("Reliance", 6.8));
// dataPoints.Add(new PieChartModel("Others", 40.2));
// ViewBag.DataPoints = JsonConvert.SerializeObject(dataPoints);
var sanphamdao = new SanPhamDAO();
var baivietdao = new BaiVietDAO();
var hoadondao = new HoaDonDAO();
var chitiethoadondao = new ChiTietHoaDonDAO();
ViewBag.CountProduct = sanphamdao.CountProduct();
ViewBag.CountContent = baivietdao.CountContent();
ViewBag.CountPendingOrders = hoadondao.CountPendingOrders();
ViewBag.SumOrder = chitiethoadondao.SumOrder();
return(View());
}
public ActionResult Edit(BaiViet model)
{
if (ModelState.IsValid)
{
var dao = new BaiVietDAO();
var session = (UserLogin)Session[CommonConstants.USER_SESSION];
model.NguoiUpdate = session.UserName;
var culture = Session[CommonConstants.CurrentCulture];
var result = dao.Edit(model);
if (result)
{
SetAlert("Sửa bài viết thành công", "success");
return(RedirectToAction("Index", "BaiViet"));
}
else
{
ModelState.AddModelError("", "Cập nhật bài viết không thành công");
}
}
LoadDanhMuc();
return(View());
}
