void IEmployeesHelper.AddProduct(Models.Employee.ItemModel model, List<HttpPostedFileBase> files)
{
//items
var product = new items
{
Title = model.Item.Title,
Price = model.Item.Price,
Id_Category = model.SelectedCategory,
Description = model.Item.Description
};
//item details
StringBuilder stringBulider = new StringBuilder();
for (int i = 0; i < model.DetailsItem.Count; i++)
{
if (!String.IsNullOrEmpty(model.DetailsItem[i]))
{
stringBulider.Append(model.DetailsItem[i]);
stringBulider.Append(";");
}
}
stringBulider.Remove(stringBulider.Length - 1, 1);
var itemDetails = new _dict_items_details
{
Name = stringBulider.ToString()
};
//item quantity
List<items_quantity> itemQuantity = new List<items_quantity>();
foreach (var quantity in model.Quantity)
{
itemQuantity.Add(
new items_quantity
{
Id_Shop = quantity.Id_Shop,
Quantity = quantity.Quantity
});
}
//item pictures
List<items_picutures> itemPictures = new List<items_picutures>();
foreach (var file in files)
{
if (file.ContentType.Equals("image/jpeg"))
{
var picture = new items_picutures();
picture.PictureMimeType = file.ContentType;
picture.PictureData = new byte[file.ContentLength];
file.InputStream.Read(picture.PictureData, 0, file.ContentLength);
itemPictures.Add(picture);
}
}
_employeeRepository.AddProduct(product, itemPictures, itemDetails, itemQuantity);
}
public void AddItem(items item, int quantity)
{
CartLine line = lineCollection
.Where(p => p.Item.Id.Equals(item.Id))
.FirstOrDefault();
if (line == null)
lineCollection.Add(new CartLine() { Item = item, Quantity = quantity });
else
line.Quantity += quantity;
}
void IEmployeeRepository.EditProduct(items item, List<items_picutures> itemPictures, _dict_items_details itemDetial, List<items_quantity> itemQuantity)
{
//item
var dbItem = _context.Items.Find(item.Id);
dbItem.Id_Category = item.Id_Category;
dbItem.Price = item.Price;
dbItem.Title = item.Title;
var dbDesc = _context.DictDescriptionItems.Find(item.Id_Description);
dbDesc.Name = item.Description.Name;
_context.SaveChanges();
//images
foreach(var picture in itemPictures)
{
var dbPic = _context.ItemsPictures.Find(picture.Id);
dbPic.PictureData = picture.PictureData;
dbPic.PictureMimeType = picture.PictureMimeType;
_context.SaveChanges();
}
//itemDetail
var dbDetail = _context.DictItemsDetails
.Where(x => x.Id_Item == itemDetial.Id_Item)
.FirstOrDefault();
dbDetail.Name = itemDetial.Name;
_context.SaveChanges();
//itemQuantity
foreach(var quantity in itemQuantity)
{
var dbQ = _context.ItemsQuantity.Find(quantity.Id);
dbQ.Quantity = quantity.Quantity;
_context.SaveChanges();
}
}
void IEmployeeRepository.AddProduct(items item, List<items_picutures> itemPictures, _dict_items_details itemDetails, List<items_quantity> itemQuantity)
{
var desc = new _dict_description_items();
desc.Name = item.Description.Name;
desc.InsertTime = DateTime.Now;
_context.DictDescriptionItems.Add(desc);
item.Description = null;
item.Id_Description = desc.Id;
_context.Items.Add(item);
itemDetails.Id_Item = item.Id;
itemDetails.InsertTime = DateTime.Now;
_context.DictItemsDetails.Add(itemDetails);
foreach(var picture in itemPictures)
{
picture.Id_Item = item.Id;
_context.ItemsPictures.Add(picture);
}
foreach(var q in itemQuantity)
{
q.Id_Item = item.Id;
_context.ItemsQuantity.Add(q);
}
_context.SaveChanges();
}
public void RemoveItem(items item)
{
lineCollection.RemoveAll(l => l.Item.Id.Equals(item.Id));
}
void IEmployeesHelper.EditProduct(Models.Employee.ItemModel model, HttpFileCollectionBase files)
{
//item
var item = new items
{
Id = model.Item.Id,
Title = model.Item.Title,
Id_Category = model.SelectedCategory,
Description = model.Item.Description,
Id_Description = model.Item.Id_Description,
Price = model.Item.Price
};
//item details
StringBuilder stringBulider = new StringBuilder();
for (int i = 0; i < model.DetailsItem.Count; i++)
{
if (!String.IsNullOrEmpty(model.DetailsItem[i]))
{
stringBulider.Append(model.DetailsItem[i]);
stringBulider.Append(";");
}
}
stringBulider.Remove(stringBulider.Length - 1, 1);
var itemDetails = new _dict_items_details
{
Id_Item = model.Item.Id,
Name = stringBulider.ToString()
};
//item quantity
List<items_quantity> itemQuantity = new List<items_quantity>();
foreach(var quantity in model.Quantity)
{
itemQuantity.Add(
new items_quantity
{
Id = quantity.Id,
Id_Shop = quantity.Id_Shop,
Quantity = quantity.Quantity
});
}
//item pictures
List<items_picutures> itemPictures = new List<items_picutures>();
foreach(string file in files)
{
if (files[file].ContentType.Equals("image/jpeg"))
{
var picture = new items_picutures();
picture.PictureMimeType = files[file].ContentType;
picture.PictureData = new byte[files[file].ContentLength];
files[file].InputStream.Read(picture.PictureData, 0, files[file].ContentLength);
var ids = file.Split(new char[] { '-' });
picture.Id = int.Parse(ids[1]);
itemPictures.Add(picture);
}
}
_employeeRepository.EditProduct(item, itemPictures, itemDetails, itemQuantity);
}
OrderModel IOrderHelper.RecalculateOrder(OrderModel model)
{
var selectedOrderId = model.selectedDeliveryId;
var selectedOrder = _ordersRepository.DictOrdersDelivery
.Where(x => x.Id.Equals(selectedOrderId))
.FirstOrDefault();
var delivery = _ordersRepository.DictOrdersDelivery;
var selectListItemDelivery = new List<SelectListItem>();
foreach (var item in delivery)
{
selectListItemDelivery.Add(new SelectListItem
{
Text = item.Name + " - " + item.Price.ToString("c"),
Value = item.Id.ToString()
});
}
model.OrderDelivery = selectListItemDelivery;
var deliveryItem = model.cart.Lines
.Where(x => x.Item.Id.Equals(0))
.FirstOrDefault();
if (deliveryItem == null)
{
model.cart.AddItem(
new items
{
Title = selectedOrder.Name,
Price = selectedOrder.Price
}, 1);
model.TotalPrice = model.cart.ComputeTotalValue();
}
else
{
var item = new items
{
Title = selectedOrder.Name,
Price = selectedOrder.Price
};
model.cart.RemoveItem(deliveryItem.Item);
model.cart.AddItem(item, 1);
model.TotalPrice = model.cart.ComputeTotalValue();
}
return model;
}
