public IHttpActionResult GetWells() { List <WellDTO> wells = new List <WellDTO>(); using (SqlConnection connection = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["fracdatasource"].ConnectionString)) { //SqlCommand command = new SqlCommand("select * from well inner join welldata on well.id = welldata.id", connection); SqlCommand command = new SqlCommand("select * from well;", connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); try { while (reader.Read()) { WellDTO newWell = new WellDTO() { Id = int.Parse(reader["Id"].ToString()), Name = reader["Name"].ToString() }; wells.Add(newWell); } } finally { // Always call Close when done reading. reader.Close(); } } return(Ok(wells)); }
/// <summary> /// All Wells /// </summary> /// <returns></returns> public async Task <WellDTO> GetWellByName(string wellName) { using (var connection = CreateConnection()) { var well = new WellDTO(); try { // Geting data for Wells from database using Store proc well = await connection.QuerySingleAsync <WellDTO>(StoredProcedureNames.GET_WELL_BY_NAME, new { WELL_NAME = wellName }, null, null, commandType : CommandType.StoredProcedure).ConfigureAwait(false); } catch (Exception ex) { } return(well); } }