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;
}
