protected void Page_Load(object sender, EventArgs e) { Title = "Project Add"; int numusers = 0; Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); if (Session["User"] == null) { Response.Redirect("Login.aspx"); } else { UserData user = (UserData)Session["User"]; UserChoose.Multiple = true; if (!IsPostBack) { Object[][] members = findata.getuserinformation(); for (int i = 0; i < members.Length; i++) { if ((string)members[i][0] == user.getID()) { } 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]); 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") { UserChoose.Items.Add(new ListItem(" " + priority(eventcount).ToString() + " " + (string)members[i][1] + " " + (string)members[i][2] + " ", members[i][0].ToString())); numusers += 1; } } } } } } findata.Close(); }
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) { 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) { Title = "Events"; if (Session["User"] != null) //Logged in { Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); UserData user = (UserData)Session["User"]; Object[][] userevents = findata.getalluserevents(user.getID()); 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); if (result < 0) { findata.deleteevent((string)userevents[j][4], user.getID()); } else { } } } string htmldata = ""; string temp = ""; UserCredential credential; using (var stream = new FileStream(Server.MapPath("client_secret.json"), FileMode.Open, FileAccess.Read)) { string credPath = System.Environment.GetFolderPath( System.Environment.SpecialFolder.Personal);; credPath = Path.Combine(credPath, ".credentials/calendar-dotnet-quickstart.json"); credential = GoogleWebAuthorizationBroker.AuthorizeAsync( GoogleClientSecrets.Load(stream).Secrets, Scopes, "user", CancellationToken.None, new FileDataStore(credPath, true)).Result; Console.WriteLine("Credential file saved to: " + credPath); } // Create Google Calendar API service. var service = new CalendarService(new BaseClientService.Initializer() { HttpClientInitializer = credential, ApplicationName = ApplicationName, }); // Define parameters of request. EventsResource.ListRequest request = service.Events.List("primary"); request.TimeMin = DateTime.Now; request.ShowDeleted = false; request.SingleEvents = true; request.MaxResults = 1000; request.OrderBy = EventsResource.ListRequest.OrderByEnum.StartTime; string picturedef = " "; Object[] pics; // List events. Google.Apis.Calendar.v3.Data.Events events = request.Execute(); if (events.Items != null && events.Items.Count > 0) { foreach (var eventItem in events.Items) { string when = eventItem.Start.DateTime.ToString(); if (String.IsNullOrEmpty(when)) { when = eventItem.Start.Date; } string desc = eventItem.Description; string summary = eventItem.Summary; string loc = eventItem.Location; string id = eventItem.Id; if (desc == null) { desc = ""; } if (summary == null) { summary = ""; } if (loc == null) { loc = ""; } Boolean exsisting = false; object[] googleids = findata.geteventids(user.getID()); if (googleids != null) { for (int i = 0; i < googleids.Length; i++) { if (eventItem.Id == (string)googleids[i]) { exsisting = true; } } if (exsisting == true) { } else if (exsisting == false) { findata.deleteevent(eventItem.Id, user.getID()); findata.deleteeventpics(eventItem.Id, user.getID()); } } if (findata.checkevents(Convert.ToString(id), user.getID().ToString()) == Convert.ToString(id)) { object[] storedevent = findata.getevent(id, user.getID().ToString()); if ((string)storedevent[1] == when || (string)storedevent[2] == summary || (string)storedevent[3] == loc || (string)storedevent[6] == desc) { } else { findata.updateevent(DateTime.Parse(when), eventItem.Summary, eventItem.Location, eventItem.Description, (string)storedevent[4], (string)storedevent[0]); } htmldata += "<a href=\"EventEdit.aspx?eid=" + eventItem.Id + "\">"; htmldata += "<div class=\"col s12 m4 l0\">"; htmldata += "<div class=\"card horizontal hoverable deep-purple lighten-3\">"; /* htmldata += "<div class=\"card-image\">"; * * if (findata.geteventfirstpics(id) != null) * { * htmldata += "<img style='width:200px;height:200px' class= \"responsive-img\" src = 'data:image/jpeg;base64," + findata.geteventfirstpics(id) + "'/>"; * } * else * { * htmldata += "<img style='width:200px;height:200px' class= \"responsive-img\" src = 'data:image/jpeg;base64," + UserData.Nopic + "'/>"; * * } * * * * htmldata += "</div>";*/ htmldata += "<div class=\"card-stacked\">"; htmldata += "<div class=\"card-content black-text\">"; htmldata += "<span class=\"card-title\">" + "<p class=\"bold trunctext\">" + eventItem.Summary + "</p>"; htmldata += "</span>"; htmldata += "<p class=\"bold \">Date/Time: " + when + "</p>"; htmldata += "</span>"; htmldata += "<p class=\"bold\">Location: " + eventItem.Location + "</p>"; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</a>"; } else { findata.insertevent(Convert.ToDateTime(when), summary, loc, id, user.getID(), desc); htmldata += "<a href=\"EventEdit.aspx?eid=" + id + "\">"; htmldata += "<div class=\"col s12 m4 l0\">"; htmldata += "<div class=\"card horizontal hoverable deep-purple 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>";*/ htmldata += "<div class=\"card-stacked\">"; htmldata += "<div class=\"card-content black-text\">"; htmldata += "<span class=\"card-title\">" + "<p class=\" bold trunctext\">" + eventItem.Summary + "</p>"; htmldata += "</span>"; htmldata += "<p class=\"bold\">Date/Time: " + when + "</p>"; htmldata += "</span>"; htmldata += "<p class=\"bold trunctext\">Location: " + eventItem.Location + "</p>"; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</a>"; } } } else { Console.WriteLine("No upcoming events found."); } //Console.Read(); htmldata += "</div>"; // htmldata += temp; upev.InnerHtml = htmldata; findata.Close(); } else { Response.Redirect("Login.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { Title = "Member Profile"; if (Session["User"] == null) { Response.Redirect("Login.aspx"); } else { Title = "Fincal: Member Profile"; UserData user = (UserData)(Session["User"]); Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); userid = Request.QueryString.Get("uid"); findata.Open(); proj = findata.getprojects(userid); iss = findata.getissues(userid); userdata = findata.getspecificuserinformation(userid); if (userdata != null) { Object[][] userevents = findata.getalluserevents(userid); 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; } } } if (proj != null) { for (int i = 0; i < proj.Length; i++) { projnum += 1; } } else { projnum = 0; } if (iss != null) { for (int i = 0; i < iss.Length; i++) { isnum += 1; } } else { isnum = 0; } txtusername.Value = (string)userdata[0]; txtemail.Value = (string)userdata[1]; txtskill.Value = (string)userdata[2]; txtgit.Value = (string)userdata[3]; txtproj.Value = projnum.ToString(); txtiss.Value = isnum.ToString(); txtschedule.Value = priority(eventcount).ToString(); object[][] userprojects = findata.getprojects(user.getID()); object[] memberassignedprog = findata.getassignedprojects(userid); object[][] membernotice = findata.getprojnotification(userid); if (userprojects != null) { for (int i = 0; i < userprojects.Length; i++) { bool ismem = false; if (memberassignedprog != null) { for (int j = 0; j < memberassignedprog.Length; j++) { if (Convert.ToInt32((string)userprojects[i][0]) == Convert.ToInt32((string)memberassignedprog[j])) { ismem = true; } } } if (membernotice != null) { for (int j = 0; j < membernotice.Length; j++) { if (Convert.ToInt32((string)userprojects[i][0]) == Convert.ToInt32((string)membernotice[j][1])) { ismem = true; } } } if (ismem == false) { Projectchoose.Items.Add(new ListItem(" " + (string)userprojects[i][1], userprojects[i][0].ToString())); } } } } findata.Close(); } }
protected void Page_Load(object sender, EventArgs e) { Title = "Issue Invite"; if (Session["User"] == null) { Response.Redirect("Login.aspx"); } else { UserData user = (UserData)Session["User"]; Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); pid = Request.QueryString.Get("id"); issnid = Request.QueryString.Get("in"); String[] test; findata.Open(); issdetails = findata.getissuedetails(pid); issndetails = findata.getissuenoticedetails(issnid); if (issdetails != null) { projdetails = findata.getprojectdetails((string)issdetails[3]); txtprojectname.Value = (string)projdetails[1]; txtisst.Value = (string)issdetails[1]; txtissd.Value = (string)issdetails[2]; txtisspriority.Value = (string)issdetails[4]; pldetails = findata.getprojectleaderinformaion((string)issdetails[5]); txtexp.Value = DateTime.Parse((string)issndetails[3]).AddDays(7).ToString(); } object[][] issmembers = findata.issueteam(pid); if (issmembers != null) { for (int i = 0; i < issmembers.Length; i++) { Object[][] userevents = findata.getalluserevents((string)issmembers[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; } } } htmldata += "<li class=\"collection-item\"><span style=\"font-weight:bold\">\"Schedule: " + priority(eventcount).ToString() + " Username: "******" Email: " + (string)issmembers[i][2] + "</span></li>"; } } else { htmldata += "<li class=\"collection-item\"><span style=\"font-weight:bold\">No memebrs yet</span></li>"; } membersonissue.InnerHtml += htmldata; 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(); } } }
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 = "Issue Details"; UserData user = (UserData)Session["User"]; Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); if (!IsPostBack) { string id = Request.QueryString.Get("id"); findata.Open(); object[] issdetails = findata.getissuedetails(id); if (issdetails != null) { object[] projdetails = findata.getprojectdetails((string)issdetails[3]); txtprojname.Value = (string)projdetails[1]; object[] userdetails = findata.getspecificuserinformation((string)projdetails[3]); txtprojleader.Value = (string)userdetails[1]; txtissdesc.Value = (string)issdetails[2]; txtisstitle.Value = (string)issdetails[1]; object[][] issmembers = findata.issueteam((string)issdetails[0]); if (issmembers != null) { for (int i = 0; i < issmembers.Length; i++) { Object[][] userevents = findata.getalluserevents((string)issmembers[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; } } } htmldata += "<li class=\"collection-item\"><span style=\"font-weight:bold\">Schedule: " + priority(eventcount).ToString() + "    Username: "******"    Email: " + (string)issmembers[i][2] + "</span></li>"; } } else { htmldata += "<li class=\"collection-item\"><span style=\"font-weight:bold\">No memebrs yet</span></li>"; } } membersonissue.InnerHtml += htmldata; findata.Close(); } }