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);
}
