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;
 }
Пример #2
0
 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
 };
Пример #3
0
 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
 };
Пример #4
0
 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
 };
Пример #5
0
 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,
 };
Пример #6
0
        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;
 }