public List <GETEquipmentListVM> getEquipmentListByJobsite(long jobsiteAuto, int User)
{
List <GETEquipmentListVM> result = new List <GETEquipmentListVM>();
if (jobsiteAuto == 0)
{
return(result);
}
using (var dataEntitiesShared = new DAL.SharedContext())
{
result = (from eqmt in dataEntitiesShared.EQUIPMENT
join lu_mmta in dataEntitiesShared.LU_MMTA
on eqmt.mmtaid_auto equals lu_mmta.mmtaid_auto
join model in dataEntitiesShared.MODEL
on lu_mmta.model_auto equals model.model_auto
join make in dataEntitiesShared.MAKE
on lu_mmta.make_auto equals make.make_auto
where eqmt.crsf_auto == jobsiteAuto
select new GETEquipmentListVM
{
equipmentid_auto = eqmt.equipmentid_auto,
serialno = eqmt.serialno,
unitno = eqmt.unitno,
model_auto = model.model_auto,
modeldesc = model.modeldesc,
makedesc = make.makedesc
}).ToList();
}
var accessible = new BLL.Core.Domain.UserAccess(new SharedContext(), User).getAccessibleEquipments().Select(m => m.equipmentid_auto);
return(result.Where(m => accessible.Any(k => k == m.equipmentid_auto)).ToList());
}
public List <GETEquipmentListVM> getEquipmentListByCustomer(long customerAuto, System.Security.Principal.IPrincipal User)
{
List <GETEquipmentListVM> result = new List <GETEquipmentListVM>();
if (customerAuto == 0)
{
return(result);
}
using (var dataEntitiesShared = new DAL.SharedContext())
{
result = (from eqmt in dataEntitiesShared.EQUIPMENT
join crsf in dataEntitiesShared.CRSF
on eqmt.crsf_auto equals crsf.crsf_auto
join customer in dataEntitiesShared.CUSTOMER
on crsf.customer_auto equals customer.customer_auto
join lu_mmta in dataEntitiesShared.LU_MMTA
on eqmt.mmtaid_auto equals lu_mmta.mmtaid_auto
join model in dataEntitiesShared.MODEL
on lu_mmta.model_auto equals model.model_auto
join make in dataEntitiesShared.MAKE
on lu_mmta.make_auto equals make.make_auto
where customer.customer_auto == customerAuto
select new GETEquipmentListVM
{
equipmentid_auto = eqmt.equipmentid_auto,
serialno = eqmt.serialno,
unitno = eqmt.unitno,
modeldesc = model.modeldesc,
makedesc = make.makedesc,
customer_auto = customer.customer_auto,
cust_name = customer.cust_name
}).ToList();
}
var accessible = new BLL.Core.Domain.UserAccess(new SharedContext(), User).getAccessibleEquipments().Select(m => m.equipmentid_auto);
return(result.Where(m => accessible.Any(k => k == m.equipmentid_auto)).ToList());
}