public long Create(tbl_BaiViet content)
{
if (string.IsNullOrEmpty(content.sTenTieuDecMeta))
{
content.sTenTieuDecMeta = StringHelper.ToUnsignString(content.sTieuDe);
}
//content.sImages = "http://192.168.0.107:7500" + content.sImages;
content.dNgayTao = DateTime.Now;
content.iViewCount = 0;
db.tbl_BaiViet.Add(content);
db.SaveChanges();
//tags
//lay danh sach tag
if (!string.IsNullOrEmpty(content.sTags))
{
string[] tags = content.sTags.Split(',');
foreach (var tag in tags)
{
var tagID = StringHelper.ToUnsignString(tag);
var existTag = this.CheckTag(tagID);
//them vao bang tag
if (!existTag)
{
this.InsertTag(tagID, tag);
}
//them vao bang tagBaiviet
this.InsertContentTag(content.IDBaiViet, tagID);
}
}
return(content.IDBaiViet);
}
public IHttpActionResult Puttbl_BaiViet(long id, tbl_BaiViet tbl_BaiViet)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tbl_BaiViet.IDBaiViet)
{
return(BadRequest());
}
db.Entry(tbl_BaiViet).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!tbl_BaiVietExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult Gettbl_BaiViet(long id)
{
tbl_BaiViet tbl_BaiViet = db.tbl_BaiViet.Find(id);
if (tbl_BaiViet == null)
{
return(NotFound());
}
return(Ok(tbl_BaiViet));
}
public IHttpActionResult Posttbl_BaiViet(tbl_BaiViet tbl_BaiViet)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.tbl_BaiViet.Add(tbl_BaiViet);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = tbl_BaiViet.IDBaiViet }, tbl_BaiViet));
}
public ActionResult Create(tbl_BaiViet model)
{
if (ModelState.IsValid)
{
var session = (UserLogin)Session[CommonConstants.USER_SESSION];
model.sNguoiTao = session.UserName;
new BaiVietDAO().Create(model);
return(RedirectToAction("Index"));
}
setViewBag();
return(View());
}
public ActionResult CreateContent(tbl_BaiViet model)
{
if (ModelState.IsValid)
{
var session = (UserLogin)Session[CommonConstants.USER_SESSION];
model.sNguoiTao = session.UserName;
new BaiVietDAO().Create(model);
SetAlert("Thêm bài viết thành công, chờ kiểm duyệt", "success");
return(RedirectToAction("MyContent"));
}
setViewBag();
return(View());
}
public IHttpActionResult Deletetbl_BaiViet(long id)
{
tbl_BaiViet tbl_BaiViet = db.tbl_BaiViet.Find(id);
if (tbl_BaiViet == null)
{
return(NotFound());
}
db.tbl_BaiViet.Remove(tbl_BaiViet);
db.SaveChanges();
return(Ok(tbl_BaiViet));
}
public bool Edit(tbl_BaiViet content)
{
try
{
var addcontent = db.tbl_BaiViet.Find(content.IDBaiViet);
addcontent.sTieuDe = content.sTieuDe;
if (string.IsNullOrEmpty(content.sTenTieuDecMeta))
{
content.sTenTieuDecMeta = StringHelper.ToUnsignString(content.sTieuDe);
}
//addcontent.sImages = "http://192.168.0.107:7500" + content.sImages;
addcontent.sImages = content.sImages;
addcontent.IDChuDe = content.IDChuDe;
addcontent.sXemTruoc = content.sXemTruoc;
addcontent.sNoiDung = content.sNoiDung;
addcontent.bStatus = content.bStatus;
addcontent.sTags = content.sTags;
addcontent.dNgaySua = DateTime.Now;
db.SaveChanges();
//tags
//lay danh sach tag
if (!string.IsNullOrEmpty(content.sTags))
{
this.RemoveAllContentTag(content.IDBaiViet);
string[] tags = content.sTags.Split(',');
foreach (var tag in tags)
{
var tagID = StringHelper.ToUnsignString(tag);
var existTag = this.CheckTag(tagID);
//them vao bang tag
if (!existTag)
{
this.InsertTag(tagID, tag);
}
//them vao bang tagBaiviet
this.InsertContentTag(content.IDBaiViet, tagID);
}
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public ActionResult Edit(tbl_BaiViet model, FormCollection formcollection)
{
if (ModelState.IsValid)
{
//var dao = new BaiVietDAO();
long idbaiviet = long.Parse(formcollection["hdnIDbaiviet"]);
var session = (UserLogin)Session[CommonConstants.USER_SESSION];
model.sNguoiSua = session.UserName;
model.IDBaiViet = idbaiviet;
//var result = dao.Edit(model);
new BaiVietDAO().Edit(model);
return(RedirectToAction("Index"));
}
setViewBag(model.IDChuDe);
return(View());
}
