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 <TS_WorkOrderExecutionMcIDDomain> populateMachineID() { //string str_select = "SELECT distinct McID " // + " FROM TS_WorkOrderExecution " // + "Where( McID is not null and McID <> '' ) " // + "order by McID "; using (HMLVTSDb = new HMLVTSDB()) { //return entity.Student.Where(x => x.IsActive == true).ToList(); var entity = HMLVTSDb.TS_WorkOrderExecution.Where(x => x.McID != null).ToList(); return(entity.ToDomainMcIDModels()); } }
public IEnumerable <TS_WorkOrderDomain> FindAll() { //using (TestDB = new CleanNexus.Repository.EntityFramework.DBContexts.TestDB()) //{ // var entity = TestDB.Students.Where(x => x.IsActive == true).ToList(); // return entity.ToDomainModels(); //} using (HMLVTSDb = new HMLVTSDB()) { //return entity.Student.Where(x => x.IsActive == true).ToList(); string str_select = "Select * from dbo.TS_WorkOrder"; var entity = HMLVTSDb.TS_WorkOrder.SqlQuery(str_select).ToList(); //var entity = HMLVTSDb.TS_WorkOrder.ToList(); return(entity.ToDomainModels()); } }
public IEnumerable <TS_WorkOrderExecutionDomain> populatePartIDlist() { //using (TestDB = new CleanNexus.Repository.EntityFramework.DBContexts.TestDB()) //{ // var entity = TestDB.Students.Where(x => x.IsActive == true).ToList(); // return entity.ToDomainModels(); //} using (HMLVTSDb = new HMLVTSDB()) { //return entity.Student.Where(x => x.IsActive == true).ToList(); //string str_select = "SELECT distinct PartID FROM TS_WorkOrderExecution Order by PartID "; string str_select = "Select * from dbo.TS_WorkOrderExecution"; var entity = HMLVTSDb.TS_WorkOrderExecution.SqlQuery(str_select).ToList(); //var entity = HMLVTSDb.TS_WorkOrder.ToList(); return(entity.ToDomainModels()); } }
public IEnumerable <TS_WorkOrderExecutionWorkCenterDomain> populateWorkCentre() { //using (TestDB = new CleanNexus.Repository.EntityFramework.DBContexts.TestDB()) //{ // var entity = TestDB.Students.Where(x => x.IsActive == true).ToList(); // return entity.ToDomainModels(); //} //"SELECT distinct WorkCenter FROM TS_WorkOrderExecution order by WorkCenter "; //string str_select = "SELECT distinct WorkCenter FROM dbo.TS_WorkOrderExecution"; using (HMLVTSDb = new HMLVTSDB()) { //return entity.Student.Where(x => x.IsActive == true).ToList(); //var entity = HMLVTSDb.TS_WorkOrderExecution.SqlQuery(str_select).ToList(); //var entity = HMLVTSDb.TS_WorkOrderExecution.Select(x=>x.WOID).Distinct().ToList(); var entity = HMLVTSDb.TS_WorkOrderExecution.ToList(); return(entity.ToDomainWorkCentreModels()); // return entity.ToDomainWorkCentreModels(); } }
public IEnumerable <TS_WorkOrderExecutionWODomain> populateWOlist() { //string str_select = "SELECT distinct WOID FROM TS_WorkOrderExecution " //+ "WHERE ParentWOID IS NULL " //+ "OR EXISTS (select ParentWOID " //+ "FROM TS_WorkOrderExecution " //+ "WHERE WOID = ParentWOID) Order by WOID "; + "order by McID "; using (HMLVTSDb = new HMLVTSDB()) { //return entity.Student.Where(x => x.IsActive == true).ToList(); //Workflows.Where(w => w.Activities.Any(a => a.Title == "xyz")) // var entity = HMLVTSDb.TS_WorkOrderExecution.Where(x => x.ParentWOID == null || x.ParentWOID.Any(w => x.WOID == x.ParentWOID)).ToList();// to do //var entity1 = HMLVTSDb.TS_WorkOrderExecution.Where(x => x.ParentWOID.Any(w=>x.WOID == x.ParentWOID)).ToList(); var entity = HMLVTSDb.TS_WorkOrderExecution .Where(x => x.ParentWOID == null) .ToList();// to do return(entity.ToDomainMOModels()); } }
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(); } } }