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