/// <summary> /// Get zero or one classifier type by Code /// </summary> /// <param name="classifierTypeCode">The type code of the classifier to return</param> /// <param name="result">The classifier type the the code `classifierTypeCode`</param> /// <returns></returns> public bool TryGetClassifierType(string classifierTypeCode, out ClassifierType result) { using (var connection = new SqlConnection(connectionString)) { connection.Open(); using (var command = new SqlCommand("dbo.GetClassifierType", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@ClassifierTypeCode", classifierTypeCode); using (var reader = command.ExecuteReader()) { if (reader.HasRows) { reader.Read(); result = new ClassifierType(this, reader.GetString(0)) { Name = reader.GetString(1), Description = reader.GetString(2), UpdatedBy = reader.GetString(3), UpdatedOn = reader.GetDateTime(4) }; return(true); } else { result = null; return(false); } } } } }
static void Main() { DAL dal = new DAL("Server=localhost;Database=Classify;Trusted_Connection=True;"); dal.Reset(); ClassifierType t = dal.SaveClassifierType("country", "Country", "Lande"); var dk = t.AddMember("DK", "Denmark", "Danmark"); t.AddMember("DE", "Germany", "Deutschland"); t.AddMember("SE", "Sweden", "Sverige") .AddRelated("Neighbor", dk); /* * dal.GetContext(t).AddMember("cl", "Cl", "desc"); // Classifier * dal["test"]["cl"]["rel"]; * * t.AddMember("c", "C", "Desc"); * Console.WriteLine(t.Description) */ }
public bool Filter(ClassifierType t) => t.Code == ClassifierTypeCode;