public IEnumerable <WorkOrderInfoDomain> populatePONumberlist()
{
//string str_select =
//"select distinct a.PONumber "
//+ "from " + GlobalVar.WOGlobalPSDatabase + "WorkOrderInfo a "
//+ "inner join TS_WorkOrder b "
//+ "on b.WOID = a.WOID "
//+ "where a.PONumber is not null "
//+ "Order by a.PONumber ";
using (HMLVTSDb = new HMLVTSDB())
{
using (SIMAPS_MOMDb = new SIMAPS_MOM())
{
var one = HMLVTSDb.TS_WorkOrder.AsEnumerable();
var two = SIMAPS_MOMDb.WorkOrderInfoes.AsEnumerable();
var entity = (from a in one
join b in two on a.WOID equals b.WOID
where b.PONumber != null
orderby b.PONumber
select b).ToList();
return(entity.ToDomainModels());
}
}
}
public IEnumerable <WorkOrderMasterDomain> populateCustomerNamelist()
{
//string str_select =
// "select distinct a.Customer "
// + "from " + GlobalVar.WOGlobalPSDatabase + "WorkOrderMaster a "
// + "inner join TS_WorkOrder b "
// + "on b.WOID = a.ID "
// + "where a.Customer is not null "
// + "Order by a.Customer ";
using (HMLVTSDb = new HMLVTSDB())
{
using (SIMAPS_MOMDb = new SIMAPS_MOM())
{
//return entity.Student.Where(x => x.IsActive == true).ToList();
//string str_select = "Select * from Integration.WorkOrderMaster";
//var entity1 = HMLVTSDb.TS_WorkOrderExecution.Where(x => x.ParentWOID == null).ToList();
var one = HMLVTSDb.TS_WorkOrder.AsEnumerable();
var two = SIMAPS_MOMDb.WorkOrderMaster1.AsEnumerable();
var entity = (from a in one
join b in two on a.WOID equals b.ID
select b).ToList();
//var entity = HMLVTSDb.TS_WorkOrder.ToList();
//where a.Customer != null;
return(entity.ToDomainModels());
//var entity = from a in SIMAPS_MOMDb.Integration.WorkOrderMaster.;
// join b in HMLVTSDb.
// var entity = HMLVTSDb.TS_WorkOrder.SqlQuery(str_select).ToList();
//var entity = HMLVTSDb.TS_WorkOrder.ToList();
// return entity.ToDomainModels();
}
}
}
