public async Task <IEnumerable <AudioVm> > listar_audios(AudioVm Item) { List <AudioVm> mostrar = null; using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["CallCloud"].ConnectionString)) { cn.Open(); SqlCommand cmd = new SqlCommand { CommandText = "busqueda_audios_filtros", CommandType = CommandType.StoredProcedure, Connection = cn }; SqlParameter param1 = cmd.Parameters.AddWithValue("@pk_business", Item.PK_Business); param1.Direction = ParameterDirection.Input; SqlParameter param2 = cmd.Parameters.AddWithValue("@pk_speech", Item.PK_Speech); param2.Direction = ParameterDirection.Input; SqlParameter param3 = cmd.Parameters.AddWithValue("@pk_agent", Item.PkAgent); param3.Direction = ParameterDirection.Input; using (SqlDataReader dr = await cmd.ExecuteReaderAsync(CommandBehavior.SingleResult)) { if (dr != null) { mostrar = new List <AudioVm>(); while (await dr.ReadAsync()) { Item = new AudioVm(); Item.pk_auido = !dr.IsDBNull(dr.GetOrdinal("PK_audio")) ? dr.GetInt32(dr.GetOrdinal("PK_audio")) :0; Item.seconds = !dr.IsDBNull(dr.GetOrdinal("seconds")) ? dr.GetInt32(dr.GetOrdinal("seconds")) : 0; Item.dateCreated = !dr.IsDBNull(dr.GetOrdinal("dateCreated")) ? dr.GetDateTime(dr.GetOrdinal("dateCreated")).ToLongTimeString() : ""; Item.PkAgent = !dr.IsDBNull(dr.GetOrdinal("PK_Agent")) ? dr.GetInt32(dr.GetOrdinal("PK_Agent")) : 0; Item.PK_Business = !dr.IsDBNull(dr.GetOrdinal("PK_Business")) ? dr.GetInt32(dr.GetOrdinal("PK_Business")) : 0; Item.Fk_Boss = !dr.IsDBNull(dr.GetOrdinal("FK_Boss")) ? dr.GetInt32(dr.GetOrdinal("FK_Boss")) : 0; Item.FirstName = !dr.IsDBNull(dr.GetOrdinal("nameAB")) ? dr.GetString(dr.GetOrdinal("nameAB")) : ""; Item.date = !dr.IsDBNull(dr.GetOrdinal("date")) ? dr.GetDateTime(dr.GetOrdinal("date")).ToShortDateString() : ""; Item.nameBusiness = !dr.IsDBNull(dr.GetOrdinal("nameBusiness")) ? dr.GetString(dr.GetOrdinal("nameBusiness")) : ""; Item.state = !dr.IsDBNull(dr.GetOrdinal("state")) ? dr.GetString(dr.GetOrdinal("state")) : ""; Item.direccionAudio = !dr.IsDBNull(dr.GetOrdinal("PathMinThumbnails")) ? dr.GetString(dr.GetOrdinal("PathMinThumbnails")) : ""; Item.fileName = !dr.IsDBNull(dr.GetOrdinal("fileName")) ? dr.GetString(dr.GetOrdinal("fileName")) : ""; Item.filesize = !dr.IsDBNull(dr.GetOrdinal("filesize")) ? dr.GetString(dr.GetOrdinal("filesize")) : ""; mostrar.Add(Item); } } } } return(mostrar); }
public async Task <IEnumerable <AudioVm> > listar_audios_detalle(AudioVm Item) { List <AudioVm> mostrar = null; using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["CallCloud"].ConnectionString)) { cn.Open(); SqlCommand cmd = new SqlCommand { CommandText = "Rsp_Audio_Detalle", CommandType = CommandType.StoredProcedure, Connection = cn }; SqlParameter param1 = cmd.Parameters.AddWithValue("@pk_Audio", Item.pk_auido); param1.Direction = ParameterDirection.Input; using (SqlDataReader dr = await cmd.ExecuteReaderAsync(CommandBehavior.SingleResult)) { if (dr != null) { mostrar = new List <AudioVm>(); while (await dr.ReadAsync()) { Item = new AudioVm(); Item.fileName = !dr.IsDBNull(dr.GetOrdinal("fileName")) ? dr.GetString(dr.GetOrdinal("fileName")) : ""; Item.text = !dr.IsDBNull(dr.GetOrdinal("text")) ? dr.GetString(dr.GetOrdinal("text")) : ""; Item.starSecond = !dr.IsDBNull(dr.GetOrdinal("startSecond")) ? dr.GetFloat(dr.GetOrdinal("startSecond")) : 0; Item.endSecond = !dr.IsDBNull(dr.GetOrdinal("endSecond")) ? dr.GetFloat(dr.GetOrdinal("endSecond")) : 0; Item.duration = !dr.IsDBNull(dr.GetOrdinal("duration")) ? dr.GetFloat(dr.GetOrdinal("duration")) : 0; mostrar.Add(Item); } } } } return(mostrar); }