public bool GetInstrumentType(string typeName, Instrument newEquipment, int rowIndex) { if (string.IsNullOrEmpty(typeName)) { if (MetaData.ImportType == CommonUtils.ImportType.UpdateInstrument) { return false; } } if (string.IsNullOrEmpty(typeName)) { RaiseMessage(CommonUtils.MessageType.Error, string.Format("WorkSheet '{0}' Line '{1}': Type row is blank. Skipping.", WorkSheetName, rowIndex)); return true; } InstrumentType equipmentType = (from x in mExistingInstrumentTypes where string.Compare(x.Name, typeName, true, CultureInfo.CurrentCulture) == 0 select x).FirstOrDefault(); if (equipmentType == null) { if (CanCreateProperties) { equipmentType = new InstrumentType { Name = typeName, IsActive = true, Code = typeName.Replace(" ", "").ToUpper().Trim() }; mExistingInstrumentTypes.Add(equipmentType); } else { RaiseMessage(CommonUtils.MessageType.Error, string.Format("WorkSheet '{0}' Row '{1}':Could not match '{2}' InstrumentType. Skipping.", WorkSheetName, rowIndex, typeName)); return true; } } newEquipment.InstrumentType = equipmentType; return false; }
public InstrumentType SaveInstrumentType(InstrumentType instrumentType) { using (CmsEntities cee = new CmsEntities()) { InstrumentType original = (from x in cee.InstrumentTypes where x.Id == instrumentType.Id select x).FirstOrDefault(); if (original == null) { instrumentType.Code = instrumentType.Name.Replace(" ", ""); instrumentType.IsActive = true; cee.InstrumentTypes.Add(instrumentType); } else { original.Name = instrumentType.Name; original.Description = instrumentType.Description; original.Code = instrumentType.Name.Replace(" ", ""); original.Ordinal = instrumentType.Ordinal; original.IsActive = true; } cee.SaveChanges(); } return instrumentType; }
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 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"); }