public AutomatizationManagerBase() { this._message = new List <AutomatizationToSkypeMessage>(); this._mobilePaywallDatabase = new MobilePaywallDatabase(); this._kiwiclicksDatabase = new KiwiclicksDatabase(); this._transactionManager = new TransactionManager(this); this._running = true; this.Restart(); }
public void Update(KiwiclicksDatabase database, bool isActive) { this._isActive = isActive; string inactive = !this._isActive ? "0" : "1"; string command = KiwiclicksOfferEntry.SqlCommandUpdate. Replace(KiwiclicksOfferEntry.SqlIDWildcard, this._id.ToString()). Replace(KiwiclicksOfferEntry.SqlInactiveWildcard, inactive). Replace(KiwiclicksOfferEntry.SqlUrlWildcard, this._url); database.Execute(command); }
// SUMMARY: Load all public static List <KiwiclicksOfferEntry> LoadMany(KiwiclicksDatabase database, List <AutomationEntry> automations) { List <KiwiclicksOfferEntry> result = new List <KiwiclicksOfferEntry>(); if (automations == null || automations.Count == 0) { return(result); } string names = ""; foreach (AutomationEntry ae in automations) { if (ae.IsActive && !string.IsNullOrEmpty(ae.ExternalOfferName)) { if (names != "") { names += ","; } names += string.Format("'{0}'", ae.ExternalOfferName); } } string command = KiwiclicksOfferEntry.SqlCommandMany.Replace(KiwiclicksOfferEntry.SqlNameWildcard, names); DataTable table = database.Load(command); if (table == null) { return(result); } foreach (DataRow row in table.Rows) { KiwiclicksOfferEntry entry = new KiwiclicksOfferEntry(); entry.ID = Int32.Parse(row[(int)KiwiclicksOfferEntry.Columns.ID].ToString()); entry.Name = row[(int)KiwiclicksOfferEntry.Columns.Name].ToString(); entry.Url = row[(int)KiwiclicksOfferEntry.Columns.OfferUrl].ToString(); entry.IsActive = row[(int)KiwiclicksOfferEntry.Columns.OfferInactive].ToString().Equals("0"); result.Add(entry); } return(result); }