private static string BuildBody(ProductsSet product, ClientSet client, int Price) { StringBuilder body = new StringBuilder(); string introduction = "De acuerdo a conversaciones previas habiendo expresado su interes por un/una " + product.Producto; body.Append(introduction); if (product.Marca != "") { body.Append(" de la marca " + product.Marca); } if (product.Modelo != "") { body.Append(" modelo " + product.Modelo); } body.AppendLine(" le envio informacion sobre este/esta " + product.Producto + "el cual podria interesarle:"); body.AppendLine(); body.AppendLine("Producto: " + product.Producto); body.AppendLine("Modelo: " + product.Modelo); body.AppendLine("Marca: " + product.Marca); body.AppendLine("Año: " + product.Año); body.AppendLine("Peso: " + product.Peso + " Kilos"); body.AppendLine("Potencia: " + product.Potencia + "CV"); body.AppendLine("Precio: " + Price + " Euros"); return(body.ToString()); }
private void Editar() { try { if (_IsfilterMode) { if (ProductsSetListView.Items.Count > 0 && ProductsSetListView.SelectedItem != null) { String file = ProductsSetListView.SelectedItem.ToString(); ProductsSet p = (ProductsSet)ProductsSetListView.SelectedItem; Machine productdetails = new Machine(p); productdetails._new = false; productdetails.ShowDialog(); if (!productdetails.Cancel) { _dataDC.SaveChanges(); checkNotifications(p); } } } } catch { } }
public NotificationClient(ProductsSet Product) { InitializeComponent(); _product = Product; var productList = from c in _dataDC.ProductsSet where _dataDC.NotificationSet.Where(S => S.ProductID == _product.Id).Select(S => S.SearchID).Contains(c.Id) select c; Notification = (from n in productList join cl in _dataDC.ClientSet on n.Proveedor_ID equals cl.Id select new NotificationListItem { Name = cl.Name + " " + cl.Surname, ProviderPrice = 0, ClientPrice = 0, Profit = 0, SendEmail = false, RequestProduct = false, DeleteSearch = false, ClientID = cl.Id, SearchID = n.Id }).ToList(); foreach (NotificationListItem item in Notification) { item.ProviderPrice = _product.Precio; } UpdateAddList(); }
private void MenuItem_MouseDown(object sender, RoutedEventArgs e) { //provmenu.PlacementTarget = this; //provmenu.IsOpen = true; ProductsSet p = new ProductsSet(); p.Enbusca = false.ToString(); p.Enventa = true.ToString(); if (ProvedorID != null && ProvedorID != "") { p.Proveedor_ID = ProvedorID; } Machine productdetails = new Machine(p); productdetails._new = true; productdetails.ShowDialog(); if (productdetails._new && !productdetails.Cancel) { lp.Add(p); _dataDC.ProductsSet.AddObject(p); _dataDC.SaveChanges(); filter(); checkNotifications(p); } }
public static void ClientBuyProduct(string ClientID, string ProductID) { Model1Container _dataDC = ModelSingleton.getDataDC; ProductsSet Product = _dataDC.ProductsSet.First(S => S.Id == ProductID); SaleSet currentsale = _dataDC.SaleSet.First(S => S.Client_ID == ClientID && S.Product_ID == ProductID); BuyProduct newBuyProduct = new BuyProduct(currentsale); newBuyProduct.ShowDialog(); if (!newBuyProduct.Cancel) { Product.Enventa = "false"; foreach (SaleSet item in _dataDC.SaleSet.Where(S => S.Product_ID == ProductID && S.Id != currentsale.Id)) { _dataDC.SaleSet.DeleteObject(item); } foreach (NotificationSet item in _dataDC.NotificationSet.Where(S => S.ProductID == ProductID)) { _dataDC.NotificationSet.DeleteObject(item); } _dataDC.SaveChanges(); } }
public ProductSearched(ProductsSet product) { InitializeComponent(); _product = product; _dataDC = ModelSingleton.getDataDC; product.Descripcion = ""; cbProducto.ItemsSource = _dataDC.ProductsSet.Select(S => S.Producto).Distinct().ToList(); cbModelo.ItemsSource = _dataDC.ProductsSet.Select(S => S.Modelo).Distinct().ToList(); cbMarca.ItemsSource = _dataDC.ProductsSet.Select(S => S.Marca).Distinct().ToList(); this.DataContext = product; for (int añoindex = 1900; añoindex < 2025; añoindex++) { cbYear.Items.Add(añoindex); } if (product.Año != null) { cbYear.SelectedItem = product.Año; } _product.PrivateDescription = ""; _product.Kilometer = 0; _product.Hours = 0; }
private static string BuildBody(ProductsSet product, ClientSet client, int Price) { StringBuilder body = new StringBuilder(); string introduction = "De acuerdo a conversaciones previas habiendo expresado su interes por un/una " + product.Producto; body.Append(introduction); if(product.Marca !="") { body.Append(" de la marca " + product.Marca); } if (product.Modelo != "") { body.Append(" modelo " + product.Modelo); } body.AppendLine(" le envio informacion sobre este/esta " + product.Producto + "el cual podria interesarle:"); body.AppendLine(); body.AppendLine("Producto: " + product.Producto); body.AppendLine("Modelo: " + product.Modelo); body.AppendLine("Marca: " + product.Marca); body.AppendLine("Año: " + product.Año); body.AppendLine("Peso: " + product.Peso + " Kilos"); body.AppendLine("Potencia: " + product.Potencia + "CV"); body.AppendLine("Precio: " + Price + " Euros"); return body.ToString(); }
public ProductSearched(ProductsSet product) { InitializeComponent(); _product = product; _dataDC = ModelSingleton.getDataDC; product.Descripcion = ""; cbProducto.ItemsSource = _dataDC.ProductsSet.Select(S => S.Producto).Distinct().ToList(); cbModelo.ItemsSource = _dataDC.ProductsSet.Select(S => S.Modelo).Distinct().ToList(); cbMarca.ItemsSource = _dataDC.ProductsSet.Select(S => S.Marca).Distinct().ToList(); this.DataContext = product; for ( int añoindex = 1900; añoindex < 2025; añoindex++) { cbYear.Items.Add(añoindex); } if (product.Año != null){ cbYear.SelectedItem = product.Año; } _product.PrivateDescription = ""; _product.Kilometer = 0; _product.Hours = 0; }
protected void AddProduct(object sender, EventArgs e) { UCProductList s = (UCProductList)sender; if (s.ProductsSetListView.SelectedItem != null) { ProductsSet productSelected = (ProductsSet)s.ProductsSetListView.SelectedItem; if (_dataDC.SaleSet.Where(S => S.Client_ID == _clientID && S.Product_ID == productSelected.Id).Count() == 0) { SaleListItem Item = new SaleListItem(); Item.Name = productSelected.Producto + " " + productSelected.Marca + " " + productSelected.Modelo; Item.ProviderPrice = productSelected.Precio; Item.ClientPrice = 0; Item.Profit = 0; Item.SendEmail = false; Item.ProductID = productSelected.Id; ItemList.Add(Item); addlist.ItemsSource = ItemList.ToList(); } else { MessageBox.Show("Este producto ya ha sido previamente solicitado por este cliente,vuelva a la ventana de cliente para visualizar o modificar los detalles de la solicitud anterior"); } } }
static public void checkNotifications(ProductsSet p) { Model1Container _dataDC = ModelSingleton.getDataDC; Boolean newinserted = false; foreach (ProductsSet Product in _dataDC.ProductsSet.Where(S => S.Enbusca == "True" && p.Producto.ToLower().Contains(S.Producto.ToLower()) && (p.Marca.ToLower().Contains(S.Marca) || S.Marca == "") && (p.Modelo.ToLower().Contains(S.Modelo.ToLower()) || S.Modelo == "") && p.Precio <= S.Precio && p.Año >= S.Año ) ) { if (_dataDC.SaleSet.Where(S => S.Client_ID == Product.Proveedor_ID && S.Product_ID == p.Id).Count() == 0) { if (_dataDC.NotificationSet.Where(S => S.ProductID == p.Id && S.SearchID == Product.Id).Count() == 0) { NotificationSet newNotification = new NotificationSet(); Ramdom r = new Ramdom(); newNotification.ID = r.RandomString(32); newNotification.ProductID = p.Id; newNotification.SearchID = Product.Id; _dataDC.AddToNotificationSet(newNotification); newinserted = true; } } } if (newinserted) { _dataDC.SaveChanges(); } }
private void proveedorSetListView_MouseDoubleClick(object sender, MouseButtonEventArgs e) { String file = ProductsSetListView.SelectedItem.ToString(); ProductsSet p = (ProductsSet)ProductsSetListView.SelectedItem; //Provider providerdetails = new Provider(p); //providerdetails._new = false; //providerdetails.ShowDialog(); //_dataDC.SaveChanges(); }
private void List_Notification(object sender, MouseButtonEventArgs e) { if (ListNotification.SelectedItem != null) { ProductsSet selectedProduct = (ProductsSet)ListNotification.SelectedItem; NotificationClient NCWindow = new NotificationClient(selectedProduct); NCWindow.ShowDialog(); } }
private void buttonAdd_Click(object sender, EventArgs e) { ProductsSet productsSet = new ProductsSet(); productsSet.Manufacturer = Manufacturer.Text; productsSet.Price = Price.Text; productsSet.Name = NameProduct.Text; productsSet.Amount = Amount.Text; Program.wftDb.ProductsSet.Add(productsSet); Program.wftDb.SaveChanges(); ShowProduct(); }
private void buttonEdit_Click(object sender, EventArgs e) { if (listViewClient.SelectedItems.Count == 1) { ProductsSet productsSet = listViewClient.SelectedItems[0].Tag as ProductsSet; productsSet.Manufacturer = Manufacturer.Text; productsSet.Price = Price.Text; productsSet.Name = NameProduct.Text; productsSet.Amount = Amount.Text; Program.wftDb.SaveChanges(); ShowProduct(); } }
public Machine(ProductsSet product) { InitializeComponent(); _product = product; _dataDC = ModelSingleton.getDataDC; string productPath = Properties.Settings.Default.ImagePath.ToString() + "\\" + _product.Id; if (!Directory.Exists(productPath)) { System.IO.Directory.CreateDirectory(productPath); } ProveedorSet p; if (product.Proveedor_ID != null && product.Proveedor_ID != "") { p = (ProveedorSet)_dataDC.ProveedorSet.Where(S => S.Id == product.Proveedor_ID).ToList()[0]; } else { p = new ProveedorSet(); } if (product.Descripcion != "" && product.Descripcion != null) { tbdescription.Text = product.Descripcion; } cbProducto.ItemsSource = _dataDC.ProductsSet.Select(S => S.Producto).Distinct().ToList(); cbModelo.ItemsSource = _dataDC.ProductsSet.Select(S => S.Modelo).Distinct().ToList(); cbMarca.ItemsSource = _dataDC.ProductsSet.Select(S => S.Marca).Distinct().ToList(); this.DataContext = product; tbProvider.ItemsSource = _dataDC.ProveedorSet.Select(S => S).ToList(); tbProvider.SelectedItem = p; ClientList.ItemsSource = from c in _dataDC.ClientSet where _dataDC.SaleSet.Where(S => S.Product_ID == _product.Id).Select(S => S.Client_ID).Contains(c.Id) select c; for (int añoindex = 1900; añoindex < 2025; añoindex++) { cbyear.Items.Add(añoindex); } }
private void lvProductRequested_MouseDoubleClick(object sender, MouseButtonEventArgs e) { if (lvProductRequested.Items.Count > 0 && lvProductRequested.SelectedItem != null) { ItemRequestedProductList selectedProductitem = (ItemRequestedProductList)lvProductRequested.SelectedItem; ProductsSet selectedProduct = lrequestedproduct.Where(S => S.Id == selectedProductitem.ProductID).ToList()[0]; Machine productdetails = new Machine(selectedProduct); productdetails._new = false; productdetails.ShowDialog(); if (!productdetails.Cancel) { _dataDC.SaveChanges(); UCProductList.checkNotifications(selectedProduct); } } }
private void DeleteProduct(string productID) { //Change the state to Delete ProductsSet product = lp.First(S => S.Id == productID); product.Enbusca = "false"; product.Enventa = "false"; product.Proveedor_ID = "Borrado"; foreach (SaleSet item in _dataDC.SaleSet.Where(S => S.Product_ID == productID && S.FinalPrice == 0)) { _dataDC.SaleSet.DeleteObject(item); } foreach (NotificationSet item in _dataDC.NotificationSet.Where(S => S.ProductID == productID)) { _dataDC.NotificationSet.DeleteObject(item); } _dataDC.SaveChanges(); lp = new ObservableProduct(_dataDC); ProductsSetListView.ItemsSource = lp; }
private void btAddSearch_Click(object sender, RoutedEventArgs e) { ProductsSet newProduct = new ProductsSet(); newProduct.Proveedor_ID = _client.Id; newProduct.Enbusca = true.ToString(); newProduct.Enventa = false.ToString(); ProductSearched search = new ProductSearched(newProduct); search._new = true; search.ShowDialog(); if (search._new && !search.Cancel) { lps.Add(newProduct); _dataDC.ProductsSet.AddObject(newProduct); _dataDC.SaveChanges(); lvProductSearched.ItemsSource = lps.Where(S => S.Enbusca == true.ToString() && S.Proveedor_ID == _client.Id).ToList(); } }
public Machine(ProductsSet product) { InitializeComponent(); _product = product; _dataDC = ModelSingleton.getDataDC; string productPath = Properties.Settings.Default.ImagePath.ToString() + "\\" + _product.Id; if (!Directory.Exists(productPath)) { System.IO.Directory.CreateDirectory(productPath); } ProveedorSet p; if (product.Proveedor_ID != null && product.Proveedor_ID !="") { p = (ProveedorSet)_dataDC.ProveedorSet.Where(S => S.Id == product.Proveedor_ID).ToList()[0]; } else { p = new ProveedorSet(); } if (product.Descripcion != "" && product.Descripcion != null) { tbdescription.Text = product.Descripcion; } cbProducto.ItemsSource = _dataDC.ProductsSet.Select(S => S.Producto).Distinct().ToList(); cbModelo.ItemsSource = _dataDC.ProductsSet.Select(S => S.Modelo).Distinct().ToList(); cbMarca.ItemsSource = _dataDC.ProductsSet.Select(S => S.Marca).Distinct().ToList(); this.DataContext = product; tbProvider.ItemsSource = _dataDC.ProveedorSet.Select(S=> S ).ToList(); tbProvider.SelectedItem = p ; ClientList.ItemsSource = from c in _dataDC.ClientSet where _dataDC.SaleSet.Where(S => S.Product_ID == _product.Id).Select(S => S.Client_ID).Contains(c.Id) select c; for (int añoindex = 1900; añoindex < 2025; añoindex++) { cbyear.Items.Add(añoindex); } }
private void MenuItem_MouseDown(object sender, RoutedEventArgs e) { //provmenu.PlacementTarget = this; //provmenu.IsOpen = true; ProductsSet p = new ProductsSet(); p.Enbusca = false.ToString(); p.Enventa = true.ToString(); Machine productdetails = new Machine(p); productdetails._new = true; productdetails.ShowDialog(); if (productdetails._new) { lp.Add(p); _dataDC.ProductsSet.AddObject(p); _dataDC.SaveChanges(); } _dataDC.Dispose(); }
public BaseResponse AddProduct(ProductsSet product, ProductTranslations[] translations = null) { return((BaseResponse)_businessOperation.AddProduct(product, translations)); }
public static void checkNotifications(ProductsSet p) { Model1Container _dataDC = ModelSingleton.getDataDC; Boolean newinserted = false; foreach (ProductsSet Product in _dataDC.ProductsSet.Where(S=>S.Enbusca == "True" && p.Producto.ToLower().Contains(S.Producto.ToLower()) && (p.Marca.ToLower().Contains(S.Marca) || S.Marca == "") && (p.Modelo.ToLower().Contains(S.Modelo.ToLower()) || S.Modelo == "") && p.Precio <= S.Precio && p.Año >= S.Año ) ) { if (_dataDC.SaleSet.Where(S => S.Client_ID == Product.Proveedor_ID && S.Product_ID == p.Id).Count() == 0) { if (_dataDC.NotificationSet.Where(S => S.ProductID == p.Id && S.SearchID == Product.Id).Count() == 0) { NotificationSet newNotification = new NotificationSet(); Ramdom r = new Ramdom(); newNotification.ID = r.RandomString(32); newNotification.ProductID = p.Id; newNotification.SearchID = Product.Id; _dataDC.AddToNotificationSet(newNotification); newinserted = true; } } } if (newinserted) _dataDC.SaveChanges(); }