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