//Добавление продукции в базе для выбраного магазина private void Add(string nameShopr) { List <ModelProductDAO> modelProductDAOs = new List <ModelProductDAO>(); ModelProductDAO modelProductDAO = new ModelProductDAO(); List <ModelDatePrice> listmodelDatePrices = null; ModelDatePrice modelDatePrice = null; var prod = dAOContext.shope.FirstOrDefault(s => s.nameShope == nameShopr); foreach (var product in ManagerShope.listProduct) { modelDatePrice = new ModelDatePrice(); listmodelDatePrices = new List <ModelDatePrice>(); var s = prod.shope.FirstOrDefault(p => p.id == product.id); if (s == null) { modelDatePrice.dataTime = DateTime.Today.ToLongDateString(); modelDatePrice.price = product.price; listmodelDatePrices.Add(modelDatePrice); modelProductDAO.description = product.description; modelProductDAO.listPhoto = DeserizerPhotoInStr(product.listPhoto); modelProductDAO.ModelDatePrice = listmodelDatePrices; modelProductDAO.nameProduct = product.nameProduct; modelProductDAO.id = product.id; dAOContext.shope.Update(prod); dAOContext.SaveChanges(); } } }
private ModelAllShoppe SetModelAllShope() { ModelAllShoppe modelAllShoppe = null; ModelProductDAO modelProduct = null; ModelPhoto modelPhoto = null; ModelDatePrice modelDate = null; modelAllShoppe = new ModelAllShoppe(); modelAllShoppe.shope = new List <ModelProductDAO>(); foreach (var product in ManagerShope.listProduct) { modelProduct = new ModelProductDAO(); modelPhoto = new ModelPhoto(); modelDate = new ModelDatePrice(); modelProduct.listPhoto = new List <ModelPhoto>(); modelProduct.ModelDatePrice = new List <ModelDatePrice>(); modelDate.dataTime = DateTime.Today.ToLongDateString(); modelDate.price = product.price; modelProduct.listPhoto.AddRange(DeserizerPhotoInStr(product.listPhoto)); modelProduct.ModelDatePrice.Add(modelDate); modelProduct.description = product.description; modelProduct.id = product.id; modelProduct.nameProduct = product.nameProduct; modelAllShoppe.shope.Add(modelProduct); } return(modelAllShoppe); }
//Обновление продукции в базе для выбраного магазина public void UpdateProduct(string nameShopr) { init(); Remove(nameShopr); init(); Add(nameShopr); init(); ModelDatePrice price = null; var shope = dAOContext.shope.ToList().FirstOrDefault(s => s.nameShope == nameShopr).shope; foreach (var prpod in ManagerShope.listProduct) { try { price = new ModelDatePrice(); string tempDataPrice = DateTime.Today.ToLongDateString(); var product = shope.FirstOrDefault(p => p.id == prpod.id); ModelDatePrice dataPrice = product.ModelDatePrice.FirstOrDefault(d => d.dataTime == ""); if (dataPrice == null) { price.dataTime = DateTime.Today.ToLongDateString(); price.id = prpod.id; price.price = prpod.price; dAOContext.dataTime.Add(price); dAOContext.SaveChanges(); } } catch (Exception) { } } }
//Возращает колекцию цен с датами продукта private List <ModelDatePrice> GetDatePrices(string price, ModelProductDAO modelProductDAO = null) { List <ModelDatePrice> listModelDatePrices = new List <ModelDatePrice>(); ModelDatePrice modelDatePrice = new ModelDatePrice(); try { if (modelProductDAO != null && modelProductDAO.ModelDatePrice != null) { listModelDatePrices = modelProductDAO.ModelDatePrice; } modelDatePrice.dataTime = DateTime.Today.ToLongDateString(); modelDatePrice.price = price; listModelDatePrices.Add(modelDatePrice); } catch (Exception e) { throw new Exception(e.Message); } return(listModelDatePrices); }