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 RaiseNotificationSet() => NotificationSet?.Invoke(this, EventArgs.Empty);
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();
}
