protected void btnacceptproject_ServerClick(object sender, EventArgs e) { UserData user = (UserData)Session["User"]; Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); int result = findata.addprojteam(user.getID(), pid); if (result == 1) { int delete = findata.deleteporjnotificaiton(pid, user.getID()); if (delete == 1) { changeaccPage(); } else { changeerrorPage(); } } findata.Close(); }
protected void btnsendchat_ServerClick(object sender, EventArgs e) { Chatmanagement.ChatClient chat = new Chatmanagement.ChatClient(); UserData user = (UserData)Session["User"]; chat.Open(); if (txtsend.Equals("")) { Invlaidproject.InnerHtml += "<p>No message to send.</p>"; } else { int result = chat.insertissuechat(txtsend.Value.ToString(), id, user.getID()); if (result == 1) { chat.Close(); Page.Response.Redirect(Page.Request.Url.ToString(), true); } chat.Close(); } chat.Close(); }
protected void Page_Load(object sender, EventArgs e) { Title = "Meeting Add"; if (Session["User"] != null) { Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); UserData user = (UserData)Session["User"]; if (!IsPostBack) { Object[][] userprojects = findata.getprojects(user.getID()); if (userprojects != null) { for (int i = 0; i < userprojects.Length; i++) { Projchoose.Items.Add(new ListItem(" " + (string)userprojects[i][1], userprojects[i][0].ToString())); } } else { addmembers(); } } findata.Close(); } else { Response.Redirect("Login.aspx"); } }
protected void btnDeleteevent_ServerClick(object sender, EventArgs e) { 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/calendardelete-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 CalendarService(new BaseClientService.Initializer() { HttpClientInitializer = credential, ApplicationName = ApplicationName, }); service.Events.Delete("primary", eID).ExecuteAsync(); changePagedelete(); UserData user = (UserData)(Session["User"]); Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); findata.deleteevent(eID, user.getID()); findata.Close(); }
protected void Page_Load(object sender, EventArgs e) { Title = "Issue Report"; if (Session["User"] != null) { if (!IsPostBack) { UserData user = (UserData)Session["User"]; findata = new Dataservice.DatamanagementClient(); findata.Open(); object[] userassingedproj = findata.getassignedprojects(user.getID()); if (userassingedproj != null) { for (int i = 0; i < userassingedproj.Length; i++) { object[] projdetails = findata.getprojectdetails((string)userassingedproj[i]); Projectchoose.Items.Add(new ListItem(" " + (string)projdetails[1], projdetails[0].ToString())); } } findata.Close(); } } else { Response.Redirect("Login.aspx"); } }
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 { 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 = "Issue Chat"; } findata.Open(); chat.Open(); issuedetails = findata.getissuedetails(id); projdetails = findata.getprojectdetails((string)issuedetails[3]); lblidname.InnerHtml = "Project : " + (string)projdetails[1] + " Issue : " + (string)issuedetails[1]; chatdata = chat.getissuechat(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 { } findata.Close(); chat.Close(); } }
protected void btnprojadd_ServerClick(object sender, EventArgs e) { Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); UserData user = (UserData)Session["User"]; Object[][] members = findata.getuserinformation(); if (txtprojd.Value.Equals("") || txtprojt.Value.Equals("")) { Invlaidproject.InnerHtml = "*Please make sure you have filled in all the fields<br/>"; return; } else if (txtdom.Value.Equals("") || txttime.Value.Equals("")) { Invlaidproject.InnerHtml = "*Please add a date and time for first meeting<br/>"; return; } else { int result = findata.createproject(txtprojt.Value, txtprojd.Value, user.getID(), DateTime.Now); // int meeting = findata.insertmeeting("Project:" + txtprojt.Value, txtprojd.Value ); if (result != 0) { foreach (ListItem item in UserChoose.Items) { if (item.Selected) { int id = Convert.ToInt32(item.Value.ToString()); findata.insertprojectnotifications(result.ToString(), id.ToString(), DateTime.Now); } } DateTime d = Convert.ToDateTime(txtdom.Value); DateTime t = Convert.ToDateTime(txttime.Value); DateTime dt = new DateTime(d.Year, d.Month, d.Day, t.Hour, t.Minute, t.Second); DateTime getdate = DateTime.Parse(XmlConvert.ToString(dt, XmlDateTimeSerializationMode.Utc)); int createmeeting = findata.insertmeeting("Project: " + txtprojt.Value.ToString(), "First meeting", getdate.ToString(), result.ToString(), user.getID()); if (createmeeting == 1) { insertevent(); } } } findata.Close(); changePage(); }
// private string htmldata; protected void Page_Load(object sender, EventArgs e) { Title = "Pictures"; if (Session["User"] == null) { Response.Redirect("Login.aspx"); } else { if (!IsPostBack) { Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); // UserData currentUser = (UserData)(Session["User"]); UserData user = (UserData)Session["User"]; Object[][] pictures = findata.getalluserpictures(user.getID()); if (pictures != null) { for (int i = 0; i < pictures.Length; i++) { // htmldata += "<a class=\"carousel - item\" href=\"Pictureedit?id=" + (string)pictures[i][0] + "\"><img style='width:250px;height:250px' class= \"responsive-img\" src = 'data:image/jpeg;base64," + (string)pictures[i][1] + "'/></a>"; htmldata += "<a href=\"Pictureedit.aspx?id=" + (string)pictures[i][0] + "\">"; htmldata += "<div class=\"col card hoverable\">"; htmldata += "<div class=\"card-image waves-effect waves-block waves-light\">"; htmldata += "<img style='width:200px;height:200px' class=\"responsive-img\" src = 'data:image/jpeg;base64," + (string)pictures[i][1] + "'/>"; htmldata += "<span class=\"card-title\">" + (string)pictures[i][2] + "</span>"; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</a>"; } } // htmldata += "<a class=\"carousel - item\" href=\"#one!\"><img style='width:300px;height:300px' class= \"responsive-img\" src = 'data:image/jpeg;base64," + UserData.Nopic + "'/></a>"; htmldata += "</div>"; findata.Close(); picturecarousel.InnerHtml = htmldata; } else { Response.Redirect("Allpictures.aspx"); } } }
protected void btnDeletefromteam_ServerClick(object sender, EventArgs e) { id = Request.QueryString.Get("id"); UserData user = (UserData)Session["User"]; Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); int result = findata.deleteassiguserfromteam(user.getID(), id); int deletemeeting = findata.deleteuserfrommeetinglink(user.getID()); if (result == 1) { changePage(); } findata.Close(); }
protected void btnDeletepic_ServerClick(object sender, EventArgs e) { user = (UserData)(Session["User"]); string id = Request.QueryString.Get("id"); Dataservice.DatamanagementClient findatae = new Dataservice.DatamanagementClient(); findatae.Open(); findatae.deletepicture(id, user.getID()); findatae.Close(); Response.Redirect("Allpictures.aspx"); }
private async void taskedit() { 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/tasksupdate-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, }); Google.Apis.Tasks.v1.Data.Task task = service.Tasks.Get("@default", taskid).Execute(); if (Completedcheck.Checked == false) { task.Status = "needsAction"; task.CompletedRaw = null; task.Completed = null; completed = 0; } else if (Completedcheck.Checked == true) { task.Status = "completed"; completed = 1; } task.Title = txttaskanme.Value; Google.Apis.Tasks.v1.Data.Task result = await service.Tasks.Update(task, "@default", taskid).ExecuteAsync(); UserData user = (UserData)Session["User"]; Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); object[] taskdetails = findata.gettask(taskid, user.getID()); int getnum = findata.updatetask(txttaskanme.Value.ToString(), completed.ToString(), user.getID(), Leveldrop.Items[Leveldrop.SelectedIndex].Text.ToString(), result.Id.ToString(), (string)taskdetails[0]); findata.Close(); }
private void getprojectnotificaitons() { string htmldata = ""; Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); UserData user = (UserData)Session["User"]; object[][] projectnotificaiotns = findata.getprojnotification(user.getID()); if (projectnotificaiotns != null) { for (int j = 0; j < projectnotificaiotns.Length; j++) { object[] projdetails = findata.getprojectdetails((string)projectnotificaiotns[j][1]); object[] getprojleader = findata.getprojectleaderinformaion((string)projdetails[3]); DateTime credate = DateTime.Parse((string)projectnotificaiotns[j][3]); DateTime exdate = credate.AddDays(14); int result = DateTime.Compare(exdate, DateTime.Now); if (result < 0) { findata.deleteporjnotificaiton((string)projectnotificaiotns[j][0], user.getID()); } else { htmldata += "<a href=\"Projectaccept.aspx?id=" + (string)projdetails[0] + "&pn=" + (string)projectnotificaiotns[j][0] + "\">"; htmldata += "<div class=\"col s12 m4 l4\">"; // incomplete += "<div class=\"card horizontal hoverable " + colorchoice(Convert.ToInt32((string)storedtask[4])) + " href=\"Taskedit" + "?id=" + task.Id + "\">"; htmldata += "<div class=\"card hoverable green accent-2\">"; htmldata += "<div class=\"card-stacked\">"; htmldata += "<div class=\"card-content black-text\">"; htmldata += "<span class=\"card-title\"><p class=\"bold\">" + (string)projdetails[1] + "</p>"; htmldata += "</span>"; htmldata += "<p class=\"trunctext\">Project owner: " + (string)getprojleader[0] + "</p>"; htmldata += "<p class=\"trunctext\">Expires in: " + (exdate - DateTime.Now).Days + " Days</p>"; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</a>"; } } } findata.Close(); newprojects.InnerHtml = htmldata; }
protected void btncancelprojnotification_Click(object sender, EventArgs e) { UserData user = (UserData)Session["User"]; Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); int result = findata.deleteporjnotificaiton(pid, user.getID()); if (result == 1) { changecancelPage(); } else { changeerrorPage(); } findata.Close(); }
private void Pictureget() { UserData user = (UserData)Session["User"]; string htmldata = "<div>"; Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); // UserData currentUser = (UserData)(Session["User"]); Object[][] pictures = findata.getfewpics(user.getID()); if (pictures != null) { for (int i = 0; i < pictures.Length; i++) { // htmldata += "<a class=\"carousel - item\" href=\"Pictureedit?id=" + (string)pictures[i][0] + "\"><img style='width:250px;height:250px' class= \"responsive-img\" src = 'data:image/jpeg;base64," + (string)pictures[i][1] + "'/></a>"; htmldata += "<a href=\"Pictureedit.aspx?id=" + (string)pictures[i][0] + "\">"; htmldata += "<div class=\"col 7 card hoverable\">"; htmldata += "<div class=\"card-image waves-effect waves-block waves-light\">"; htmldata += "<img style='width:200px;height:200px' class= \"responsive-img\" src = 'data:image/jpeg;base64," + (string)pictures[i][1] + "'/>"; htmldata += "<span class=\"card-title \"><p class=\"trunctext bold\">" + (string)pictures[i][2] + "</p></span>"; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</a>"; } // htmldata += "<a class=\"carousel - item\" href=\"#one!\"><img style='width:300px;height:300px' class= \"responsive-img\" src = 'data:image/jpeg;base64," + UserData.Nopic + "'/></a>"; } htmldata += "</div>"; picturecarousel.InnerHtml = htmldata; findata.Close(); }
protected void Page_Load(object sender, EventArgs e) { Title = "Task Edit"; taskid = Request.QueryString.Get("id"); UserData user = (UserData)Session["User"]; if (user != null) { if (!IsPostBack) { Leveldrop.Items.Add(new ListItem("1", "1")); Leveldrop.Items.Add(new ListItem("2", "2")); Leveldrop.Items.Add(new ListItem("3", "3")); Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); storetask = findata.gettask(taskid, user.getID()); if (storetask != null) { txttaskanme.Value = (string)storetask[1]; Leveldrop.Items.FindByText((string)storetask[4]).Selected = true; if (Convert.ToBoolean(storetask[2])) { Completedcheck.Checked = true; } else { Completedcheck.Checked = false; } } findata.Close(); } } else { Response.Redirect("Login.aspx"); } }
protected void btnDeletefromteam_ServerClick(object sender, EventArgs e) { string id = Request.QueryString.Get("id"); UserData user = (UserData)Session["User"]; Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); Chatmanagement.ChatClient chat = new Chatmanagement.ChatClient(); findata.Open(); chat.Open(); //chat.deleteisschatuser(user.getID()); int result = findata.deleteassiguserformissue(user.getID(), id); findata.Close(); chat.Close(); if (result == 1) { Response.Redirect("Issues.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { Title = "Picture Edit"; if (Session["User"] != null) { if (!IsPostBack) { string id = Request.QueryString.Get("id"); string htmldata = ""; Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); user = (UserData)(Session["User"]); findata.Open(); object[] picture = findata.getpic(id, user.getID()); findata.Close(); htmldata += "<div class=\"card-image\">"; htmldata += "<img class= \"responsive-img\" src = 'data:image/jpeg;base64," + (string)picture[1] + "'/>"; htmldata += "</div>"; txtpictitle.Value = (string)picture[2]; txtpicdescription.Value = (string)picture[3]; pictureholder.InnerHtml = htmldata; } } else { Response.Redirect("Login.aspx"); } }
protected void btnUpdatepic_ServerClick(object sender, EventArgs e) { Boolean postad = true; user = (UserData)(Session["User"]); if (txtpicdescription.Value.Equals("")) { Invlaidtask.InnerHtml = "<p>Please provide a description</p>"; postad = false; return; } if (postad) { string id = Request.QueryString.Get("id"); Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); int success = findata.updatepic(id, txtpictitle.Value, txtpicdescription.Value, user.getID()); findata.Close(); Response.Redirect("Allpictures.aspx"); } }
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 btnDeleteAcc_Click(object sender, EventArgs e) { user = (UserData)(Session["User"]); Userservice.UserserviceClient service = new Userservice.UserserviceClient(); Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); Chatmanagement.ChatClient chat = new Chatmanagement.ChatClient(); service.Open(); findata.Open(); chat.Open(); Object[][] getuserprojects = findata.getprojects(user.getID()); if (getuserprojects != null) { for (int j = 0; j < getuserprojects.Length; j++) { string pid = (string)getuserprojects[j][0]; int team = findata.deleteprojteam(pid); int delete = findata.deleteallprojnotificaion(pid); int deleteprojchat = chat.deleteprojchat(pid); int deltepissflags = findata.deleteissflagproj(pid); object[] getmeetingid = findata.getprojmeetings(pid); if (getmeetingid != null) { for (int i = 0; i < getmeetingid.Length; i++) { int meetmemdel = findata.deletemeetingmembers((string)getmeetingid[i]); if (meetmemdel == 1) { findata.deletemeeting((string)getmeetingid[i]); } } } object[][] getprojiss = findata.getprojissues(pid); if (getprojiss != null) { for (int i = 0; i < getprojiss.Length; i++) { object[] issnotice = findata.getissnoticeiss((string)getprojiss[i][0]); if (issnotice != null) { findata.deleteissnoticeiss((string)getprojiss[i][0]); } chat.deleteissuechat((string)getprojiss[i][0]); findata.deleteissue((string)getprojiss[i][0]); } } int proj = findata.deleteproject(pid); } } int projchat = chat.deleteprojchatuser(user.getID()); int isschat = chat.deleteisschatuser(user.getID()); int meetinglinks = findata.deleteuserfrommeetinglink(user.getID()); int projteams = findata.deleteuserfromprojteams(user.getID()); int issteams = findata.deleteuserfromissteams(user.getID()); int issflag = findata.deleteuserfromisflags(user.getID()); int deletedvents = findata.deletealluserevents(user.getID()); int deletetasks = findata.deleteallusertasks(user.getID()); int deletepic = findata.deleteallpictures(user.getID()); int result = service.deleteUser(user.getID()); if (result == 1)//if the result is one then the user is deleted and redirected to the index page { Session["User"] = null; //Response.Write("<script>alert('User Account Deleted!');</script>"); Response.Redirect("Default.aspx"); } service.Close(); findata.Close(); chat.Close(); }
protected void btnUpdateAccount_ServerClick(object sender, EventArgs e) { if (txtFirstName.Value.Equals("") || txtLastName.Value.Equals("") || txtDoB.Value.Equals("")) { invalidprof.InnerHtml = "* Fill in all the fields</br>"; } else { if (txtgithublink.Value.Equals("")) { invalidprof.InnerHtml = "*You can add a repo link later in your profile.<br/>"; link = ""; } else if (!txtgithublink.Value.Contains("https://github.com/")) { invalidprof.InnerHtml = "Your repo link is not a valid GitHub repo.<br/>"; } else { link = txtgithublink.Value.ToString(); } user = (UserData)(Session["User"]); Userservice.UserserviceClient service = new Userservice.UserserviceClient(); int skill = skilldrop.SelectedIndex; service.Open(); int result = service.updateUserInfo(user.getID(), txtFirstName.Value, txtLastName.Value, Convert.ToDateTime(txtDoB.Value), skill.ToString(), link); service.Close(); if (result == 1)//if the result is one then the user is deleted and redirected to the index page { Session["User"] = null; htmldata = "<div class=\"col s12 m6 push-m3\">"; htmldata += "<div class=\"card white\">"; htmldata += "<div class=\"card-content Black-text\">"; htmldata += "<span class=\"card-title bold\">Account Updated Successfully</span>"; htmldata += "<p>Your account has been updated successfully.<br/><br/>Please proceeed to log back into your account to view the changes.</p>"; htmldata += "</div>"; htmldata += "<div class=\"card-action\"> "; htmldata += "<a href=\"Login.aspx\" class=\"btn waves-effect waves-light\">Continue</a> "; htmldata += "<a href=\"Default.aspx\" class=\"btn waves-effect waves-light orange lighten-2\">Cancel</a> "; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</div>"; } else { Session["User"] = null; htmldata = "<div class=\"col s12 m6 push-m3\">"; htmldata += "<div class=\"card white\">"; htmldata += "<div class=\"card-content Black-text\">"; htmldata += "<span class=\"card-title bold\">Oh No...An Error Occured</span>"; htmldata += "<p>Unfortunately we were unable to update your account.<br/><br/>As a precaution, please log back into your account where you may try again.</p>"; htmldata += "</div>"; htmldata += "<div class=\"card-action\"> "; htmldata += "<a href=\"Login.aspx\" class=\"btn waves-effect waves-light\">Continue</a> "; htmldata += "<a href=\"Default.aspx\" class=\"btn waves-effect waves-light orange lighten-2\">Cancel</a> "; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</div>"; } myProfileView.InnerHtml = htmldata; } }
protected void Page_Load(object sender, EventArgs e) { upev.InnerHtml = ""; if (Session["User"] != null) { Title = "Search"; string searchterm = Request.QueryString.Get("term"); indexTitle.InnerText = "Searching user: "******"User"]; if (searchdetails != null) { for (int i = 0; i < searchdetails.Length; i++) { if ((string)searchdetails[i][0] == user.getID()) { } else { htmldata += "<a href=\"Profileviewer.aspx?uid=" + (string)searchdetails[i][0] + "\">"; htmldata += "<div class=\"col s12 m4 l0\">"; if ((string)searchdetails[i][4] == "") { htmldata += "<div class=\"card horizontal hoverable grey lighten-1\">"; } else { htmldata += "<div class=\"card horizontal hoverable green lighten-1\">"; } /* 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\">" + (string)searchdetails[i][1] + "</p>"; htmldata += "</span>"; htmldata += "<p class=\"bold\">Email: " + (string)searchdetails[i][2] + "</p>"; htmldata += "<p class=\"bold\">Skill: " + (string)searchdetails[i][3] + "</p>"; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</div>"; htmldata += "</a>"; } } } else { changePage(); } userdata.Close(); upev.InnerHtml = htmldata; } else { Response.Redirect("Login.aspx"); } }
protected void btnpicadd_ServerClick(object sender, EventArgs e) { UserData user = (UserData)(Session["User"]); string base64String = ""; if (picchoice.PostedFile.ContentLength != 0 && base64String != "Nopic") { base64String = ImageFunctions.validateImage(new BinaryReader(picchoice.PostedFile.InputStream).ReadBytes(picchoice.PostedFile.ContentLength)); Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); findata.Open(); findata.insertpicture(base64String, txtpictitle.Value, txtpicdesc.Value, user.getID().ToString()); findata.Close(); Response.Redirect("Allpictures.aspx"); } else { Invlaidpic.InnerHtml = "<p>Please add a picture to proceed</p>"; base64String = "Nopic"; } }
private async void inserttask() { UserCredential credential; using (var stream = new FileStream(Server.MapPath("client_secret.json"), FileMode.Open, FileAccess.Read)) { string credPath = Server.MapPath("/token.json"); credential = GoogleWebAuthorizationBroker.AuthorizeAsync( GoogleClientSecrets.Load(stream).Secrets, Scopes, "user", CancellationToken.None, new FileDataStore(credPath, true)).Result; Console.WriteLine("Credential file saved to: " + credPath); } 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/tasksadd-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, }); Google.Apis.Tasks.v1.Data.Task task = new Google.Apis.Tasks.v1.Data.Task { Title = "Issue: " + (string)issdetails[1] + " Project: " + (string)projdetails[1] }; newtask = await service.Tasks.Insert(task, "@default").ExecuteAsync(); Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient(); UserData user = (UserData)Session["User"]; findata.Open(); findata.inserttask(newtask.Title, "0", (string)issdetails[4].ToString(), newtask.Id, user.getID()); 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 = "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(); } }
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 = "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(); } }