public static ObjectWorksModel GetObjectWorkModel()
{
//
var filterTable = new Database.FiltersEntities().Filters
.ToList()
.Where(x => x.user_id == MySession.Current.UserGuid)
.Where(x => x.table_name_id == (int)FilterTableName.ObjectWorks)
.ToList();
var objectWorksList = new Database.WorksEntities().Works
.Where(x => x.object_id == MySession.Current.ObjectId).ToList();
foreach (var item in filterTable)
{
switch (item.operation_id)
{
case (int)Operations.Equal:
objectWorksList = objectWorksList
.Where(x => x.date_start == MyConvert.ToDateTime(item.compare_value))
.ToList();
break;
case (int)Operations.Bigger:
objectWorksList = objectWorksList
.Where(x => x.date_start >= MyConvert.ToDateTime(item.compare_value))
.ToList();
break;
case (int)Operations.Smaller:
objectWorksList = objectWorksList
.Where(x => x.date_start <= MyConvert.ToDateTime(item.compare_value))
.ToList();
break;
}
}
var objectWorksModel = new ObjectWorksModel
{
//
ObjectList = Object.GetObjectsByParentId(),
//
UnitList = new Database.ExcelentConstructUnit().Units.ToList(),
//
WorkerList = new Database.ExcelentConstructWorkers()
.Workers.ToList().Where(x => x.UserId == MySession.Current.UserGuid).ToList(),
ObjectWorksList = objectWorksList,
WorkersGroupList = Worker.WorkersGroups.GetWorkersGroupsModel().WorkersGroupList
};
return(objectWorksModel);
}
public static ObjectExtraModel GetObjectExtraModel()
{
var objectExtraModel = new ObjectExtraModel();
objectExtraModel.ObjectList = Object.GetObjectsByParentId();
//
objectExtraModel.WorkerList = BusinessLogic.Worker.Worker.GetWorkerList();
//
var objectExtraList = new Database.ExcelentConstructObjectExtras().ObjectExtras.ToList()
.Where(x => x.object_id == MySession.Current.ObjectId).ToList();
//
var filterTable = new Database.FiltersEntities().Filters
.ToList()
.Where(x => x.user_id == MySession.Current.UserGuid)
.Where(x => x.table_name_id == (int)FilterTableName.ObjectExtra).ToList();
//
foreach (var item in filterTable)
{
switch (item.operation_id)
{
case (int)Operations.Equal:
objectExtraList = objectExtraList
.Where(x => x.create_date == MyConvert.ToDateTime(item.compare_value))
.ToList();
break;
case (int)Operations.Bigger:
objectExtraList = objectExtraList
.Where(x => x.create_date >= MyConvert.ToDateTime(item.compare_value))
.ToList();
break;
case (int)Operations.Smaller:
objectExtraList = objectExtraList
.Where(x => x.create_date <= MyConvert.ToDateTime(item.compare_value))
.ToList();
break;
}
}
objectExtraModel.ObjectExtraList = objectExtraList;
//
return(objectExtraModel);
}
public static ObjectInstrumentModel GetObjectInstrumentModel()
{
var objectInstrumentList = new Database.ExcelentConstructObjectInstruments().ObjectInstruments.ToList()
.Where(x => x.object_id == MySession.Current.ObjectId).ToList();
//
var filterTable = new Database.FiltersEntities().Filters
.ToList()
.Where(x => x.user_id == MySession.Current.UserGuid)
.Where(x => x.table_name_id == (int)FilterTableName.ObjectInstruments).ToList();
//
foreach (var item in filterTable)
{
switch (item.operation_id)
{
case (int)Operations.Equal:
break;
case (int)Operations.Bigger:
objectInstrumentList = objectInstrumentList
.Where(x => x.first_day >= MyConvert.ToDateTime(item.compare_value))
.ToList();
break;
case (int)Operations.Smaller:
objectInstrumentList = objectInstrumentList
.Where(x => x.first_day <= MyConvert.ToDateTime(item.compare_value))
.ToList();
break;
}
}
var objectInstrumentModel = new ObjectInstrumentModel
{
ObjectList = Object.GetObjectsByParentId(),
WorkerList = Worker.Worker.GetWorkerList(),
ObjectInstrumentList = objectInstrumentList
};
return(objectInstrumentModel);
}
public static ObjectMaterialModel GetObjectMaterialModel()
{
var objectMaterialList = new Database.ExcelentConstructObjectMaterial().ObjectMaterials
.AsQueryable()
.Where(x => x.object_id == MySession.Current.ObjectId).ToList();
//Find into filter table
var filterTable = new Database.FiltersEntities().Filters
.ToList()
.Where(x => x.user_id == MySession.Current.UserGuid)
.Where(x => x.table_name_id == (int)FilterTableName.ObjectMaterial).ToList();
foreach (var item in filterTable)
{
switch (item.operation_id)
{
case (int)Operations.Bigger:
objectMaterialList = objectMaterialList
.Where(x => x.buyed_date >= MyConvert.ToDateTime(item.compare_value))
.ToList();
break;
case (int)Operations.Smaller:
objectMaterialList = objectMaterialList
.Where(x => x.buyed_date <= MyConvert.ToDateTime(item.compare_value))
.ToList();
break;
}
}
var objectMaterialModel = new ObjectMaterialModel
{
ObjectList = Object.GetObjectsByParentId(),
ObjectMaterialList = objectMaterialList,
UnitList = new Database.ExcelentConstructUnit().Units.ToList()
};
return(objectMaterialModel);
}
