public void UpdateStatus(Guid id, SnippetHealth newStatus)
{
using (var connection = GetOpenConnection()) {
SqlCeCommand cmd = connection.CreateCommand();
cmd.CommandText = "UPDATE Snippets SET SnippetHealth = ? WHERE Id = ?";
cmd.Parameters.Add(new SqlCeParameter("SnippetHealth", SqlDbType.Int));
cmd.Parameters.Add(new SqlCeParameter("Id", SqlDbType.NChar));
cmd.Prepare();
cmd.Parameters["SnippetHealth"].Value = (int)newStatus;
cmd.Parameters["Id"].Value = id.ToString();
cmd.ExecuteNonQuery();
}
}
public static string ToColor(this SnippetHealth health)
{
switch (health)
{
case SnippetHealth.Unknown:
return("white");
case SnippetHealth.Good:
return("green");
case SnippetHealth.Error:
return("gold");
case SnippetHealth.Fatal:
return("red");
default:
return("aliceblue");
}
}
