public async Task <IHttpActionResult> PutAdvert(int id, Advert advert)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != advert.Id)
{
return(BadRequest());
}
_advertRepository.UpdateAdvert(advert);
try
{
await _advertRepository.SaveAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AdvertExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void Constructor_ShouldInitializePictureCollectionCorreclty()
{
var advert = new Advert();
var pictures = advert.Pictures;
Assert.That(pictures, Is.Not.Null.And.InstanceOf <HashSet <Picture> >());
}
public ActionResult CreateAdvert(Advert advert)
{
advert.CreationTime = DateTime.Now;
advertDb.Adverts.Add(advert);
advertDb.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <ApiResult <AdverViewModel> > Item(int ID)
{
var res = new ApiResult <AdverViewModel>();
AdverViewModel m = new AdverViewModel();
if (ID > 0)
{
Advert advert = db.GetId(ID);
if (advert != null)
{
m.ID = advert.ID;
m.Title = advert.Title;
m.StartDate = Utility.GetDateFormat(advert.StartDate);
m.EndDate = Utility.GetDateFormat(advert.EndDate);
m.TypeID = advert.TypeID;
m.BackgroundColor = advert.BackgroundColor;
m.Pic = Utility.GetImgUrl(advert.Pic);
m.Url = advert.Url;
m.Sorting = advert.Sorting;
m.IsEnable = advert.IsEnable;
res.success = true;
}
}
else
{
m.StartDate = "";
m.EndDate = "";
m.IsEnable = true;
m.Title = "";
}
res.data = m;
return(await Task.Run(() => res));
}
public ActionResult Decline(int Id)
{
Advert a = (from x in ent.Adverts where x.Id == Id select x).FirstOrDefault();
ApplicationUser user = (from u in ent.Users where u.Id == a.SellerId select u).FirstOrDefault();
try
{
a.IsDeleted = true;
string imagePath1 = Server.MapPath("/images/" + a.Image1);
string imagePath2 = Server.MapPath("/images/" + a.Image2);
string imagePath3 = Server.MapPath("/images/" + a.Image3);
System.IO.File.Delete(imagePath1);
System.IO.File.Delete(imagePath2);
System.IO.File.Delete(imagePath3);
user.remainingAdvert += 1;
ent.SaveChanges();
}
catch (Exception ex)
{
string message = ex.Message;
throw;
}
Advert adv = new Advert();
adv = (from advert in ent.Adverts where advert.IsConfirmed == false && advert.IsDeleted == false select advert).Take(1).FirstOrDefault();
return(View("Index", adv));
}
public ActionResult Create([Bind(Include = "Id,Title,Description,UserID,Images")] Advert advert)
{
advert.UserID = User.Identity.GetUserId();
if (ModelState.IsValid)
{
List <ImagePath> imagePaths = new List <ImagePath>();
for (int i = 0; i < Request.Files.Count; i++)
{
var file = Request.Files[i];
if (file != null && file.ContentLength > 0)
{
var fileName = Path.GetFileName(file.FileName);
ImagePath imagePath = new ImagePath()
{
FileName = fileName,
Extension = Path.GetExtension(fileName),
Id = Guid.NewGuid()
};
imagePaths.Add(imagePath);
var path = Path.Combine(Server.MapPath("~/App_Data/Upload/"), imagePath.Id + imagePath.Extension);
file.SaveAs(path);
}
}
advert.ImagePaths = imagePaths;
db.Adverts.Add(advert);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(advert));
}
public Advert CreateAdvert(
AdvertType advertType,
string title,
string description,
string address,
int countryId,
int cityId,
int districtId,
HouseType houseType)
{
int userId = (int)_session.GetCurrentSession().UserId;
var advert = new Advert(
userId,
advertType,
title,
description,
address,
countryId,
cityId,
districtId,
houseType);
_repository.Insert(advert);
return(advert);
}
/// <summary>
/// Buy an advert
/// </summary>
/// <param name="advert">An advert</param>
/// <param name="productImage">The advert's product image</param>
/// <returns>Redirects to different view depending on the situation</returns>
public async Task <IActionResult> BuyAdvert([Bind("advertId,AdvertName,Sponsoring,BeginDateTime,DeadlineDateTime,Link,UserId")] Advert advert, IFormFile productImage)
{
if (productImage == null)
{
return(RedirectToAction("Buy", new { advert = advert }));
}
//Convert picture to bytearray
byte[] bytes;
using (BinaryReader reader = new BinaryReader(productImage.OpenReadStream()))
{
bytes = reader.ReadBytes(Convert.ToInt32(productImage.Length));
}
advert.productImage = bytes;
if (ModelState.IsValid)
{
string uri = "/Advert/BuyAdvert/";
try
{
var response = await _APIhelper.PostAdvertAsync(uri, advert);
}
catch (Exception)
{
return(RedirectToAction("Buy", new { advert = advert }));
}
return(RedirectToAction("Index"));
}
return(RedirectToAction("Buy", new { advert = advert }));
}
public ActionResult <Advert> AddAdvert(Advert advert)
{
_advertContext.Adverts.Add(advert);
_advertContext.SaveChanges();
return(advert);
}
public ActionResult <Advert> Add([FromBody] Advert advert)
{
var ad = _advertService.Add(advert);
var url = Url.Link("FindById", new { id = ad.Id });
return(Created(url, ad));
}
public ViewResult Edit(int advertId)
{
Advert advert = advertRepository.Adverts.FirstOrDefault(a => a.AdvertId == advertId);
AdvertEditViewModel advertViewModel = mapper.Map <AdvertEditViewModel>(advert);
return(View(advertViewModel));
}
public ActionResult UpdateAdvert(Advert advert, string checkBox)
{
if (ModelState.IsValid)
{
advert.DT_MODIFIED = DateTime.Now;
advert.UserID = CommonFunctions.GetUserId();
db.Entry(advert).State = EntityState.Modified;
var properties = db.AdvertFeature.Where(x => x.AdvertID == advert.AdvertID).ToList();
if (checkBox != "")
{
var features = Array.ConvertAll(checkBox.Split(','), int.Parse);
db.AdvertFeature.Where(x => x.AdvertID == advert.AdvertID).ToList().ForEach(x => db.Entry(x).State = EntityState.Deleted);
foreach (var featureId in features)
{
db.AdvertFeature.Add(new AdvertFeature {
AdvertID = advert.AdvertID, FeatureID = featureId
});
}
}
db.SaveChanges();
return(Json(new { success = true, JsonRequestBehavior.AllowGet }));
}
else
{
return(Json(new { success = false, JsonRequestBehavior.AllowGet }));
}
}
public ActionResult CreateAdvert(Advert advert, string checkBox)
{
if (ModelState.IsValid)
{
if (checkBox != "")
{
var features = Array.ConvertAll(checkBox.Split(','), int.Parse);
foreach (var featureId in features)
{
advert.AdvertFeature.Add(new AdvertFeature {
AdvertID = advert.AdvertID, FeatureID = featureId
});
}
}
advert.UserID = CommonFunctions.GetUserId();
db.Advert.Add(advert);
db.SaveChanges();
return(Json(new { success = true, JsonRequestBehavior.AllowGet }));
}
else
{
return(Json(new { success = false, JsonRequestBehavior.AllowGet }));
}
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Name,Length")] Advert advert)
{
if (id != advert.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(advert);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AdvertExists(advert.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(advert));
}
protected override void Seed(AdvertsWebApp.Models.AdvertDb context)
{
Advert ad = new Advert();
ad.AdvertId = 1;
ad.Name = "bmw";
ad.AdvertText = "šis ir labs BMW";
ad.Price = 2000.95;
ad.CreationTime = DateTime.Now;
Advert homeAd = new Advert();
homeAd.AdvertId = 2;
homeAd.Name = "māja";
homeAd.AdvertText = "liela māja";
homeAd.Price = 12000;
homeAd.CreationTime = new DateTime(1999, 12, 31);
context.Adverts.AddOrUpdate(ad);
context.Adverts.AddOrUpdate(homeAd);
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data.
}
public int Add(Advert advert)
{
if (advert == null)
{
throw new ArgumentNullException(nameof(advert));
}
var result = _advertRepository.Add(new AdvertEntity()
{
CreationDate = DateTime.Now,
Text = advert.Text,
Reward = advert.Reward,
Title = advert.Title,
AccountId = advert.AccountId,
Tags = advert.Tags?.Select(x => new TagEntity()
{
Value = x
}).ToList(),
AdvertAddressDetails = advert.AdvertAddressDetails != null ? new AdvertAddressDetailsEntity()
{
City = advert.AdvertAddressDetails.City,
Street = advert.AdvertAddressDetails.Street
} : null
});
return(result);
}
public async Task Update_Advert_Command_Should_Update_Entity_Title_And_Description()
{
var user = new User(Guid.NewGuid(), "*****@*****.**");
await _dbFixture.InsertAsync(user);
var category = new Category(Guid.NewGuid(), user.Id);
await _dbFixture.InsertAsync(category);
string advertDescription = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum bibendum purus et libero vulputate elementum.";
var advert = new Advert(Guid.NewGuid(), "Test Advert Name", advertDescription, user.Id,
category.Id, null);
await _dbFixture.InsertAsync(advert);
string newDescription = "Vestibulum bibendum purus et libero vulputate elementum. Quisque hendrerit risus turpis, vitae tristique urna feugiat nec.";
var command = new UpdateAdvert(advert.Id, "Updated Ad Title", newDescription, advert.Creator);
var updateTask = await _rabbitMqFixture.SubscribeAndGetAsync <AdvertUpdated, Advert>(_dbFixture.GetEntityTask, command.Id);
await _rabbitMqFixture.PublishAsync(command);
var updatedEntity = await updateTask.Task;
updatedEntity.ShouldNotBeNull();
updatedEntity.Title.ShouldBe(command.Title);
updatedEntity.Description.ShouldBe(command.Description);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
if (Request.QueryString["id"] != null)
{
int advertId = Convert.ToInt32(Request.QueryString["id"]);
Advert objAdvert = AdvertAction.GetAdvertById(advertId);
objAdvert.AdvertImage = AdvertAction.GetAdvertImageByAdvertId(advertId);
objAdvert.AdvertDocuments = AdvertAction.GetAdvertDocuments(advertId);
ctAdvert.GUID = System.Guid.NewGuid().ToString();
ctAdvert.ShowAdvertPreview(objAdvert);
//update the advert.counter values
AdvertAction.SetAdvertCounter(advertId);
lblAdvertId.Text = "Advert ID : " + advertId.ToString();
lblCounter.Text = (objAdvert.Counter + 1).ToString();
//Constructing the page title
Master.Page.Title = objAdvert.Title + " - " + objAdvert.Category.Description + " - GSE-Mart.aero";
}
}
}
catch (Exception ex)
{
ctlNotifier.intResponseCode = 1;
ctlNotifier.strResponse = ex.ToString();
}
}
//[ValidateAntiForgeryToken]
public ActionResult Add(AdvertViewModel model)
{
Guard.WhenArgument(model, nameof(model)).IsNull().Throw();
if (!ModelState.IsValid)
{
return(RedirectToAction("Index", "AjaxAdvert"));
}
var advert = new Advert()
{
Title = model.Title,
VehicleModelId = model.VehicleModelId,
UserId = this.User.Identity.GetUserId(),
Year = model.Year,
Price = model.Price,
Power = model.Power,
DistanceCoverage = model.DistanceCoverage,
CityId = model.CityId,
Description = model.Description,
CreatedOn = DateTime.Now
};
this.advertService.CreateAdvert(advert, null);
return(Json(model, JsonRequestBehavior.AllowGet));
}
public void UpdateAdvert(Advert advert, string userId)
{
_unitOfWork.Advert.UpdateAdvert(advert, userId);
// metoda wysyłająca maila
// ...
// dodatkowa modyfikacja danych
_unitOfWork.Complete();
}
public async Task <AdvertDto> GetAsync(int id)
{
Advert advert = await _unitOfWork.AdvertRepository.GetAsync(id);
ThrowIfNotFound(advert);
return(_mapper.Map <AdvertDto>(advert));
}
public async Task <Advert> AddAdvert(Advert advert)
{
await _context.Adverts.AddAsync(advert);
await _context.SaveChangesAsync();
return(advert);
}
public Advert CreateAdvert(Advert advert)
{
//throw new NotImplementedException();
_ctx.Adverts.Add(advert);
_ctx.SaveChanges();
return(advert);
}
public void DeleteAdvert(int id)
{
Advert advertToBeDeleted = this.GetById(id);
this.techrepoContext.Adverts.Remove(advertToBeDeleted);
this.techrepoContext.SaveChanges();
}
public void Constructor_ShouldHaveParametlessConstructor()
{
// Arrange and Act
var advert = new Advert();
// Assert
Assert.IsInstanceOf <Advert>(advert);
}
public void UpdateAdvert(Advert advert)
{
Advert advertToBeUpdated = this.GetById(advert.Id);
advertToBeUpdated = advert;
this.techrepoContext.SaveChanges();
}
public void AddAdvert(Advert ad)
{
var adEntity = this.mapper.Map <AdvertEntity>(ad);
adEntity.CreatedTime = DateTime.Now;
this.db.Adverts.Add(adEntity);
this.db.SaveChanges();
}
/// <summary>
/// 获取指定广告位
/// </summary>
/// <param name="advertId"></param>
/// <returns></returns>
public Advert GetAdvert(string advertId)
{
var ad = new Advert {
AdvertId = advertId
};
return(Session.Select(ad) ? ad : null);
}
/// <summary>
/// 删除指定广告位
/// </summary>
/// <param name="advertId">广告标识</param>
/// <returns></returns>
public bool Delete(string advertId)
{
var ad = new Advert {
AdvertId = advertId
};
return(Session.Delete(ad) > 0);
}
public void Advert_IsInstanceOfAdvert()
{
//Arrange & Act
var advert = new Advert();
//Assert
Assert.IsInstanceOf <Advert>(advert);
}
public void AddAdvert(Advert advert)
{
int ag = advert.IsAgent() ? 1 : 0;
List<String> errors = new List<String>();
SqlCommand command = myConnection.CreateCommand();
command.CommandText = "INSERT INTO [nasgor].[dbo].[Adverts] VALUES ('" + advert.getHeader() + "', '" + advert.getPhone() + "', '" + advert.getPrice() + "', '" + ag + "');";
try
{
command.ExecuteNonQuery();
}
catch (Exception ex)
{
errors.Add(ex.Message);
File.WriteAllLines("C://Users/nasgor/My Documents/clear.txt", errors);
}
}
public static void AddCarAdvert(Advert advert)
{
string query = " INSERT INTO Advert (Adtitle,Description,Email,Category,Name,Phone,Location,mileage,YearOfMake,EngineSize,FuelType,Transmission,Image1,Image2,Image3,Image4,Price,Brand,Advertid) VALUES (@Adtitle,@Description,@Email,@Category,@Name,@phone,@Location,@Mileage,@YearOfMake,@EngineSize,@FuelType,@Transmission,@Image1,@Image2,@Image3,@Image4,@Price,@Brand,@Advertid)";
command.CommandText = query;
//command.Parameters.Add(new SqlParameter("@price", advert.Price));
command.Parameters.AddWithValue("@Adtitle", advert.Title);
command.Parameters.AddWithValue("@Description", advert.Descritpion);
command.Parameters.AddWithValue("@Email", advert.Email);
command.Parameters.AddWithValue("@Category", advert.Category);
command.Parameters.AddWithValue("@Name", advert.Name);
command.Parameters.AddWithValue("@Phone", advert.Phone);
command.Parameters.AddWithValue("@Location", advert.Location);
command.Parameters.AddWithValue("@Mileage", advert.Mileage);
command.Parameters.AddWithValue("@YearOfMake", advert.Year);
command.Parameters.AddWithValue("@EngineSize", advert.EngineSize);
command.Parameters.AddWithValue("@FuelType", advert.FuelType);
command.Parameters.AddWithValue("@Transmission", advert.Transmission);
command.Parameters.AddWithValue("@Image1", advert.Image1);
command.Parameters.AddWithValue("@Image2", advert.Image2);
command.Parameters.AddWithValue("@Image3", advert.Image3);
command.Parameters.AddWithValue("@Image4", advert.Image4);
command.Parameters.AddWithValue("@Price", advert.Price);
command.Parameters.AddWithValue("@Brand", advert.Brand);
command.Parameters.AddWithValue("@Advertid", advert.Advertid);
try
{
conn.Open();
command.ExecuteNonQuery();
}
catch (Exception ex)
{
ex.ToString();
// throw;
}
finally
{
conn.Close();
command.Parameters.Clear();
}
}
protected void lblSubmit_Click(object sender, EventArgs e)
{
try
{
flimage1 = DateTime.Now.ToString("mmss") + Path.GetFileName(fluImage1.PostedFile.FileName);
if (fluImage1.FileBytes.Length > 4096000)
{
lblResult.Text = "File size cannot be greater than 4MB";
}
else if (fluImage1.FileBytes.Length == 0)
{
//fluImage1.SaveAs(Server.MapPath("~/Images/AdvertImages/Tulips.jpg"));
flimage1 = "Tulips.jpg";
}
else
{
fluImage1.SaveAs(Server.MapPath("~/AdvertImages/") + flimage1 );
}
//Upload image 2
flimage2 = DateTime.Now.ToString("mmss") + Path.GetFileName(fluImage2.FileName);
if (fluImage2.FileBytes.Length > 4096000)
{
lblResult.Text = "File size cannot be greater than 4MB";
}
else if (fluImage2.FileBytes.Length == 0)
{
// fluImage2.SaveAs(Server.MapPath("~/Images/AdvertImages/Tulips.jpg"));
flimage2 = "Tulips.jpg";
}
else
{
fluImage2.SaveAs(Server.MapPath("~/AdvertImages/") + flimage2);
}
//Upload image 3
flimage3 = DateTime.Now.ToString("mmss") + Path.GetFileName(fluImage3.FileName);
if (fluImage3.FileBytes.Length > 4096000)
{
lblResult.Text = "File size cannot be greater than 4MB";
}
else if (fluImage3.FileBytes.Length == 0)
{
flimage3="Tulips.jpg";
}
else
{
fluImage3.SaveAs(Server.MapPath("~/AdvertImages/") + flimage3);
}
//Upload image 4
flimage4 = DateTime.Now.ToString("mmss") + Path.GetFileName(fluImage4.FileName);
if (fluImage4.FileBytes.Length > 4096000)
{
lblResult.Text = "File size cannot be greater than 4MB";
}
else if (fluImage4.FileBytes.Length == 0)
{
//fluImage4.SaveAs(Server.MapPath("~/Images/AdvertImages/Tulips.jpg"));
flimage4 = "Tulips.jpg";
}
else
{
fluImage4.SaveAs(Server.MapPath("~/AdvertImages/") + flimage4);
}
}
catch (FormatException)
{
lblResult.Text = "Please upload correct format";
}
catch (FileNotFoundException)
{
lblResult.Text = "File upload Failed";
}
catch (Exception)
{
lblResult.Text = "Image Upload Failed";
//throw;
}
try
{
string title = txtAdTitle.Text;
string description = txtDescription.Text;
string email = txtEmail.Text;
string category = ddlCategory.Text;
double price = Convert.ToDouble(txtPrice.Text);
string image1 = "../AdvertImages/" + flimage1.Trim();
string image2 = "../AdvertImages/" + flimage2.Trim();
string image3 = "../AdvertImages/" + flimage3.Trim();
string image4 = "../AdvertImages/" + flimage4.Trim();
string location = txtLocation.Text;
long phone = Convert.ToInt64(txtPhone.Text);
string name = txtName.Text;
long advertid = Convert.ToInt64(DateTime.Now.ToString("yyddMMHHmmss"));
if (ddlCategory.SelectedValue == "Vehicle")
{
int mileage = Convert.ToInt32(txtCarMileage.Text);
int year = Convert.ToInt32(ddlYearOfMake.Text);
string enginesize = ddlEngsize.Text;
string fueltype = " ";
string transmission = ddlTranm.Text;
string brand = ddlCarBrand.Text;
Advert advert = new Advert(title, description, email, category, price, brand, image1, image2, image3, image4, location, mileage, year, enginesize, fueltype, transmission, phone, name, advertid);
Connection.AddCarAdvert(advert);
}
else if (ddlCategory.SelectedValue == "Computers")
{
string brand = ddlPcBrand.Text;
Advert advert = new Advert(title, description, email, category, price, brand, image1, image2, image3, image4, location, phone, name, advertid);
Connection.AddAdvert(advert);
}
else
{
string brand = "none";
Advert advert = new Advert(title, description, email, category, price, brand, image1, image2, image3, image4, location, phone, name, advertid);
Connection.AddAdvert(advert);
}
//TODO : Move message "Upload successfull" after sending user an email
try
{
Email.SendEmail(email);
}
catch (Exception ex)
{
ex.ToString();
}
ClearTextFields();
}
catch (Exception ex)
{
lblResult.Text = ex.ToString() + "Upload Failed";
}
}
/// <summary>
/// 编辑广告
/// </summary>
/// <param name="loginId">登录标识</param>
/// <param name="info">广告</param>
/// <returns>ResultDesc</returns>
public ErrType EditAdvert(string loginId, AdvertInfo info)
{
try
{
Advert advert = new Advert();
advert.ID = info.ID;
advert.Creator = info.Creator;
advert.Name = info.Name;
advert.Remark = info.Remark;
advert.Status = info.Status;
advert.Url = info.Url;
ResultDesc desc = ManagerService.EditAdvert(loginId, advert);
if (desc.Result)
return GeneralErr.Success;
else
return GeneralErr.Error;
}
catch (Exception e)
{
return GeneralErr.Error;
}
}
