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();
}
}
private void getissuenotifitcaions()
{
string htmldata = "";
Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient();
UserData user = (UserData)Session["User"];
findata.Open();
object[][] issuenotifications = findata.getissuenotifications(user.getID());
if (issuenotifications != null)
{
for (int i = 0; i < issuenotifications.Length; i++)
{
DateTime credate = DateTime.Parse((string)issuenotifications[i][3]);
DateTime exdate = credate.AddDays(14);
object[] issuedetails = findata.getissuedetails((string)issuenotifications[i][1]);
object[] projdetails = findata.getprojectdetails((string)issuedetails[3]);
int result = DateTime.Compare(exdate, DateTime.Now);
if (result < 0)
{
findata.deleteporjnotificaiton((string)issuenotifications[i][0], user.getID());
}
else
{
htmldata += "<a href=\"Issueaccept.aspx?id=" + (string)issuedetails[0] + "&in=" + (string)issuenotifications[i][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 orange lighten-3\">";
htmldata += "<div class=\"card-stacked\">";
htmldata += "<div class=\"card-content black-text\">";
htmldata += "<span class=\"card-title\"><p class=\"bold\">" + (string)issuedetails[1] + "</p>";
htmldata += "</span>";
htmldata += "<p class=\"trunctext\">Project: " + (string)projdetails[1] + "</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();
newissues.InnerHtml = htmldata;
}
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)
{
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
{
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 = "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();
}
}
