public ActionResult SaveUnit(string ChkActive, Units objUnit) { try { UnitsDAL objCtrl = new UnitsDAL(); objUnit.Active = !string.IsNullOrEmpty(ChkActive); if (objUnit.Id > 0) { objUnit.UpdatedAt = DateTime.Now; objUnit.UpdatedBy = SysBaseInfor.GetCurrentUserId(); objCtrl.UpdateItem(objUnit); } else { objUnit.CreatedAt = DateTime.Now; objUnit.CreatedBy = SysBaseInfor.GetCurrentUserId(); objCtrl.CreateItem(objUnit); string adminName = "admin@" + objUnit.Code; string adminPass = "******"; string roleName = "UnitsAdmin"; InitializeIdentity(HttpContext.GetOwinContext(), adminName, adminPass, roleName, 1, 0, objUnit.Code, objUnit.Id); } return(PartialView(urlView + "_DetailUnit.cshtml", objUnit)); } catch (Exception ex) { return(PartialView(urlView + "_DetailUnit.cshtml", new Modules())); } }
public JsonResult SaveDetailUnitReport(UnitReport objReport) { try { UnitReportDAL objCtrl = new UnitReportDAL(); if (objReport.DayReport != null) { objReport.DayReport = objReport.DayReport.ToLocalTime(); } if (objReport.Id > 0) { objReport.UpdatedBy = SysBaseInfor.GetCurrentUserId(); objCtrl.UpdateItem(objReport); return(Json(new { Msg = "Success", Type = "Edit" })); } else { objReport.Status = 0; objReport.CreatedBy = SysBaseInfor.GetCurrentUserId(); objReport.UnitId = SysBaseInfor.GetCurrentUnitId().ToInt32(); objCtrl.CreateItem(objReport); return(Json(new { Msg = "Success", Type = "Create" })); } } catch (Exception ex) { return(Json(new { Msg = "Fail" })); } }
public JsonResult SaveDetailWorkCalendar(UnitWorkCalendar objWorkCalendar) { try { UnitWorkCalendarDAL objCtrl = new UnitWorkCalendarDAL(); if (objWorkCalendar.DayWorkCalendar != null) { objWorkCalendar.DayWorkCalendar = objWorkCalendar.DayWorkCalendar.ToLocalTime(); } if (objWorkCalendar.Id > 0) { objWorkCalendar.UpdatedBy = SysBaseInfor.GetCurrentUserId(); objCtrl.UpdateItem(objWorkCalendar); return(Json(new { Msg = "Success", Type = "Edit" })); } else { objWorkCalendar.Status = 0; objWorkCalendar.CreatedBy = SysBaseInfor.GetCurrentUserId(); objWorkCalendar.UnitId = SysBaseInfor.GetCurrentUnitId().ToInt32(); objCtrl.CreateItem(objWorkCalendar); return(Json(new { Msg = "Success", Type = "Create" })); } } catch (Exception ex) { return(Json(new { Msg = "Fail" })); } }
public ActionResult GetListDirectoryLibrary() { var userLibrary = Server.MapPath(string.Format("~/UserImages/{0}/", SysBaseInfor.GetCurrentUserId())); var directories = Directory.GetDirectories(userLibrary); return(View()); }
public JsonResult PublishWorkCalendar(int workCalendarId, int?TypeSelect) { try { UnitWorkCalendarDAL objCtrl = new UnitWorkCalendarDAL(); UnitWorkCalendar obj = objCtrl.GetItemByID("Id", workCalendarId); if (obj.Id > 0) { obj.PublishedBy = SysBaseInfor.GetCurrentUserId(); obj.PublishedAt = DateTime.Now; if (TypeSelect > 0) { obj.Status = 0; } else { obj.Status = 1; } objCtrl.UpdateItem(obj); } return(Json(new { Msg = "Success" })); } catch (Exception ex) { return(Json(new { Msg = "Fail" })); } }
public ActionResult UpdateAndCreate(string chkType, string chkAutoUpload, News newDetail) { try { if (newDetail.Id > 0) { if (isChief || (newDetail.CreatedBy == SysBaseInfor.GetCurrentUserId() && (newDetail.Status == 0 || newDetail.Status == 4))) { NewsDAL objCtrl = new NewsDAL(); newDetail.Type = !string.IsNullOrEmpty(chkType) ? (byte)1 : (byte)0; newDetail.UpdatedAt = DateTime.Now; newDetail.UpdatedBy = SysBaseInfor.GetCurrentUserId(); newDetail.UnitId = SysBaseInfor.GetCurrentUnitId().ToInt32(); if (!string.IsNullOrEmpty(chkAutoUpload)) { var tmpContent = UploadAllImageInNewsToServer(newDetail.FullContent, newDetail.Id); if (!string.IsNullOrEmpty(tmpContent)) { newDetail.FullContent = tmpContent; } } objCtrl.UpdateItem(newDetail); return(Json(new { msg = "Success", idNews = newDetail.Id, typeAction = "UpdateAndCreate" })); } } return(Json(new { msg = "Thao tác không thực hiện được" })); } catch (Exception ex) { return(Json(new { msg = ex.Message })); } }
public ActionResult CreateNews(string chkType, string chkAutoUpload, News newDetail) { try { if (string.IsNullOrEmpty(newDetail.Title)) { return(Json(new { msg = "Bạn phải nhập tiêu đề" })); } if (string.IsNullOrEmpty(newDetail.Summary)) { return(Json(new { msg = "Bạn phải nhập tóm tắt" })); } if (newDetail.CategoryID <= 0) { return(Json(new { msg = "Bạn phải chọn chuyên mục" })); } if (newDetail.Id == 0) { CategoriesDAL categoryCtrl = new CategoriesDAL(); var category = categoryCtrl.GetItemByID("Id", newDetail.CategoryID); NewsDAL objCtrl = new NewsDAL(); newDetail.Type = !string.IsNullOrEmpty(chkType) ? (byte)1 : (byte)0; newDetail.Active = 1; newDetail.UnitId = SysBaseInfor.GetCurrentUnitId().ToInt32(); newDetail.CreatedAt = DateTime.Now; newDetail.CreatedBy = SysBaseInfor.GetCurrentUserId(); newDetail.Status = isChief ? (byte)1 : (byte)0; objCtrl.CreateItem(newDetail); if (newDetail.Id > 0 && !string.IsNullOrEmpty(chkAutoUpload)) { var tmpContent = UploadAllImageInNewsToServer(newDetail.FullContent, newDetail.Id); if (!string.IsNullOrEmpty(tmpContent)) { newDetail.FullContent = tmpContent; } objCtrl.UpdateItem(newDetail); } return(Json(new { msg = "Success", idNews = newDetail.Id, typeAction = "Create" })); } else { return(Json(new { msg = "Thao tác không thực hiện được" })); } } catch (Exception ex) { return(Json(new { msg = ex.Message })); } }
public JsonResult UploadDropZone(int?idAlbum) { string urlImage = ""; try { if (idAlbum != null && idAlbum.GetValueOrDefault() > 0) { var ctrlUI = new PictureUserDAL(); foreach (string fileName in Request.Files) { HttpPostedFileBase file = Request.Files[fileName]; if (file != null && file.ContentLength > 0) { var strDateTime = DateTime.Now.ToString("dd-MM-yyyy"); var fName = idAlbum + "_" + Guid.NewGuid() + Path.GetExtension(file.FileName); urlImage = string.Format("/UserImages/{0}/{1}/{2}/{3}/{4}", SysBaseInfor.GetCurrentUnitId(), SysBaseInfor.GetCurrentUserId(), SysBaseDirectory.pictureUploaded, strDateTime, fName); var userPath = string.Format("{0}{1}/", userPictureUploadedPath, strDateTime); if (!Directory.Exists(userPath)) { Directory.CreateDirectory(userPath); } string path = Path.Combine(userPath, fName); file.SaveAs(path); var pictureSave = new PictureUser(); pictureSave.IdAlbum = idAlbum.GetValueOrDefault(); pictureSave.IdUnit = SysBaseInfor.GetCurrentUnitId().ToInt32(); pictureSave.CreatedBy = SysBaseInfor.GetCurrentUserId(); pictureSave.CreatedAt = DateTime.Now; pictureSave.PictureUrl = urlImage; pictureSave.PictureName = fName; ctrlUI.CreateItem(pictureSave); } } return(Json(new { urlImage = urlImage })); } else { return(Json("Có lỗi khi tải lên")); } } catch (Exception ex) { return(Json("Có lỗi khi tải lên")); } }
public ActionResult DeleteNew(int idNews) { try { NewsDAL objCtrl = new NewsDAL(); var result = objCtrl.GetItemByID("Id", idNews); if (isChief) { if (result.Status != 3) { if (result.CreatedBy == SysBaseInfor.GetCurrentUserId()) { objCtrl.DeleteItemByValues("Id", idNews); return(Content("Success")); } else { if (result.Status != 0 || result.Status != 4) { objCtrl.DeleteItemByValues("Id", idNews); return(Content("Success")); } } } } else { if (result.CreatedBy == SysBaseInfor.GetCurrentUserId() && (result.Status == 0 || result.Status == 4)) { objCtrl.DeleteItemByValues("Id", idNews); return(Content("Success")); } } return(Content("Không thể xóa")); } catch (Exception ex) { return(Content(ex.Message)); } }
public JsonResult SaveListAlbum(List <PictureUserAlbum> lstListAlbum) { try { var ctrlPUA = new PictureUserAlbumDAL(); if (lstListAlbum != null && lstListAlbum.Count > 0) { foreach (PictureUserAlbum item in lstListAlbum) { item.IdUser = SysBaseInfor.GetCurrentUserId(); item.IdUnit = SysBaseInfor.GetCurrentUnitId().ToInt32(); item.CreatedAt = DateTime.Now; item.Active = true; ctrlPUA.CreateNewOrUpdate(item); } } return(Json("Success")); } catch (Exception ex) { return(Json(ex.Message)); } }
public void CheckDefaultDirectory() { userPicturePath = Server.MapPath(string.Format("~/UserImages/{0}/{1}/", SysBaseInfor.GetCurrentUnitId(), SysBaseInfor.GetCurrentUserId())); userPictureNewPath = Server.MapPath(string.Format("~/UserImages/{0}/{1}/{2}/", SysBaseInfor.GetCurrentUnitId(), SysBaseInfor.GetCurrentUserId(), SysBaseDirectory.pictureNews)); userPictureThumbnailPath = Server.MapPath(string.Format("~/UserImages/{0}/{1}/{2}/", SysBaseInfor.GetCurrentUnitId(), SysBaseInfor.GetCurrentUserId(), SysBaseDirectory.pictureThumbnail)); userPictureUploadedPath = Server.MapPath(string.Format("~/UserImages/{0}/{1}/{2}/", SysBaseInfor.GetCurrentUnitId(), SysBaseInfor.GetCurrentUserId(), SysBaseDirectory.pictureUploaded)); //userpictureOtherPath = Server.MapPath(string.Format("~/UserImages/{0}/{1}/{2}/", SysBaseInfor.GetCurrentUnitId(), SysBaseInfor.GetCurrentUserId(), SysBaseDirectory.pictureOther)); if (!Directory.Exists(userPicturePath)) { Directory.CreateDirectory(userPicturePath); } if (!Directory.Exists(userPictureNewPath)) { Directory.CreateDirectory(userPictureNewPath); } if (!Directory.Exists(userPictureThumbnailPath)) { Directory.CreateDirectory(userPictureThumbnailPath); } if (!Directory.Exists(userPictureUploadedPath)) { Directory.CreateDirectory(userPictureUploadedPath); } }
public JsonResult GetListAlum() { try { var ctrlPUA = new PictureUserAlbumDAL(); var lstAlbum = ctrlPUA.GetListUserAlbumByUnitAndUser(SysBaseInfor.GetCurrentUnitId().ToInt32(), SysBaseInfor.GetCurrentUserId()); return(Json(lstAlbum)); } catch (Exception ex) { return(Json(ex.Message)); } }
public JsonResult GetListImageByDirectory(string dirSelect, int?page) { try { var lstImg = new List <GalereyaImage>(); if (page != null && page.GetValueOrDefault() > 0) { var currentPage = page.GetValueOrDefault(); var uriImage = string.Format("/UserImages/{0}/{1}/{2}/", SysBaseInfor.GetCurrentUnitId(), SysBaseInfor.GetCurrentUserId(), dirSelect); DirectoryInfo currentDir = new DirectoryInfo(userPicturePath + "/" + dirSelect + "/"); lstImg = currentDir.GetFiles().OrderBy(fi => fi.CreationTime).Skip(currentPage * pageSize).Take(pageSize).Select(fi => new GalereyaImage { lowsrc = Url.Content(uriImage + Path.GetFileName(fi.Name)), fullsrc = Url.Content(uriImage + Path.GetFileName(fi.Name)), description = "Ngày tải: " + fi.CreationTime.ToString("dd/MM/yyyy"), category = dirSelect }).ToList(); } return(Json(lstImg)); } catch (Exception ex) { return(Json(ex.Message)); } }
public PartialViewResult GetListFileAttachment(string inDir) { if (!string.IsNullOrEmpty(inDir)) { var RootDir = Server.MapPath(string.Format("~/UserImages/{0}/{1}/{2}/{3}/", SysBaseInfor.GetCurrentUnitId(), SysBaseDirectory.newsAttachment, inDir, SysBaseInfor.GetCurrentUserId())); var uriImage = string.Format("~/UserImages/{0}/{1}/{2}/{3}/", SysBaseInfor.GetCurrentUnitId(), SysBaseDirectory.newsAttachment, inDir, SysBaseInfor.GetCurrentUserId()); var files = Directory.GetFiles(RootDir).Select(x => new FileUploadView { Url = Url.Content(uriImage + Path.GetFileName(x)), Name = Path.GetFileName(x) }); return(PartialView("~/Views/NewsManage/UploadPartial/_ListFileShow.cshtml", files)); } return(PartialView(blankViewUrl)); }
public ActionResult UploadDropZone() { string fName = ""; string urlImage = ""; try { var userPath = Server.MapPath(string.Format("~/UserImages/{0}/{1}/{2}/{3}/", SysBaseInfor.GetCurrentUnitId(), SysBaseDirectory.pictureThumbnail, DateTime.Now.ToString("dd-MM-yyyy"), SysBaseInfor.GetCurrentUserId())); if (!Directory.Exists(userPath)) { Directory.CreateDirectory(userPath); } foreach (string fileName in Request.Files) { HttpPostedFileBase file = Request.Files[fileName]; string imgType = ""; var isImages = file.InputStream.IsImage(out imgType); if (isImages && !string.IsNullOrEmpty(imgType)) { fName = Guid.NewGuid().ToString() + "." + imgType; if (file != null && file.ContentLength > 0) { string path = Path.Combine(userPath, fName); file.SaveAs(path); urlImage = string.Format("/UserImages/{0}/{1}/{2}/{3}/{4}", SysBaseInfor.GetCurrentUnitId(), SysBaseDirectory.pictureThumbnail, DateTime.Now.ToString("dd-MM-yyyy"), SysBaseInfor.GetCurrentUserId(), fName); return(Json(new { urlImage = urlImage })); } } } return(Json("Error")); } catch (Exception ex) { return(Json("Error")); } }
public JsonResult UploadFileCkeditor(int key, HttpPostedFileWrapper upload) { try { var userPath = Server.MapPath(string.Format("~/UserImages/{0}/{1}/{2}/{3}/", SysBaseInfor.GetCurrentUnitId(), SysBaseDirectory.newsAttachment, DateTime.Now.ToString("dd-MM-yyyy"), SysBaseInfor.GetCurrentUserId())); if (!Directory.Exists(userPath)) { Directory.CreateDirectory(userPath); } if (upload != null) { string fileName = Guid.NewGuid().ToString() + "_" + upload.FileName; if (Array.IndexOf(listDocExtension, Path.GetExtension(fileName)) > -1) { string path = Path.Combine(userPath, fileName); upload.SaveAs(path); var uriFile = string.Format("/UserImages/{0}/{1}/{2}/{3}/{4}", SysBaseInfor.GetCurrentUnitId(), SysBaseDirectory.newsAttachment, DateTime.Now.ToString("dd-MM-yyyy"), SysBaseInfor.GetCurrentUserId(), fileName); return(Json(uriFile)); } return(Json("Chỉ được tải lên file word,excel,pdf hoặc file nén zip,rar")); } ; return(Json("Không tìm thấy file!")); } catch (Exception ex) { return(Json("Có lỗi xảy ra!")); } }
public JsonResult UploadImageCkeditor(int key, HttpPostedFileWrapper upload) { try { var userPath = Server.MapPath(string.Format("~/UserImages/{0}/{1}/{2}/{3}/", SysBaseInfor.GetCurrentUnitId(), SysBaseDirectory.pictureNews, DateTime.Now.ToString("dd-MM-yyyy"), SysBaseInfor.GetCurrentUserId())); if (!Directory.Exists(userPath)) { Directory.CreateDirectory(userPath); } if (upload != null) { string imgType = ""; var isImages = upload.InputStream.IsImage(out imgType); if (isImages && !string.IsNullOrEmpty(imgType)) { string ImageName = Guid.NewGuid().ToString() + "." + imgType; string path = Path.Combine(userPath, ImageName); upload.SaveAs(path); var uriImage = string.Format("/UserImages/{0}/{1}/{2}/{3}/{4}", SysBaseInfor.GetCurrentUnitId(), SysBaseDirectory.pictureNews, DateTime.Now.ToString("dd-MM-yyyy"), SysBaseInfor.GetCurrentUserId(), ImageName); return(Json(uriImage)); } return(Json("Chỉ được tải lên file hình ảnh!")); } ; return(Json("Không tìm thấy file!")); } catch (Exception ex) { return(Json("Có lỗi xảy ra. Xin vui lòng thử lại!")); } }
public PartialViewResult TabDefaultGalleryView(string dirSelect) { if (!string.IsNullOrEmpty(dirSelect)) { int idAlbum = 0; if (int.TryParse(dirSelect, out idAlbum)) { var ctrlUI = new PictureUserDAL(); var lstImg = ctrlUI.GetLstByUnitAndUser(SysBaseInfor.GetCurrentUnitId().ToInt32(), SysBaseInfor.GetCurrentUserId(), idAlbum).Select(item => new GalereyaImage { lowsrc = item.PictureUrl, fullsrc = item.PictureUrl, description = "Ngày tải: " + item.CreatedAt.ToString("dd/MM/yyyy"), category = item.IdAlbum.ToString() }).ToArray(); ViewBag.lstImgTabDefault = lstImg; ViewBag.dirSelect = dirSelect; return(PartialView("~/Views/PictureManage/_PictureDefaultGallery.cshtml")); } else { var uriImage = string.Format("/UserImages/{0}/{1}/{2}/", SysBaseInfor.GetCurrentUnitId(), SysBaseInfor.GetCurrentUserId(), dirSelect); DirectoryInfo currentDir = new DirectoryInfo(userPicturePath + "/" + dirSelect + "/"); var lstImg = currentDir.GetFiles().OrderBy(fi => fi.CreationTime).Select(fi => new GalereyaImage { lowsrc = Url.Content(uriImage + Path.GetFileName(fi.Name)), fullsrc = Url.Content(uriImage + Path.GetFileName(fi.Name)), description = "Ngày tải: " + fi.CreationTime.ToString("dd/MM/yyyy"), category = dirSelect }).ToArray(); ViewBag.lstImgTabDefault = lstImg; ViewBag.dirSelect = dirSelect; return(PartialView("~/Views/PictureManage/_PictureDefaultGallery.cshtml")); } } else { return(PartialView("~/Views/Shared/_blank.cshtml")); } }
public JsonResult Save( int id = 0, int _status = 0, int _show_athome = 0, int _price = 0, int _price_src = 0, int _chapter = 0, int _page = 0, int _view_temp = 0, string _title = "", string _author = "", string _slug = "", string _sapo = "", string _content = "", string _cates = "", string _cates_slug = "", string _tags = "", string _tags_slug = "", string _related = "", string _meta_keywords = "", string _meta_description = "", int _cate_id = 0, string _thumbnail = "", string _preview_urls = "", string _loai_file = "", int _type = 0, int _top_level = 0, int _order = 0, int _hot_kind = 0, int _luot_mua = 0 ) { var stt = false; var msg = ""; #region Phân tích request/submit form (nếu có) if (_title == null || _title.Trim() == "") { msg = "Tên không được để trống"; } if (_slug == null || _slug.Trim() == "") { msg = "Slug không được để trống"; } else { #region Update/Insert tags var tags = _tags.Trim().Split(','); var tags_slug = new string[tags.Length];// _tags.ToLower().Trim().Split(','); for (int i = 0; i < tags.Length; i++) { tags_slug[i] = PLibs.GenerateSlug(tags[i].ToLower()); } var cates = (_cates.Trim() == "0" || _cates.Trim() == "" ? "" : _cates.Trim()).Split(','); //var cates_slug = (_cates_slug.Trim() == "0" || _cates_slug.Trim() == "" ? "" : _cates_slug.ToLower().Trim()).Split(','); var cates_slug = new string[cates.Length];// _tags.ToLower().Trim().Split(','); for (int i = 0; i < cates.Length; i++) { cates_slug[i] = PLibs.GenerateSlug(cates[i].ToLower()); } for (int i = 0; i < tags.Length; i++) { var t_slug = tags_slug[i].Trim(" -".ToCharArray()).ToLower().Trim(); if (t_slug == "") { continue; } DBLibs.ExecuteNonQuery($@" BEGIN TRAN UPDATE Tags WITH (SERIALIZABLE) SET [used] = ([used] + 1) WHERE slug = '{t_slug}' IF @@rowcount = 0 BEGIN INSERT INTO Tags ([name], [slug], created_at) VALUES (N'{tags[i].Trim(" -".ToCharArray()).Trim()}', '{t_slug}', {CLibs.DatetimeToTimestampOrgin(DateTime.Now)}) END COMMIT TRAN ", _cnn); } for (int i = 0; i < cates.Length; i++) { var c_slug = cates_slug[i].Trim(" -".ToCharArray()).ToLower().Trim(); if (c_slug == "") { continue; } DBLibs.ExecuteNonQuery($@" BEGIN TRAN UPDATE Tags WITH (SERIALIZABLE) SET [used] = ([used] + 1) WHERE slug = '{c_slug}' IF @@rowcount = 0 BEGIN INSERT INTO Tags ([name], [slug], created_at) VALUES (N'{cates[i].Trim(" -".ToCharArray()).Trim()}', '{c_slug}', {CLibs.DatetimeToTimestampOrgin(DateTime.Now)}) END COMMIT TRAN ", _cnn); } #endregion //#region Tính toán lại cateid //if (_cate_id == 0 && _cates_slug.Length > 0) //{ // var sql = $@"SELECT id FROM Tags WHERE slug = '{cates_slug[0].Trim()}'"; // var tmp = DBLibs.ExecuteScalar(sql, _cnn); // if (tmp != null) // int.TryParse(tmp.ToString(), out _cate_id); //} //#endregion if (id < 1) { #region Thêm tài liệu var exited = DBLibs.ExecuteScalar($"SELECT COUNT(*) FROM TaiLieu WHERE slug = N'{_slug.Replace("'", "''").Trim()}' OR Title = N'{_title.Replace("'", "''").Trim()}'", _cnn); if (exited != null && int.Parse(exited.ToString()) > 0) { return(Json(new { status = false, message = "Đã có tài liệu có cùng tiêu đề hoặc url!" })); } var sql = $@" INSERT INTO dbo.TaiLieu ( Slug , UnitId , TacGia , Title , Thumbnail , Summary , FullContent , Tags , Price , Price_Src , Price_Sale_Percent , [Status] , CreatedAt , UpdatedAt , CreatedBy , UpdatedBy , show_athome , SoChapter , SoPage , meta_keywords , meta_descriptions , view_temp ) VALUES ( '{_slug.Replace("'", "''")}' , -- Slug - varchar(250) {SysBaseInfor.GetCurrentUnitId()} , -- UnitId - int N'{_author.Replace("'", "''")}' , -- TacGia - nvarchar(500) N'{_title.Replace("'", "''")}' , -- Title - nvarchar(200) N'' , -- Thumbnail - nvarchar(500) N'{_sapo.Replace("'", "''")}' , -- Summary - nvarchar(1000) N'{_content.Replace("'", "''")}' , -- FullContent - ntext N'{_tags.Replace("'", "''")}' , -- Tags - nvarchar(1000) {_price} , -- Price - bigint {_price_src} , -- Price_Src - bigint {(_price == 0 ? 0 : (_price_src * 100 / _price))} , -- Price_Sale_Percent - tinyint {_status} , -- Status - tinyint GETDATE() , -- CreatedAt - datetime GETDATE() , -- UpdatedAt - datetime N'{(string.IsNullOrEmpty(SysBaseInfor.GetCurrentUserId()) ? "0" : SysBaseInfor.GetCurrentUserId())}' , -- CreatedBy - nvarchar(128) N'{(string.IsNullOrEmpty(SysBaseInfor.GetCurrentUserId()) ? "0" : SysBaseInfor.GetCurrentUserId())}' , -- UpdatedBy - nvarchar(128) {(_show_athome > 0 ? 1 : 0)} , -- show_athome - bit {_chapter} , -- SoChapter - smallint {_page} , -- SoPage - smallint N'{_meta_keywords.Replace("'", "''")}' , -- meta_keywords - nvarchar(250) N'{_meta_description.Replace("'", "''")}' , -- meta_descriptions - nvarchar(250) {_view_temp} -- view_temp - int ) SELECT SCOPE_IDENTITY() "; var newid = DBLibs.ExecuteScalar(sql, _cnn); int.TryParse(newid == null ? "0" : newid.ToString(), out id); if (newid != null) { stt = true; } else { msg = "Không thêm dữ liệu vào được!"; } #endregion } else { #region Update tài liệu var exited = DBLibs.ExecuteScalar($"SELECT COUNT(*) FROM TaiLieu WHERE id <> {id} AND (slug = N'{_slug.Replace("'", "''").Trim()}' OR title = N'{_title.Replace("'", "''").Trim()}')", _cnn); if (exited != null && int.Parse(exited.ToString()) > 0) { return(Json(new { status = false, message = "Đã có tài liệu có cùng tiêu đề hoặc url!" })); } var sql = $@" UPDATE TaiLieu SET Slug = '{_slug.Replace("'", "''")}' , -- Slug - varchar(250) --CategoryID = {_cate_id} , -- CategoryID - int TacGia = N'{_author.Trim().Replace("'", "''")}' , -- TacGia - nvarchar(500) Title = N'{_title.Trim().Replace("'", "''")}' , -- Title - nvarchar(200) Thumbnail = N'{_thumbnail.Trim().Replace("'", "''")}' , -- Thumbnail - nvarchar(500) Summary = N'{_sapo.Trim().Replace("'", "''")}' , -- Summary - nvarchar(1000) FullContent = N'{_content.Trim().Replace("'", "''")}' , -- FullContent - ntext Tags = N'{_tags.Trim().Replace("'", "''")}' , -- Tags - nvarchar(1000) Price = {_price} , -- Price - bigint Price_Src = {_price_src} , -- Price_Src - bigint Price_Sale_Percent = {(_price == 0 ? 0 : (_price_src * 100 / _price))} , -- Price_Sale_Percent - tinyint PreviewLinks = N'{_preview_urls.Trim().Replace("'", "''")}' , -- PreviewLinks - nvarchar(max) Type = {_type} , -- Type - tinyint Status = {_status} , -- Status - tinyint UpdatedAt = GETDATE() , -- UpdatedAt - datetime UpdatedBy = N'{(string.IsNullOrEmpty(SysBaseInfor.GetCurrentUserId()) ? "0" : SysBaseInfor.GetCurrentUserId())}' , -- UpdatedBy - nvarchar(128) show_athome = {(_show_athome > 0 ? 1 : 0)} , -- show_athome - bit TopLevel = {_top_level} , -- TopLevel - tinyint --Order = {_order} , -- Order - int HotKind = {_hot_kind} , -- HotKind - tinyint SoChapter = {_chapter} , -- SoChapter - smallint SoPage = {_page} , -- SoPage - smallint LuotMua = {_luot_mua} , -- LuotMua - int LoaiFile = '{_loai_file.Replace("'", "''")}' , -- LoaiFile - varchar(4) meta_keywords = N'{_meta_keywords.Replace("'", "''")}' , -- meta_keywords - nvarchar(250) meta_descriptions = N'{_meta_description.Replace("'", "''")}' , -- meta_descriptions - nvarchar(250) view_temp = {_view_temp} -- view_temp - int WHERE id = {id}"; var eff = DBLibs.ExecuteNonQuery(sql, _cnn); if (eff > 0) { stt = true; } else { msg = "Không cập nhật dữ liệu được!"; } #endregion } } #endregion return(Json(new { newid = id, status = stt, message = msg }, JsonRequestBehavior.AllowGet)); }
public ActionResult Index() { var countNews = DBLibs.ExecuteScalar($"SELECT COUNT(*) AS count FROM dbo.News Where CreatedBy = '{SysBaseInfor.GetCurrentUserId()}' OR UpdatedBy = '{SysBaseInfor.GetCurrentUserId()}' ", _cnn); ViewBag.countNews = countNews; var sql = $@"SELECT TOP 1000 [Id] ,[Name] ,[UnitId] ,[RoleType] ,[Discriminator] FROM [dbo].[AspNetRoles]"; var dtRole = DBLibs.GetDataBy_DataAdapter(sql, _cnn); ViewBag.ListRole = dtRole; return(View()); }
public string UploadImageToServer(string url, int newsId, string mediaUrl) { try { string fileExtension = Path.GetExtension(url); var uri = new Uri(url); if (Array.IndexOf(listDocExtension, fileExtension) > -1) { var strDateTime = DateTime.Now.ToString("dd-MM-yyyy"); var userDocumentPath = Server.MapPath(string.Format("~/UserImages/{0}/{1}/{2}/{3}/", SysBaseInfor.GetCurrentUnitId(), SysBaseDirectory.newsAttachment, strDateTime, SysBaseInfor.GetCurrentUserId())); if (!Directory.Exists(userDocumentPath)) { Directory.CreateDirectory(userDocumentPath); } var fileName = Guid.NewGuid().ToString() + fileExtension; using (WebClient webClient = new WebClient()) { webClient.Headers.Add("Accept: text/html, application/xhtml+xml, */*"); webClient.Headers.Add("User-Agent: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)"); webClient.DownloadFile(uri, Path.Combine(userDocumentPath, fileName)); } var urlDocument = string.Format("/UserImages/{0}/{1}/{2}/{3}/{4}", SysBaseInfor.GetCurrentUnitId(), SysBaseDirectory.newsAttachment, strDateTime, SysBaseInfor.GetCurrentUserId(), fileName); return(mediaUrl + urlDocument); } else { var strDateTime = DateTime.Now.ToString("dd-MM-yyyy"); var userPictureNewsPath = Server.MapPath(string.Format("~/UserImages/{0}/{1}/{2}/{3}/", SysBaseInfor.GetCurrentUnitId(), SysBaseDirectory.pictureNews, strDateTime, SysBaseInfor.GetCurrentUserId())); if (!Directory.Exists(userPictureNewsPath)) { Directory.CreateDirectory(userPictureNewsPath); } var fileName = Path.Combine(userPictureNewsPath, Guid.NewGuid().ToString()); using (WebClient webClient = new WebClient()) { webClient.Headers.Add("Accept: text/html, application/xhtml+xml, */*"); webClient.Headers.Add("User-Agent: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)"); webClient.DownloadFile(uri, Path.Combine(userPictureNewsPath, fileName)); } var fileStream = new FileStream(fileName, FileMode.Open); string imageType; var isImage = fileStream.IsImage(out imageType); fileStream.Close(); fileStream.Dispose(); if (isImage && !string.IsNullOrEmpty(imageType)) { var fName = newsId + "_" + Guid.NewGuid() + "." + imageType; var urlImage = string.Format("/UserImages/{0}/{1}/{2}/{3}/{4}", SysBaseInfor.GetCurrentUnitId(), SysBaseDirectory.pictureNews, strDateTime, SysBaseInfor.GetCurrentUserId(), fName); string path = Path.Combine(userPictureNewsPath, fName); System.IO.File.Move(fileName, path); return(mediaUrl + urlImage); } System.IO.File.Delete(fileName); return(null); } } catch (Exception ex) { return(null); } }
public JsonResult Delete(int id) { var stt = false; var msg = ""; #region Kiểm tra quyền được xóa (chỉ admin & người tạo mới xóa được) if ( SysBaseInfor.GetCurrentUserName().StartsWith("admin@") || int.Parse(DBLibs.ExecuteScalar($"SELECT COUNT(*) FROM TaiLieu WHERE id = {id} AND CreatedBy = '{SysBaseInfor.GetCurrentUserId()}'", _cnn).ToString()) > 0) { #region Xóa các file ảnh try { var path_imgs = Server.MapPath("~") + $"UserData/{SysBaseInfor.GetIdNguoiDung()}/{id}/"; var di = new DirectoryInfo(path_imgs); foreach (FileInfo file in di.GetFiles()) { file.Delete(); } foreach (DirectoryInfo dir in di.GetDirectories()) { dir.Delete(true); } } catch { } #endregion #region Xóa các file tài liệu try { var path_docs = Server.MapPath("~") + $"TaiLieu/{id}/"; var di = new DirectoryInfo(path_docs); foreach (FileInfo file in di.GetFiles()) { file.Delete(); } foreach (DirectoryInfo dir in di.GetDirectories()) { dir.Delete(true); } } catch { } #endregion var eff = DBLibs.ExecuteNonQuery($"DELETE TaiLieu WHERE id = {id}", _cnn); if (eff < 1) { msg = "Lỗi không xác định, không xóa được tài liệu"; } else { stt = true; } } else { msg = "Không có quyền xóa tài liệu"; } #endregion return(Json(new { status = stt, message = msg }, JsonRequestBehavior.AllowGet)); }