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