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; }