public void AddSite(int contractID, int siteDetailID) { var siteDetailRepo = new SiteDetailRepository() { DB = DB }; var siteDetail = siteDetailRepo.Get(siteDetailID); ContractDetail e = new ContractDetail(); e.ContractID = contractID; e.SiteID = siteDetail.SiteID; e.Format = siteDetail.Format; e.Type = siteDetail.Type; e.Height = siteDetail.Height; e.Width = siteDetail.Width; e.SiteDetailName = siteDetail.Name; DB.ContractDetails.AddObject(e); Save(); ContractDetailRepository contractDetailRepository = new ContractDetailRepository(); contractDetailRepository.CopyTimeline(e.ID); }
public SiteMonitoring Create(Action <SiteMonitoring> updateMethod, IEnumerable <HttpPostedFileBase> files, int?contractDetailID, string[] noteList) { var contractDetailRepository = new ContractDetailRepository() { DB = DB }; var contractDetail = contractDetailRepository.Get(contractDetailID.Value); SiteMonitoring e = new SiteMonitoring(); updateMethod(e); e.ContractDetail = contractDetail; Save(); PicasaRepository picasaRepository = new PicasaRepository(); picasaRepository.DB = DB; picasaRepository.UploadPhoto(e, files, noteList, false); Save(); return(e); }
public ContractDetail DeleteTheLastTimeline(int contractDetailID) { ContractDetailRepository contractDetailRepo = new ContractDetailRepository() { DB = DB }; var r = contractDetailRepo.Get(contractDetailID); var lastTimeline = r.ContractDetailTimelines.OrderByDescending(r1 => r1.Order).FirstOrDefault(); if (lastTimeline != null) { if (r.SiteMonitorings.Where(r1 => r1.Order == lastTimeline.Order).Count() == 0) { DB.DeleteObject(lastTimeline); Save(); } } return(r); }
public ContractDetailTimeline Add(int contractDetailID, int timeCount, string timeUnit) { timeCount = timeCount < 1 ? 1 : timeCount; ContractDetailRepository contractDetailRepo = new ContractDetailRepository() { DB = DB }; var contractDetail = contractDetailRepo.Get(contractDetailID); var lastTimeline = contractDetail.ContractDetailTimelines.OrderByDescending(r => r.Order).FirstOrDefault(); var newTimeline = new ContractDetailTimeline(); if (lastTimeline == null) { newTimeline.Order = 1; newTimeline.FromDate = contractDetail.EffectiveDate.HasValue ? contractDetail.EffectiveDate : DateTime.Now.Date; } else { newTimeline.Order = lastTimeline.Order + 1; newTimeline.FromDate = lastTimeline.ToDate.Value.AddDays(1); } if (timeUnit.ToLower() == "day") { newTimeline.ToDate = newTimeline.FromDate.Value.AddDays(timeCount).AddDays(-1); } else if (timeUnit.ToLower() == "month") { newTimeline.ToDate = newTimeline.FromDate.Value.AddMonths(timeCount).AddDays(-1); } newTimeline.ContractDetailID = contractDetailID; DB.AddToContractDetailTimelines(newTimeline); Save(); return(newTimeline); }
public SiteMonitoring InitWithDefaultValue(int?ContractDetailID) { SiteMonitoring e = new SiteMonitoring(); e.ContractDetailID = ContractDetailID; e.Working = true; e.Clean = true; e.CreativeGoodConditon = true; e.ExternalInterference = false; e.Vandalism = false; ContractDetailRepository cdrepo = new ContractDetailRepository(); ContractDetail cd = cdrepo.Get(ContractDetailID.ToInt()); e.ContractDetail = cd; e.NoOfBullbs = cd.Site.FrontlitNumerOfLamps; e.Site = cd.Site; e.ProductID = cd.ProductID; e.Product = cd.Product; return(e); }
public IEnumerable <SelectListItem> FilterOrderForCreate(int contractDetailID) { ContractDetailRepository contractDetailRepository = new ContractDetailRepository(); SiteMonitoringRepository siteMonitoringRepository = new SiteMonitoringRepository(); var contractDetail = contractDetailRepository.Get(contractDetailID); var orderList = contractDetail.SiteMonitorings.Select(r => r.Order).Distinct(); var timelineList = contractDetail.ContractDetailTimelines .ToList() .Where(r => !orderList.Contains(r.Order)) .OrderBy(r => r.Order) .Select(r => new SelectListItem() { Value = r.Order.ToString(), Text = string.Format("{0}: {1} - {2}", r.Order, String.Format("{0:d}", r.FromDate), String.Format("{0:d}", r.ToDate)) }); ; return(timelineList); }