public async Task <bool> SubOficinaEliminar(SqlConnection cn, SubOffice objSubOfficeBE) { try { bool resultado = false; SqlCommand cmd = new SqlCommand { CommandText = "SP_SUB_OFICINA_ELIMINAR", CommandType = CommandType.StoredProcedure, Connection = cn }; SqlParameter param1 = cmd.Parameters.AddWithValue("@PK_SubOffice", objSubOfficeBE.Pk_SubOffice); param1.Direction = ParameterDirection.Input; int rpta = await cmd.ExecuteNonQueryAsync(); if (rpta > 0) { resultado = true; } return(resultado); } #pragma warning disable CS0168 // The variable 'ex' is declared but never used catch (Exception ex) #pragma warning restore CS0168 // The variable 'ex' is declared but never used { return(false); } }
public async Task <List <SubOffice> > SubOficinaListar(SqlConnection cn, SubOffice objSubOfficeBE) { List <SubOffice> lstSubOfficeBE = null; SqlCommand cmd = new SqlCommand { CommandText = "SP_SUB_OFICINA_LISTAR", CommandType = CommandType.StoredProcedure, Connection = cn }; cmd.Parameters.AddWithValue("@PK_Enterprise", objSubOfficeBE.Pk_Enterprise); cmd.Parameters.AddWithValue("@PK_Office", objSubOfficeBE.Pk_Office); cmd.Parameters.AddWithValue("@NameSubOffice", objSubOfficeBE.nameSubOffice ?? ""); cmd.Parameters.AddWithValue("@estado", objSubOfficeBE.Estado); using (SqlDataReader dtr = await cmd.ExecuteReaderAsync(CommandBehavior.SingleResult)) { lstSubOfficeBE = new List <SubOffice>(); while (await dtr.ReadAsync()) { lstSubOfficeBE.Add(new SubOffice { Pk_SubOffice = dtr.GetInt32(dtr.GetOrdinal("PK_SubOffice")), Pk_Office = dtr.GetInt32(dtr.GetOrdinal("PK_Office")), Pk_Enterprise = dtr.GetInt32(dtr.GetOrdinal("PK_Enterprise")), nameOffice = dtr.GetString(dtr.GetOrdinal("nameOffice")), nameSubOffice = dtr.GetString(dtr.GetOrdinal("nameSubOffice")), Estado = dtr.GetInt32(dtr.GetOrdinal("estado")), Tx_Estado = dtr.GetString(dtr.GetOrdinal("Tx_Estado")) }); } } return(lstSubOfficeBE); }
public async Task <List <KeyValuePair <string, string> > > NegocioListarCombos(SubOffice objSubOficinaBE) { using (SqlConnection cn = new SqlConnection(this.stringConexion)) { await cn.OpenAsync(); BusinessDatos objBusinessDA = new BusinessDatos(); return(await objBusinessDA.NegocioListarCombos(cn, objSubOficinaBE)); } }
public async Task <List <KeyValuePair <string, string> > > NegocioListarCombos(SqlConnection cn, SubOffice objSubOficinaBE) { List <KeyValuePair <string, string> > lstOpcionBE = null; SqlCommand cmd = new SqlCommand { CommandText = "SP_NEGOCIO_COMBO", CommandType = CommandType.StoredProcedure, Connection = cn }; cmd.Parameters.AddWithValue("@PK_SubOffice", objSubOficinaBE.Pk_SubOffice); using (SqlDataReader dtr = await cmd.ExecuteReaderAsync(CommandBehavior.SingleResult)) { lstOpcionBE = new List <KeyValuePair <string, string> >(); while (await dtr.ReadAsync()) { lstOpcionBE.Add( new KeyValuePair <string, string>( dtr.GetString(dtr.GetOrdinal("name")), Convert.ToString(dtr.GetInt32(dtr.GetOrdinal("PK_Business"))) ) ); } } return(lstOpcionBE); }