protected override void OnNavigatedTo(NavigationEventArgs e)
{
base.OnNavigatedTo(e);
string productID_;
NavigationContext.QueryString.TryGetValue("id", out productID_);
if (!string.IsNullOrEmpty(productID_) )
{
productID = productID_;
tbID.Text = productID;
DiscountDataContext db = new DiscountDataContext();
var lProduct = from c in db.Products where c.productID == productID select c;
foreach (var prod_i in lProduct)
{
product = prod_i;
}
storeName = product.storeName;
tbStoreName.Text = storeName;
nameFile = product.productID;
InitializeSettings();
tbProductName.Text += product.productName;
tbOldPrice.Text = product.oldPrice + " р.";
tbNewPrice.Text = product.newPrice + " р.";
tbDiscount.Text = product.discount.ToString() + "%";
tbStartDate.Text = product.startDate;
tbEndDate.Text = product.endDate;
//lbProduct.ItemsSource = product;
}
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
base.OnNavigatedTo(e);
string productID_;
NavigationContext.QueryString.TryGetValue("id", out productID_);
if (!string.IsNullOrEmpty(productID_))
{
productID = productID_;
tbID.Text = productID;
DiscountDataContext db = new DiscountDataContext();
var lProduct = from c in db.Products where c.productID == productID select c;
foreach (var prod_i in lProduct)
{
product = prod_i;
}
storeName = product.storeName;
tbStoreName.Text = storeName;
nameFile = product.productID;
InitializeSettings();
tbProductName.Text += product.productName;
tbOldPrice.Text = product.oldPrice + " р.";
tbNewPrice.Text = product.newPrice + " р.";
tbDiscount.Text = product.discount.ToString() + "%";
tbStartDate.Text = product.startDate;
tbEndDate.Text = product.endDate;
//lbProduct.ItemsSource = product;
}
}
public CProductsSearch(ProductsTable p_)
{
base.discount = p_.discount;
base.endDate = p_.endDate;
base.imageURL = p_.imageURL;
base.newPrice = p_.newPrice;
base.oldPrice = p_.oldPrice;
base.productID = p_.productID;
base.productName = p_.productName;
base.productType = p_.productType;
base.productTypeID = p_.productTypeID;
base.startDate = p_.startDate;
base.storeID = p_.storeID;
base.storeName = p_.storeName;
}
public CProductsSearch(ProductsTable p_)
{
base.discount = p_.discount;
base.endDate = p_.endDate;
base.imageURL = p_.imageURL;
base.newPrice = p_.newPrice;
base.oldPrice = p_.oldPrice;
base.productID = p_.productID;
base.productName = p_.productName;
base.productType = p_.productType;
base.productTypeID = p_.productTypeID;
base.startDate = p_.startDate;
base.storeID = p_.storeID;
base.storeName = p_.storeName;
}
private void saveDBProductsLocally()
{
using (DiscountDataContext db = new DiscountDataContext())
{
var lProducts = from c in db.Products
select c;
foreach (var i in lProducts)
{
db.Products.DeleteOnSubmit(i);
}
db.SubmitChanges();
foreach (CProduct prod_i in products)
{
var product = new ProductsTable();
product.productID = prod_i.productID;
product.productName = prod_i.productName;
product.storeID = prod_i.storeID;
product.storeName = prod_i.storeName;
product.productTypeID = prod_i.productsTypeID;
product.productType = prod_i.productsType;
product.discount = prod_i.discount;
product.oldPrice = prod_i.oldPrice;
product.newPrice = prod_i.newPrice;
product.startDate = prod_i.startDate;
product.endDate = prod_i.endDate;
product.imageURL = prod_i.imageURL;
db.Products.InsertOnSubmit(product);
}
db.SubmitChanges();
}
cleanStorage();
}
private void saveDBProductsLocally()
{
using (DiscountDataContext db = new DiscountDataContext())
{
var lProducts = from c in db.Products
select c;
foreach (var i in lProducts)
{
db.Products.DeleteOnSubmit(i);
}
db.SubmitChanges();
foreach (CProduct prod_i in products)
{
var product = new ProductsTable();
product.productID = prod_i.productID;
product.productName = prod_i.productName;
product.storeID = prod_i.storeID;
product.storeName = prod_i.storeName;
product.productTypeID = prod_i.productsTypeID;
product.productType = prod_i.productsType;
product.discount = prod_i.discount;
product.oldPrice = prod_i.oldPrice;
product.newPrice = prod_i.newPrice;
product.startDate = prod_i.startDate;
product.endDate = prod_i.endDate;
product.imageURL = prod_i.imageURL;
db.Products.InsertOnSubmit(product);
}
db.SubmitChanges();
}
cleanStorage();
}
