public static SubsidiaryContent[] GetSubsidiaryContentsFromGrammar(string grammarId) { ArrayList subsidiaryContents = new ArrayList(); using (OleDbConnection connection = new OleDbConnection(connectionString)) { connection.Open(); OleDbCommand query = new OleDbCommand("SELECT Grammars.Grammar, sc.Sub_contents, Sub_Contents_Id as sub_id FROM Grammars INNER JOIN (Grammar_Subsidiary_Contents gsc INNER JOIN Subsidiary_Contents sc ON gsc.Sub_contents = sc.Sub_contents_Id) ON Grammars.Grammar = gsc.Grammar WHERE Grammars.Grammar = ?", connection); OleDbParameter param_grammar = query.CreateParameter(); param_grammar.Value = grammarId; query.Parameters.Add(param_grammar); OleDbDataReader reader = query.ExecuteReader(); while (reader.Read()) { SubsidiaryContent newSC = new SubsidiaryContent(); newSC.Sub_content_id = Convert.ToInt32(reader["sub_id"]); newSC.Sub_content_name = reader["Sub_contents"].ToString(); subsidiaryContents.Add(newSC); } } return((SubsidiaryContent[])subsidiaryContents.ToArray(typeof(SubsidiaryContent))); }
public static SubsidiaryContent[] GetAllGrammarSubsidiaryContents() { ArrayList subContents = new ArrayList(); using (OleDbConnection connection = new OleDbConnection(connectionString)) { connection.Open(); OleDbCommand storedProcedure = new OleDbCommand("GetAllGrammarSubsidiaryContents", connection); storedProcedure.CommandType = CommandType.StoredProcedure; OleDbDataReader reader = storedProcedure.ExecuteReader(); while (reader.Read()) { SubsidiaryContent subContent = new SubsidiaryContent(); subContent.Grammar_id = Convert.ToInt32(reader["Grammar"]); subContent.Sub_content_id = Convert.ToInt32(reader["content_id"]); subContent.Sub_content_name = reader["Sub_contents"].ToString(); subContents.Add(subContent); } } return((SubsidiaryContent[])subContents.ToArray(typeof(SubsidiaryContent))); }