public AddServiceLogVM()
{
_search = String.Empty;
_parameter = System.Linq.Expressions.Expression.Parameter(typeof(Device), "d");
_filterSearch = new FilterSearch(_parameter);
_filters = new List <IFilter>();
_filters.Add(_filterSearch);
_filterSearch.FilterCreated += OnFilterChanged;
_date = DateTime.Now;
Devices = new ObservableCollection <Device>();
ParametersValues = new ObservableCollection <ParameterValue>();
Services = new ObservableCollection <ServiceForModel>();
Spares = new ObservableCollection <SpareForModel>();
Users = new ObservableCollection <Repairer>();
_selectedServices = new ObservableCollection <ServiceForModel>();
_selectedSpares = new ObservableCollection <SpareForModel>();
var sdbContext = SingletonDBContext.GetInstance(new SQLiteContext());
_dbContext = sdbContext.DBContext;
if (_dbContext is SQLiteContext)
{
SQLiteContext context = _dbContext as SQLiteContext;
context.Device.Load();
Devices = context.Device.Local.ToBindingList();
context.Repairer.Load();
Users = context.Repairer.Local.ToBindingList();
}
}
public AddStatusVM()
{
Name = String.Empty;
var sdbContext = SingletonDBContext.GetInstance(new SQLiteContext());
_dbContext = sdbContext.DBContext;
}
public EditDeviceVM(long rowid)
{
InventoryNumber = String.Empty;
SerialNumber = String.Empty;
Model = null;
Dept = null;
Status = null;
var sdbContext = SingletonDBContext.GetInstance(new SQLiteContext());
_dbContext = sdbContext.DBContext;
if (_dbContext is SQLiteContext)
{
var context = _dbContext as SQLiteContext;
context.Model.Load();
Models = context.Model.Local.ToBindingList();
context.Dept.Load();
Depts = context.Dept.Local.ToBindingList();
context.Status.Load();
Statuses = context.Status.Local.ToBindingList();
_device = context.Device.Where(d => d.Rowid == rowid).SingleOrDefault();
InventoryNumber = _device.InventoryNumber;
SerialNumber = _device.SerialNumber;
Model = _device.Model;
Dept = _device.Dept;
Status = _device.Status;
}
}
public AddSpareVM()
{
Name = String.Empty;
Description = String.Empty;
var sdbContext = SingletonDBContext.GetInstance(new SQLiteContext());
_dbContext = sdbContext.DBContext;
}
public AddTypeModelVM()
{
FullName = String.Empty;
ShortName = String.Empty;
var sdbContext = SingletonDBContext.GetInstance(new SQLiteContext());
_dbContext = sdbContext.DBContext;
}
public AddCategoryVM()
{
Name = String.Empty;
Range = String.Empty;
var sdbContext = SingletonDBContext.GetInstance(new SQLiteContext());
_dbContext = sdbContext.DBContext;
}
public AddUserVM()
{
Name = String.Empty;
Surname = String.Empty;
Midname = String.Empty;
var sdbContext = SingletonDBContext.GetInstance(new SQLiteContext());
_dbContext = sdbContext.DBContext;
}
public AddParameterVM()
{
Name = String.Empty;
Default = String.Empty;
Unit = String.Empty;
var sdbContext = SingletonDBContext.GetInstance(new SQLiteContext());
_dbContext = sdbContext.DBContext;
}
public AddServiceVM()
{
ShortName = String.Empty;
FullName = String.Empty;
Description = String.Empty;
var sdbContext = SingletonDBContext.GetInstance(new SQLiteContext());
_dbContext = sdbContext.DBContext;
}
private void InitializeData()
{
ServiceCategories = new ObservableCollection <SCView>();
_dbContext = SingletonDBContext.GetInstance(new SQLiteContext()).DBContext;
if (_dbContext is SQLiteContext)
{
SQLiteContext context = _dbContext as SQLiteContext;
context.ServiceCategory.Load();
var serviceCategoriesList = context.ServiceCategory.Local.ToBindingList();
ServiceCategoriesListCreator(serviceCategoriesList);
}
}
public EditServiceLogVM(long rowid)
{
ParametersValues = new ObservableCollection <ParameterValue>();
Services = new ObservableCollection <ServiceForModel>();
Spares = new ObservableCollection <SpareForModel>();
Users = new ObservableCollection <Repairer>();
OldServices = new ObservableCollection <ServiceForModel>();
OldSpares = new ObservableCollection <SpareForModel>();
NewSpare = false;
NewService = false;
_selectedServices = new ObservableCollection <ServiceForModel>();
_selectedSpares = new ObservableCollection <SpareForModel>();
_dbContext = SingletonDBContext.GetInstance(new SQLiteContext()).DBContext;
if (_dbContext is SQLiteContext)
{
SQLiteContext context = _dbContext as SQLiteContext;
_serviceLog = context.ServiceLog.Where(s => s.Rowid == rowid).SingleOrDefault();
//var parameters = context.ParameterForModel.Where(pfm => pfm.RowidModel == _serviceLog.Device.RowidModel).ToList();
//foreach (var item in parameters)
//{
// var pv = context.ServiceLog.Where(s => s.Device.Rowid == _serviceLog.Device.Rowid).ToList().LastOrDefault()?.ParametersValues.ToList().LastOrDefault();
// if (pv == null)
// {
// ParametersValues.Add(new ParameterValue() { RowidParameterForModel = item.Rowid, ParameterForModel = item, Value = item.Parameter.Default });
// }
// else
// {
// ParametersValues.Add(new ParameterValue() { RowidParameterForModel = item.Rowid, ParameterForModel = item, Value = pv.Value });
// }
//}
context.ParameterValue.Where(pv => pv.ServiceLog.Rowid == _serviceLog.Rowid).ToList().ForEach(item => ParametersValues.Add(item));
List <ParameterForModel> tempPFM = ParametersValues.Select(pv => pv.ParameterForModel).ToList();
var temp = context.ParameterForModel.Where(pfm => pfm.RowidModel == _serviceLog.Device.RowidModel).ToList();
temp = temp.Where(item => !tempPFM.Contains(item)).ToList();
if (temp != null)
{
temp.ForEach(item => ParametersValues.Add(new ParameterValue()
{
ParameterForModel = item
}));
}
context.ServiceForModel.Where(s => s.RowidModel == _serviceLog.Device.RowidModel).ToList().ForEach(item => Services.Add(item));
context.SpareForModel.Where(s => s.RowidModel == _serviceLog.Device.RowidModel).ToList().ForEach(item => Spares.Add(item));
context.Repairer.ToList().ForEach(item => Users.Add(item));
SelectedUser = _serviceLog.Repairer;
_serviceLog.SparesUsed.Select(su => su.SpareForModel).ToList().ForEach(item => OldSpares.Add(item));
_serviceLog.ServicesDone.Select(sd => sd.ServiceForModel).ToList().ForEach(item => OldServices.Add(item));
}
Date = _serviceLog.DateTime;
Title = String.Format("Изменить {0} I/N - \"{1}\" | S/N - \"{2}\"", _serviceLog.Device.Model.TypeModel.ShortName, _serviceLog.Device.InventoryNumber, _serviceLog.Device.SerialNumber);
}
public EditStatusVM(long rowid)
{
Name = String.Empty;
var sdbContext = SingletonDBContext.GetInstance(new SQLiteContext());
_dbContext = sdbContext.DBContext;
if (_dbContext is SQLiteContext)
{
SQLiteContext context = _dbContext as SQLiteContext;
_status = context.Status.Where(s => s.Rowid == rowid).SingleOrDefault();
Name = _status.Name;
}
}
private void InitializeData()
{
Parameters = new ObservableCollection <PView>();
SelectedModels = new ObservableCollection <Model>();
SelectedParameterForModels = new ObservableCollection <ParameterForModel>();
_dbContext = SingletonDBContext.GetInstance(new SQLiteContext()).DBContext;
if (_dbContext is SQLiteContext)
{
SQLiteContext context = _dbContext as SQLiteContext;
context.Parameter.Load();
var parametersList = context.Parameter.Local.ToBindingList();
ParametersListCreator(parametersList);
}
}
private IList <ServiceCategory> CalculateCategory(ServiceLog serviceLog)
{
List <ServiceCategory> serviceCategories = new List <ServiceCategory>();
long complexity = 0;
serviceLog.ServicesDone.ToList().ForEach(i => complexity += i.ServiceForModel.Service.Price);
DbContext dbContext = SingletonDBContext.GetInstance(new SQLiteContext()).DBContext;
if (dbContext is SQLiteContext)
{
var context = dbContext as SQLiteContext;
serviceCategories = context.ServiceCategory.ToList().FindAll(s => complexity >= s.MinValue && complexity <= s.MaxValue).ToList();
}
return(serviceCategories);
}
public AddModelVM()
{
FullName = String.Empty;
ShortName = String.Empty;
TypeModel = null;
var sdbContext = SingletonDBContext.GetInstance(new SQLiteContext());
_dbContext = sdbContext.DBContext;
if (_dbContext is SQLiteContext)
{
var context = _dbContext as SQLiteContext;
context.TypeModel.Load();
TypesModel = context.TypeModel.Local.ToBindingList();
}
}
public EditSpareVM(long rowid)
{
Name = String.Empty;
Description = String.Empty;
var sdbContext = SingletonDBContext.GetInstance(new SQLiteContext());
_dbContext = sdbContext.DBContext;
if (_dbContext is SQLiteContext)
{
var context = _dbContext as SQLiteContext;
_spare = context.Spare.Where(s => s.Rowid == rowid).SingleOrDefault();
Name = _spare.Name;
Description = _spare.Description;
}
}
public EditTypeModelVM(long rowid)
{
FullName = String.Empty;
ShortName = String.Empty;
var sdbContext = SingletonDBContext.GetInstance(new SQLiteContext());
_dbContext = sdbContext.DBContext;
if (_dbContext is SQLiteContext)
{
SQLiteContext context = _dbContext as SQLiteContext;
_typeModel = context.TypeModel.Where(t => t.Rowid == rowid).SingleOrDefault();
FullName = _typeModel.FullName;
ShortName = _typeModel.ShortName;
}
}
private void InitializeData()
{
_reservedStartDate = _startDate.Date;
_reservedEndDate = _endDate.Date;
AllTime = false;
FirstDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
SecondDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
Spares = new ObservableCollection <Spare>();
Services = new ObservableCollection <Service>();
Models = new ObservableCollection <Data.Entity.Model>();
TypesModel = new ObservableCollection <TypeModel>();
Depts = new ObservableCollection <Dept>();
Repairers = new ObservableCollection <Repairer>();
Statuses = new ObservableCollection <Status>();
ServiceLogs = new ObservableCollection <SView>();
ParametersValues = new ObservableCollection <ParameterValue>();
ServicesDone = new ObservableCollection <ServiceDone>();
SparesUsed = new ObservableCollection <SpareUsed>();
SelectedStatuses = new ObservableCollection <Status>();
SelectedRepairers = new ObservableCollection <Repairer>();
SelectedDepts = new ObservableCollection <Dept>();
SelectedTypesModel = new ObservableCollection <TypeModel>();
SelectedModels = new ObservableCollection <Data.Entity.Model>();
SelectedSpares = new ObservableCollection <Spare>();
SelectedServices = new ObservableCollection <Service>();
_dbContext = SingletonDBContext.GetInstance(new SQLiteContext()).DBContext;
if (_dbContext is SQLiteContext)
{
SQLiteContext context = _dbContext as SQLiteContext;
context.Status.Load();
Statuses = context.Status.Local.ToBindingList();
context.Repairer.Load();
Repairers = context.Repairer.Local.ToBindingList();
context.Dept.Load();
Depts = context.Dept.Local.ToBindingList();
context.TypeModel.Load();
TypesModel = context.TypeModel.Local.ToBindingList();
context.Model.Load();
Models = context.Model.Local.ToBindingList();
context.Service.Load();
Services = context.Service.Local.ToBindingList();
context.Spare.Load();
Spares = context.Spare.Local.ToBindingList();
}
OnFilterChanged();
}
public EditCategoryVM(long rowid)
{
Name = String.Empty;
Range = String.Empty;
var sdbContext = SingletonDBContext.GetInstance(new SQLiteContext());
_dbContext = sdbContext.DBContext;
if (_dbContext is SQLiteContext)
{
var context = _dbContext as SQLiteContext;
_serviceCategory = context.ServiceCategory.Where(s => s.Rowid == rowid).SingleOrDefault();
Name = _serviceCategory.Name;
Range = _serviceCategory.Range;
MinValue = _serviceCategory.MinValue;
MaxValue = _serviceCategory.MaxValue;
}
}
public EditParameterVM(long rowid)
{
Name = String.Empty;
Default = String.Empty;
Unit = String.Empty;
var sdbContext = SingletonDBContext.GetInstance(new SQLiteContext());
_dbContext = sdbContext.DBContext;
if (_dbContext is SQLiteContext)
{
var context = _dbContext as SQLiteContext;
_parameter = context.Parameter.Where(p => p.Rowid == rowid).SingleOrDefault();
Name = _parameter.Name;
Default = _parameter.Default;
Unit = _parameter.Unit;
}
}
public EditDeptVM(long rowid)
{
Name = String.Empty;
Code = String.Empty;
Description = String.Empty;
var sdbContext = SingletonDBContext.GetInstance(new SQLiteContext());
_dbContext = sdbContext.DBContext;
if (_dbContext is SQLiteContext)
{
SQLiteContext context = _dbContext as SQLiteContext;
_dept = context.Dept.Where(d => d.Rowid == rowid).SingleOrDefault();
Name = _dept.Name;
Code = _dept.Code;
Description = _dept.Description;
}
}
public EditServiceVM(long rowid)
{
ShortName = String.Empty;
FullName = String.Empty;
Description = String.Empty;
var sdbContext = SingletonDBContext.GetInstance(new SQLiteContext());
_dbContext = sdbContext.DBContext;
if (_dbContext is SQLiteContext)
{
var context = _dbContext as SQLiteContext;
_service = context.Service.Where(s => s.Rowid == rowid).SingleOrDefault();
ShortName = _service.ShortName;
FullName = _service.FullName;
Description = _service.Description;
Price = _service.Price;
}
}
private void InitializeData()
{
Users = new ObservableCollection <UView>();
SelectedModels = new ObservableCollection <Model>();
SelectedTypesModel = new ObservableCollection <TypeModel>();
_dbContext = SingletonDBContext.GetInstance(new SQLiteContext()).DBContext;
if (_dbContext is SQLiteContext)
{
SQLiteContext context = _dbContext as SQLiteContext;
context.Model.Load();
Models = context.Model.Local.ToBindingList();
context.TypeModel.Load();
TypesModel = context.TypeModel.Local.ToBindingList();
context.Repairer.Load();
var usersList = context.Repairer.Local.ToBindingList();
UsersListCreator(usersList, null);
}
}
private void InitializeData()
{
TypesModel = new ObservableCollection <TMView>();
SelectedDepts = new ObservableCollection <Dept>();
SelectedModels = new ObservableCollection <Model>();
_dbContext = SingletonDBContext.GetInstance(new SQLiteContext()).DBContext;
if (_dbContext is SQLiteContext)
{
SQLiteContext context = _dbContext as SQLiteContext;
context.Dept.Load();
Depts = context.Dept.Local.ToBindingList();
context.TypeModel.Load();
var typesModelList = context.TypeModel.Local.ToBindingList();
TypesModelListCreator(typesModelList, null, null);
context.Model.Load();
Models = context.Model.Local.ToBindingList();
}
}
public void InitializeData()
{
Spares = new ObservableCollection<SView>();
SelectedModels = new ObservableCollection<Model>();
SelectedSpareForModels = new ObservableCollection<SpareForModel>();
Models = null;
SpareForModels = null;
SelectedModel = null;
SelectedSpareForModel = null;
_dbContext = SingletonDBContext.GetInstance(new SQLiteContext()).DBContext;
if (_dbContext is SQLiteContext)
{
SQLiteContext context = _dbContext as SQLiteContext;
context.Spare.Load();
var sparesList = context.Spare.Local.ToBindingList();
SparesListCreator(sparesList);
}
}
public EditModelVM(long rowid)
{
FullName = String.Empty;
ShortName = String.Empty;
TypeModel = null;
var sdbContext = SingletonDBContext.GetInstance(new SQLiteContext());
_dbContext = sdbContext.DBContext;
if (_dbContext is SQLiteContext)
{
var context = _dbContext as SQLiteContext;
context.TypeModel.Load();
TypesModel = context.TypeModel.Local.ToBindingList();
_model = context.Model.Where(m => m.Rowid == rowid).SingleOrDefault();
FullName = _model.FullName;
ShortName = _model.ShortName;
TypeModel = _model.TypeModel;
}
}
public AddDeviceVM()
{
InventoryNumber = String.Empty;
SerialNumber = String.Empty;
Model = null;
Dept = null;
Status = null;
var sdbContext = SingletonDBContext.GetInstance(new SQLiteContext());
_dbContext = sdbContext.DBContext;
if (_dbContext is SQLiteContext)
{
var context = _dbContext as SQLiteContext;
context.Model.Load();
Models = context.Model.Local.ToBindingList();
context.Dept.Load();
Depts = context.Dept.Local.ToBindingList();
context.Status.Load();
Statuses = context.Status.Local.ToBindingList();
}
}
private void InitializeData()
{
Devices = new ObservableCollection <DView>();
SelectedDepts = new ObservableCollection <Dept>();
SelectedModels = new ObservableCollection <Model>();
SelectedTypesModel = new ObservableCollection <TypeModel>();
SelectedStatuses = new ObservableCollection <Status>();
_dbContext = SingletonDBContext.GetInstance(new SQLiteContext()).DBContext;
if (_dbContext is SQLiteContext)
{
SQLiteContext context = _dbContext as SQLiteContext;
context.Dept.Load();
Depts = context.Dept.Local.ToBindingList();
context.Model.Load();
Models = context.Model.Local.ToBindingList();
context.Model.Load();
TypesModel = context.TypeModel.Local.ToBindingList();
context.Status.Load();
Statuses = context.Status.Local.ToBindingList();
context.Device.Load();
var devicesList = context.Device.Local.ToBindingList();
DevicesListCreator(devicesList);
}
}
