public String CategoryAdminList(HttpContext context, string editType, string editLangCurrent)
{
var ajaxInfo = NBrightBuyUtils.GetAjaxInfo(context);
var razortemplate = ajaxInfo.GetXmlProperty("genxml/hidden/razortemplate");
if (razortemplate == "")
{
razortemplate = "Admin_CategoryList.cshtml";
}
var themefolder = ajaxInfo.GetXmlProperty("genxml/hidden/themefolder");
if (themefolder == "")
{
themefolder = "config";
}
var catid = ajaxInfo.GetXmlPropertyInt("genxml/hidden/selectedcatid");
var grpCats = new List <NBrightInfo>();
if (editType.ToLower() == "property")
{
var selgroup = ajaxInfo.GetXmlProperty("genxml/hidden/selectedgroup");
grpCats = NBrightBuyUtils.GetCatList(catid, selgroup, editLangCurrent);
}
else
{
grpCats = NBrightBuyUtils.GetCatList(catid, "cat", editLangCurrent);
}
var strOut = NBrightBuyUtils.RazorTemplRenderList(razortemplate, 0, "", grpCats, TemplateRelPath, themefolder, Utils.GetCurrentCulture(), StoreSettings.Current.Settings());
return(strOut);
}
private static String GetAddressList(HttpContext context)
{
var addressData = new AddressData();
var ajaxInfo = NBrightBuyUtils.GetAjaxFields(context);
var themeFolder = ajaxInfo.GetXmlProperty("genxml/hidden/themefolder");
var razortemplate = ajaxInfo.GetXmlProperty("genxml/hidden/razortemplate");
var passSettings = ajaxInfo.ToDictionary();
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);
}
}
var l = addressData.GetAddressList();
var strOut = NBrightBuyUtils.RazorTemplRenderList(razortemplate, 0, "", l, "/DesktopModules/NBright/NBrightBuy", themeFolder, Utils.GetCurrentCulture(), passSettings);
return(strOut);
}
public static String RenderPluginAdminList(List <NBrightInfo> list, NBrightInfo ajaxInfo, int recordCount)
{
try
{
if (NBrightBuyUtils.CheckRights())
{
if (list == null)
{
return("");
}
var strOut = "";
// select a specific entity data type for the product (used by plugins)
var themeFolder = ajaxInfo.GetXmlProperty("genxml/hidden/themefolder");
if (themeFolder == "")
{
themeFolder = "config";
}
var razortemplate = ajaxInfo.GetXmlProperty("genxml/hidden/razortemplate");
if (razortemplate == "")
{
razortemplate = "Admin_pluginsList.cshtml";
}
var passSettings = new Dictionary <string, string>();
foreach (var s in ajaxInfo.ToDictionary())
{
if (!passSettings.ContainsKey(s.Key))
{
passSettings.Add(s.Key, s.Value);
}
}
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, TemplateRelPath, themeFolder, Utils.GetCurrentCulture(), passSettings);
return(strOut);
}
return("");
}
catch (Exception ex)
{
return(ex.ToString());
}
}
private String GetData(HttpContext context, bool clearCache = false)
{
var objCtrl = new NBrightBuyController();
var strOut = "";
//get uploaded params
var ajaxInfo = NBrightBuyUtils.GetAjaxFields(context);
SetContextLangauge(ajaxInfo); // Ajax breaks context with DNN, so reset the context language to match the client.
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 = _lang;
}
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/NBrightBuy/Providers/PromoProvider";
if (Utils.IsNumeric(selecteditemid))
{
// do edit field data if a itemid has been selected
var obj = objCtrl.Get(Convert.ToInt32(selecteditemid), "", editlang);
strOut = NBrightBuyUtils.RazorTemplRender(typeCode.ToLower() + "fields.cshtml", Convert.ToInt32(moduleid), _lang + itemid + editlang + selecteditemid, obj, templateControl, "config", _lang, StoreSettings.Current.Settings());
}
else
{
// Return list of items
var l = objCtrl.GetList(PortalSettings.Current.PortalId, Convert.ToInt32(moduleid), typeCode, "", " order by [XMLData].value('(genxml/textbox/validuntil)[1]','nvarchar(50)'), ModifiedDate desc", 0, 0, 0, 0, editlang);
strOut = NBrightBuyUtils.RazorTemplRenderList(typeCode.ToLower() + "list.cshtml", Convert.ToInt32(moduleid), _lang + editlang, l, templateControl, "config", _lang, StoreSettings.Current.Settings());
}
return(strOut);
}
public static string GetProductItemListHtml(ItemListData itemListData, string listkey = "", string entityTypeCode = "PRD", string entityTypeCodeLang = "PRDLANG")
{
var strOut = "";
var rtnList = GetProductItemList(itemListData, listkey, entityTypeCode, entityTypeCodeLang);
var modelsetings = StoreSettings.Current.Settings();
if (!modelsetings.ContainsKey("listkeys"))
{
modelsetings.Add("listkeys", itemListData.listkeys);
}
strOut = NBrightBuyUtils.RazorTemplRenderList(_templatename, -1, "", rtnList, "/DesktopModules/NBright/NBrightBuy", _themeFolder, Utils.GetCurrentCulture(), modelsetings);
return(strOut);
}
private void PageLoad()
{
if (UserId > 0) // limit module to registered users
{
// new data record so set defaults.
var cw = new ItemListData(PortalId, UserController.Instance.GetCurrentUserInfo().UserID);
var objList = ItemListsFunctions.GetProductItemList(cw);
if (ModSettings.Settings().ContainsKey("listkeys"))
{
ModSettings.Settings().Remove("listkeys");
}
ModSettings.Settings().Add("listkeys", cw.listkeys);
var strOut = NBrightBuyUtils.RazorTemplRenderList(RazorTemplate, ModuleId, "", objList, ControlPath, ModSettings.ThemeFolder, Utils.GetCurrentCulture(), ModSettings.Settings());
var lit = new Literal();
lit.Text = strOut;
phData.Controls.Add(lit);
}
}
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 + "%");
}
var list = objCtrl.GetDnnUsers(portalId, "%" + searchText + "%", 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());
}
}
private string RunReport(HttpContext context)
{
var strOut = "- No Data Returned -";
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("");
var editlang = ajaxInfo.GetXmlProperty("genxml/hidden/editlang");
if (editlang == "")
{
editlang = Utils.GetCurrentCulture();
}
var selecteditemid = ajaxInfo.GetXmlPropertyInt("genxml/hidden/selecteditemid");
if (selecteditemid > 0)
{
var objCtrl = new NBrightBuyController();
var obj = objCtrl.Get(selecteditemid);
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);
if (strXmlResults != "")
{
var xdoc = XDocument.Parse(strXmlResults);
var headerInfo = new NBrightInfo(false);
headerInfo.XMLData = "<item></item>";
var elementsList = xdoc.XPathSelectElements("root/item[1]/*");
var xmlList = new List <NBrightInfo>();
if (obj.GetXmlProperty("genxml/radiobuttonlist/reportformat") == "csv")
{
var lp = 1;
foreach (XElement xmlitem in elementsList)
{
headerInfo.SetXmlProperty("item/header" + lp, xmlitem.Name.ToString());
lp += 1;
}
xmlList.Add(headerInfo);
}
foreach (XElement xmlitem in xdoc.XPathSelectElements("root/item"))
{
var nbi = new NBrightInfo(false);
nbi.XMLData = xmlitem.ToString();
xmlList.Add(nbi);
}
var templateControl = "/DesktopModules/NBright/OS_Reports";
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", editlang, StoreSettings.Current.Settings());
if (!inline)
{
var outfile = StoreSettings.Current.FolderTempMapPath + "\\" + selecteditemid + "." + obj.GetXmlProperty("genxml/radiobuttonlist/reportformat");
Utils.SaveFile(outfile, strOut);
strOut = "<br/><h1>Completed: <a target='_blank' href='" + StoreSettings.Current.FolderTemp + "/" + selecteditemid + "."
+ obj.GetXmlProperty("genxml/radiobuttonlist/reportformat") + "?key=" + Utils.GetUniqueKey() + "' >View</a></h1>";
}
}
return(strOut);
}
}
}
catch (Exception ex)
{
return(ex.ToString() + " <hr/> " + strSql);
}
return(strOut);
}
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();
}
var rundisplay = ajaxInfo.GetXmlPropertyBool("genxml/hidden/rundisplay");
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_Reports";
if (Utils.IsNumeric(selecteditemid))
{
// do edit field data if a itemid has been selected
var obj = objCtrl.Get(Convert.ToInt32(selecteditemid), "", editlang);
if (rundisplay)
{
strOut = NBrightBuyUtils.RazorTemplRender("run.cshtml", Convert.ToInt32(moduleid), itemid + editlang + selecteditemid, obj, templateControl, "config", editlang, StoreSettings.Current.Settings());
}
else
{
strOut = NBrightBuyUtils.RazorTemplRender("datafields.cshtml", Convert.ToInt32(moduleid), itemid + editlang + selecteditemid, obj, templateControl, "config", editlang, StoreSettings.Current.Settings());
}
}
else
{
var pagenumber = ajaxInfo.GetXmlPropertyInt("genxml/hidden/pagenumber");
var pagesize = ajaxInfo.GetXmlPropertyInt("genxml/hidden/pagesize");
if (pagenumber == 0)
{
pagenumber = 1;
}
if (pagesize == 0)
{
pagesize = 20;
}
var filter = "";
var searchText = ajaxInfo.GetXmlProperty("genxml/hidden/searchtext");
if (searchText != "")
{
filter += " and ( ";
filter += " (([xmldata].value('(genxml/textbox/ref)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " or (([xmldata].value('(genxml/lang/genxml/textbox/ref2)[1]', 'nvarchar(max)') like '%" + searchText + "%' collate sql_latin1_general_cp1_ci_ai ))";
filter += " ) ";
}
// get only entity type required
var recordcount = objCtrl.GetListCount(PortalSettings.Current.PortalId, -1, typeCode, filter);
// Return list of items
var l = objCtrl.GetDataList(PortalSettings.Current.PortalId, Convert.ToInt32(moduleid), typeCode, typeCode + "LANG", editlang, filter, " order by [XMLData].value('(genxml/textbox/ref)[1]','nvarchar(50)')", true, "", 0, pagenumber, pagesize, recordcount);
strOut = NBrightBuyUtils.RazorTemplRenderList("datalist.cshtml", Convert.ToInt32(moduleid), "", l, templateControl, "config", editlang, StoreSettings.Current.Settings());
if (recordcount > pagesize)
{
var pg = new NBrightCore.controls.PagingCtrl();
strOut += pg.RenderPager(recordcount, pagesize, pagenumber);
}
}
return(strOut);
}
private void RazorPageLoad()
{
NBrightInfo objCat = null;
if (_templD.Trim() != "") // if we don;t have a template, don't do anything
{
if (_displayentrypage)
{
// get correct itemid, based on eid given
_eid = GetEntryIdFromName(_eid);
RazorDisplayDataEntry(_eid);
}
else
{
// Get meta data from template
var metaTokens = NBrightBuyUtils.RazorPreProcessTempl(_templD, _controlPath, ModSettings.ThemeFolder, Utils.GetCurrentCulture(), ModSettings.Settings(), ModuleId.ToString());
#region "Order BY"
////////////////////////////////////////////
// get ORDERBY SORT
////////////////////////////////////////////
if (_orderbyindex != "") // if we have orderby set in url, find the meta tags
{
if (metaTokens.ContainsKey("orderby" + _orderbyindex))
{
if (metaTokens["orderby" + _orderbyindex].Contains("{") || metaTokens["orderby" + _orderbyindex].ToLower().Contains("order by"))
{
_navigationdata.OrderBy = metaTokens["orderby" + _orderbyindex];
_navigationdata.OrderByIdx = _orderbyindex;
}
else
{
_navigationdata.OrderBy = " Order by " + metaTokens["orderby" + _orderbyindex];
_navigationdata.OrderByIdx = _orderbyindex;
}
_navigationdata.Save();
}
}
else
{
if (String.IsNullOrEmpty(_navigationdata.OrderBy) && metaTokens.ContainsKey("orderby"))
{
if (metaTokens["orderby"].Contains("{") || metaTokens["orderby"].ToLower().Contains("order by"))
{
_navigationdata.OrderBy = metaTokens["orderby"];
}
else
{
_navigationdata.OrderBy = " Order by " + metaTokens["orderby"];
}
_navigationdata.OrderByIdx = "";
_navigationdata.Save();
}
}
#endregion
#region "Get Paging setup"
//See if we have a pagesize, uses the "searchpagesize" tag token.
// : This can be overwritten by the cookie value if we need user selection of pagesize.
CtrlPaging.Visible = false;
#region "Get pagesize, from best place"
var pageSize = 0;
if (Utils.IsNumeric(ModSettings.Get("pagesize")))
{
pageSize = Convert.ToInt32(ModSettings.Get("pagesize"));
}
// overwrite default module pagesize , if we have a pagesize control in the template
if (metaTokens.ContainsKey("selectpagesize") && Utils.IsNumeric(_navigationdata.PageSize))
{
pageSize = Convert.ToInt32(_navigationdata.PageSize);
}
//check for url param page size
if (Utils.IsNumeric(_pagesize) && (_pagemid == "" | _pagemid == ModuleId.ToString(CultureInfo.InvariantCulture)))
{
pageSize = Convert.ToInt32(_pagesize);
}
if (pageSize == 0)
{
var strPgSize = "";
if (metaTokens.ContainsKey("searchpagesize"))
{
strPgSize = metaTokens["searchpagesize"];
}
if (metaTokens.ContainsKey("pagesize") && strPgSize == "")
{
strPgSize = metaTokens["pagesize"];
}
if (Utils.IsNumeric(strPgSize))
{
pageSize = Convert.ToInt32(strPgSize);
}
}
if (pageSize > 0)
{
CtrlPaging.Visible = true;
}
_navigationdata.PageSize = pageSize.ToString("");
#endregion
var pageNumber = 1;
//check for url param paging
if (Utils.IsNumeric(_pagenum) && (_pagemid == "" | _pagemid == ModuleId.ToString(CultureInfo.InvariantCulture)))
{
pageNumber = Convert.ToInt32(_pagenum);
}
//Get returnlimt from module settings
var returnlimit = 0;
var strreturnlimit = ModSettings.Get("returnlimit");
if (Utils.IsNumeric(strreturnlimit))
{
returnlimit = Convert.ToInt32(strreturnlimit);
}
#endregion
#region "Get filter setup"
// check the display header to see if we have a sqlfilter defined.
var strFilter = "";
var sqlTemplateFilter = "";
if (metaTokens.ContainsKey("sqlfilter"))
{
sqlTemplateFilter = GenXmlFunctions.StripSqlCommands(metaTokens["sqlfilter"]);
}
if (_navigationdata.HasCriteria)
{
var paramcatid = Utils.RequestQueryStringParam(Context, "catid");
if (Utils.IsNumeric(paramcatid))
{
if (_navigationdata.CategoryId != Convert.ToInt32(paramcatid)) // filter mode DOES NOT persist catid (stop confusion when user selects a category)
{
_navigationdata.ResetSearch();
}
}
// if navdata is not deleted then get filter from navdata, created by productsearch module.
strFilter = _navigationdata.Criteria;
if (!strFilter.Contains(sqlTemplateFilter))
{
strFilter += " " + sqlTemplateFilter;
}
if (_navigationdata.Mode.ToLower() == "s")
{
_navigationdata.ResetSearch(); // single search so clear after
}
}
else
{
// reset search if category selected
// NOTE: keeping search across categories is VERY confusing for cleint, although it works logically.
_navigationdata.ResetSearch();
strFilter = sqlTemplateFilter;
}
#endregion
#region "Get Category select setup"
var objQual = DotNetNuke.Data.DataProvider.Instance().ObjectQualifier;
var dbOwner = DataProvider.Instance().DatabaseOwner;
//get default catid.
var catseo = _catid;
var defcatid = ModSettings.Get("defaultcatid");
if (defcatid == "")
{
defcatid = "0";
}
if (Utils.IsNumeric(defcatid) && Convert.ToInt32(defcatid) > 0)
{
// if we have no filter use the default category
if (_catid == "" && strFilter.Trim() == "")
{
_catid = defcatid;
}
}
else
{
defcatid = ModSettings.Get("defaultpropertyid");
if (defcatid == "")
{
defcatid = "0";
}
if (Utils.IsNumeric(defcatid))
{
// if we have no filter use the default category
if (_catid == "" && strFilter.Trim() == "")
{
_catid = defcatid;
}
}
}
// If we have a static list,then always display the default category
if (ModSettings.Get("staticlist") == "True")
{
if (catseo == "")
{
catseo = _catid;
}
_catid = defcatid;
if (ModSettings.Get("chkcascaderesults").ToLower() == "true")
{
strFilter = strFilter + " and NB1.[ItemId] in (select parentitemid from " + dbOwner + "[" + objQual + "NBrightBuy] where (typecode = 'CATCASCADE' or typecode = 'CATXREF') and XrefItemId = " + _catid + ") ";
}
else
{
strFilter = strFilter + " and NB1.[ItemId] in (select parentitemid from " + dbOwner + "[" + objQual + "NBrightBuy] where typecode = 'CATXREF' and XrefItemId = " + _catid + ") ";
}
if (ModSettings.Get("caturlfilter") == "True" && catseo != "" && catseo != _catid)
{
// add aditional filter for catid filter on url (catseo holds catid from url)
if (ModSettings.Get("chkcascaderesults").ToLower() == "true")
{
strFilter = strFilter + " and NB1.[ItemId] in (select parentitemid from " + dbOwner + "[" + objQual + "NBrightBuy] where (typecode = 'CATCASCADE' or typecode = 'CATXREF') and XrefItemId = " + catseo + ") ";
}
else
{
strFilter = strFilter + " and NB1.[ItemId] in (select parentitemid from " + dbOwner + "[" + objQual + "NBrightBuy] where typecode = 'CATXREF' and XrefItemId = " + catseo + ") ";
}
}
// do special custom sort in each cateogry, this passes the catid to the SQL SPROC, whcih process the '{bycategoryproduct}' and orders by product/category seq.
if (_navigationdata.OrderBy.Contains("{bycategoryproduct}"))
{
_navigationdata.OrderBy = "{bycategoryproduct}" + _catid;
}
}
else
{
#region "use url to get category to display"
//check if we are display categories
// get category list data
if (_catname != "") // if catname passed in url, calculate what the catid is
{
objCat = ModCtrl.GetByGuidKey(PortalId, ModuleId, "CATEGORYLANG", _catname);
if (objCat == null)
{
// check it's not just a single language
objCat = ModCtrl.GetByGuidKey(PortalId, ModuleId, "CATEGORY", _catname);
if (objCat != null)
{
_catid = objCat.ItemID.ToString("");
}
}
else
{
_catid = objCat.ParentItemId.ToString("");
if (!String.IsNullOrEmpty(objCat.GUIDKey) && Utils.IsNumeric(_catid) && objCat.Lang != Utils.GetCurrentCulture())
{
// do a 301 redirect to correct url for the langauge (If the langauge is changed on the product list, we need to make sure we have the correct catref for the langauge)
var catGrpCtrl = new GrpCatController(Utils.GetCurrentCulture());
var activeCat = catGrpCtrl.GetCategory(Convert.ToInt32(_catid));
if (activeCat != null)
{
var redirecturl = "";
if (Utils.IsNumeric(_eid))
{
var prdData = ProductUtils.GetProductData(Convert.ToInt32(_eid), Utils.GetCurrentCulture(), true, EntityTypeCode);
redirecturl = NBrightBuyUtils.GetEntryUrl(PortalId, _eid, _modkey, prdData.SEOName, TabId.ToString(), "", activeCat.categoryrefGUIDKey);
}
else
{
redirecturl = catGrpCtrl.GetCategoryUrl(activeCat, TabId, Utils.GetCurrentCulture());
}
try
{
if (redirecturl != "")
{
Response.Redirect(redirecturl, false);
Response.StatusCode = (int)System.Net.HttpStatusCode.MovedPermanently;
Response.End();
}
}
catch (Exception)
{
// catch err
}
}
}
}
// We have a category selected (in url), so overwrite categoryid navigationdata.
// This allows the return to the same category after a returning from a entry view.
if (Utils.IsNumeric(_catid))
{
_navigationdata.CategoryId = Convert.ToInt32(_catid);
}
catseo = _catid;
_navigationdata.ResetSearch();
strFilter = "";
}
if (Utils.IsNumeric(_catid))
{
if (ModSettings.Get("chkcascaderesults").ToLower() == "true")
{
strFilter = strFilter + " and NB1.[ItemId] in (select parentitemid from " + dbOwner + "[" + objQual + "NBrightBuy] where (typecode = 'CATCASCADE' or typecode = 'CATXREF') and XrefItemId = " + _catid + ") ";
}
else
{
strFilter = strFilter + " and NB1.[ItemId] in (select parentitemid from " + dbOwner + "[" + objQual + "NBrightBuy] where typecode = 'CATXREF' and XrefItemId = " + _catid + ") ";
}
if (Utils.IsNumeric(catseo))
{
var objSEOCat = ModCtrl.GetData(Convert.ToInt32(catseo), "CATEGORYLANG", Utils.GetCurrentCulture());
if (objSEOCat != null && _eid == "") // we may have a detail page and listonly module, in which can we need the product detail as page title
{
//Page Title
var seoname = objSEOCat.GetXmlProperty("genxml/lang/genxml/textbox/txtseoname");
if (seoname == "")
{
seoname = objSEOCat.GetXmlProperty("genxml/lang/genxml/textbox/txtcategoryname");
}
var newBaseTitle = objSEOCat.GetXmlProperty("genxml/lang/genxml/textbox/txtseopagetitle");
if (newBaseTitle == "")
{
newBaseTitle = objSEOCat.GetXmlProperty("genxml/lang/genxml/textbox/txtseoname");
}
if (newBaseTitle == "")
{
newBaseTitle = objSEOCat.GetXmlProperty("genxml/lang/genxml/textbox/txtcategoryname");
}
if (newBaseTitle != "")
{
BasePage.Title = newBaseTitle;
}
//Page KeyWords
var newBaseKeyWords = objSEOCat.GetXmlProperty("genxml/lang/genxml/textbox/txtmetakeywords");
if (newBaseKeyWords != "")
{
BasePage.KeyWords = newBaseKeyWords;
}
//Page Description
var newBaseDescription = objSEOCat.GetXmlProperty("genxml/lang/genxml/textbox/txtmetadescription");
if (newBaseDescription == "")
{
newBaseDescription = objSEOCat.GetXmlProperty("genxml/lang/genxml/textbox/txtcategorydesc");
}
if (newBaseDescription != "")
{
BasePage.Description = newBaseDescription;
}
// Remove canonical link for list. The Open URL Rewriter (OUR) will create a url that is different to the default SEO url in NBS.
// So to stop clashes it's been disable by default. The requirment for a canonical link on a category list is more ticking the box than of being any SEO help (might even be causing confusion to Search Engines).
// ** If your a SEO nutcases (or SEO companies pushing for it) then you can uncomment the code below, and you can implement the Open URL Rewriter and canonical link.
//if (PortalSettings.HomeTabId == TabId)
// PageIncludes.IncludeCanonicalLink(Page, Globals.AddHTTP(PortalSettings.PortalAlias.HTTPAlias)); //home page always default of site.
//else
//{
// PageIncludes.IncludeCanonicalLink(Page, NBrightBuyUtils.GetListUrl(PortalId, TabId, objSEOCat.ItemID, seoname, Utils.GetCurrentCulture()));
// // Code required for OUR (if used, test to ensure it works correctly!!)
// //PageIncludes.IncludeCanonicalLink(Page, NBrightBuyUtils.GetListUrl(PortalId, TabId, objSEOCat.ItemID, "", Utils.GetCurrentCulture()));
//}
}
}
// do special custom sort in each cateogry, this passes the catid to the SQL SPROC, whcih process the '{bycategoryproduct}' and orders by product/category seq.
if (_navigationdata.OrderBy.Contains("{bycategoryproduct}"))
{
_navigationdata.OrderBy = "{bycategoryproduct}" + _catid;
}
}
else
{
if (!_navigationdata.FilterMode)
{
_navigationdata.CategoryId = 0; // filter mode persist catid
}
if (_navigationdata.OrderBy.Contains("{bycategoryproduct}"))
{
_navigationdata.OrderBy = " Order by ModifiedDate DESC ";
}
}
#endregion
}
// This allows the return to the same category after a returning from a entry view. + Gives support for current category in razor tokens
if (Utils.IsNumeric(_catid))
{
_navigationdata.CategoryId = Convert.ToInt32(_catid);
}
#endregion
#region "Apply provider product filter"
// Special filtering can be done, by using the ProductFilter interface.
var productfilterkey = "";
if (metaTokens.ContainsKey("providerfilterkey"))
{
productfilterkey = metaTokens["providerfilterkey"];
}
if (productfilterkey != "")
{
var provfilter = FilterInterface.Instance(productfilterkey);
if (provfilter != null)
{
strFilter = provfilter.GetFilter(strFilter, _navigationdata, ModSettings, Context);
}
}
#endregion
#region "itemlists (wishlist)"
// if we have a itemListName field then get the itemlist cookie.
if (ModSettings.Get("displaytype") == "2") // displaytype 2 = "selected list"
{
var cw = new ItemListData(PortalId, UserController.Instance.GetCurrentUserInfo().UserID);
if (cw.Exists && cw.ItemCount > 0)
{
strFilter = " and (";
foreach (var i in cw.GetItemList())
{
strFilter += " NB1.itemid = '" + i + "' or";
}
strFilter = strFilter.Substring(0, (strFilter.Length - 3)) + ") ";
// remove the last "or"
}
else
{
//no data in list so select false itemid to stop anything displaying
strFilter += " and (NB1.itemid = '-1') ";
}
}
#endregion
// insert page header text
NBrightBuyUtils.RazorIncludePageHeader(ModuleId, Page, Path.GetFileNameWithoutExtension(_templD) + "_head" + Path.GetExtension(_templD), _controlPath, ModSettings.ThemeFolder, ModSettings.Settings());
// save navigation data
_navigationdata.PageModuleId = Utils.RequestParam(Context, "pagemid");
_navigationdata.PageNumber = Utils.RequestParam(Context, "page");
if (Utils.IsNumeric(_catid))
{
_navigationdata.PageName = NBrightBuyUtils.GetCurrentPageName(Convert.ToInt32(_catid));
}
// save the last active modulekey to a cookie, so it can be used by the "NBrightBuyUtils.GetReturnUrl" function
NBrightCore.common.Cookie.SetCookieValue(PortalId, "NBrigthBuyLastActive", "ModuleKey", ModuleKey, 1);
if (strFilter.Trim() == "")
{
// if at this point we have no filter, then assume we're using urlrewriter and a 404 url has been entered.
// rather than display all visible products in a list with no default.
// redirect to the product display function, so we can display a 404 and product not found.
RazorDisplayDataEntry(_eid);
}
else
{
strFilter += " and (NB3.Visible = 1) "; // get only visible products
var recordCount = ModCtrl.GetDataListCount(PortalId, ModuleId, EntityTypeCode, strFilter, EntityTypeCodeLang, Utils.GetCurrentCulture(), DebugMode);
_navigationdata.RecordCount = recordCount.ToString("");
_navigationdata.Save();
if (returnlimit > 0 && returnlimit < recordCount)
{
recordCount = returnlimit;
}
// **** check if we already have the template cached, if so no need for DB call or razor call ****
// get same cachekey used for DB return, and use for razor.
var razorcachekey = ModCtrl.GetDataListCacheKey(PortalId, ModuleId, EntityTypeCode, EntityTypeCodeLang, Utils.GetCurrentCulture(), strFilter, _navigationdata.OrderBy, DebugMode, "", returnlimit, pageNumber, pageSize, recordCount);
var cachekey = "NBrightBuyRazorOutput" + _templD + "*" + razorcachekey + PortalId.ToString();
var strOut = (String)NBrightBuyUtils.GetModCache(cachekey);
if (strOut == null || StoreSettings.Current.DebugMode)
{
var l = ModCtrl.GetDataList(PortalId, ModuleId, EntityTypeCode, EntityTypeCodeLang, Utils.GetCurrentCulture(), strFilter, _navigationdata.OrderBy, DebugMode, "", returnlimit, pageNumber, pageSize, recordCount);
strOut = NBrightBuyUtils.RazorTemplRenderList(_templD, ModuleId, razorcachekey, l, _controlPath, ModSettings.ThemeFolder, Utils.GetCurrentCulture(), ModSettings.Settings());
}
var lit = new Literal();
lit.Text = strOut;
phData.Controls.Add(lit);
if (_navigationdata.SingleSearchMode)
{
_navigationdata.ResetSearch();
}
if (pageSize > 0)
{
CtrlPaging.PageSize = pageSize;
CtrlPaging.CurrentPage = pageNumber;
CtrlPaging.TotalRecords = recordCount;
CtrlPaging.BindPageLinks();
}
}
}
}
}
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);
}
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);
}
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);
}
public static String RenderProductAdminList(List <NBrightInfo> list, NBrightInfo ajaxInfo, int recordCount)
{
try
{
if (NBrightBuyUtils.CheckRights())
{
if (list == null)
{
return("");
}
if (UserController.Instance.GetCurrentUserInfo().UserID <= 0)
{
return("");
}
var strOut = "";
// select a specific entity data type for the product (used by plugins)
var themeFolder = "config";
var pageNumber = ajaxInfo.GetXmlPropertyInt("genxml/hidden/pagenumber");
var pageSize = ajaxInfo.GetXmlPropertyInt("genxml/hidden/pagesize");
var razortemplate = ajaxInfo.GetXmlProperty("genxml/hidden/razortemplate");
var editlang = ajaxInfo.GetXmlProperty("genxml/hidden/editlang");
if (editlang == "")
{
editlang = Utils.GetCurrentCulture();
}
var templateControl = "/DesktopModules/NBright/OS_BulkEdit";
bool paging = pageSize > 0;
var passSettings = new Dictionary <string, string>();
foreach (var s in ajaxInfo.ToDictionary())
{
passSettings.Add(s.Key, s.Value);
}
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, templateControl, themeFolder, editlang, 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());
}
}
public static String ProductAdminList(Dictionary <string, string> settings, bool paging = true)
{
try
{
if (NBrightBuyUtils.CheckManagerRights())
{
if (UserController.Instance.GetCurrentUserInfo().UserID <= 0)
{
return("");
}
var strOut = "";
if (!settings.ContainsKey("themefolder"))
{
settings.Add("themefolder", "");
}
if (!settings.ContainsKey("razortemplate"))
{
settings.Add("razortemplate", "");
}
if (!settings.ContainsKey("header"))
{
settings.Add("header", "");
}
if (!settings.ContainsKey("body"))
{
settings.Add("body", "");
}
if (!settings.ContainsKey("footer"))
{
settings.Add("footer", "");
}
if (!settings.ContainsKey("filter"))
{
settings.Add("filter", "");
}
if (!settings.ContainsKey("orderby"))
{
settings.Add("orderby", "");
}
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("searchcategory"))
{
settings.Add("searchcategory", "");
}
if (!settings.ContainsKey("cascade"))
{
settings.Add("cascade", "False");
}
if (!settings.ContainsKey("portalid"))
{
settings.Add("portalid", PortalSettings.Current.PortalId.ToString("")); // aways make sure we have portalid in settings
}
// select a specific entity data type for the product (used by plugins)
if (!settings.ContainsKey("entitytypecode"))
{
settings.Add("entitytypecode", "PRD");
}
if (!settings.ContainsKey("entitytypecodelang"))
{
settings.Add("entitytypecodelang", "PRDLANG");
}
var entitytypecodelang = settings["entitytypecodelang"];
var entitytypecode = settings["entitytypecode"];
var themeFolder = settings["themefolder"];
var header = settings["header"];
var body = settings["body"];
var footer = settings["footer"];
var filter = settings["filter"];
var orderby = settings["orderby"];
var returnLimit = Convert.ToInt32(settings["returnlimit"]);
var pageNumber = Convert.ToInt32(settings["pagenumber"]);
var pageSize = Convert.ToInt32(settings["pagesize"]);
var cascade = Convert.ToBoolean(settings["cascade"]);
var razortemplate = settings["razortemplate"];
var portalId = Convert.ToInt32(settings["portalid"]);
var searchText = settings["searchtext"];
var searchCategory = settings["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;
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, entitytypecode, filter, entitytypecodelang, Utils.GetCurrentCulture());
}
// get selected entitytypecode.
var list = objCtrl.GetDataList(PortalSettings.Current.PortalId, -1, entitytypecode, entitytypecodelang, Utils.GetCurrentCulture(), filter, orderby, StoreSettings.Current.DebugMode, "", returnLimit, 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());
}
}
