public Rpt01_Model_SiteMonitoring Report(int contractID, DateTime?from, DateTime?to)
        {
            SiteMonitoringRepository   siteMonitoringRepository = new SiteMonitoringRepository();
            Rpt01_Model_SiteMonitoring rpt = new Rpt01_Model_SiteMonitoring();

            rpt.From    = from;
            rpt.To      = to;
            rpt.Details = new List <Rpt01_Model_SiteMonitoringDetail>();

            var contract = Get(contractID);

            if (contract != null)
            {
                int index = 1;

                foreach (OAMS.Models.ContractDetail cd in contract.ContractDetails.OrderBy(r => r.Type))
                {
                    Rpt01_Model_SiteMonitoringDetail detail = new Rpt01_Model_SiteMonitoringDetail();

                    DateTime?lastDate = null;

                    SiteMonitoring sm = siteMonitoringRepository.Find(cd, from, to);
                    sm = sm ?? new SiteMonitoring();

                    lastDate = sm.SiteMonitoringPhotoes
                               .OrderByDescending(r => r.TakenDate)
                               .Select(r => r.TakenDate)
                               .FirstOrDefault();

                    detail.ID                   = index;
                    detail.SiteCode             = cd.Site.Code;
                    detail.Supplier             = contract.Contractor != null ? contract.ContractorName : cd.Site.ContractorName;
                    detail.Province             = cd.Site.Geo1 != null ? cd.Site.Geo1.FullName : "";
                    detail.District             = cd.Site.Geo2 != null ? cd.Site.Geo2.Name : "";
                    detail.Street               = string.Format("{0} {1} {2}", cd.Site.AddressLine1, cd.Site.AddressLine2, cd.Site.Geo3 == null ? "" : cd.Site.Geo3.Name);
                    detail.Size                 = string.Format("{0}m x {1}m", cd.Width.ToString(), cd.Height.ToString());
                    detail.Product              = sm.Product == null ? "" : sm.Product.Name;
                    detail.Client               = sm.Product == null ? "" : sm.Product.NewClientName;
                    detail.SiteType             = cd.Type;
                    detail.CurrentCreative      = sm.CurrentCreative;
                    detail.SiteFormat           = cd.Format;
                    detail.SiteScore            = cd.Site.Score;
                    detail.LastestPhotoDate     = lastDate;
                    detail.BackFront            = cd.Site.BacklitFormat != null ? "Backlit" : "Frontlit";
                    detail.Working              = sm.Working;
                    detail.NumOfBulbs           = sm.NoOfBullbs;
                    detail.BulbsWorking         = sm.BullsWorking;
                    detail.Issue                = sm.Issues;
                    detail.Clean                = sm.Clean;
                    detail.CreativeGoodConditon = sm.CreativeGoodConditon;
                    detail.ExternalInterference = sm.ExternalInterference;
                    detail.Vandalism            = sm.Vandalism;
                    detail.Comments             = sm.Comments;
                    detail.RequiredFollowUp     = sm.RequiredFollowUp;
                    detail.Action               = sm.Action;
                    detail.DateOfProblem        = sm.DateOfProblem;
                    detail.NowFixed             = sm.NowFixed;

                    index++;
                    if (sm.Working.HasValue && sm.Working.Value)
                    {
                        rpt.TotalWorking++;
                    }
                    if (sm.Issues != null)
                    {
                        rpt.TotalIssues++;
                    }
                    if (sm.Clean.HasValue && sm.Clean.Value)
                    {
                        rpt.TotalClean++;
                    }
                    if (sm.CreativeGoodConditon.HasValue && sm.CreativeGoodConditon.Value)
                    {
                        rpt.TotalCreativeGoodCondition++;
                    }
                    if (sm.ExternalInterference.HasValue && sm.ExternalInterference.Value)
                    {
                        rpt.TotalExternnalInterference++;
                    }
                    if (sm.Vandalism.HasValue && sm.Vandalism.Value)
                    {
                        rpt.TotalVandalism++;
                    }
                    if (sm.RequiredFollowUp.HasValue && sm.RequiredFollowUp.Value)
                    {
                        rpt.TotalRequiredFollowUp++;
                    }
                    if (sm.NowFixed.HasValue && sm.NowFixed.Value)
                    {
                        rpt.TotalNowFixed++;
                    }

                    rpt.Details.Add(detail);
                }
            }

            return(rpt);
        }
