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; }