public long?GetCodigoProveedorActualOrDefaultByFarmaco(long farmaco)
{
try
{
var farmacoInteger = (int)farmaco;
using (var db = FarmaciaContext.Recepcion())
{
var sql = "SELECT TOP 1 Proveedor FROM Recepcion WHERE ID_Farmaco = @farmaco ORDER BY ID_Fecha DESC";
return(db.Database.SqlQuery <int?>(sql,
new OleDbParameter("farmaco", farmaco))
.FirstOrDefault());
}
}
catch (Exception ex) when(ex.Message.Contains(FarmaciaContext.MessageUnderlyngProviderFailed))
{
return(GetCodigoProveedorActualOrDefaultByFarmaco(farmaco));
}
}
