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