public int DesasignarContrato(AsignarContratoCompraRequestDTO request) { int result = 0; if (request.ContratoVentaId > 0) { ConsultaContratoCompraPorIdBE contrato = _IContratoCompraRepository.ConsultarContratoCompraPorContratoVentaId(request.ContratoVentaId); result = _IContratoCompraRepository.DesasignarContratoCompra(request.ContratoVentaId, contrato.ContratoCompraId, DateTime.Now, request.Usuario, ContratoCompraEstados.Activo, ContratoEstados.Activo); } return(result); }
public ConsultaContratoCompraPorIdBE ConsultarContratoCompraPorContratoVentaId(int ContratoVentaId) { ConsultaContratoCompraPorIdBE itemBE = null; var parameters = new DynamicParameters(); parameters.Add("@ContratoId", ContratoVentaId); using (IDbConnection db = new SqlConnection(_connectionString.Value.CoffeeConnectDB)) { var list = db.Query <ConsultaContratoCompraPorIdBE>("[uspContratoCompraConsultaPorContratoVentaId]", parameters, commandType: CommandType.StoredProcedure); if (list.Any()) { itemBE = list.First(); } } return(itemBE); }