public List <SubLegalArea> GetSubAreas(int number)
{
List <SubLegalArea> subLegalAreas = new List <SubLegalArea>();
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("SP_GetSubLegalAreas", conn)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add(new SqlParameter("@FK_MA_ID", number));
SqlDataReader reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
return(subLegalAreas);
}
while (reader.Read())
{
SubLegalArea subLegalArea = new SubLegalArea
{
Id = (int)reader["PK_SA_ID"],
Title = (string)reader["SA_Title"]
};
subLegalAreas.Add(subLegalArea);
}
}
return(subLegalAreas);
}
public void select(string Main)
{
SubLegalArea.SelectionList();
}
