public static List <AutomationGroupEntry> LoadMany(MobilePaywallDatabase database) { List <AutomationGroupEntry> result = new List <AutomationGroupEntry>(); DataTable table = database.Load(AutomationGroupEntry.SqlCommandMany); if (table == null) { return(result); } foreach (DataRow row in table.Rows) { AutomationGroupEntry entry = new AutomationGroupEntry(); entry.ID = Int32.Parse(row[(int)AutomationGroupEntry.Columns.ID].ToString()); CountryEntry country = new CountryEntry(); country.ID = Int32.Parse(row[(int)AutomationGroupEntry.Columns.CountryID].ToString()); country.GlobalName = row[(int)AutomationGroupEntry.Columns.CountryGlobalName].ToString(); country.TwoLetterIsoCode = row[(int)AutomationGroupEntry.Columns.CountryTwoLetterIsoCode].ToString(); entry.Country = country; entry.Name = row[(int)AutomationGroupEntry.Columns.Name].ToString(); entry.RotationTime = Int32.Parse(row[(int)AutomationGroupEntry.Columns.RotationTime].ToString()); entry.StartTime = row[(int)AutomationGroupEntry.Columns.StartTime].ToString(); entry.EndTime = row[(int)AutomationGroupEntry.Columns.EndTime].ToString(); entry.IsActive = (bool)row[(int)AutomationGroupEntry.Columns.IsActive]; entry.AutoStart = (bool)row[(int)AutomationGroupEntry.Columns.AutoStart]; entry.Created = row[(int)AutomationGroupEntry.Columns.Created].ToString(); entry.Loaded = DateTime.Now; result.Add(entry); } return(result); }
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 static List <TransactionEntry> Load(MobilePaywallDatabase database, string query) { List <TransactionEntry> result = new List <TransactionEntry>(); DataTable table = database.Load(query); if (table == null) { return(result); } foreach (DataRow row in table.Rows) { TransactionEntry entry = new TransactionEntry(); entry.Count = Int32.Parse(row[(int)TransactionEntry.Columns.Count].ToString()); entry.ServiceID = Int32.Parse(row[(int)TransactionEntry.Columns.Service].ToString()); entry.Created = DateTime.Now; result.Add(entry); } return(result); }
public static List <AutomationEntry> Load(MobilePaywallDatabase database, List <AutomationGroupEntry> groups) { List <AutomationEntry> result = new List <AutomationEntry>(); if (groups == null || groups.Count == 0) { return(result); } string ids = ""; foreach (AutomationGroupEntry ge in groups) { if (!ids.Equals("")) { ids += ","; } ids += ge.ID; } DataTable table = database.Load(AutomationEntry.SqlCommand.Replace(AutomationEntry.SqlIndexWildcard, ids)); if (table == null) { return(result); } foreach (DataRow row in table.Rows) { AutomationEntry entry = new AutomationEntry(); entry.ID = Int32.Parse(row[(int)AutomationEntry.Columns.ID].ToString()); entry.Name = row[(int)AutomationEntry.Columns.Name].ToString(); ServiceEntry service = new ServiceEntry(); service.ID = Int32.Parse(row[(int)AutomationEntry.Columns.ServiceID].ToString()); service.Name = row[(int)AutomationEntry.Columns.ServiceName].ToString(); service.Description = row[(int)AutomationEntry.Columns.ServiceDescription].ToString(); entry.Service = service; MobileOperatorEntry mobileOperator = null; if (row[(int)AutomationEntry.Columns.MobileOperatorID] != DBNull.Value) { mobileOperator = new MobileOperatorEntry(); mobileOperator.ID = Int32.Parse(row[(int)AutomationEntry.Columns.MobileOperatorID].ToString()); mobileOperator.Name = row[(int)AutomationEntry.Columns.MobileOperatorID].ToString(); } entry.MobileOperator = mobileOperator; entry.AutomationGroupID = Int32.Parse(row[(int)AutomationEntry.Columns.AutomationGroupID].ToString()); entry.TransactionLimit = Int32.Parse(row[(int)AutomationEntry.Columns.Limit].ToString()); entry.ExternalOfferName = row[(int)AutomationEntry.Columns.ExternalOfferName].ToString(); entry.IsActive = (bool)row[(int)AutomationEntry.Columns.IsActive]; entry.Index = Int32.Parse(row[(int)AutomationEntry.Columns.Index].ToString()); entry.Comment = row[(int)AutomationEntry.Columns.Comment].ToString(); entry.Created = row[(int)AutomationEntry.Columns.Created].ToString(); result.Add(entry); } return(result); }