public bool AddCMSNews(CMSNewsView cmsNewsView)
{
try
{
using (var db = new OnlineStoreMVCEntities())
{
var cmsNews = new cms_News
{
CategoryId = cmsNewsView.CategoryId,
CoverImageId = cmsNewsView.CoverImageId,
Title = cmsNewsView.Title,
SubTitle = cmsNewsView.SubTitle,
ContentNews = cmsNewsView.ContentNews,
Authors = cmsNewsView.Authors,
Tags = cmsNewsView.Tags,
TotalView = cmsNewsView.TotalView,
DisplayHomePage = cmsNewsView.DisplayHomePage,
Status = cmsNewsView.Status,
SortOrder = cmsNewsView.SortOrder,
CreatedDate = DateTime.Now,
ModifiedDate = DateTime.Now
};
db.cms_News.Add(cmsNews);
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static CMSNewsViewModel ConvertCMSNewsToCMSNewsViewModel(cms_News news)
{
return(new CMSNewsViewModel
{
Id = news.Id,
CategoryId = news.CategoryId,
CategoryTitle = news.cms_Categories.Title,
CoverImageId = news.CoverImageId,
CoverImageName = news.share_Images.ImageName,
CoverImagePath = news.share_Images.ImagePath,
Title = news.Title,
SubTitle = news.SubTitle,
ContentNews = news.ContentNews,
Authors = news.Authors,
Tags = news.Tags,
DisplayHomePage = news.DisplayHomePage,
TotalView = news.TotalView,
Status = news.Status,
SortOrder = news.SortOrder,
CreatedDate = news.CreatedDate
});
}
public ActionResult updateimage(cms_News data, HttpPostedFileBase file, List <string> hashtagcodes)
{
try
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
{
string fileExtension = System.IO.Path.GetExtension(file.FileName).ToLower();
if (fileExtension == ".jpeg" || fileExtension == ".png" || fileExtension == ".gif" || fileExtension == ".jpg")
{
data.hinh_dai_dien = new AzureHelper().UploadImageToAzure("News", file, currentUser.name);
}
else
{
return(Json(new { success = false, error = "Vui lòng chọn đúng file ảnh." }));
}
return(Json(new { success = true, data = data }));
}
}
catch (Exception e)
{
return(Json(new { success = false, error = e.Message }));
}
}
public ActionResult CreateUpdate(cms_News data, List <Image_Info> listimage, List <Image_Info> listimagecontent, HttpPostedFileBase file, List <string> tu_khoas)
{
try
{
using (var dbConn = Helpers.OrmliteConnection.openConn())
using (var dbTrans = dbConn.OpenTransaction())
{
if (listimage != null)
{
foreach (var item in listimage)
{
data.hinh_dai_dien = item.duong_dan_day_du;
data.ma_hinh_goc = item.ma_anh_goc;
}
//return Json(new { success = false, message = "Vui lòng chọn hình ảnh tin tức", JsonRequestBehavior.AllowGet });
}
if (file != null)
{
data.hinh_dai_dien = new cms_News().UploadImageToFolder("NEWS", file, currentUser.name, data.ma_website);
data.ma_hinh_goc = currentUser.name + "_" + DateTime.Now.ToString("yyyyMMddHHmmssfff");
}
string ma_tu_tang = String.Empty;
var lastId = dbConn.FirstOrDefault <cms_News>("SELECT TOP 1 * FROM cms_News ORDER BY ma_bai_viet DESC");
if (lastId != null)
{
var nextNo = Int32.Parse(lastId.ma_bai_viet.Substring(3, 3)) + 1;
ma_tu_tang = "BAI" + String.Format("{0:000}", nextNo);
}
else
{
ma_tu_tang = "BAI001";
}
data.ma_bai_viet = data.id == 0 ? ma_tu_tang : dbConn.SingleOrDefault <cms_News>("id={0}", data.id).ma_bai_viet;
if (listimagecontent != null)
{
foreach (var items in listimagecontent)
{
var test = dbConn.Select <cms_New_Images>(c => c.duong_dan_day_du == items.duong_dan_day_du && c.ma_bai_viet == data.ma_bai_viet);
if (dbConn.Select <cms_New_Images>(c => c.duong_dan_day_du == items.duong_dan_day_du && c.ma_bai_viet == data.ma_bai_viet).Count() == 0)
{
cms_New_Images item = new cms_New_Images();
item.ma_bai_viet = data.ma_bai_viet;
item.nguoi_tao = currentUser.name;
item.ngay_tao = DateTime.Now;
item.ten_anh = items.ma_anh_goc;
item.duong_dan_day_du = items.duong_dan_day_du;
item.trang_thai = true;
dbConn.Insert(item);
}
}
}
if (data.slug == "" || data.slug == null)
{
data.slug = SqlHelper.convertToUnSign3(data.tieu_de);
}
else
{
data.slug = SqlHelper.convertToUnSign3(data.slug);
}
data.tu_khoa = "";
if (tu_khoas != null)
{
foreach (string item in tu_khoas)
{
data.tu_khoa += item + ";";
}
}
if (data.id > 0)
{
if (accessDetail != null && (accessDetail.access["all"] || accessDetail.access["update"]))
{
var exist = dbConn.SingleOrDefault <cms_News>("id={0}", data.id);
if (data.hinh_dai_dien == null)
{
data.hinh_dai_dien = exist.hinh_dai_dien;
data.ma_hinh_goc = exist.ma_hinh_goc;
}
data.ngay_sua_bai = data.updatedat = DateTime.Now;
data.nguoi_sua_bai = data.updatedby = currentUser.name;
dbConn.UpdateOnly(data,
onlyFields: p =>
new
{
p.ma_website,
p.ma_chuyen_muc,
p.ma_vi_tri,
p.tieu_de,
p.mo_ta,
p.uu_tien,
p.hinh_dai_dien,
p.ma_hinh_goc,
p.noi_dung,
p.ngay_viet_bai,
p.tu_khoa,
p.nguon_bai_viet,
p.link_nguon_bai_viet,
p.luot_xem,
p.nguoi_sua_bai,
p.ngay_sua_bai,
//p.cho_phep_comment,
p.slug,
p.updatedat,
p.updatedby
},
where : p => p.id == data.id);
dbTrans.Commit();
}
else
{
return(Json(new { success = false, error = "Don't have permission to update" }));
}
}
else
{
if (accessDetail != null && (accessDetail.access["all"] || accessDetail.access["create"]))
{
data.trang_thai_tao = 1;
data.nguoi_viet_bai = data.nguoi_viet_bai == null ? currentUser.name : data.nguoi_viet_bai;
data.ngay_viet_bai = data.ngay_viet_bai == null ? DateTime.Now : data.ngay_viet_bai;
data.createdat = DateTime.Now;
data.createdby = currentUser.name;
dbConn.Insert(data);
int Id = (int)dbConn.GetLastInsertId();
data.id = Id;
dbTrans.Commit();
}
else
{
return(Json(new { success = false, error = "Don't have permission to create" }));
}
}
}
return(Json(new { success = true, data = data }));
}
catch (Exception e)
{
return(Json(new { success = false, error = e.Message }));
}
}
