When using ASP.NET razor and SQL Server 2008 R2, I have a local variable declared in the following manner:
var tsmMtd = db.QueryValue("
SELECT b.Name, SUM(subtotal) totalSUM
FROM DR_TRANS a
INNER JOIN Staff b ON a.Salesno = b.Staffno
WHERE a.salesno in (12,23,28,30)
AND a.TRANSDATE >= dateadd(m, datediff(m, 0, getdate()), 0)
AND a.REF3 = 'Invoice'
GROUP BY b.Name
ORDER BY totalSUM DESC
");
This query returns an array of names from the table sorted by sales value, which can be accessed later in the HTML with:
@tsmMtd.ToString()
Now, I want to format the text of the page based on the top salesperson's name. If they are the top salesperson, I want their name to appear in blue. Here's how I achieved this for actual sales figures:
<span class=@(salesval12 > 6000 ? "blue" : "red")>@salesval12.ToString("C")</span>
However, when trying to apply a similar logic to display the top salesperson's name in blue based on a specific name like "CHARLIE JONES," I encountered an error message Compiler Error Message: CS0029: Cannot implicitly convert type 'string' to 'bool'
So my questions are:
- What am I doing wrong in this case?
- What should be the correct approach?
Any help or suggestions would be greatly appreciated.