public DataSet getCustomer(CustomerBiz oCustomerBiz)
{
DataSet dsCustomer = null;
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
try
{
dsCustomer = new DataSet();
dsCustomer = objCoreDataLayer.ExecuteDataSet("pr_getcustomer", new object[] { oCustomerBiz.Email,oCustomerBiz.Pwd});
}
catch (Exception ex)
{
throw ex;
}
return dsCustomer;
}
public DataSet getAllCustomer()
{
DataSet dsCustomer = null;
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
try
{
dsCustomer = new DataSet();
dsCustomer = objCoreDataLayer.ExecuteDataSet("pr_getallcustomer", new object[] {});
}
catch (Exception ex)
{
throw ex;
}
return dsCustomer;
}
public DataSet getCriticalUpdates()
{
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
DataSet dsCritical = null;
try
{
dsCritical = new DataSet();
dsCritical = objCoreDataLayer.ExecuteDataSet("pr_getCriticalUpdates", new object[] { });
}
catch (Exception e)
{
throw e;
}
return dsCritical;
}
public DataSet getAllBanners()
{
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
DataSet dsAllBanner = null;
try
{
dsAllBanner = new DataSet();
dsAllBanner = objCoreDataLayer.ExecuteDataSet("pr_getallbanner", new object[] { });
}
catch (Exception e)
{
throw e;
}
return dsAllBanner;
}
public DataSet getListAllProducts(ProductBiz oProductBiz)
{
DataSet dsProducts = null;
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
try
{
dsProducts = new DataSet();
dsProducts = objCoreDataLayer.ExecuteDataSet("pr_getallproducts", new object[] { oProductBiz.CategoryId ,oProductBiz.SearchText});
}
catch (Exception ex)
{
throw ex;
}
return dsProducts;
}
public DataSet getAllCarousel()
{
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
DataSet dsAllCarousel = null;
try
{
dsAllCarousel = new DataSet();
dsAllCarousel = objCoreDataLayer.ExecuteDataSet("pr_getallcarousels", new object[] { });
}
catch (Exception e)
{
throw e;
}
return dsAllCarousel;
}
public DataSet getRandomAdBanner(string category)
{
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
DataSet dsBanner = null;
try
{
dsBanner = new DataSet();
dsBanner = objCoreDataLayer.ExecuteDataSet("pr_Get_Random_Banner", new object[] { category });
}
catch (Exception e)
{
throw e;
}
return dsBanner;
}
public DataSet getStatus()
{
DataSet dsStatus = null;
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
try
{
dsStatus = new DataSet();
dsStatus = objCoreDataLayer.ExecuteDataSet("pr_selStatus", new object[] { });
}
catch (Exception ex)
{
throw ex;
}
return dsStatus;
}
public DataSet getBannerAdById(int adId)
{
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
DataSet dsBannerAd = null;
try
{
dsBannerAd = new DataSet();
dsBannerAd = objCoreDataLayer.ExecuteDataSet("pr_getBannerAdById", new object[] {adId });
}
catch (Exception e)
{
throw e;
}
return dsBannerAd;
}
public DataSet getProductDetailsById(int pid)
{
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
DataSet dsProductDetails = null;
try
{
dsProductDetails = new DataSet();
dsProductDetails = objCoreDataLayer.ExecuteDataSet("pr_getProductDetailsById", new object[] { pid});
}
catch (Exception e)
{
throw e;
}
return dsProductDetails;
}
public DataSet getReviewsByProduct(RatingBiz oRatingBiz)
{
DataSet dsProductReview = null;
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
try
{
dsProductReview = new DataSet();
dsProductReview = objCoreDataLayer.ExecuteDataSet("pr_getallprodreviews", new object[] { oRatingBiz.Pid});
}
catch (Exception ex)
{
throw ex;
}
return dsProductReview;
}
public DataSet getCityByStateId(int stateId)
{
DataSet dsCity = null;
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
try
{
dsCity = new DataSet();
dsCity = objCoreDataLayer.ExecuteDataSet("pr_getcitybystateid", new object[] { stateId });
}
catch (Exception ex)
{
throw ex;
}
return dsCity;
}
public DataSet getCustomerSavedAddress(CustomerBiz oCustomerBiz)
{
DataSet dsCustomerAdd = null;
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
try
{
dsCustomerAdd = new DataSet();
dsCustomerAdd = objCoreDataLayer.ExecuteDataSet("pr_getcustomerSavedAdd", new object[] { oCustomerBiz.CustomerId });
}
catch (Exception ex)
{
throw ex;
}
return dsCustomerAdd;
}
public DataSet getCategory()
{
DataSet dsCat = null;
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
try
{
dsCat = new DataSet();
dsCat = objCoreDataLayer.ExecuteDataSet("pr_selcategory", new object[] { });
}
catch (Exception ex)
{
throw ex;
}
return dsCat;
}
public DataSet getBrands()
{
DataSet dsBrands = null;
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
try
{
dsBrands = new DataSet();
dsBrands = objCoreDataLayer.ExecuteDataSet("pr_getAllBrands", new object[] { });
}
catch (Exception ex)
{
throw ex;
}
return dsBrands;
}
public DataSet getAreaByCityId(int cityId)
{
DataSet dsArea = null;
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
try
{
dsArea = new DataSet();
dsArea = objCoreDataLayer.ExecuteDataSet("pr_getareabycityid", new object[] { cityId });
}
catch (Exception ex)
{
throw ex;
}
return dsArea;
}
public DataSet getAllProducts()
{
DataSet dsProducts = null;
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
try
{
dsProducts = new DataSet();
dsProducts = objCoreDataLayer.ExecuteDataSet("pr_getallproductsAdmin", new object[] { });
}
catch (Exception ex)
{
throw ex;
}
return dsProducts;
}
public DataSet getAllCategoriesWithProdCount()
{
DataSet dsCategories = null;
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
try
{
dsCategories = new DataSet();
dsCategories = objCoreDataLayer.ExecuteDataSet("pr_getallcategories", new object[] { });
}
catch (Exception ex)
{
throw ex;
}
return dsCategories;
}
