示例#1
0
        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");
            }
        }
示例#2
0
        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();
            }
        }
示例#3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            Title = "Meeting Invite";
            if (Session["User"] != null)
            {
                meetid = Request.QueryString.Get("id");
                mlid   = Request.QueryString.Get("ml");
                Dataservice.DatamanagementClient findata = new Dataservice.DatamanagementClient();
                findata.Open();
                object[]   getmeetinginfo       = findata.getmeetinginformation(meetid);
                object[]   getmlinfo            = findata.getmeetinglink(mlid);
                Object[][] getmeetingattendance = findata.getmeetingattendance(meetid);
                if (Boolean.Parse((string)getmlinfo[3]) == true)
                {
                    btnaccept.Visible = false;
                }

                if (getmeetinginfo != null)
                {
                    object[] gerporjectdetails = findata.getprojectdetails((string)getmeetinginfo[4]);
                    object[] getuserinformaion = findata.getspecificuserinformation((string)getmeetinginfo[5]);
                    txtprojname.Value           = (string)gerporjectdetails[1];
                    txtptojectleaderuname.Value = (string)getuserinformaion[0];
                    txtptojectleaderemail.Value = (string)getuserinformaion[1];
                    txtmeett.Value    = (string)getmeetinginfo[1];
                    txtmeetd.Value    = (string)getmeetinginfo[2];
                    txtmeetdate.Value = (string)getmeetinginfo[3];

                    if (getmeetingattendance != null)
                    {
                        for (int i = 0; i < getmeetingattendance.Length; i++)
                        {
                            htmldata += "<li class=\"collection-item\"><span style=\"font-weight:bold\">Username: "******"&nbsp&nbsp&nbsp      Attending: " + (string)getmeetingattendance[i][1] + "</span></li>";
                        }
                    }

                    else
                    {
                        htmldata += "<li class=\"collection-item\"><span style=\"font-weight:bold\">No memebrs yet</span></li>";
                    }


                    membersattending.InnerHtml += htmldata;
                }



                findata.Close();
            }
            else
            {
                Response.Redirect("Login.aspx");
            }
        }
示例#4
0
        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;
        }
示例#5
0
        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();
                }
            }
        }
示例#6
0
        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) + "&nbsp&nbsp&nbsp              Username:    "******"&nbsp&nbsp&nbsp              Email:     " + (string)projectmemdetails[1] + "&nbsp&nbsp&nbsp              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();
                }
            }
        }
示例#7
0
        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");
            }
        }
示例#8
0
        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();
            }
        }
示例#9
0
        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();
            }
        }
示例#10
0
        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();
            }
        }
示例#11
0
        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();
                }
            }
        }
示例#12
0
        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();
        }
示例#13
0
      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() + "&nbsp&nbsp&nbsp       Username: "******"&nbsp&nbsp&nbsp      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();
          }
      }
示例#14
0
        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();
            }
        }