Beispiel #1
0
        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;
        }
Beispiel #2
0
        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;
        }
Beispiel #3
0
        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;
        }
Beispiel #4
0
        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;
        }
Beispiel #5
0
        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;
        }
Beispiel #6
0
        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;
        }
Beispiel #7
0
        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;
        }
Beispiel #8
0
        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;
        }
Beispiel #9
0
        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;
        }
Beispiel #10
0
        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;
        }
Beispiel #11
0
        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;
        }
Beispiel #12
0
        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;
        }
Beispiel #13
0
        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;
        }
Beispiel #14
0
        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;
        }
Beispiel #15
0
        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;
        }
Beispiel #16
0
        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;
        }
Beispiel #17
0
        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;
        }
Beispiel #18
0
        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;
        }
Beispiel #19
0
        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;
        }
Beispiel #20
0
        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;
        }
Beispiel #21
0
        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;
        }
Beispiel #22
0
        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;
        }
Beispiel #23
0
        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;
        }
Beispiel #24
0
        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;
        }
Beispiel #25
0
        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;
        }
Beispiel #26
0
        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;
        }
Beispiel #27
0
        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;
        }
Beispiel #28
0
        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;
        }