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