public void ReduceCouponUsed(string couponCode,int storeID,int portalID,string userName)
{
CouponManageSQLProvider csm = new CouponManageSQLProvider();
csm.UpdateCouponUserRecord(couponCode, storeID, portalID, userName);
}
public void DeleteCouponUser(string couponUserID, int storeID, int portalID, string userName)
{
try
{
CouponManageSQLProvider cmSQLProvider = new CouponManageSQLProvider();
cmSQLProvider.DeleteCouponUser(couponUserID, storeID, portalID, userName);
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateCouponUser(int couponUserID, int couponStatusID, int storeID, int portalID, string cultureName)
{
try
{
CouponManageSQLProvider cmSQLProvider = new CouponManageSQLProvider();
cmSQLProvider.UpdateCouponUser(couponUserID, couponStatusID, storeID, portalID, cultureName);
}
catch (Exception ex)
{
throw ex;
}
}
public List<CouponUserInfo> GetCouponUserDetails(int offset, int limit, string couponCode, string userName, System.Nullable<int> couponStatusId, System.Nullable<DateTime> validFrom, System.Nullable<DateTime> validTo, int storeId, int portalId, string cultureName)
{
try
{
CouponManageSQLProvider cmSQLProvider = new CouponManageSQLProvider();
return cmSQLProvider.GetCouponUserDetails(offset, limit, couponCode, userName, couponStatusId, validFrom, validTo, storeId, portalId, cultureName);
}
catch (Exception ex)
{
throw ex;
}
}
public List<CouponUserListInfo> GetCouponUserList(int offset, int limit, int CouponID, string CouponCode, string UserName, System.Nullable<int> CouponStatusID, int StoreID, int PortalID, string CultureName)
{
try
{
CouponManageSQLProvider cmSQLProvider = new CouponManageSQLProvider();
return cmSQLProvider.GetCouponUserList(offset, limit, CouponID, CouponCode, UserName, CouponStatusID, StoreID, PortalID, CultureName);
}
catch (Exception ex)
{
throw ex;
}
}
public CouponVerificationInfo VerifyCouponCode(decimal totalCost, string couponCode, int storeID, int portalID, string userName, int appliedCount)
{
try
{
CouponManageSQLProvider cmSqlProvider = new CouponManageSQLProvider();
CouponVerificationInfo info = cmSqlProvider.VerifyUserCoupon(totalCost, couponCode, storeID, portalID, userName, appliedCount);
return info;
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateCouponUserRecord(string CouponCode, int storeID, int portalID, string userName)
{
try
{
CouponManageSQLProvider cmSQLProvider = new CouponManageSQLProvider();
cmSQLProvider.UpdateCouponUserRecord(CouponCode, storeID, portalID, userName);
}
catch (Exception ex)
{
throw ex;
}
}
public List<CouponPortalUserListInfo> GetPortalUsersByCouponID(int offset, int limit, int couponID, int storeID, int portalID, string customerName, string cultureName)
{
try
{
CouponManageSQLProvider cmSqlProvider = new CouponManageSQLProvider();
return cmSqlProvider.GetPortalUsersList(offset, limit, couponID, storeID, portalID, customerName, cultureName);
}
catch (Exception ex)
{
throw ex;
}
}
public List<CouponSettingKeyValueInfo> GetSettinKeyValueByCouponID(int couponID, int storeID, int portalID)
{
try
{
CouponManageSQLProvider cmSqlProvider = new CouponManageSQLProvider();
return cmSqlProvider.GetCouponSettingKeyValueInfo(couponID, storeID, portalID);
}
catch (Exception ex)
{
throw ex;
}
}
public List<CouponStatusInfo> GetCouponStatus()
{
try
{
CouponManageSQLProvider cmSqlProvider = new CouponManageSQLProvider();
return cmSqlProvider.BindCouponStatus();
}
catch (Exception ex)
{
throw ex;
}
}
public void AddUpdateCouponDetails(int couponID, int couponTypeID, string couponCode, string couponAmount, string validateFrom, string validateTo,
string isActive, int storeID, int portalID, string cultureName, string userName, string settingIDs, string settingValues,
string PortalUser_CustomerName, string PortalUser_EmailID, string PortalUser_UserName, string SenderEmail, string Subject, ArrayList MessageBody)
{
try
{
CouponManageSQLProvider cmSQLProvider = new CouponManageSQLProvider();
if (PortalUser_EmailID != "")
{
cmSQLProvider.SendCouponCodeEmail(SenderEmail, PortalUser_EmailID, Subject, MessageBody);
}
cmSQLProvider.AddUpdateCoupons(couponID, couponTypeID, couponCode, couponAmount, validateFrom, validateTo, isActive, storeID, portalID, cultureName, userName, settingIDs, settingValues, PortalUser_UserName);
}
catch (Exception ex)
{
throw ex;
}
}
public List<CouponInfo> GetCouponDetails(int offset, int limit, System.Nullable<int> couponTypeID, string couponCode, System.Nullable<DateTime> validateFrom, System.Nullable<DateTime> validateTo, int storeId, int portalId, string cultureName)
{
try
{
CouponManageSQLProvider cmSQLProvider = new CouponManageSQLProvider();
return cmSQLProvider.BindAllCouponDetails(offset, limit, couponTypeID, couponCode, validateFrom, validateTo, storeId, portalId, cultureName);
}
catch (Exception ex)
{
throw ex;
}
}