public JsonResult AddUpdateCode(AffiliationData cdata) { String res = ""; if (ModelState.IsValid) { if ((cdata.Redeemby >= DateTime.Now && cdata.Redeemby != null) || cdata.Redeemby == null) { try { String Code = cdata.Code.Trim(); var couponOptions = new StripeCouponCreateOptions(); couponOptions.Id = Code; couponOptions.Duration = cdata.Duration == 0 ? "once" : "forever"; couponOptions.MaxRedemptions = cdata.Maxredeem; if (cdata.Redeemby != null) { couponOptions.RedeemBy = Convert.ToDateTime(cdata.Redeemby).AddMinutes(-1).AddDays(1); } if (cdata.Amount == null || cdata.Amount == 0) { couponOptions.PercentOff = cdata.Percent; } else { couponOptions.AmountOff = (int)cdata.Amount * 100; couponOptions.Currency = "usd"; } StripeHelper.CreateCoupon(couponOptions); var userid = Convert.ToInt32(Session["AdminUserID"]); res = adata.AddUpdateCouponData(Code, cdata.Duration, cdata.Amount, cdata.Percent, cdata.Maxredeem, cdata.Redeemby, userid); } catch (Exception ex) { res = ex.Message; } } else { res = "Redeemby must be greater than current date."; } } else { res = "Failed!"; } return(new JsonResult { Data = res, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public AffiliationData getAffiliation(string affiliation_code) { ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); oracleObj.SelectCommand = "Select * From AFFILIATION Where AFFILIATION_CODE='" + affiliation_code + "'"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); AffiliationData affiliation_data = new AffiliationData(); foreach (DataRowView rowData in allData) { affiliation_data.Affiliation_Code = rowData["AFFILIATION_CODE"].ToString(); affiliation_data.Affiliation_Thai = rowData["AFFILIATION_THAINAME"].ToString(); affiliation_data.Affiliation_Eng = rowData["AFFILIATION_ENGNAME"].ToString(); affiliation_data.Affiliation_Type = rowData["AFFILIATION_TYPE"].ToString(); } return(affiliation_data); }
public List <AffiliationData> getAffiliation() { List <AffiliationData> affiliationData = new List <AffiliationData>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); oracleObj.SelectCommand = "Select * From AFFILIATION Order By AFFILIATION_CODE"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { AffiliationData affiliation_data = new AffiliationData(); affiliation_data.Affiliation_Code = rowData["AFFILIATION_CODE"].ToString(); affiliation_data.Affiliation_Thai = rowData["AFFILIATION_THAINAME"].ToString(); affiliation_data.Affiliation_Eng = rowData["AFFILIATION_ENGNAME"].ToString(); affiliation_data.Affiliation_Type = rowData["AFFILIATION_TYPE"].ToString(); affiliationData.Add(affiliation_data); } return(affiliationData); }