public void Get(Int32 StoryTypeID)
{
try
{
if (Command.Connection.State == System.Data.ConnectionState.Closed)
{
Command.Connection.Open();
Initialise();
}
Command.Parameters["@StoryTypeID"].Value = StoryTypeID;
System.Data.SqlClient.SqlDataReader reader = null;
try
{
reader = Command.ExecuteReader();
}
catch (System.Data.SqlClient.SqlException SQLex) { }
while (reader.Read())
{
Avenue.Heights.Data.AvenueData atmp = this;
GenerateAvenueData(reader, ref atmp);
break;
}
}
finally
{
Command.Parameters.Clear();
Command.Connection.Close();
}
}
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 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 static void GenerateAvenueData(System.Data.SqlClient.SqlDataReader Reader, ref Avenue.Heights.Data.AvenueData Data)
{
Avenue.Workflow.Data.UserIteration tmpData = (Avenue.Workflow.Data.UserIteration)Data;
tmpData._UserIterationID = (Int32)CheckDBNull(Reader["UserIterationID"]);
tmpData.UserID = (Int32)CheckDBNull(Reader["UserID"]);
tmpData.IterationID = (Int32)CheckDBNull(Reader["IterationID"]);
}
public static void GenerateAvenueData(System.Data.SqlClient.SqlDataReader Reader, ref Avenue.Heights.Data.AvenueData Data)
{
Avenue.Workflow.Data.IterationTimePeriod tmpData = (Avenue.Workflow.Data.IterationTimePeriod)Data;
tmpData._IterationTimePeriodID = (Int32)CheckDBNull(Reader["IterationTimePeriodID"]);
tmpData.IterationID = (Int32)CheckDBNull(Reader["IterationID"]);
tmpData.IterationTimePeriodStartDate = (DateTime)CheckDBNull(Reader["IterationTimePeriodStartDate"]);
tmpData.IterationTimePeriodEndDate = (DateTime)CheckDBNull(Reader["IterationTimePeriodEndDate"]);
}
public Iteration(Avenue.Heights.Data.AvenueData DataIteration)
: base()
{
AccessIteration = (Avenue.Workflow.Data.Iteration)DataIteration;
}
private static void GenerateAvenueData(System.Data.SqlClient.SqlDataReader Reader, ref Avenue.Heights.Data.AvenueData Data)
{
Avenue.Workflow.Data.TaskStatus tmpData = (Avenue.Workflow.Data.TaskStatus)Data;
tmpData._TaskStatusID = (Int32)CheckDBNull(Reader["TaskStatusID"]);
tmpData.TaskStatusName = (String)CheckDBNull(Reader["TaskStatusName"]);
}
public Story(Avenue.Heights.Data.AvenueData DataStory)
: base()
{
AccessStory = (Avenue.Workflow.Data.Story)DataStory;
}
public Theme(Avenue.Heights.Data.AvenueData DataTheme)
: base()
{
AccessTheme = (Avenue.Workflow.Data.Theme)DataTheme;
}
public IterationTimePeriod(Avenue.Heights.Data.AvenueData DataIterationTimePeriod)
: base()
{
AccessIterationTimePeriod = (Avenue.Workflow.Data.IterationTimePeriod)DataIterationTimePeriod;
}
public static void GenerateAvenueData(System.Data.SqlClient.SqlDataReader Reader, ref Avenue.Heights.Data.AvenueData Data)
{
Avenue.Workflow.Data.Task tmpData = (Avenue.Workflow.Data.Task)Data;
tmpData._TaskID = (Int32)CheckDBNull(Reader["TaskID"]);
tmpData.StoryID = (Int32)CheckDBNull(Reader["StoryID"]);
tmpData.TaskDescription = (String)CheckDBNull(Reader["TaskDescription"]);
tmpData.TaskStartDate = (DateTime?)CheckDBNull(Reader["TaskStartDate"]);
tmpData.TaskEndDate = (DateTime?)CheckDBNull(Reader["TaskEndDate"]);
tmpData.TaskEstimatedTime = (Decimal?)CheckDBNull(Reader["TaskEstimatedTime"]);
tmpData.TaskClockedTime = (Decimal?)CheckDBNull(Reader["TaskClockedTime"]);
tmpData.TaskStatusID = (Int32)CheckDBNull(Reader["TaskStatusID"]);
tmpData.TaskAssignedUser = (Int32)CheckDBNull(Reader["TaskAssignedUser"]);
}
public static void GenerateAvenueData(System.Data.SqlClient.SqlDataReader Reader, ref Avenue.Heights.Data.AvenueData Data)
{
Avenue.Workflow.Data.User tmpData = (Avenue.Workflow.Data.User)Data;
tmpData._UserID = (Int32)CheckDBNull(Reader["UserID"]);
tmpData.UserFirstName = (String)CheckDBNull(Reader["UserFirstName"]);
tmpData.UserLastName = (String)CheckDBNull(Reader["UserLastName"]);
tmpData.UserName = (String)CheckDBNull(Reader["UserName"]);
tmpData.UserEmail = (String)CheckDBNull(Reader["UserEmail"]);
tmpData.UserThemeID = (Int32)CheckDBNull(Reader["UserThemeID"]);
tmpData.UserAspNetMembership = (Guid)CheckDBNull(Reader["UserAspNetMembership"]);
tmpData.UserPicture = (byte[])CheckDBNull(Reader["UserPicture"]);
}
public static void GenerateAvenueData(System.Data.SqlClient.SqlDataReader Reader, ref Avenue.Heights.Data.AvenueData Data)
{
Avenue.Workflow.Data.Story tmpData = (Avenue.Workflow.Data.Story)Data;
tmpData._StoryID = (Int32)CheckDBNull(Reader["StoryID"]);
tmpData.IterationID = (Int32)CheckDBNull(Reader["IterationID"]);
tmpData.IterationTimePeriodID = (Int32)CheckDBNull(Reader["IterationTimePeriodID"]);
tmpData.StoryDescription = (String)CheckDBNull(Reader["StoryDescription"]);
tmpData.StoryTypeID = (Int32)CheckDBNull(Reader["StoryTypeID"]);
}
public StoryType(Avenue.Heights.Data.AvenueData DataStoryType)
: base()
{
AccessStoryType = (Avenue.Workflow.Data.StoryType)DataStoryType;
}
public UserIteration(Avenue.Heights.Data.AvenueData DataUserIteration)
: base()
{
AccessUserIteration = (Avenue.Workflow.Data.UserIteration)DataUserIteration;
}
public User(Avenue.Heights.Data.AvenueData DataUser)
: base()
{
AccessUser = (Avenue.Workflow.Data.User)DataUser;
}
public TaskStatus(Avenue.Heights.Data.AvenueData DataTaskStatus)
: base()
{
AccessTaskStatus = (Avenue.Workflow.Data.TaskStatus)DataTaskStatus;
}
private static void GenerateAvenueData(System.Data.SqlClient.SqlDataReader Reader, ref Avenue.Heights.Data.AvenueData Data)
{
Avenue.Workflow.Data.StoryType tmpData = (Avenue.Workflow.Data.StoryType)Data;
tmpData._StoryTypeID = (Int32)CheckDBNull(Reader["StoryTypeID"]);
tmpData.StoryTypeName = (String)CheckDBNull(Reader["StoryTypeName"]);
}
public IterationType(Avenue.Heights.Data.AvenueData DataIterationType)
: base()
{
AccessIterationType = (Avenue.Workflow.Data.IterationType)DataIterationType;
}
public static void GenerateAvenueData(System.Data.SqlClient.SqlDataReader Reader, ref Avenue.Heights.Data.AvenueData Data)
{
Avenue.Workflow.Data.Iteration tmpData = (Avenue.Workflow.Data.Iteration)Data;
tmpData._IterationID = (Int32)CheckDBNull(Reader["IterationID"]);
tmpData.IterationDescription = (String)CheckDBNull(Reader["IterationDescription"]);
tmpData.IterationTypeID = (Int32)CheckDBNull(Reader["IterationTypeID"]);
tmpData.DefaultIterationTimePeriod = (Int32)CheckDBNull(Reader["DefaultIterationTimePeriod"]);
tmpData.IterationOwner = (Int32)CheckDBNull(Reader["IterationOwner"]);
}
public Task(Avenue.Heights.Data.AvenueData DataTask)
: base()
{
AccessTask = (Avenue.Workflow.Data.Task)DataTask;
}
