public FileResult ExportExcel(ThemTinTucModel obj) { string tacvu = obj.Content; ShopDataContex db = new ShopDataContex(); DataTable dt = new DataTable("Grid"); dt.Columns.AddRange(new DataColumn[15] { new DataColumn("ID"), new DataColumn("ID2"), new DataColumn("Item title"), new DataColumn("Final URL"), new DataColumn("Image URL"), new DataColumn("Item subtitle"), new DataColumn("Item description"), new DataColumn("Item category"), new DataColumn("Price"), new DataColumn("Sale price"), new DataColumn("Contextual keywords"), new DataColumn("Item address"), new DataColumn("Tracking template"), new DataColumn("Custom parameter"), new DataColumn("Action") }); var Menus = db.Menu.Where(o => o.idControl == 11 && o.ok && o.HasValue && o.HasOnHand && o.DungSai && o.TenNgan != null && o.MoTaNgan != null).OrderByDescending(o => o.sDateOk).ToList(); foreach (var product in Menus) { string ID = "BG" + product.id_; string ID2 = ""; string Itemtitle = product.TenNgan; string FinalURL = "https://beautygarden.vn/" + product.Link + ".html"; string ImageURL = "https://beautygarden.vn/Upload/Files/" + product.Img; string Itemsubtitle = "beautygarden.vn"; string Itemdescription = product.MoTaNgan; string Itemcategory = ""; string Price = product.PricePro + " VND"; string Saleprice = ""; string Contextualkeywords = ""; string Itemaddress = ""; string Trackingtemplate = ""; string Customparameter = ""; string Action = tacvu; dt.Rows.Add(ID, ID2, Itemtitle, FinalURL, ImageURL, Itemsubtitle, Itemdescription, Itemcategory, Price, Saleprice, Contextualkeywords, Itemaddress, Trackingtemplate, Customparameter, Action); } using (XLWorkbook wb = new XLWorkbook()) { wb.Worksheets.Add(dt); using (MemoryStream stream = new MemoryStream()) { wb.SaveAs(stream); return(File(stream.ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "CSVgoogle.xlsx")); } } }
public ActionResult SaveEdit(ThemTinTucModel model) { #region update tin tuc DetailMenu dlcu = _detailMenuRepository.GetById(model.id_); dlcu.id_ = model.id_; dlcu.Name = model.Name; dlcu.Img = (model.Img).Replace("/files/", ""); dlcu.Link = model.Link; dlcu.id_ = model.id_; dlcu.Note = model.Note; dlcu.sPosition = model.sPosition; dlcu.sDate = DateTime.Now; dlcu.sDateOk = DateTime.Now; //dlcu.Content = ChangeImageSEO(model.Content, model.Name, ConvertFont(model.Name)); dlcu.Content = model.Content; dlcu.SEODescription = model.SEODescription; dlcu.SEOtitle = model.SEOtitle; dlcu.CodeName = ConvertFont(model.Name).Replace("-", " "); dlcu.IdSalePage = model.IdSalePage; dlcu.NguoiTao = User.Identity.Name; _detailMenuRepository.Update(dlcu); _unitOfWork.Commit(); #endregion if (model.mySingleField != null) { #region danh sach tag string[] separators = { "," }; var taglist = model.mySingleField.Split(separators, StringSplitOptions.RemoveEmptyEntries); //check null: nếu tồn tại thêm mới bình thường if (taglist.Any()) { foreach (var tag in taglist) { //check trung int checktrung = _tagTinTucRepository.GetTagNamebyIdmenu(model.id_, tag.Trim()); if (checktrung == 0) { TagTinTuc _tag = new TagTinTuc() { NgayTao = DateTime.Now, IdMenu = dlcu.id_, TenTag = tag.Trim(), Link = ConvertFont(tag.Trim()), Code = RejectMarks(tag.Trim()) }; _tagTinTucRepository.Add(_tag); _unitOfWork.Commit(); } } } #endregion } return(RedirectToAction("Index")); }
public ActionResult Addnew(ThemTinTucModel model) { if (ModelState.IsValid) { DetailMenu tintuc = new DetailMenu() { sDate = DateTime.Now, Name = RejectMarks(model.Name), Note = model.Note, Img = (model.Img).Replace("/files/", ""), Content = model.Content, id_Menu = 20, Link = ConvertFont(model.Name), idUser = 15, idUserOk = 15, sDateOk = DateTime.Now, ok = true, Ma_Hang = "", NameAdwords = "", Number = 0, ShowMenu = true, ShowIconHot = false, ShowKhuyenMai = false, ShowIconNew = false, TinhTrangSP = false, SEODescription = model.SEODescription, SEOtitle = model.SEOtitle }; _detailMenuRepository.Add(tintuc); _unitOfWork.Commit(); } else { return(View("Create", model)); } return(RedirectToAction("Index")); }
public ActionResult Addnew(ThemTinTucModel model) { //if (ModelState.IsValid) //{ #region them moi tin tuc DetailMenu tintuc = new DetailMenu() { sDate = DateTime.Now, Name = RejectMarks(model.Name), Note = model.Note, Img = (model.Img).Replace("/files/", ""), Content = ChangeImageSEO(model.Content, model.Name, ConvertFont(model.Name)), //Content = model.Content, id_Menu = 20, Link = ConvertFont(model.Name), idUser = 15, idUserOk = 15, sDateOk = DateTime.Now, ok = true, Ma_Hang = "", NameAdwords = "", Number = 0, ShowMenu = true, ShowIconHot = false, ShowKhuyenMai = true, ShowIconNew = false, TinhTrangSP = false, sPosition = model.sPosition, SEODescription = model.SEODescription, SEOtitle = model.SEOtitle, CodeName = ConvertFont(model.Name).Replace("-", " "), IdSalePage = model.IdSalePage, NguoiTao = User.Identity.Name }; _detailMenuRepository.Add(tintuc); _unitOfWork.Commit(); #endregion if (model.mySingleField != null) { #region them moi tag string[] separators = { "," }; var taglist = model.mySingleField.Split(separators, StringSplitOptions.RemoveEmptyEntries); //check null: nếu tồn tại thêm mới bình thường if (taglist.Any()) { foreach (var tag in taglist) { TagTinTuc _tag = new TagTinTuc() { NgayTao = DateTime.Now, IdMenu = tintuc.id_, // id cua tin moi vua them TenTag = tag.Trim(), Link = ConvertFont(tag.Trim()), Code = RejectMarks(tag.Trim()) }; _tagTinTucRepository.Add(_tag); _unitOfWork.Commit(); } } #endregion } //} //else //{ // return View("Create", model); //} return(RedirectToAction("Index")); }
public void ExportToCSVAdsDynamicGoogle(ThemTinTucModel obj) { try { string tacvu = obj.Content; tacvu = string.IsNullOrEmpty(tacvu) ? "" : tacvu; StringWriter sw = new StringWriter(); sw.WriteLine("ID\t" + "ID2\t" + "Item title\t" + "Final URL\t" + "Image URL\t" + "Item subtitle\t" + "Item description\t" + "Item category\t" + "Price\t" + "Sale price\t" + "Contextual keywords\t" + "Item address\t" + "Tracking template\t" + "Custom parameter\t" + tacvu); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment;filename=CSVAdsDynamicGoogle.csv"); Response.ContentType = "application/octet-stream"; ShopDataContex db = new ShopDataContex(); var Menus = db.Menu.Where(o => o.idControl == 11 && o.ok && o.HasValue && o.HasOnHand && o.DungSai && o.TenNgan != null && o.MoTaNgan != null).OrderByDescending(o => o.sDateOk).ToList(); foreach (var menu in Menus) { sw.WriteLine(string.Format("{0}\t" + "{1}\t" + "{2}\t" + "{3}\t" + "{4}\t" + "{5}\t" + "{6}\t" + "{7}\t" + "{8}\t" + "{9}\t" + "{10}\t" + "{11}\t" + "{12}\t" + "{13}\t" + "{14}", "BG" + menu.id_, "", CheckString25Char(menu.TenNgan == null ? menu.NameProductLong : menu.TenNgan), "https://beautygarden.vn/" + menu.Link + ".html", "https://beautygarden.vn/Upload/Files/" + menu.Img, "beautygarden.vn", CheckString25Char(menu.MoTaNgan == null ? "Mỹ Phẩm Chính Hãng" : menu.MoTaNgan), GetTenDanhMuc(menu.id_), menu.PricePro + " VND", "", "", "", "", "", tacvu )); } Response.Write(sw.ToString()); Response.End(); } catch (Exception e) { Console.WriteLine(e.Message); } }