private void Generate(Avenue.Heights.Data.AvenueCollection DataTasks)
{
foreach (Data.Task aTask in DataTasks)
{
base.Add(new Access.Task(aTask));
}
}
private void Generate(Avenue.Heights.Data.AvenueCollection DataUserIterations)
{
foreach (Data.UserIteration aUserIteration in DataUserIterations)
{
base.Add(new Access.UserIteration(aUserIteration));
}
}
private void Generate(Avenue.Heights.Data.AvenueCollection DataStoryTypes)
{
foreach (Data.StoryType aStoryType in DataStoryTypes)
{
base.Add(new Access.StoryType(aStoryType));
}
}
private void Generate(Avenue.Heights.Data.AvenueCollection DataStories)
{
foreach (Data.Story aStory in DataStories)
{
base.Add(new Access.Story(aStory));
}
}
private void Generate(Avenue.Heights.Data.AvenueCollection DataUsers)
{
foreach (Data.User aUser in DataUsers)
{
base.Add(new Access.User(aUser));
}
}
private void Generate(Avenue.Heights.Data.AvenueCollection DataIterationTimePeriods)
{
foreach (Data.IterationTimePeriod aIterationTimePeriod in DataIterationTimePeriods)
{
base.Add(new Access.IterationTimePeriod(aIterationTimePeriod));
}
}
private void Generate(Avenue.Heights.Data.AvenueCollection DataThemes)
{
foreach (Data.Theme aTheme in DataThemes)
{
base.Add(new Access.Theme(aTheme));
}
}
private void Generate(Avenue.Heights.Data.AvenueCollection DataTaskStatuses)
{
foreach (Data.TaskStatus aTaskStatus in DataTaskStatuses)
{
base.Add(new Access.TaskStatus(aTaskStatus));
}
}
public Avenue.Workflow.Data.Users GetByUserThemeID(Int32 UserThemeID)
{
System.Data.SqlClient.SqlCommand acommand = new System.Data.SqlClient.SqlCommand();
acommand.Connection = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["AvenueHeightsConnection"].ConnectionString);
acommand.CommandText = "dbo.ave_User_GetByUserThemeID";
acommand.CommandType = System.Data.CommandType.StoredProcedure;
acommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, 10, 0, null, System.Data.DataRowVersion.Current, false, null, "", "", ""));
acommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserThemeID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, 10, 0, null, System.Data.DataRowVersion.Current, false, UserThemeID, "", "", ""));
try
{
if (acommand.Connection.State == System.Data.ConnectionState.Closed)
{
acommand.Connection.Open();
}
System.Data.SqlClient.SqlDataReader reader = acommand.ExecuteReader();
Avenue.Heights.Data.AvenueCollection refthis = this;
User.GenerateAvenueList(reader, ref refthis);
}
finally
{
acommand.Connection.Close();
}
return(this);
}
public UserIterations(Avenue.Heights.Data.AvenueCollection DataUserIterations)
: base()
{
Generate(DataUserIterations);
}
public static void GenerateAvenueList(System.Data.SqlClient.SqlDataReader Reader, ref Avenue.Heights.Data.AvenueCollection Collection)
{
while (Reader.Read())
{
Avenue.Heights.Data.AvenueData aData = new Avenue.Heights.Data.AvenueData();
GenerateAvenueData(Reader, ref aData);
Collection.Add(aData);
}
}
public Tasks(Avenue.Heights.Data.AvenueCollection DataTasks)
: base()
{
Generate(DataTasks);
}
public StoryTypes(Avenue.Heights.Data.AvenueCollection DataStoryTypes)
: base()
{
Generate(DataStoryTypes);
}
public IterationTimePeriods(Avenue.Heights.Data.AvenueCollection DataIterationTimePeriods)
: base()
{
Generate(DataIterationTimePeriods);
}
public static void GenerateAvenueList(System.Data.SqlClient.SqlDataReader Reader, ref Avenue.Heights.Data.AvenueCollection Collection)
{
while (Reader.Read())
{
Avenue.Workflow.Data.UserIteration aUserIteration = new Avenue.Workflow.Data.UserIteration();
Avenue.Heights.Data.AvenueData aData = (Avenue.Heights.Data.AvenueData)aUserIteration;
GenerateAvenueData(Reader, ref aData);
Collection.Add(aData);
}
}
public IterationTypes(Avenue.Heights.Data.AvenueCollection DataIterationTypes)
: base()
{
Generate(DataIterationTypes);
}
