public override void DoWork()
{
try
{
var portallist = DnnUtils.GetAllPortals();
foreach (var portal in portallist)
{
var storeSettings = new StoreSettings(portal.PortalID);
if (Directory.Exists(storeSettings.FolderTempMapPath))
{
// clear old carts
var objCtrl = new NBrightBuyController();
var objQual = DotNetNuke.Data.DataProvider.Instance().ObjectQualifier;
var dbOwner = DotNetNuke.Data.DataProvider.Instance().DatabaseOwner;
var days = 60;
var d = DateTime.Now.AddDays(days * -1);
var strDate = d.ToString("s");
var stmt = "";
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + portal.PortalID.ToString("") + " and typecode = 'CART' and ModifiedDate < '" + strDate + "' ";
objCtrl.ExecSql(stmt);
// clear down NBStore temp folder
string[] files = Directory.GetFiles(storeSettings.FolderTempMapPath);
foreach (string file in files)
{
FileInfo fi = new FileInfo(file);
if (fi.LastAccessTime < DateTime.Now.AddHours(-1))
{
fi.Delete();
}
}
// DO Scheduler Jobs
var pluginData = new PluginData(portal.PortalID);
var l = pluginData.GetSchedulerProviders();
foreach (var p in l)
{
var prov = p.Value;
ObjectHandle handle = null;
handle = Activator.CreateInstance(prov.GetXmlProperty("genxml/textbox/assembly"), prov.GetXmlProperty("genxml/textbox/namespaceclass"));
if (handle != null)
{
var objProvider = (SchedulerInterface)handle.Unwrap();
var strMsg = objProvider.DoWork(portal.PortalID);
if (strMsg != "")
{
this.ScheduleHistoryItem.AddLogNote(strMsg);
}
}
}
}
}
this.ScheduleHistoryItem.Succeeded = true;
}
catch (Exception Ex)
{
//--intimate the schedule mechanism to write log note in schedule history
this.ScheduleHistoryItem.Succeeded = false;
this.ScheduleHistoryItem.AddLogNote("NBS Service Start. Failed. " + Ex.ToString());
this.Errored(ref Ex);
}
}
private void PurgeCarts()
{
var objCtrl = new NBrightBuyController();
var objQual = DotNetNuke.Data.DataProvider.Instance().ObjectQualifier;
var dbOwner = DotNetNuke.Data.DataProvider.Instance().DatabaseOwner;
if (Utils.IsNumeric(GenXmlFunctions.GetField(rpData, "purgecartsdays")))
{
var days = Convert.ToInt32(GenXmlFunctions.GetField(rpData, "purgecartsdays"));
var d = DateTime.Now.AddDays(days * -1);
var strDate = d.ToString("s");
var stmt = "";
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'CART' and ModifiedDate < '" + strDate + "' ";
objCtrl.ExecSql(stmt);
}
}
private void DoClearDown()
{
var pass = GenXmlFunctions.GetField(rpData, "txtclearpass");
if (pass == StoreSettings.Current.Get("adminpin") && pass != "")
{
var done = false;
var objCtrl = new NBrightBuyController();
var objQual = DotNetNuke.Data.DataProvider.Instance().ObjectQualifier;
var dbOwner = DotNetNuke.Data.DataProvider.Instance().DatabaseOwner;
var stmt = "";
if (GenXmlFunctions.GetField(rpData, "clearproducts") == "True")
{
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'PRD' ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'PRDLANG' ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'AMY' ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'AMYLANG' ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'PRDXREF' ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'USERPRDXREF' ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'CATCASCADE' ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'CATXREF' ";
objCtrl.ExecSql(stmt);
done = true;
}
if (GenXmlFunctions.GetField(rpData, "clearcategories") == "True")
{
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'CATEGORY' and [XMLData].value('(genxml/dropdownlist/ddlgrouptype)[1]','nvarchar(max)') = 'cat' ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'CATEGORYLANG' and ParentItemId not in (Select itemid from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'CATEGORY') ";
objCtrl.ExecSql(stmt);
done = true;
}
if (GenXmlFunctions.GetField(rpData, "clearpropertiesonly") == "True")
{
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'CATEGORY' and [XMLData].value('(genxml/dropdownlist/ddlgrouptype)[1]','nvarchar(max)') != 'cat' ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'CATEGORYLANG' and ParentItemId not in (Select itemid from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'CATEGORY') ";
objCtrl.ExecSql(stmt);
done = true;
}
if (GenXmlFunctions.GetField(rpData, "clearproperties") == "True")
{
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'CATEGORY' and [XMLData].value('(genxml/dropdownlist/ddlgrouptype)[1]','nvarchar(max)') != 'cat' ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'CATEGORYLANG' and ParentItemId not in (Select itemid from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'CATEGORY') ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'GROUP' ";
objCtrl.ExecSql(stmt);
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'GROUPLANG' ";
objCtrl.ExecSql(stmt);
done = true;
}
if (GenXmlFunctions.GetField(rpData, "clearorders") == "True")
{
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where PortalId = " + PortalId.ToString("") + " and typecode = 'ORDER' ";
objCtrl.ExecSql(stmt);
done = true;
}
DataCache.ClearCache();
if (done) NBrightBuyUtils.SetNotfiyMessage(ModuleId, "deletecompleted", NotifyCode.ok);
}
else
{
NBrightBuyUtils.SetNotfiyMessage(ModuleId, "nopin", NotifyCode.fail);
}
}
public void RemoveRelatedProduct(int productid)
{
var parentitemid = Info.ItemID.ToString("");
var xrefitemid = productid.ToString("");
var objCtrl = new NBrightBuyController();
var objQual = DotNetNuke.Data.DataProvider.Instance().ObjectQualifier;
var dbOwner = DotNetNuke.Data.DataProvider.Instance().DatabaseOwner;
var stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where typecode = 'PRDXREF' and XrefItemId = " + xrefitemid + " and parentitemid = " + parentitemid;
objCtrl.ExecSql(stmt);
}
public void RemoveCategory(int categoryid)
{
var objCtrl = new NBrightBuyController();
if (Utils.IsNumeric(DataRecord.GetXmlProperty("genxml/defaultcatid")) && categoryid == Convert.ToInt32(DataRecord.GetXmlProperty("genxml/defaultcatid")))
{
DataRecord.SetXmlProperty("genxml/defaultcatid", "");
objCtrl.Update(DataRecord);
}
var parentitemid = Info.ItemID.ToString("");
var xrefitemid = categoryid.ToString("");
var objQual = DotNetNuke.Data.DataProvider.Instance().ObjectQualifier;
var dbOwner = DotNetNuke.Data.DataProvider.Instance().DatabaseOwner;
var stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where typecode = 'CATXREF' and XrefItemId = " + xrefitemid + " and parentitemid = " + parentitemid;
objCtrl.ExecSql(stmt);
//remove all cascade xref
var objGrpCtrl = new GrpCatController(_lang, true);
var parentcats = objGrpCtrl.GetCategory(Convert.ToInt32(xrefitemid));
if (parentcats != null)
{
foreach (var p in parentcats.Parents)
{
var xreflist = objCtrl.GetList(_portalId, -1, "CATXREF", " and NB1.parentitemid = " + parentitemid);
if (xreflist != null)
{
var deleterecord = true;
foreach (var xref in xreflist)
{
var catid = xref.XrefItemId;
var xrefparentcats = objGrpCtrl.GetCategory(Convert.ToInt32(catid));
if (xrefparentcats != null && xrefparentcats.Parents.Contains(p))
{
deleterecord = false;
break;
}
}
if (deleterecord)
{
stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where typecode = 'CATCASCADE' and XrefItemId = " + p.ToString("") + " and parentitemid = " + parentitemid;
objCtrl.ExecSql(stmt);
}
}
}
}
}
public void RemoveClient(int userid)
{
var parentitemid = Info.ItemID.ToString("");
var objCtrl = new NBrightBuyController();
var objQual = DotNetNuke.Data.DataProvider.Instance().ObjectQualifier;
var dbOwner = DotNetNuke.Data.DataProvider.Instance().DatabaseOwner;
var stmt = "delete from " + dbOwner + "[" + objQual + "NBrightBuy] where typecode = 'USERPRDXREF' and UserId = " + userid.ToString("") + " and parentitemid = " + parentitemid;
objCtrl.ExecSql(stmt);
}
