/// <summary>
/// This function needs to process and returned message from the bank.
/// Thsi processing may vary widely between banks.
/// </summary>
/// <param name="context"></param>
public void ProcessRequest(HttpContext context)
{
var modCtrl = new NBrightBuyController();
var info = ProviderUtils.GetProviderSettings("DnnCMolliepayment");
try
{
var debugMode = info.GetXmlPropertyBool("genxml/checkbox/debugmode");
var debugMsg = "START CALL" + DateTime.Now.ToString("s") + " </br>";
debugMsg += "returnmessage: " + context.Request.Form.Get("returnmessage") + "</br>";
if (debugMode)
{
info.SetXmlProperty("genxml/debugmsg", debugMsg);
modCtrl.Update(info);
}
debugMsg = "DnnCMollie DEBUG: " + DateTime.Now.ToString("s") + " </br>";
var rtnMsg = "version=2" + Environment.NewLine + "cdr=1";
// ------------------------------------------------------------------------
// In this case the payment provider passes back data via form POST.
// Get the data we need.
//string returnmessage = "";
//int DnnCMollieStoreOrderID = 0;
//string DnnCMollieCartID = "";
//string DnnCMollieClientLang = "";
var testMode = info.GetXmlPropertyBool("genxml/checkbox/testmode");
var testApiKey = info.GetXmlProperty("genxml/textbox/testapikey");
var liveApiKey = info.GetXmlProperty("genxml/textbox/liveapikey");
var nbi = new NBrightInfo();
var paymentMethod = nbi.GetXmlProperty("genxml/textbox/paymentmethod");
var paymentBank = nbi.GetXmlProperty("genxml/textbox/paymentbank");
var apiKey = testApiKey;
if (!testMode)
{
apiKey = liveApiKey;
}
string molliePaymentId = context.Request.Form["id"];
int oId = -1;
int.TryParse(context.Request.Form["orderid"], out oId);
if (oId <= 0)
{
int.TryParse(context.Request.Form["ordid"], out oId);
}
MollieClient mollieClient = new MollieClient();
mollieClient.setApiKey(apiKey);
PaymentStatus paymentStatus = mollieClient.GetStatus(molliePaymentId);
var orderid = paymentStatus.metadata;
var nbInfo = modCtrl.Get(Convert.ToInt32(orderid), "ORDER");
if (nbi != null)
{
var orderData = new OrderData(nbInfo.ItemID);
switch (paymentStatus.status.Value)
{
case Status.paid:
orderData.PaymentOk();
break;
case Status.cancelled:
//set order status to Cancelled
orderData.PaymentOk("030");
break;
case Status.failed:
//set order status to payment failed
orderData.PaymentFail();
break;
case Status.open:
//set order status to Waiting for payment
orderData.PaymentOk("060");
break;
case Status.pending:
//set order status to Waiting for payment
orderData.PaymentOk("060");
break;
case Status.expired:
//set order status to Incomplete
orderData.PaymentOk("010");
break;
}
var rtnStr = paymentStatus.status.Value + "<br/> id = " + molliePaymentId;
rtnStr += "<br/> orderId = " + orderid;
rtnStr += "<br/> status = " + orderData.OrderStatus;
File.WriteAllText(PortalSettings.Current.HomeDirectoryMapPath + "\\debug_DnnC_IPN_return.html", rtnStr.ToString());
}
}
catch { }
} //end
/// <summary>
/// This function needs to process and returned message from the bank.
/// This processing may vary widely between banks.
/// </summary>
/// <param name="context"></param>
public void ProcessRequest(HttpContext context)
{
var info = ProviderUtils.GetProviderSettings();
var objEventLog = new EventLogController();
PortalSettings portalsettings = new PortalSettings();
try
{
var debugMode = info.GetXmlPropertyBool("genxml/checkbox/debugmode");
var debugMsg = "START CALL" + DateTime.Now.ToString("s") + " </br>";
var rtnMsg = "version=2" + Environment.NewLine + "cdr=1";
var orderid = Utils.RequestQueryStringParam(context, "orderid");
debugMsg += "orderid: " + orderid + "</br>";
if (Utils.IsNumeric(orderid))
{
var orderData = new OrderData(Convert.ToInt32(orderid));
PaymentResponse paymentClientResult = ProviderUtils.GetOrderPaymentResponse(orderData, "OS_MollieNotify.ProcessRequest");
objEventLog.AddLog("Mollie Webhook call for orderid: " + orderid, "Status: " + paymentClientResult.Status, portalsettings, -1, EventLogController.EventLogType.ADMIN_ALERT);
//Waiting for Payment 060
//Payment OK 040
//Incomplete 010
//Cancelled 030
switch (paymentClientResult.Status.ToString().ToLower())
{
case "paid":
orderData.PaymentOk("040", true);
rtnMsg = "OK";
break;
case "failed":
orderData.PaymentFail("010");
rtnMsg = "OK";
break;
case "canceled":
orderData.PaymentFail("030");
rtnMsg = "OK";
break;
case "expired":
orderData.PaymentFail("010");
rtnMsg = "OK";
break;
default:
orderData.PaymentFail("010");
rtnMsg = "OK";
break;
}
}
if (debugMode)
{
debugMsg += "Return Message: " + rtnMsg;
info.SetXmlProperty("genxml/debugmsg", debugMsg);
var modCtrl = new NBrightBuyController();
modCtrl.Update(info);
}
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Write(rtnMsg);
HttpContext.Current.Response.ContentType = "text/plain";
HttpContext.Current.Response.CacheControl = "no-cache";
HttpContext.Current.Response.Expires = -1;
HttpContext.Current.Response.End();
}
catch (Exception ex)
{
objEventLog.AddLog("Mollie Webhook call failed", ex.Message + " " + ex.InnerException, portalsettings, -1, EventLogController.EventLogType.ADMIN_ALERT);
if (!ex.ToString().StartsWith("System.Threading.ThreadAbortException")) // we expect a thread abort from the End response.
{
info.SetXmlProperty("genxml/debugmsg", "OS_Mollie ERROR: " + ex.ToString());
var modCtrl = new NBrightBuyController();
modCtrl.Update(info);
}
}
}
/// <summary>
/// This function needs to process and returned message from the bank.
/// Thsi processing may vary widely between banks.
/// </summary>
/// <param name="context"></param>
public void ProcessRequest(HttpContext context)
{
var modCtrl = new NBrightBuyController();
var info = modCtrl.GetPluginSinglePageData("OS_Sipspayment", "OS_SipsPAYMENT", Utils.GetCurrentCulture());
try
{
var debugMode = info.GetXmlPropertyBool("genxml/checkbox/debugmode");
var rtnMsg = "version=2" + Environment.NewLine + "cdr=1";
// ------------------------------------------------------------------------
// In this case the payment provider passes back data via form POST.
// Get the data we need.
string returnmessage = "";
int NBrightBuySipsApiStoreOrderID = 0;
string NBrightBuySipsApiCartID = "";
string NBrightBuySipsApiClientLang = "";
if ((context.Request.Form.Get("DATA") != null))
{
returnmessage = "message=" + context.Request.Form.Get("DATA");
if (!string.IsNullOrEmpty(returnmessage))
{
// ------------------------------------------------------------------------
//var settings = ProviderUtils.GetProviderSettings("NBrightBuySipsApipayment");
var controlMapPath = HttpContext.Current.Server.MapPath("/DesktopModules/NBright/OS_Sips");
var pathfile = "pathfile=" + PortalSettings.Current.HomeDirectoryMapPath.TrimEnd('\\') + "\\" + info.GetXmlProperty("genxml/textbox/paramfolder") + "\\pathfile";
var exepath = controlMapPath.TrimEnd('\\') + "\\sipsbin\\response.exe";
var sipsdata = ProviderUtils.CallSipsExec(exepath, pathfile + " " + returnmessage);
if (debugMode)
{
info.SetXmlProperty("genxml/debugmsg", sipsdata);
modCtrl.Update(info);
}
var tableau = sipsdata.Split('!');
string code = tableau[1];
string error_msg = tableau[2];
if (string.IsNullOrEmpty(code) | code == "-1")
{
info.SetXmlProperty("genxml/debugmsg", error_msg);
modCtrl.Update(info);
}
else
{
// L'execution s'est bien deroulee
// recuperation des donnees de la reponse
string merchant_id = tableau[3];
string merchant_country = tableau[4];
string amount = tableau[5];
string transaction_id = tableau[6];
string payment_means = tableau[7];
string transmission_date = tableau[8];
string payment_time = tableau[9];
string payment_date = tableau[10];
string response_code = tableau[11];
string payment_certificate = tableau[12];
string authorisation_id = tableau[13];
string currency_code = tableau[14];
string card_number = tableau[15];
string cvv_flag = tableau[16];
string cvv_response_code = tableau[17];
string bank_response_code = tableau[18];
string complementary_code = tableau[19];
string complementary_info = tableau[20];
string return_context = tableau[21];
string caddie = tableau[22];
string receipt_complement = tableau[23];
string merchant_language = tableau[24];
string language = tableau[25];
string customer_id = tableau[26];
string order_id = tableau[27];
string customer_email = tableau[28];
string customer_ip_address = tableau[29];
string capture_day = tableau[30];
string capture_mode = tableau[31];
string data = tableau[32];
// Sauvegarde des champs de la reponse
string Lmsg = null;
Lmsg = merchant_id + ",";
Lmsg += merchant_country + ",";
Lmsg += amount + ",";
Lmsg += transaction_id + ",";
Lmsg += transmission_date + ",";
Lmsg += payment_means + ",";
Lmsg += payment_time + ",";
Lmsg += payment_date + ",";
Lmsg += response_code + ",";
Lmsg += payment_certificate + ",";
Lmsg += authorisation_id + ",";
Lmsg += currency_code + ",";
Lmsg += card_number + ",";
Lmsg += cvv_flag + ",";
Lmsg += cvv_response_code + ",";
Lmsg += bank_response_code + ",";
Lmsg += complementary_code + ",";
Lmsg += complementary_info + ",";
Lmsg += return_context + ",";
Lmsg += caddie + ",";
Lmsg += receipt_complement + ",";
Lmsg += merchant_language + ",";
Lmsg += language + ",";
Lmsg += customer_id + ",";
Lmsg += order_id + ",";
Lmsg += customer_email + ",";
Lmsg += customer_ip_address + ",";
Lmsg += capture_day + ",";
Lmsg += capture_mode + ",";
Lmsg += data + ",";
//update database stuff
if (Utils.IsNumeric(order_id))
{
var orderData = new OrderData(Convert.ToInt32(order_id));
orderData.AddAuditMessage(Lmsg, "payment", "sipsapi", info.GetXmlProperty("genxml/checkbox/debugmode"));
// Status return "00" is payment successful
if (response_code == "00")
{
//set order status to Payed
orderData.PaymentOk();
}
else
{
orderData.PaymentFail();
}
}
}
}
}
}
catch (Exception ex)
{
if (!ex.ToString().StartsWith("System.Threading.ThreadAbortException")) // we expect a thread abort from the End response.
{
info.SetXmlProperty("genxml/debugmsg", "NBrightBuySipsApi ERROR: " + ex.ToString());
modCtrl.Update(info);
}
}
}
private static String GetOrderListData(Dictionary <String, String> settings, bool paging = true)
{
if (UserController.Instance.GetCurrentUserInfo().UserID <= 0)
{
return("");
}
var strOut = "";
if (!settings.ContainsKey("selecteduserid"))
{
settings.Add("selecteduserid", "");
}
if (!settings.ContainsKey("themefolder"))
{
settings.Add("themefolder", "");
}
if (!settings.ContainsKey("userid"))
{
settings.Add("userid", "-1");
}
if (!settings.ContainsKey("razortemplate"))
{
settings.Add("razortemplate", "");
}
if (!settings.ContainsKey("returnlimit"))
{
settings.Add("returnlimit", "0");
}
if (!settings.ContainsKey("pagenumber"))
{
settings.Add("pagenumber", "0");
}
if (!settings.ContainsKey("pagesize"))
{
settings.Add("pagesize", "0");
}
if (!settings.ContainsKey("searchtext"))
{
settings.Add("searchtext", "");
}
if (!settings.ContainsKey("dtesearchdatefrom"))
{
settings.Add("dtesearchdatefrom", "");
}
if (!settings.ContainsKey("dtesearchdateto"))
{
settings.Add("dtesearchdateto", "");
}
if (!settings.ContainsKey("searchorderstatus"))
{
settings.Add("searchorderstatus", "");
}
if (!settings.ContainsKey("portalid"))
{
settings.Add("portalid", PortalSettings.Current.PortalId.ToString("")); // aways make sure we have portalid in settings
}
if (!Utils.IsNumeric(settings["userid"]))
{
settings["pagenumber"] = "1";
}
if (!Utils.IsNumeric(settings["pagenumber"]))
{
settings["pagenumber"] = "1";
}
if (!Utils.IsNumeric(settings["pagesize"]))
{
settings["pagesize"] = "20";
}
if (!Utils.IsNumeric(settings["returnlimit"]))
{
settings["returnlimit"] = "50";
}
var themeFolder = settings["themefolder"];
var razortemplate = settings["razortemplate"];
var returnLimit = Convert.ToInt32(settings["returnlimit"]);
var pageNumber = Convert.ToInt32(settings["pagenumber"]);
var pageSize = Convert.ToInt32(settings["pagesize"]);
var portalId = Convert.ToInt32(settings["portalid"]);
var userid = settings["userid"];
var selecteduserid = settings["selecteduserid"];
var searchText = settings["searchtext"];
var searchdatefrom = settings["dtesearchdatefrom"];
var searchdateto = settings["dtesearchdateto"];
var searchorderstatus = settings["searchorderstatus"];
var filter = "";
if (searchText != "")
{
filter += " and ( (([xmldata].value('(genxml/billaddress/genxml/textbox/firstname)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/billaddress/genxml/textbox/lastname)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/billaddress/genxml/textbox/unit)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/billaddress/genxml/textbox/street)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/billaddress/genxml/textbox/postalcode)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/billaddress/genxml/textbox/email)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/shipaddress/genxml/textbox/firstname)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/shipaddress/genxml/textbox/lastname)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/shipaddress/genxml/textbox/unit)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/shipaddress/genxml/textbox/street)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/shipaddress/genxml/textbox/postalcode)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/shipaddress/genxml/textbox/email)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/productrefs)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/ordernumber)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai )) ) ";
}
if (Utils.IsNumeric(selecteduserid))
{
filter += " and (NB1.UserId = " + selecteduserid + ") ";
}
if (searchdateto != "" && searchdatefrom != "")
{
filter += " and ( ([xmldata].value('(genxml/createddate)[1]', 'datetime') >= convert(datetime,'" + searchdatefrom + "') ) and ([xmldata].value('(genxml/createddate)[1]', 'datetime') <= convert(datetime,'" + searchdateto + "') ) ) ";
}
if (searchdateto == "" && searchdatefrom != "")
{
filter += " and ([xmldata].value('(genxml/createddate)[1]', 'datetime') >= convert(datetime,'" + searchdatefrom + "') ) ";
}
if (searchdateto != "" && searchdatefrom == "")
{
filter += " and ([xmldata].value('(genxml/createddate)[1]', 'datetime') <= convert(datetime,'" + searchdateto + "') ) ";
}
if (searchorderstatus != "")
{
filter += " and ([xmldata].value('(genxml/dropdownlist/orderstatus)[1]', 'nvarchar(max)') = '" + searchorderstatus + "') ";
}
// check for user or manager.
if (!NBrightBuyUtils.CheckRights())
{
filter += " and ( userid = " + UserController.Instance.GetCurrentUserInfo().UserID + ") ";
}
var recordCount = 0;
if (themeFolder == "")
{
themeFolder = StoreSettings.Current.ThemeFolder;
if (settings.ContainsKey("themefolder"))
{
themeFolder = settings["themefolder"];
}
}
var objCtrl = new NBrightBuyController();
if (paging) // get record count for paging
{
if (pageNumber == 0)
{
pageNumber = 1;
}
if (pageSize == 0)
{
pageSize = 20;
}
// get only entity type required
recordCount = objCtrl.GetListCount(PortalSettings.Current.PortalId, -1, "ORDER", filter);
}
var orderby = " order by [XMLData].value('(genxml/createddate)[1]','datetime') DESC, ModifiedDate DESC ";
var list = objCtrl.GetList(portalId, -1, "ORDER", filter, orderby, 0, pageNumber, pageSize, recordCount);
var passSettings = settings;
foreach (var s in StoreSettings.Current.Settings()) // copy store setting, otherwise we get a byRef assignement
{
if (passSettings.ContainsKey(s.Key))
{
passSettings[s.Key] = s.Value;
}
else
{
passSettings.Add(s.Key, s.Value);
}
}
strOut = NBrightBuyUtils.RazorTemplRenderList(razortemplate, 0, "", list, "/DesktopModules/NBright/NBrightBuy", themeFolder, Utils.GetCurrentCulture(), passSettings);
// add paging if needed
if (paging && (recordCount > pageSize))
{
var pg = new NBrightCore.controls.PagingCtrl();
strOut += pg.RenderPager(recordCount, pageSize, pageNumber);
}
return(strOut);
}
public static String GetBankRemotePost(OrderData orderData)
{
var objCtrl = new NBrightBuyController();
var info = objCtrl.GetPluginSinglePageData("OS_WorldPaypayment", "OS_WorldPayPAYMENT", orderData.Lang);
var MD5secretKey = info.GetXmlProperty("genxml/textbox/secretkey");
var installid = info.GetXmlPropertyInt("genxml/textbox/installid");
var request = new HostedTransactionRequest();
var appliedtotal = orderData.PurchaseInfo.GetXmlPropertyRaw("genxml/appliedtotal");
request.amount = appliedtotal;
request.currency = info.GetXmlProperty("genxml/textbox/currencycode");
request.testMode = 0; // Not sure what this should be. Only example I found was 100 for test system??
request.instId = installid;
request.cartId = orderData.GetInfo().ItemID.ToString();
var postUrl = info.GetXmlProperty("genxml/textbox/liveurl");
if (info.GetXmlPropertyBool("genxml/checkbox/preproduction"))
{
request.testMode = 100;
postUrl = info.GetXmlProperty("genxml/textbox/testurl");
}
var requestInputs = request.ToNameValueCollection();
var rPost = new RemotePostPay();
rPost.Url = postUrl;
var callbackhashInputs = new StringBuilder();
callbackhashInputs.Append(MD5secretKey);
callbackhashInputs.Append(":");
callbackhashInputs.Append(request.currency);
callbackhashInputs.Append(":");
callbackhashInputs.Append(request.cartId);
callbackhashInputs.Append(":");
callbackhashInputs.Append(appliedtotal);
var signaturehashInputs = new StringBuilder();
signaturehashInputs.Append(MD5secretKey);
signaturehashInputs.Append(":");
signaturehashInputs.Append(request.currency);
signaturehashInputs.Append(":");
signaturehashInputs.Append(request.cartId);
signaturehashInputs.Append(":");
signaturehashInputs.Append(appliedtotal);
byte[] callbackhashDigest = new MD5CryptoServiceProvider().ComputeHash(StringToByteArray(callbackhashInputs.ToString()));
byte[] signaturehashDigest = new MD5CryptoServiceProvider().ComputeHash(StringToByteArray(signaturehashInputs.ToString()));
rPost.Add("signature", ByteArrayToHexString(signaturehashDigest));
rPost.Add("MC_callbacksignature", ByteArrayToHexString(callbackhashDigest));
// add the rest of the form variables
foreach (var k in requestInputs.AllKeys)
{
rPost.Add(k, requestInputs.GetValues(k)[0]);
}
//Build the re-direct html
var rtnStr = "";
rtnStr = rPost.GetPostHtml();
if (info.GetXmlPropertyBool("genxml/checkbox/debugmode"))
{
File.WriteAllText(PortalSettings.Current.HomeDirectoryMapPath + "\\debug_OS_WorldPaypost.html", rtnStr + " signaturehashInputs:" + signaturehashInputs + " request.amount:" + request.amount + " appliedtotal:" + appliedtotal);
}
return(rtnStr);
}
public override NBrightInfo AfterProductSave(NBrightInfo nbrightInfo)
{
var promoid = nbrightInfo.GetXmlPropertyInt("genxml/hidden/promoid"); // legacy promo flag
if (nbrightInfo.GetXmlPropertyBool("genxml/hidden/promoflag") || promoid > 0)
{
var prdData = ProductUtils.GetProductData(nbrightInfo.ItemID, nbrightInfo.PortalId, nbrightInfo.Lang);
// loop on models to get all promoid at model level.
var modelpromoids = new List <int>();
if (promoid > 0)
{
modelpromoids.Add(promoid);
}
var lp = 1;
foreach (var m in prdData.Models)
{
var modelPromoId = prdData.Info.GetXmlPropertyInt("genxml/promo/salepriceid" + lp);
if (modelPromoId > 0 && !modelpromoids.Contains(modelPromoId))
{
modelpromoids.Add(modelPromoId);
}
modelPromoId = prdData.Info.GetXmlPropertyInt("genxml/promo/dealercostid" + lp);
if (modelPromoId > 0 && !modelpromoids.Contains(modelPromoId))
{
modelpromoids.Add(modelPromoId);
}
modelPromoId = prdData.Info.GetXmlPropertyInt("genxml/promo/dealersaleid" + lp);
if (modelPromoId > 0 && !modelpromoids.Contains(modelPromoId))
{
modelpromoids.Add(modelPromoId);
}
lp += 1;
}
// multiple promotions, remove from each model.
foreach (var mpid in modelpromoids)
{
var objCtrl = new NBrightBuyController();
var promoData = objCtrl.GetData(mpid);
var catgroupid = promoData.GetXmlPropertyInt("genxml/dropdownlist/catgroupid");
var propgroupid = promoData.GetXmlPropertyInt("genxml/dropdownlist/propgroupid");
var propbuygroupid = promoData.GetXmlPropertyInt("genxml/dropdownlist/propbuy");
var propapplygroupid = promoData.GetXmlPropertyInt("genxml/dropdownlist/propapply");
var removepromo = true;
foreach (var c in prdData.GetCategories(nbrightInfo.PortalId))
{
if (c.categoryid == catgroupid)
{
removepromo = false;
}
if (c.categoryid == propgroupid)
{
removepromo = false;
}
if (c.categoryid == propbuygroupid)
{
removepromo = false;
}
if (c.categoryid == propapplygroupid)
{
removepromo = false;
}
}
if (removepromo)
{
PromoUtils.RemoveProductPromoData(nbrightInfo.PortalId, nbrightInfo.ItemID, mpid);
ProductUtils.RemoveProductDataCache(nbrightInfo.PortalId, nbrightInfo.ItemID);
}
}
}
return(nbrightInfo);
}
public static string CalcGroupPromoItem(NBrightInfo p)
{
var objCtrl = new NBrightBuyController();
var typeselect = p.GetXmlProperty("genxml/radiobuttonlist/typeselect");
var catgroupid = p.GetXmlProperty("genxml/dropdownlist/catgroupid");
var propgroupid = p.GetXmlProperty("genxml/dropdownlist/propgroupid");
var promoname = p.GetXmlProperty("genxml/textbox/name");
var amounttype = p.GetXmlProperty("genxml/radiobuttonlist/amounttype");
var amount = p.GetXmlPropertyDouble("genxml/textbox/amount");
var validfrom = p.GetXmlProperty("genxml/textbox/validfrom");
var validuntil = p.GetXmlProperty("genxml/textbox/validuntil");
var overwrite = p.GetXmlPropertyBool("genxml/checkbox/overwrite");
var disabled = p.GetXmlPropertyBool("genxml/checkbox/disabled");
var lastcalculated = p.GetXmlProperty("genxml/hidden/lastcalculated");
if (!disabled)
{
var runcalc = true;
if (Utils.IsDate(lastcalculated))
{
if (Convert.ToDateTime(lastcalculated) >= p.ModifiedDate)
{
runcalc = false; // only run if changed
}
if (DateTime.Now.Date > Convert.ToDateTime(lastcalculated).Date.AddDays(1))
{
runcalc = true; // every day just after midnight. (for site performace)
}
}
if (Utils.IsDate(validuntil))
{
if (DateTime.Now.Date > Convert.ToDateTime(validuntil))
{
runcalc = true; // need to disable the promo if passed date
}
}
if ((runcalc) && Utils.IsDate(validfrom) && Utils.IsDate(validuntil))
{
var dteF = Convert.ToDateTime(validfrom).Date;
var dteU = Convert.ToDateTime(validuntil).Date;
CategoryData gCat;
var groupid = catgroupid;
if (typeselect != "cat")
{
groupid = propgroupid;
}
gCat = CategoryUtils.GetCategoryData(groupid, Utils.GetCurrentCulture());
var prdList = gCat.GetAllArticles();
foreach (var prd in prdList)
{
if (DateTime.Now.Date >= dteF && DateTime.Now.Date <= dteU)
{
// CALC Promo
CalcProductSalePrice(p.PortalId, prd.ParentItemId, amounttype, amount, promoname, p.ItemID, overwrite, dteF, dteU);
}
if (DateTime.Now.Date > dteU)
{
// END Promo
RemoveProductPromoData(p.PortalId, prd.ParentItemId, p.ItemID);
p.SetXmlProperty("genxml/checkbox/disabled", "True");
objCtrl.Update(p);
}
ProductUtils.RemoveProductDataCache(p.PortalId, prd.ParentItemId);
}
p.SetXmlProperty("genxml/hidden/lastcalculated", DateTime.Now.AddSeconds(10).ToString("O")); // Add 10 sec to time so we don't get exact clash with update time.
objCtrl.Update(p);
}
}
return("OK");
}
public static string CalcMultiBuyPromoItem(NBrightInfo p)
{
var objCtrl = new NBrightBuyController();
var propgroupid = p.GetXmlPropertyInt("genxml/dropdownlist/propbuy");
var promoname = p.GetXmlProperty("genxml/textbox/name");
var validfrom = p.GetXmlProperty("genxml/textbox/validfrom");
var validuntil = p.GetXmlProperty("genxml/textbox/validuntil");
var disabled = p.GetXmlPropertyBool("genxml/checkbox/disabled");
var lastcalculated = p.GetXmlProperty("genxml/hidden/lastcalculated");
if (!disabled)
{
var portalsettings = NBrightDNN.DnnUtils.GetPortalSettings(p.PortalId);
var lang = portalsettings.DefaultLanguage;
var runcalc = true;
if (Utils.IsDate(lastcalculated))
{
if (Convert.ToDateTime(lastcalculated) >= p.ModifiedDate)
{
runcalc = false; // only run if changed
}
if (DateTime.Now.Date > Convert.ToDateTime(lastcalculated).Date.AddDays(1))
{
runcalc = true; // every day just after midnight. (for site performace)
}
}
if (Utils.IsDate(validuntil))
{
if (DateTime.Now.Date > Convert.ToDateTime(validuntil))
{
runcalc = true; // need to disable the promo if passed date
}
}
if ((runcalc) && Utils.IsDate(validfrom) && Utils.IsDate(validuntil))
{
var dteF = Convert.ToDateTime(validfrom).Date;
var dteU = Convert.ToDateTime(validuntil).Date;
CategoryData gCat;
gCat = CategoryUtils.GetCategoryData(propgroupid, lang);
var prdList = gCat.GetAllArticles();
foreach (var prd in prdList)
{
if (DateTime.Now.Date >= dteF && DateTime.Now.Date <= dteU)
{
// CALC Promo
FlagProductMultiBuy(p.PortalId, prd.ParentItemId, promoname, p.ItemID, "PROMOMULTIBUY", dteF, dteU);
}
if (DateTime.Now.Date > dteU)
{
// END Promo
RemoveProductPromoData(p.PortalId, prd.ParentItemId, p.ItemID);
p.SetXmlProperty("genxml/checkbox/disabled", "True");
objCtrl.Update(p);
}
ProductUtils.RemoveProductDataCache(p.PortalId, prd.ParentItemId);
var productData = ProductUtils.GetProductData(prd.ParentItemId, p.PortalId, lang);
productData.Save(); // recalc any new prices.
}
p.SetXmlProperty("genxml/hidden/lastcalculated", DateTime.Now.AddSeconds(10).ToString("O")); // Add 10 sec to time so we don't get exact clash with update time.
objCtrl.Update(p);
}
}
return("OK");
}
public static void RemoveProductPromoData(int portalid, int productId, int promoid)
{
var cultureList = DnnUtils.GetCultureCodeList(portalid);
var objCtrl = new NBrightBuyController();
var prdData = objCtrl.GetData(productId);
// (legacy) remove fields for old promo
var currentpromoid = prdData.GetXmlPropertyInt("genxml/hidden/promoid");
if (currentpromoid != 0) //
{
prdData.RemoveXmlNode("genxml/hidden/promotype");
prdData.RemoveXmlNode("genxml/hidden/promoname");
prdData.RemoveXmlNode("genxml/hidden/promoid");
prdData.RemoveXmlNode("genxml/hidden/promocalcdate");
prdData.RemoveXmlNode("genxml/hidden/datefrom");
prdData.RemoveXmlNode("genxml/hidden/dateuntil");
}
// remove any sale price amounts that may have been added by group promotion.
var l = prdData.XMLDoc.SelectNodes("genxml/models/genxml");
if (l != null)
{
var promoexist = false;
var lp = 1;
foreach (XmlNode nod in l)
{
var promodealersaleid = prdData.GetXmlPropertyInt("genxml/promo/dealersaleid" + lp);
var promosalepriceid = prdData.GetXmlPropertyInt("genxml/promo/salepriceid" + lp);
var promodealercostid = prdData.GetXmlPropertyInt("genxml/promo/dealercostid" + lp);
if (promosalepriceid == promoid)
{
prdData.SetXmlPropertyDouble("genxml/models/genxml[" + lp + "]/textbox/txtsaleprice", "0");
prdData.RemoveXmlNode("genxml/promo/salepriceid" + lp);
promosalepriceid = 0;
}
if (promodealercostid == promoid)
{
prdData.SetXmlPropertyDouble("genxml/models/genxml[" + lp + "]/textbox/txtdealercost", "0");
prdData.RemoveXmlNode("genxml/promo/dealercostid" + lp);
promodealercostid = 0;
}
if (promodealersaleid == promoid)
{
prdData.SetXmlPropertyDouble("genxml/models/genxml[" + lp + "]/textbox/txtdealersale", "0");
prdData.RemoveXmlNode("genxml/promo/dealersaleid" + lp);
promodealersaleid = 0;
}
if (promodealersaleid > 0 || promosalepriceid > 0 || promodealercostid > 0)
{
promoexist = true;
}
lp += 1;
}
if (!promoexist)
{
prdData.RemoveXmlNode("genxml/hidden/promoflag");
prdData.RemoveXmlNode("genxml/promo");
}
// promo description only at product level, thi sis not correct for multiple price promoiton.
// but this is a rare use case issue.
foreach (var lang in cultureList)
{
var prdDataLang = objCtrl.GetDataLang(productId, lang);
if (prdDataLang != null)
{
prdDataLang.RemoveXmlNode("genxml/hidden/promodesc");
objCtrl.Update(prdDataLang);
}
}
}
objCtrl.Update(prdData);
}
private static void CalcProductSalePrice(int portalid, int productId, string amounttype, double amount, int promoid, int whichprice, bool overwrite)
{
var cultureList = DnnUtils.GetCultureCodeList(portalid);
var objCtrl = new NBrightBuyController();
var prdData = objCtrl.GetData(productId);
var nodList = prdData.XMLDoc.SelectNodes("genxml/models/genxml");
if (nodList != null)
{
prdData.SetXmlProperty("genxml/hidden/promoflag", "True"); // set flag, so we can identify products with promo for product save event removal.
if (prdData.GetXmlProperty("genxml/promo") == "")
{
prdData.SetXmlProperty("genxml/promo", "");
}
var lp = 1;
foreach (XmlNode nod in nodList)
{
var currentpromoid = GetCurrentPromoId(prdData, whichprice, lp);
var nbi = new NBrightInfo();
nbi.XMLData = nod.OuterXml;
var disablesale = nbi.GetXmlPropertyBool("genxml/checkbox/chkdisablesale");
var disabledealer = nbi.GetXmlPropertyBool("genxml/checkbox/chkdisabledealer");
var unitcost = nbi.GetXmlPropertyDouble("genxml/textbox/txtunitcost");
var dealercost = nbi.GetXmlPropertyDouble("genxml/textbox/txtdealercost");
Double newamt = 0;
Double newdealersaleamt = 0;
Double newdealeramt = 0;
if (amounttype == "1")
{
newamt = unitcost - amount;
newdealersaleamt = dealercost - amount;
}
else
{
newamt = unitcost - ((unitcost / 100) * amount);
newdealersaleamt = dealercost - ((dealercost / 100) * amount);
}
newdealeramt = newamt;
if (newamt < 0)
{
newamt = 0;
}
if (newdealersaleamt < 0)
{
newdealersaleamt = 0;
}
var currentprice = GetCurrentPromoPrice(prdData, whichprice, lp);
if (!overwrite)
{
if (currentprice == 0)
{
overwrite = true;
}
if (currentpromoid == promoid)
{
overwrite = true;
}
}
if (overwrite)
{
switch (whichprice)
{
case 1:
prdData.SetXmlPropertyDouble("genxml/models/genxml[" + lp + "]/textbox/txtsaleprice", newamt);
prdData.SetXmlProperty("genxml/promo/salepriceid" + lp, promoid.ToString());
break;
case 2:
prdData.SetXmlPropertyDouble("genxml/models/genxml[" + lp + "]/textbox/txtdealercost", newdealeramt);
prdData.SetXmlProperty("genxml/promo/dealercostid" + lp, promoid.ToString());
break;
case 3:
prdData.SetXmlPropertyDouble("genxml/models/genxml[" + lp + "]/textbox/txtdealersale", newdealersaleamt);
prdData.SetXmlProperty("genxml/promo/dealersaleid" + lp, promoid.ToString());
break;
case 4:
prdData.SetXmlPropertyDouble("genxml/models/genxml[" + lp + "]/textbox/txtdealersale", newdealersaleamt);
prdData.SetXmlProperty("genxml/promo/dealersaleid" + lp, promoid.ToString());
prdData.SetXmlPropertyDouble("genxml/models/genxml[" + lp + "]/textbox/txtsaleprice", newamt);
prdData.SetXmlProperty("genxml/promo/salepriceid" + lp, promoid.ToString());
break;
default:
prdData.SetXmlPropertyDouble("genxml/models/genxml[" + lp + "]/textbox/txtsaleprice", newamt);
prdData.SetXmlProperty("genxml/promo/salepriceid" + lp, promoid.ToString());
break;
}
}
if (disablesale)
{
prdData.SetXmlPropertyDouble("genxml/models/genxml[" + lp + "]/textbox/txtsaleprice", 0);
prdData.RemoveXmlNode("genxml/promo/salepriceid" + lp);
}
if (disabledealer)
{
prdData.SetXmlPropertyDouble("genxml/models/genxml[" + lp + "]/textbox/txtdealercost", 0);
prdData.RemoveXmlNode("genxml/promo/dealercostid" + lp);
prdData.SetXmlPropertyDouble("genxml/models/genxml[" + lp + "]/textbox/txtdealersale", 0);
prdData.RemoveXmlNode("genxml/promo/dealersaleid" + lp);
}
lp += 1;
}
objCtrl.Update(prdData);
foreach (var lang in cultureList)
{
var promodesc = "";
var p = objCtrl.GetDataLang(promoid, lang);
if (p != null)
{
promodesc = p.GetXmlProperty("genxml/textbox/description");
}
var prdDataLang = objCtrl.GetDataLang(productId, lang);
if (prdDataLang != null)
{
prdDataLang.SetXmlProperty("genxml/hidden/promodesc", promodesc);
objCtrl.Update(prdDataLang);
}
}
}
}
public static string CalcGroupPromoItem(NBrightInfo p)
{
var objCtrl = new NBrightBuyController();
var typeselect = p.GetXmlProperty("genxml/radiobuttonlist/typeselect");
var catgroupid = p.GetXmlProperty("genxml/dropdownlist/catgroupid");
var propgroupid = p.GetXmlProperty("genxml/dropdownlist/propgroupid");
var promoname = p.GetXmlProperty("genxml/textbox/name");
var amounttype = p.GetXmlProperty("genxml/radiobuttonlist/amounttype");
var amount = p.GetXmlPropertyDouble("genxml/textbox/amount");
var validfrom = p.GetXmlProperty("genxml/textbox/validfrom");
var validuntil = p.GetXmlProperty("genxml/textbox/validuntil");
var overwrite = p.GetXmlPropertyBool("genxml/checkbox/overwrite");
var disabled = p.GetXmlPropertyBool("genxml/checkbox/disabled");
var lastcalculated = p.GetXmlProperty("genxml/hidden/lastcalculated");
var whichprice = p.GetXmlPropertyInt("genxml/radiobuttonlist/whichprice");
var runfreq = p.GetXmlPropertyInt("genxml/radiobuttonlist/runfreq");
if (!disabled)
{
var portalsettings = NBrightDNN.DnnUtils.GetPortalSettings(p.PortalId);
var lang = portalsettings.DefaultLanguage;
var prdList = new List <NBrightInfo>();
if (typeselect == "all")
{
prdList = objCtrl.GetList(p.PortalId, -1, "PRD");
}
else
{
CategoryData gCat;
var groupid = catgroupid;
if (typeselect != "cat")
{
groupid = propgroupid;
}
gCat = CategoryUtils.GetCategoryData(groupid, lang);
if (gCat != null)
{
prdList = gCat.GetAllArticles();
}
}
var runcalc = true;
if (runfreq == 1 || runfreq == 3) // run freq is date range
{
if (runfreq == 3)
{
// run constantly, set end date to +100 year
validfrom = DateTime.Now.AddYears(-1).ToString("s");
validuntil = DateTime.Now.AddYears(100).ToString("s");
}
// run date range
if (Utils.IsDate(lastcalculated))
{
if (Convert.ToDateTime(lastcalculated) >= p.ModifiedDate)
{
runcalc = false; // only run if changed
}
if (DateTime.Now.Date > Convert.ToDateTime(lastcalculated).Date.AddDays(1))
{
runcalc = true; // every day just after midnight. (for site performace)
}
}
if (Utils.IsDate(validuntil))
{
if (DateTime.Now.Date > Convert.ToDateTime(validuntil))
{
runcalc = true; // need to disable the promo if passed date
}
}
if ((runcalc) && Utils.IsDate(validfrom) && Utils.IsDate(validuntil))
{
var dteF = Convert.ToDateTime(validfrom).Date;
var dteU = Convert.ToDateTime(validuntil).Date;
foreach (var prd in prdList)
{
var productid = prd.ParentItemId;
if (typeselect == "all")
{
productid = prd.ItemID;
}
if (DateTime.Now.Date >= dteF && DateTime.Now.Date <= dteU)
{
// CALC Promo
CalcProductSalePrice(p.PortalId, productid, amounttype, amount, p.ItemID, whichprice, overwrite);
}
if (DateTime.Now.Date > dteU)
{
// END Promo
RemoveProductPromoData(p.PortalId, productid, p.ItemID);
}
ProductUtils.RemoveProductDataCache(p.PortalId, productid);
var productData = ProductUtils.GetProductData(productid, p.PortalId, lang);
productData.Save(); // recalc any new prices.
}
if (DateTime.Now.Date > dteU)
{
// END Promo
p.SetXmlProperty("genxml/checkbox/disabled", "True");
}
}
}
if (runfreq == 2) // run Once, do update and disable promo.
{
foreach (var prd in prdList)
{
var productid = prd.ParentItemId;
if (typeselect == "all")
{
productid = prd.ItemID;
}
// CALC Promo
CalcProductSalePrice(p.PortalId, productid, amounttype, amount, p.ItemID, whichprice, overwrite);
ProductUtils.RemoveProductDataCache(p.PortalId, productid);
var productData = ProductUtils.GetProductData(productid, p.PortalId, lang);
productData.Save(); // recalc any new prices.
}
p.SetXmlProperty("genxml/checkbox/disabled", "True");
}
if (runfreq == 4) // remove
{
foreach (var prd in prdList)
{
var productid = prd.ParentItemId;
if (typeselect == "all")
{
productid = prd.ItemID;
}
RemoveProductPromoData(p.PortalId, productid, p.ItemID);
ProductUtils.RemoveProductDataCache(p.PortalId, productid);
var productData = ProductUtils.GetProductData(productid, p.PortalId, lang);
productData.Save(); // recalc any new prices.
}
p.SetXmlProperty("genxml/checkbox/disabled", "True");
}
p.SetXmlProperty("genxml/hidden/lastcalculated", DateTime.Now.AddSeconds(10).ToString("O")); // Add 10 sec to time so we don't get exact clash with update time.
objCtrl.Update(p);
}
return("OK");
}
/// <summary>
/// This function needs to process and returned message from the bank.
/// This processing may vary widely between banks.
/// </summary>
/// <param name="context"></param>
public void ProcessRequest(HttpContext context)
{
var modCtrl = new NBrightBuyController();
var info = ProviderUtils.GetProviderSettings();
try
{
var debugMode = info.GetXmlPropertyBool("genxml/checkbox/debugmode");
var orderid = context.Request.Form.Get("vads_order_id");
string clientlang = context.Request.Form.Get("vads_order_info");
var rtnMsg = "SECURITY WARNING";
var sig1 = context.Request.Form.Get("signature");
var strMacCalc = ProviderUtils.GetSignatureReturnData(info.GetXmlProperty("genxml/textbox/certificate"), context.Request);
var sig2 = ProviderUtils.GetSignature(strMacCalc);
var debugMsg = "START CALL notify.ashx " + DateTime.Now.ToString("s") + " </br>";
if (debugMode)
{
foreach (var f in context.Request.Form.AllKeys)
{
debugMsg += f + ": " + context.Request.Form.Get(f) + "</br>";
}
debugMsg += "NBrightSystemPay DEBUG: " + DateTime.Now.ToString("s") + " </br>";
debugMsg += sig1 + " </br>";
debugMsg += sig2 + " </br>";
info.SetXmlProperty("genxml/debugmsg", debugMsg);
modCtrl.Update(info);
}
else
{
if (info.GetXmlProperty("genxml/debugmsg") != "")
{
info.SetXmlProperty("genxml/debugmsg", "");
modCtrl.Update(info);
}
}
if (sig1 == sig2)
{
// ------------------------------------------------------------------------
rtnMsg = "";
int nBrightSystemPayStoreOrderId = 0;
if (Utils.IsNumeric(orderid))
{
nBrightSystemPayStoreOrderId = Convert.ToInt32(orderid);
}
if (debugMode)
{
debugMsg += "OrderId: " + nBrightSystemPayStoreOrderId + " vads_order_id: " + orderid + " </br>";
}
if (nBrightSystemPayStoreOrderId > 0)
{
var orderData = new OrderData(nBrightSystemPayStoreOrderId);
string nBrightSystemPayStatusCode = ProviderUtils.GetStatusCode(orderData, context.Request);
if (debugMode)
{
debugMsg += "NBrightSystemPayStatusCode: " + nBrightSystemPayStatusCode + " </br>";
}
// Status return "00" is payment successful
if (nBrightSystemPayStatusCode == "00")
{
//set order status to Payed
orderData.PaymentOk();
}
else
{
orderData.PaymentFail();
}
orderData.Save();
}
if (debugMode)
{
debugMsg += "Return Message: " + rtnMsg;
info.SetXmlProperty("genxml/debugmsg", debugMsg);
modCtrl.Update(info);
}
}
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Write(rtnMsg);
HttpContext.Current.Response.ContentType = "text/plain";
HttpContext.Current.Response.CacheControl = "no-cache";
HttpContext.Current.Response.Expires = -1;
HttpContext.Current.Response.End();
}
catch (Exception ex)
{
if (!ex.ToString().StartsWith("System.Threading.ThreadAbortException")) // we expect a thread abort from the End response.
{
info.SetXmlProperty("genxml/debugmsg", "NBrightSystemPay ERROR: " + ex.ToString());
modCtrl.Update(info);
}
}
}
public static NBrightInfo CalcQtyPromoItem(NBrightInfo p, NBrightInfo cartItemInfo)
{
var objCtrl = new NBrightBuyController();
var typeselect = p.GetXmlProperty("genxml/radiobuttonlist/typeselect");
var catgroupid = p.GetXmlProperty("genxml/dropdownlist/catgroupid");
var propgroupid = p.GetXmlProperty("genxml/dropdownlist/propgroupid");
var promoname = p.GetXmlProperty("genxml/textbox/name");
var amounttype = p.GetXmlProperty("genxml/radiobuttonlist/amounttype");
var amount = p.GetXmlPropertyDouble("genxml/textbox/amount");
var overwrite = p.GetXmlPropertyBool("genxml/checkbox/overwrite");
var disabled = p.GetXmlPropertyBool("genxml/checkbox/disabled");
var rangeList = p.GetXmlProperty("genxml/textbox/range");
if (!disabled)
{
var productid = cartItemInfo.GetXmlPropertyInt("genxml/productid");
if (productid > 0)
{
var prodData = new ProductData(productid, Utils.GetCurrentCulture());
if (prodData.Exists)
{
var groupid = catgroupid;
if (typeselect == "prop")
{
groupid = propgroupid;
}
var gCat = CategoryUtils.GetCategoryData(groupid, Utils.GetCurrentCulture());
if (gCat == null)
{
return(cartItemInfo);
}
if (prodData.HasProperty(gCat.CategoryRef) || prodData.IsInCategory(gCat.CategoryRef))
{
var runcalc = true;
// build range Data
var rangeData = new List <RangeItem>();
var rl = rangeList.Split(new string[] { "\n", "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
foreach (var s in rl)
{
var ri = s.Split('=');
if (ri.Count() == 2 && Utils.IsNumeric(ri[1]))
{
var riV = ri[0].Split('-');
if (riV.Count() == 2 && Utils.IsNumeric(riV[0]) && Utils.IsNumeric(riV[1]))
{
var rItem = new RangeItem();
rItem.RangeLow = Convert.ToDouble(riV[0], CultureInfo.GetCultureInfo("en-US"));
rItem.Cost = Convert.ToDouble(ri[1], CultureInfo.GetCultureInfo("en-US"));
rItem.RangeHigh = Convert.ToDouble(riV[1], CultureInfo.GetCultureInfo("en-US"));
rangeData.Add(rItem);
}
}
}
var unitcost = cartItemInfo.GetXmlPropertyDouble("genxml/unitcost");
var promoprice = cartItemInfo.GetXmlPropertyDouble("genxml/promoprice");
var rangeValue = cartItemInfo.GetXmlPropertyDouble("genxml/qty");
var basecost = unitcost;
foreach (var i in rangeData)
{
if (rangeValue >= i.RangeLow && rangeValue < i.RangeHigh)
{
double newsaleprice = 0;
if (amounttype == "1")
{
// percentage discount
newsaleprice = Math.Round(basecost - ((basecost / 100) * i.Cost), 4);
}
else
{
// amount discount
newsaleprice = basecost - i.Cost;
if (newsaleprice < 0)
{
newsaleprice = 0;
}
}
cartItemInfo.SetXmlPropertyDouble("genxml/promoprice", newsaleprice);
}
}
}
}
}
}
return(cartItemInfo);
}
public string ProductAdminList(HttpContext context)
{
try
{
if (NBrightBuyUtils.CheckRights())
{
var ajaxInfo = NBrightBuyUtils.GetAjaxInfo(context);
if (UserController.Instance.GetCurrentUserInfo().UserID <= 0)
{
return(null);
}
var editlang = ajaxInfo.GetXmlProperty("genxml/hidden/editlang");
if (editlang == "")
{
editlang = Utils.GetCurrentCulture();
}
NBrightBuyUtils.RemoveModCache(-2);
ajaxInfo.SetXmlProperty("genxml/hidden/razortemplate", "datalist.cshtml");
var strOut = "";
// select a specific entity data type for the product (used by plugins)
var entitytypecodelang = "PRDLANG";
var entitytypecode = "PRD";
var filter = ajaxInfo.GetXmlProperty("genxml/hidden/filter");
var orderby = ajaxInfo.GetXmlProperty("genxml/hidden/orderby");
var returnLimit = ajaxInfo.GetXmlPropertyInt("genxml/hidden/returnlimit");
var pageNumber = ajaxInfo.GetXmlPropertyInt("genxml/hidden/pagenumber");
var pageSize = ajaxInfo.GetXmlPropertyInt("genxml/hidden/pagesize");
var cascade = ajaxInfo.GetXmlPropertyBool("genxml/hidden/cascade");
var portalId = PortalSettings.Current.PortalId;
if (ajaxInfo.GetXmlProperty("genxml/hidden/portalid") != "")
{
portalId = ajaxInfo.GetXmlPropertyInt("genxml/hidden/portalid");
}
var searchText = ajaxInfo.GetXmlProperty("genxml/hidden/searchtext");
var searchCategory = ajaxInfo.GetXmlProperty("genxml/hidden/searchcategory");
if (searchText != "")
{
filter += " and (NB3.[ProductName] like '%" + searchText + "%' or NB3.[ProductRef] like '%" + searchText + "%' or NB3.[Summary] like '%" + searchText + "%' ) ";
}
if (Utils.IsNumeric(searchCategory))
{
if (orderby == "{bycategoryproduct}")
{
orderby += searchCategory;
}
var objQual = DotNetNuke.Data.DataProvider.Instance().ObjectQualifier;
var dbOwner = DotNetNuke.Data.DataProvider.Instance().DatabaseOwner;
if (!cascade)
{
filter += " and NB1.[ItemId] in (select parentitemid from " + dbOwner + "[" + objQual + "NBrightBuy] where typecode = 'CATXREF' and XrefItemId = " + searchCategory + ") ";
}
else
{
filter += " and NB1.[ItemId] in (select parentitemid from " + dbOwner + "[" + objQual + "NBrightBuy] where (typecode = 'CATXREF' and XrefItemId = " + searchCategory + ") or (typecode = 'CATCASCADE' and XrefItemId = " + searchCategory + ")) ";
}
}
else
{
if (orderby == "{bycategoryproduct}")
{
orderby = " order by NB3.productname ";
}
}
// logic for client list of products
if (NBrightBuyUtils.IsClientOnly())
{
filter += " and NB1.ItemId in (select ParentItemId from dbo.[NBrightBuy] as NBclient where NBclient.TypeCode = 'USERPRDXREF' and NBclient.UserId = " + UserController.Instance.GetCurrentUserInfo().UserID.ToString("") + ") ";
}
var recordCount = 0;
var objCtrl = new NBrightBuyController();
if (pageNumber == 0)
{
pageNumber = 1;
}
if (pageSize == 0)
{
pageSize = 20;
}
// get only entity type required. Do NOT use typecode, that is set by the filter.
recordCount = objCtrl.GetListCount(PortalSettings.Current.PortalId, -1, "PRD", filter, "", editlang);
// get selected entitytypecode.
var list = objCtrl.GetDataList(PortalSettings.Current.PortalId, -1, "PRD", "PRDLANG", editlang, filter, orderby, StoreSettings.Current.DebugMode, "", returnLimit, pageNumber, pageSize, recordCount);
return(RenderProductAdminList(list, ajaxInfo, recordCount));
}
}
catch (Exception ex)
{
Logging.LogException(ex);
return(ex.ToString());
}
return("");
}
public static String ClientAdminList(HttpContext context)
{
try
{
if (NBrightBuyUtils.CheckManagerRights())
{
var settings = NBrightBuyUtils.GetAjaxDictionary(context);
var paging = true;
if (UserController.Instance.GetCurrentUserInfo().UserID <= 0)
{
return("");
}
var strOut = "";
if (!settings.ContainsKey("themefolder"))
{
settings.Add("themefolder", "");
}
if (!settings.ContainsKey("userid"))
{
settings.Add("userid", "-1");
}
if (!settings.ContainsKey("razortemplate"))
{
settings.Add("razortemplate", "");
}
if (!settings.ContainsKey("returnlimit"))
{
settings.Add("returnlimit", "0");
}
if (!settings.ContainsKey("pagenumber"))
{
settings.Add("pagenumber", "0");
}
if (!settings.ContainsKey("pagesize"))
{
settings.Add("pagesize", "0");
}
if (!settings.ContainsKey("searchtext"))
{
settings.Add("searchtext", "");
}
if (!settings.ContainsKey("dtesearchdatefrom"))
{
settings.Add("dtesearchdatefrom", "");
}
if (!settings.ContainsKey("dtesearchdateto"))
{
settings.Add("dtesearchdateto", "");
}
if (!settings.ContainsKey("searchorderstatus"))
{
settings.Add("searchorderstatus", "");
}
if (!settings.ContainsKey("portalid"))
{
settings.Add("portalid", PortalSettings.Current.PortalId.ToString("")); // aways make sure we have portalid in settings
}
if (!Utils.IsNumeric(settings["userid"]))
{
settings["pagenumber"] = "1";
}
if (!Utils.IsNumeric(settings["pagenumber"]))
{
settings["pagenumber"] = "1";
}
if (!Utils.IsNumeric(settings["pagesize"]))
{
settings["pagesize"] = "20";
}
if (!Utils.IsNumeric(settings["returnlimit"]))
{
settings["returnlimit"] = "50";
}
var themeFolder = settings["themefolder"];
var razortemplate = settings["razortemplate"];
var returnLimit = Convert.ToInt32(settings["returnlimit"]);
var pageNumber = Convert.ToInt32(settings["pagenumber"]);
var pageSize = Convert.ToInt32(settings["pagesize"]);
var portalId = Convert.ToInt32(settings["portalid"]);
var userid = settings["userid"];
var searchText = settings["searchtext"];
var recordCount = 0;
if (themeFolder == "")
{
themeFolder = StoreSettings.Current.ThemeFolder;
if (settings.ContainsKey("themefolder"))
{
themeFolder = settings["themefolder"];
}
}
var objCtrl = new NBrightBuyController();
if (paging) // get record count for paging
{
if (pageNumber == 0)
{
pageNumber = 1;
}
if (pageSize == 0)
{
pageSize = 20;
}
// get only entity type required
recordCount = objCtrl.GetDnnUsersCount(portalId, "%" + searchText.Replace("'", "''") + "%");
}
var list = objCtrl.GetDnnUsers(portalId, "%" + searchText.Replace("'", "''") + "%", 0, pageNumber, pageSize, recordCount);
var passSettings = settings;
foreach (var s in StoreSettings.Current.Settings()) // copy store setting, otherwise we get a byRef assignement
{
if (passSettings.ContainsKey(s.Key))
{
passSettings[s.Key] = s.Value;
}
else
{
passSettings.Add(s.Key, s.Value);
}
}
strOut = NBrightBuyUtils.RazorTemplRenderList(razortemplate, 0, "", list, "/DesktopModules/NBright/NBrightBuy", themeFolder, Utils.GetCurrentCulture(), passSettings);
// add paging if needed
if (paging && (recordCount > pageSize))
{
var pg = new NBrightCore.controls.PagingCtrl();
strOut += pg.RenderPager(recordCount, pageSize, pageNumber);
}
return(strOut);
}
return("");
}
catch (Exception ex)
{
return(ex.ToString());
}
}
/// <summary>
/// This function needs to process and returned message from the bank.
/// This processing may vary widely between banks.
/// </summary>
/// <param name="context"></param>
public void ProcessRequest(HttpContext context)
{
var modCtrl = new NBrightBuyController();
var info = modCtrl.GetPluginSinglePageData("OSPayPalpayment", "OSPayPalPAYMENT", Utils.GetCurrentCulture());
try
{
var ipn = new PayPalIpnParameters(context.Request);
var debugMode = info.GetXmlPropertyBool("genxml/checkbox/debug.mode");
var debugMsg = "START CALL" + DateTime.Now.ToString("s") + " </br>";
var rtnMsg = "version=2" + Environment.NewLine + "cdr=1";
// ------------------------------------------------------------------------
// In this case the payment provider passes back data via form POST.
// Get the data we need.
string returnmessage = "";
int OSPayPalStoreOrderID = 0;
string OSPayPalCartID = "";
string OSPayPalClientLang = "";
if (Utils.IsNumeric(ipn.item_number))
{
var validateUrl = info.GetXmlProperty("genxml/textbox/paymenturl") + "?" + ipn.PostString;
// check the record exists
debugMsg += "OrderId: " + ipn.item_number + " </br>";
var nbi = modCtrl.Get(Convert.ToInt32(ipn.item_number), "ORDER");
if (nbi != null)
{
var orderData = new OrderData(nbi.ItemID);
debugMsg += "validateUrl: " + validateUrl + " </br>";
if (ProviderUtils.VerifyPayment(ipn, validateUrl))
{
//set order status to Payed
debugMsg += "PaymentOK </br>";
orderData.PaymentOk();
}
else
{
if (ipn.IsValid)
{
debugMsg += "NOT VALIDATED BY PAYPAL </br>";
//set order status to Not verified
orderData.PaymentOk("050");
}
else
{
if (orderData.OrderStatus == "020" || orderData.OrderStatus == "010" || orderData.OrderStatus == "030")
{
debugMsg += "PAYMENT FAIL </br>";
orderData.PaymentFail();
}
else
{
debugMsg += "INVALID UPDATE ACTION</br>";
}
}
}
}
else
{
debugMsg += "ORDER does not exists";
}
if (debugMode)
{
info.SetXmlProperty("genxml/debugmsg", debugMsg);
modCtrl.Update(info);
}
}
if (debugMode)
{
debugMsg += "Return Message: " + rtnMsg;
info.SetXmlProperty("genxml/debugmsg", debugMsg);
modCtrl.Update(info);
}
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Write(rtnMsg);
HttpContext.Current.Response.ContentType = "text/plain";
HttpContext.Current.Response.CacheControl = "no-cache";
HttpContext.Current.Response.Expires = -1;
HttpContext.Current.Response.End();
}
catch (Exception ex)
{
if (!ex.ToString().StartsWith("System.Threading.ThreadAbortException")) // we expect a thread abort from the End response.
{
info.SetXmlProperty("genxml/debugmsg", "OS_PayPal ERROR: " + ex.ToString());
modCtrl.Update(info);
}
}
}
public static String GetBankRemotePost(OrderData orderData)
{
var rPost = new RemotePost();
var objCtrl = new NBrightBuyController();
var info = objCtrl.GetPluginSinglePageData("NBrightPayBoxpayment", "NBrightPayBoxPAYMENT", orderData.Lang);
var param = new string[3];
param[0] = "orderid=" + orderData.PurchaseInfo.ItemID.ToString("");
param[1] = "status=1";
var pbxeffectue = Globals.NavigateURL(StoreSettings.Current.PaymentTabId, "", param);
param[0] = "orderid=" + orderData.PurchaseInfo.ItemID.ToString("");
param[1] = "status=0";
var pbxrefuse = Globals.NavigateURL(StoreSettings.Current.PaymentTabId, "", param);
var appliedtotal = orderData.PurchaseInfo.GetXmlPropertyDouble("genxml/appliedtotal").ToString("0.00").Replace(",", "").Replace(".", "");;
var postUrl = info.GetXmlProperty("genxml/textbox/mainurl");
WebRequest request = WebRequest.Create("https://tpeweb.paybox.com/load.html");
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
if (response == null || response.StatusCode != HttpStatusCode.OK)
{
postUrl = info.GetXmlProperty("genxml/textbox/backupurl");
}
if (info.GetXmlPropertyBool("genxml/checkbox/preproduction"))
{
postUrl = info.GetXmlProperty("genxml/textbox/preprodurl");
}
rPost.Url = postUrl;
rPost.Add("PBX_SITE", info.GetXmlProperty("genxml/textbox/pbxsite"));
rPost.Add("PBX_RANG", info.GetXmlProperty("genxml/textbox/pbxrang"));
rPost.Add("PBX_DEVISE", info.GetXmlProperty("genxml/textbox/pbxdevise"));
rPost.Add("PBX_TOTAL", appliedtotal);
rPost.Add("PBX_IDENTIFIANT", info.GetXmlProperty("genxml/textbox/pbxidentifiant"));
rPost.Add("PBX_CMD", orderData.PurchaseInfo.ItemID.ToString(""));
rPost.Add("PBX_PORTEUR", orderData.GetClientEmail());
rPost.Add("PBX_RETOUR", info.GetXmlProperty("genxml/textbox/pbxretour"));
rPost.Add("PBX_EFFECTUE", pbxeffectue);
rPost.Add("PBX_REFUSE", pbxrefuse);
rPost.Add("PBX_ANNULE", pbxrefuse);
rPost.Add("PBX_REPONDRE_A", Utils.ToAbsoluteUrl("/DesktopModules/NBright/NBrightPayBox/notify.ashx"));
rPost.Add("PBX_HASH", "SHA512");
rPost.Add("PBX_TIME", DateTime.UtcNow.ToString("o"));
rPost.Add("PBX_HMAC", rPost.GetHmac(info.GetXmlProperty("genxml/textbox/hmackey")).ToUpper());
//Build the re-direct html
var rtnStr = "";
rtnStr = rPost.GetPostHtml("/DesktopModules/NBright/NBrightPayBox/Themes/config/img/" + info.GetXmlProperty("genxml/dropdownlist"));
if (info.GetXmlPropertyBool("genxml/checkbox/debugmode"))
{
File.WriteAllText(PortalSettings.Current.HomeDirectoryMapPath + "\\debug_NBrightPayBoxpost.html", rtnStr);
}
return(rtnStr);
}
private void DoClearDown()
{
var pass = GenXmlFunctions.GetField(rpData, "txtclearpass");
if (pass == StoreSettings.Current.Get("adminpin") && pass != "")
{
var done = false;
var objCtrl = new NBrightBuyController();
var objQual = DotNetNuke.Data.DataProvider.Instance().ObjectQualifier;
var dbOwner = DotNetNuke.Data.DataProvider.Instance().DatabaseOwner;
var stmt = "";
if (GenXmlFunctions.GetField(rpData, "clearproducts") == "True")
{
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'PRD' ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'PRDLANG' ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'AMY' ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'AMYLANG' ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'PRDXREF' ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'USERPRDXREF' ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'CATCASCADE' ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'CATXREF' ";
objCtrl.ExecSql(stmt);
done = true;
}
if (GenXmlFunctions.GetField(rpData, "clearcategories") == "True")
{
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'CATEGORY' and [XMLData].value('(genxml/dropdownlist/ddlgrouptype)[1]','nvarchar(max)') = 'cat' ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'CATEGORYLANG' and ParentItemId not in (Select itemid from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'CATEGORY') ";
objCtrl.ExecSql(stmt);
done = true;
}
if (GenXmlFunctions.GetField(rpData, "clearpropertiesonly") == "True")
{
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'CATEGORY' and [XMLData].value('(genxml/dropdownlist/ddlgrouptype)[1]','nvarchar(max)') != 'cat' ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'CATEGORYLANG' and ParentItemId not in (Select itemid from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'CATEGORY') ";
objCtrl.ExecSql(stmt);
done = true;
}
if (GenXmlFunctions.GetField(rpData, "clearproperties") == "True")
{
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'CATEGORY' and [XMLData].value('(genxml/dropdownlist/ddlgrouptype)[1]','nvarchar(max)') != 'cat' ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'CATEGORYLANG' and ParentItemId not in (Select itemid from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'CATEGORY') ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'GROUP' ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'GROUPLANG' ";
objCtrl.ExecSql(stmt);
done = true;
}
if (GenXmlFunctions.GetField(rpData, "clearorders") == "True")
{
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'ORDER' ";
objCtrl.ExecSql(stmt);
done = true;
}
DataCache.ClearCache();
if (done)
{
NBrightBuyUtils.SetNotfiyMessage(ModuleId, "deletecompleted", NotifyCode.ok);
}
}
else
{
NBrightBuyUtils.SetNotfiyMessage(ModuleId, "nopin", NotifyCode.fail);
}
}
private static void CalcProductSalePrice(int portalid, int productId, string amounttype, double amount, string promoname, int promoid, bool overwrite, DateTime dteF, DateTime dteU)
{
var cultureList = DnnUtils.GetCultureCodeList(portalid);
var objCtrl = new NBrightBuyController();
var prdData = objCtrl.GetData(productId);
var nodList = prdData.XMLDoc.SelectNodes("genxml/models/genxml");
if (nodList != null)
{
var currentpromoid = prdData.GetXmlPropertyInt("genxml/hidden/promoid");
if (currentpromoid == 0 || currentpromoid == promoid || overwrite)
{
prdData.SetXmlProperty("genxml/hidden/promotype", "PROMOGROUP");
prdData.SetXmlPropertyDouble("genxml/hidden/promoname", promoname);
prdData.SetXmlProperty("genxml/hidden/promoid", promoid.ToString());
prdData.SetXmlProperty("genxml/hidden/promocalcdate", DateTime.Now.ToString("O"));
prdData.SetXmlProperty("genxml/hidden/datefrom", dteF.ToString("O"));
prdData.SetXmlProperty("genxml/hidden/dateuntil", dteU.ToString("O"));
var lp = 1;
foreach (XmlNode nod in nodList)
{
var nbi = new NBrightInfo();
nbi.XMLData = nod.OuterXml;
var unitcost = nbi.GetXmlPropertyDouble("genxml/textbox/txtunitcost");
Double newamt = 0;
if (amounttype == "1")
{
newamt = unitcost - amount;
}
else
{
newamt = unitcost - ((unitcost / 100) * amount);
}
if (newamt < 0)
{
newamt = 0;
}
var currentprice = prdData.GetXmlPropertyDouble("genxml/models/genxml[" + lp + "]/textbox/txtsaleprice");
if (!overwrite)
{
if (currentprice == 0)
{
overwrite = true;
}
if (currentpromoid == promoid)
{
overwrite = true;
}
}
if (overwrite)
{
prdData.SetXmlPropertyDouble("genxml/models/genxml[" + lp + "]/textbox/txtsaleprice", newamt);
}
lp += 1;
}
objCtrl.Update(prdData);
foreach (var lang in cultureList)
{
var p = objCtrl.GetDataLang(promoid, lang);
var prdDataLang = objCtrl.GetDataLang(productId, lang);
if (prdDataLang != null)
{
prdDataLang.SetXmlProperty("genxml/hidden/promodesc", p.GetXmlProperty("genxml/textbox/description"));
objCtrl.Update(prdDataLang);
}
}
}
}
}
/// <summary>
/// This function needs to process and returned message from the bank.
/// This processing may vary widely between banks.
/// </summary>
/// <param name="context"></param>
public void ProcessRequest(HttpContext context)
{
var modCtrl = new NBrightBuyController();
var info = modCtrl.GetPluginSinglePageData("OS_PayBoxpayment", "OS_PayBoxPAYMENT", Utils.GetCurrentCulture());
try
{
var debugMode = info.GetXmlPropertyBool("genxml/checkbox/debugmode");
var debugMsg = "START CALL" + DateTime.Now.ToString("s") + " </br>";
var rtnMsg = "version=2" + Environment.NewLine + "cdr=1";
// ------------------------------------------------------------------------
// In this case the payment provider passes back data via form POST.
// Get the data we need.
string returnmessage = "";
int OS_PayBoxStoreOrderID = 0;
string OS_PayBoxCartID = "";
string OS_PayBoxClientLang = "";
var orderid = Utils.RequestQueryStringParam(context, "ref");
debugMsg += "orderid: " + orderid + "</br>";
if (Utils.IsNumeric(orderid))
{
var authcode = Utils.RequestQueryStringParam(context, "auto");
var errcode = Utils.RequestQueryStringParam(context, "rtnerr");
var call = Utils.RequestQueryStringParam(context, "call");
var trans = Utils.RequestQueryStringParam(context, "trans");
OS_PayBoxStoreOrderID = Convert.ToInt32(orderid);
// ------------------------------------------------------------------------
debugMsg += "OrderId: " + orderid + " </br>";
debugMsg += "errcode: " + errcode + " </br>";
debugMsg += "authcode: " + authcode + " </br>";
debugMsg += "trans: " + trans + " </br>";
debugMsg += "call: " + call + " </br>";
var orderData = new OrderData(OS_PayBoxStoreOrderID);
if (info.GetXmlPropertyBool("genxml/checkbox/pbxautoseule"))
{
orderData.PurchaseInfo.SetXmlProperty("genxml/payboxrtn", "");
orderData.PurchaseInfo.SetXmlProperty("genxml/payboxrtn/call", call);
orderData.PurchaseInfo.SetXmlProperty("genxml/payboxrtn/trans", trans);
orderData.SavePurchaseData();
}
if (authcode == "")
{
rtnMsg = "KO";
}
else
{
rtnMsg = "OK";
}
if (authcode == "")
{
orderData.PaymentFail();
}
else
{
if (errcode == "00000")
{
orderData.PaymentOk();
}
else if (errcode == "99999")
{
orderData.PaymentOk("050");
}
else
{
orderData.PaymentFail();
}
}
if (debugMode)
{
orderData.PurchaseInfo.SetXmlProperty("genxml/payboxrtn/debugmsg", debugMsg);
orderData.SavePurchaseData();
}
}
if (debugMode)
{
debugMsg += "Return Message: " + rtnMsg;
info.SetXmlProperty("genxml/debugmsg", debugMsg);
modCtrl.Update(info);
}
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Write(rtnMsg);
HttpContext.Current.Response.ContentType = "text/plain";
HttpContext.Current.Response.CacheControl = "no-cache";
HttpContext.Current.Response.Expires = -1;
HttpContext.Current.Response.End();
}
catch (Exception ex)
{
if (!ex.ToString().StartsWith("System.Threading.ThreadAbortException")) // we expect a thread abort from the End response.
{
Logging.LogException(ex);
}
}
}
private String DoProductIdx(DotNetNuke.Entities.Portals.PortalInfo portal, DateTime lastrun, Boolean debug)
{
if (debug)
{
InternalSearchController.Instance.DeleteAllDocuments(portal.PortalID, SearchHelper.Instance.GetSearchTypeByName("tab").SearchTypeId);
}
var searchDocs = new List <SearchDocument>();
var culturecodeList = DnnUtils.GetCultureCodeList(portal.PortalID);
var storeSettings = new StoreSettings(portal.PortalID);
foreach (var lang in culturecodeList)
{
var strContent = "";
// select all products
var objCtrl = new NBrightBuyController();
var strFilter = " and NB1.ModifiedDate > convert(datetime,'" + lastrun.ToString("s") + "') ";
if (debug)
{
strFilter = "";
}
var l = objCtrl.GetList(portal.PortalID, -1, "PRD", strFilter);
foreach (var p in l)
{
var prodData = new ProductData(p.ItemID, lang);
strContent = prodData.Info.GetXmlProperty("genxml/textbox/txtproductref") + " : " + prodData.SEODescription + " " + prodData.SEOName + " " + prodData.SEOTagwords + " " + prodData.SEOTitle;
if (strContent != "")
{
var tags = new List <String>();
tags.Add("nbsproduct");
//Get the description string
string strDescription = HtmlUtils.Shorten(HtmlUtils.Clean(strContent, false), 100, "...");
var searchDoc = new SearchDocument();
// Assigns as a Search key the SearchItems'
searchDoc.UniqueKey = prodData.Info.ItemID.ToString("");
searchDoc.QueryString = "ref=" + prodData.Info.GetXmlProperty("genxml/textbox/txtproductref");
searchDoc.Title = prodData.ProductName;
searchDoc.Body = strContent;
searchDoc.Description = strDescription;
if (debug)
{
searchDoc.ModifiedTimeUtc = DateTime.Now.Date;
}
else
{
searchDoc.ModifiedTimeUtc = prodData.Info.ModifiedDate;
}
searchDoc.AuthorUserId = 1;
searchDoc.TabId = storeSettings.ProductDetailTabId;
searchDoc.PortalId = portal.PortalID;
searchDoc.SearchTypeId = SearchHelper.Instance.GetSearchTypeByName("tab").SearchTypeId;
searchDoc.CultureCode = lang;
searchDoc.Tags = tags;
//Add Module MetaData
searchDoc.ModuleDefId = 0;
searchDoc.ModuleId = 0;
searchDocs.Add(searchDoc);
}
}
}
//Index
InternalSearchController.Instance.AddSearchDocuments(searchDocs);
InternalSearchController.Instance.Commit();
return(" - NBS-DNNIDX scheduler ACTIVATED ");
}
private string RunReport(HttpContext context)
{
var strOut = "Error!! - Invalid ItemId on Run Report";
var strSql = "";
try
{
var ajaxInfo = NBrightBuyUtils.GetAjaxFields(context);
var itemid = ajaxInfo.GetXmlPropertyInt("genxml/hidden/itemid");
var razortemplate = ajaxInfo.GetXmlProperty("genxml/hidden/razortemplate");
var portalid = PortalSettings.Current.PortalId.ToString("");
if (itemid > 0)
{
var objCtrl = new NBrightBuyController();
var obj = objCtrl.Get(itemid);
if (obj != null)
{
var inline = obj.GetXmlPropertyBool("genxml/checkbox/inline");
strSql = obj.GetXmlProperty("genxml/textbox/sql");
// replace any settings tokens (This is used to place the form data into the SQL)
strSql = Utils.ReplaceSettingTokens(strSql, ajaxInfo.ToDictionary());
strSql = Utils.ReplaceUrlTokens((strSql));
strSql =
GenXmlFunctions.StripSqlCommands(strSql); // don't allow anything to update through here.
// add FOR XML if not there, this function will only output XML results.
if (!strSql.ToLower().Contains("for xml"))
{
strSql += " FOR XML PATH ('item'), ROOT ('root')";
}
var strXmlResults = objCtrl.GetSqlxml(strSql);
var xdoc = XDocument.Parse(strXmlResults);
{
var xmlList = new List <NBrightInfo>();
foreach (XElement xmlitem in xdoc.XPathSelectElements("root/item"))
{
var nbi = new NBrightInfo(false);
nbi.XMLData = xmlitem.ToString();
xmlList.Add(nbi);
}
var templateControl = "/DesktopModules/NBright/NBrightBuyReport";
if (obj.GetXmlProperty("genxml/radiobuttonlist/reportformat") == "html")
{
if (inline)
{
razortemplate = "reporthtmlinline.cshtml";
}
else
{
razortemplate = "reporthtml.cshtml";
}
}
if (obj.GetXmlProperty("genxml/radiobuttonlist/reportformat") == "csv")
{
inline = false;
razortemplate = "reportcsv.cshtml";
}
//project
if (obj.GetXmlProperty("genxml/radiobuttonlist/reportformat") == "barchart")
{
inline = true;
razortemplate = "reportbar.cshtml";
}
strOut = NBrightBuyUtils.RazorTemplRenderList(razortemplate, -1, "", xmlList, templateControl, "config", _lang, StoreSettings.Current.Settings());
if (!inline)
{
var outfile = StoreSettings.Current.FolderTempMapPath + "\\" + itemid + "." + obj.GetXmlProperty("genxml/radiobuttonlist/reportformat");
Utils.SaveFile(outfile, strOut);
strOut = "Completed: <a target='_blank' href='" + StoreSettings.Current.FolderTemp + "/" + itemid + "."
+ obj.GetXmlProperty("genxml/radiobuttonlist/reportformat") + "' >View</a>";
}
}
return(strOut);
}
}
}
catch (Exception ex)
{
return(ex.ToString() + " <hr/> " + strSql);
}
return(strOut);
}
/// <summary>
/// This function needs to process and returned message from the bank.
/// This processing may vary widely between banks.
/// </summary>
/// <param name="context"></param>
public void ProcessRequest(HttpContext context)
{
var modCtrl = new NBrightBuyController();
var info = ProviderUtils.GetProviderSettings("NBrightPayPalpayment");
try
{
var ipn = new PayPalIpnParameters(context.Request.Form);
var debugMode = info.GetXmlPropertyBool("genxml/checkbox/debug.mode");
var debugMsg = "START CALL" + DateTime.Now.ToString("s") + " </br>";
debugMsg += "returnmessage: " + context.Request.Form.Get("returnmessage") + "</br>";
if (debugMode)
{
info.SetXmlProperty("genxml/debugmsg", debugMsg);
modCtrl.Update(info);
}
debugMsg += "NBrightPayPal DEBUG: " + DateTime.Now.ToString("s") + " </br>" + context.Request.Form + "<br/>";
if (Utils.IsNumeric(ipn.item_number))
{
var validateUrl = info.GetXmlProperty("genxml/textbox/paymenturl") + "?" + ipn.PostString;
// check the record exists
debugMsg += "OrderId: " + ipn.item_number + " </br>";
var nbi = modCtrl.Get(Convert.ToInt32(ipn.item_number), "ORDER");
if (nbi != null)
{
var orderData = new OrderData(nbi.ItemID);
if (ProviderUtils.VerifyPayment(ipn, validateUrl))
{
if (debugMode)
{
info.SetXmlProperty("genxml/debugmsg", debugMsg);
modCtrl.Update(info);
}
//set order status to Payed
orderData.PaymentOk();
}
else
{
if (ipn.IsValid)
{
info.SetXmlProperty("genxml/debugmsg", "NOT VALIDATED BY PAYPAL");
//set order status to Not verified
orderData.PaymentOk("050");
}
else
{
info.SetXmlProperty("genxml/debugmsg", "PAYMENT FAIL");
orderData.PaymentFail();
}
}
}
else
{
debugMsg += "ORDER does not exists";
}
if (debugMode)
{
info.SetXmlProperty("genxml/debugmsg", debugMsg);
modCtrl.Update(info);
}
}
}
catch (Exception ex)
{
if (!ex.ToString().StartsWith("System.Threading.ThreadAbortException")) // we expect a thread abort from the End response.
{
info.SetXmlProperty("genxml/debugmsg", "NBrightPayPal ERROR: " + ex.ToString());
modCtrl.Update(info);
}
}
}
private String GetData(HttpContext context, bool clearCache = false)
{
var objCtrl = new NBrightBuyController();
var strOut = "";
//get uploaded params
var ajaxInfo = NBrightBuyUtils.GetAjaxFields(context);
var itemid = ajaxInfo.GetXmlProperty("genxml/hidden/itemid");
var typeCode = ajaxInfo.GetXmlProperty("genxml/hidden/typecode");
var newitem = ajaxInfo.GetXmlProperty("genxml/hidden/newitem");
var selecteditemid = ajaxInfo.GetXmlProperty("genxml/hidden/selecteditemid");
var moduleid = ajaxInfo.GetXmlProperty("genxml/hidden/moduleid");
var editlang = ajaxInfo.GetXmlProperty("genxml/hidden/editlang");
var selectlang = ajaxInfo.GetXmlProperty("genxml/hidden/selectlang");
var rundisplay = ajaxInfo.GetXmlPropertyBool("genxml/hidden/rundisplay");
if (selectlang != "")
{
editlang = selectlang;
}
if (itemid == "")
{
itemid = selecteditemid;
}
if (editlang == "")
{
editlang = _lang;
}
if (!Utils.IsNumeric(moduleid))
{
moduleid = "-2"; // use moduleid -2 for razor
}
if (clearCache)
{
NBrightBuyUtils.RemoveModCache(Convert.ToInt32(moduleid));
}
if (newitem == "new")
{
itemid = AddNew(moduleid, typeCode);
}
var templateControl = "/DesktopModules/NBright/NBrightBuyReport";
if (Utils.IsNumeric(itemid))
{
// do edit field data if a itemid has been selected
var obj = objCtrl.Get(Convert.ToInt32(itemid), "", editlang);
if (rundisplay)
{
strOut = NBrightBuyUtils.RazorTemplRender(typeCode.ToLower() + "run.cshtml", Convert.ToInt32(moduleid), _lang + itemid + editlang, obj, templateControl, "config", _lang, StoreSettings.Current.Settings());
}
else
{
strOut = NBrightBuyUtils.RazorTemplRender(typeCode.ToLower() + "fields.cshtml", Convert.ToInt32(moduleid), _lang + itemid + editlang, obj, templateControl, "config", _lang, StoreSettings.Current.Settings());
}
}
else
{
// Return list of items
var l = objCtrl.GetDataList(PortalSettings.Current.PortalId, Convert.ToInt32(moduleid), typeCode, typeCode + "LANG", Utils.GetCurrentCulture(), "", " order by ModifiedDate desc", false, "", 100, 0, 0, 0);
strOut = NBrightBuyUtils.RazorTemplRenderList(typeCode.ToLower() + "list.cshtml", Convert.ToInt32(moduleid), _lang + editlang, l, templateControl, "config", _lang, StoreSettings.Current.Settings());
}
return(strOut);
}
private static NBrightInfo _nbrightInfo()
{
NBrightBuyController _nBright = new NBrightBuyController();
return(_nBright.GetByGuidKey(PortalSettings.Current.PortalId, -1, "SHIPPING", "OS_AllShipping"));
}
private String GetData(HttpContext context, bool clearCache = false)
{
var objCtrl = new NBrightBuyController();
var strOut = "";
//get uploaded params
var ajaxInfo = NBrightBuyUtils.GetAjaxFields(context);
var itemid = ajaxInfo.GetXmlProperty("genxml/hidden/itemid");
var typeCode = ajaxInfo.GetXmlProperty("genxml/hidden/typecode");
var newitem = ajaxInfo.GetXmlProperty("genxml/hidden/newitem");
var selecteditemid = ajaxInfo.GetXmlProperty("genxml/hidden/selecteditemid");
var moduleid = ajaxInfo.GetXmlProperty("genxml/hidden/moduleid");
var editlang = ajaxInfo.GetXmlProperty("genxml/hidden/editlang");
if (editlang == "")
{
editlang = Utils.GetCurrentCulture();
}
if (!Utils.IsNumeric(moduleid))
{
moduleid = "-2"; // use moduleid -2 for razor
}
if (clearCache)
{
NBrightBuyUtils.RemoveModCache(Convert.ToInt32(moduleid));
}
if (newitem == "new")
{
selecteditemid = AddNew(moduleid, typeCode);
}
var templateControl = "/DesktopModules/NBright/OS_CartReview";
if (Utils.IsNumeric(selecteditemid))
{
// do edit field data if a itemid has been selected
var obj = objCtrl.Get(Convert.ToInt32(selecteditemid), "", editlang);
var cartobj = new CartData(PortalSettings.Current.PortalId, "", obj.ItemID.ToString(""));
strOut = NBrightBuyUtils.RazorTemplRender("datafields.cshtml", Convert.ToInt32(moduleid), itemid + editlang + selecteditemid, cartobj, templateControl, "config", editlang, StoreSettings.Current.Settings());
}
else
{
var filter = "";
var searchText = ajaxInfo.GetXmlProperty("genxml/hidden/searchtext");
if (searchText != "")
{
filter += " and ( (([xmldata].value('(genxml/billaddress/genxml/textbox/firstname)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/billaddress/genxml/textbox/lastname)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/billaddress/genxml/textbox/unit)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/billaddress/genxml/textbox/street)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/billaddress/genxml/textbox/postalcode)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/billaddress/genxml/textbox/email)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/shipaddress/genxml/textbox/firstname)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/shipaddress/genxml/textbox/lastname)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/shipaddress/genxml/textbox/unit)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/shipaddress/genxml/textbox/street)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/shipaddress/genxml/textbox/postalcode)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/shipaddress/genxml/textbox/email)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/productrefs)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/ordernumber)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai )) ) ";
}
var pagenumber = ajaxInfo.GetXmlPropertyInt("genxml/hidden/pagenumber");
var pagesize = ajaxInfo.GetXmlPropertyInt("genxml/hidden/pagesize");
if (pagenumber == 0)
{
pagenumber = 1;
}
if (pagesize == 0)
{
pagesize = 20;
}
// get only entity type required
var recordcount = objCtrl.GetListCount(PortalSettings.Current.PortalId, -1, typeCode, filter);
// Return list of items
var l = objCtrl.GetList(PortalSettings.Current.PortalId, Convert.ToInt32(moduleid), typeCode, filter, " order by NB1.ModifiedDate DESC ", 0, pagenumber, pagesize, recordcount, editlang);
strOut = NBrightBuyUtils.RazorTemplRenderList("datalist.cshtml", Convert.ToInt32(moduleid), editlang + pagenumber, l, templateControl, "config", editlang, StoreSettings.Current.Settings());
if (recordcount > pagesize)
{
var pg = new NBrightCore.controls.PagingCtrl();
strOut += pg.RenderPager(recordcount, pagesize, pagenumber);
}
}
return(strOut);
}
public override NBrightInfo CalculatePromotion(int portalId, NBrightInfo cartInfo)
{
// loop through cart items
var rtncartInfo = (NBrightInfo)cartInfo.Clone();
try
{
var cartData = new CartData(cartInfo.PortalId);
var cartList = cartData.GetCartItemList();
foreach (var cartItemInfo in cartList)
{
cartInfo.SetXmlPropertyDouble("genxml/items/genxml[./itemcode = '" + cartItemInfo.GetXmlProperty("genxml/itemcode") + "']/promodiscount", 0); // remove any existing discount
if (cartItemInfo.GetXmlProperty("genxml/productxml/genxml/hidden/promotype") == "PROMOMULTIBUY")
{
var promoid = cartItemInfo.GetXmlPropertyInt("genxml/productxml/genxml/hidden/promoid");
var objCtrl = new NBrightBuyController();
var promoData = objCtrl.GetData(promoid);
if (promoData != null)
{
//NOTE: WE nedd to process disabld promotions so they can be removed from cart
var buyqty = promoData.GetXmlPropertyInt("genxml/textbox/buyqty");
var validfrom = promoData.GetXmlProperty("genxml/textbox/validfrom");
var validuntil = promoData.GetXmlProperty("genxml/textbox/validuntil");
var propbuygroupid = promoData.GetXmlProperty("genxml/dropdownlist/propbuy");
var propapplygroupid = promoData.GetXmlProperty("genxml/dropdownlist/propapply");
var amounttype = promoData.GetXmlProperty("genxml/radiobuttonlist/amounttype");
var amount = promoData.GetXmlPropertyDouble("genxml/textbox/amount");
// Applied discount to this single cart item
if (!promoData.GetXmlPropertyBool("genxml/checkbox/disabled") && cartItemInfo.GetXmlPropertyInt("genxml/qty") >= buyqty && Utils.IsDate(validfrom) && Utils.IsDate(validuntil)) // check we have correct qty to activate promo
{
var dteF = Convert.ToDateTime(validfrom).Date;
var dteU = Convert.ToDateTime(validuntil).Date;
if (DateTime.Now.Date >= dteF && DateTime.Now.Date <= dteU)
{
// calc discount amount
var cartqty = cartItemInfo.GetXmlPropertyDouble("genxml/qty");
var qtycount = cartqty;
var unitcost = cartItemInfo.GetXmlPropertyDouble("genxml/basecost");
double discountamt = 0;
while (qtycount > buyqty)
{
if (amounttype == "1")
{
discountamt += (unitcost - amount);
}
else
{
discountamt += ((unitcost / 100) * amount);
}
if (discountamt < 0)
{
discountamt = 0;
}
qtycount = (qtycount - (buyqty + 1)); // +1 so we allow for discount 1 in basket.
}
cartInfo.SetXmlPropertyDouble("genxml/items/genxml[./itemcode = '" + cartItemInfo.GetXmlProperty("genxml/itemcode") + "']/promodiscount", discountamt);
}
}
}
}
}
return(cartInfo);
}
catch (Exception ex)
{
var x = ex.ToString();
return(rtncartInfo);
}
}
protected override void OnLoad(EventArgs e)
{
try
{
var orderid = Utils.RequestQueryStringParam(HttpContext.Current, "merchantReference");
if (orderid != "")
{
var modCtrl = new NBrightBuyController();
var info = modCtrl.GetPluginSinglePageData("OS_PayBoxpayment", "OS_PayBoxPAYMENT", Utils.GetCurrentCulture());
orderid = orderid.Split('_')[0];
var param = "?orderid=" + orderid;
var lang = Utils.RequestQueryStringParam(HttpContext.Current, "shopperLocale");
if (lang != "")
{
param += "&language=" + lang;
}
var authResult = Utils.RequestQueryStringParam(HttpContext.Current, "authResult");
var call = Utils.RequestQueryStringParam(HttpContext.Current, "call");
var trans = Utils.RequestQueryStringParam(HttpContext.Current, "trans");
if (info.GetXmlPropertyBool("genxml/checkbox/pbxautoseule"))
{
var orderData = new OrderData(Convert.ToInt32(orderid));
if (orderData.PurchaseInfo.GetXmlProperty("genxml/payboxrtn/call") == "")
{
orderData.PurchaseInfo.SetXmlProperty("genxml/payboxrtn", "");
orderData.PurchaseInfo.SetXmlProperty("genxml/payboxrtn/call", call);
orderData.PurchaseInfo.SetXmlProperty("genxml/payboxrtn/trans", trans);
orderData.SavePurchaseData();
}
}
switch (authResult)
{
case "AUTHORISED":
param += "&status=1";
break;
case "CANCELLED":
param += "&status=0";
break;
case "REFUSED":
param += "&status=0";
break;
case "PENDING":
param += "&status=0";
break;
case "ERROR":
param += "&status=0";
break;
}
Response.Redirect(info.GetXmlProperty("genxml/textbox/paymentreturn") + param);
}
}
catch (Exception exc) //Module failed to load
{
//display the error on the template (don;t want to log it here, prefer to deal with errors directly.)
var l = new Literal();
l.Text = exc.ToString();
phData.Controls.Add(l);
}
}
public static String GetBankRemotePost(OrderData orderData)
{
var rPost = new RemotePost();
var objCtrl = new NBrightBuyController();
var settings = objCtrl.GetPluginSinglePageData("OS_Sipspayment", "OS_SipsPAYMENT", Utils.GetCurrentCulture());
var appliedtotal = orderData.PurchaseInfo.GetXmlPropertyDouble("genxml/appliedtotal");
var alreadypaid = orderData.PurchaseInfo.GetXmlPropertyDouble("genxml/alreadypaid");
var orderTotal = Regex.Replace((appliedtotal - alreadypaid).ToString("0.00"), "[^0-9]", "");
var controlMapPath = HttpContext.Current.Server.MapPath("/DesktopModules/NBright/OS_Sips");
var pathfile = PortalSettings.Current.HomeDirectoryMapPath.TrimEnd('\\') + "\\" + settings.GetXmlProperty("genxml/textbox/paramfolder") + "\\pathfile";
var transid = Convert.ToDateTime(orderData.PurchaseInfo.ModifiedDate).Ticks.ToString();
transid = transid.Substring(transid.Length - 6);
var parms = "";
parms = "pathfile=\"" + pathfile + "\" ";
parms += "merchant_id=" + settings.GetXmlProperty("genxml/textbox/merchantid") + " ";
parms += "merchant_country=" + settings.GetXmlProperty("genxml/textbox/merchantcountry") + " ";
parms += "amount=" + orderTotal + " ";
parms += "currency_code=" + settings.GetXmlProperty("genxml/textbox/currencycode") + " ";
parms += "transaction_id=" + transid + " ";
parms += "payment_means=" + settings.GetXmlProperty("genxml/textbox/paymentmeans") + " ";
parms += "order_id=" + orderData.PurchaseInfo.ItemID.ToString("") + " ";
var param = new string[3];
param[0] = "orderid=" + orderData.PurchaseInfo.ItemID.ToString("");
param[1] = "status=1";
var storeSettings = new StoreSettings(orderData.PortalId);
var sUrlOk = Globals.NavigateURL(storeSettings.PaymentTabId, "", param);
param[1] = "status=0";
var sUrlKo = Globals.NavigateURL(storeSettings.PaymentTabId, "", param);
parms += "normal_return_url=" + sUrlOk + " ";
parms += "cancel_return_url=" + sUrlKo + " ";
if (settings.GetXmlProperty("genxml/textbox/ipn") != "")
{
parms += "automatic_response_url=" + settings.GetXmlProperty("genxml/textbox/ipn") + " ";
}
else
{
var baseUri = new Uri("https://" + PortalSettings.Current.PortalAlias.HTTPAlias);
var absoluteUri = new Uri(baseUri, "/DesktopModules/NBright/OS_Sips/notify.ashx");
parms += "automatic_response_url=" + absoluteUri + " ";
}
parms += "language=" + orderData.Lang.Substring(0, 2) + " ";
if (settings.GetXmlPropertyBool("genxml/checkbox/debugmode"))
{
File.WriteAllText(PortalSettings.Current.HomeDirectoryMapPath + "\\debug_SipsApiparams.html", parms);
}
var exepath = controlMapPath.TrimEnd('\\') + "\\sipsbin\\request.exe";
var sipsdata = CallSipsExec(exepath, parms);
var tableau = sipsdata.Split('!');
string code = "";
code = tableau[1];
string errorMsg = tableau[2];
if (code.Equals("") | code.Equals("-1"))
{
return(errorMsg);
}
var htmlOutput = tableau[3];
var aryResult = htmlOutput.Split('"');
var sipsUrl = aryResult[1];
var sipsData = aryResult[5];
rPost.Url = sipsUrl;
rPost.Add("DATA", sipsData); // must be uppercase.
// just force CB payment. (CB must be in the list of payment_means)
rPost.Add("CB.x", "5");
rPost.Add("CB.y", "5");
// save here (may chnage lang field)
orderData.AddAuditMessage(transid, "sisptransid", "sipsapi", "True");
orderData.Save();
//Build the re-direct html
var rtnStr = rPost.GetPostHtml();
if (settings.GetXmlPropertyBool("genxml/checkbox/debugmode"))
{
File.WriteAllText(PortalSettings.Current.HomeDirectoryMapPath + "\\debug_SipsApihtmlOutput.html", htmlOutput);
File.WriteAllText(PortalSettings.Current.HomeDirectoryMapPath + "\\debug_SipsApipost.html", rtnStr);
}
return(rtnStr);
}
public static List <UrlRule> GetRules(int portalId)
{
object padlock = new object();
lock (padlock)
{
List <UrlRule> rules = new List <UrlRule>();
List <UrlRule> catrules = new List <UrlRule>();
#if DEBUG
decimal speed;
string mess;
var stopwatch = new System.Diagnostics.Stopwatch();
stopwatch.Start();
#endif
var purgeResult = UrlRulesCaching.PurgeExpiredItems(portalId);
var portalCacheKey = UrlRulesCaching.GeneratePortalCacheKey(portalId, null);
var portalRules = UrlRulesCaching.GetCache(portalId, portalCacheKey, purgeResult.ValidCacheItems);
if (portalRules != null && portalRules.Count > 0)
{
#if DEBUG
stopwatch.Stop();
speed = stopwatch.Elapsed.Milliseconds;
mess = $"PortalId: {portalId}. Time elapsed: {stopwatch.Elapsed.Milliseconds}ms. All Cached. PurgedItems: {purgeResult.PurgedItemCount}. Speed: {speed}";
Logger.Error(mess);
#endif
return(portalRules);
}
Dictionary <string, Locale> dicLocales = LocaleController.Instance.GetLocales(portalId);
var objCtrl = new NBrightBuyController();
var storesettings = new StoreSettings(portalId);
ModuleController mc = new ModuleController();
var modules = mc.GetModulesByDefinition(portalId, "NBS_ProductDisplay").OfType <ModuleInfo>();
var modulesOldModule = mc.GetModulesByDefinition(portalId, "NBS_ProductView").OfType <ModuleInfo>();
modules = modules.Concat(modulesOldModule);
// ------- Category URL ---------------
#region "Category Url"
// Not using the module loop!!
// becuase tabs that are defined in the url are dealt with by open url rewriter, so we only need use the default tab which is defined by the store settings.
foreach (KeyValuePair <string, Locale> key in dicLocales)
{
try
{
string cultureCode = key.Value.Code;
string ruleCultureCode = (dicLocales.Count > 1 ? cultureCode : null);
var grpCatCtrl = new GrpCatController(cultureCode, portalId);
// get all products in portal, with lang data
var catitems = objCtrl.GetList(portalId, -1, "CATEGORY");
foreach (var catData in catitems)
{
var catDataLang = objCtrl.GetDataLang(catData.ItemID, cultureCode);
if (catDataLang != null && !catData.GetXmlPropertyBool("genxml/checkbox/chkishidden"))
{
var catCacheKey = portalCacheKey + "_" + catDataLang.ItemID + "_" + cultureCode;
List <UrlRule> categoryRules = UrlRulesCaching.GetCache(portalId, catCacheKey, purgeResult.ValidCacheItems);
if (categoryRules != null && categoryRules.Count > 0)
{
rules.AddRange(categoryRules);
}
else
{
catrules = new List <UrlRule>();
var caturlname = catDataLang.GUIDKey;
var SEOName = catDataLang.GetXmlProperty("genxml/textbox/txtseoname");
var categoryName = catDataLang.GetXmlProperty("genxml/textbox/txtcategoryname");
var newcatUrl = grpCatCtrl.GetBreadCrumb(catData.ItemID, 0, "/", false);
var url = newcatUrl;
if (!string.IsNullOrEmpty(url))
{
// ------- Category URL ---------------
var rule = new UrlRule
{
CultureCode = ruleCultureCode,
TabId = storesettings.ProductListTabId,
Parameters = "catref=" + caturlname,
Url = url
};
var reducedRules =
rules.Where(r => r.CultureCode == rule.CultureCode && r.TabId == rule.TabId)
.ToList();
bool ruleExist = reducedRules.Any(r => r.Parameters == rule.Parameters);
if (!ruleExist)
{
if (reducedRules.Any(r => r.Url == rule.Url)) // if duplicate url
{
rule.Url = catData.ItemID + "-" + url;
}
rules.Add(rule);
catrules.Add(rule);
}
var proditems = objCtrl.GetList(catData.PortalId, -1, "CATXREF", " and NB1.XRefItemId = " + catData.ItemID.ToString(""));
var l2 = objCtrl.GetList(catData.PortalId, -1, "CATCASCADE", " and NB1.XRefItemId = " + catData.ItemID.ToString(""));
proditems.AddRange(l2);
var pageurl = "";
var pageurl1 = rule.Url;
// do paging for category (on all product modules.)
foreach (var module in modules)
{
// ------- Paging URL ---------------
var modsetting = NBrightBuyUtils.GetSettings(portalId, module.ModuleID);
var pagesize = modsetting.GetXmlPropertyInt("genxml/textbox/pagesize");
var staticlist = modsetting.GetXmlPropertyBool("genxml/checkbox/staticlist");
var defaultcatid = modsetting.GetXmlPropertyBool("genxml/dropdownlist/defaultpropertyid");
var defaultpropertyid = modsetting.GetXmlPropertyBool("genxml/dropdownlist/defaultcatid");
if (pagesize > 0)
{
if (module.TabID != storesettings.ProductListTabId || staticlist)
{
// on the non-default product list tab, add the moduleid, so we dont; get duplicates.
// NOTE: this only supports defaut paging url for 1 module on the defaut product list page. Other modules will have moduleid added to the url.
//pageurl = module.ModuleID + "-" + pageurl1;
//IGNORE NON DEFAULT MODULES.
}
else
{
pageurl = pageurl1;
var pagetotal = Convert.ToInt32((proditems.Count / pagesize) + 1);
for (int i = 1; i <= pagetotal; i++)
{
rule = new UrlRule
{
CultureCode = ruleCultureCode,
TabId = module.TabID,
Parameters = "catref=" + caturlname + "&page=" + i + "&pagemid=" + module.ModuleID,
Url = pageurl + "-" + i
};
ruleExist = reducedRules.Any(r => r.Parameters == rule.Parameters);
if (!ruleExist)
{
if (reducedRules.Any(r => r.Url == rule.Url)) // if duplicate url
{
rule.Url = module.ModuleID + "-" + rule.Url;
}
rules.Add(rule);
catrules.Add(rule);
}
}
}
}
}
// ------- Product URL ---------------
foreach (var xrefData in proditems)
{
//var product = new ProductData(xrefData.ParentItemId, cultureCode, false);
var prdData = objCtrl.GetData(xrefData.ParentItemId, cultureCode);
var pref = prdData.GetXmlProperty("genxml/textbox/txtproductref");
string produrl = prdData.GetXmlProperty("genxml/lang/genxml/textbox/txtseoname");
;
if (string.IsNullOrEmpty(produrl))
{
produrl = prdData.GetXmlProperty("genxml/lang/genxml/textbox/txtproductname");
}
if (string.IsNullOrEmpty(produrl))
{
produrl = pref;
}
if (string.IsNullOrEmpty(produrl))
{
produrl = prdData.ItemID.ToString("");
}
//if (catref != "") produrl = catref + "-" + produrl;
//if (catref != "") produrl = catref + "-" + produrl;
produrl = newcatUrl + "/" + Utils.UrlFriendly(produrl);
var prodrule = new UrlRule
{
CultureCode = ruleCultureCode,
TabId = storesettings.ProductDetailTabId,
Parameters = "catref=" + catDataLang.GUIDKey + "&ref=" + prdData.GUIDKey,
Url = produrl
};
reducedRules =
rules.Where(
r => r.CultureCode == prodrule.CultureCode && r.TabId == prodrule.TabId)
.ToList();
ruleExist = reducedRules.Any(r => r.Parameters == prodrule.Parameters);
if (!ruleExist)
{
if (reducedRules.Any(r => r.Url == prodrule.Url)) // if duplicate url
{
prodrule.Url = prdData.ItemID + "-" + produrl;
}
rules.Add(prodrule);
catrules.Add(prodrule);
}
}
}
UrlRulesCaching.SetCache(portalId, catCacheKey, new TimeSpan(1, 0, 0, 0), catrules);
}
}
}
}
catch (Exception ex)
{
Logger.Error("Failed to generate url for module NBS", ex);
}
}
#endregion
UrlRulesCaching.SetCache(portalId, portalCacheKey, new TimeSpan(1, 0, 0, 0), rules);
#if DEBUG
stopwatch.Stop();
mess = $"PortalId: {portalId}. Time elapsed: {stopwatch.Elapsed.Milliseconds}ms. Module Count: {modules.Count()}. PurgedItems: {purgeResult.PurgedItemCount}";
Logger.Error(mess);
Console.WriteLine(mess);
#endif
return(rules);
}
}
