private String AddNew(String moduleid, String typeCode) { if (!Utils.IsNumeric(moduleid)) { moduleid = "-2"; // -2 for razor } var objCtrl = new NBrightBuyController(); var nbi = new NBrightInfo(true); nbi.PortalId = PortalSettings.Current.PortalId; nbi.TypeCode = typeCode; nbi.ModuleId = Convert.ToInt32(moduleid); nbi.ItemID = -1; var itemId = objCtrl.Update(nbi); nbi.ItemID = itemId; foreach (var lang in DnnUtils.GetCultureCodeList(PortalSettings.Current.PortalId)) { var nbi2 = new NBrightInfo(true); nbi2.PortalId = PortalSettings.Current.PortalId; nbi2.TypeCode = typeCode + "LANG"; nbi2.ModuleId = Convert.ToInt32(moduleid); nbi2.ItemID = -1; nbi2.Lang = lang; nbi2.ParentItemId = itemId; nbi2.GUIDKey = ""; nbi2.ItemID = objCtrl.Update(nbi2); } NBrightBuyUtils.RemoveModCache(nbi.ModuleId); return(nbi.ItemID.ToString("")); }
private String DeleteData(HttpContext context) { var objCtrl = new NBrightBuyController(); //get uploaded params var ajaxInfo = NBrightBuyUtils.GetAjaxFields(context); var itemid = ajaxInfo.GetXmlProperty("genxml/hidden/itemid"); if (Utils.IsNumeric(itemid)) { var nbi = objCtrl.Get(Convert.ToInt32(itemid)); if (nbi != null) { var typecode = nbi.TypeCode; // run the promo before delete, so we remove any promo data that may exist. if (typecode == "CATEGORYPROMO") { PromoUtils.RemoveGroupProductPromo(PortalSettings.Current.PortalId, nbi.ItemID); } if (typecode == "MULTIBUYPROMO") { PromoUtils.RemoveMultiBuyProductPromo(PortalSettings.Current.PortalId, nbi.ItemID); } // delete DB record objCtrl.Delete(nbi.ItemID); } NBrightBuyUtils.RemoveModCache(-2); } return(""); }
/// ----------------------------------------------------------------------------- /// <summary> /// ImportModule implements the IPortable ImportModule Interface /// </summary> /// <remarks> /// </remarks> /// <param name = "ModuleID">The ID of the Module being imported</param> /// <param name = "Content">The Content being imported</param> /// <param name = "Version">The Version of the Module Content being imported</param> /// <param name = "UserId">The UserID of the User importing the Content</param> /// <history> /// </history> /// ----------------------------------------------------------------------------- public void ImportModule(int ModuleID, string Content, string Version, int UserId) { var xmlDoc = new XmlDocument(); var objModCtrl = new ModuleController(); var objModInfo = objModCtrl.GetModule(ModuleID); if (objModInfo != null) { var objImp = new NBrightInfo(false); objImp.FromXmlItem(Content); objImp.ModuleId = ModuleID; objImp.PortalId = objModInfo.PortalID; objImp.ItemID = -1; // create new record //delete the old setting record. var moduleSettings = NBrightBuyUtils.GetSettings(objModInfo.PortalID, ModuleID, "", false); if (moduleSettings.ItemID > -1) { Delete(moduleSettings.ItemID); } Update(objImp); NBrightBuyUtils.RemoveModCache(ModuleID); } }
protected void UpdateData() { if (CtrlTypeCode != "") { // read any existing data or create new. var objInfo = NBrightBuyUtils.GetSettings(PortalId, ModuleId, CtrlTypeCode, false); // populate changed data objInfo.ModifiedDate = DateTime.Now; //rebuild xml objInfo.XMLData = GenXmlFunctions.GetGenXml(RpData); objInfo = EventBeforeUpdate(RpData, objInfo); objInfo.ItemID = ModCtrl.Update(objInfo); EventAfterUpdate(RpData, objInfo); // clear any store level cache, might be overkill to clear ALL Store cache, // but editing of settings should only happen when changes are being made. NBrightBuyUtils.RemoveModCache(-1); NBrightBuyUtils.RemoveModCache(ModuleId); } }
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 override void UpdateSettings() { try { base.UpdateSettings(); NBrightBuyUtils.RemoveModCache(ModuleId); UpdateData(); } catch (Exception exc) { Exceptions.ProcessModuleLoadException(this, exc); } }
protected override void OnInit(EventArgs e) { //Remove any cache for the module, we don't want any cache in/after the BO editing. NBrightBuyUtils.RemoveModCache(ModuleId); // add required controls. RpData = new Repeater(); RpData.ItemCommand += CtrlItemCommand; this.Controls.Add(RpData); //set default Data controller ModCtrl = new NBrightBuyController(); #region "Get all Settings for module" //get Model Level Settings ModSettings = new ModSettings(ModuleId, Settings); #endregion var strTemplate = ""; if (!String.IsNullOrEmpty(CtrlPluginPath)) { //search plugin path for template strTemplate = NBrightBuyUtils.GetTemplateData(CtrlTypeCode + "_Settings.html", CtrlPluginPath, "config", ModSettings.Settings()); } if (strTemplate == "") { // add themefolder to settings, incase module has independant theme. strTemplate = ModCtrl.GetTemplateData(ModSettings, CtrlTypeCode + "_Settings.html", Utils.GetCurrentCulture(), StoreSettings.Current.DebugMode); } if (strTemplate != "") { RpData.ItemTemplate = NBrightBuyUtils.GetGenXmlTemplate(strTemplate, ModSettings.Settings(), PortalSettings.HomeDirectory); } //add template provider to NBright Templating NBrightCore.providers.GenXProviderManager.AddProvider("NBrightBuy,Nevoweb.DNN.NBrightBuy.render.GenXmlTemplateExt"); var pInfo = ModCtrl.GetByGuidKey(PortalId, -1, "PROVIDERS", "NBrightTempalteProviders"); if (pInfo != null) { NBrightCore.providers.GenXProviderManager.AddProvider(pInfo.XMLDoc); } base.OnInit(e); }
private String DeleteData(HttpContext context) { var objCtrl = new NBrightBuyController(); //get uploaded params var ajaxInfo = NBrightBuyUtils.GetAjaxFields(context); var itemid = ajaxInfo.GetXmlProperty("genxml/hidden/itemid"); if (Utils.IsNumeric(itemid)) { // delete DB record objCtrl.Delete(Convert.ToInt32(itemid)); NBrightBuyUtils.RemoveModCache(-2); } return(""); }
private String GetData(HttpContext context, bool clearCache = false) { var objCtrl = new NBrightBuyController(); var strOut = ""; //get uploaded params var ajaxInfo = NBrightBuyUtils.GetAjaxFields(context); var guidkey = ajaxInfo.GetXmlProperty("genxml/hidden/guidkey"); var typeCode = ajaxInfo.GetXmlProperty("genxml/hidden/typecode"); 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)); } var templateControl = "/DesktopModules/NBright/NBrightBuyOpenUrlRewriter"; // get data record with language var obj = objCtrl.GetByGuidKey(PortalSettings.Current.PortalId, Convert.ToInt32(moduleid), typeCode, guidkey); if (obj == null) { var itemId = AddNew(moduleid, typeCode); obj = objCtrl.Get(itemId); } var objData = objCtrl.GetData(obj.ItemID, typeCode + "LANG", editlang); //strOut = NBrightBuyUtils.RazorTemplRender(typeCode.ToLower() + "fields.cshtml", Convert.ToInt32(moduleid), _lang + guidkey + editlang, objData, templateControl, "config", editlang, StoreSettings.Current.Settings()); return(strOut); }
/// <summary> /// Save cart /// </summary> public void Save(Boolean portallevelsave = true) { //save cart var strXml = "<plugin>"; var lp = 0; foreach (var info in _pluginList) { info.SetXmlProperty("genxml/hidden/index", lp.ToString(""), TypeCode.String, false); info.SetXmlProperty("genxml/textbox/ctrl", info.GetXmlProperty("genxml/textbox/ctrl").Trim().ToLower()); strXml += info.XMLData; lp += 1; } strXml += "</plugin>"; var nbi = new NBrightInfo(true); nbi.RemoveXmlNode("genxml/plugin"); nbi.AddXmlNode(strXml, "plugin", "genxml"); _templCtrl.SaveTemplate("menuplugin.xml", nbi.XMLData, portallevelsave); NBrightBuyUtils.RemoveModCache(0); Load(); // reload newly created plugin file, to ensure cache and pluigin list is correct. }
protected void CtrlItemCommand(object source, RepeaterCommandEventArgs e) { var cArg = e.CommandArgument.ToString(); var param = new string[3]; switch (e.CommandName.ToLower()) { case "addnew": var groupData = new GroupData(-1, EditLanguage); Response.Redirect(NBrightBuyUtils.AdminUrl(TabId, param), true); break; case "delete": if (Utils.IsNumeric(cArg)) { ModCtrl.Delete(Convert.ToInt32(cArg)); } Response.Redirect(NBrightBuyUtils.AdminUrl(TabId, param), true); break; case "saveall": SaveAll(); NBrightBuyUtils.SetNotfiyMessage(ModuleId, NotifyRef + "save", NotifyCode.ok); NBrightBuyUtils.RemoveModCache(-1); //clear any cache Response.Redirect(NBrightBuyUtils.AdminUrl(TabId, param), true); break; case "move": if (Utils.IsNumeric(cArg)) { MoveRecord(Convert.ToInt32(cArg)); } Response.Redirect(NBrightBuyUtils.AdminUrl(TabId, param), true); break; } }
public void RemovePortalLevel() { _templCtrl.RemovePortalLevelTemplate("menuplugin.xml"); NBrightBuyUtils.RemoveModCache(0); }
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(""); }
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); }
public static string GetRelatedCats(int portalId, string parentItemId, string cultureCode, string templatePrefix, string controlMapPath, Boolean AllowCache = true) { var strOut = ""; if (Utils.IsNumeric(parentItemId)) { if (!AllowCache) { //Remove any cache for the module -1, we don't want any cache in BO //All xref records are portal wide, hence -1 in cahce key. NBrightBuyUtils.RemoveModCache(-1); } var objCtrl = new NBrightBuyController(); var templCtrl = new TemplateController(controlMapPath); var hTempl = templCtrl.GetTemplateData(templatePrefix + "_" + ModuleEventCodes.selectedheader + ".html", Utils.GetCurrentCulture()); var bTempl = templCtrl.GetTemplateData(templatePrefix + "_" + ModuleEventCodes.selectedbody + ".html", Utils.GetCurrentCulture()); var fTempl = templCtrl.GetTemplateData(templatePrefix + "_" + ModuleEventCodes.selectedfooter + ".html", Utils.GetCurrentCulture()); // replace Settings tags for ajax to work. hTempl = Utils.ReplaceUrlTokens(hTempl); bTempl = Utils.ReplaceUrlTokens(bTempl); fTempl = Utils.ReplaceUrlTokens(fTempl); var strFilter = " and parentitemid = " + parentItemId; var strOrderBy = GenXmlFunctions.GetSqlOrderBy(hTempl); if (strOrderBy == "") { strOrderBy = GenXmlFunctions.GetSqlOrderBy(bTempl); } var l = objCtrl.GetList(portalId, -1, "CATXREF", strFilter, strOrderBy); var objList = new List <NBrightInfo>(); foreach (var objXref in l) { var o = objCtrl.Get(objXref.XrefItemId, "CATEGORYLANG", cultureCode); if (o != null) { if (objXref.GetXmlProperty("genxml/hidden/defaultcat") != "") { // set the default flag in the category, for display in the entry only. o.SetXmlProperty("genxml/hidden/defaultcat", "True"); } o.GUIDKey = objXref.ItemID.ToString(); // overwrite with xref itemid for delete ajax action. o.TextData = o.GetXmlProperty("genxml/lang/genxml/textbox/txtname"); // set for sort o.Lang = cultureCode; // set lang so the GenXmlTemplateExt can pickup the edit langauge. objList.Add(o); objList.Sort(delegate(NBrightInfo p1, NBrightInfo p2) { return(p1.TextData.CompareTo(p2.TextData)); }); } } var obj = new NBrightInfo(); strOut += GenXmlFunctions.RenderRepeater(obj, hTempl); strOut += GenXmlFunctions.RenderRepeater(objList, bTempl); strOut += GenXmlFunctions.RenderRepeater(obj, fTempl); } 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); }