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