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