public string UpdatePriceFilterField()
{
string result = "No products to update";
var products = _db.ProductRepository.GetAll().Where(p => p.PriceFilter == null).Take(1000).ToList();
if (products != null)
{
var uProducts = products.ToList();
if (uProducts != null && uProducts.Count > 0)
{
foreach (var p in uProducts)
{
if (p.Price.HasValue)
{
try
{
p.PriceFilter = Convert.ToDouble(p.Price.Value);
_db.ProductRepository.Update(p);
}
catch (Exception)
{
}
}
}
_db.SaveChanges();
}
result = "Success: " + products.Count().ToString();
}
return(result);
}
public ActionResult CreatePlace(PlaceViewModel model)
{
if (ModelState.IsValid)
{
var newPlace = new Place();
newPlace.Name = model.Name;
newPlace.NameSV = model.NameSV;
newPlace.PlaceTypeId = model.PlaceTypeId;
newPlace.ParentId = model.ParentId;
_context.PlaceRepository.Insert(newPlace);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(View(model));
}
}
public ActionResult CreateProduct(ProductViewModel model)
{
if (ModelState.IsValid)
{
var newProduct = new Product();
newProduct.ProductTypeId = 1;
newProduct.SalesResponsibleId = model.SalesResponsibleId;
newProduct.PlaceId = model.PlaceId;
newProduct.Description = model.Description;
newProduct.ExternalLink = model.ExternalLink;
newProduct.Address = model.Address;
newProduct.Lat = model.Lat;
newProduct.Long = model.Long;
newProduct.IsApproved = model.IsApproved;
newProduct.InsertDate = DateTime.Now;
newProduct.LivingSpace = model.LivingSpace;
newProduct.NumberOfRooms = model.NumberOfRooms;
newProduct.Price = model.Price;
newProduct.MonthlyCharge = model.MonthlyCharge;
newProduct.SquareMeterPrice = model.SquareMeterPrice;
newProduct.YearBuilt = model.YearBuilt;
newProduct.ExternalPicLink = model.ExternalPicLink;
newProduct.PlotSize = model.PlotSize;
newProduct.RefNr = model.RefNr;
_context.ProductRepository.Insert(newProduct);
Console.Write(newProduct.Id);
_context.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(View(model));
}
}
private void SaveProduct(ProductItem product)
{
var item = new Product();
item.ProductTypeId = product.ProductTypeId;
item.SalesResponsibleId = product.SalesResponsibleId;
item.PlaceId = product.PlaceId;
item.Description = product.Description;
item.LivingSpace = product.LivingSpace;
item.NumberOfRooms = product.NumberOfRooms;
item.Price = product.Price;
item.ExternalLink = product.ExternalLink;
item.InsertDate = DateTime.Now;
item.Address = product.Address;
item.Lat = product.Lat;
item.Long = product.Long;
item.IsApproved = true;
item.RefNr = product.RefNr;
item.YearBuilt = product.YearBuilt;
_db.ProductRepository.Insert(item);
_db.SaveChanges();
item.ThumbnailUrl = UploadImages(item.Id, product);
_db.ProductRepository.Update(item);
_db.SaveChanges();
}
