public virtual async Task ExecuteAsync()
{
AssignParameterValues();
if (Conn.State == ConnectionState.Open)
{
await Cmd.ExecuteNonQueryAsync();
}
else
{
await Conn.OpenAsync();
try
{
await Cmd.ExecuteNonQueryAsync();
}
catch
{
throw;
}
finally
{
Conn.Close();
}
}
AssignValuesParameters();
try
{
LastMsg = Parameters.OfType <DbParameter>().ToList().First(x => x.ParameterName == "@msg").Value.ToString();
}
catch
{
LastMsg = "";
}
}
public virtual Dictionary <string, object> ReturnValues()
{
return(Parameters.OfType <DbParameter>()
.Where(p => p.Direction == ParameterDirection.InputOutput || p.Direction == ParameterDirection.Output)
.ToDictionary(i => i.ParameterName, i => i.Value));
//Dictionary<string, object> Result = new Dictionary<string, object>();
//foreach (SqlParameter Param in Parameters)
//{
// if (Param.Direction == ParameterDirection.InputOutput || Param.Direction == ParameterDirection.Output)
// {
// Result.Add(Param.ParameterName, Param.Value);
// }
//}
//return Result;
}
