public ActionResult ThemBaiViet(FormCollection frm, BaiViet baiviet, HttpPostedFileBase AnhDaiDien)
{
try
{
ViewBag.ID = new SelectList(db.DanhMucs.Where(n => (n.ID != 1 && n.ID != 2 && n.ID != 1002)).ToList().OrderBy(n => n.TenDanhMuc), "ID", "TenDanhMuc");
string path = Server.MapPath("~/Content/Images/baiviet/");
AnhDaiDien.SaveAs(path + Path.GetFileName(AnhDaiDien.FileName));
baiviet.AnhDaiDien = AnhDaiDien.FileName;
baiviet.DanhMuc = int.Parse(frm["ID"]);
baiviet.TenBaiViet = frm["TenBaiViet"];
baiviet.Keywords = frm["MetaKeywords"];
baiviet.Description = frm["MetaDescription"];
baiviet.MetaTitle = frm["MetaTitle"];
baiviet.Title = frm["Title"];
baiviet.CapNhat = DateTime.Parse(DateTime.Now.ToString());
baiviet.NoiDung = frm["NoiDung"];
db.BaiViets.Add(baiviet);
db.SaveChanges();
return(RedirectToAction("BaiViet", "Admin"));
}
catch (Exception ex)
{
}
return(View());
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
BaiViet bv = new BaiViet();
//get bài viết theo id
int id = Convert.ToInt32(Request.QueryString["id"]);
bv = data.GetABaiViet(id);
//đổ dữ liệu lên view
lblTieude.Text = bv.tieuDe;
lblChuyenmuc.Text = data.GetTenChuyenMuc(bv.id_cm);
lblCM.Text = data.GetTenChuyenMuc(bv.id_cm);
lblNgaydang.Text = bv.ngayTao.ToString();
lblXem.Text = bv.luotXem.ToString();
lblNoidung.Text = bv.noiDung;
lbltenND.Text = bv.tenND;
//title, description, keyword meta
Page.Title = bv.tieuDe;
Page.MetaDescription = bv.moTa;
Page.MetaKeywords = bv.tuKhoa;
//luot xem
data.LuotXemBV(id);
dataBinhLuan.DataSource = data.GetBinhLuanBV(id);
dataBinhLuan.DataBind();
}
catch {
Response.Redirect("/");
}
}
public ActionResult Sua(BaiViet bv, HttpPostedFileBase myfileImage)
{
ViewBag.LoaiBaiViet = new SelectList(db.LoaiBaiViets, "maLoai", "tenLoai", bv.maLoai);
if (myfileImage == null)
{
ViewBag.ThongBao = "Vui lòng chọn Ảnh Bìa";
return(View(bv));
}
else
{
if (ModelState.IsValid)
{
var filename = Path.GetFileName(myfileImage.FileName);
var path = Path.Combine(Server.MapPath("~/Content/images/"), filename);
if (System.IO.File.Exists(path))
{
ViewBag.ThongBao = "Hình ảnh đã tồn tại";
}
else
{
myfileImage.SaveAs(path);
}
bv.hinhAnh = filename;
UpdateModel(bv);
db.SaveChanges();
}
return(RedirectToAction("TrangChu", "TrangChu"));
}
}
protected void btnThem_Click(object sender, EventArgs e)
{
try
{
BaiViet bv = new BaiViet();
bv.tieuDe = txtTieuDe.Text;
bv.id_cm=Convert.ToInt16(ddChuyenMuc.Text.ToString());
NguoiDung nd = (NguoiDung)Session["login"];
bv.id_nd = nd.id;//id nguoi dung
bv.noiDung=txtNoiDung.Text;
bv.moTa=txtMota.Text;
bv.tuKhoa=txtTuKhoa.Text;
//file upload
string path = Server.MapPath("~/Upload/")+hinhAnh.FileName;
hinhAnh.PostedFile.SaveAs(path);
bv.hinhAnh = "/Upload/" + hinhAnh.FileName;
//end upload
bv.ngayTao=Convert.ToDateTime(DateTime.Now.ToString());
bv.trangThai = Convert.ToInt32(rdtrangThai.Text);
if (nd.quyen == 0) bv.phanLoai = 0;//nếu quyền = 0 thì phân loại = 0 => phải kiểm duyệt
else bv.phanLoai = 1;//nếu quyền = 1 thì không phải kiểm duyệt bài viết
data.ThemBaiViet(bv);
Response.Redirect("TinTuc.aspx");
}
catch (Exception ex)
{
Response.Write("<script>alert(" + ex.Message + ");</script>");
}
}
public BaiViet GetABaiViet(int id)
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"SELECT tblBaiViet.*, tenCM , hoTen
FROM tblChuyenMuc INNER JOIN tblBaiViet
ON tblBaiViet.id_CM = tblChuyenMuc.id
INNER JOIN tblNguoiDung
ON tblNguoiDung.id = tblBaiViet.id_ND
WHERE tblBaiViet.id = @id";
cmd.Connection = con;
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader rd = cmd.ExecuteReader();
BaiViet bv = new BaiViet();
if (rd.Read())
{
bv.id_cm = Convert.ToInt32(rd["id_CM"]);
bv.tenND = Convert.ToString(rd["hoTen"]);
bv.id_nd = Convert.ToInt32(rd["id_ND"]);
//bv.tenCM = Convert.ToString(rd["tenCM"]);
bv.tieuDe = Convert.ToString(rd["tieuDe"]);
bv.noiDung = Convert.ToString(rd["noiDung"]);
bv.moTa = Convert.ToString(rd["moTa"]);;
bv.tuKhoa = Convert.ToString(rd["tuKhoa"]);
bv.hinhAnh = Convert.ToString(rd["hinhAnh"]);
bv.ngayTao = Convert.ToDateTime(rd["ngayTao"]);
bv.trangThai = Convert.ToInt32(rd["trangThai"]);
bv.luotXem = Convert.ToInt32(rd["luotXem"]);
}
con.Close();
return bv;
}
public ActionResult Admin_ChangeStatePost(int ID, int stt)
{
//if (ID == null || stt == null)
//{
// return HttpNotFound("NULL ID or STT");
//}
if (stt < 0 || stt > 4)
{
return(HttpNotFound("Wrong status"));
}
BaiViet baiviet = db.BaiViets.SingleOrDefault(t => t.ID == ID);
if (baiviet == null)
{
return(HttpNotFound("Bai Viet not found!"));
}
baiviet.Trangthai = stt;
db.Entry(baiviet).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", "BaiViets"));
}
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
DataAccess data = new DataAccess();
ddChuyenMuc.DataSource = data.GetAllChuyenMuc();
ddChuyenMuc.DataValueField = "id";
ddChuyenMuc.DataTextField = "tenCM";
ddChuyenMuc.DataBind();
BaiViet bv = new BaiViet();
bv = data.GetABaiViet(Convert.ToInt32(Request.QueryString["id"]));
txtTieuDe.Text = bv.tieuDe.ToString();
ddChuyenMuc.Text = bv.id_cm.ToString();
oldHinhAnh.ImageUrl = bv.hinhAnh.ToString();
txtNoiDung.Text = bv.noiDung;
txtMota.Text = bv.moTa;
txtTuKhoa.Text = bv.tuKhoa;
if (bv.trangThai == 1) rd1.Checked = true;
else rd0.Checked = true;
//if (rdv.Equals(1)
//{
// rdtrangThai.Items.FindByValue("1").Selected = true;
// rdtrangThai.Items.FindByValue("0").Selected = false;
//}
//else
//{
// rdtrangThai.Items.FindByValue("0").Selected = true;
// rdtrangThai.Items.FindByValue("1").Selected = false;
//}
}
}
public ActionResult Edit([Bind(Include = "ID,TieuDe,NoiDung,NguoiDang,NgayCapNhat,Trangthai,Tabs,linkImage")] BaiViet baiviet)
{
BaiViet testbai = db.BaiViets.SingleOrDefault(t => t.ID == baiviet.ID);
if (checkUser(testbai) == false)
{
return(HttpNotFound("Bài viết này không thuộc về bạn"));
}
if (ModelState.IsValid)
{
testbai.NgayCapNhat = DateTime.Now;
testbai.NguoiDang = User.Identity.GetUserId();
testbai.NoiDung = baiviet.NoiDung;
testbai.Tabs = baiviet.Tabs;
testbai.TieuDe = baiviet.TieuDe;
testbai.Trangthai = 0;
testbai.linkImage = baiviet.linkImage;
db.Entry(testbai).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.NguoiDang = new SelectList(db.AspNetUsers, "Id", "UserName", baiviet.NguoiDang);
return(View(baiviet));
}
public BaiViet GetDataByMa(string MaBaiViet)
{
try
{
BaiViet baiViet = null;
DataTable dt = dataProvider.ExecuteQuery("Proc_BaiViet_GetData", new object[] { MaBaiViet }, new List <string>()
{
"@MaBaiViet"
});
if (dt != null && dt.Rows.Count > 0)
{
var row = dt.Rows[0];
baiViet = new BaiViet();
baiViet.MaBaiViet = String.IsNullOrEmpty(row["MaBaiViet"].ToString()) ? 0 : int.Parse(row["MaBaiViet"].ToString());
baiViet.MaNV = String.IsNullOrEmpty(row["MaNV"].ToString()) ? 0 : int.Parse(row["MaNV"].ToString());
baiViet.TenBaiViet = String.IsNullOrEmpty(row["TenBaiViet"].ToString()) ? "" : row["TenBaiViet"].ToString();
baiViet.NoiDung = String.IsNullOrEmpty(row["NoiDung"].ToString()) ? "" : row["NoiDung"].ToString();
baiViet.NgaySua = String.IsNullOrEmpty(row["NgaySua"].ToString()) ? DateTime.Now : Convert.ToDateTime(row["NgaySua"]);
baiViet.NgayTao = String.IsNullOrEmpty(row["NgayTao"].ToString()) ? DateTime.Now : Convert.ToDateTime(row["NgayTao"]);
baiViet.TrangThaiHienThi = String.IsNullOrEmpty(row["TrangThaiHienThi"].ToString()) ? 0 : int.Parse(row["TrangThaiHienThi"].ToString());
}
return(baiViet);
}
catch (Exception ex)
{
return(null);
}
}
public HttpResponseMessage Delete(HttpRequestMessage request, int id)
{
BaiViet modelBaiViet = null;
try
{
var listBinhLuan = _binhLuanService.BinhLuanWithIdBaiViet(id);
foreach (var item in listBinhLuan)
{
_binhLuanService.Delete(item.IdBinhLuan);
}
_baiVietService.SaveChange();
modelBaiViet = _baiVietService.Delete(id);
_baiVietService.SaveChange();
if (modelBaiViet != null)
{
Message = "Xóa Bài Viet thành công";
}
else
{
throw new DbEntityValidationException("Xóa Bài Viet không thành công");
}
}
catch (DbEntityValidationException ex)
{
LogException(ex);
}
return(GetResponseMessage(IsSuccess, Message, 1, modelBaiViet));
}
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);
}
//
// GET: /BaiViet/
public ActionResult DanhSach(string id)
{
byte ChuDeID = (id == null) ? (byte)0 : Byte.Parse(id);
List <BaiViet> l_BaiViet = new BaiViet().GetPaginationList(1, 6, ChuDeID, 0);
return(View(l_BaiViet));
}
protected void btnDangBai_Click(object sender, EventArgs e)
{
//if (Page.IsValid && fHinhAnh.HasFile)
//{
// string fileName = "images/" + fHinhAnh.FileName;
// string filePath = MapPath(fileName);
// fHinhAnh.SaveAs(filePath);
//}
string tieuDe = txtTieuDe.Text;
int chuyenMuc = Convert.ToInt32(ddlChuyenMuc.Text);
string moTaNgan = txtMoTaNgan.Text;
string hinhAnh = fHinhAnh.FileName;
string thongTinChiTiet = txtThongTinChiTiet.Text;
int dacSan = Convert.ToInt32(ddlDacSan.Text);
decimal giaBan = Convert.ToDecimal(txtGiaBan.Text);
int trangThai = Convert.ToInt32(ddlTrangThai.Text);
BaiViet obj = new BaiViet(tieuDe, chuyenMuc, moTaNgan, hinhAnh, thongTinChiTiet, 1, dacSan, giaBan, trangThai);
XuLyBaiViet xl = new XuLyBaiViet();
if (xl.ThemBaiViet(obj) <= 0)
{
lblError.Text = "Đăng bài không thành công. Vui lòng kiểm tra lại dữ liệu nhập vào";
}
else
{
Response.Redirect("Post.aspx");
}
}
public int baiviet_capnhat(short ID, string TieuDe, string SoLuoc, string NoiDung, byte ChuDeID, int LopHocID, string URL)
{
if (ID == 0)
{
BaiViet bv = new BaiViet();
bv.TieuDe = TieuDe;
bv.SoLuoc = SoLuoc;
bv.NoiDung = NoiDung;
bv.LopHocID = LopHocID;
bv.ChuDeID = ChuDeID;
bv.IP = CommonFunc.getIPAddress();
bv.URL = URL;
bv.LuotXem = 0;
bv.NgayDang = DateTime.Now.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
return(bv.Add());
}
else
{
BaiViet bv = new BaiViet().FindByID(ID);
if (!URL.Equals(bv.URL))
{
deleteFile(bv.URL);
}
bv.TieuDe = TieuDe;
bv.SoLuoc = SoLuoc;
bv.NoiDung = NoiDung;
bv.ChuDeID = ChuDeID;
bv.LopHocID = LopHocID;
bv.URL = URL;
return(bv.Update());
}
}
public BaiViet GetABaiViet(int id)
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"SELECT tblBaiViet.*, tenCM , hoTen
FROM tblChuyenMuc INNER JOIN tblBaiViet
ON tblBaiViet.id_CM = tblChuyenMuc.id
INNER JOIN tblNguoiDung
ON tblNguoiDung.id = tblBaiViet.id_ND
WHERE tblBaiViet.id = @id";
cmd.Connection = con;
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader rd = cmd.ExecuteReader();
BaiViet bv = new BaiViet();
if (rd.Read())
{
bv.id_cm = Convert.ToInt32(rd["id_CM"]);
bv.tenND = Convert.ToString(rd["hoTen"]);
bv.id_nd = Convert.ToInt32(rd["id_ND"]);
//bv.tenCM = Convert.ToString(rd["tenCM"]);
bv.tieuDe = Convert.ToString(rd["tieuDe"]);
bv.noiDung = Convert.ToString(rd["noiDung"]);
bv.moTa = Convert.ToString(rd["moTa"]);;
bv.tuKhoa = Convert.ToString(rd["tuKhoa"]);
bv.hinhAnh = Convert.ToString(rd["hinhAnh"]);
bv.ngayTao = Convert.ToDateTime(rd["ngayTao"]);
bv.trangThai = Convert.ToInt32(rd["trangThai"]);
bv.luotXem = Convert.ToInt32(rd["luotXem"]);
}
con.Close();
return(bv);
}
public HttpResponseMessage Create(HttpRequestMessage request, BaiViet baiViet)
{
BaiViet modelBaiViet = null;
try
{
baiViet.NgayDang = DateTime.Now;
baiViet.TrangThai = true;
baiViet.SoCmt = 0;
baiViet.SoLike = 0;
modelBaiViet = _baiVietService.Add(baiViet);
if (modelBaiViet != null)
{
Message = "Tạo mới Bài Viet thành công";
_baiVietService.SaveChange();
}
else
{
throw new DbEntityValidationException("tạo Bài Viet không thành công");
}
}
catch (DbEntityValidationException ex)
{
LogException(ex);
}
return(GetResponseMessage(IsSuccess, Message, 1, modelBaiViet));
}
public List <BaiViet> GetData()
{
try
{
List <BaiViet> dsBaiViet = new List <BaiViet>();
DataTable dt = dataProvider.ExecuteQuery("Proc_BaiViet_GetData", null, null);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
BaiViet baiViet = new BaiViet();
baiViet.MaBaiViet = String.IsNullOrEmpty(row["MaBaiViet"].ToString()) ? 0 : int.Parse(row["MaBaiViet"].ToString());
baiViet.MaNV = String.IsNullOrEmpty(row["MaNV"].ToString()) ? 0 : int.Parse(row["MaNV"].ToString());
baiViet.TenBaiViet = String.IsNullOrEmpty(row["TenBaiViet"].ToString()) ? "" : row["TenBaiViet"].ToString();
baiViet.NoiDung = String.IsNullOrEmpty(row["NoiDung"].ToString()) ? "" : row["NoiDung"].ToString();
baiViet.NgaySua = String.IsNullOrEmpty(row["NgaySua"].ToString()) ? DateTime.Now : Convert.ToDateTime(row["NgaySua"]);
baiViet.NgayTao = String.IsNullOrEmpty(row["NgayTao"].ToString()) ? DateTime.Now : Convert.ToDateTime(row["NgayTao"]);
baiViet.TrangThaiHienThi = String.IsNullOrEmpty(row["TrangThaiHienThi"].ToString()) ? 0 : int.Parse(row["TrangThaiHienThi"].ToString());
dsBaiViet.Add(baiViet);
}
return(dsBaiViet);
}
return(new List <BaiViet>());
}
catch (Exception ex)
{
return(new List <BaiViet>());
}
}
public HttpResponseMessage KhoaMo(HttpRequestMessage request, int id)
{
BaiViet modelBaiViet = null;
try
{
_baiVietService.KhoaMo(id);
_baiVietService.SaveChange();
modelBaiViet = _baiVietService.GetById(id);
if (modelBaiViet != null)
{
if (modelBaiViet.TrangThai != null && (bool)modelBaiViet.TrangThai)
{
Message = "Mở Bài Viet thành công";
}
else
{
Message = "Khóa Bài Viet thành công";
}
}
else
{
throw new DbEntityValidationException("Khóa mở Bài Viet không thành công");
}
}
catch (DbEntityValidationException ex)
{
LogException(ex);
}
return(GetResponseMessage(IsSuccess, Message, 1, modelBaiViet));
}
protected void btnThem_Click(object sender, EventArgs e)
{
BaiViet bv = new BaiViet();
bv.id = Convert.ToInt32(Request.QueryString["id"]);
bv.tieuDe = txtTieuDe.Text;
bv.id_cm = Convert.ToInt16(ddChuyenMuc.Text.ToString());
bv.id_nd = 2;
bv.noiDung = txtNoiDung.Text;
bv.moTa = txtMota.Text;
bv.tuKhoa = txtTuKhoa.Text;
//file upload
if (hinhAnh.HasFile)
{
string path = Server.MapPath("~/Upload/") + hinhAnh.FileName;
hinhAnh.PostedFile.SaveAs(path);
bv.hinhAnh = "/Upload/" + hinhAnh.FileName;
}
else
{
bv.hinhAnh = oldHinhAnh.ImageUrl;
}
if (rd1.Checked)
{
bv.trangThai = 1;
}
else
{
bv.trangThai = 0;
}
//end upload
data.SuaBaiViet(bv);
Response.Redirect("TinTuc.aspx");
}
protected void btnThem_Click(object sender, EventArgs e)
{
BaiViet bv = new BaiViet();
bv.id=Convert.ToInt32(Request.QueryString["id"]);
bv.tieuDe = txtTieuDe.Text;
bv.id_cm = Convert.ToInt16(ddChuyenMuc.Text.ToString());
bv.id_nd = 2;
bv.noiDung = txtNoiDung.Text;
bv.moTa = txtMota.Text;
bv.tuKhoa = txtTuKhoa.Text;
//file upload
if (hinhAnh.HasFile)
{
string path = Server.MapPath("~/Upload/") + hinhAnh.FileName;
hinhAnh.PostedFile.SaveAs(path);
bv.hinhAnh = "/Upload/" + hinhAnh.FileName;
}
else bv.hinhAnh = oldHinhAnh.ImageUrl;
if (rd1.Checked)
{
bv.trangThai = 1;
}
else bv.trangThai = 0;
//end upload
data.SuaBaiViet(bv);
Response.Redirect("TinTuc.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
BaiViet bv = new BaiViet();
//get bài viết theo id
int id = Convert.ToInt32(Request.QueryString["id"]);
bv = data.GetABaiViet(id);
//đổ dữ liệu lên view
lblTieude.Text = bv.tieuDe;
lblChuyenmuc.Text = data.GetTenChuyenMuc(bv.id_cm);
lblCM.Text = data.GetTenChuyenMuc(bv.id_cm);
lblNgaydang.Text = bv.ngayTao.ToString();
lblXem.Text = bv.luotXem.ToString();
lblNoidung.Text = bv.noiDung;
lbltenND.Text = bv.tenND;
//title, description, keyword meta
Page.Title = bv.tieuDe;
Page.MetaDescription = bv.moTa;
Page.MetaKeywords = bv.tuKhoa;
//luot xem
data.LuotXemBV(id);
dataBinhLuan.DataSource = data.GetBinhLuanBV(id);
dataBinhLuan.DataBind();
//nếu chưa login
}
public ActionResult DeleteBaiViet(int id, BaiViet baiViet)
{
baiViet = db.BaiViets.Where(x => x.ID == id).SingleOrDefault();
db.BaiViets.Remove(baiViet);
db.SaveChanges();
return(RedirectToAction("BaiViet", "Admin"));
}
public JsonResult GetData(int idBV)
{
BaiViet bv = db.BaiViets.Where(x => x.idBV == idBV).SingleOrDefault();
NhaTro nt = db.NhaTroes.Where(x => x.idNT == bv.idNT).SingleOrDefault();
PostingModel view = new PostingModel();
view.TieuDe = bv.TieuDe;
view.TieuDePhu = bv.TieuDePhu;
view.NgayDang = bv.NgayDang;
view.DienTich = nt.DienTich;
view.Lau = (int)nt.Lau;
view.PhongNgu = (int)nt.PhongNgu;
view.NhaTam = (int)nt.NhaTam;
view.MoTa = bv.MoTa;
view.SoNha = nt.SoNha;
view.Gia = (int)nt.Gia;
view.idQuan = (int)nt.idQuan;
view.idPhuong = (int)nt.idPhuong;
view.idBV = idBV;
string value = string.Empty;
value = JsonConvert.SerializeObject(view, Formatting.Indented, new JsonSerializerSettings
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
return(Json(value, JsonRequestBehavior.AllowGet));
}
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 async Task <IActionResult> Edit(int id, [Bind("ID,TieuDe,NoiDung,Hinh,MaLoai")] BaiViet baiViet)
{
if (id != baiViet.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(baiViet);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!BaiVietExists(baiViet.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(baiViet));
}
public async Task <ActionResult> Create([Bind(Include = "MaBaiViet,NoiDung,AnhChuDe,MaPhanLoai,NgayDang,LuotXem,MaNguoiDung,MaBinhLuan,MaDanhMuc,TenBaiViet,MaDinhDuong,MaTinTuc,MaKienThuc,TenChuDe,TieuDe,HuongDan")] BaiViet baiViet, HttpPostedFileBase fileUpload)
{
var fileimg = Path.GetFileName(fileUpload.FileName);
//Lưu file
var pa = Path.Combine(Server.MapPath("~/Content/Img/"), fileimg);
if (fileUpload == null)
{
ViewBag.ThongBao = "Chọn hình ảnh";
return(View());
}
else if (System.IO.File.Exists(pa))
{
ViewBag.ThongBao = "Hình ảnh đã tồn tại!";
}
else
{
fileUpload.SaveAs(pa);
}
baiViet.AnhChuDe = fileUpload.FileName;
db.BaiViets.Add(baiViet);
await db.SaveChangesAsync();
ViewBag.MaDanhMuc = new SelectList(db.DanhMucs, "MaDanhMuc", "TenDanhMuc", baiViet.MaDanhMuc);
ViewBag.MaDinhDuong = new SelectList(db.DinhDuongs, "Ma_DinhDuong", "TieuDe", baiViet.MaDinhDuong);
ViewBag.MaKienThuc = new SelectList(db.KTs, "MaKienThuc", "TenKienThuc", baiViet.MaKienThuc);
ViewBag.MaNguoiDung = new SelectList(db.NguoiDungs, "MaNguoiDung", "TenNguoiDung", baiViet.MaNguoiDung);
ViewBag.MaPhanLoai = new SelectList(db.PhanLoais, "MaPhanLoai", "TenPhanLoai", baiViet.MaPhanLoai);
ViewBag.MaTinTuc = new SelectList(db.TinTucs, "MaTinTuc", "TieuDe", baiViet.MaTinTuc);
return(View(baiViet));
}
public ActionResult DeleteConfirmed(int id)
{
BaiViet baiViet = db.BaiViets.Find(id);
db.BaiViets.Remove(baiViet);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public JsonResult SuaBaiViet(BaiViet std)
{
std.NgaySua = DateTime.Now;
std.MaNV = 1;
string baiVietModel = new BaiVietModel().CapNhatBaiViet(std);
return(Json(new { data = "", JsonRequestBehavior.AllowGet }));
}
public int Create(BaiViet baiViet)
{
baiViet.NgayTao = DateTime.Now;
baiViet.ViewCount = 0;
db.BaiViets.Add(baiViet);
db.SaveChanges();
return(baiViet.ID);
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
BaiViet baiViet = await db.BaiViets.FindAsync(id);
db.BaiViets.Remove(baiViet);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public ViewResult AnPhamKhoaHoc_Details(int baiVietID)
{
BaiViet baiViet = db.BaiViets.Find(baiVietID);
string text = System.IO.File.ReadAllText(Server.MapPath(apkhURL + baiViet.NoiDung));
ViewBag.NoiDung = (object)text;
return(View(baiViet));
}
public ViewResult ChamSocSacDep_Details(int baiVietID)
{
BaiViet baiViet = db.BaiViets.Find(baiVietID);
string text = System.IO.File.ReadAllText(Server.MapPath(cssdURL + baiViet.NoiDung));
ViewBag.NoiDung = (object)text;
return(View(baiViet));
}
public ActionResult SuaBaiViet(string MaBaiViet)
{
BaiVietModel baiVietModel = new BaiVietModel();
BaiViet baiViet = new BaiViet();
baiViet = baiVietModel.GetDataByMa(MaBaiViet);
ViewBag.BaiViet = baiViet;
return(View());
}
public ActionResult EventsWorkshop_Details(int baiVietID)
{
BaiViet baiViet = db.BaiViets.Find(baiVietID);
string text = System.IO.File.ReadAllText(Server.MapPath(eventURL + baiViet.NoiDung));
ViewBag.NoiDung = (object)text;
return(View(baiViet));
}
public ActionResult Open()
{
string path = Server.MapPath("~/info.txt");
string[] info = System.IO.File.ReadAllLines(path);
BaiViet s = new BaiViet();
ViewBag.hinhAnh = "~/Content/igmaes" + s.hinhAnh;
return(View("TrangChu"));
}
public string ShowItem(BaiViet bv, string column)
{
switch (column)
{
case "TieuDe":
if (Session["lang"].ToString().Equals("vn"))
return bv.TieuDe_Vn;
else
return bv.TieuDe_Cn;
case "LienKet":
return "/View/ArticleDetail.aspx?ID=" + bv.ID;
default: return "";
}
}
protected void btnThem_Click(object sender, EventArgs e)
{
BaiViet bv = new BaiViet();
bv.tieuDe = txtTieuDe.Text;
bv.id_cm=Convert.ToInt16(ddChuyenMuc.Text.ToString());
bv.id_nd=2;
bv.noiDung=txtNoiDung.Text;
bv.moTa=txtMota.Text;
bv.tuKhoa=txtTuKhoa.Text;
//file upload
string path = Server.MapPath("~/Upload/")+hinhAnh.FileName;
hinhAnh.PostedFile.SaveAs(path);
bv.hinhAnh = "/Upload/" + hinhAnh.FileName;
//end upload
bv.ngayTao=Convert.ToDateTime(DateTime.Now.ToString());
data.ThemBaiViet(bv);
Response.Redirect("TinTuc.aspx");
}
protected void rptArticleList_ItemDataBound(object sender, ListViewItemEventArgs e)
{
var curentIndex = 0;
var CurrentItem = new BaiViet();
var ltrItemBV = e.Item.FindControl("ltrItemBV") as Literal;
if (e.Item.ItemType == ListViewItemType.DataItem)
{
ListViewDataItem dataItem = (ListViewDataItem)e.Item;
CurrentItem = (BaiViet)dataItem.DataItem;
curentIndex = dataItem.DataItemIndex;
if (curentIndex < 4)
{
if (curentIndex == 0)
ltrItemBV.Text = "<div class='line-fix-parent-width mb15'>" + showItem(CurrentItem, 2);
else if (curentIndex == 3)
ltrItemBV.Text = showItem(CurrentItem, 2) + "</div>";
else
ltrItemBV.Text = showItem(CurrentItem, 2);
}
else
ltrItemBV.Text = showItem(CurrentItem, 1);
}
}
//----
public void ThemBaiViet(BaiViet bv)
{
string sql = "INSERT INTO tblBaiViet(id_cm, id_nd, tieuDe,noiDung, moTa, tuKhoa,hinhAnh,ngayTao) VALUES(@id_cm, @id_nd, @tieuDe,@noiDung, @moTa, @tuKhoa,@hinhAnh,@ngayTao)";
con.Open();
SqlCommand cmd = new SqlCommand(sql,con);
cmd.Parameters.AddWithValue("@id_cm", bv.id_cm);
cmd.Parameters.AddWithValue("@id_nd", bv.id_nd);
cmd.Parameters.Add("@tieuDe",SqlDbType.NText);
cmd.Parameters["@tieuDe"].Value = bv.tieuDe;
cmd.Parameters.AddWithValue("@noiDung", bv.noiDung);
cmd.Parameters.AddWithValue("@moTa", bv.moTa);
cmd.Parameters.AddWithValue("@tuKhoa", bv.tuKhoa);
cmd.Parameters.AddWithValue("@hinhAnh", bv.hinhAnh);
cmd.Parameters.AddWithValue("@ngayTao", bv.ngayTao);
cmd.ExecuteNonQuery();
con.Close();
}
protected string showItem(BaiViet bv, int th)
{
switch (th)
{
case 1:
return
"<div class='item-bai-viet'>"
+ "<div class='duong-dan-bai-viet'>"
+ "<a href='" + ShowArticleCat1(bv, "ArticleCatDuongDan") + "' class='link'>"
+ "<img src='" + bv.HinhAnh + "' alt='Hình ảnh' class='img' />"
+ "</a>"
+ "</div>"
+ "<div class='tieu-de-bai-viet'>"
+ "<a href='" + ShowArticleCat1(bv, "ArticleCatDuongDan") + "'>"
+ ShowArticleCat1(bv, "ArticleCatTieuDe") + "</a>"
+ "</h4>"
+ "<p class='meta'>"
+ ShowArticleCat1(bv, "laytomtat")
+ "</p>"
+ "</div></div>";
case 2:
return "<div class='item-doc1'>"
+ "<div class='item-doc-figure h180'>"
+ "<a href='" + ShowArticleCat1(bv, "ArticleCatDuongDan") + "' class='link'>"
+ "<img src='" + bv.HinhAnh + "' alt='Hinh anh' class='img' />"
+ "</a>"
+ "</div>"
+ "<div class='item-doc-tieu-de'>"
+ "<h1><a href='" + ShowArticleCat1(bv, "ArticleCatDuongDan") + "' class='link'>"
+ ShowArticleCat1(bv, "ArticleCatTieuDe") + "</a></h1>"
+ "</div>"
+ "<div class='item-doc-mo-ta'>"
+ "<p>"
+ ShowArticleCat1(bv, "laytomtat")
+ "</p>"
+ "</div>"
+ "</div>";
default: return "";
}
}
public void SuaBaiViet(BaiViet bv)
{
string sql = @"UPDATE tblBaiViet set id_cm=@id_cm,
id_nd=@id_nd,
tieuDe=@tieuDe,
noiDung=@noiDung,
moTa=@moTa,
tuKhoa=@tuKhoa,
hinhAnh=@hinhAnh,
trangThai=@trangThai
WHERE id=@id";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@id", bv.id);
cmd.Parameters.AddWithValue("@id_cm", bv.id_cm);
cmd.Parameters.AddWithValue("@id_nd", bv.id_nd);
cmd.Parameters.Add("@tieuDe", SqlDbType.NText);
cmd.Parameters["@tieuDe"].Value = bv.tieuDe;
cmd.Parameters.Add("@noiDung", SqlDbType.NText);
cmd.Parameters["@noiDung"].Value = bv.noiDung;
cmd.Parameters.Add("@moTa", SqlDbType.NText);
cmd.Parameters["@moTa"].Value = bv.moTa;
cmd.Parameters.Add("@tuKhoa", SqlDbType.NText);
cmd.Parameters["@tuKhoa"].Value = bv.tuKhoa;
cmd.Parameters.AddWithValue("@hinhAnh", bv.hinhAnh);
cmd.Parameters.AddWithValue("@trangThai", bv.trangThai);
cmd.ExecuteNonQuery();
con.Close();
}
protected string ShowArticleCat1(BaiViet baiviet, string column)
{
switch (column)
{
case "laytomtat":
if (baiviet.TomTat_Vn.Length > 100)
{
return StringUltility.GetStringByLenght(baiviet.TomTat_Vn, 100) + "...";
}
else
{
return baiviet.TomTat_Vn + "...";
}
case "ArticleCatDuongDan":
return "/" + baiviet.IDTheLoai + "/bai-viet/" + Helper.RejectMarks(baiviet.TieuDe_Vn) + "-" + baiviet.ID + ".html";
case "ArticleCatTieuDe":
return baiviet.TieuDe_Vn;
default: return "";
}
}
private void SetData(BaiViet data)
{
lblId.Text = data.ID.ToString();
txtTieuDeVn.Text = data.TieuDe_Vn;
txtTomTatVn.Text = data.TomTat_Vn;
txtHinhAnh.Text = data.HinhAnh;
txtckeditorVn.Text = data.ChiTiet_Vn;
ddlLoaiMenu.SelectedValue = data.IDTheLoai.ToString();
}
private void SetData(BaiViet data)
{
lblId.Text = data.ID.ToString();
txtTieuDeVn.Text = data.TieuDe_Vn;
txtTomTatVn.Text = data.TomTat_Vn;
txtHinhAnh.Text = data.HinhAnh;
txtckeditorVn.Text = data.ChiTiet_Vn;
ddlLoaiMenu.SelectedValue = data.IDTheLoai.ToString();
//if (data.TrangChu == true)
// ckbTrangChu.Checked = true;
}
private BaiViet GetData()
{
BaiViet data = null;
if (lblId.Text != "")
{
//lay thong tin cu tu Database de cap nhat
data = BaiViet.LayTheoID(lblId.Text);
//cap nhat lai thoi gian chinh sua
data.NgayCapNhat = DateTime.Now.ToShortDateString();
//cap nhat nguoi chinh sua(use hien tai)
data.NguoiCapNhat = Session["TenDangNhap"].ToString();
}
else
{
data = new BaiViet();//them moi
data.NgayTao = DateTime.Now.ToShortDateString();
data.NguoiTao = Session["TenDangNhap"].ToString();
}
data.TieuDe_Vn = txtTieuDeVn.Text;
data.TomTat_Vn = txtTomTatVn.Text;
data.HinhAnh = txtHinhAnh.Text; ;
data.ChiTiet_Vn = txtckeditorVn.Text;
//if (ckbTrangChu.Checked)
// data.TrangChu = true;
//else
// data.TrangChu = false;
data.TrangThai = 1;
data.IDTheLoai = ConvertType.ToInt32(ddlLoaiMenu.SelectedValue.Trim());
return data;
}
