protected void Page_Load(object sender, EventArgs e) { if (Session["User"] == null) { Response.Redirect("Login.aspx"); } else { Title = "Issue Edit"; pid = Request.QueryString.Get("id"); UserData user = (UserData)Session["User"]; Currentmembers.Multiple = true; Othermembers.Multiple = true; if (!IsPostBack) { Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); issuemembers = findata.getissuemembers(pid); issue = findata.getissuedetails(pid); projectmembers = findata.getprojectmembers((string)issue[3]); project = findata.getprojectdetails((string)issue[3]); txtprojname.Value = (string)project[1]; txtprojt.Value = (string)project[1]; txtprojd.Value = (string)project[2]; for (int i = 0; i < projectmembers.Length; i++) { if ((string)projectmembers[i] == user.getID()) { } else { Boolean userisamember = false; bool issnotice = false; if (issuemembers != null) { for (int j = 0; j < issuemembers.Length; j++) { if ((string)projectmembers[i] == (string)issuemembers[j]) { userisamember = true; } else { userisamember = false; } } } userdetails = findata.getspecificuserinformation((string)projectmembers[i]); Object[][] userevents = findata.getalluserevents((string)projectmembers[i]); int eventcount = 0; if (userevents != null) { for (int j = 0; j < userevents.Length; j++) { DateTime credate = DateTime.Parse((string)userevents[j][1]); int result = DateTime.Compare(credate, DateTime.Now.AddDays(14)); if (result < 0) { eventcount += 1; } } } object[][] userissnotice = findata.getissuenotifications((string)projectmembers[i]); if (userissnotice != null) { for (int a = 0; a < userissnotice.Length; a++) { if (Convert.ToInt32(pid) == Convert.ToInt32((string)userissnotice[a][1])) { issnotice = true; } } } if (issnotice == false) { if (userisamember == true) { Currentmembers.Items.Add(new ListItem(" " + priority(eventcount).ToString() + " " + (string)userdetails[0] + " " + (string)userdetails[2] + " ", (string)projectmembers[i].ToString())); } else { Othermembers.Items.Add(new ListItem(" " + priority(eventcount).ToString() + " " + (string)userdetails[0] + " " + (string)userdetails[2] + " ", (string)projectmembers[i].ToString())); } } } } findata.Close(); } } }
protected void Page_Load(object sender, EventArgs e) { Title = "Meetings"; if (Session["User"] != null) { UserData user = (UserData)Session["User"]; Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); usermeetings = findata.getusermeetings(user.getID()); if (usermeetings != null) { for (int i = 0; i < usermeetings.Length; i++) { DateTime meetdate = DateTime.Parse((string)usermeetings[i][3]); int result = DateTime.Compare(meetdate, DateTime.Now); projdetails = findata.getprojectdetails((string)usermeetings[i][4]); if (result < 0) { } else { object[][] getattenginguser = findata.getallattendingmeeting((string)usermeetings[i][0]); int mematt = 0; if (getattenginguser != null) { mematt = getattenginguser.Length; } object[] getprojmembers = findata.getprojectmembers((string)usermeetings[i][4]); int projmem = 0; if (getprojmembers != null) { projmem = getprojmembers.Length; } htmldata1 += "<a href=\"Meetingview.aspx?id=" + (string)usermeetings[i][0] + "\">"; htmldata1 += "<div class=\"col s12 m3 l0\">"; htmldata1 += "<div class=\"card horizontal hoverable grey lighten-1\">"; htmldata1 += "<div class=\"card-stacked\">"; htmldata1 += "<div class=\"card-content black-text\">"; htmldata1 += "<span class=\"card-title\">" + "<p class=\" bold\">" + (string)usermeetings[i][2] + "</p>"; htmldata1 += "</span>"; htmldata1 += "<p class=\"trunctext\">Project: " + (string)projdetails[1] + "</p>"; htmldata1 += "<p class=\"trunctext\">Project Members: " + projmem + "</p>"; htmldata1 += "<p class=\"trunctext\">Members Attending: " + mematt + "</p>"; htmldata1 += "</div>"; htmldata1 += "</div>"; htmldata1 += "</div>"; htmldata1 += "</div>"; htmldata1 += "</a>"; } } } userothermeetings = findata.getmeetinginfromations(user.getID()); if (userothermeetings != null) { for (int i = 0; i < userothermeetings.Length; i++) { DateTime meetdate = DateTime.Parse((string)userothermeetings[i][3]); int result = DateTime.Compare(meetdate, DateTime.Now); projdetails = findata.getprojectdetails((string)userothermeetings[i][4]); if (result < 0) { } else { object[][] getattenginguser = findata.getallattendingmeeting((string)userothermeetings[i][0]); int mematt = 0; if (getattenginguser != null) { mematt = getattenginguser.Length; } object[] getprojmembers = findata.getprojectmembers((string)userothermeetings[i][4]); int projmem = 0; if (getprojmembers != null) { projmem = getprojmembers.Length; } if (Boolean.Parse((string)userothermeetings[i][7]) == true) { htmldata2 += "<a href=\"Meetingaccept.aspx?id=" + (string)userothermeetings[i][0] + "&ml=" + (string)userothermeetings[i][6] + "\">"; htmldata2 += "<div class=\"col s12 m3 l0\">"; htmldata2 += "<div class=\"card horizontal hoverable light-blue lighten-3\">"; htmldata2 += "<div class=\"card-stacked\">"; htmldata2 += "<div class=\"card-content black-text\">"; htmldata2 += "<span class=\"card-title\">" + "<p class=\" bold\">" + (string)userothermeetings[i][2] + "</p>"; htmldata2 += "</span>"; htmldata2 += "<p class=\"trunctext\">Project: " + (string)projdetails[1] + "</p>"; htmldata2 += "<p class=\"trunctext\">Project Members: " + projmem + "</p>"; htmldata2 += "<p class=\"trunctext\">Members Attending: " + mematt + "</p>"; htmldata2 += "</div>"; htmldata2 += "</div>"; htmldata2 += "</div>"; htmldata2 += "</div>"; htmldata2 += "</a>"; } else { htmldata2 += "<a href=\"Meetingaccept.aspx?id=" + (string)userothermeetings[i][0] + "&ml=" + (string)userothermeetings[i][6] + "\">"; htmldata2 += "<div class=\"col s12 m3 l0\">"; htmldata2 += "<div class=\"card horizontal hoverable lime lighten-3\">"; htmldata2 += "<div class=\"card-stacked\">"; htmldata2 += "<div class=\"card-content black-text\">"; htmldata2 += "<span class=\"card-title\">" + "<p class=\" bold\">" + (string)userothermeetings[i][2] + "</p>"; htmldata2 += "</span>"; htmldata2 += "<p class=\"trunctext\">Project: " + (string)projdetails[1] + "</p>"; htmldata2 += "<p class=\"trunctext\">Project Members: " + projmem + "</p>"; htmldata2 += "<p class=\"trunctext\">Members Attending: " + mematt + "</p>"; htmldata2 += "</div>"; htmldata2 += "</div>"; htmldata2 += "</div>"; htmldata2 += "</div>"; htmldata2 += "</a>"; } } } } findata.Close(); yourmeet.InnerHtml = htmldata1; othermeet.InnerHtml = htmldata2; } else { Response.Redirect("Login.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["User"] == null) { Response.Redirect("Login.aspx"); } else { Title = "Project View"; id = Request.QueryString.Get("id"); UserData user = (UserData)Session["User"]; if (!IsPostBack) { Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); project = findata.getprojectdetails(id); projectmembers = findata.getprojectmembers(id); txtprojt.Value = (string)project[1]; txtprojd.Value = (string)project[2]; pldetails = findata.getprojectleaderinformaion((string)project[3]); txtptojectleaderuname.Value = (string)pldetails[0]; txtptojectleaderemail.Value = (string)pldetails[1]; txtcredate.Value = (string)project[4]; if (projectmembers != null) { for (int i = 0; i < projectmembers.Length; i++) { projectmemdetails = findata.getspecificuserinformation((string)projectmembers[i]); Object[][] userevents = findata.getalluserevents((string)projectmembers[i]); int eventcount = 0; if (userevents != null) { for (int j = 0; j < userevents.Length; j++) { DateTime credate = DateTime.Parse((string)userevents[j][1]); int result = DateTime.Compare(credate, DateTime.Now.AddDays(14)); if (result < 0) { eventcount += 1; } } } htmldata += "<li class=\"collection-item\"><span style=\"font-weight:bold\">Schedule: " + priority(eventcount) + "    Username: "******"    Email: " + (string)projectmemdetails[1] + "    Skill: " + (string)projectmemdetails[2] + "</span></li>"; } } else { htmldata += "<li class=\"collection-item\"><span style=\"font-weight:bold\">No memebrs yet</span></li>"; } membersonproject.InnerHtml += htmldata; findata.Close(); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["User"] == null) { Response.Redirect("Login.aspx"); } else { Title = "Projects"; UserData user = (UserData)Session["User"]; Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); Object[][] projects = findata.getprojects(user.getID()); if (projects != null) { for (int i = 0; i < projects.Length; i++) { object[] projteam = findata.getprojectmembers((string)projects[i][0]); object[] projissues = findata.getprojissues((string)projects[i][0]); int projmem = 0; if (projteam != null) { projmem = projteam.Length; } int projis = 0; if (projissues != null) { projis = projissues.Length; } htmldata1 += "<a href=\"Projectedit.aspx?id=" + (string)projects[i][0] + "\">"; htmldata1 += "<div class=\"col s12 m3 l0\">"; htmldata1 += "<div class=\"card horizontal hoverable green lighten-2\">"; /* htmldata += "<div class=\"card-image\">"; * * htmldata += "<img style='width:200px;height:200px' class= \"responsive-img\" src = 'data:image/jpeg;base64," + UserData.Nopic + "'/>"; * * * htmldata += "</div>";*/ htmldata1 += "<div class=\"card-stacked\">"; htmldata1 += "<div class=\"card-content black-text\">"; htmldata1 += "<span class=\"card-title\">" + "<p class=\"bold\">" + (string)projects[i][1] + "</p>"; htmldata1 += "</span>"; htmldata1 += "<p class=\"trunctext\">Project members: " + projmem + "</p>"; htmldata1 += "<p class=\"trunctext\">Project issues: " + projis + "</p>"; htmldata1 += "</div>"; htmldata1 += "</div>"; htmldata1 += "</div>"; htmldata1 += "</div>"; htmldata1 += "</a>"; } } else { htmldata1 += ""; } object[] assignedprojectsids = findata.getassignedprojects(user.getID()); if (assignedprojectsids != null) { for (int i = 0; i < assignedprojectsids.Length; i++) { object[] assigproj = findata.getprojectdetails((string)assignedprojectsids[i]); object[] projteam = findata.getprojectmembers((string)assignedprojectsids[i]); object[] projleader = findata.getspecificuserinformation((string)assigproj[3]); int projmem = 0; if (projteam != null) { projmem = projteam.Length; } htmldata2 += "<a href=\"Projectview.aspx?id=" + assigproj[0].ToString() + "\">"; htmldata2 += "<div class=\"col s12 m3 l0\">"; htmldata2 += "<div class=\"card horizontal hoverable lime lighten-2\">"; /* htmldata += "<div class=\"card-image\">"; * * htmldata += "<img style='width:200px;height:200px' class= \"responsive-img\" src = 'data:image/jpeg;base64," + UserData.Nopic + "'/>"; * * * htmldata += "</div>";*/ htmldata2 += "<div class=\"card-stacked\">"; htmldata2 += "<div class=\"card-content black-text\">"; htmldata2 += "<span class=\"card-title\">" + "<p class=\" bold\">" + assigproj[1].ToString() + "</p>"; htmldata2 += "</span>"; htmldata2 += "<p class=\"trunctext\">Project owner: " + (string)projleader[0] + "</p>"; htmldata2 += "<p class=\"trunctext\">Project members: " + projmem + "</p>"; htmldata2 += "</div>"; htmldata2 += "</div>"; htmldata2 += "</div>"; htmldata2 += "</div>"; htmldata2 += "</a>"; } } else { htmldata2 += ""; } yourprojects.InnerHtml = htmldata1; otherprojects.InnerHtml = htmldata2; findata.Close(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["User"] == null) { Response.Redirect("Login.aspx"); } else { int numusers = 0; Title = "Project Edit"; pid = Request.QueryString.Get("id"); UserData user = (UserData)Session["User"]; Currentmembers.Multiple = true; Othermembers.Multiple = true; if (!IsPostBack) { Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); members = findata.getuserinformation(); project = findata.getprojectdetails(pid); projectmembers = findata.getprojectmembers(pid); txtprojt.Value = (string)project[1]; txtprojd.Value = (string)project[2]; for (int i = 0; i < members.Length; i++) { if ((string)members[i][0] == user.getID()) { } else { Boolean userisamember = false; Boolean notice = false; if (projectmembers != null) { for (int j = 0; j < projectmembers.Length; j++) { if ((string)members[i][0] == (string)projectmembers[j]) { userisamember = true; } } } object[][] projnotice = findata.getprojnotification((string)members[i][0]); if (projnotice != null) { for (int a = 0; a < projnotice.Length; a++) { if (Convert.ToInt32(pid) == Convert.ToInt32((string)projnotice[a][1])) { notice = true; } } } if (notice == false) { if (userisamember == true) { Object[][] userevents = findata.getalluserevents((string)members[i][0]); int eventcount = 0; if (userevents != null) { for (int j = 0; j < userevents.Length; j++) { DateTime credate = DateTime.Parse((string)userevents[j][1]); int result = DateTime.Compare(credate, DateTime.Now.AddDays(14)); if (result < 0) { eventcount += 1; } } } Currentmembers.Items.Add(new ListItem(" " + priority(eventcount).ToString() + " " + (string)members[i][1] + " " + (string)members[i][2] + " ", members[i][0].ToString())); } else { Object[][] userevents = findata.getalluserevents((string)members[i][0]); int eventcount = 0; if (userevents != null) { for (int j = 0; j < userevents.Length; j++) { DateTime credate = DateTime.Parse((string)userevents[j][1]); DateTime exweek = credate.AddDays(14); int result = DateTime.Compare(credate, DateTime.Now.AddDays(14)); if (result < 0) { eventcount += 1; } } } if (numusers <= 30) { if (priority(eventcount).ToString() == "Free" || priority(eventcount).ToString() == "Occupied") { Othermembers.Items.Add(new ListItem(" " + priority(eventcount).ToString() + " " + (string)members[i][1] + " " + (string)members[i][2] + " ", members[i][0].ToString())); numusers += 1; } } } } } } findata.Close(); } } }
private void meetings() { Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); UserData user = (UserData)Session["User"]; Object[][] usermeetings = findata.getusermeetings(user.getID()); if (usermeetings != null) { for (int j = 0; j < usermeetings.Length; j++) { DateTime credate = DateTime.Parse((string)usermeetings[j][3]); int result = DateTime.Compare(credate, DateTime.Now); if (result < 0) { int deletemeetmembers = findata.deletemeetingmembers((string)usermeetings[j][0]); findata.deletemeeting((string)usermeetings[j][0]); } Object[] projectmembers = findata.getprojectmembers((string)usermeetings[j][4]); object[][] meetingmembers = findata.getmeetingmembers((string)usermeetings[j][4]); if (projectmembers != null) { if (meetingmembers != null) { for (int i = 0; i < projectmembers.Length; i++) { bool inmeeting = false; for (int a = 0; a < meetingmembers.Length; a++) { if ((string)projectmembers[i] == (string)meetingmembers[a][0]) { inmeeting = true; } } if (inmeeting == false) { findata.insertmeetingmember((string)usermeetings[j][0], (string)projectmembers[i], "0"); } } } else { for (int i = 0; i < projectmembers.Length; i++) { findata.insertmeetingmember((string)usermeetings[j][0], (string)projectmembers[i], "0"); } } } } } findata.Close(); }
protected void Page_Load(object sender, EventArgs e) { Title = "Issue Add"; pid = Request.QueryString.Get("id"); Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); if (Session["User"] == null) { Response.Redirect("Login.aspx"); } else { if (!IsPostBack) { LevelDrop.Items.Add(new ListItem("1", "1")); LevelDrop.Items.Add(new ListItem("2", "2")); LevelDrop.Items.Add(new ListItem("3", "3")); } if (!IsCallback) { UserData user = (UserData)Session["User"]; UserChoose.Multiple = true; object[] projdetails = findata.getprojectdetails(pid); txtprojname.Value = (string)projdetails[1]; object[] projmembers = findata.getprojectmembers(pid); if (projmembers != null) { for (int i = 0; i < projmembers.Length; i++) { object[] getmemberdetails = findata.getspecificuserinformation((string)projmembers[i]); if ((string)getmemberdetails[0] == user.getID()) { } else { Object[][] userevents = findata.getalluserevents((string)projmembers[i]); int eventcount = 0; if (userevents != null) { for (int j = 0; j < userevents.Length; j++) { DateTime credate = DateTime.Parse((string)userevents[j][1]); int result = DateTime.Compare(credate, DateTime.Now.AddDays(14)); if (result < 0) { eventcount += 1; } } } UserChoose.Items.Add(new ListItem(" " + priority(eventcount).ToString() + " " + (string)getmemberdetails[0] + " " + (string)getmemberdetails[2] + " ", (string)projmembers[i].ToString())); } } } else { Response.Redirect("Projectedit.aspx?id=" + pid); } } } findata.Close(); }
protected void Page_Load(object sender, EventArgs e) { Title = "Chats"; if (Session["User"] == null) { Response.Redirect("Login.aspx"); } else { UserData user = (UserData)Session["User"]; Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); Object[][] projects = findata.getprojects(user.getID()); Object[][] otherprojects = findata.getassignedprojdetials(user.getID()); Object[][] issue = findata.getissues(user.getID()); Object[][] otherissues = findata.getassignedissdetials(user.getID()); if (projects != null) { for (int i = 0; i < projects.Length; i++) { object[] projmembers = findata.getprojectmembers((string)projects[i][0]); int nummem = 0; if (projmembers != null) { nummem = projmembers.Length; } htmldata1 += "<a href=\"Chatspecificproj.aspx?id=" + (string)projects[i][0] + "\">"; htmldata1 += "<div class=\"col s12 m3 l0\">"; htmldata1 += "<div class=\"card horizontal hoverable blue-grey\">"; /* htmldata += "<div class=\"card-image\">"; * * htmldata += "<img style='width:200px;height:200px' class= \"responsive-img\" src = 'data:image/jpeg;base64," + UserData.Nopic + "'/>"; * * * htmldata += "</div>";*/ htmldata1 += "<div class=\"card-stacked\">"; htmldata1 += "<div class=\"card-content black-text\">"; htmldata1 += "<span class=\"card-title\">" + "<p class=\"bold\">" + (string)projects[i][1] + "</p>"; htmldata1 += "</span>"; htmldata1 += "<p class=\"bold\">Members: " + nummem + "</p>"; htmldata1 += "</span>"; htmldata1 += "</div>"; htmldata1 += "</div>"; htmldata1 += "</div>"; htmldata1 += "</div>"; htmldata1 += "</a>"; } } else { htmldata1 += ""; } if (otherprojects != null) { for (int i = 0; i < otherprojects.Length; i++) { object[] projmembers = findata.getprojectmembers((string)otherprojects[i][0]); int nummem = 0; if (projmembers != null) { nummem = projmembers.Length; } htmldata1 += "<a href=\"Chatspecificproj.aspx?id=" + (string)otherprojects[i][0] + "\">"; htmldata1 += "<div class=\"col s12 m3 l0\">"; htmldata1 += "<div class=\"card horizontal hoverable blue-grey lighten-5\">"; htmldata1 += "<div class=\"card-stacked\">"; htmldata1 += "<div class=\"card-content black-text\">"; htmldata1 += "<span class=\"card-title\">" + "<p class=\"bold\">" + (string)otherprojects[i][1] + "</p>"; htmldata1 += "</span>"; htmldata1 += "<p class=\"bold\">Members: " + nummem + "</p>"; htmldata1 += "</span>"; htmldata1 += "</div>"; htmldata1 += "</div>"; htmldata1 += "</div>"; htmldata1 += "</div>"; htmldata1 += "</a>"; } } else { htmldata1 += ""; } if (issue != null) { for (int i = 0; i < issue.Length; i++) { Object[] projectdetails = findata.getprojectdetails((string)issue[i][3]); object[] issmembers = findata.getissuemembers((string)issue[i][0]); int nummem = 0; if (issmembers != null) { nummem = issmembers.Length; } htmldata2 += "<a href=\"Chatspecificissue.aspx?id=" + (string)issue[i][0] + "\">"; htmldata2 += "<div class=\"col s12 m3 l0\">"; htmldata2 += "<div class=\"card horizontal hoverable green\">"; /* htmldata += "<div class=\"card-image\">"; * * htmldata += "<img style='width:200px;height:200px' class= \"responsive-img\" src = 'data:image/jpeg;base64," + UserData.Nopic + "'/>"; * * * htmldata += "</div>";*/ htmldata2 += "<div class=\"card-stacked\">"; htmldata2 += "<div class=\"card-content black-text\">"; htmldata2 += "<span class=\"card-title\">" + "<p class=\" bold\">" + (string)issue[i][1] + "</p>"; htmldata2 += "</span>"; htmldata2 += "<p class=\"trunctext\">Project: " + (string)projectdetails[1] + "</p>"; htmldata2 += "</span>"; htmldata2 += "<p class=\"bold\">Members: " + nummem + "</p>"; htmldata2 += "</div>"; htmldata2 += "</div>"; htmldata2 += "</div>"; htmldata2 += "</div>"; htmldata2 += "</a>"; } } else { htmldata2 += ""; } if (otherissues != null) { for (int i = 0; i < otherissues.Length; i++) { Object[] projectdetails = findata.getprojectdetails((string)otherissues[i][0]); object[] issmembers = findata.getissuemembers((string)otherissues[i][0]); int nummem = 0; if (issmembers != null) { nummem = issmembers.Length; } htmldata2 += "<a href=\"Chatspecificissue.aspx?id=" + (string)otherissues[i][0] + "\">"; htmldata2 += "<div class=\"col s12 m3 l0\">"; htmldata2 += "<div class=\"card horizontal hoverable cyan lighten-3\">"; /* htmldata += "<div class=\"card-image\">"; * * htmldata += "<img style='width:200px;height:200px' class= \"responsive-img\" src = 'data:image/jpeg;base64," + UserData.Nopic + "'/>"; * * * htmldata += "</div>";*/ htmldata2 += "<div class=\"card-stacked\">"; htmldata2 += "<div class=\"card-content black-text\">"; htmldata2 += "<span class=\"card-title\">" + "<p class=\" bold\">" + (string)otherissues[i][1] + "</p>"; htmldata2 += "</span>"; htmldata2 += "<p class=\"trunctext\">Project: " + (string)projectdetails[1] + "</p>"; htmldata2 += "</span>"; htmldata2 += "<p class=\"bold\">Members: " + nummem + "</p>"; htmldata2 += "</div>"; htmldata2 += "</div>"; htmldata2 += "</div>"; htmldata2 += "</div>"; htmldata2 += "</a>"; } } else { htmldata2 += ""; } Projects.InnerHtml += htmldata1; Issues.InnerHtml += htmldata2; findata.Close(); } }