Esempio n. 1
0
        public projectSummaryDTO GetSummaryCharts(string Filter, Int64 ProjectId = 0, Int64 MilestoneId = 0, string Value1 = "0", string TaskIds = null, string LocationIds = null, DateTime?FromDate = null, DateTime?ToDate = null, string SearchFilter = null, string FilterOption = null, string Request = "")
        {
            projectSummaryDTO obj = new projectSummaryDTO();

            PM_DashboardDL pd = new PM_DashboardDL();
            DataSet        ds = pd.GetDashboardWO(Filter, ProjectId, 5, 0, "", TaskIds, LocationIds, FromDate, ToDate, null);

            DataTable dtSiteStatus          = ds.Tables[0];
            DataTable dtIssueDistribution   = ds.Tables[1];
            DataTable dtIssueAccountibility = ds.Tables[2];

            obj.SiteStatus          = dtSiteStatus.ToList <SiteStatusDTO>();
            obj.IssueDistribution   = dtIssueDistribution.ToList <IssueDistributionDTO>();
            obj.IssueAccountibility = dtIssueAccountibility.ToList <IssueAccountibilityyDTO>();

            //http://localhost:18460/swi/PM_SummayCharts?&filter=PROGRAM_SUMMARY&ProjectId=20021&MilestoneId=0&Value1=0&TaskIds=50076&LocationIds=163408,163409,163410,163411,163412,163413,163414,163415,163416,163405,163406,163407163408,163409,163410,163411,163412,163413,163414,163415,163416,163405,163406,163407&FromDate=12/31/2017&ToDate=1/31/2018

            return(obj);
        }
Esempio n. 2
0
        public List <PM_Issues> GetProjectIssue(string filter, Int64 projectId, int Page, int Offset, string searchoption, string TaskIds = null, string LocationIds = null, DateTime?FromDate = null, DateTime?ToDate = null, string UserId = null)
        {
            DataSet          ds  = pd.GetDashboardWO(filter, projectId, 5, Offset, searchoption, TaskIds, LocationIds, FromDate, ToDate, UserId);
            DataTable        dt  = ds.Tables[0];
            List <PM_Issues> lst = new List <PM_Issues>();

            lst = dt.ToList <PM_Issues>();
            if (ds.Tables.Count == 2)
            {
                DataTable Count = ds.Tables[1];

                if (lst.Count != 0)
                {
                    lst.FirstOrDefault().Count = (!string.IsNullOrEmpty(Count.Rows[0]["Count"].ToString())) ? Convert.ToInt32(Count.Rows[0]["Count"].ToString()) : 0;
                }
            }
            //List<PM_Dashboard> list = new List<PM_Dashboard>();



            return(lst);
        }