public ActionResult DeleteAdvertisementCategory(int id) { try { string statusmessage = ""; AdvertisementCategory advertisementget = _advertisementCategoryService.GetAdvertisementCategoryById(id); if (!string.IsNullOrEmpty(advertisementget.FileURL)) { if (System.IO.File.Exists(Server.MapPath(advertisementget.FileURL))) { System.IO.File.Delete(Server.MapPath(advertisementget.FileURL)); } } if (advertisementget.AdvertisementItem != null) { foreach (var add in advertisementget.AdvertisementItem) { if (System.IO.File.Exists(Server.MapPath(add.FileURL))) { System.IO.File.Delete(Server.MapPath(add.FileURL)); } _advertisementItemService.DeleteAdvertisementItem(add.ItemId); } } _advertisementCategoryService.DeleteAdvertisementCategory(id); return(RedirectToAction("Index", "Advertisement", new { message = statusmessage })); } catch (Exception ex) { return(View(ex)); } }
public static async Task CreateAdvertisements(ApplicationDbContext context) { for (int i = 0; i < 20; i++) { Advertisement advertisement = new Advertisement() { Slug = "advertisement-" + i, Title = "Advertisement " + i, Text = "", Price = 200, Currency = 0, Quantity = 150, ImageId = null, GalleryId = null, DateTime = DateTime.Now }; context.Add(advertisement); await context.SaveChangesAsync(); AdvertisementCategory advertisementCategory = new AdvertisementCategory() { AdvertisementId = advertisement.Id, CategoryId = 3 }; context.AdvertisementsCategories.Add(advertisementCategory); await context.SaveChangesAsync(); } }
public ActionResult EditAdvertisementCategory(AdvertisementViewModel model) { try { string statusmessage = ""; string dateNow = CustomDataHelper.CurrentDateTimeSL.GetCurrentDate().ToString("yyyy-MM-ddTHH\\:mm\\:ss.fffffffzzz"); AdvertisementCategory advertisement = new AdvertisementCategory() { CategoryId = model.Category.CategoryId, FileURL = model.Category.FileURL, FileType = "Image", CategoryName = model.Category.CategoryName, ModifiedDate = dateNow }; if (model.Category.UploadFile != null && model.Category.UploadFile.ContentLength > 0) { if (CheckPostedFileType(model.Category.UploadFile, "Image")) { //string baseUrl = Request.Url.Scheme + "://" + Request.Url.Authority + Request.ApplicationPath.TrimEnd('/'); var uploadDir = "/Content/Advertisement/AdvertisementImage/"; string extension = Path.GetExtension(model.Category.UploadFile.FileName); string uniqueFileName = Guid.NewGuid().ToString(); var imagePath = Path.Combine(Server.MapPath(uploadDir), uniqueFileName + extension); var imageUrl = Path.Combine(uploadDir, uniqueFileName + extension); model.Category.UploadFile.SaveAs(imagePath); AdvertisementCategory advertisementget = _advertisementCategoryService.GetAdvertisementCategoryById(model.Category.CategoryId); if (!string.IsNullOrEmpty(advertisementget.FileURL)) { if (System.IO.File.Exists(Server.MapPath(advertisementget.FileURL))) { System.IO.File.Delete(Server.MapPath(advertisementget.FileURL)); } advertisement.FileURL = imageUrl; } } else { statusmessage = "Image File should be .png/.jpeg/.jpg format"; } } _advertisementCategoryService.UpdateAdvertisementCategory(advertisement); return(RedirectToAction("Index", "Advertisement", new { message = statusmessage })); } catch (Exception ex) { return(Json(ex)); } }
public async Task <IActionResult> Create([Bind("Id,Slug,Title,Text,Price,Currency,Quantity,AdvertisementsCategories,AdvertisementsAttributes,ImageId,GalleryId,DateTime,UserId")] Advertisement advertisement, int[] AdvertisementsCategories, int[] AdvertisementsAttributes) { if (ModelState.IsValid) { advertisement.DateTime = DateTime.Now; _context.Add(advertisement); await _context.SaveChangesAsync(); //Categories foreach (var item in AdvertisementsCategories) { AdvertisementCategory advertisementCategory = new AdvertisementCategory() { AdvertisementId = advertisement.Id, CategoryId = item }; _context.AdvertisementsCategories.Add(advertisementCategory); } //Attributes foreach (var item in AdvertisementsAttributes) { AdvertisementAttribute advertisementAttribute = new AdvertisementAttribute() { AdvertisementId = advertisement.Id, AttributeId = item }; _context.AdvertisementsAttributes.Add(advertisementAttribute); } await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["Users"] = new SelectList(_context.Users, "Id", "UserName", advertisement.UserId); return(View(advertisement)); }
public async Task <IActionResult> Edit(int id, [Bind("Id,Slug,Title,Text,Price,Currency,Quantity,AdvertisementsCategories,AdvertisementsAttributes,ImageId,GalleryId,DateTime,UserId")] Advertisement advertisement, int[] AdvertisementsCategories, int[] AdvertisementsAttributes) { if (id != advertisement.Id) { return(NotFound()); } if (ModelState.IsValid) { try { if (advertisement.DateTime == null) { advertisement.DateTime = DateTime.Now; } _context.Update(advertisement); await _context.SaveChangesAsync(); //Categories var advertisementCategoryList = await _context.AdvertisementsCategories.Where(p => p.AdvertisementId == id).ToListAsync(); foreach (var item in advertisementCategoryList) { var advertisementCategory = await _context.AdvertisementsCategories.FirstOrDefaultAsync(p => p.AdvertisementId == id); _context.AdvertisementsCategories.Remove(advertisementCategory); await _context.SaveChangesAsync(); } foreach (var item in AdvertisementsCategories) { AdvertisementCategory advertisementCategory = new AdvertisementCategory() { AdvertisementId = advertisement.Id, CategoryId = item }; _context.AdvertisementsCategories.Add(advertisementCategory); } //Attributes var advertisementAttributeList = await _context.AdvertisementsAttributes.Where(p => p.AdvertisementId == id).ToListAsync(); foreach (var item in advertisementAttributeList) { var advertisementAttribute = await _context.AdvertisementsAttributes.FirstOrDefaultAsync(p => p.AdvertisementId == id); _context.AdvertisementsAttributes.Remove(advertisementAttribute); await _context.SaveChangesAsync(); } foreach (var item in AdvertisementsAttributes) { AdvertisementAttribute advertisementAttribute = new AdvertisementAttribute() { AdvertisementId = advertisement.Id, AttributeId = item }; _context.AdvertisementsAttributes.Add(advertisementAttribute); } await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!AdvertisementExists(advertisement.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["AdvertisementsAttributes"] = await _context.AdvertisementsAttributes.Where(a => a.AdvertisementId == id).ToListAsync(); ViewData["AdvertisementsCategories"] = await _context.AdvertisementsCategories.Where(a => a.AdvertisementId == id).ToListAsync(); ViewData["Users"] = new SelectList(_context.Users, "Id", "UserName", advertisement.UserId); return(View(advertisement)); }
public void UpdateAdvertisementCategory(AdvertisementCategory advertisement) { _resitory.UpdateAdvertisementCategory(advertisement); }
public void SaveAdvertisementCategory(AdvertisementCategory advertisementCategory) { _resitory.SaveAdvertisementCategory(advertisementCategory); }