/// <summary>
/// Release checks
/// </summary>
/// <param name="checkList"></param>
/// <param name="user"></param>
/// <param name="operation"></param>
/// <returns></returns>
public List <OnHoldChecksModel> ReleaseChecks(OnHoldChecksModelList checkList, string user, string operation)
{
var checkListResult = _onHoldRepositoryWrite.ReleaseChecks(checkList, user, operation);
/// delete from notification center
return(checkListResult);
}
/// <summary>
/// Release or rejects checks
/// </summary>
/// <param name="checkList"></param>
/// <param name="user"></param>
/// <param name="operation"></param>
/// <returns></returns>
public List <OnHoldChecksModel> ReleaseChecks(OnHoldChecksModelList checkList, string user, string operation)
{
using (SqlConnection dbConnection = new SqlConnection(_connectionString))
{
SqlCommand command = null;
try
{
dbConnection.Open();
command = new SqlCommand("Viacheck.PCN_ReleaseChecksOnHold", dbConnection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@Checks", System.Data.SqlDbType.Structured);
command.Parameters["@Checks"].Value = checkList;
command.Parameters.Add("@ProcessedUser", System.Data.SqlDbType.VarChar);
command.Parameters["@ProcessedUser"].Value = user;
command.Parameters.Add("@Operation", System.Data.SqlDbType.VarChar);
command.Parameters["@Operation"].Value = operation;
command.CommandTimeout = 0;
var reader = command.ExecuteReader();
var validationList = new List <OnHoldChecksModel>();
while (reader.Read())
{
validationList.Add(new OnHoldChecksModel
{
CheckID = int.Parse(reader["CheckId"].ToString()),
HoldDescription = (reader["HoldDescription"].ToString())
});
}
return(validationList);
}
catch (Exception ex)
{
if (command != null)
{
command.Cancel();
command.Dispose();
}
throw ex;
}
finally
{
if (dbConnection != null)
{
if (dbConnection.State == ConnectionState.Open)
{
dbConnection.Close();
}
}
}
}
}
