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