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