public AdvertisementController(IAdvertisementService _advertisementService)
{
advertisementService = _advertisementService;
newAdvertisement = new NewAdvertisement(_advertisementService);
countVisitor = new CountVisitor(_advertisementService);
deleteAdvertisement = new DeleteAdvertisement(_advertisementService);
editAdvertisement = new EditAdvertisement(_advertisementService);
}
public void UpdateAdvertisement(NewAdvertisement item)
{
db.BeginTransaction();
int id = item.AdvertisementId;
Advertisement ad = new Advertisement();
ad.Id = id;
ad.SellingType = item.SellingType;
ad.EmployeeId = item.EmployeeId;
ad.CategoryId = item.CategoryId;
ad.Expiry = item.Expiry;
ad.PostedOn = item.PostedOn;
ad.Status = "Active";
ad.DisplayPhone = item.DisplayPhone;
var update = db.Update("Advertisement", "Id", ad);
if (update > 0)
{
db.Delete <Report>("WHERE AdvertisementId = @0", id);
db.Delete <AdminMessage>("WHERE AdvertisementId = @0", id);
Images img;
db.Delete <Images>("WHERE AdvertisementId = @0", id);
if (item.Images.Count > 0)
{
foreach (var image in item.Images)
{
img = new Images();
img.AdvertisementId = id;
ImageBlob imageBlob = new ImageBlob(_configuration);
img.Image = imageBlob.ImageUploading(image).Result;
db.Insert("Images", "Id", true, img);
}
}
else
{
img = new Images();
img.AdvertisementId = id;
db.Insert("Images", "Id", true, img);
}
foreach (var field in item.Fields)
{
db.Update <AdvertisementDetails>($"SET Value = '{field.Value}' WHERE AdvertisementId = {id} and FieldName Like '%{field.Key}'");
}
}
db.CompleteTransaction();
}
public void CreateNewAdvertisement(NewAdvertisement item)
{
db.BeginTransaction();
Console.WriteLine(item.Images);
Advertisement ad = new Advertisement();
ad.SellingType = item.SellingType;
ad.EmployeeId = item.EmployeeId;
ad.CategoryId = item.CategoryId;
ad.Expiry = item.Expiry;
ad.PostedOn = item.PostedOn;
ad.Status = "Active";
ad.DisplayPhone = item.DisplayPhone;
int id = Convert.ToInt32(db.Insert("Advertisement", "Id", true, ad));
Images img;
if (item.Images.Count > 0)
{
foreach (var image in item.Images)
{
img = new Images();
img.AdvertisementId = id;
ImageBlob imageBlob = new ImageBlob(_configuration);
img.Image = imageBlob.ImageUploading(image).Result;
db.Insert("Images", "Id", true, img);
}
}
else
{
img = new Images();
img.AdvertisementId = id;
db.Insert("Images", "Id", true, img);
}
AdvertisementDetails adDetails;
foreach (var field in item.Fields)
{
adDetails = new AdvertisementDetails();
adDetails.AdvertisementId = id;
adDetails.FieldName = field.Key;
adDetails.Value = field.Value;
db.Insert("AdvertisementDetails", "Id", true, adDetails);
}
db.CompleteTransaction();
}
public void Edit([FromBody] NewAdvertisement item)
{
_adPost.UpdateAdvertisement(item);
}
public void Create([FromBody] NewAdvertisement item)
{
_adPost.CreateNewAdvertisement(item);
}
