/// <summary>
/// Generic Method For CRUD operation (Asynchronous)
/// </summary>
/// <typeparam name="T">Object For Stored Procedure</typeparam>
/// <param name="spName">Stored Procedure Name</param>
/// <param name="input">Object For Stored Procedure</param>
/// <returns>System Response With Code And Messages</returns>
public async Task <SystemResponse> ManageDataAsync <T>(string spName, T input)
{
string procedureName = spName;
_log.Information("sp call for checking region code with query {0} {1}", "EXEC " + procedureName, JsonConvert.SerializeObject(input));
var response = await _dapperDao.ExecuteQueryAsync <SystemResponse>(procedureName, input);
_log.Information("response returned as {0}", JsonConvert.SerializeObject(response));
return(response.FirstOrDefault());
}
