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