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