public static List <string> Execute(
string container,
string tag,
int top)
{
List <string> ids = new List <string>();
try
{
using (var connection = new SqlConnection(Configuration.DatabaseConnection))
{
var cmd = new SqlCommand(SqlValues.SelectKeyListStorage, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(SqlValues.Top, top);
cmd.Parameters.AddWithValue(SqlValues.Container, container);
cmd.Parameters.AddWithValue(SqlValues.Data, tag);
cmd.CommandTimeout = 0;
connection.Open();
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var id = (string)reader[SqlValues.Id];
ids.Add(id);
}
return(ids);
}
}
catch (Exception ex)
{
if (ex is SqlException)
{
SqlExceptionCheck.Execute(ex);
}
throw new PlyQorException(StatusCode.ERR010, ex);
}
}
public static int Execute(
string container,
string id,
string oldindex,
string newindex)
{
try
{
using (var connection = new SqlConnection(Configuration.DatabaseConnection))
{
var cmd = new SqlCommand(SqlValues.UpdateKeyTagStorage, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(SqlValues.Container, container);
cmd.Parameters.AddWithValue(SqlValues.Id, id);
cmd.Parameters.AddWithValue(SqlValues.OldData, oldindex);
cmd.Parameters.AddWithValue(SqlValues.NewData, newindex);
cmd.CommandTimeout = 0;
connection.Open();
var reader = cmd.ExecuteReader();
while (reader.Read())
{
}
var recordCount = reader.RecordsAffected;
return(recordCount);
}
}
catch (Exception ex)
{
if (ex is SqlException)
{
SqlExceptionCheck.Execute(ex);
}
throw new PlyQorException(StatusCode.ERR010, ex);
}
}
public static string Execute(
string container,
string id)
{
string data = string.Empty;
try
{
using (var connection = new SqlConnection(Configuration.DatabaseConnection))
{
var cmd = new SqlCommand(SqlValues.SelectKeyStorage, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(SqlValues.Container, container);
cmd.Parameters.AddWithValue(SqlValues.Id, id);
cmd.CommandTimeout = 0;
connection.Open();
var reader = cmd.ExecuteReader();
while (reader.Read())
{
data = (string)reader[SqlValues.Data];
}
return(data);
}
}
catch (Exception ex)
{
if (ex is SqlException)
{
SqlExceptionCheck.Execute(ex);
}
throw new PlyQorException(StatusCode.ERR010, ex);
}
}
public static int Execute(
DateTime timestamp,
string container,
string id,
string data)
{
try
{
using (var connection = new SqlConnection(Configuration.DatabaseConnection))
{
var cmd = new SqlCommand(SqlValues.InsertKeyStorage, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(SqlValues.TimeStamp, timestamp);
cmd.Parameters.AddWithValue(SqlValues.Container, container);
cmd.Parameters.AddWithValue(SqlValues.Id, id);
cmd.Parameters.AddWithValue(SqlValues.Data, data);
cmd.CommandTimeout = 0;
connection.Open();
var reader = cmd.ExecuteReader();
var recordCount = reader.RecordsAffected;
return(recordCount);
}
}
catch (Exception ex)
{
if (ex is SqlException)
{
SqlExceptionCheck.Execute(ex);
}
throw new PlyQorException(StatusCode.ERR010, ex);
}
}
public static int Execute(
string container,
string tag)
{
int count = 0;
try
{
using (var connection = new SqlConnection(Configuration.DatabaseConnection))
{
var cmd = new SqlCommand(SqlValues.SelectTagCountStorage, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(SqlValues.Container, container);
cmd.Parameters.AddWithValue(SqlValues.Data, tag);
cmd.CommandTimeout = 0;
connection.Open();
var reader = cmd.ExecuteReader();
while (reader.Read())
{
count = (int)reader[SqlValues.Count];
}
return(count);
}
}
catch (Exception ex)
{
if (ex is SqlException)
{
SqlExceptionCheck.Execute(ex);
}
throw new PlyQorException(StatusCode.ERR010, ex);
}
}
public static int Execute(int days)
{
try
{
using (var connection = new SqlConnection(Configuration.DatabaseConnection))
{
var cmd = new SqlCommand(SqlValues.TraceRetentionStorage, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(SqlValues.Days, days);
cmd.CommandTimeout = 0;
connection.Open();
var reader = cmd.ExecuteReader();
while (reader.Read())
{
}
var recordCount = reader.RecordsAffected;
return(recordCount);
}
}
catch (Exception ex)
{
if (ex is SqlException)
{
SqlExceptionCheck.Execute(ex);
}
throw new PlyQorException(StatusCode.ERR010, ex);
}
}