public Boolean Update()
{
Boolean success = false;
DataLayer.MSSQL mssql = null;
try
{
mssql = new DataLayer.MSSQL(ConnectionString);
QueueId = mssql.ExecuteScalar(StoredProcedures.Queues_Update.ToString(),
"@QueueId", QueueId,
"@ServerId", ServerId,
"@Error,", Error,
"@Priority", Priority,
"@Status", Status,
"@Url", Url,
"@DequeuedOn", DequeuedOn,
"@StartedOn", StartedOn,
"@DownloadedOn", DownloadedOn,
"@ParsedOn", ParsedOn,
"@FinishedOn", FinishedOn,
"@Attempt", Attempt,
"@Results", Results);
success = QueueId > 0;
}
catch (Exception ex) { throw new Exceptions.BusinessLogicException("Error saving queue.", ex); }
finally { if (mssql != null) mssql.Dispose(); }
return success;
}
public bool ByQueueId(long queueId)
{
bool success = false;
DataRow row = null;
DataLayer.MSSQL mssql = null;
try
{
mssql = new DataLayer.MSSQL(ConnectionString);
row = mssql.GetDataRow(StoredProcedures.Queues_Select_ByQueueId.ToString(),
"@QueueId", queueId);
if (row != null)
success = row.TryParse<Queue>(this) && QueueId > 0;
}
catch (Exception ex) { throw new Exceptions.BusinessLogicException("Error loading queue.", ex); }
finally { if (mssql != null) mssql.Dispose(); }
return success;
}
public Boolean Update()
{
Boolean success = false;
DataLayer.MSSQL mssql = null;
try
{
mssql = new DataLayer.MSSQL(ConnectionString);
LeadId = mssql.ExecuteScalar(StoredProcedures.Leads_Insert.ToString(),
"@LeadId", LeadId,
"@Slogan", Slogan,
"@Website", Website,
"@Creative", Creative,
"@PhoneNumber", PhoneNumber,
"@Address,", Address,
"@Link", Link,
"@Latitude", Latitude,
"@Longitude", Longitude,
"@QueueId", QueueId);
success = LeadId > 0;
}
catch (Exception ex) { throw new Exceptions.BusinessLogicException("Error saving lead.", ex); }
finally { if (mssql != null) mssql.Dispose(); }
return success;
}
public static IEnumerable<Queue> SelectNext(int serverId, string connectionString)
{
IEnumerable<Queue> queues = null;
DataTable table = null;
DataLayer.MSSQL mssql = null;
try
{
mssql = new DataLayer.MSSQL(connectionString);
table = mssql.GetDataTable(StoredProcedures.Queues_Select_Next.ToString(), "@ServerId", serverId);
if (table != null)
queues = table.Rows.Select<Queue>(new object[] { connectionString });
}
catch (Exception ex) { throw new Exceptions.BusinessLogicException("Error loading queue.", ex); }
finally { if (mssql != null) mssql.Dispose(); }
return queues;
}
public static IEnumerable<Lead> ByQueueId(long queueId, string connectionString)
{
IEnumerable<Lead> leads = null;
DataTable table = null;
DataLayer.MSSQL mssql = null;
try
{
mssql = new DataLayer.MSSQL(connectionString);
table = mssql.GetDataTable(StoredProcedures.Leads_Select_ByQueueId.ToString(), "@QueueId", queueId);
if (table != null)
leads = table.Rows.Select<Lead>(new object[] { connectionString });
}
catch (Exception ex) { throw new Exceptions.BusinessLogicException("Error loading leads.", ex); }
finally { if (mssql != null) mssql.Dispose(); }
return leads;
}