public List<ProductDetails> getSubCategory(string SubCategoryName)
{
List<ProductDetails> lst = new List<ProductDetails>();
DBHelper helper = new DBHelper();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter(CONSTANT.SUB_CAT_NAME, SubCategoryName);
DataSet ds = helper.executeSelectQuery(PROCEDURES.GET_SUB_CATEGORY_WISE_PRODUCT, param);
if (ds != null)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
ProductDetails sub = new ProductDetails();
sub.ProductName = row["Prod_Name"].ToString();
sub.ProductImage = row["Prod_Img"].ToString();
sub.ProductMRP = row["MRP"].ToString();
sub.ProductPrice = row["Selling Price"].ToString();
sub.ProductQuanity = row["packed_quantity"].ToString();
sub.ProductId = row["Prod_Id"].ToString();
sub.ProductBrand = row["Brand_Name"].ToString();
lst.Add(sub);
}
}
return lst;
}
public List<ProductDetails> GetProducts(string searchCondition)
{
List<ProductDetails> lst = new List<ProductDetails>();
DBHelper helper = new DBHelper();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter(CONSTANT.PRODUCT_SEARCH_CRITERIA, searchCondition);
DataSet ds = helper.executeSelectQuery(PROCEDURES.PRODUCT_SEARCH, param);
if (ds != null)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
ProductDetails sub = new ProductDetails();
sub.ProductName = row["Prod_Name"].ToString();
sub.ProductImage = row["Prod_Img"].ToString();
sub.ProductMRP = row["MRP"].ToString();
sub.ProductPrice = row["Selling Price"].ToString();
sub.ProductQuanity = row["packed_quantity"].ToString();
sub.ProductId = row["Prod_Id"].ToString();
sub.ProductBrand = row["Brand_Name"].ToString();
lst.Add(sub);
}
}
return lst;
}
public List<ProductDetails> GetAllProducts()
{
List<ProductDetails> lst = new List<ProductDetails>();
DBHelper helper = new DBHelper();
DataSet ds = helper.executeSelectQuery(PROCEDURES.GET_ALL_PRODUCTS);
if (ds != null)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
ProductDetails sub = new ProductDetails();
sub.ProductName = row["Prod_Name"].ToString();
sub.ProductImage = row["Prod_Img"].ToString();
sub.ProductMRP = row["MRP"].ToString();
sub.ProductPrice = row["Selling Price"].ToString();
sub.ProductQuanity = row["packed_quantity"].ToString();
sub.ProductId = row["Prod_Id"].ToString();
sub.ProductBrand = row["Brand_Name"].ToString();
lst.Add(sub);
}
}
return lst;
}
public ProductDetails GetProductBasedOnID(string productId)
{
// List<ProductDetails> lst = new List<ProductDetails>();
DBHelper helper = new DBHelper();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter(CONSTANT.PRODUCT_ID, productId);
ProductDetails productDetails = new ProductDetails();
DataSet ds = helper.executeSelectQuery(PROCEDURES.GET_PRODUCT_ID_WISE_PRODUCT, param);
if (ds != null)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
productDetails.ProductName = row["Prod_Name"].ToString();
productDetails.ProductImage = row["Prod_Img"].ToString();
productDetails.ProductMRP = row["MRP"].ToString();
productDetails.ProductPrice = row["Selling Price"].ToString();
productDetails.ProductQuanity = row["packed_quantity"].ToString();
productDetails.ProductId = row["Prod_Id"].ToString();
productDetails.ProductBrand = row["Brand_Name"].ToString();
//lst.Add(productDetails);
}
}
return productDetails;
}
public Item(ProductDetails productDetails, int qty)
{
Product = productDetails;
Qty = qty;
}