// public int InsertCoupon (IDbTransaction tran, string strCode, int iNumberOfMinutesGiven, // int iNumberOfCentsGiven, uint uiIdBookofCoupons, ref uint uiId) // { // CmpMoneyOffCouponsDB cmpCoupon = new CmpMoneyOffCouponsDB(); // uiId=cmpCoupon.GetMaximumPk(tran); // // return cmpCoupon.InsertCoupon( uiId, strCode, iNumberOfMinutesGiven, iNumberOfCentsGiven, uiIdBookofCoupons ); // // } public CmpMoneyOffCouponsDB.MoneyOffCouponsStates GetMoneyOffCouponState(string strCouponCode, ref DateTime dtStartDate, ref DateTime dtExpDate, ref int iNumberOfMinutesGiven, ref int iNumberOfCentsGiven, ref uint uiID) { CmpMoneyOffCouponsDB.MoneyOffCouponsStates result = CmpMoneyOffCouponsDB.MoneyOffCouponsStates.PendingActivation; dtStartDate = DateTime.MaxValue; dtExpDate = DateTime.MinValue; iNumberOfMinutesGiven = -1; iNumberOfCentsGiven = -1; uiID = 0; try { CmpMoneyOffCouponsDB cmp = new CmpMoneyOffCouponsDB(); DataTable dt = cmp.GetData(null, "COUP_CODE = @MONEYOFF_COUPON.COUP_CODE@", new object[] { strCouponCode }); if (dt.Rows.Count > 0) { CmpMoneyOffCouponsDB.MoneyOffCouponsStates state = (CmpMoneyOffCouponsDB.MoneyOffCouponsStates)Convert.ToInt32(dt.Rows[0]["COUP_STATE"]); uiID = Convert.ToUInt32(dt.Rows[0]["COUP_ID"]); if (dt.Rows[0]["COUP_START_DATE"] != DBNull.Value) { dtStartDate = Convert.ToDateTime(dt.Rows[0]["COUP_START_DATE"]); } if (dt.Rows[0]["COUP_EXP_DATE"] != DBNull.Value) { dtExpDate = Convert.ToDateTime(dt.Rows[0]["COUP_EXP_DATE"]); } if (dt.Rows[0]["COUP_DISCOUNT_TIME"] != DBNull.Value) { iNumberOfMinutesGiven = Convert.ToInt32(dt.Rows[0]["COUP_DISCOUNT_TIME"]); } if (dt.Rows[0]["COUP_DISCOUNT_MONEY"] != DBNull.Value) { iNumberOfCentsGiven = Convert.ToInt32(dt.Rows[0]["COUP_DISCOUNT_MONEY"]); } } } catch { } return(result); }
public MoneyOffCouponsResults IsMoneyOffCouponUsable(string strCouponCode, DateTime dtTime, ref int iNumberOfMinutesGiven, ref int iNumberOfCentsGiven, ref uint uiID) { MoneyOffCouponsResults result = MoneyOffCouponsResults.DontExist; iNumberOfMinutesGiven = -1; iNumberOfCentsGiven = -1; uiID = 0; try { CmpMoneyOffCouponsDB cmp = new CmpMoneyOffCouponsDB(); DataTable dt = cmp.GetData(null, "COUP_CODE = @MONEYOFF_COUPON.COUP_CODE@", new object[] { strCouponCode }); if (dt.Rows.Count > 0) { CmpMoneyOffCouponsDB.MoneyOffCouponsStates state = (CmpMoneyOffCouponsDB.MoneyOffCouponsStates)Convert.ToInt32(dt.Rows[0]["COUP_STATE"]); switch (state) { case CmpMoneyOffCouponsDB.MoneyOffCouponsStates.PendingActivation: result = MoneyOffCouponsResults.NotActived; break; case CmpMoneyOffCouponsDB.MoneyOffCouponsStates.Used: result = MoneyOffCouponsResults.AlreadyUsed; break; case CmpMoneyOffCouponsDB.MoneyOffCouponsStates.Cancelled: result = MoneyOffCouponsResults.Cancelled; break; case CmpMoneyOffCouponsDB.MoneyOffCouponsStates.Actived: { DateTime dtStartDate; DateTime dtExpDate; if (dt.Rows[0]["COUP_START_DATE"] != DBNull.Value) { dtStartDate = Convert.ToDateTime(dt.Rows[0]["COUP_START_DATE"]); } else { dtStartDate = DateTime.MaxValue; } if (dt.Rows[0]["COUP_EXP_DATE"] != DBNull.Value) { dtExpDate = Convert.ToDateTime(dt.Rows[0]["COUP_EXP_DATE"]); } else { dtExpDate = DateTime.MinValue; } if (dtTime > dtStartDate) { if (dtTime < dtExpDate) { result = MoneyOffCouponsResults.Usable; uiID = Convert.ToUInt32(dt.Rows[0]["COUP_ID"]); if (dt.Rows[0]["COUP_DISCOUNT_TIME"] != DBNull.Value) { iNumberOfMinutesGiven = Convert.ToInt32(dt.Rows[0]["COUP_DISCOUNT_TIME"]); } else { iNumberOfMinutesGiven = -1; } if (dt.Rows[0]["COUP_DISCOUNT_MONEY"] != DBNull.Value) { iNumberOfCentsGiven = Convert.ToInt32(dt.Rows[0]["COUP_DISCOUNT_MONEY"]); } else { iNumberOfCentsGiven = -1; } } else { result = MoneyOffCouponsResults.Expired; } } else { result = MoneyOffCouponsResults.NotStarted; } } break; } } } catch { } return(result); }