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