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