public bool UpdateArchiveSourceIsOnline(ArchiveSource paramSource)
{
if (this.Connection.State != ConnectionState.Open)
{
this.OpenConnection();
}
StringBuilder sbQuery = new StringBuilder();
sbQuery.Append("UPDATE archivesource SET ");
sbQuery.Append("SourceIsOnline = @SourceIsOnline, ");
sbQuery.Append("SourceVersion = @SourceVersion ");
sbQuery.Append("WHERE Id = @SourceId");
var query = sbQuery.ToString();
char isOnline = '0';
if (paramSource.SourceIsOnline) {
isOnline = '1';
}
using (var updCommand = new MySqlCommand(query, Connection))
{
updCommand.Parameters.AddWithValue("@SourceIsOnline", MySqlDbType.Binary).Value = isOnline;
updCommand.Parameters.AddWithValue("@SourceVersion", MySqlDbType.Int64).Value = paramSource.SourceVersion;
updCommand.Parameters.AddWithValue("@SourceId", MySqlDbType.Int64).Value = paramSource.Id;
updCommand.ExecuteNonQuery();
}
this.CloseConnection();
return true;
}
/// <summary>
/// Selects the archive source online to list.
/// </summary>
/// <returns>The archive source online to list.</returns>
public IList<ArchiveSource> SelectArchiveSourceOnlineToList()
{
string query = "SELECT * FROM archivesource WHERE SourceIsOnline = '1'";
var sourceList = new List<ArchiveSource>();
if (this.Connection.State != ConnectionState.Open)
{
this.OpenConnection();
}
MySqlCommand cmd = new MySqlCommand(query, this.Connection);
MySqlDataReader dataReader = cmd.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
var source = new ArchiveSource();
source.GetArchiveSource(dataReader);
sourceList.Add(source);
}
}
dataReader.Close();
this.CloseConnection();
return sourceList;
}
/// <summary>
/// Selects the archive source by identifier.
/// </summary>
/// <returns>The archive source by identifier.</returns>
/// <param name="sourceId">Source identifier.</param>
public ArchiveSource SelectArchiveSourceById(long sourceId)
{
string query = "SELECT * FROM archivesource WHERE Id = @SourceId";
var source = new ArchiveSource();
if (this.Connection.State != ConnectionState.Open)
{
this.OpenConnection();
}
MySqlCommand cmd = new MySqlCommand(query, this.Connection);
cmd.Parameters.AddWithValue("@SourceId", sourceId);
MySqlDataReader dataReader = cmd.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
source = source.GetArchiveSource(dataReader);
}
}
dataReader.Close();
this.CloseConnection();
return source;
}