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