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