protected void Page_Load(object sender, EventArgs e) { if (Session["User"] == null) { Response.Redirect("Login.aspx"); } else { Title = "Issues"; UserData user = (UserData)Session["User"]; Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); Object[][] issue = findata.getissues(user.getID()); if (issue != null) { for (int i = 0; i < issue.Length; i++) { Object[] projectdetails = findata.getprojectdetails((string)issue[i][3]); object[] issteam = findata.getissuemembers((string)issue[i][0]); int issmem = 0; if (issteam != null) { issmem = issteam.Length; } htmldata1 += "<a href=\"Issueedit.aspx?id=" + (string)issue[i][0] + "\">"; htmldata1 += "<div class=\"col s12 m3 l0\">"; htmldata1 += "<div class=\"card horizontal hoverable " + colorchoice(Convert.ToInt32((string)issue[i][4])) + "\">"; /* 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)issue[i][1] + "</p>"; htmldata1 += "</span>"; htmldata1 += "<p class=\"trunctext\">Project: " + (string)projectdetails[1] + "</p>"; htmldata1 += "<p class=\"trunctext\">Issue members: " + issmem + "</p>"; htmldata1 += "</div>"; htmldata1 += "</div>"; htmldata1 += "</div>"; htmldata1 += "</div>"; htmldata1 += "</a>"; } } else { htmldata1 += ""; } object[] assignedissueids = findata.getassignedissues(user.getID()); if (assignedissueids != null) { for (int i = 0; i < assignedissueids.Length; i++) { object[] assigiss = findata.getissuedetails((string)assignedissueids[0]); Object[] projectdetails = findata.getprojectdetails((string)assigiss[3]); object[] issteam = findata.getissuemembers((string)assignedissueids[0]); int issmem = 0; if (issteam != null) { issmem = issteam.Length; } htmldata2 += "<a href=\"Issueview.aspx?id=" + assigiss[0].ToString() + "\">"; htmldata2 += "<div class=\"col s12 m3 l0\">"; htmldata2 += "<div class=\"card horizontal hoverable " + colorchoice(Convert.ToInt32((string)assigiss[4])) + "\">"; /* 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\">" + assigiss[1].ToString() + "</p>"; htmldata2 += "</span>"; htmldata2 += "<p class=\"trunctext\">Project: " + (string)projectdetails[1] + "</p>"; htmldata2 += "<p class=\"trunctext\">Issue members: " + issmem + "</p>"; htmldata2 += "</div>"; htmldata2 += "</div>"; htmldata2 += "</div>"; htmldata2 += "</div>"; htmldata2 += "</a>"; } } else { htmldata2 += ""; } Object[][] userproj = findata.getprojects(user.getID()); if (userproj != null) { for (int i = 0; i < userproj.Length; i++) { object[][] issuedetails = findata.getissueflags((string)userproj[i][0]); if (issuedetails != null) { object[] projdetails = findata.getprojectdetails((string)userproj[i][0]); for (int j = 0; j < issuedetails.Length; j++) { htmldata3 += "<a href=\"Issueflagviewer.aspx?id=" + (string)issuedetails[j][0] + "\">"; htmldata3 += "<div class=\"col s12 m3 l0\">"; htmldata3 += "<div class=\"card horizontal hoverable\">"; /* htmldata += "<div class=\"card-image\">"; * * htmldata += "<img style='width:200px;height:200px' class= \"responsive-img\" src = 'data:image/jpeg;base64," + UserData.Nopic + "'/>"; * * * htmldata += "</div>";*/ htmldata3 += "<div class=\"card-stacked\">"; htmldata3 += "<div class=\"card-content black-text\">"; htmldata3 += "<span class=\"card-title\">" + "<p class=\" bold\">" + (string)issuedetails[j][3] + "</p>"; htmldata3 += "</span>"; htmldata3 += "<p class=\"trunctext\">Project: " + (string)projdetails[1] + "</p>"; htmldata3 += "<p class=\"trunctext\">Reporting member: " + (string)issuedetails[j][1] + "</p>"; htmldata3 += "</div>"; htmldata3 += "</div>"; htmldata3 += "</div>"; htmldata3 += "</div>"; htmldata3 += "</a>"; } } else { } } } yourprojects.InnerHtml = htmldata1; otherprojects.InnerHtml = htmldata2; flagged.InnerHtml = htmldata3; 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(); }
private void Eventsget() { string[] Scopes = { CalendarService.Scope.CalendarReadonly }; string ApplicationName = "Google Calendar API .NET Quickstart"; // if (Session["User"] != null) //Logged in // { UserData user = (UserData)Session["User"]; Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); 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]); DateTime exweek = credate.AddDays(14); int result = DateTime.Compare(exweek, 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 = 6; 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 = "Johannesburg"; } Boolean exsisting = false; object[] googleids = findata.geteventids(user.getID().ToString()); 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().ToString()); findata.deleteeventpics(eventItem.Id, user.getID().ToString()); } } 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 l4 \">"; 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 += "<p class=\"trunctext\">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().ToString(), desc); htmldata += "<a href=\"EventEdit.aspx?eid=" + id + "\">"; htmldata += "<div class=\"col s12 m4 l4 \">"; 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 += "<p class=\"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"); * }*/ }
private void Taskget() { string[] Scopes = { TasksService.Scope.TasksReadonly }; string ApplicationName = "Google Tasks API .NET Quickstart"; object[] storedtask = null; // string htmldata = "<div class='row'>"; string taskcolor = "white"; string complete = " <div class='row'>"; string incomplete = "<div class='row'>"; 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/tasks-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 Tasks API service. var service = new TasksService(new BaseClientService.Initializer() { HttpClientInitializer = credential, ApplicationName = ApplicationName, }); // Define parameters of request. Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); UserData user = (UserData)Session["User"]; TasksResource.ListRequest request = service.Tasks.List("@default"); request.MaxResults = 20; Google.Apis.Tasks.v1.Data.Tasks tasks = request.Execute(); if (tasks.Items != null) { foreach (Google.Apis.Tasks.v1.Data.Task task in tasks.Items) { string title = task.Title; string id = task.Id; if (task.Status.ToString() == "completed") { if (findata.checktasks(id, user.getID()) == id) { storedtask = findata.gettask(id, user.getID()); if ((string)storedtask[1] == title) { } else { findata.updatetask(task.Title, "1", user.getID().ToString(), (string)storedtask[4], task.Id, (string)storedtask[0]); } complete += "<a href=\"Taskedit.aspx?id=" + task.Id + "\">"; complete += "<div class=\"col s12 m3 l3\">"; complete += "<div class=\"card horizontal hoverable " + colorchoice(Convert.ToInt32((string)storedtask[4])) + "\">"; // htmldata += "<div class=\"card horizontal hoverable blue\">"; complete += "<div class=\"card-stacked\">"; complete += "<div class=\"card-content black-text\">"; complete += "<span class=\"card-title bold trunctext\">" + task.Title.ToString(); complete += "</span>"; complete += "</div>"; complete += "</div>"; complete += "</div>"; complete += "</div>"; complete += "</a>"; } else { findata.inserttask(task.Title, "1", "1", task.Id, user.getID()); complete += "<a href=\"Taskedit.aspx?id=" + task.Id + "\">"; complete += "<div class=\"col s12 m3 l3\">"; // complete += "<div class=\"card horizontal hoverable " + colorchoice(Convert.ToInt32((string)storedtask[4])) + " href=\"Taskedit" + "?id=" + task.Id + "\">"; complete += "<div class=\"card horizontal hoverable green\">"; complete += "<div class=\"card-stacked\">"; complete += "<div class=\"card-content black-text\">"; complete += "<span class=\"card-title bold trunctext\">" + task.Title.ToString(); complete += "</span>"; complete += "</div>"; complete += "</div>"; complete += "</div>"; complete += "</div>"; complete += "</a>"; } } else { if (findata.checktasks(id, user.getID()) == id) { storedtask = findata.gettask(id, user.getID()); if ((string)storedtask[1] == title) { } else { findata.updatetask(task.Title, "1", user.getID().ToString(), (string)storedtask[4], task.Id, (string)storedtask[0]); } incomplete += "<a href=\"Taskedit.aspx?id=" + task.Id + "\">"; incomplete += "<div class=\"col s12 m3 l3\">"; incomplete += "<div class=\"card hoverable " + colorchoice(Convert.ToInt32((string)storedtask[4])) + "\">"; //htmldata += "<div class=\"card horizontal hoverable blue\">"; incomplete += "<div class=\"card-stacked\">"; incomplete += "<div class=\"card-content black-text\">"; incomplete += "<span class=\"card-title bold trunctext\">" + task.Title.ToString(); incomplete += "</span>"; incomplete += "</div>"; incomplete += "</div>"; incomplete += "</div>"; incomplete += "</div>"; incomplete += "</a>"; } else { findata.inserttask(task.Title, "0", "1", task.Id, user.getID()); incomplete += "<a href=\"Taskedit.aspx?id=" + task.Id + "\">"; incomplete += "<div class=\"col s12 m3 l3\">"; // incomplete += "<div class=\"card horizontal hoverable " + colorchoice(Convert.ToInt32((string)storedtask[4])) + " href=\"Taskedit" + "?id=" + task.Id + "\">"; incomplete += "<div class=\"card hoverable green\">"; incomplete += "<div class=\"card-stacked\">"; incomplete += "<div class=\"card-content black-text\">"; incomplete += "<span class=\"card-title trunctext\">" + task.Title.ToString(); incomplete += "</span>"; incomplete += "</div>"; incomplete += "</div>"; incomplete += "</div>"; incomplete += "</div>"; incomplete += "</a>"; } } } } else { Console.WriteLine("No task lists found."); } // List task lists. //Console.Read(); incomplete += "</div>"; complete += "</div>"; taskinprogress.InnerHtml = incomplete; completedtask.InnerHtml = complete; findata.Close(); }
private void meetingget() { Object[][] usermeetings; Object[][] userothermeetings; object[] projdetails; string htmldata = ""; 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; } htmldata += "<a href=\"Meetingview.aspx?id=" + (string)usermeetings[i][0] + "\">"; htmldata += "<div class=\"col s12 m3 l0\">"; htmldata += "<div class=\"card horizontal hoverable grey lighten-1\">"; htmldata += "<div class=\"card-stacked\">"; htmldata += "<div class=\"card-content black-text\">"; htmldata += "<span class=\"card-title\">" + "<p class=\" bold\">" + (string)usermeetings[i][2] + "</p>"; htmldata += "</span>"; htmldata += "<p class=\"trunctext\">Project: " + (string)projdetails[1] + "</p>"; htmldata += "<p class=\"trunctext\">Project Members: " + projmem + "</p>"; htmldata += "<p class=\"trunctext\">Members Attending: " + mematt + "</p>"; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</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) { htmldata += "<a href=\"Meetingaccept.aspx?id=" + (string)userothermeetings[i][0] + "&ml=" + (string)userothermeetings[i][6] + "\">"; htmldata += "<div class=\"col s12 m3 l0\">"; htmldata += "<div class=\"card horizontal hoverable light-blue lighten-3\">"; htmldata += "<div class=\"card-stacked\">"; htmldata += "<div class=\"card-content black-text\">"; htmldata += "<span class=\"card-title\">" + "<p class=\" bold\">" + (string)userothermeetings[i][2] + "</p>"; htmldata += "</span>"; htmldata += "<p class=\"trunctext\">Project: " + (string)projdetails[1] + "</p>"; htmldata += "<p class=\"trunctext\">Project Members: " + projmem + "</p>"; htmldata += "<p class=\"trunctext\">Members Attending: " + mematt + "</p>"; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</a>"; } else { htmldata += "<a href=\"Meetingaccept.aspx?id=" + (string)userothermeetings[i][0] + "&ml=" + (string)userothermeetings[i][6] + "\">"; htmldata += "<div class=\"col s12 m3 l0\">"; htmldata += "<div class=\"card horizontal hoverable lime lighten-3\">"; htmldata += "<div class=\"card-stacked\">"; htmldata += "<div class=\"card-content black-text\">"; htmldata += "<span class=\"card-title\">" + "<p class=\" bold\">" + (string)userothermeetings[i][2] + "</p>"; htmldata += "</span>"; htmldata += "<p class=\"trunctext\">Project: " + (string)projdetails[1] + "</p>"; htmldata += "<p class=\"trunctext\">Project Members: " + projmem + "</p>"; htmldata += "<p class=\"trunctext\">Members Attending: " + mematt + "</p>"; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</a>"; } } } } findata.Close(); newmeetings.InnerHtml = htmldata; }
protected void Page_Load(object sender, EventArgs e) { if (Session["User"] == null) { Response.Redirect("Login.aspx"); } else { id = Request.QueryString.Get("id"); Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); Chatmanagement.ChatClient chat = new Chatmanagement.ChatClient(); UserData user = (UserData)Session["User"]; if (!IsPostBack) { Title = "Project Chat"; } findata.Open(); chat.Open(); projdetails = findata.getprojectdetails(id); lblidname.InnerHtml = "Project : " + (string)projdetails[1]; chatdata = chat.getprojchat(id); if (chatdata != null) { for (int i = 0; i < chatdata.Length; i++) { if ((string)chatdata[i][0] == user.getID()) { txtmsg.InnerText += Environment.NewLine; txtmsg.InnerText += (string)chatdata[i][2]; txtmsg.InnerText += Environment.NewLine; } else { txtmsg.InnerText += Environment.NewLine; txtmsg.InnerText += " " + (string)chatdata[i][1].ToString().ToUpper(); txtmsg.InnerText += Environment.NewLine; txtmsg.InnerText += " " + (string)chatdata[i][2]; txtmsg.InnerText += Environment.NewLine; } } } else { } txtmsg.InnerHtml += messageformat; findata.Close(); chat.Close(); } }