public List<ProductCategory> ProductCategory_GetByLevel(string Level, int LevelLength) { List<Data.ProductCategory> list = new List<Data.ProductCategory>(); using (SqlCommand dbCmd = new SqlCommand("sp_ProductCategory_GetByLevel", GetConnection())) { Data.ProductCategory obj = new Data.ProductCategory(); dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add(new SqlParameter("@Level", Level)); dbCmd.Parameters.Add(new SqlParameter("@LevelLength", LevelLength)); SqlDataReader dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { list.Add(obj.ProductCategoryIDataReader(dr)); } dr.Close(); //conn.Close(); } else { dr.Close(); } } return list; }
public Data.Product ToEntity(Data.ProductCategory category) => new Data.Product { Brand = Brand.Name, CategoryId = category.Id, Id = Id.ToString(), Image = Images.CutOut.ToString(), Link = $"https://www.farfetch.com{Url}", Name = ShortDescription, Price = PriceInfo.InitialPrice, SalePrice = PriceInfo.FinalPrice, Savings = PriceInfo.InitialPrice - PriceInfo.FinalPrice, Edit = category.Edit };
public coach_bags_selenium.Data.Product AsEntity(Data.ProductCategory category) => new Data.Product { Link = "https://www.ferragamo.com" + Url, Name = Name, Brand = "Salvatore Ferragamo", CategoryId = category.Id, SalePrice = Prices.Last().PricePrice, Price = Prices.Last().PricePrice, Savings = 0, Id = UniqueId, Image = Image1.ToString(), Edit = category.Edit };
public coach_bags_selenium.Data.Product AsEntity(Data.ProductCategory category) => new Data.Product { Link = "https://www.michaelkors.global/en_AU" + ProductSeourl, Name = SkUs.First().Name, Brand = Brand, CategoryId = category.Id, SalePrice = decimal.Parse(Prices.LowSalePrice), Price = decimal.Parse(Prices.HighListPrice), Savings = decimal.Parse(Prices.HighListPrice) - decimal.Parse(Prices.LowSalePrice), Id = Identifier, Image = Media.AlternativeImages.FirstOrDefault()?.ImageUrl, Edit = category.Edit };
public Data.Product ToEntity(Data.ProductCategory category) => new Data.Product { Brand = DesignerNameEn, CategoryId = category.Id, Id = ProductId, Image = Thumbnail, Images = Images .Where(p => p.Size.Width >= 1920) .GroupBy(p => p.View) .Select(i => "https:" + i.First().Url).ToArray(), Link = $"https://www.theoutnet.com/en-au/shop/product{Seo.SeoUrlKeyword}", Name = Name, Price = Price.WasPrice.Amount / Price.WasPrice.Divisor, SalePrice = Price.SellingPrice.Amount / Price.SellingPrice.Divisor, Savings = Price.WasPrice.Amount / Price.WasPrice.Divisor - Price.SellingPrice.Amount / Price.SellingPrice.Divisor, Edit = category.Edit, };
private static List <ProductCategory> GetDataProductCategories(Model.Product product, int productId) { List <Data.ProductCategory> productCategories = new List <Data.ProductCategory>(); foreach (var category in product.Categories) { var productCategory = new Data.ProductCategory(); var date = DateTime.Now; productCategory.CategoryId = category.Id; productCategory.ProductId = productId; productCategory.CreateDateTime = date; productCategory.UpdateDateTime = date; productCategories.Add(productCategory); } return(productCategories); }
public List<ProductCategory> ProductCategory_GetByAll() { List<Data.ProductCategory> list = new List<Data.ProductCategory>(); using (SqlCommand dbCmd = new SqlCommand("sp_ProductCategory_GetByAll", GetConnection())) { Data.ProductCategory obj = new Data.ProductCategory(); dbCmd.CommandType = CommandType.StoredProcedure; SqlDataReader dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { list.Add(obj.ProductCategoryIDataReader(dr)); } dr.Close(); //conn.Close(); } else { dr.Close(); } } return list; }
protected void Update_Click(object sender, EventArgs e) { if (Page.IsValid) { Data.ProductCategory obj = new Data.ProductCategory(); obj.ID = Id; obj.Name = txtName.Text; obj.Title = txtTitle.Text; obj.Tag = Common.StringClass.NameToTag(txtName.Text); obj.Level = Level + "00000"; obj.Ord = txtOrd.Text != "" ? txtOrd.Text : "1"; obj.Description = txtDescription.Text; obj.MetaKeyword = txtMetaKeyword.Text; obj.IsDisplayInHome = chkIsDisplayInHome.Checked ? "1" : "0"; obj.Active = chkActive.Checked ? "1" : "0"; if (Insert == true) { ProductCategoryService.ProductCategory_Insert(obj); } else { ProductCategoryService.ProductCategory_Update(obj); } BindGrid(); pnView.Visible = true; pnUpdate.Visible = false; Level = ""; Insert = false; } }
public List<ProductCategory> ProductCategory_Paging(string CurentPage, string PageSize) { List<Data.ProductCategory> list = new List<Data.ProductCategory>(); using (SqlCommand dbCmd = new SqlCommand("sp_ProductCategory_Paging", GetConnection())) { Data.ProductCategory obj = new Data.ProductCategory(); dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add(new SqlParameter("@CurentPage", CurentPage)); dbCmd.Parameters.Add(new SqlParameter("@PageSize", PageSize)); SqlDataReader dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { list.Add(obj.ProductCategoryIDataReader(dr)); } dr.Close(); //conn.Close(); } else { dr.Close(); } } return list; }
public List<ProductCategory> ProductCategory_GetByTop(string Top, string Where, string Order) { List<Data.ProductCategory> list = new List<Data.ProductCategory>(); using (SqlCommand dbCmd = new SqlCommand("sp_ProductCategory_GetByTop", GetConnection())) { Data.ProductCategory obj = new Data.ProductCategory(); dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add(new SqlParameter("@Top", Top)); dbCmd.Parameters.Add(new SqlParameter("@Where", Where)); dbCmd.Parameters.Add(new SqlParameter("@Order", Order)); SqlDataReader dr = dbCmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { list.Add(obj.ProductCategoryIDataReader(dr)); } dr.Close(); //conn.Close(); } else { dr.Close(); } } return list; }
public ProductCategory ProductCategoryIDataReader(IDataReader dr) { Data.ProductCategory obj = new Data.ProductCategory(); obj.ID = (dr["ID"] is DBNull) ? string.Empty : dr["ID"].ToString(); obj.Name = (dr["Name"] is DBNull) ? string.Empty : dr["Name"].ToString(); obj.Title = (dr["Title"] is DBNull) ? string.Empty : dr["Title"].ToString(); obj.Tag = (dr["Tag"] is DBNull) ? string.Empty : dr["Tag"].ToString(); obj.Level = (dr["Level"] is DBNull) ? string.Empty : dr["Level"].ToString(); obj.Ord = (dr["Ord"] is DBNull) ? string.Empty : dr["Ord"].ToString(); obj.Description = (dr["Description"] is DBNull) ? string.Empty : dr["Description"].ToString(); obj.MetaKeyword = (dr["MetaKeyword"] is DBNull) ? string.Empty : dr["MetaKeyword"].ToString(); obj.Active = (dr["Active"] is DBNull) ? string.Empty : dr["Active"].ToString(); obj.Type = (dr["Type"] is DBNull) ? string.Empty : dr["Type"].ToString(); obj.IsDisplayInHome = (dr["IsDisplayInHome"] is DBNull) ? string.Empty : dr["IsDisplayInHome"].ToString(); return obj; }