//public async override Task<int> Edit(Speech Item) //{ // int rpta = -1; // using (SqlConnection cn = new SqlConnection(this.stringConexion)) // { // await cn.OpenAsync(); // SpeechDatos oSpeechDatos = new SpeechDatos(); // rpta = await oSpeechDatos.Insert(cn, Item); // } // return rpta; //} //public async override Task<int> Delete(Speech Item) //{ // int rpta = -1; // using (SqlConnection cn = new SqlConnection(this.stringConexion)) // { // await cn.OpenAsync(); // SpeechDatos oSpeechDatos = new SpeechDatos(); // rpta = await oSpeechDatos.Delete(cn, Item); // } // return rpta; //} //public async Task<List<ReporteDatos>> ListarAudioSpeech(Speech objSpeechBE) //{ // List<ReporteDatos> lstReporteBE = null; // using (SqlConnection cn = new SqlConnection(this.stringConexion)) // { // await cn.OpenAsync(); // SpeechDatos oSpeechDatos = new SpeechDatos(); // lstReporteBE = await oSpeechDatos.ListarAudioSpeechAsync(cn, objSpeechBE); // } // return lstReporteBE; //} //public async Task<List<ReporteDatos>> ListarAudioDetalle(AudioWts objAudio) //{ // List<ReporteDatos> lstReporteBE = null; // using (SqlConnection cn = new SqlConnection(this.stringConexion)) // { // await cn.OpenAsync(); // SpeechDatos oSpeechDatos = new SpeechDatos(); // lstReporteBE = await oSpeechDatos.ListarAudioDetalleAsync(cn, objAudio); // } // return lstReporteBE; //} //public async override Task<Speech> Find(Speech Item) //{ // Speech oSpeech = null; // using (SqlConnection cn = new SqlConnection(this.stringConexion)) // { // await cn.OpenAsync(); // SpeechDatos oSpeechDatos = new SpeechDatos(); // oSpeech = await oSpeechDatos.Find(cn, Item); // } // return oSpeech; //} //public async override Task<IEnumerable<Speech>> Retrieve(Speech Item) //{ // IEnumerable<Speech> lSpeech = null; // using (SqlConnection cn = new SqlConnection(this.stringConexion)) // { // await cn.OpenAsync(); // SpeechDatos oSpeechDatos = new SpeechDatos(); // lSpeech = await oSpeechDatos.Retrieve(cn, Item); // } // return lSpeech; //} //public async Task<IEnumerable<Speech>> RetrieveSectionSpeech(int id) //{ // IEnumerable<Speech> lSpeech = null; // using (SqlConnection cn = new SqlConnection(this.stringConexion)) // { // await cn.OpenAsync(); // SpeechDatos oSpeechDatos = new SpeechDatos(); // lSpeech = await oSpeechDatos.RetrieveSectionSpeech(cn, id); // } // return lSpeech; //} public async Task <bool> SpeechRegistrar(Speech objSpeechBE) { using (SqlConnection cn = new SqlConnection(this.stringConexion)) { await cn.OpenAsync(); SpeechDatos objSpeechDA = new SpeechDatos(); return(await objSpeechDA.SpeechRegistrar(cn, objSpeechBE)); } }
public async Task <List <KeyValuePair <string, string> > > SpeechListarCombos(Business objNegocioBE) { using (SqlConnection cn = new SqlConnection(this.stringConexion)) { await cn.OpenAsync(); SpeechDatos objSpeechDA = new SpeechDatos(); return(await objSpeechDA.SpeechListarCombos(cn, objNegocioBE)); } }