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