public int?Delete(int id) { ContractDetail e = Get(id); int?contractID = e.ContractID; var l = e.SiteMonitorings.ToList(); foreach (var item in l) { DB.DeleteObject(item); } var l1 = e.ContractDetailTimelines.ToList(); foreach (var item in l1) { DB.DeleteObject(item); } DB.DeleteObject(e); Save(); return(contractID); }
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 void Update(int ID, Action <ContractDetail> updateMethod) { ContractDetail e = Get(ID); updateMethod(e); //UpdateCategory(e); Save(); }
public SiteMonitoring Find(ContractDetail contractDetail, DateTime?from, DateTime?to) { SiteMonitoring sm = null; List <SiteMonitoring> lst = contractDetail.SiteMonitorings.Where( r => r.ContractDetail.ContractDetailTimelines.Where(rr => rr.Order == r.Order).ToList().Count > 0 && r.ContractDetail.ContractDetailTimelines.Where(rr => rr.Order == r.Order).ToList()[0].IsIn(from, to) ).ToList();// OrderByDescending(item => item.Order).First(); if (lst.Count > 0) { sm = lst.OrderByDescending(item => item.Order).First(); } return(sm); }
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.SiteDetailName = siteDetail.Name; DB.ContractDetails.AddObject(e); Save(); ContractDetailRepository contractDetailRepository = new ContractDetailRepository(); contractDetailRepository.CopyTimeline(e.ID); }
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); }
/// <summary> /// Deprecated Method for adding a new object to the ContractDetails EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToContractDetails(ContractDetail contractDetail) { base.AddObject("ContractDetails", contractDetail); }
/// <summary> /// Create a new ContractDetail object. /// </summary> /// <param name="id">Initial value of the ID property.</param> public static ContractDetail CreateContractDetail(global::System.Int32 id) { ContractDetail contractDetail = new ContractDetail(); contractDetail.ID = id; return contractDetail; }
public SiteMonitoring Find(ContractDetail contractDetail, DateTime? from, DateTime? to) { SiteMonitoring sm = null; List<SiteMonitoring> lst = contractDetail.SiteMonitorings.Where( r => r.ContractDetail.ContractDetailTimelines.Where(rr => rr.Order == r.Order).ToList().Count > 0 && r.ContractDetail.ContractDetailTimelines.Where(rr => rr.Order == r.Order).ToList()[0].IsIn(from, to) ).ToList();// OrderByDescending(item => item.Order).First(); if (lst.Count > 0) { sm = lst.OrderByDescending(item => item.Order).First(); } return sm; }