public IEnumerable <Models.ValidationRule> get_all_validation_rules()
{
// /api/spectrum/get_all_validation_rules
List <Models.ValidationRule> rulesList = new List <Models.ValidationRule>();
using (SqlConnection conn = new SqlConnection(LorakonConnectionStrings.ConnectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("select * from SpectrumValidationRules", conn);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
Models.ValidationRule rule = new Models.ValidationRule(
(Guid)reader["ID"],
reader["NuclideName"].ToString(),
Convert.ToSingle(reader["ActivityMin"]),
Convert.ToSingle(reader["ActivityMax"]),
Convert.ToSingle(reader["ConfidenceMin"]),
Convert.ToBoolean(reader["CanBeAutoApproved"]));
rulesList.Add(rule);
}
}
}
return(rulesList);
}
public IHttpActionResult update_validation_rule(string id, [FromBody] Models.ValidationRule rule)
{
using (SqlConnection conn = new SqlConnection(LorakonConnectionStrings.ConnectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("update SpectrumValidationRules set ActivityMin=@ActivityMin, ActivityMax=@ActivityMax, ConfidenceMin=@ConfidenceMin, CanBeAutoApproved=@CanBeAutoApproved where NuclideName=@NuclideName", conn);
cmd.Parameters.AddWithValue("@NuclideName", rule.NuclideName);
cmd.Parameters.AddWithValue("@ActivityMin", rule.ActivityMin);
cmd.Parameters.AddWithValue("@ActivityMax", rule.ActivityMax);
cmd.Parameters.AddWithValue("@ConfidenceMin", rule.ConfidenceMin);
cmd.Parameters.AddWithValue("@CanBeAutoApproved", rule.CanBeAutoApproved);
cmd.ExecuteNonQuery();
}
return(Ok());
}
public IHttpActionResult insert_validation_rule([FromBody] Models.ValidationRule rule)
{
using (SqlConnection conn = new SqlConnection(LorakonConnectionStrings.ConnectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("insert into SpectrumValidationRules values (@ID, @NuclideName, @ActivityMin, @ActivityMax, @ConfidenceMin, @CanBeAutoApproved)", conn);
cmd.Parameters.AddWithValue("@ID", Guid.NewGuid());
cmd.Parameters.AddWithValue("@NuclideName", rule.NuclideName);
cmd.Parameters.AddWithValue("@ActivityMin", rule.ActivityMin);
cmd.Parameters.AddWithValue("@ActivityMax", rule.ActivityMax);
cmd.Parameters.AddWithValue("@ConfidenceMin", rule.ConfidenceMin);
cmd.Parameters.AddWithValue("@CanBeAutoApproved", rule.CanBeAutoApproved);
cmd.ExecuteNonQuery();
}
return(Ok());
}