Example #2
0
        public Rpt01_Model_SiteMonitoring Report(int contractID, DateTime? from, DateTime? to)
        {
            SiteMonitoringRepository siteMonitoringRepository = new SiteMonitoringRepository();
            Rpt01_Model_SiteMonitoring rpt = new Rpt01_Model_SiteMonitoring();
            rpt.From = from;
            rpt.To = to;
            rpt.Details = new List<Rpt01_Model_SiteMonitoringDetail>();

            var contract = Get(contractID);
            if (contract != null)
            {
                int index = 1;

                foreach (OAMS.Models.ContractDetail cd in contract.ContractDetails.OrderBy(r => r.Site.Type))
                {
                    Rpt01_Model_SiteMonitoringDetail detail = new Rpt01_Model_SiteMonitoringDetail();

                    DateTime? lastDate = null;

                    SiteMonitoring sm = siteMonitoringRepository.Find(cd, from, to);
                    sm = sm ?? new SiteMonitoring();

                    lastDate = sm.SiteMonitoringPhotoes
                        .OrderByDescending(r => r.TakenDate)
                        .Select(r => r.TakenDate)
                        .FirstOrDefault();

                    detail.ID = index;
                    detail.SiteCode = cd.Site.Code;
                    detail.Supplier = contract.Contractor != null ? contract.ContractorName : cd.Site.ContractorName;
                    detail.Province = cd.Site.Geo1 != null ? cd.Site.Geo1.FullName : "";
                    detail.District = cd.Site.Geo2 != null ? cd.Site.Geo2.Name : "";
                    detail.Street = string.Format("{0} {1} {2}", cd.Site.AddressLine1, cd.Site.AddressLine2, cd.Site.Geo3 == null ? "" : cd.Site.Geo3.Name);
                    detail.Size = string.Format("{0}m x {1}m", cd.Site.Width.ToString(), cd.Site.Height.ToString());
                    detail.Product = sm.Product == null ? "" : sm.Product.Name;
                    detail.Client = sm.Product == null ? "" : sm.Product.NewClientName;
                    detail.SiteType = cd.Site.Type;
                    detail.SiteFormat = cd.Format;
                    detail.LastestPhotoDate = lastDate;
                    detail.BackFront = cd.Site.BacklitFormat != null ? "Backlit" : "Frontlit";
                    detail.Working = sm.Working;
                    detail.NumOfBulbs = sm.NoOfBullbs;
                    detail.BulbsWorking = sm.BullsWorking;
                    detail.Issue = sm.Issues;
                    detail.Clean = sm.Clean;
                    detail.CreativeGoodConditon = sm.CreativeGoodConditon;
                    detail.ExternalInterference = sm.ExternalInterference;
                    detail.Vandalism = sm.Vandalism;
                    detail.Comments = sm.Comments;
                    detail.RequiredFollowUp = sm.RequiredFollowUp;
                    detail.Action = sm.Action;
                    detail.DateOfProblem = sm.DateOfProblem;
                    detail.NowFixed = sm.NowFixed;

                    index++;
                    if (sm.Working.HasValue && sm.Working.Value) rpt.TotalWorking++;
                    if (sm.Issues != null) rpt.TotalIssues++;
                    if (sm.Clean.HasValue && sm.Clean.Value) rpt.TotalClean++;
                    if (sm.CreativeGoodConditon.HasValue && sm.CreativeGoodConditon.Value) rpt.TotalCreativeGoodCondition++;
                    if (sm.ExternalInterference.HasValue && sm.ExternalInterference.Value) rpt.TotalExternnalInterference++;
                    if (sm.Vandalism.HasValue && sm.Vandalism.Value) rpt.TotalVandalism++;
                    if (sm.RequiredFollowUp.HasValue && sm.RequiredFollowUp.Value) rpt.TotalRequiredFollowUp++;
                    if (sm.NowFixed.HasValue && sm.NowFixed.Value) rpt.TotalNowFixed++;

                    rpt.Details.Add(detail);
                }
            }

            return rpt;
        }