public ProductCollection FetchAll() { ProductCollection coll = new ProductCollection(); Query qry = new Query(Product.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public void Acc_ETL_CollectionToTable() { ProductCollection coll = new ProductCollection().Where("CategoryID", 1); coll.Load(); DataTable tbl = coll.ToDataTable(); Assert.IsTrue(coll.Count == tbl.Rows.Count); }
/// <summary> /// Fetches all products by category id. /// </summary> /// <param name="categoryId">The category id.</param> /// <returns></returns> public ProductCollection FetchAllProductsByCategoryId(int categoryId) { IDataReader reader = SPs.FetchAllProductsByCategoryId(categoryId).GetReader(); ProductCollection productCollection = new ProductCollection(); productCollection.LoadAndCloseReader(reader); return productCollection; }
public static ProductCollection BestRating() { ProductCollection list = new ProductCollection(); //list.ReadTop(4, true, Product.Columns.Total_Rate); return list; }
public void Acc_ETL_CloneCollection() { ProductCollection coll = new ProductCollection().Where("CategoryID", 1); coll.Load(); ProductCollection coll2 = new ProductCollection(); coll2.AddRange(coll.Clone()); Assert.IsTrue(coll.Count == coll2.Count); }
public virtual ProductCollection GetProducts() { var products = ProductHelper.GetProducts(2); var collection = new ProductCollection(products); collection.Links.Add(new Link("self", "/products")); collection.Links.Add(new Link("product", "/products/{productId}")); return collection; }
public void BatchSaveInsert() { ProductCollection c = CreateProductCollection(); c.BatchSave(); c = new ProductCollection(); c.Load(ReadOnlyRecord<Product>.FetchByParameter(Product.Columns.ProductName, Comparison.Like, "Unit Test Product%")); Assert.AreEqual(1000, c.Count, "Expected 1000 - After Save: " + c.Count); }
public static Product callbackProductName(string ProductId) { ProductCollection lists = new ProductCollection(); lists.ReadList(Criteria.NewCriteria(Product.Columns.ProductId,CriteriaOperators.Like,ProductId)); if (lists.Count != 0) { return lists[0]; } else return null; }
public static ProductCollection tablets() { ProductCollection lists = new ProductCollection(); lists.ReadList(Criteria.NewCriteria(Product.Columns.Category, CriteriaOperators.Like, "tablet")); if (lists.Count != 0) { return lists; } else return null; }
public static IEnumerable<ProductVM> MapToProductVMList(ProductCollection productCollection) { return productCollection.Select(product => new ProductVM { ID = product.Id, Naam = product.Naam, LeverancierNaam = product.LeverancierNaam, Prijs = product.Prijs, AfbeeldingPad = Util.AfbeeldingPrefix + product.AfbeeldingURL, }); }
private static void AssertProductCollection(ProductCollection productCollection, ProductCollection expectedProductCollection) { for (int i = 0; i < productCollection.Count; i++) { Assert.AreEqual(expectedProductCollection[i].Id, productCollection[i].Id); Assert.AreEqual(expectedProductCollection[i].Naam, productCollection[i].Naam); Assert.AreEqual(expectedProductCollection[i].LeverancierNaam, productCollection[i].LeverancierNaam); Assert.AreEqual(expectedProductCollection[i].AfbeeldingURL, productCollection[i].AfbeeldingURL); Assert.AreEqual(expectedProductCollection[i].Prijs, productCollection[i].Prijs); } }
private static void AssertProductCollectionWithProductVMList(ProductCollection productCollection, IEnumerable<ProductVM> productVMList) { var productVMArray = productVMList.ToArray(); for (int i = 0; i < productCollection.Count; i++) { Assert.AreEqual(productVMArray[i].ID, productCollection[i].Id); Assert.AreEqual(productVMArray[i].Naam, productCollection[i].Naam); Assert.AreEqual(productVMArray[i].LeverancierNaam, productCollection[i].LeverancierNaam); Assert.AreEqual(productVMArray[i].AfbeeldingPad, Util.AfbeeldingPrefix + productCollection[i].AfbeeldingURL); Assert.AreEqual(productVMArray[i].Prijs, productCollection[i].Prijs); } }
private static ProductCollection DBMapping(DBProductCollection dbCollection) { if (dbCollection == null) return null; ProductCollection collection = new ProductCollection(); foreach (DBProduct dbItem in dbCollection) { Product item = DBMapping(dbItem); collection.Add(item); } return collection; }
public void GetCostOfAllItems_ShouldReturnTheCostOfAllItems() { var productCollection = new ProductCollection { Items = new List<Product> { new Product {Price = 10}, new Product {Price = 10}, new Product {Price = 10} } }; var result = productCollection.GetCostOfAllItems(); Assert.That(result, Is.EqualTo(30)); }
private ProductCollection GetProducts() { int totalItems = 0; ProductCollection productCollection = new ProductCollection(); try { ViewedItemsCollection collection = ViewedItemManager.GetCurrentViewedItem(10, 0, out totalItems); List<int> productsIDs = collection.Select(x => x.ProductVariantID).ToList(); foreach (var productID in productsIDs) { ProductVariant product = ProductManager.GetProductVariantByID(productID); productCollection.Add(product.Product); } } catch { } return productCollection; }
public void DeferredDelete() { ProductCollection c = CreateProductCollection(); c.BatchSave(); c = new ProductCollection(); c.Load(ReadOnlyRecord<Product>.FetchByParameter(Product.Columns.ProductName, Comparison.Like, "Unit Test Product%")); Assert.AreEqual(1000, c.Count, "Expected 1000 - After Save: " + c.Count); while(c.Count > 0) c.RemoveAt(0); // RemoveItem() gets called c.SaveAll(); c = new ProductCollection(); c.Load(ReadOnlyRecord<Product>.FetchByParameter(Product.Columns.ProductName, Comparison.Like, "Unit Test Product%")); Assert.AreEqual(0, c.Count, "Expected 0 - After Save: " + c.Count); }
/// <summary> /// Will sort the product collection passed in depending on the sort by. /// </summary> /// <param name="products">The product collection to sort.</param> /// <param name="sortBy">The type of sorting.</param> public static void SortProducts(ProductCollection products, CatalogSortBy sortBy) { switch (sortBy) { case CatalogSortBy.PriceAscending: products.Sort(delegate(Product p1, Product p2) { return p1.OurPrice.CompareTo(p2.OurPrice); }); break; case CatalogSortBy.PriceDescending: products.Sort(delegate(Product p1, Product p2) { return p2.OurPrice.CompareTo(p1.OurPrice); }); break; case CatalogSortBy.TitleAscending: products.Sort(delegate(Product p1, Product p2) { return p1.Name.CompareTo(p2.Name); }); break; case CatalogSortBy.TitleDescending: products.Sort(delegate(Product p1, Product p2) { return p2.Name.CompareTo(p1.Name); }); break; case CatalogSortBy.DateUpdatedAscending: products.Sort(delegate(Product p1, Product p2) { return p2.CreatedOn.CompareTo(p1.CreatedOn); }); break; case CatalogSortBy.DateCreatedAscending: products.Sort(delegate(Product p1, Product p2) { return p1.CreatedOn.CompareTo(p2.CreatedOn); }); break; case CatalogSortBy.DateCreatedDescending: products.Sort(delegate(Product p1, Product p2) { return p2.ModifiedOn.CompareTo(p1.ModifiedOn); }); break; case CatalogSortBy.DateUpdatedDescending: products.Sort(delegate(Product p1, Product p2) { return p1.ModifiedOn.CompareTo(p2.ModifiedOn); }); break; } }
/// <summary> /// /// </summary> /// <returns></returns> public static ProductCollection GetCommend() { ProductCollection list = new ProductCollection(); string sql = "select * from t_product where iscommend = 1 order by prod_id desc limit 18"; MySqlDataReader reader = DbHelper.ExecuteDataReader(sql); if (reader.HasRows) { while (reader.Read()) { list.Add(FillDataRecord(reader)); } } reader.Close(); return list; }
public void Query_Updates() { Query qry = new Query(Product.Schema); qry.AddUpdateSetting("Discontinued", true); qry.AddWhere(Product.Columns.ProductName, "Unit Test Product 3"); qry.Execute(); //verify qry = new Query(Product.Schema); qry.AddWhere(Product.Columns.ProductName, "Unit Test Product 3"); ProductCollection coll = new ProductCollection(); using(IDataReader rdr = qry.ExecuteReader()) { coll.Load(rdr); rdr.Close(); } foreach(Product prod in coll) Assert.IsTrue(prod.Discontinued); }
/// <summary> /// Handles the Click event of the lbDelete control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="T:System.Web.UI.WebControls.CommandEventArgs"/> instance containing the event data.</param> protected void lbDelete_Click(object sender, CommandEventArgs e) { try { Manufacturer manufacturer; int manufacturerId = 0; int.TryParse(e.CommandArgument.ToString(), out manufacturerId); if (manufacturerId > 0) { manufacturer = new Manufacturer(manufacturerId); ProductCollection productCollection = new ProductCollection().Where(Product.Columns.ManufacturerId, Comparison.Equals, manufacturerId).Load(); if (productCollection.Count > 0) { Master.MessageCenter.DisplayFailureMessage(string.Format(LocalizationUtility.GetText("lblUnableToDeleteManufacturers"), manufacturer.Name)); } else { Manufacturer.Delete(manufacturerId); LoadManufacturers(); Master.MessageCenter.DisplaySuccessMessage(LocalizationUtility.GetText("lblManufacturerDeleted")); } } } catch (HttpException) { try { if(dgManufacturers.PageCount > 1) { dgManufacturers.CurrentPageIndex = dgManufacturers.CurrentPageIndex - 1; } else { dgManufacturers.CurrentPageIndex = 0; } dgManufacturers.DataBind(); Master.MessageCenter.DisplaySuccessMessage(LocalizationUtility.GetText("lblManufacturerDeleted")); } catch (Exception exe) { Logger.Error(typeof(manufacturers).Name + ".lbDelete_Click", exe); Master.MessageCenter.DisplayCriticalMessage(LocalizationUtility.GetCriticalMessageText(exe.Message)); } } catch (Exception ex) { Logger.Error(typeof(manufacturers).Name + ".lbDelete_Click", ex); Master.MessageCenter.DisplayCriticalMessage(ex.Message); } }
public static void CheckAreValidProducts( Microsoft.UpdateServices.Administration.IUpdateServer server, ProductCollection products, System.String runSetName, System.String groupId, System.String classificationId ) { //make sure we have at least one product if (products.Count < 1) { System.String groupPath = (groupId != null) ? "\\TargetGroups\\" + groupId : "\\AllTargetGroups"; throw new System.Configuration.ConfigurationErrorsException( "The products section in \"" + runSetName + groupPath + "\\Classifications\\" + classificationId + "\\\" must have at least 1 item." ); } foreach (Product product in products) { //make sure the product exists on wsus try { server.GetUpdateCategory(product.Guid); } catch (System.Exception) { throw new System.ArgumentException( "The Product Guid \"" + product.Guid + "\" could not be found on the WSUS server. Run Set: " + runSetName ); } //todo: make sure the product doesn't appear in the list twice //todo: make sure the product parent hasn't already been added to the list } }
/// <summary>Register the price and currency that a user is using to make iOS in-app purchases.</summary> /// <remarks> /// After receiving the list of in-app purchases from Apple, this method can be called to record the localized item information. /// This overload is meant to be called from Unity's IStoreListener.OnInitialized callback passing in the /// ProductCollection which you can get from the IStoreListener using the products property. /// </remarks> /// <param name="unityProducts">A collection containing all the products registered with Unity.</param> public static void RegisterIOSInAppPurchaseList(ProductCollection unityProducts) { if(unityProducts == null || unityProducts.all == null || unityProducts.all.Length == 0) return; Product[] products = unityProducts.all; var fuseProducts = new List<FuseMisc.Product>(); foreach(var p in products) { if(p.availableToPurchase) { fuseProducts.Add(new FuseMisc.Product() { ProductId = p.definition.storeSpecificId, Price = (float)p.metadata.localizedPrice, PriceLocale = p.metadata.isoCurrencyCode }); } } RegisterIOSInAppPurchaseList(fuseProducts.ToArray()); }
private static void AddUpdateDeleteProducts(ZipArchiveEntry entry) { IEnumerable<Product> products = null; using (var entryStream = entry.Open()) { Console.WriteLine("products.csv is {0} bytes", entry.Length); Console.WriteLine("Starting products at {0:hh:mm:ss.fff}", DateTime.Now); var stopwatch = new Stopwatch(); stopwatch.Start(); var reader = new StreamReader(entryStream); var csv = new CsvReader(reader); csv.Configuration.RegisterClassMap(new ProductMap()); products = csv.GetRecords<Product>().Where(p => !p.IsDead); var productCollection = new ProductCollection(); productCollection.SetItems(products); var importer = new NpgsqlBulkImporter(ConfigurationManager.ConnectionStrings["spurious"].ConnectionString, stopwatch); importer.BulkImport("products", productCollection); stopwatch.Stop(); Console.WriteLine("Finished products at {0:hh:mm:ss.fff}, taking {1}", DateTime.Now, stopwatch.Elapsed); } }
public void Acc_Products_CollectionSample() { // sample snippet #1 ProductCollection products = new ProductCollection().Where("categoryID", 1).Load(); Assert.AreEqual(12, products.Count); // sample snippet #2 products = new ProductCollection().Where("categoryID", 1).OrderByAsc("ProductName").Load(); Assert.AreEqual(12, products.Count); Assert.AreEqual("Chai", products[0].ProductName); Assert.AreEqual("Steeleye Stout", products[11].ProductName); }
/// <summary> /// Gets a "recently viewed products" list /// </summary> /// <param name="Number">Number of products to load</param> /// <returns>"recently viewed products" list</returns> public static ProductCollection GetRecentlyViewedProducts(int Number) { ProductCollection products = new ProductCollection(); List<int> productIDs = GetRecentlyViewedProductsIDs(Number); foreach (int productID in productIDs) { Product product = GetProductByID(productID); if (product != null && product.Published && !product.Deleted) products.Add(product); } return products; }
public IActionResult Index(ProductCollection model) { return(View(model)); }
protected void resultFilter(string SearchFor) { int CategoryFilterID = CommonLogic.QueryStringUSInt("CategoryFilterID"); int SectionFilterID = CommonLogic.QueryStringUSInt("SectionFilterID"); int ProductTypeFilterID = CommonLogic.QueryStringUSInt("ProductTypeFilterID"); int ManufacturerFilterID = CommonLogic.QueryStringUSInt("ManufacturerFilterID"); int DistributorFilterID = CommonLogic.QueryStringUSInt("DistributorFilterID"); int GenreFilterID = CommonLogic.QueryStringUSInt("GenreFilterID"); int VectorFilterID = CommonLogic.QueryStringUSInt("VectorFilterID"); int AffiliateFilterID = CommonLogic.QueryStringUSInt("AffiliateFilterID"); int CustomerLevelFilterID = CommonLogic.QueryStringUSInt("CustomerLevelFilterID"); String ENCleaned = CommonLogic.QueryStringCanBeDangerousContent("EntityName").Trim().ToUpperInvariant(); // kludge for now, during conversion to properly entity/object setup: if (ENCleaned == "CATEGORY") { CategoryFilterID = CommonLogic.QueryStringUSInt("EntityFilterID"); SectionFilterID = 0; ProductTypeFilterID = Localization.ParseNativeInt(ddTypes.SelectedValue); ManufacturerFilterID = 0; DistributorFilterID = 0; GenreFilterID = 0; VectorFilterID = 0; AffiliateFilterID = 0; CustomerLevelFilterID = 0; _entityId = CategoryFilterID; _entityName = ENCleaned; } if (ENCleaned == "SECTION") { CategoryFilterID = 0; SectionFilterID = CommonLogic.QueryStringUSInt("EntityFilterID"); ProductTypeFilterID = Localization.ParseNativeInt(ddTypes.SelectedValue); ManufacturerFilterID = 0; DistributorFilterID = 0; GenreFilterID = 0; VectorFilterID = 0; AffiliateFilterID = 0; CustomerLevelFilterID = 0; _entityId = SectionFilterID; _entityName = ENCleaned; } if (ENCleaned == "MANUFACTURER") { CategoryFilterID = 0; SectionFilterID = 0; ProductTypeFilterID = Localization.ParseNativeInt(ddTypes.SelectedValue); ManufacturerFilterID = CommonLogic.QueryStringUSInt("EntityFilterID"); DistributorFilterID = 0; GenreFilterID = 0; VectorFilterID = 0; AffiliateFilterID = 0; CustomerLevelFilterID = 0; _entityId = ManufacturerFilterID; _entityName = ENCleaned; } if (ENCleaned == "DISTRIBUTOR") { CategoryFilterID = 0; SectionFilterID = 0; ProductTypeFilterID = Localization.ParseNativeInt(ddTypes.SelectedValue); ManufacturerFilterID = 0; DistributorFilterID = CommonLogic.QueryStringUSInt("EntityFilterID"); GenreFilterID = 0; VectorFilterID = 0; AffiliateFilterID = 0; CustomerLevelFilterID = 0; _entityId = DistributorFilterID; _entityName = ENCleaned; } if (ENCleaned == "GENRE") { CategoryFilterID = 0; SectionFilterID = 0; ProductTypeFilterID = Localization.ParseNativeInt(ddTypes.SelectedValue); ManufacturerFilterID = 0; DistributorFilterID = 0; GenreFilterID = CommonLogic.QueryStringUSInt("EntityFilterID"); VectorFilterID = 0; AffiliateFilterID = 0; CustomerLevelFilterID = 0; _entityId = GenreFilterID; _entityName = ENCleaned; } if (ENCleaned == "VECTOR") { CategoryFilterID = 0; SectionFilterID = 0; ProductTypeFilterID = Localization.ParseNativeInt(ddTypes.SelectedValue); ManufacturerFilterID = 0; DistributorFilterID = 0; GenreFilterID = 0; VectorFilterID = CommonLogic.QueryStringUSInt("EntityFilterID"); AffiliateFilterID = 0; CustomerLevelFilterID = 0; _entityId = VectorFilterID; _entityName = ENCleaned; } if (ENCleaned == "AFFILIATE") { CategoryFilterID = 0; SectionFilterID = 0; ProductTypeFilterID = Localization.ParseNativeInt(ddTypes.SelectedValue); ManufacturerFilterID = 0; DistributorFilterID = 0; GenreFilterID = 0; VectorFilterID = 0; AffiliateFilterID = CommonLogic.QueryStringUSInt("EntityFilterID"); CustomerLevelFilterID = 0; _entityId = AffiliateFilterID; _entityName = ENCleaned; } if (ENCleaned == "CUSTOMERLEVEL") { CategoryFilterID = 0; SectionFilterID = 0; ProductTypeFilterID = Localization.ParseNativeInt(ddTypes.SelectedValue); ManufacturerFilterID = 0; DistributorFilterID = 0; GenreFilterID = 0; VectorFilterID = 0; AffiliateFilterID = 0; CustomerLevelFilterID = CommonLogic.QueryStringUSInt("EntityFilterID"); _entityId = CustomerLevelFilterID; _entityName = ENCleaned; } // end kludge //search if (SearchFor.Length == 0) { SearchFor = txtSearch.Text; ThisCustomer.ThisCustomerSession.SetVal("ProductsSearch", txtSearch.Text); } //Node filter string Index = ""; for (int i = 0; i < treeMain.Nodes.Count; i++) { if (treeMain.Nodes[i].Selected) { Index = treeMain.Nodes[i].Value; ThisCustomer.ThisCustomerSession.SetVal("ProductsTree", treeMain.Nodes[i].Value); break; } } //Type filter string typepName = ddTypes.SelectedValue; ThisCustomer.ThisCustomerSession.SetVal("ProductsType", typepName); ThisCustomer.ThisCustomerSession.SetVal("ProductsSort", ViewState["Sort"].ToString()); ThisCustomer.ThisCustomerSession.SetVal("ProductsOrder", ViewState["SortOrder"].ToString()); //remember page if (ThisCustomer.ThisCustomerSession.SessionNativeInt("ProductsPage") > 0) { gMain.PageIndex = ThisCustomer.ThisCustomerSession.SessionNativeInt("ProductsPage"); } ProductCollection products = new ProductCollection(); products.CategoryID = CategoryFilterID; products.SectionID = SectionFilterID; products.ManufacturerID = ManufacturerFilterID; products.DistributorID = DistributorFilterID; products.GenreID = GenreFilterID; products.VectorID = VectorFilterID; products.AffiliateID = AffiliateFilterID; products.ProductTypeID = ProductTypeFilterID; products.PublishedOnly = false; products.SearchDescriptionAndSummaryFields = false; products.SearchMatch = SearchFor; if (!Index.Equals("All")) { products.SearchIndex = Index; } products.SortBy = ViewState["Sort"].ToString(); products.SortOrder = ViewState["SortOrder"].ToString(); DataSet dsProducts = products.LoadFromDBEntity(); //build grid buildGridData(dsProducts); ((TextBox)Form.FindControl("txtSearch")).Text = SearchFor; }
//public static void FedExShowShipmentRateDetails(RatedShipmentDetail shipmentDetail, Person shipto, ProductCollection cart) public static double FedExRate(RatedShipmentDetail shipmentDetail, Person shipto, ProductCollection cart) { double temp = 0; if (shipmentDetail == null) { return(-1); //***EAC something wrong? } if (shipmentDetail.ShipmentRateDetail == null) { return(-1); //***EAC something wrong? } ShipmentRateDetail rateDetail = shipmentDetail.ShipmentRateDetail; FedExNoelWrite("--- Shipment Rate Detail ---"); // FedExNoelWrite("RateType: " + rateDetail.RateType); if (rateDetail.TotalBillingWeight != null) { FedExNoelWrite("Total Billing Weight: " + rateDetail.TotalBillingWeight.Value + " " + shipmentDetail.ShipmentRateDetail.TotalBillingWeight.Units); } if (rateDetail.TotalBaseCharge != null) { FedExNoelWrite("Total Base Charge: " + rateDetail.TotalBaseCharge.Amount + " " + rateDetail.TotalBaseCharge.Currency); } if (rateDetail.TotalFreightDiscounts != null) { FedExNoelWrite("Total Freight Discounts: " + rateDetail.TotalFreightDiscounts.Amount + " " + rateDetail.TotalFreightDiscounts.Currency); } if (rateDetail.TotalSurcharges != null) { FedExNoelWrite("Total Surcharges: " + rateDetail.TotalSurcharges.Amount + " " + rateDetail.TotalSurcharges.Currency); } if (rateDetail.Surcharges != null) { // Individual surcharge for each package foreach (Surcharge surcharge in rateDetail.Surcharges) { FedExNoelWrite(" surcharge " + surcharge.SurchargeType + " " + surcharge.Amount.Amount + " " + surcharge.Amount.Currency); } } if (rateDetail.TotalNetCharge != null) { FedExNoelWrite("Total Net Charge: " + rateDetail.TotalNetCharge.Amount + " " + rateDetail.TotalNetCharge.Currency); temp = (double)rateDetail.TotalNetCharge.Amount; } return(temp); }
public static void FedExSetShipmentDetails(RateRequest request, Person shipto, ProductCollection cart) { request.RequestedShipment = new RequestedShipment(); request.RequestedShipment.ShipTimestamp = DateTime.Now; // Shipping date and time request.RequestedShipment.ShipTimestampSpecified = true; request.RequestedShipment.DropoffType = DropoffType.REGULAR_PICKUP; //Drop off types are BUSINESS_SERVICE_CENTER, DROP_BOX, REGULAR_PICKUP, REQUEST_COURIER, STATION request.RequestedShipment.ServiceType = (ServiceType)Enum.Parse(typeof(ServiceType), DAL2.DAL.GetShippingMethodValuebyID(cart.ShipMethod)); // Service types are STANDARD_OVERNIGHT, PRIORITY_OVERNIGHT, FEDEX_GROUND ... request.RequestedShipment.ServiceTypeSpecified = true; request.RequestedShipment.PackagingType = PackagingType.YOUR_PACKAGING; // Packaging type FEDEX_BOK, FEDEX_PAK, FEDEX_TUBE, YOUR_PACKAGING, ... request.RequestedShipment.PackagingTypeSpecified = true; // FedExSetOrigin(request, shipto, cart); // FedExSetDestination(request, shipto, cart); // FedExSetPackageLineItems(request, shipto, cart); // //request.RequestedShipment.TotalInsuredValue = new Money(); //request.RequestedShipment.TotalInsuredValue.Amount = 100; //request.RequestedShipment.TotalInsuredValue.Currency = "USD"; // request.RequestedShipment.RateRequestTypes = new RateRequestType[1]; request.RequestedShipment.RateRequestTypes[0] = RateRequestType.LIST; //request.RequestedShipment.RateRequestTypes[1] = RateRequestType.LIST; request.RequestedShipment.PackageCount = boxcount.ToString(); }
/// <summary> /// Gets a list of update categories by searching for the guids specified in the config /// </summary> /// <param name="server"> /// wsus server connection /// </param> /// <param name="products"> /// list of product guids from config /// </param> /// <returns> /// collection of update categories /// </returns> private static UpdateCategoryCollection GetUpdateCategoryCollection( IUpdateServer server, ProductCollection products) { if (products == null) { throw new ArgumentNullException("products"); } if (products.Count < 1) { throw new ArgumentException("products has no product items."); } var result = new UpdateCategoryCollection(); foreach (Product product in products) { IUpdateCategory category = server.GetUpdateCategory(product.Guid); result.Add(category); } return result; }
protected void Page_Load(object sender, EventArgs e) { //Some checks - We need a good confid if (Request.QueryString["confid"] == null) { Utils.ResetSessions(); Response.Redirect("default.aspx?redirect=cart", true); } else { strConfId = Request.QueryString["confid"].ToString(); } if (strConfId.Length > 4 || strConfId == "") //potentially an intrusion { Utils.ResetSessions(); Response.Redirect("default.aspx?redirect=cart", true); } //End of checks ImgBtnContinueSearch.Attributes.Add("onmousedown", "this.src='images/continuered_on.jpg'"); ImgBtnContinueSearch.Attributes.Add("onmouseup", "this.src='images/continuered_off.jpg'"); ImgBtnCancelOrder.Attributes.Add("onmousedown", "this.src='images/cancel_on.jpg'"); ImgBtnCancelOrder.Attributes.Add("onmouseup", "this.src='images/cancel_off.jpg'"); ImgBtnCheckOut.Attributes.Add("onmousedown", "this.src='images/checkout_on.jpg'"); ImgBtnCheckOut.Attributes.Add("onmouseup", "this.src='images/checkout_off.jpg'"); //***EAC Hide buttons or not...Better to do on PageLoad for each page than in Master.cs! Master.FindControl("btnViewCart").Visible = false; //Master.FindControl("btnSearchOther").Visible = false; Master.FindControl("btnFinish").Visible = false; Master.FindControl("lblFreePubsInfo").Visible = false; //Check whether the conference is domestic or international if (Session["KIOSK_ShipLocation"] != null) { if (Session["KIOSK_ShipLocation"].ToString().Length > 0) { if (string.Compare(Session["KIOSK_ShipLocation"].ToString(), "Domestic", true) == 0) { hdnTotalLimit.Value = ConfigurationManager.AppSettings["DomesticOrderLimit"]; } else if (string.Compare(Session["KIOSK_ShipLocation"].ToString(), "International", true) == 0) { //hdnTotalLimit.Value = ConfigurationManager.AppSettings["InternationalOrderLimit"]; hdnTotalLimit.Value = PubEnt.DAL.DAL.GetIntl_MaxOrder(int.Parse(strConfId)).ToString(); } } } if (!IsPostBack) { #region dummydata2--remove before going live if (Request.QueryString["debug"] == "yes") { Session["KIOSK_Pubs"] = "4236,1095,1169"; Session["KIOSK_Qtys"] = "1,14,1"; Session["KIOSK_Urls"] = "34,47,110,116,117,118,119,120,121,122,123,124,127,128,129,130,131"; Session["KIOSK_ShipLocation"] = "Domestic"; } #endregion this.shoppingcart = null; //destroy cart if it exists this.shoppingcart = new ProductCollection(); //***EAC Parse the KIOSK_Pubs and KIOSK_qtys..assume they have same dimensions string[] pubs = Session["KIOSK_Pubs"].ToString().Split(new Char[] { ',' }); string[] qtys = Session["KIOSK_Qtys"].ToString().Split(new Char[] { ',' }); for (var i = 0; i < pubs.Length; i++) { if (pubs[i].Trim() != "") { int pubid = Int32.Parse(pubs[i]); Product p = Product.GetPubByPubID(pubid); p.NumQtyOrdered = Int32.Parse(qtys[i]); p.IsPhysicalItem = true; shoppingcart.Add(p); //TODO: BLL Add should differentiate physical from virtual items while deduping } } #region EAC Add ONLINE-only items to the shopping cart (20130226) //***EAC We are assuming Session_pubs and Session_Urls are mutually exclusive string[] urls = Session["KIOSK_Urls"].ToString().Split(new Char[] { ',' }); for (var i = 0; i < urls.Length; i++) { if (urls[i].Trim() != "") { int pubid = Int32.Parse(urls[i]); Product p = Product.GetPubByPubID(pubid); p.NumQtyOrdered = 1; p.IsPhysicalItem = false; shoppingcart.Add(p); //TODO: BLL Add should differentiate physical from virtual items while deduping } } #endregion //--- Sorting the publication collection by long title this.shoppingcart.Sort(ProductCollection.ProductFields.LongTitle, true); grdViewItems.DataSource = this.shoppingcart; grdViewItems.DataBind(); //Add client code //ImgBtnCancelOrder.Attributes.Add("onclick", "return fnAskBeforeCancelling(" + "'" + ImgBtnCancelOrder.ClientID + "')"); } //Check for cart object here if (this.shoppingcart == null) { //Display empty shopping cart Panel1.Visible = false; Panel2.Visible = true; ImgBtnCheckOut.Visible = false; } else { if (this.shoppingcart.Count > 0 && hdnTotalLimit.Value.Length > 0) { //***EAC at this point we have a usable cart lblTot.Text = this.shoppingcart.TotalQtyForShipping.ToString(); lblFreeRemaining.Text = (Int32.Parse(hdnTotalLimit.Value) - this.shoppingcart.TotalQtyForShipping).ToString(); Panel1.Visible = true; Panel2.Visible = false; if (Session["KIOSK_ShipLocation"].ToString() != "Domestic") { h3free.Visible = false; trFreeRemain.Visible = false; spanQty.Visible = false; trTotalItems.Visible = false; } } else//shopping cart is empty { Panel1.Visible = false; Panel2.Visible = true; ImgBtnCheckOut.Visible = false; } } }
public void Update(ProductCollection pt) { pt.ObjectState = ObjectState.Modified; _unitOfWork.Repository <ProductCollection>().Update(pt); }
protected void GetOrderInfo() { string strOrderSource = ""; string strOrderCreator = ""; Customer Cust = DAL.DAL.GetOrderCustInfobyOrderNum(OrderNum); lblInvoice.Text = OrderNum; if (Cust != null) { lblShipToName.Text = Cust.ShipToName; lblShipToOrg.Text = Cust.ShipToOrg; lblShipToAddr1.Text = Cust.ShipToAddr1; lblShipToAddr2.Text = Cust.ShipToAddr2; lblShipToZip5.Text = Cust.ShipToZip5; lblShipToZip4.Text = Cust.ShipToZip4; lblShipToCity.Text = Cust.ShipToCity; lblShipToState.Text = Cust.ShipToState; lblShipToPhone.Text = Cust.ShipToPhone; lblShipToEmail.Text = Cust.ShipToEmail; if (Cust.BillToName != "") { lblBillToName.Text = Cust.BillToName; } else { lblBillToName.Text = " "; } lblBillToOrg.Text = Cust.BillToOrg; lblBillToAddr1.Text = Cust.BillToAddr1; lblBillToAddr2.Text = Cust.BillToAddr2; lblBillToZip5.Text = Cust.BillToZip5; lblBillToZip4.Text = Cust.BillToZip4; lblBillToCity.Text = Cust.BillToCity; lblBillToState.Text = Cust.BillToState; lblBillToPhone.Text = Cust.BillToPhone; lblBillToEmail.Text = Cust.BillToEmail; } IDataReader dr = DAL.DAL.GetOrderStatus(OrderNum); try { using (dr) { if (dr.Read()) { if (dr["ORDERSOURCE"].ToString() == "IWEB") { strOrderSource = "NCIPL"; strOrderCreator = "NCIPL user"; } else if (dr["ORDERSOURCE"].ToString() == "IVPR") { strOrderSource = "VPR"; strOrderCreator = "VPR user"; } else if (dr["ORDERSOURCE"].ToString() == "IEOT") { strOrderSource = "NCIPLex"; strOrderCreator = "Exhibit Team"; } else if (dr["ORDERSOURCE"].ToString() == "ICIS") { strOrderSource = dr["ORDERMEDIA"].ToString(); strOrderCreator = dr["ORDERCREATOR"].ToString(); } lblOrderSource.Text = strOrderSource; lblOrderCreator.Text = strOrderCreator; lblTypeofCustomer.Text = dr["CUSTOMERTYPE"].ToString(); lblCreated.Text = dr["CREATEDATE"].ToString(); if (dr["MethodDisplay"].ToString() == "") { lblShipMethod.Text = "USPS"; } else { lblShipMethod.Text = dr["MethodDisplay"].ToString(); } //---- Current Logic /* * if (dr["DOWNLOAD"].ToString() == "Y") * { * lblDownload.Text = "Yes"; * * if (dr["TERMCODE"].ToString() != "B") * { * if (dr["PACKSLIP"].ToString() != "") * { * lblShipped.Text = "Shipped - " + dr["DATE_SHIP"].ToString(); * * if (dr["TRACKTRACE"].ToString() != "") * { * lblTracking.Text = dr["TRACKTRACE"].ToString(); * } * else * { * lblTracking.Text = ""; * } * } * else * { * lblShipped.Text = "Pending"; * } * } * else * { * lblShipped.Text = "Backorder"; * } * } * else * { * lblDownload.Text = "No"; * }*/ //--- New Logic 11/05/2012 if (dr["TERMCODE"].ToString() == "B") { lblShipped.Text = "Not Processed"; lblDownload.Text = "No"; } else if (dr["TERMCODE"].ToString() == "R" || dr["TERMCODE"].ToString() == "P") { lblShipped.Text = "Held – Under Review"; lblDownload.Text = "No"; } else if (dr["TERMCODE"].ToString() == "G") { lblShipped.Text = "Pending"; if (dr["DOWNLOAD"].ToString() == "Y") { lblDownload.Text = "Yes"; } else { lblDownload.Text = "No"; } } else { if (dr["TERMCODE"].ToString() == "" && dr["PACKSLIP"].ToString() == "") { lblShipped.Text = "Pending"; if (dr["DOWNLOAD"].ToString() == "Y") { lblDownload.Text = "Yes"; } else { lblDownload.Text = "No"; } } else { if (dr["DOWNLOAD"].ToString() == "Y") { lblDownload.Text = "Yes"; } else { lblDownload.Text = "No"; } if (dr["PACKSLIP"].ToString() != "") { lblShipped.Text = "Shipped - " + dr["DATE_SHIP"].ToString(); if (dr["TRACKTRACE"].ToString() != "") { lblTracking.Text = dr["TRACKTRACE"].ToString(); } else { lblTracking.Text = ""; } } } } //--------------------------------------------------------------------------------- } } } catch (Exception ECREAx) { //TO DO: log any error if (!dr.IsClosed) { dr.Close(); } } ProductCollection col = DAL.DAL.GetHistOrderDetail(OrderNum); grdViewItems.DataSource = col; grdViewItems.DataBind(); }
public void Delete(ProductCollection pt) { _unitOfWork.Repository <ProductCollection>().Delete(pt); }
public ProductCollection Create(ProductCollection pt) { pt.ObjectState = ObjectState.Added; _unitOfWork.Repository <ProductCollection>().Insert(pt); return(pt); }
public ProductCollection Add(ProductCollection pt) { _unitOfWork.Repository <ProductCollection>().Insert(pt); return(pt); }
public ProductPage(ProductCollection collection) { InitializeComponent(); this.BindingContext = new ProductsViewModel(collection); }
protected void BindData() { StringBuilder allowedTokensString = new StringBuilder(); string[] allowedTokens = Pricelist.GetListOfAllowedTokens(); for (int i = 0; i < allowedTokens.Length; i++) { string token = allowedTokens[i]; allowedTokensString.Append(token); if (i != allowedTokens.Length - 1) { allowedTokensString.Append(", "); } } this.lblAllowedTokens.Text = allowedTokensString.ToString(); Pricelist pricelist = ProductManager.GetPricelistByID(this.PricelistID); if (pricelist != null) { this.txtAdminNotes.Text = pricelist.AdminNotes; this.txtBody.Text = pricelist.Body; this.txtCacheTime.Value = pricelist.CacheTime; this.txtDescription.Text = pricelist.Description; this.txtDisplayName.Text = pricelist.DisplayName; this.txtFooter.Text = pricelist.Footer; this.txtHeader.Text = pricelist.Header; this.txtPricelistGuid.Text = pricelist.PricelistGuid; this.txtShortName.Text = pricelist.ShortName; CommonHelper.SelectListItem(this.ddlExportMode, pricelist.ExportModeID); CommonHelper.SelectListItem(this.ddlExportType, pricelist.ExportTypeID); CommonHelper.SelectListItem(this.ddlPriceAdjustmentType, pricelist.PriceAdjustmentTypeID); CommonHelper.SelectListItem(this.ddlAffiliate, pricelist.AffiliateID); this.chkOverrideIndivAdjustment.Checked = pricelist.OverrideIndivAdjustment; this.txtPriceAdjustment.Value = pricelist.PriceAdjustment; this.ddlFormatLocalization.SelectedValue = pricelist.FormatLocalization; ProductVariantCollection productVariants = new ProductVariantCollection(); ProductCollection products = ProductManager.GetAllProducts(); foreach (Product product in products) { productVariants.AddRange(product.ProductVariants); } if (productVariants.Count > 0) { gvProductVariants.DataSource = productVariants; gvProductVariants.DataBind(); } } else { ddlFormatLocalization.SelectedValue = System.Globalization.CultureInfo.CurrentCulture.IetfLanguageTag; ProductVariantCollection productVariants = new ProductVariantCollection(); ProductCollection products = ProductManager.GetAllProducts(); foreach (Product product in products) { productVariants.AddRange(product.ProductVariants); } if (productVariants.Count > 0) { gvProductVariants.DataSource = productVariants; gvProductVariants.DataBind(); } } }
public ProductCollection GetProductCollection() { return(ProductCollection.GetFromFileAsync(Path.Combine(_path, "releases-index.json"), false).Result); }
public void GetEventsStartDate() { DateTime startTime = DateTime.Now.AddMonths(-1); AtomFeed atomFeed = new AtomFeed(null, 1, 100000, false, false, null, 11); // ATOM LOGIN. Assert.AreEqual(true, atomFeed.Login(TestSettings.WinQualUserName, TestSettings.WinQualPassword)); // ATOM GetProducts. AtomProductCollection atomProducts = atomFeed.GetProducts(); // WERAPI Login. Login login = new Login(TestSettings.WinQualUserName, TestSettings.WinQualPassword); login.Validate(); // WERAPI GetProducts. ProductCollection apiProducts = Product.GetProducts(ref login); Assert.AreEqual(atomProducts.Count, apiProducts.Count); bool eventListsDifferent = false; foreach (AtomProduct atomProduct in atomProducts) { // ATOM GetFiles. AtomFileCollection atomFiles = atomFeed.GetFiles(atomProduct); // API GetFiles Product apiProduct = Utils.FindProduct(apiProducts, atomProduct.Product.Id); ApplicationFileCollection apiFiles = apiProduct.GetApplicationFiles(ref login); Assert.AreEqual(atomFiles.Count, apiFiles.Count); foreach (AtomFile atomFile in atomFiles) { ApplicationFile apiFile = Utils.FindFile(apiFiles, atomFile.File.Id); // ATOM GetEvents. StackHashEventCollection atomStackHashEvents = Utils.GetEventsAtom(atomFeed, atomFile, startTime); StackHashEventCollection atomStackHashEventsNoTime = Utils.GetEventsAtom(atomFeed, atomFile); if (atomStackHashEvents.Count != atomStackHashEventsNoTime.Count) { eventListsDifferent = true; } // WERAPI GetEvents. List <Event> rawApiEvents; StackHashEventCollection apiStackHashEvents = Utils.GetEventsApi(ref login, apiFile, out rawApiEvents, startTime); Assert.AreEqual(apiStackHashEvents.Count, atomStackHashEvents.Count); foreach (StackHashEvent stackHashEvent in atomStackHashEvents) { // Find the equivalent event in the api file list. StackHashEvent apiEvent = apiStackHashEvents.FindEvent(stackHashEvent.Id, stackHashEvent.EventTypeName); Assert.AreNotEqual(null, apiEvent); Assert.AreEqual(true, stackHashEvent.CompareTo(apiEvent) == 0); } } } Assert.AreEqual(true, eventListsDifferent); }
public static void FedExSetPackageLineItems(RateRequest request, Person shipto, ProductCollection cart) { double MaxWeightPerBox = Double.Parse(ConfigurationManager.AppSettings["MaxWeightPerBox"]); boxcount = (int)(cart.TotalWeight / MaxWeightPerBox) + 1; request.RequestedShipment.RequestedPackageLineItems = new RequestedPackageLineItem[boxcount]; for (int i = 0; i < boxcount; i++) { request.RequestedShipment.RequestedPackageLineItems[i] = new RequestedPackageLineItem(); request.RequestedShipment.RequestedPackageLineItems[i].SequenceNumber = (i + 1).ToString(); // package sequence number request.RequestedShipment.RequestedPackageLineItems[i].GroupPackageCount = "1"; // package weight request.RequestedShipment.RequestedPackageLineItems[i].Weight = new Weight(); request.RequestedShipment.RequestedPackageLineItems[i].Weight.Units = WeightUnits.LB; if (i == (boxcount - 1)) //last box { request.RequestedShipment.RequestedPackageLineItems[i].Weight.Value = (decimal)((cart.TotalWeight - (i * MaxWeightPerBox)) * 1.1); //plus 10% } else { request.RequestedShipment.RequestedPackageLineItems[i].Weight.Value = (decimal)(MaxWeightPerBox * 1.1); //plus 10% } // package dimensions //***EAC per Andy's instructions request.RequestedShipment.RequestedPackageLineItems[i].Dimensions = new Dimensions(); request.RequestedShipment.RequestedPackageLineItems[i].Dimensions.Length = "18"; //per Andy request.RequestedShipment.RequestedPackageLineItems[i].Dimensions.Width = "12"; //per Andy request.RequestedShipment.RequestedPackageLineItems[i].Dimensions.Height = "10"; //per Andy request.RequestedShipment.RequestedPackageLineItems[i].Dimensions.Units = LinearUnits.IN; } }
public ActionResult Post(ProductCollection vm) { ProductCollection pt = vm; if (ModelState.IsValid) { if (vm.ProductCollectionId <= 0) { pt.CreatedDate = DateTime.Now; pt.ModifiedDate = DateTime.Now; pt.CreatedBy = User.Identity.Name; pt.ModifiedBy = User.Identity.Name; pt.ObjectState = Model.ObjectState.Added; _ProductCollectionService.Create(pt); int RefDocTypeId = new DocumentTypeService(_unitOfWork).Find(MasterDocTypeConstants.ProductCollection).DocumentTypeId; try { _unitOfWork.Save(); } catch (Exception ex) { string message = _exception.HandleException(ex); ModelState.AddModelError("", message); ViewBag.id = vm.ProductTypeId; ViewBag.Name = new ProductTypeService(_unitOfWork).Find(vm.ProductTypeId).ProductTypeName; return(View("Create", vm)); } LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel { DocTypeId = RefDocTypeId, DocId = pt.ProductCollectionId, ActivityType = (int)ActivityTypeContants.Added, })); ViewBag.id = vm.ProductTypeId; ViewBag.Name = new ProductTypeService(_unitOfWork).Find(vm.ProductTypeId).ProductTypeName; return(RedirectToAction("Edit", new { id = pt.ProductCollectionId }).Success("Data saved successfully")); } else { List <LogTypeViewModel> LogList = new List <LogTypeViewModel>(); ProductCollection temp = _ProductCollectionService.Find(pt.ProductCollectionId); int RefDocTypeId = new DocumentTypeService(_unitOfWork).Find(MasterDocTypeConstants.ProductCollection).DocumentTypeId; ProductCollection ExRec = Mapper.Map <ProductCollection>(temp); temp.ProductCollectionName = pt.ProductCollectionName; temp.IsActive = pt.IsActive; temp.ModifiedDate = DateTime.Now; temp.ModifiedBy = User.Identity.Name; temp.ObjectState = Model.ObjectState.Modified; _ProductCollectionService.Update(temp); var ProcSeqHeader = (from p in db.ProcessSequenceHeader where p.ReferenceDocId == temp.ProductCollectionId && p.ReferenceDocTypeId == RefDocTypeId select p).FirstOrDefault(); if (ProcSeqHeader != null) { ProcSeqHeader.ProcessSequenceHeaderName = temp.ProductCollectionName + "-" + new DivisionService(_unitOfWork).Find((int)HttpContext.Session["DivisionId"]).DivisionName; } LogList.Add(new LogTypeViewModel { ExObj = ExRec, Obj = temp, }); XElement Modifications = new ModificationsCheckService().CheckChanges(LogList); try { _unitOfWork.Save(); } catch (Exception ex) { string message = _exception.HandleException(ex); ModelState.AddModelError("", message); ViewBag.id = pt.ProductTypeId; ViewBag.Name = new ProductTypeService(_unitOfWork).Find(pt.ProductTypeId).ProductTypeName; return(View("Create", pt)); } LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel { DocTypeId = RefDocTypeId, DocId = temp.ProductCollectionId, ActivityType = (int)ActivityTypeContants.Modified, xEModifications = Modifications, })); ViewBag.id = pt.ProductTypeId; ViewBag.Name = new ProductTypeService(_unitOfWork).Find(pt.ProductTypeId).ProductTypeName; return(RedirectToAction("Index", new { id = vm.ProductTypeId }).Success("Data saved successfully")); } } ViewBag.id = vm.ProductTypeId; ViewBag.Name = new ProductTypeService(_unitOfWork).Find(vm.ProductTypeId).ProductTypeName; return(View("Create", vm)); }
public ProductCollectionTest() { _sut = new ProductCollection(_productRepoMock.Object); }
private void UpdateProducts(bool forceResynchronize, IErrorIndex errorIndex, ProductCollection products, bool getEvents, bool getCabs) { // Product -1 is the special product ID that indicates when the last sync of products // was complete. DateTime lastProductPullDate = errorIndex.GetLastSyncTimeLocal(-1); if (forceResynchronize) { lastProductPullDate = new DateTime(0, DateTimeKind.Local); } // Add the products first. foreach (Product product in products) { if (m_AbortRequested) { throw new OperationCanceledException("Abort requested during Win Qual synchronize"); } m_SyncProgress.ProductId = product.ID; StackHashProduct stackHashProduct = ObjectConversion.ConvertProduct(product); // Check the date created. If it is greater than the last pull date then // this is a new product so add a product record. if (product.DateCreatedLocal > lastProductPullDate) { errorIndex.AddProduct(stackHashProduct); } else if (product.DateModifiedLocal > lastProductPullDate) { // Update the product information if product last modified date is greater than // the last pull date. errorIndex.AddProduct(stackHashProduct); } else { // Check if the file exists. If not then add it. if (!errorIndex.ProductExists(stackHashProduct)) { errorIndex.AddProduct(stackHashProduct); } } if (getEvents && !isExcludedProduct(stackHashProduct.Id)) { // Get the last date that this product was synchronized on WinQual. DateTime lastPullDate = errorIndex.GetLastSyncTimeLocal(stackHashProduct.Id); if (forceResynchronize) { lastPullDate = new DateTime(0, DateTimeKind.Local); } UpdateFiles(lastPullDate, errorIndex, product, stackHashProduct, getCabs); if (getCabs) { onProgress(WinQualProgressType.ProductCabsUpdated, stackHashProduct); } else { onProgress(WinQualProgressType.ProductEventsUpdated, stackHashProduct); } if (getCabs) { // Completed getting all events and cabs for this product. errorIndex.SetLastSyncTimeLocal(stackHashProduct.Id, DateTime.Now); } } } errorIndex.SetLastSyncTimeLocal(-1, DateTime.Now); }
/// <summary> /// Generates the feed data for given products /// </summary> /// <param name="products">The products to generate feed for</param> /// <returns>Feed data generated</returns> protected override string GetFeedData(ProductCollection products) { //write header row StringWriter feedWriter = new StringWriter(); StringBuilder feedLine; string storeUrl = Token.Instance.Store.StoreUrl; storeUrl = storeUrl + (storeUrl.EndsWith("/") ? "" : "/"); string url, name, desc, price, imgurl, category, mpn, upc, manufacturer, stock, stockdesc, shiprate; foreach (Product product in products) { url = product.NavigateUrl; if (url.StartsWith("~/")) { url = url.Substring(2); } url = storeUrl + url; name = CleanupText(product.Name); desc = CleanupText(product.Summary); if (desc.Length > 1024) { desc = desc.Substring(0, 1024); } price = string.Format("{0:F2}", product.Price); imgurl = product.ImageUrl; if (!string.IsNullOrEmpty(imgurl) && !IsAbsoluteURL(imgurl)) { if (imgurl.StartsWith("~/")) { imgurl = imgurl.Substring(2); } imgurl = storeUrl + imgurl; } if (product.Categories.Count > 0) { List <CatalogPathNode> path = CatalogDataSource.GetPath(product.Categories[0], false); category = ""; foreach (CatalogPathNode item in path) { if (item == null) { continue; } if (category.Length > 0) { category = category + "->" + CleanupText(item.Name); } else { category = CleanupText(item.Name); } } } else { category = "None"; } manufacturer = ""; if (product.Manufacturer != null) { manufacturer = CleanupText(product.Manufacturer.Name); } mpn = product.ModelNumber; if (product.InventoryMode == InventoryMode.Product) { stock = product.InStock > 0 ? "Y" : "N"; } // IF INVENTORY IS DISABLED OR INVENTORY MODE IS TRACK VARIANTS, ASSUME INVENTORY IS AVAILABLE else { stock = "Y"; } //TODO stockdesc = "New"; upc = this.IsUpcCode(product.Sku) ? product.Sku : string.Empty; shiprate = ""; feedLine = new StringBuilder(); feedLine.Append(mpn + "," + upc + ",\"" + manufacturer + "\",\"" + name + "\",\"" + desc + "\"," + price + "," + stock + "," + stockdesc + "," + url + "," + imgurl + ",\"" + category + "\"," + shiprate); feedWriter.WriteLine(feedLine.ToString()); } string returnData = feedWriter.ToString(); feedWriter.Close(); return(returnData); }
protected void chkReOrder_CheckedChanged(object sender, EventArgs e) { if (chkReOrder.Checked) { this.shoppingcart = null; //destroy cart if it exists this.shoppingcart = new ProductCollection(); ProductCollection colOrigOrder = DAL.DAL.GetOrigOrderDetail(OrderNum); /*foreach (GridViewRow item in grdViewItems.Rows) * { * TextBox txtQty = (TextBox)item.FindControl("txtQty"); * HiddenField hdnPubID = (HiddenField)item.FindControl("hdnPubID"); * * int pubid = Int32.Parse(hdnPubID.Value); * Product p = Product.GetCartPubByPubID(pubid); * p.NumQtyOrdered = Int32.Parse(txtQty.Text); * this.shoppingcart.Add(p); * * Session["NCIPL_Pubs"] = this.shoppingcart.Pubs; * Session["NCIPL_Qtys"] = this.shoppingcart.Qtys; * }*/ foreach (Product item in colOrigOrder) { //TextBox txtQty = (TextBox)item.FindControl("txtQty"); //HiddenField hdnPubID = (HiddenField)item.FindControl("hdnPubID"); int pubid = item.PubId; //Do not add to the cart if Pub is a Promotion Pub if (DAL.DAL.IsPromotionPub(pubid) == 0) { Product p = Product.GetCartPubByPubID(pubid); p.NumQtyOrdered = item.NumQtyOrdered; this.shoppingcart.Add(p); Session["NCIPL_Pubs"] = this.shoppingcart.Pubs; Session["NCIPL_Qtys"] = this.shoppingcart.Qtys; } } if (chkUseAddress4NewOrder.Checked) { } else { Session["SEARCHORDER_CUSTID"] = CustID; Customer Cust = DAL.DAL.GetOrderCustInfobyCustID(CustID); this.shipto = new Person(1, Cust.ShipToName, Cust.ShipToOrg, Cust.ShipToEmail, Cust.ShipToAddr1, Cust.ShipToAddr2, Cust.ShipToCity, Cust.ShipToState, Cust.ShipToZip5, Cust.ShipToZip4, Cust.ShipToPhone); this.billto = new Person(1, Cust.BillToName, Cust.BillToOrg, Cust.BillToEmail, Cust.BillToAddr1, Cust.BillToAddr2, Cust.BillToCity, Cust.BillToState, Cust.BillToZip5, Cust.BillToZip4, Cust.BillToPhone); } } else { Session["NCIPL_cart"] = null; //destroy Session["NCIPL_Pubs"] = null; //destroy Session["NCIPL_Qtys"] = null; //destroy if (chkUseAddress4NewOrder.Checked) { } else { Session["SEARCHORDER_CUSTID"] = null; //destroy Session["NCIPL_shipto"] = null; //destroy Session["NCIPL_billto"] = null; //destroy } } //Display the master page tabs GlobalUtils.Utils UtilMethod = new GlobalUtils.Utils(); if (Session["NCIPL_Pubs"] != null) { Master.LiteralText = UtilMethod.GetTabHtmlMarkUp(Session["NCIPL_Qtys"].ToString(), "cart"); } else { Master.LiteralText = UtilMethod.GetTabHtmlMarkUp("", "cart"); } UtilMethod = null; }
/// <summary> /// Generate froogle feed /// </summary> /// <param name="stream">Stream</param> public static void GenerateFeed(Stream stream) { const string googleBaseNamespace = "http://base.google.com/ns/1.0"; XmlWriterSettings settings = new XmlWriterSettings { Encoding = Encoding.UTF8 }; using (XmlWriter writer = XmlWriter.Create(stream, settings)) { writer.WriteStartDocument(); writer.WriteStartElement("rss"); writer.WriteAttributeString("version", "2.0"); writer.WriteAttributeString("xmlns", "g", null, googleBaseNamespace); writer.WriteStartElement("channel"); writer.WriteElementString("title", string.Format("{0} Google Base", SettingManager.StoreName)); writer.WriteElementString("link", "http://base.google.com/base/"); writer.WriteElementString("description", "Information about products"); ProductCollection products = ProductManager.GetAllProducts(false); foreach (Product product in products) { ProductVariantCollection productVariants = ProductManager.GetProductVariantsByProductID(product.ProductID, false); foreach (ProductVariant productVariant in productVariants) { writer.WriteStartElement("item"); writer.WriteElementString("link", SEOHelper.GetProductURL(product)); writer.WriteElementString("title", productVariant.FullProductName); writer.WriteStartElement("description"); string description = productVariant.Description; if (String.IsNullOrEmpty(description)) { description = product.FullDescription; } if (String.IsNullOrEmpty(description)) { description = product.ShortDescription; } if (String.IsNullOrEmpty(description)) { description = product.Name; } writer.WriteCData(description); writer.WriteEndElement(); // description writer.WriteStartElement("g", "brand", googleBaseNamespace); writer.WriteFullEndElement(); // g:brand writer.WriteElementString("g", "condition", googleBaseNamespace, "new"); writer.WriteElementString("g", "expiration_date", googleBaseNamespace, DateTime.Now.AddDays(30).ToString("yyyy-MM-dd")); writer.WriteElementString("g", "id", googleBaseNamespace, productVariant.ProductVariantID.ToString()); string imageUrl = string.Empty; ProductPictureCollection productPictures = product.ProductPictures; if (productPictures.Count > 0) { imageUrl = PictureManager.GetPictureUrl(productPictures[0].Picture, SettingManager.GetSettingValueInteger("Media.Product.ThumbnailImageSize"), true); } writer.WriteElementString("g", "image_link", googleBaseNamespace, imageUrl); decimal price = productVariant.Price; writer.WriteElementString("g", "price", googleBaseNamespace, price.ToString(new CultureInfo("en-US", false).NumberFormat)); writer.WriteStartElement("g", "product_type", googleBaseNamespace); writer.WriteFullEndElement(); // g:brand //if (productVariant.Weight != decimal.Zero) //{ // writer.WriteElementString("g", "weight", googleBaseNamespace, string.Format(CultureInfo.InvariantCulture, "{0} {1}", productVariant.Weight.ToString(new CultureInfo("en-US", false).NumberFormat), MeasureManager.BaseWeightIn.SystemKeyword)); //} writer.WriteEndElement(); // item } } writer.WriteEndElement(); // channel writer.WriteEndElement(); // rss writer.WriteEndDocument(); } }
public void _0001_Test() { SupplierCollection suppliers = new SupplierCollection(); suppliers.Add(new SuplierItem(1, "Lomex")); suppliers.Add(new SuplierItem(2, "TME")); suppliers.Add(new SuplierItem(3, "Farnell")); suppliers.Add(new SuplierItem(4, "CBA")); ProductCollection products = new ProductCollection(); products.Add(new ProductItem(1, "1N4148", "Dióda", 1)); products.Add(new ProductItem(2, "BC128", "Tranzisztor", 1)); products.Add(new ProductItem(3, "AT90CAN128", "Processzor", 2)); products.Add(new ProductItem(4, "ESD szönyeg", "ESD Védelem", 2)); //products.Add(new ProductItem(5, "Henkel On", "Forrasztás", 3)); //products.Add(new ProductItem(6, "Weller WP szürő", "Egészség", 3)); //products.Add(new ProductItem(7, "Banán", "Gyümölcs", 2)); /*Data SET*/ DataSet dataSet = new DataSet("DemoDataSet"); /*Suppliers*/ /*SupplierId-PK,SupplierName*/ DataTable suppliersDt = ToDataTable(suppliers, "Suppliers"); suppliersDt.PrimaryKey = new DataColumn[] { suppliersDt.Columns["SupplierId"] }; dataSet.Tables.Add(suppliersDt); /*Products*/ /*ProductId-PK, ProductName, Description, SupplierId*/ DataTable productsDt = ToDataTable(products, "Products"); suppliersDt.PrimaryKey = new DataColumn[] { suppliersDt.Columns["ProductId"] }; DataColumn supplierNameColumn = new DataColumn("SupplierName", typeof(string)); productsDt.Columns.Add(supplierNameColumn); dataSet.Tables.Add(productsDt); /* */ DataRelation productsSuppliersRelation = dataSet.Relations.Add("ProductSuppliers", dataSet.Tables["Suppliers"].Columns["SupplierId"], dataSet.Tables["Products"].Columns["SupplierId"], true); dataSet.AcceptChanges(); DataGrid dg = new DataGrid(); dg.SetDataBinding(dataSet, "Products"); var form = new Form2(); form.dataGridView1.DataSource = dataSet; form.dataGridView1.DataMember = "Products"; form.dataGridView2.DataSource = dataSet; form.dataGridView2.DataMember = "Suppliers"; Application.Run(form); }
/// <summary> /// 条件查询产品 /// </summary> /// <param name="istop">置顶</param> /// <param name="iscommend">推荐</param> /// <returns>ProductCollection 包含条件查询的记录</returns> public static ProductCollection GetList(bool istop, bool iscommend) { bool bIsTop = false; bool bIsCommend = false; if (istop) { bIsTop = istop; } if (iscommend) { bIsCommend = iscommend; } ProductCollection list = null; string sql = "select * from t_product where IsTop=?IsTop and IsCommend=?IsCommend"; MySqlParameter[] parms = { new MySqlParameter("?IsTop",MySqlDbType.Bit), new MySqlParameter("?IsCommend",MySqlDbType.Bit) }; parms[0].Value = bIsTop; parms[1].Value = bIsCommend; MySqlDataReader reader = DbHelper.ExecuteDataReader(sql, parms); if (reader.HasRows) { list = new ProductCollection(); while (reader.Read()) { list.Add(FillDataRecord(reader)); } } reader.Close(); return list; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { /////////////////////////////fill the product boxes/////////////////////////////////// ProductCollection products = new ProductCollection(); products.ReadList(); //////BOX1///// lbl_title1.Text = products[0].Brand + "-" + products[0].ProductName; lbl_id1.Text = products[0].ProductId; img_product1.ImageUrl = "./Images/Products/" + products[0].Discount; lbl_price1.Text = "قیمت: " + products[0].Price + " تومان"; //////// //////BOX2///// lbl_title2.Text = products[1].Brand + "-" + products[1].ProductName; lbl_id2.Text = products[1].ProductId; img_product2.ImageUrl = "./Images/Products/" + products[1].Discount; lbl_price2.Text = "قیمت: " + products[1].Price + " تومان"; //////// //////BOX3///// lbl_title3.Text = products[2].Brand + "-" + products[2].ProductName; lbl_id3.Text = products[2].ProductId; img_product3.ImageUrl = "./Images/Products/" + products[2].Discount; lbl_price3.Text = "قیمت: " + products[2].Price + " تومان"; //////// //////BOX4///// lbl_title4.Text = products[3].Brand + "-" + products[3].ProductName; lbl_id4.Text = products[3].ProductId; img_product4.ImageUrl = "./Images/Products/" + products[3].Discount; lbl_price4.Text = "قیمت: " + products[3].Price + " تومان"; //////// //////BOX5///// lbl_title5.Text = products[4].Brand + "-" + products[4].ProductName; lbl_id5.Text = products[4].ProductId; img_product5.ImageUrl = "./Images/Products/" + products[4].Discount; lbl_price5.Text = "قیمت: " + products[4].Price + " تومان"; //////// //////BOX6///// lbl_title6.Text = products[5].Brand + "-" + products[5].ProductName; lbl_id6.Text = products[5].ProductId; img_product6.ImageUrl = "./Images/Products/" + products[5].Discount; lbl_price6.Text = "قیمت: " + products[5].Price + " تومان"; //////// //////BOX7///// lbl_title7.Text = products[6].Brand + "-" + products[6].ProductName; lbl_id7.Text = products[6].ProductId; img_product7.ImageUrl = "./Images/Products/" + products[6].Discount; lbl_price7.Text = "قیمت: " + products[6].Price + " تومان"; //////// //////BOX8///// lbl_title8.Text = products[7].Brand + "-" + products[7].ProductName; lbl_id8.Text = products[7].ProductId; img_product8.ImageUrl = "./Images/Products/" + products[7].Discount; lbl_price8.Text = "قیمت: " + products[7].Price + " تومان"; //////// //////BOX9///// lbl_title9.Text = products[8].Brand + "-" + products[8].ProductName; lbl_id9.Text = products[8].ProductId; img_product9.ImageUrl = "./Images/Products/" + products[8].Discount; lbl_price9.Text = "قیمت: " + products[8].Price + " تومان"; //////// //////BOX10///// lbl_title10.Text = products[9].Brand + "-" + products[9].ProductName; lbl_id10.Text = products[9].ProductId; img_product10.ImageUrl = "./Images/Products/" + products[9].Discount; lbl_price10.Text = "قیمت: " + products[9].Price + " تومان"; //////// } }
/// <summary> /// 查询产品 所有数据 /// </summary> /// <param name="pc_id"></param> /// <param name="startRowIndex"></param> /// <param name="maximumRows"></param> /// <returns>ProductCollection 包含所有记录</returns> public static ProductCollection GetList(int pc_id, int startRowIndex, int maximumRows) { int iStartRowIndex = -1; int iMaximumRows = -1; if (startRowIndex > 0 && maximumRows > 0) { iStartRowIndex = startRowIndex; iMaximumRows = maximumRows; } ProductCollection list = new ProductCollection(); string sql = @"SELECT prod_id, prod_name, prod_number, prod_price, prod_image, prod_content, prod_date, prod_click, istop, iscommend, pc_id FROM ( select *, (select ifnull(sum(1) + 1, 1) from t_product where (?pc_id=0 or pc_id=?pc_id) and prod_id > a.prod_id) as row_rank from t_product a where ?pc_id=0 or pc_id in (select pc_id from (select pc_id from t_productclass where pc_id=?pc_id union all select p.pc_id from t_productclass p inner join (select pc_id from t_productclass where pc_id=?pc_id) t on p.parent_id = t.pc_id) as temp) order by prod_id desc ) as ProductWithRowNumbers where ((row_rank between ?start_row_index AND ?start_row_index + ?maximum_rows - 1) OR ?start_row_index = -1 OR ?maximum_rows = -1);"; MySqlParameter[] parms = { new MySqlParameter("?pc_id",MySqlDbType.Int32), new MySqlParameter("?start_row_index",MySqlDbType.Int32), new MySqlParameter("?maximum_rows",MySqlDbType.Int32) }; parms[0].Value = pc_id; parms[1].Value = iStartRowIndex; parms[2].Value = iMaximumRows; MySqlDataReader reader = DbHelper.ExecuteDataReader(sql, parms); if (reader.HasRows) { list = new ProductCollection(); while (reader.Read()) { list.Add(FillDataRecord(reader)); } } reader.Close(); return list; }
/// <summary> /// Generate the bootstrapper. /// </summary> /// <returns> Return true on success, false on failure.</returns> public override bool Execute() { if (Path == null) { Path = Util.GetDefaultPath(VisualStudioVersion); } var bootstrapperBuilder = new BootstrapperBuilder { Validate = Validate, Path = Path }; ProductCollection products = bootstrapperBuilder.Products; var settings = new BuildSettings { ApplicationFile = ApplicationFile, ApplicationName = ApplicationName, ApplicationRequiresElevation = ApplicationRequiresElevation, ApplicationUrl = ApplicationUrl, ComponentsLocation = ConvertStringToComponentsLocation(ComponentsLocation), ComponentsUrl = ComponentsUrl, CopyComponents = CopyComponents, Culture = Culture, FallbackCulture = FallbackCulture, OutputPath = OutputPath, SupportUrl = SupportUrl }; if (String.IsNullOrEmpty(settings.Culture) || settings.Culture == "*") { settings.Culture = settings.FallbackCulture; } if (BootstrapperItems != null) { // The bootstrapper items may not be in the correct order, because XMake saves // items in alphabetical order. So we will attempt to put items into the correct // order, according to the Products order in the search. To do this, we add all // the items we are told to build into a hashtable, then go through our products // in order, looking to see if the item is built. If it is, remove the item from // the hashtable. All remaining items in the table can not be built, so errors // will be issued. var items = new Dictionary <string, ITaskItem>(StringComparer.OrdinalIgnoreCase); foreach (ITaskItem bootstrapperItem in BootstrapperItems) { string installAttribute = bootstrapperItem.GetMetadata("Install"); if (String.IsNullOrEmpty(installAttribute) || Shared.ConversionUtilities.ConvertStringToBool(installAttribute)) { if (!items.ContainsKey(bootstrapperItem.ItemSpec)) { items.Add(bootstrapperItem.ItemSpec, bootstrapperItem); } else { Log.LogWarningWithCodeFromResources("GenerateBootstrapper.DuplicateItems", bootstrapperItem.ItemSpec); } } } foreach (Product product in products) { if (items.ContainsKey(product.ProductCode)) { settings.ProductBuilders.Add(product.ProductBuilder); items.Remove(product.ProductCode); } } foreach (ITaskItem bootstrapperItem in items.Values) { Log.LogWarningWithCodeFromResources("GenerateBootstrapper.ProductNotFound", bootstrapperItem.ItemSpec, bootstrapperBuilder.Path); } } BuildResults results = bootstrapperBuilder.Build(settings); BuildMessage[] messages = results.Messages; if (messages != null) { foreach (BuildMessage message in messages) { if (message.Severity == BuildMessageSeverity.Error) { Log.LogError(null, message.HelpCode, message.HelpKeyword, null, 0, 0, 0, 0, message.Message); } else if (message.Severity == BuildMessageSeverity.Warning) { Log.LogWarning(null, message.HelpCode, message.HelpKeyword, null, 0, 0, 0, 0, message.Message); } } } BootstrapperKeyFile = results.KeyFile; BootstrapperComponentFiles = results.ComponentFiles; return(results.Succeeded); }
public void Acc_Products_CollectionLoad2() { ProductCollection products = new ProductCollection().Load(); Assert.AreEqual(77, products.Count); }
protected void LoadBody() { ltBody.Text = "<form method=\"post\" action=\"entityBulkDownloadFiles.aspx?entityname=" + EntityName + "&EntityID=" + EntityID + "\">"; ltBody.Text += "<div style=\"width: 100%; border-top: solid 1px #d2d2d2; padding-top: 3px; margin-top: 5px;\">"; ltBody.Text += ("<input type=\"hidden\" name=\"EntityName\" value=\"" + EntityName + "\">\n"); ltBody.Text += ("<input type=\"hidden\" name=\"EntityID\" value=\"" + EntityID + "\">\n"); ProductCollection products = new ProductCollection(m_EntitySpecs.m_EntityName, EntityID); products.PageSize = 0; products.PageNum = 1; products.PublishedOnly = false; products.ReturnAllVariants = true; Int32 mappingCount = DB.GetSqlN("select count(*) as N from Product" + this.m_EntitySpecs.m_EntityName + " where " + m_EntitySpecs.m_EntityName + "Id = " + this.EntityID.ToString()); DataSet dsProducts = new DataSet(); if (mappingCount > 0) { dsProducts = products.LoadFromDB(); } int NumProducts = products.NumProducts; if (NumProducts > 1000) { ltBody.Text += ("<p><b>" + AppLogic.GetString("admin.common.ImportExcession", SkinID, LocaleSetting) + "</b></p>"); } else if (NumProducts > 0) { ltBody.Text += ("<script type=\"text/javascript\">\n"); ltBody.Text += ("function Form_Validator(theForm)\n"); ltBody.Text += ("{\n"); ltBody.Text += ("submitonce(theForm);\n"); ltBody.Text += ("return (true);\n"); ltBody.Text += ("}\n"); ltBody.Text += ("</script>\n"); ltBody.Text += ("<input type=\"hidden\" name=\"IsSubmit\" value=\"true\">\n"); ltBody.Text += ("<table border=\"0\" cellpadding=\"0\" border=\"0\" cellspacing=\"0\" width=\"100%\">\n"); ltBody.Text += ("<tr class=\"table-header\">\n"); ltBody.Text += ("<td><b>" + AppLogic.GetString("admin.common.ProductID", SkinID, LocaleSetting) + "</b></td>\n"); ltBody.Text += ("<td><b>" + AppLogic.GetString("admin.common.VariantID", SkinID, LocaleSetting) + "</b></td>\n"); ltBody.Text += ("<td><b>" + AppLogic.GetString("admin.common.ProductName", SkinID, LocaleSetting) + "</b></td>\n"); ltBody.Text += ("<td><b>" + AppLogic.GetString("admin.common.VariantName", SkinID, LocaleSetting) + "</b></td>\n"); ltBody.Text += ("<td align=\"left\"><b>" + AppLogic.GetString("admin.common.DownloadFile", SkinID, LocaleSetting) + "</b></td>\n"); ltBody.Text += ("</tr>\n"); int LastProductID = 0; int rowcount = dsProducts.Tables[0].Rows.Count; for (int i = 0; i < rowcount; i++) { DataRow row = dsProducts.Tables[0].Rows[i]; if (DB.RowFieldBool(row, "IsDownload")) { int ThisProductID = DB.RowFieldInt(row, "ProductID"); int ThisVariantID = DB.RowFieldInt(row, "VariantID"); if (i % 2 == 0) { ltBody.Text += ("<tr class=\"table-row2\">\n"); } else { ltBody.Text += ("<tr class=\"table-alternatingrow2\">\n"); } ltBody.Text += ("<td align=\"left\" valign=\"middle\">"); ltBody.Text += (ThisProductID.ToString()); ltBody.Text += ("</td>"); ltBody.Text += ("<td align=\"left\" valign=\"middle\">"); ltBody.Text += (ThisVariantID.ToString()); ltBody.Text += ("</td>"); ltBody.Text += ("<td align=\"left\" valign=\"middle\">"); bool showlinks = false; if (showlinks) { ltBody.Text += ("<a target=\"entityBody\" href=\"" + AppLogic.AdminLinkUrl("entityeditproducts.aspx") + "?iden=" + ThisProductID.ToString() + "&entityname=" + EntityName + "&entityid=" + EntityID.ToString() + "\">"); } ltBody.Text += (DB.RowFieldByLocale(row, "Name", cust.LocaleSetting)); if (showlinks) { ltBody.Text += ("</a>"); } ltBody.Text += ("</td>\n"); ltBody.Text += ("<td align=\"left\" valign=\"middle\">"); if (showlinks) { ltBody.Text += ("<a target=\"entityBody\" href=\"" + AppLogic.AdminLinkUrl("entityeditproductvariant.aspx") + "?iden=" + ThisProductID.ToString() + "&variantid=" + ThisVariantID.ToString() + "&entityname=" + EntityName + "&entityid=" + EntityID.ToString() + "\">"); } ltBody.Text += (DB.RowFieldByLocale(row, "VariantName", cust.LocaleSetting)); if (showlinks) { ltBody.Text += ("</a>"); } ltBody.Text += ("</td>\n"); ltBody.Text += ("<td align=\"left\" valign=\"middle\">"); ltBody.Text += ("<input maxLength=\"1000\" class=\"singleNormal\" onkeypress=\"javascript:return WebForm_FireDefaultButton(event, 'btnsubmit')\" name=\"DownloadLocation_" + ThisProductID.ToString() + "_" + ThisVariantID.ToString() + "\" value=\"" + DB.RowField(row, "DownloadLocation") + "\">\n"); ltBody.Text += ("</td>\n"); ltBody.Text += ("</tr>\n"); LastProductID = ThisProductID; } } if (LastProductID == 0) { ltBody.Text += ("</table>\n"); ltBody.Text += ("<p align=\"left\"><b>" + AppLogic.GetString("admin.common.NoDownloadProductsFound", SkinID, LocaleSetting) + "</b></p>"); } else { ltBody.Text += ("<tr><td colspan=\"5\" align=\"right\"><input type=\"submit\" id=\"btnsubmit\" value=\"" + AppLogic.GetString("admin.entityBulkDownloadFiles.DownloadUpdate", SkinID, LocaleSetting) + "\" name=\"Submit\" class=\"normalButtons\"></td></tr>\n"); ltBody.Text += ("</table>\n"); } } else { ltBody.Text += ("<p><b>" + AppLogic.GetString("admin.common.NoProductsFound", SkinID, LocaleSetting) + "</b></p>"); } dsProducts.Dispose(); products.Dispose(); ltBody.Text += ("</div>"); ltBody.Text += ("</form>"); }
public void _0001_Test() { SupplierCollection suppliers = new SupplierCollection(); suppliers.Add(new SuplierItem(1, "Lomex")); suppliers.Add(new SuplierItem(2, "TME")); suppliers.Add(new SuplierItem(3, "Farnell")); suppliers.Add(new SuplierItem(4, "CBA")); ProductCollection products = new ProductCollection(); products.Add(new ProductItem(1, "1N4148", "Dióda", 1)); products.Add(new ProductItem(2, "BC128", "Tranzisztor", 1)); products.Add(new ProductItem(3, "AT90CAN128", "Processzor", 2)); products.Add(new ProductItem(4, "ESD szönyeg", "ESD Védelem", 2)); //products.Add(new ProductItem(5, "Henkel On", "Forrasztás", 3)); //products.Add(new ProductItem(6, "Weller WP szürő", "Egészség", 3)); //products.Add(new ProductItem(7, "Banán", "Gyümölcs", 2)); /*Data SET*/ DataSet dataSet = new DataSet("DemoDataSet"); /*Suppliers*/ /*SupplierId-PK,SupplierName*/ DataTable suppliersDt = ToDataTable(suppliers, "Suppliers"); suppliersDt.PrimaryKey = new DataColumn[] { suppliersDt.Columns["SupplierId"] }; dataSet.Tables.Add(suppliersDt); /*Products*/ /*ProductId-PK, ProductName, Description, SupplierId*/ DataTable productsDt = ToDataTable(products, "Products"); suppliersDt.PrimaryKey = new DataColumn[] { suppliersDt.Columns["ProductId"] }; DataColumn supplierNameColumn = new DataColumn("SupplierName", typeof(string)); productsDt.Columns.Add(supplierNameColumn); dataSet.Tables.Add(productsDt); /* */ DataColumn parentColumn = dataSet.Tables["Suppliers"].Columns["SupplierId"]; DataColumn childColumn = dataSet.Tables["Products"].Columns["ProductId"]; ForeignKeyConstraint fKConstraint; fKConstraint = new ForeignKeyConstraint("SupplierFKConstraint", parentColumn, childColumn); fKConstraint.DeleteRule = Rule.SetNull; fKConstraint.UpdateRule = Rule.Cascade; fKConstraint.AcceptRejectRule = AcceptRejectRule.Cascade; dataSet.Tables["Products"].Constraints.Add(fKConstraint); dataSet.EnforceConstraints = true; dataSet.AcceptChanges(); var form = new Form2(); form.dataGridView1.DataSource = dataSet; form.dataGridView1.DataMember = "Products"; form.dataGridView2.DataSource = dataSet; form.dataGridView2.DataMember = "Suppliers"; Application.Run(form); }
public static double UPSEstimatedRate(Person shipto, ProductCollection cart) { double temp = 0.0; //return 0.0 if something is wrong try { RateService rate = new RateService(); RateRequest rateRequest = new RateRequest(); UPSSecurity upss = new UPSSecurity(); UPSSecurityServiceAccessToken upssSvcAccessToken = new UPSSecurityServiceAccessToken(); upssSvcAccessToken.AccessLicenseNumber = ConfigurationManager.AppSettings["UPSAccessLicenseNumber"]; upss.ServiceAccessToken = upssSvcAccessToken; UPSSecurityUsernameToken upssUsrNameToken = new UPSSecurityUsernameToken(); upssUsrNameToken.Username = ConfigurationManager.AppSettings["UPSUserName"]; upssUsrNameToken.Password = ConfigurationManager.AppSettings["UPSPassword"]; upss.UsernameToken = upssUsrNameToken; rate.UPSSecurityValue = upss; RequestType request = new RequestType(); String[] requestOption = { "Rate" }; request.RequestOption = requestOption; rateRequest.Request = request; ShipmentType shipment = new ShipmentType(); ShipperType shipper = new ShipperType(); shipper.ShipperNumber = ConfigurationManager.AppSettings["UPSShipperNumber"]; UPSRateService.AddressType shipperAddress = new UPSRateService.AddressType(); String[] addressLine = { ConfigurationManager.AppSettings["LMStreet"] }; shipperAddress.AddressLine = addressLine; shipperAddress.City = ConfigurationManager.AppSettings["LMCity"]; shipperAddress.StateProvinceCode = ConfigurationManager.AppSettings["LMState"]; shipperAddress.PostalCode = ConfigurationManager.AppSettings["LMZip"]; shipperAddress.CountryCode = ConfigurationManager.AppSettings["LMCountry"]; shipperAddress.AddressLine = addressLine; shipper.Address = shipperAddress; shipment.Shipper = shipper; ShipFromType shipFrom = new ShipFromType(); //UPSRateService.AddressType shipFromAddress = new UPSRateService.AddressType(); //shipFromAddress.AddressLine = shipperAddress.AddressLine; //shipFromAddress.City = shipperAddress.City; //shipFromAddress.StateProvinceCode = shipperAddress.StateProvinceCode; //shipFromAddress.PostalCode = shipperAddress.PostalCode; //shipFromAddress.CountryCode = shipperAddress.CountryCode; shipFrom.Address = shipperAddress; shipment.ShipFrom = shipFrom; ShipToType shipTo = new ShipToType(); ShipToAddressType shipToAddress = new ShipToAddressType(); String[] addressLine1 = { shipto.Addr1 }; shipToAddress.AddressLine = addressLine1; shipToAddress.City = shipto.City; shipToAddress.StateProvinceCode = shipto.State; shipToAddress.PostalCode = shipto.Zip5; shipToAddress.CountryCode = shipto.Country; shipTo.Address = shipToAddress; shipment.ShipTo = shipTo; CodeDescriptionType service = new CodeDescriptionType(); //Below code uses dummy date for reference. Please udpate as required. //service.Code = "03"; //01:nextdayair 02;2ndday 03:ground 12:3dayselect service.Code = DAL2.DAL.GetShippingMethodValuebyID(cart.ShipMethod); shipment.Service = service; PackageType package = new PackageType(); PackageWeightType packageWeight = new PackageWeightType(); packageWeight.Weight = cart.TotalWeight.ToString(); CodeDescriptionType uom = new CodeDescriptionType(); uom.Code = "LBS"; uom.Description = "pounds"; packageWeight.UnitOfMeasurement = uom; package.PackageWeight = packageWeight; CodeDescriptionType packType = new CodeDescriptionType(); packType.Code = "02"; //02:pkgcustomer package.PackagingType = packType; PackageType[] pkgArray = { package }; shipment.Package = pkgArray; rateRequest.Shipment = shipment; System.Net.ServicePointManager.CertificatePolicy = new TrustAllCertificatePolicy(); RateResponse rateResponse = rate.ProcessRate(rateRequest); UPSNoelWrite("The transaction was a " + rateResponse.Response.ResponseStatus.Description); UPSNoelWrite("Total Shipment Charges " + rateResponse.RatedShipment[0].TotalCharges.MonetaryValue + rateResponse.RatedShipment[0].TotalCharges.CurrencyCode); temp = Double.Parse(rateResponse.RatedShipment[0].TotalCharges.MonetaryValue); } catch (Exception ex) { temp = 0.0; } return(temp); //catch (System.Web.Services.Protocols.SoapException ex) //{ // UPSNoelWrite(""); // UPSNoelWrite("---------Rate Web Service returns error----------------"); // UPSNoelWrite("---------\"Hard\" is user error \"Transient\" is system error----------------"); // UPSNoelWrite("SoapException Message= " + ex.Message); // UPSNoelWrite(""); // UPSNoelWrite("SoapException Category:Code:Message= " + ex.Detail.LastChild.InnerText); // UPSNoelWrite(""); // UPSNoelWrite("SoapException XML String for all= " + ex.Detail.LastChild.OuterXml); // UPSNoelWrite(""); // UPSNoelWrite("SoapException StackTrace= " + ex.StackTrace); // UPSNoelWrite("-------------------------"); // UPSNoelWrite(""); //} //catch (System.ServiceModel.CommunicationException ex) //{ // UPSNoelWrite(""); // UPSNoelWrite("--------------------"); // UPSNoelWrite("CommunicationException= " + ex.Message); // UPSNoelWrite("CommunicationException-StackTrace= " + ex.StackTrace); // UPSNoelWrite("-------------------------"); // UPSNoelWrite(""); //} //catch (Exception ex) //{ // UPSNoelWrite(""); // UPSNoelWrite("-------------------------"); // UPSNoelWrite(" Generaal Exception= " + ex.Message); // UPSNoelWrite(" Generaal Exception-StackTrace= " + ex.StackTrace); // UPSNoelWrite("-------------------------"); //} //finally //{ // //Console.ReadKey(); //} }
/// <param name='cancellationToken'> /// Cancellation token. /// </param> public async Task <HttpOperationResponse <IList <Product> > > GetWithOperationResponseAsync(CancellationToken cancellationToken = default(System.Threading.CancellationToken)) { // Tracing bool shouldTrace = ServiceClientTracing.IsEnabled; string invocationId = null; if (shouldTrace) { invocationId = ServiceClientTracing.NextInvocationId.ToString(); Dictionary <string, object> tracingParameters = new Dictionary <string, object>(); ServiceClientTracing.Enter(invocationId, this, "GetAsync", tracingParameters); } // Construct URL string url = ""; url = url + "/api/Product"; string baseUrl = this.Client.BaseUri.AbsoluteUri; // Trim '/' character from the end of baseUrl and beginning of url. if (baseUrl[baseUrl.Length - 1] == '/') { baseUrl = baseUrl.Substring(0, baseUrl.Length - 1); } if (url[0] == '/') { url = url.Substring(1); } url = baseUrl + "/" + url; url = url.Replace(" ", "%20"); // Create HTTP transport objects HttpRequestMessage httpRequest = new HttpRequestMessage(); httpRequest.Method = HttpMethod.Get; httpRequest.RequestUri = new Uri(url); // Set Credentials if (this.Client.Credentials != null) { cancellationToken.ThrowIfCancellationRequested(); await this.Client.Credentials.ProcessHttpRequestAsync(httpRequest, cancellationToken).ConfigureAwait(false); } // Send Request if (shouldTrace) { ServiceClientTracing.SendRequest(invocationId, httpRequest); } cancellationToken.ThrowIfCancellationRequested(); HttpResponseMessage httpResponse = await this.Client.HttpClient.SendAsync(httpRequest, cancellationToken).ConfigureAwait(false); if (shouldTrace) { ServiceClientTracing.ReceiveResponse(invocationId, httpResponse); } HttpStatusCode statusCode = httpResponse.StatusCode; cancellationToken.ThrowIfCancellationRequested(); string responseContent = await httpResponse.Content.ReadAsStringAsync().ConfigureAwait(false); if (statusCode != HttpStatusCode.OK) { HttpOperationException <object> ex = new HttpOperationException <object>(); ex.Request = httpRequest; ex.Response = httpResponse; ex.Body = null; if (shouldTrace) { ServiceClientTracing.Error(invocationId, ex); } throw ex; } // Create Result HttpOperationResponse <IList <Product> > result = new HttpOperationResponse <IList <Product> >(); result.Request = httpRequest; result.Response = httpResponse; // Deserialize Response if (statusCode == HttpStatusCode.OK) { IList <Product> resultModel = new List <Product>(); JToken responseDoc = null; if (string.IsNullOrEmpty(responseContent) == false) { responseDoc = JToken.Parse(responseContent); } if (responseDoc != null) { resultModel = ProductCollection.DeserializeJson(responseDoc); } result.Body = resultModel; } if (shouldTrace) { ServiceClientTracing.Exit(invocationId, result); } return(result); }
static partial void OnAfterEntityCollectionToDtoCollection(EntityCollection <ProductEntity> entities, ProductCollection dtos);
/// <summary> /// Loads the products. /// </summary> private void LoadProducts() { SetButtonState(ddlDisplayTypes.Items.Count > 0); if (ddlDisplayTypes.Items.Count <= 0) return; lbAllItems.DataSource = new Store.ProductCollection() .Where(Product.Columns.IsEnabled, true) .Load(); lbAllItems.DataBind(); _products = CustomizedProductDisplayType.GetProductCollection(int.Parse(ddlDisplayTypes.SelectedValue)); foreach (Product item in _products) { lbAddedItems.Items.Add(new ListItem(item.Name, item.ProductId.ToString())); ListItem itemToRemove = null; foreach (ListItem litem in lbAllItems.Items) { if (litem.Value == item.ProductId.ToString()) { itemToRemove = litem; break; } } if (itemToRemove != null) lbAllItems.Items.Remove(itemToRemove); } }
public async Task AddProductCollectionAsync(ProductCollection collection) { throw new NotImplementedException(); }