//333333333333333
public List <ProductViewThumbnail> BindAllProductInfo()
{
List <ProductViewThumbnail> productDetailViewListtObj = new List <ProductViewThumbnail>();
try
{
SqlCmd.CommandText = "spSelectProductsViewInfo";
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlConnection.Open();
SqlDataReader sqldataReaderObj = SqlCmd.ExecuteReader();
if (sqldataReaderObj.HasRows)
{
while (sqldataReaderObj.Read())
{
ProductViewThumbnail productDetailViewThumbnailObj = new ProductViewThumbnail();
productDetailViewThumbnailObj.ProductID = sqldataReaderObj["ProductID"].ToString();
productDetailViewThumbnailObj.ManufacturerID = sqldataReaderObj["ManufacturersName"].ToString();
productDetailViewThumbnailObj.ProductPrice = (int)sqldataReaderObj["ProductPrice"];
productDetailViewThumbnailObj.ProductDiscountPrice = (int)sqldataReaderObj["ProductDiscountPrice"];
productDetailViewThumbnailObj.ProductImageID = sqldataReaderObj["ProductImageID"].ToString();
productDetailViewThumbnailObj.ProductImageNameExtention = sqldataReaderObj["ProductImageNameExtention"].ToString();
productDetailViewThumbnailObj.RAM = sqldataReaderObj["RAM"].ToString();
productDetailViewThumbnailObj.CPU = sqldataReaderObj["CPU"].ToString();
productDetailViewThumbnailObj.Chipset = sqldataReaderObj["Chipset"].ToString();
productDetailViewThumbnailObj.PrimaryCamera = sqldataReaderObj["PrimaryCamera"].ToString();
productDetailViewThumbnailObj.SecondryCamera = sqldataReaderObj["SecondryCamera"].ToString();
productDetailViewThumbnailObj.OS = sqldataReaderObj["OS"].ToString();
productDetailViewThumbnailObj.ProductColor = sqldataReaderObj["ProductColor"].ToString();
productDetailViewThumbnailObj.ProductFreeDeliveryStatus = sqldataReaderObj["ProductFreeDeliveryStatus"].ToString();
productDetailViewThumbnailObj.Product30DaysReturnStatus = sqldataReaderObj["Product30DaysReturnStatus"].ToString();
productDetailViewThumbnailObj.ProductQuantity = sqldataReaderObj["ProductQuantity"].ToString();
productDetailViewListtObj.Add(productDetailViewThumbnailObj);
}
}
sqldataReaderObj.Close();
}
catch (Exception ex)
{
}
finally
{
SqlConnection.Close();
}
return(productDetailViewListtObj);
}
public List <ProductViewThumbnail> SearchProductByProductName(string searchedItem)
{
List <ProductViewThumbnail> productViewThumbnailListObj = new List <ProductViewThumbnail>();
using (SqlConnection)
//try
{
SqlCmd.CommandText = "spSearchProductByProductName";
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@SearchItem", searchedItem);
SqlConnection.Open();
SqlDataReader sqldataReaderObj = SqlCmd.ExecuteReader();
if (sqldataReaderObj.HasRows)
{
while (sqldataReaderObj.Read())
{
ProductViewThumbnail productViewThumbnailObj = new ProductViewThumbnail();
productViewThumbnailObj.ProductID = sqldataReaderObj["ProductID"].ToString();
productViewThumbnailObj.ManufacturerID = sqldataReaderObj["ManufacturersName"].ToString();
productViewThumbnailObj.ProductPrice = (int)sqldataReaderObj["ProductPrice"];
productViewThumbnailObj.ProductDiscountPrice = (int)sqldataReaderObj["ProductDiscountPrice"];
productViewThumbnailObj.ProductImageID = sqldataReaderObj["ProductImageID"].ToString();
productViewThumbnailObj.ProductImageNameExtention = sqldataReaderObj["ProductImageNameExtention"].ToString();
//productViewThumbnailObj.ProductID = sqldataReaderObj["ProductID"].ToString();
productViewThumbnailListObj.Add(productViewThumbnailObj);
}
}
sqldataReaderObj.Close();
}
//catch (Exception ex)
//{
//}
//finally
//{
// SqlConnection.Close();
//}
return(productViewThumbnailListObj);
}
//Bind all Feature phones
public List <ProductViewThumbnail> BindFeaturePhones()
{
List <ProductViewThumbnail> productViewThumbnailListObj = new List <ProductViewThumbnail>();
//using (SqlConnection)
try
{
SqlCmd.CommandText = "spSelectProductsViewInfoFeaturePhone";
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlConnection.Open();
SqlDataReader sqldataReaderObj = SqlCmd.ExecuteReader();
if (sqldataReaderObj.HasRows)
{
while (sqldataReaderObj.Read())
{
ProductViewThumbnail productViewThumbnailObj = new ProductViewThumbnail();
productViewThumbnailObj.ProductID = sqldataReaderObj["ProductID"].ToString();
productViewThumbnailObj.ManufacturerID = sqldataReaderObj["ManufacturersName"].ToString();
productViewThumbnailObj.ProductPrice = (int)sqldataReaderObj["ProductPrice"];
productViewThumbnailObj.ProductDiscountPrice = (int)sqldataReaderObj["ProductDiscountPrice"];
productViewThumbnailObj.ProductImageID = sqldataReaderObj["ProductImageID"].ToString();
productViewThumbnailObj.ProductImageNameExtention = sqldataReaderObj["ProductImageNameExtention"].ToString();
//productViewThumbnailObj.ProductID = sqldataReaderObj["ProductID"].ToString();
productViewThumbnailListObj.Add(productViewThumbnailObj);
}
}
sqldataReaderObj.Close();
}
catch (Exception ex)
{
}
finally
{
SqlConnection.Close();
}
return(productViewThumbnailListObj);
}
public List <ProductViewThumbnail> BindProductInfoAndImageByID(string productID)// cart, Product detail View
{
List <ProductViewThumbnail> productDetailViewListtObj = new List <ProductViewThumbnail>();
//int cartTotalPrice = 0;
//int discountTotalPrice = 0;
//int totalPrice = 0;
using (SqlConnection)
//try
{
SqlCmd.CommandText = "spProductDetailsByProductID";
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@ProductID", productID);
SqlConnection.Open();
SqlDataReader sqldataReaderObj = SqlCmd.ExecuteReader();
if (sqldataReaderObj.HasRows)
{
while (sqldataReaderObj.Read())
{
ProductViewThumbnail productDetailViewThumbnailObj = new ProductViewThumbnail();
productDetailViewThumbnailObj.ProductID = sqldataReaderObj["ProductID"].ToString();
productDetailViewThumbnailObj.ManufacturerID = sqldataReaderObj["ManufacturerID"].ToString();
productDetailViewThumbnailObj.ProductPrice = (int)sqldataReaderObj["ProductPrice"];
productDetailViewThumbnailObj.ProductDiscountPrice = (int)sqldataReaderObj["ProductDiscountPrice"];
productDetailViewThumbnailObj.RAM = sqldataReaderObj["RAM"].ToString();
productDetailViewThumbnailObj.CPU = sqldataReaderObj["CPU"].ToString();
productDetailViewThumbnailObj.Chipset = sqldataReaderObj["Chipset"].ToString();
productDetailViewThumbnailObj.PrimaryCamera = sqldataReaderObj["PrimaryCamera"].ToString();
productDetailViewThumbnailObj.SecondryCamera = sqldataReaderObj["SecondryCamera"].ToString();
productDetailViewThumbnailObj.OS = sqldataReaderObj["OS"].ToString();
productDetailViewThumbnailObj.ProductColor = sqldataReaderObj["ProductColor"].ToString();
productDetailViewThumbnailObj.ProductFreeDeliveryStatus = sqldataReaderObj["ProductFreeDeliveryStatus"].ToString();
productDetailViewThumbnailObj.Product30DaysReturnStatus = sqldataReaderObj["Product30DaysReturnStatus"].ToString();
productDetailViewThumbnailObj.ProductQuantity = sqldataReaderObj["ProductQuantity"].ToString();
productDetailViewThumbnailObj.ProductImageID = sqldataReaderObj["ProductImageID"].ToString();
productDetailViewThumbnailObj.ProductImageNameExtention = sqldataReaderObj["ProductImageNameExtention"].ToString();
//cartTotalPrice += (int)sqldataReaderObj["ProductPrice"];
//discountTotalPrice += (int)sqldataReaderObj["ProductDiscountPrice"];
//totalPrice = cartTotalPrice - discountTotalPrice;
//productDetailViewThumbnailObj.TotalCartPrice = cartTotalPrice;
//productDetailViewThumbnailObj.TotalDiscountDiscountPrice = discountTotalPrice;
//productDetailViewThumbnailObj.TotalPrice = totalPrice;
productDetailViewListtObj.Add(productDetailViewThumbnailObj);
}
}
sqldataReaderObj.Close();
}
//catch (Exception ex)
//{
//}
//finally
//{
// SqlConnection.Close();
//}
return(productDetailViewListtObj);
}
