public EntityBuildOfMaterial GetByBOMID(int PK_BuildOfMaterialsID)
{
var data = base.DataContext.BuildOfMaterials.Where(p => p.PK_BuildOfMaterialsID == PK_BuildOfMaterialsID);
if (data.Count() == 1)
{
return(FactoryBuildOfMaterial.Get(data.Single()));
}
else
{
return(null);
}
}
public EntityBuildOfMaterial GetMaterialBySparePart(string SparePart, int ProductID)
{
var data = base.DataContext.BuildOfMaterials.Where(p => p.SparePartsID == SparePart && p.FK_ProductID == ProductID).Take(1);
if (data.Count() == 1)
{
return(FactoryBuildOfMaterial.Get(data.Single()));
}
else
{
return(null);
}
}
public EntityBuildOfMaterial GetMaterialByModel(string Model)
{
var data = base.DataContext.BuildOfMaterials.Where(p => p.Model == Model);
if (data.Count() == 1)
{
return(FactoryBuildOfMaterial.Get(data.Single()));
}
else
{
return(null);
}
}
public List <EntityBuildOfMaterial> GetAllSparePartByModel(List <int> models)
{
this.DataContext.Database.CommandTimeout = 180;
return(FactoryBuildOfMaterial.GetList(base.DataContext.BuildOfMaterials.Where(p => models.Contains(p.FK_ProductID)).ToList()));
}
public List <EntityBuildOfMaterial> GetAllSparePart(List <string> SparePartsID)
{
this.DataContext.Database.CommandTimeout = 180;
return(FactoryBuildOfMaterial.GetList(base.DataContext.BuildOfMaterials.Where(p => SparePartsID.Contains(p.SparePartsID)).ToList()));
}
public List <EntityBuildOfMaterial> GetAll()
{
this.DataContext.Database.CommandTimeout = 180;
return(FactoryBuildOfMaterial.GetList(base.DataContext.BuildOfMaterials.ToList()));
}
public List <EntityBuildOfMaterial> GetActives()
{
return(FactoryBuildOfMaterial.GetList(base.DataContext.BuildOfMaterials.Where(p => p.Status == true).ToList()));
}
