public DynamicListDTO searchemployee()
{
DynamicListDTO listJobOrder = _dapperrepository.GellAllData(_connectionString);
//if(string.IsNullOrEmpty(listJobOrder.errorMessage))
// {
// return Ok(listJobOrder);
//}
//else
//{
// throw new ApiException
//}
return(listJobOrder);
}
public DynamicListDTO GellAllData(string _connectionString)
{
DynamicListDTO listJobOrder = new DynamicListDTO();
try
{
using (System.Data.SqlClient.SqlConnection activeConn = new System.Data.SqlClient.SqlConnection(_connectionString))
{
activeConn.Open();
//var p = new Dapper.DynamicParameters();
//p.Add("@Name", Name, dbType: DbType.String);
listJobOrder.thisList = activeConn.Query <dynamic>("TestProcInitial", commandType: System.Data.CommandType.StoredProcedure).ToList();
}
return(listJobOrder);
}
catch (Exception ex)
{
listJobOrder.errorMessage = Convert.ToString(ex.Message);
return(listJobOrder);
}
}
