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