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