public AddEditInstrumentComponentTypeViewModel(InstrumentComponentType mct)
        {
            mInstrumentComponentType = mct;

            OkButtonCommand = new DelegateCommand<object>(OkButtonHander, CanModifyConfig);
            CancelButtonCommand = new DelegateCommand<object>(CancelButtonHander, x => true);
        }
 public AddEditInstrumentComponentTypeDialog()
 {
     InitializeComponent();
     mInstrumentComponentType = new InstrumentComponentType();
     model = new AddEditInstrumentComponentTypeViewModel(mInstrumentComponentType);
     model.View = this;
     DataContext = model;
     Utils.ResetOriginalValues(this);
 }
        public AddEditExistingInstrumentComponentPropertyDialog(InstrumentComponentType pcpt)
        {
            InitializeComponent();

            AddEditExistingInstrumentComponentPropertyViewModel model =
                new AddEditExistingInstrumentComponentPropertyViewModel(pcpt);
            model.Loaded +=
                () =>
                {
                    model.View = this;
                    DataContext = model;
                    Utils.ResetOriginalValues(this);
                };
        }
예제 #4
0
        public DbOperationResult<InstrumentComponentType> AddInstrumentComponentType(InstrumentComponentType instrumentComponentType)
        {
            DbOperationResult<InstrumentComponentType> result = new DbOperationResult<InstrumentComponentType>();

            try
            {
                InstrumentComponentType newMect = new InstrumentComponentType();

                using (CmsEntities cee = new CmsEntities())
                {
                    //Check if this component type already exist
                    InstrumentComponentType componentType = (from x in cee.InstrumentComponentTypes
                                                             where x.Id == instrumentComponentType.Id
                                                             select x).FirstOrDefault();

                    if (componentType != null)
                    {

                        //Add new Component Type
                        int nameCount = (from x in cee.InstrumentComponentTypes where x.Name.ToLower() == instrumentComponentType.Name.ToLower()  && x.Id!= instrumentComponentType.Id select x.Id).Count();
                        if (nameCount > 0)
                        {
                            throw new Exception(string.Format("The Instrument Component Type with Name '{0}' already exists.", instrumentComponentType.Name));
                        }

                        int codeCount = (from x in cee.InstrumentComponentTypes where x.Code.ToLower() == instrumentComponentType.Code.ToLower() && x.Id!= instrumentComponentType.Id select x.Id).Count();
                        if (codeCount > 0)
                        {
                            throw new Exception(string.Format("The Instrument Component Type with Code '{0}' already exists.", instrumentComponentType.Code));
                        }

                        //Edit the Component Type
                        componentType.Name = instrumentComponentType.Name;
                        componentType.Description = instrumentComponentType.Description;
                        componentType.Ordinal = instrumentComponentType.Ordinal;
                        cee.SaveChanges();
                    }
                    else
                    {
                        //Add new Component Type
                        int nameCount = (from x in cee.InstrumentComponentTypes where x.Name.ToLower() == instrumentComponentType.Name.ToLower() select x.Id).Count();
                        if (nameCount > 0)
                        {
                            throw new Exception(string.Format("The Instrument Component Type with Name '{0}' already exists.", instrumentComponentType.Name));
                        }

                        int codeCount = (from x in cee.InstrumentComponentTypes where x.Code.ToLower() == instrumentComponentType.Code.ToLower() select x.Id).Count();
                        if (codeCount > 0)
                        {
                            throw new Exception(string.Format("The Instrument Component Type with Code '{0}' already exists.", instrumentComponentType.Code));
                        }

                        componentType = new InstrumentComponentType();
                        componentType.Name = instrumentComponentType.Name;
                        componentType.Description = instrumentComponentType.Description;
                        componentType.Code = instrumentComponentType.Name.Replace(" ", "");
                        componentType.IsActive = true;
                        cee.InstrumentComponentTypes.Add(componentType);
                        cee.SaveChanges();
                    }

                    newMect.Id = componentType.Id;
                    newMect.Name = componentType.Name;
                    newMect.Description = componentType.Description;
                    newMect.Ordinal = componentType.Ordinal;
                    newMect.Code = componentType.Code;

                    result.EntityResult = newMect;
                    return result;
                }
            }
            catch (Exception ex)
            {
                result = BuildOperationalErrorResults<InstrumentComponentType>(ex);
                return result;
            }
        }
        private void LoadData()
        {
            var getInstrumentTypesTask = DatabaseLoader.GetInstrumentTypes();
            var pidDocumentsTask = DatabaseLoader.GetQuickDocuments(CommonUtils.DoctypePidCode);
            var specificationDocumentsTask = DatabaseLoader.GetQuickDocuments(CommonUtils.DoctypeFuncspecCode);
            var getInstrumentComponentTypesTask = DatabaseLoader.GetInstrumentComponentTypes();
            var getManufacturersTask = DatabaseLoader.GetManufacturers(CommonUtils.EquipmentTypeCode.INSTR);
            var getModelsTask = DatabaseLoader.GetModels(CommonUtils.EquipmentTypeCode.INSTR);

            List<Task> tasks = new List<Task>();
            tasks.Add(getInstrumentTypesTask);
            tasks.Add(pidDocumentsTask);
            tasks.Add(specificationDocumentsTask);
            tasks.Add(getInstrumentComponentTypesTask);
            tasks.Add(getManufacturersTask);

            Task.Factory.ContinueWhenAll(tasks.ToArray(), x =>
            {
                CMS.UiFactory.StartNew(() =>
                {
                    //EquipmentType
                    var allItem = new InstrumentType { Id = -1, Name = All };
                    EquipmentTypes = getInstrumentTypesTask.Result;
                    EquipmentTypes.Insert(0, allItem);
                    mSelectedEquipmentType = EquipmentTypes[0];

                    //Pid Documents
                    PandIDDocuments = pidDocumentsTask.Result;
                    PandIDDocuments.Insert(0, new QuickDocument { Id = -1, Name = All });
                    mSelectedPAndIdDocument = PandIDDocuments[0];

                    //Component Types
                    ComponentTypes = getInstrumentComponentTypesTask.Result;
                    ComponentTypes.Insert(0, new InstrumentComponentType { Id = -1, Name = All });
                    mSelectedComponentType = ComponentTypes[0];

                    //Specification Documents
                    SpecificationDocuments = specificationDocumentsTask.Result;
                    SpecificationDocuments.Insert(0, new QuickDocument { Id = -1, Name = All });
                    mSelectedSpecificationDocument = SpecificationDocuments[0];

                    //Classified
                    Classifieds = new List<String> { All, Yes, No };
                    mSelectedClassified = Classifieds[0];

                    //Classified
                    IsActiveChoices = new List<String> { All, Yes, No };
                    mSelectedIsActive = IsActiveChoices[0];

                    //Model
                    mModelsCache = getModelsTask.Result;

                    //Manufacturer
                    Manufacturers = getManufacturersTask.Result;
                    Manufacturers.Insert(0, new Manufacturer { Id = -1, Name = All });
                    SelectedManufacturer = Manufacturers[0];

                    ProcessSearchFilter();
                    AllDataLoadedAction();
                });
            });

            LoadAreas();
            LoadSubAreas();
        }
        private bool GetInstrumentComponentType(string typeName, InstrumentComponent component, int rowIndex)
        {
            InstrumentComponentType componentType = (from x in mExistingComponentTypes
                                                     where string.Compare(typeName, x.Name, true, CultureInfo.CurrentCulture) == 0
                                                           && !string.IsNullOrEmpty(x.Name)
                                                     select x).FirstOrDefault();

            if (componentType != null)
            {
                component.InstrumentComponentType = componentType;
                component.InstrumentComponentTypeId = componentType.Id;
            }
            else
            {
                if (CanCreateProperties)
                {
                    string code = typeName.Replace(" ", "_").ToUpper();
                    componentType = new InstrumentComponentType { Name = typeName, Code = code, Description = typeName + " (created by importer)", IsActive = true };
                    mExistingComponentTypes.Add(componentType);
                    component.InstrumentComponentType = componentType;
                }
                else
                {
                    RaiseMessage(CommonUtils.MessageType.Error, string.Format("WorkSheet '{0}' Line '{1}': Could not find InstrumentComponentType '{2}' in database. Skipping this row.", WorkSheetName, rowIndex, typeName));
                    return true;
                }
            }

            return false;
        }
        private void SetControlValuesFromSearchFilterList(SearchFilterList searchFilterList)
        {
            mSearchFilterControl.SetFilterIsOn(true);
            ClearControls();

            //1. Manufacturer
            SearchFilter manufactuerFilter = (from x in searchFilterList.SearchFilters where x.Name.Equals(CommonUtils.InstrumentSearchFilterNames.Manufacturer.ToString(), StringComparison.CurrentCultureIgnoreCase) select x).FirstOrDefault();
            if (manufactuerFilter != null)
            {
                int result;
                if (int.TryParse(manufactuerFilter.Value, out result))
                {
                    Manufacturer match = (from x in Manufacturers where x.Id == result select x).FirstOrDefault();
                    mSelectedManufacturer = match;
                    RaisePropertyChanged("SelectedManufacturer");
                }
            }

            //2. Model
            SearchFilter modelFilter = (from x in searchFilterList.SearchFilters where x.Name.Equals(CommonUtils.InstrumentSearchFilterNames.Model.ToString(), StringComparison.CurrentCultureIgnoreCase) select x).FirstOrDefault();
            if (modelFilter != null)
            {
                int result;
                if (int.TryParse(modelFilter.Value, out result))
                {
                    Model match = (from x in mModelsCache where x.Id == result select x).FirstOrDefault();
                    mSelectedModel = match;
                    RaisePropertyChanged("SelectedModel");
                }
            }

            //1. Area
            SearchFilter areaFilter = (from x in searchFilterList.SearchFilters where x.Name.Equals(CommonUtils.InstrumentSearchFilterNames.Area.ToString(), StringComparison.CurrentCultureIgnoreCase) select x).FirstOrDefault();
            if (areaFilter != null)
            {
                int result;
                if (int.TryParse(areaFilter.Value, out result))
                {
                    Area match = (from x in Areas where x.Id == result select x).FirstOrDefault();
                    mSelectedArea = match;
                    RaisePropertyChanged("SelectedArea");
                }
            }

            //2. SubArea
            SearchFilter subareaFilter = (from x in searchFilterList.SearchFilters where x.Name.Equals(CommonUtils.InstrumentSearchFilterNames.SubArea.ToString(), StringComparison.CurrentCultureIgnoreCase) select x).FirstOrDefault();
            if (subareaFilter != null)
            {
                int result;
                if (int.TryParse(subareaFilter.Value, out result))
                {
                    Cell match = (from x in SubAreas where x.Id == result select x).FirstOrDefault();
                    mSelectedSubArea = match;
                    RaisePropertyChanged("SelectedSubArea");
                }
            }

            foreach (SearchFilter filter in searchFilterList.SearchFilters)
            {
                if (!string.IsNullOrEmpty(filter.Value))
                {
                    //KeyWords
                    if (filter.Name.Equals(CommonUtils.InstrumentSearchFilterNames.KeyWord.ToString(), StringComparison.CurrentCultureIgnoreCase))
                    {
                        mKeyword = filter.Value;
                        RaisePropertyChanged("Keyword");
                    }

                    //KeyWords
                    if (filter.Name.Equals(CommonUtils.InstrumentSearchFilterNames.MaintSystemId.ToString(), StringComparison.CurrentCultureIgnoreCase))
                    {
                        mMainSystId = filter.Value;
                        RaisePropertyChanged("MainSystId");
                    }

                    //Classified
                    if (filter.Name.Equals(CommonUtils.InstrumentSearchFilterNames.Classified.ToString(), StringComparison.CurrentCultureIgnoreCase))
                    {
                        //For compatibility as previously it was saved as Id
                        if (filter.Value == "-1") filter.Value = All;
                        if (filter.Value == "-2") filter.Value = Yes;
                        if (filter.Value == "-3") filter.Value = No;

                        var match = (from x in Classifieds where x == filter.Value select x).FirstOrDefault();
                        mSelectedClassified = match;
                        RaisePropertyChanged("Classified");
                    }

                    //Type
                    if (filter.Name.Equals(CommonUtils.InstrumentSearchFilterNames.Type.ToString(), StringComparison.CurrentCultureIgnoreCase))
                    {
                        int result;
                        if (int.TryParse(filter.Value, out result))
                        {
                            InstrumentType match = (from x in EquipmentTypes where x.Id == result select x).FirstOrDefault();
                            mSelectedEquipmentType = match;
                            RaisePropertyChanged("SelectedEquipmentType");
                        }
                    }

                    //ComponentType
                    if (filter.Name.Equals(CommonUtils.InstrumentSearchFilterNames.ComponentType.ToString(), StringComparison.CurrentCultureIgnoreCase))
                    {
                        int result;
                        if (int.TryParse(filter.Value, out result))
                        {
                            InstrumentComponentType match = (from x in ComponentTypes where x.Id == result select x).FirstOrDefault();
                            mSelectedComponentType = match;
                            RaisePropertyChanged("SelectedComponentType");
                        }
                    }

                    //IsActive
                    if (filter.Name.Equals(CommonUtils.InstrumentSearchFilterNames.IsActive.ToString(), StringComparison.CurrentCultureIgnoreCase))
                    {
                        //For compatibility as previously it was saved as Id
                        if (filter.Value == "-1") filter.Value = All;
                        if (filter.Value == "-2") filter.Value = Yes;
                        if (filter.Value == "-3") filter.Value = No;

                        var match = (from x in IsActiveChoices where x == filter.Value select x).FirstOrDefault();
                        mSelectedIsActive = match;
                        RaisePropertyChanged("SelectedIsActive");

                    }

                    //PidDocument
                    if (filter.Name.Equals(CommonUtils.InstrumentSearchFilterNames.PidDocument.ToString(), StringComparison.CurrentCultureIgnoreCase))
                    {
                        int result;
                        if (int.TryParse(filter.Value, out result))
                        {
                            QuickDocument match = (from x in PandIDDocuments where x.Id == result select x).FirstOrDefault();
                            mSelectedPAndIdDocument = match;
                            RaisePropertyChanged("SelectedPAndIdDocument");
                        }
                    }

                    //Specification
                    if (filter.Name.Equals(CommonUtils.InstrumentSearchFilterNames.Specification.ToString(), StringComparison.CurrentCultureIgnoreCase))
                    {
                        int result;
                        if (int.TryParse(filter.Value, out result))
                        {
                            QuickDocument match = (from x in SpecificationDocuments where x.Id == result select x).FirstOrDefault();
                            mSelectedSpecificationDocument = match;
                            RaisePropertyChanged("SelectedSpecificationDocument");
                        }
                    }
                }
            }

            ProcessSearchFilter();
        }
        private void LoadData()
        {
            var getInstrumentTypesTask = DatabaseLoader.GetInstrumentTypes();
            var pidDocumentsTask = DatabaseLoader.GetQuickDocuments(CommonUtils.DoctypePidCode);
            var specificationDocumentsTask = DatabaseLoader.GetQuickDocuments(CommonUtils.DoctypeFuncspecCode);
            var getInstrumentComponentTypesTask = DatabaseLoader.GetInstrumentComponentTypes();
            var getManufacturersTask = DatabaseLoader.GetManufacturers(CommonUtils.EquipmentTypeCode.INSTR);
            var getModelsTask = DatabaseLoader.GetModels(CommonUtils.EquipmentTypeCode.INSTR);

            List<Task> tasks = new List<Task>();
            tasks.Add(getInstrumentTypesTask);
            tasks.Add(pidDocumentsTask);
            tasks.Add(specificationDocumentsTask);
            tasks.Add(getInstrumentComponentTypesTask);
            tasks.Add(getManufacturersTask);

            Task.Factory.ContinueWhenAll(tasks.ToArray(), x =>
            {
                CMS.UiFactory.StartNew(() =>
                {
                   //EquipmentType
                    var allItem = new InstrumentType {Id = -1, Name = All};
                    EquipmentTypes = getInstrumentTypesTask.Result;
                    EquipmentTypes.Insert(0, allItem);
                    mSelectedEquipmentType = EquipmentTypes[0];
                    RaisePropertyChanged("EquipmentTypes");
                    RaisePropertyChanged("SelectedEquipmentType");

                    //Pid Documents
                    PandIDDocuments = pidDocumentsTask.Result;
                    PandIDDocuments.Insert(0, new QuickDocument {Id = -1, Name = All});
                    mSelectedPAndIdDocument = PandIDDocuments[0];
                    RaisePropertyChanged("PandIDDocuments");
                    RaisePropertyChanged("SelectedPAndIDDocument");

                    //Component Types
                    ComponentTypes = getInstrumentComponentTypesTask.Result;
                    ComponentTypes.Insert(0, new InstrumentComponentType {Id = -1, Name = All});
                    mSelectedComponentType = ComponentTypes[0];
                    RaisePropertyChanged("ComponentTypes");
                    RaisePropertyChanged("SelectedComponentType");

                    //Specification Documents
                    SpecificationDocuments = specificationDocumentsTask.Result;
                    SpecificationDocuments.Insert(0, new QuickDocument {Id = -1, Name = All});
                    mSelectedSpecificationDocument = SpecificationDocuments[0];
                    RaisePropertyChanged("SpecificationDocuments");
                    RaisePropertyChanged("SelectedSpecificationDocument");

                    //Classified
                    Classifieds = new List<String> {All, Yes, No};
                    mSelectedClassified = Classifieds[0];
                    RaisePropertyChanged("Classifieds");
                    RaisePropertyChanged("SelectedClassified");

                    //IsActive
                    IsActiveChoices = new List<String> {All, Yes, No};
                    mSelectedIsActive = IsActiveChoices[0];
                    RaisePropertyChanged("IsActiveChoices");
                    RaisePropertyChanged("SelectedIsActive");

                    //Model
                    mModelsCache = getModelsTask.Result;

                    //Manufacturer
                    Manufacturers = getManufacturersTask.Result;
                    Manufacturers.Insert(0, new Manufacturer {Id = -1, Name = All});
                    SelectedManufacturer = Manufacturers[0];
                    RaisePropertyChanged("Manufacturers");
                    RaisePropertyChanged("SelectedManufacturer");

                    //Sorting
                    SortingChoices = new List<String> { CommonUtils.InstrumentSorting.Numerically.ToString(), CommonUtils.InstrumentSorting.Alphabetically.ToString() };
                    mSelectedSorting = SortingChoices[0];
                    RaisePropertyChanged("SortingChoices");
                    RaisePropertyChanged("SelectedSorting");

                    SetUpFilteredLinkControl();
                    InitialiseSearchFilterControl(CommonUtils.TabId.Instrument);
                });
            });

            LoadAreas();
            LoadSubAreas();
        }
        private void ClearControls()
        {
            mKeyword = string.Empty;
            RaisePropertyChanged("Keyword");

            mSelectedArea = Areas[0];
            RaisePropertyChanged("SelectedArea");

            mMainSystId = string.Empty;
            RaisePropertyChanged("MainSystId");

            mSelectedEquipmentType = EquipmentTypes[0];
            RaisePropertyChanged("SelectedEquipmentType");

            mSelectedSubArea = SubAreas[0];
            RaisePropertyChanged("SelectedSubArea");

            mSelectedPAndIdDocument = PandIDDocuments[0];
            RaisePropertyChanged("SelectedPAndIdDocument");

            mSelectedComponentType = ComponentTypes[0];
            RaisePropertyChanged("SelectedComponentType");

            mSelectedSpecificationDocument = SpecificationDocuments[0];
            RaisePropertyChanged("SelectedSpecificationDocument");

            mSelectedClassified = Classifieds[0];
            RaisePropertyChanged("Classified");

            mSelectedIsActive = IsActiveChoices[0];
            RaisePropertyChanged("SelectedIsActive");

            mSelectedManufacturer = Manufacturers[0];
            RaisePropertyChanged("SelectedManufacturer");

            mSelectedModel = Models[0];
            RaisePropertyChanged("SelectedModel");

            mSelectedPAndIdDocument = PandIDDocuments[0];
            RaisePropertyChanged("SelectedPAndIDDocument");

            mSelectedClassified = Classifieds[0];
            RaisePropertyChanged("SelectedClassified");

            mSelectedSorting = SortingChoices[0];
            RaisePropertyChanged("SelectedSorting");
        }