Exemplo n.º 1
0
 public bool Filter(Classifier c) => c.Code == ClassifierCode && c.TypeCode == ClassifierTypeCode;
Exemplo n.º 2
0
 public bool TryGetClassifier(string classifierTypeCode, string classifierCode, out Classifier result)
 {
     using (var connection = new SqlConnection(connectionString))
     {
         connection.Open();
         using (var command = new SqlCommand("dbo.GetClassifier", connection))
         {
             command.CommandType = CommandType.StoredProcedure;
             command.Parameters.AddWithValue("@ClassifierTypeCode", classifierTypeCode);
             command.Parameters.AddWithValue("@ClassifierCode", classifierCode);
             using (var reader = command.ExecuteReader())
             {
                 if (reader.HasRows)
                 {
                     reader.Read();
                     result = new Classifier(this, reader.GetString(0), reader.GetString(1))
                     {
                         Name        = reader.GetString(2),
                         Description = reader.GetString(3),
                         UpdatedBy   = reader.GetString(4),
                         UpdatedOn   = reader.GetDateTime(5)
                     };
                     return(true);
                 }
                 else
                 {
                     result = null;
                     return(false);
                 }
             }
         }
     }
 }