예제 #1
0
        public ActionResult uploadFilePartial(int ID)
        {
            var tblAttachment = pocoDb.Fetch <tblFileAttachment>("Where objectTypeID=@0 and itemID=@1", 11, ID);
            var VM            = new ClientPortal.ViewModels.IssueListViewModel
            {
                Attachments = tblAttachment
            };

            return(View(VM));
        }
예제 #2
0
        public ActionResult cancelledIssues(int solutionID)
        {
            List <int> cancelledStatusIDs = new List <int>();

            cancelledStatusIDs.Add(9);
            cancelledStatusIDs.Add(11);
            var tblIssues    = pocoDb.Fetch <tblIssue>("Where solutionId=@0 and issueStatusID IN(@1)", solutionID, cancelledStatusIDs).ToList();
            var topTenIssues = tblIssues.OrderByDescending(m => m.ModifiedDate).Take(10);
            var tblType      = pocoDb.Fetch <tblIssueType>("where 1=1").ToList();
            var tblstatus    = pocoDb.Fetch <tblIssueStatus>("where 1=1").ToList();
            var VMComponent  = new ClientPortal.ViewModels.IssueListViewModel
            {
                Issues   = topTenIssues,
                Statuses = tblstatus,
                Types    = tblType
            };

            return(View(VMComponent));
        }
예제 #3
0
        public ActionResult solutionIssues(int ID)
        {
            string userid = "";

            if (Session["userId"] != null)
            {
                userid = Session["userId"].ToString();
            }
            int userID = int.Parse(userid);

            Session["solutionId"] = ID;
            var        solution       = pocoDb.Fetch <tblSolution>("where solutionID = @0", ID).FirstOrDefault();
            var        Types          = pocoDb.Fetch <tblIssueType>("where 1=1").ToList();
            var        statuses       = pocoDb.Fetch <tblIssueStatus>("where 1=1");
            var        tblComponent   = pocoDb.Fetch <tblSolutionComponent>("where solutionID=@0", ID).ToList();
            List <int> clientStatusId = new List <int>()
            {
                13, 14
            };
            var        clientIssues             = pocoDb.Fetch <tblIssue>("Where issueStatusID IN(@0) and solutionId=@1", clientStatusId, ID);
            List <int> clientStatusExceptClosed = new List <int>()
            {
                1, 4, 10, 12, 13, 14, 15, 16, 17
            };

            var clientIssuesExceptClosed = pocoDb.Fetch <tblIssue>("Where issueStatusID IN(@0) and solutionId=@1", clientStatusExceptClosed, ID);
            var tblstatusClientTitle     = pocoDb.Fetch <tblIssueStatus>("where 1=1").DistinctBy(m => m.ClientTitle);

            ViewBag.ClientTitle = new SelectList(tblstatusClientTitle, "ClientTitle", "ClientTitle");
            var VM = new ClientPortal.ViewModels.IssueListViewModel
            {
                Solutions                = solution,
                Statuses                 = statuses,
                Components               = tblComponent,
                Types                    = Types,
                clientIssues             = clientIssues,
                clientIssuesExceptClosed = clientIssuesExceptClosed
            };

            return(View(VM));
        }
예제 #4
0
        public ActionResult filterStatus(int componentID, int solutionID, Boolean checkbox)
        {
            if (componentID == 0)
            {
                if (checkbox == false || checkbox == true)
                {
                    List <int> clientStatusExceptClosed = new List <int>()
                    {
                        1, 4, 10, 12, 13, 14, 15, 16, 17
                    };
                    var clientIssuesExceptClosed = pocoDb.Fetch <tblIssue>("Where issueStatusID IN(@0) and solutionId=@1", clientStatusExceptClosed, solutionID);
                    var tblType     = pocoDb.Fetch <tblIssueType>("where 1=1").ToList();
                    var tblstatus   = pocoDb.Fetch <tblIssueStatus>("where 1=1").ToList();
                    var VMComponent = new ClientPortal.ViewModels.IssueListViewModel
                    {
                        Issues   = clientIssuesExceptClosed,
                        Statuses = tblstatus,
                        Types    = tblType
                    };
                    return(PartialView(VMComponent));
                }
            }

            else
            {
                if (checkbox == false)
                {
                    List <int> clientStatusExceptClosed = new List <int>()
                    {
                        1, 4, 10, 12, 13, 14, 15, 16, 17
                    };
                    var clientIssuesExceptClosed = pocoDb.Fetch <tblIssue>("Where issueStatusID IN(@0) and solutionId=@1 and solutionComponentID=@2", clientStatusExceptClosed, solutionID, componentID);
                    var tblType     = pocoDb.Fetch <tblIssueType>("where 1=1").ToList();
                    var tblstatus   = pocoDb.Fetch <tblIssueStatus>("where 1=1").ToList();
                    var VMComponent = new ClientPortal.ViewModels.IssueListViewModel
                    {
                        Issues   = clientIssuesExceptClosed,
                        Statuses = tblstatus,
                        Types    = tblType
                    };

                    return(PartialView(VMComponent));
                }
                else
                {
                    List <int> clientStatusincludingClosed = new List <int>()
                    {
                        1, 4, 9, 10, 11, 12, 13, 14, 15, 16, 17
                    };
                    var clientIssue = pocoDb.Fetch <tblIssue>("Where issueStatusID IN(@0) and solutionId=@1 and solutionComponentID=@2", clientStatusincludingClosed, solutionID, componentID);
                    var tblType     = pocoDb.Fetch <tblIssueType>("where 1=1").ToList();
                    var tblstatus   = pocoDb.Fetch <tblIssueStatus>("where 1=1").ToList();
                    var VMComponent = new ClientPortal.ViewModels.IssueListViewModel
                    {
                        Issues   = clientIssue,
                        Statuses = tblstatus,
                        Types    = tblType
                    };

                    return(PartialView(VMComponent));
                }
            }
            return(View());
        }