public void storeVentureDataInSession(int ventureID)
{
DbMethods DbMethods = new DbMethods();
Venture ventureObj = new Venture();
ventureObj = DbMethods.GetVenture(ventureID);
//store all wanted skills
DataSet allVentureSkills = DbMethods.GetVentureSkills(ventureID);
for (int i = 0; i < allVentureSkills.Tables[0].Select().Length; i++)
{
int SkillID = (int)allVentureSkills.Tables[0].Rows[i][0];
string SkillName = allVentureSkills.Tables[0].Rows[i][1].ToString();
ventureObj.AllVentureSkills.Add(new Tuple <int, string>(SkillID, SkillName));
}
//store members and roles
DataSet ventureMembersAndRolesDS = DbMethods.GetVentureMembersAndRoles(ventureID);
for (int i = 0; i < ventureMembersAndRolesDS.Tables[0].Select().Length; i++)
{
string role = ventureMembersAndRolesDS.Tables[0].Rows[i][0].ToString();
string firstName = ventureMembersAndRolesDS.Tables[0].Rows[i][1].ToString();
string lastName = ventureMembersAndRolesDS.Tables[0].Rows[i][2].ToString();
string memberName = firstName + " " + lastName;
string username = ventureMembersAndRolesDS.Tables[0].Rows[i][3].ToString();
ventureObj.memberNameAndRoleList.Add(new Tuple <string, string, string>(username, memberName, role));
}
//store static members and roles
DataSet staticMembersAndRolesDS = DbMethods.GetAllStaticMembersByVentureID(ventureID);
for (int i = 0; i < staticMembersAndRolesDS.Tables[0].Select().Length; i++)
{
int StaticMemberID = (int)staticMembersAndRolesDS.Tables[0].Rows[i][0];
string firstName = staticMembersAndRolesDS.Tables[0].Rows[i][1].ToString();
string lastName = staticMembersAndRolesDS.Tables[0].Rows[i][2].ToString();
string role = staticMembersAndRolesDS.Tables[0].Rows[i][3].ToString();
string staticMemberName = firstName + " " + lastName;
ventureObj.staticMembersList.Add(new Tuple <string, string, int>(staticMemberName, role, StaticMemberID));
}
//store object in session
Session["ventureObj"] = ventureObj;
}