public List <ProductDetails> FindByTag(long tagId, int startIndex, int count) { List <ProductDetails> products = new List <ProductDetails>(); List <Product> productList = TagDao.Find(tagId).Products.ToList <Product>(); int c = 0; for (int i = startIndex; i < productList.Count; i++) { if (c == count) { break; } long productId = productList.ElementAt(i).productId; string name = productList.ElementAt(i).name; long categoryId = productList.ElementAt(i).categoryId; string categoryName = CategoryDao.Find(productList.ElementAt(i).categoryId).name; DateTime registerDate = productList.ElementAt(i).registerDate; double prize = productList.ElementAt(i).prize; int numberOfUnits = productList.ElementAt(i).numberOfUnits; products.Add(new ProductDetails(name, categoryId, categoryName, registerDate, prize, productId, numberOfUnits, false)); c++; } return(products); }
public ProductDetails FindProduct(long id) { Product product; product = ProductDao.Find(id); long categoryId = product.categoryId; string categoryName = CategoryDao.Find(product.categoryId).name; ProductDetails productDetails; if (product is Movie) { Movie mov = product as Movie; productDetails = new MovieDetails(product.name, categoryId, categoryName, product.registerDate, product.prize, product.productId, product.numberOfUnits, false, mov.title, mov.director, mov.summary, mov.topic, mov.duration); } else if (product is Book) { Book book = product as Book; productDetails = new BookDetails(product.name, categoryId, categoryName, product.registerDate, product.prize, product.productId, product.numberOfUnits, false, book.title, book.author, book.summary, book.topic, book.pages); } else if (product is CD) { CD cd = product as CD; productDetails = new CDDetails(product.name, categoryId, categoryName, product.registerDate, product.prize, product.productId, product.numberOfUnits, false, cd.title, cd.artist, cd.topic, cd.songs); } else { productDetails = new ProductDetails(product.name, categoryId, categoryName, product.registerDate, product.prize, product.productId, product.numberOfUnits, false); } return(productDetails); }
public List <ProductDetails> FindByKeywords(string keywords, int startIndex, int count) { List <ProductDetails> products = new List <ProductDetails>(); string productName = keywords; try { List <Product> productList = ProductDao.FindByKeywords(keywords, -1, startIndex, count); for (int i = 0; i < productList.Count; i++) { long productId = productList.ElementAt(i).productId; string name = productList.ElementAt(i).name; long categoryId = productList.ElementAt(i).categoryId; string categoryName = CategoryDao.Find(productList.ElementAt(i).categoryId).name; DateTime registerDate = productList.ElementAt(i).registerDate; double prize = productList.ElementAt(i).prize; int numberOfUnits = productList.ElementAt(i).numberOfUnits; products.Add(new ProductDetails(name, categoryId, categoryName, registerDate, prize, productId, numberOfUnits, false)); } }catch (InstanceNotFoundException e) { } return(products); }
public override void ConvertSpecific(NoteParam param, Data.Entity.Note entity) { entity.Account = AccountDao.Find(param.AccountId); entity.Category = CategoryDao.Find(param.CategoryId); entity.Status = StatusDao.Find(param.StatusId); entity.Type = TypeDao.Find(param.TypeId); }
// Populate the controls private void PopulateControls() { // Retrieve product details and category details from database ECommerce.CdShop.Entity.Product productDetails = CatalogAccess.GetProductDetails(currentProductId); Category categoryDetails = categoryDao.Find(currentCategoryId); // Set up labels and images productNameLabel.Text = productDetails.Name; image1.ImageUrl = Link.ToProductImage(productDetails.Thumbnail); image2.ImageUrl = Link.ToProductImage(productDetails.Image); // Link to department catLink.Text = categoryDetails.Name; catLink.NavigateUrl = "AdminCategories.aspx?DepartmentID=" + currentDepartmentId; // Clear form categoriesLabel.Text = ""; categoriesListAssign.Items.Clear(); categoriesListMove.Items.Clear(); categoriesListRemove.Items.Clear(); // Fill categoriesLabel and categoriesListRemove with data string categoryId, categoryName; DataTable productCategories = CatalogAccess.GetCategoriesWithProduct(currentProductId); for (int i = 0; i < productCategories.Rows.Count; i++) { // obtain category id and name categoryId = productCategories.Rows[i]["Id"].ToString(); categoryName = productCategories.Rows[i]["Name"].ToString(); // add a link to the category admin page categoriesLabel.Text += (categoriesLabel.Text == "" ? "" : ", ") + "<a href='AdminProducts.aspx?DepartmentID=" + CatalogAccess.GetCategoryDetails(currentCategoryId).DepartmentId + "&CategoryID=" + categoryId + "'>" + categoryName + "</a>"; // populate the categoriesListRemove combo box categoriesListRemove.Items.Add(new ListItem(categoryName, categoryId)); } // Delete from catalog or remove from category? if (productCategories.Rows.Count > 1) { deleteButton.Visible = false; removeButton.Enabled = true; } else { deleteButton.Visible = true; removeButton.Enabled = false; } // Fill categoriesListMove and categoriesListAssign with data productCategories = CatalogAccess.GetCategoriesWithoutProduct(currentProductId); for (int i = 0; i < productCategories.Rows.Count; i++) { // obtain category id and name categoryId = productCategories.Rows[i]["Id"].ToString(); categoryName = productCategories.Rows[i]["Name"].ToString(); // populate the list boxes categoriesListAssign.Items.Add(new ListItem(categoryName, categoryId)); categoriesListMove.Items.Add(new ListItem(categoryName, categoryId)); } }
public List <ProductDetails> GetOrderLineProductsByOrderId(long orderId) { Order order = OrderDao.Find(orderId); List <ProductDetails> productsDetails = new List <ProductDetails>(); for (int i = 0; i < order.OrderLines.Count; i++) { Product p = ProductDao.Find(order.OrderLines.ElementAt(i).productId); string categoryName = CategoryDao.Find(p.categoryId).name; ProductDetails productDetails = new ProductDetails(p.name, p.categoryId, categoryName, p.registerDate, order.OrderLines.ElementAt(i).unitPrize, p.productId, order.OrderLines.ElementAt(i).numberOfUnits, order.OrderLines.ElementAt(i).forGift); productsDetails.Add(productDetails); } return(productsDetails); }
protected void Page_Load(object sender, EventArgs e) { // Load the grid only the first time the page is loaded if (!Page.IsPostBack) { // Get CategoryID and DepartmentID from the query string string categoryId = Request.QueryString["CategoryID"]; string departmentId = Request.QueryString["DepartmentID"]; // Obtain the category name CategoryDao dao = new CategoryDao(); ECommerce.CdShop.Entity.Category cd = dao.Find(categoryId); string categoryName = cd.Name; // Link to department catLink.Text = categoryName; catLink.NavigateUrl = "AdminCategories.aspx?DepartmentID=" + departmentId; // Load the products grid BindGrid(); } }
public void create(Category objCategory) { Category objCategoryAux = new Category(); bool verification = true; string code = objCategory.IdCategory; if (code == null || code.Trim().Equals("")) { objCategory.State = 10; return; } else { code = objCategory.IdCategory.Trim(); verification = code.Length > 0 && code.Length <= 5; if (!verification) { objCategory.State = 1; return; } } string name = objCategory.Name; if (name == null || name.Equals("")) { objCategory.State = 20; return; } else { name = objCategory.Name.Trim(); verification = name.Length > 0 && name.Length <= 30; if (!verification) { objCategory.State = 2; return; } } string description = objCategory.Description; if (description == null || description.Trim().Equals("")) { objCategory.State = 30; return; } else { description = objCategory.Description.Trim(); verification = description.Length > 0 && description.Length <= 50; if (!verification) { objCategory.State = 3; return; } } objCategoryAux.IdCategory = objCategory.IdCategory; verification = !objCategoryDao.Find(objCategoryAux); if (!verification) { objCategory.State = 8; return; } //verificar o nome objCategoryAux.Name = objCategory.Name; verification = !objCategoryDao.FindCat(objCategoryAux); if (!verification) { objCategory.State = 16; return; } objCategory.State = 99; objCategoryDao.Create(objCategory); return; }