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);
}
