public async Task <ActionResult <AvailableSize> > PostAvailableSize(AvailableSize availableSize)
{
_context.AvailableSizes.Add(availableSize);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetAvailableSize", new { id = availableSize.Id }, availableSize));
}
public async Task <IActionResult> PutAvailableSize(int id, AvailableSize availableSize)
{
if (id != availableSize.Id)
{
return(BadRequest());
}
_context.Entry(availableSize).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AvailableSizeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public override string ToString()
{
if (IsConstrained)
{
return(AvailableSize.ToString());
}
else
{
return("Unconstrained");
}
}
public AvailableSize Add(AvailableSize item)
{
//proveriti da li ima taj ssid sa tom velicinom
AvailableSize ass = _AvailableSizeRepository.FindBySIIdAndSize(item.SIId, item.Size);
if (ass == null)
{
item.Id = Guid.NewGuid();
return(_AvailableSizeRepository.Add(item));
}
return(ass);
}
public ICollection <ItemVM> Search(string storeName, string model, string brand,
string sex, double minPrice, double maxPrice, double size, string sort = "ASC")
{
List <ItemVM> _items = new List <ItemVM>();
//VALIDATION OF STRINGS, FOR SEX ONLY FIRST LETTER
storeName = string.IsNullOrWhiteSpace(storeName) ? "" : storeName;
model = string.IsNullOrWhiteSpace(model) ? "" : model;
brand = string.IsNullOrWhiteSpace(brand) ? "" : brand;
sex = string.IsNullOrWhiteSpace(sex) ? "" : sex.Substring(0, 1);
maxPrice = maxPrice <= 0 ? Double.MaxValue : maxPrice;
size = size <= 0 ? 0 : size;
ICollection <Item> items = _itemService.Search(model, brand, sex);
ICollection <Store> stores = _storeService.Search(storeName);
//possible optimization
foreach (Store s in stores)
{
foreach (Item i in items)
{
StoreItem si = _storeItemService.FindByStoreIdAndItemIdAndPriceBetween(s.Id, i.Id, minPrice, maxPrice);
if (si != null)
{
ICollection <string> pics = ConvertPictures(_pictureService.FindByItemId(si.ItemId));
if (size > 0)
{
AvailableSize asa = _availableSizeService.FindBySIIdAndSize(si.Id, size);
if (asa != null)
{
_items.Add(ConvertToVM(i, si.Price, s.Name, si.Id, null, pics));
}
}
else
{
_items.Add(ConvertToVM(i, si.Price, s.Name, si.Id, null, pics));
}
}
}
}
if (sort.Equals("ASC"))
{
_items.Sort((x, y) => x.Price.CompareTo(y.Price));
}
else
{
_items.Sort((x, y) => y.Price.CompareTo(x.Price));
}
return(_items);
}
public AvailableSize Add(AvailableSize item)
{
using (_connection = new SqlConnection(_connectionString))
{
_connection.Open();
using (_command = new SqlCommand(_insertCommand, _connection))
{
_command.Parameters.AddWithValue("@Id", item.Id);
_command.Parameters.AddWithValue("@SIId", item.SIId);
_command.Parameters.AddWithValue("@Size", item.Size);
_command.ExecuteNonQuery();
return(item);
}
}
}
public ActionResult Store(NewStoreVM ns)
{
if (!IsAdmin())
{
return(Redirect("/"));
}
if (Request.Form["add"] != null)
{
//Add form
if (Validate(ns))
{
StoreItem si = new StoreItem();
si.ItemId = ns.ItemToAdd.Id;
si.StoreId = ns.Store.Id;
si.Price = ns.ItemToAdd.Price;
si = _siService.Add(si);
AvailableSize ass = new AvailableSize();
ass.SIId = si.Id;
ass.Size = ns.ItemToAdd.SelectedAverableSize.Size;
_asService.Add(ass);
return(Redirect("/Admin/Store/" + ns.Store.Id.ToString()));
}
}
else if (Request.Form["remove"] != null)
{
if (Validate(ns))
{
//remove size from item
StoreItem si = _siService.FindByStoreIdAndItemId(ns.Store.Id, ns.ItemToAdd.Id);
if (si != null)
{
_asService.RemoveBySIIdAndSize(si.Id, ns.ItemToAdd.SelectedAverableSize.Size);
return(Redirect("/Admin/Store/" + ns.Store.Id.ToString()));
}
}
}
return(Redirect("/Admin/Store/" + ns.Store.Id.ToString()));
}
public void Update(AvailableSize item)
{
throw new NotImplementedException();
}
public bool Remove(AvailableSize itemID)
{
throw new NotImplementedException();
}
