/// <summary>
/// Updates the approvalState and modified dates.
/// </summary>
/// <param name="id">The DataCollection id.</param>
/// <param name="approvalState">The DataCollectionApprovalState.</param>
/// <param name="stateChangedOn">The date and tome the state was changed.</param>
public void UpdateStatus(int id, DataCollectionApprovalState approvalState, DateTime stateChangedOn)
{
Log.InfoFormat("[URDMS] Received UpdateStatus for id:{0}, approvalState:{1}, stateStangedOn:{2}", id, approvalState, stateChangedOn);
var queryString = string.Format(ConstSql, (int)approvalState, stateChangedOn.ToString("yyyyMMdd HH:mm:ss"), id);
Log.Info("[URDMS] Created query string: " + queryString);
try
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand(queryString, connection);
command.Connection.Open();
command.ExecuteNonQuery();
command.Dispose();
}
}
catch (Exception ex)
{
Log.Error("[URDMS] Error occurred updating DataCollection table in the URDMS databse. Exception: " + ex);
}
Log.Info("[URDMS] Call to UpdateStatus completed");
}
/// <summary>
/// Updates the approvalState and modified dates.
/// </summary>
/// <param name="id">The DataCollection id.</param>
/// <param name="approvalState">The DataCollectionApprovalState.</param>
/// <param name="stateChangedOn">The date and tome the state was changed.</param>
public void UpdateStatus(int id, DataCollectionApprovalState approvalState, DateTime stateChangedOn)
{
Log.InfoFormat("[URDMS] Received UpdateStatus for id:{0}, approvalState:{1}, stateStangedOn:{2}", id, approvalState, stateChangedOn);
var queryString = string.Format(ConstSql, (int)approvalState, stateChangedOn.ToString("yyyyMMdd HH:mm:ss"), id);
Log.Info("[URDMS] Created query string: " + queryString);
try
{
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand(queryString, connection);
command.Connection.Open();
command.ExecuteNonQuery();
command.Dispose();
}
}
catch (Exception ex)
{
Log.Error("[URDMS] Error occurred updating DataCollection table in the URDMS databse. Exception: " + ex);
}
Log.Info("[URDMS] Call to UpdateStatus completed");
}
