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 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 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();
}
}
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)
{
Title = "Chats";
if (Session["User"] == null)
{
Response.Redirect("Login.aspx");
}
else
{
UserData user = (UserData)Session["User"];
Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient();
findata.Open();
Object[][] projects = findata.getprojects(user.getID());
Object[][] otherprojects = findata.getassignedprojdetials(user.getID());
Object[][] issue = findata.getissues(user.getID());
Object[][] otherissues = findata.getassignedissdetials(user.getID());
if (projects != null)
{
for (int i = 0; i < projects.Length; i++)
{
object[] projmembers = findata.getprojectmembers((string)projects[i][0]);
int nummem = 0;
if (projmembers != null)
{
nummem = projmembers.Length;
}
htmldata1 += "<a href=\"Chatspecificproj.aspx?id=" + (string)projects[i][0] + "\">";
htmldata1 += "<div class=\"col s12 m3 l0\">";
htmldata1 += "<div class=\"card horizontal hoverable blue-grey\">";
/* 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=\"bold\">Members: " + nummem + "</p>";
htmldata1 += "</span>";
htmldata1 += "</div>";
htmldata1 += "</div>";
htmldata1 += "</div>";
htmldata1 += "</div>";
htmldata1 += "</a>";
}
}
else
{
htmldata1 += "";
}
if (otherprojects != null)
{
for (int i = 0; i < otherprojects.Length; i++)
{
object[] projmembers = findata.getprojectmembers((string)otherprojects[i][0]);
int nummem = 0;
if (projmembers != null)
{
nummem = projmembers.Length;
}
htmldata1 += "<a href=\"Chatspecificproj.aspx?id=" + (string)otherprojects[i][0] + "\">";
htmldata1 += "<div class=\"col s12 m3 l0\">";
htmldata1 += "<div class=\"card horizontal hoverable blue-grey lighten-5\">";
htmldata1 += "<div class=\"card-stacked\">";
htmldata1 += "<div class=\"card-content black-text\">";
htmldata1 += "<span class=\"card-title\">" +
"<p class=\"bold\">" + (string)otherprojects[i][1] + "</p>";
htmldata1 += "</span>";
htmldata1 += "<p class=\"bold\">Members: " + nummem + "</p>";
htmldata1 += "</span>";
htmldata1 += "</div>";
htmldata1 += "</div>";
htmldata1 += "</div>";
htmldata1 += "</div>";
htmldata1 += "</a>";
}
}
else
{
htmldata1 += "";
}
if (issue != null)
{
for (int i = 0; i < issue.Length; i++)
{
Object[] projectdetails = findata.getprojectdetails((string)issue[i][3]);
object[] issmembers = findata.getissuemembers((string)issue[i][0]);
int nummem = 0;
if (issmembers != null)
{
nummem = issmembers.Length;
}
htmldata2 += "<a href=\"Chatspecificissue.aspx?id=" + (string)issue[i][0] + "\">";
htmldata2 += "<div class=\"col s12 m3 l0\">";
htmldata2 += "<div class=\"card horizontal hoverable green\">";
/* 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\">" + (string)issue[i][1] + "</p>";
htmldata2 += "</span>";
htmldata2 += "<p class=\"trunctext\">Project: " + (string)projectdetails[1] + "</p>";
htmldata2 += "</span>";
htmldata2 += "<p class=\"bold\">Members: " + nummem + "</p>";
htmldata2 += "</div>";
htmldata2 += "</div>";
htmldata2 += "</div>";
htmldata2 += "</div>";
htmldata2 += "</a>";
}
}
else
{
htmldata2 += "";
}
if (otherissues != null)
{
for (int i = 0; i < otherissues.Length; i++)
{
Object[] projectdetails = findata.getprojectdetails((string)otherissues[i][0]);
object[] issmembers = findata.getissuemembers((string)otherissues[i][0]);
int nummem = 0;
if (issmembers != null)
{
nummem = issmembers.Length;
}
htmldata2 += "<a href=\"Chatspecificissue.aspx?id=" + (string)otherissues[i][0] + "\">";
htmldata2 += "<div class=\"col s12 m3 l0\">";
htmldata2 += "<div class=\"card horizontal hoverable cyan 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>";*/
htmldata2 += "<div class=\"card-stacked\">";
htmldata2 += "<div class=\"card-content black-text\">";
htmldata2 += "<span class=\"card-title\">" +
"<p class=\" bold\">" + (string)otherissues[i][1] + "</p>";
htmldata2 += "</span>";
htmldata2 += "<p class=\"trunctext\">Project: " + (string)projectdetails[1] + "</p>";
htmldata2 += "</span>";
htmldata2 += "<p class=\"bold\">Members: " + nummem + "</p>";
htmldata2 += "</div>";
htmldata2 += "</div>";
htmldata2 += "</div>";
htmldata2 += "</div>";
htmldata2 += "</a>";
}
}
else
{
htmldata2 += "";
}
Projects.InnerHtml += htmldata1;
Issues.InnerHtml += htmldata2;
findata.Close();
}
}