can anybody please help me ----this is not returning anything
public static void PopulateCacheUserPercentageMarksForClass()
{
try
{
short? returnValue = 0;
string errMsg = "";
var param = new DynamicParameters();
param.Add("@Return", 0, direction: ParameterDirection.Output);
param.Add("@RetunErrMsg", string.Empty, direction: ParameterDirection.Output);
using (var connection = new SqlConnection(ConnectionManager.ConnectionString))
{
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
connection.Execute("s_tidx_PopulateCacheUserPercentageMarksForClass", param, commandType: CommandType.StoredProcedure);
returnValue = param.Get<short?>("@Return");
errMsg = param.Get<string>("@RetunErrMsg");
}
}
catch (Exception ex)
{
}
}