public Boolean addBanner(BannerBiz oBannerBiz)
{
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
Boolean flag = false;
try
{
string strRetValue = string.Empty;
if (oBannerBiz.UserAction.ToUpper().Equals("ADD"))
{
strRetValue = objCoreDataLayer.ExecuteScalar("pr_InsBannerAd", new object[] { oBannerBiz.Category,oBannerBiz.AdvName,oBannerBiz.ImgPath,oBannerBiz.Width,oBannerBiz.Height,
oBannerBiz.StartDate,oBannerBiz.EndDate,oBannerBiz.RedirectURL,oBannerBiz.Active,oBannerBiz.AltText,oBannerBiz.Weightage}, true);
}
else
{
strRetValue = objCoreDataLayer.ExecuteScalar("pr_UpdBannerAd", new object[] { oBannerBiz.AdId,oBannerBiz.Category,oBannerBiz.AdvName,oBannerBiz.ImgPath,oBannerBiz.Width,oBannerBiz.Height,
oBannerBiz.StartDate,oBannerBiz.EndDate,oBannerBiz.RedirectURL,oBannerBiz.Active,oBannerBiz.AltText,oBannerBiz.Weightage}, true);
}
if (strRetValue == "0")
flag = true;
}
catch (Exception ex)
{
throw ex;
}
return flag;
}
public Boolean addProduct(ProductBiz oProductBiz)
{
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
Boolean flag = false;
try
{
ArrayList arrImages = new ArrayList();
arrImages = oProductBiz.ArrImages;
StringBuilder strBuildImg = new StringBuilder();
ArrayList arrCat = new ArrayList();
arrCat = oProductBiz.ArrCategories;
StringBuilder strBuildCat = new StringBuilder();
string strRetValue = string.Empty;
foreach (BaseBiz arr in arrImages)
{
strBuildImg.Append(arr.Name);
strBuildImg.Append(",");
}
foreach (string cat in arrCat)
{
strBuildCat.Append(cat);
strBuildCat.Append(",");
}
if (oProductBiz.UserAction != "")
{
strRetValue = objCoreDataLayer.ExecuteScalar("pr_updProduct", new object[] {oProductBiz.ProductId, oProductBiz.ProductName,oProductBiz.ProductCode,oProductBiz.ProdShortDesc,oProductBiz.ProdLongDesc,
oProductBiz.Price,oProductBiz.BrandId,oProductBiz.IsActive,oProductBiz.IsProductSale,oProductBiz.SaleType,oProductBiz.Priceorpercent,oProductBiz.IsHot,oProductBiz.HotText,strBuildImg.ToString(),strBuildCat.ToString(),oProductBiz.QtyInCart,oProductBiz.QtyText }, true);
}
else
{
strRetValue = objCoreDataLayer.ExecuteScalar("pr_insProduct", new object[] { oProductBiz.ProductName,oProductBiz.ProductCode,oProductBiz.ProdShortDesc,oProductBiz.ProdLongDesc,
oProductBiz.Price,oProductBiz.BrandId,oProductBiz.IsActive,oProductBiz.IsProductSale,oProductBiz.SaleType,oProductBiz.Priceorpercent,oProductBiz.IsHot,oProductBiz.HotText,strBuildImg.ToString(),strBuildCat.ToString(),oProductBiz.QtyInCart,oProductBiz.QtyText }, true);
}
if (strRetValue == "0")
flag = true;
}
catch (Exception ex)
{
throw ex;
}
return flag;
}
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 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 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 Boolean deleteBannerAd(int adId)
{
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
Boolean flag = false;
try
{
string strReturnVal = objCoreDataLayer.ExecuteScalar("pr_delBannerAd", new object[] { adId }, true);
if (strReturnVal == "0")
flag = true;
}
catch (Exception e)
{
throw e;
}
return flag;
}
public Boolean changeStatus(int statusId,string productIds)
{
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
Boolean flag = false;
try
{
string strReturnVal = objCoreDataLayer.ExecuteScalar("pr_changestatus", new object[] { statusId, productIds }, true);
if (strReturnVal == "0")
flag = true;
}
catch (Exception e)
{
throw e;
}
return flag;
}
public Boolean customerSignUp(CustomerBiz oCustomerBiz)
{
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
Boolean flag = false;
try
{
string strRetValue = string.Empty;
strRetValue = objCoreDataLayer.ExecuteScalar("pr_insertcustomer", new object[] { oCustomerBiz.Email,oCustomerBiz.Name,oCustomerBiz.Pwd }, true);
if (strRetValue == "0")
flag = true;
}
catch (Exception ex)
{
throw ex;
}
return flag;
}
public Boolean insertContactUs(ContactBiz oContactBiz)
{
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
Boolean flag = false;
try
{
string strRetValue = string.Empty;
strRetValue = objCoreDataLayer.ExecuteScalar("pr_insContactUs", new object[] { oContactBiz.ContactName, oContactBiz.Email, oContactBiz.Subject, oContactBiz.Comments, oContactBiz.IsContact, oContactBiz.FeedbackType }, true);
if (strRetValue == "0")
flag = true;
}
catch (Exception ex)
{
throw ex;
}
return flag;
}
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 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;
}
public string insAdTrackingAndBannerURL(BannerBiz oBannerBiz)
{
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
string redirectUrl = string.Empty;
try
{
redirectUrl = objCoreDataLayer.ExecuteNonQueryAndScalar("pr_InsAdtracking", new object[] { oBannerBiz.AdId, oBannerBiz.IpAddress });
}
catch (Exception e)
{
throw e;
}
return redirectUrl;
}
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 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 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 Boolean insertReviews(RatingBiz oRatingBiz)
{
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
Boolean flag = false;
try
{
string strRetValue = string.Empty;
strRetValue = objCoreDataLayer.ExecuteScalar("PR_INSPRODREVIEW", new object[] { oRatingBiz.ReviewTitle, oRatingBiz.Pid,oRatingBiz.ReviewText,oRatingBiz.ReviewerName,oRatingBiz.Rating }, true);
if (strRetValue == "0")
flag = true;
}
catch (Exception ex)
{
throw ex;
}
return flag;
}
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 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 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 Boolean isUserExist(CustomerBiz oCustomerBiz)
{
int cnt = 0;
bool flg = false;
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
try
{
cnt = Convert.ToInt32(objCoreDataLayer.ExecuteScalar("pr_checkcustomer", new object[] { oCustomerBiz.Email,oCustomerBiz.Pwd}, false));
if (cnt > 0)
flg = true;
}
catch (Exception ex)
{
throw ex;
}
return flg;
}
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 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 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 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 int insertShippingAddress(CustomerBiz oCustomerBiz)
{
CDL.CoreDataLayer objCoreDataLayer = new CDL.CoreDataLayer();
int iCustomerAddID = 0;
try
{
iCustomerAddID = objCoreDataLayer.ExecuteIdentity("pr_InsShippingAdd", new object[] { oCustomerBiz.CustomerId,oCustomerBiz.ShippingName,oCustomerBiz.ShippingAddress,oCustomerBiz.ShippingPincode,oCustomerBiz.ShippingCity,oCustomerBiz.ShippingState,oCustomerBiz.ShippingMobile,oCustomerBiz.ShippingSaveName});
}
catch (Exception ex)
{
throw ex;
}
return iCustomerAddID;
}
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;
}
