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