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();
}
}
