public PipeClassViewModel() { mPipeClass = new PipeClass(); OkButtonCommand = new DelegateCommand<object>(OkButtonHander, CanExecuteOkButtonHandler); CancelButtonCommand = new DelegateCommand<object>(CancelButtonHander, x => true); }
public PipeClassViewModel(int pipeClassId) { CmsWebServiceClient cmsWebServiceClient = new CmsWebServiceClient(Utils.WcfBinding, Utils.WcfEndPoint); cmsWebServiceClient.GetPipeClassesCompleted += (s, e) => { mPipeClass = (from x in e.Result where x.Id == pipeClassId select x).FirstOrDefault(); if (DataLoaded != null) { DataLoaded(); } }; cmsWebServiceClient.GetPipeClassesAsync(); OkButtonCommand = new DelegateCommand<object>(OkButtonHander, CanExecuteOkButtonHandler); CancelButtonCommand = new DelegateCommand<object>(CancelButtonHander, x => true); }
private void SetControlValuesFromSearchFilterList(SearchFilterList searchFilterList) { mSearchFilterControl.SetFilterIsOn(true); ClearControls(); //1. Manufacturer SearchFilter manufactuerFilter = (from x in searchFilterList.SearchFilters where x.Name.Equals(CommonUtils.PipeSearchFilterNames.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.PipeSearchFilterNames.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.PipeSearchFilterNames.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.PipeSearchFilterNames.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.PipeSearchFilterNames.KeyWord.ToString(), StringComparison.CurrentCultureIgnoreCase)) { mKeyword = filter.Value; RaisePropertyChanged("Keyword"); } //PipeClass if (filter.Name.Equals(CommonUtils.PipeSearchFilterNames.Class.ToString(), StringComparison.CurrentCultureIgnoreCase)) { int result; if (int.TryParse(filter.Value, out result)) { var match = (from x in PipeClasses where x.Id == result select x).FirstOrDefault(); mSelectedPipeClass = match; RaisePropertyChanged("SelectedPipeClass"); } } //PipeSize if (filter.Name.Equals(CommonUtils.PipeSearchFilterNames.Size.ToString(), StringComparison.CurrentCultureIgnoreCase)) { int result; if (int.TryParse(filter.Value, out result)) { var match = (from x in PipeSizes where x.Id == result select x).FirstOrDefault(); mSelectedPipeSize = match; RaisePropertyChanged("SelectedPipeSize"); } } //PipeFluidCode if (filter.Name.Equals(CommonUtils.PipeSearchFilterNames.FluidCode.ToString(), StringComparison.CurrentCultureIgnoreCase)) { int result; if (int.TryParse(filter.Value, out result)) { var match = (from x in PipeFluidCodes where x.Id == result select x).FirstOrDefault(); mSelectedPipeFluidCode = match; RaisePropertyChanged("SelectedPipeFluidCode"); } } //PipeSpecialFeature if (filter.Name.Equals(CommonUtils.PipeSearchFilterNames.SpecialFeature.ToString(), StringComparison.CurrentCultureIgnoreCase)) { int result; if (int.TryParse(filter.Value, out result)) { var match = (from x in PipeSpecialFeatures where x.Id == result select x).FirstOrDefault(); mSelectedPipeSpecialFeature = match; RaisePropertyChanged("SelectedPipeSpecialFeature"); } } //PidDocument if (filter.Name.Equals(CommonUtils.PipeSearchFilterNames.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"); } } //ComponentType if (filter.Name.Equals(CommonUtils.PipeSearchFilterNames.ComponentType.ToString(), StringComparison.CurrentCultureIgnoreCase)) { int result; if (int.TryParse(filter.Value, out result)) { PipeComponentType match = (from x in ComponentTypes where x.Id == result select x).FirstOrDefault(); mSelectedComponentType = match; RaisePropertyChanged("SelectedComponentType"); } } //IsActive if (filter.Name.Equals(CommonUtils.PipeSearchFilterNames.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"); } } } ProcessSearchFilter(); }
private void LoadData() { var getPipeClassesTask = DatabaseLoader.GetPipeClasses(); var getPipeSizesTask = DatabaseLoader.GetPipeSizes(); var getPipeFluidCodesTask = DatabaseLoader.GetPipeFluidCodes(); var getPipeSpecialFeaturesTask = DatabaseLoader.GetPipeSpecialFeatures(); var pidDocumentsTask = DatabaseLoader.GetQuickDocuments(CommonUtils.DoctypePidCode); var getPipeComponentTypesTask = DatabaseLoader.GetPipeComponentTypes(); var getManufacturersTask = DatabaseLoader.GetManufacturers(CommonUtils.EquipmentTypeCode.PIPE); var getModelsTask = DatabaseLoader.GetModels(CommonUtils.EquipmentTypeCode.PIPE); List<Task> tasks = new List<Task>(); tasks.Add(getPipeClassesTask); tasks.Add(getPipeSizesTask); tasks.Add(getPipeFluidCodesTask); tasks.Add(getPipeSpecialFeaturesTask); tasks.Add(pidDocumentsTask); tasks.Add(getPipeComponentTypesTask); tasks.Add(getManufacturersTask); Task.Factory.ContinueWhenAll(tasks.ToArray(), x => { CMS.UiFactory.StartNew(() => { //Pipe Classes PipeClasses = getPipeClassesTask.Result; PipeClasses.Insert(0, new PipeClass { Id = -1, Name = All }); mSelectedPipeClass = PipeClasses[0]; RaisePropertyChanged("PipeClasses"); RaisePropertyChanged("SelectedPipeClass"); //Pipe Sizes PipeSizes = getPipeSizesTask.Result; PipeSizes.Insert(0, new PipeSize { Id = -1, Name = All }); mSelectedPipeSize = PipeSizes[0]; RaisePropertyChanged("PipeSizes"); RaisePropertyChanged("SelectedPipeSize"); //Pipe FluidCodes PipeFluidCodes = getPipeFluidCodesTask.Result; PipeFluidCodes.Insert(0, new PipeFluidCode { Id = -1, Name = All }); mSelectedPipeFluidCode = PipeFluidCodes[0]; RaisePropertyChanged("PipeFluidCodes"); RaisePropertyChanged("SelectedPipeFluidCode"); //Pipe SpecialFeatures PipeSpecialFeatures = getPipeSpecialFeaturesTask.Result; PipeSpecialFeatures.Insert(0, new PipeSpecialFeature { Id = -1, Name = All }); mSelectedPipeSpecialFeature = PipeSpecialFeatures[0]; RaisePropertyChanged("PipeSpecialFeatures"); RaisePropertyChanged("SelectedPipeSpecialFeature"); //Pid Documents PandIDDocuments = pidDocumentsTask.Result; PandIDDocuments.Insert(0, new QuickDocument { Id = -1, Name = All }); mSelectedPAndIdDocument = PandIDDocuments[0]; RaisePropertyChanged("PandIDDocuments"); RaisePropertyChanged("SelectedPAndIdDocument"); //Component Types ComponentTypes = getPipeComponentTypesTask.Result; ComponentTypes.Insert(0, new PipeComponentType { Id = -1, Name = All }); mSelectedComponentType = ComponentTypes[0]; RaisePropertyChanged("ComponentTypes"); RaisePropertyChanged("SelectedComponentType"); //Model mModelsCache = getModelsTask.Result; //Manufacturer Manufacturers = getManufacturersTask.Result; Manufacturers.Insert(0, new Manufacturer { Id = -1, Name = All }); SelectedManufacturer = Manufacturers[0]; RaisePropertyChanged("Manufacturers"); RaisePropertyChanged("SelectedManufacturer"); //Classified IsActiveChoices = new List<String> { All, Yes, No }; mSelectedIsActive = IsActiveChoices[0]; RaisePropertyChanged("IsActiveChoices"); RaisePropertyChanged("SelectedIsActive"); SetUpFilteredLinkControl(); InitialiseSearchFilterControl(CommonUtils.TabId.Piping); }); }); LoadAreas(); LoadSubAreas(); }
private void ClearControls() { mKeyword = string.Empty; RaisePropertyChanged("Keyword"); mSelectedArea = Areas[0]; RaisePropertyChanged("SelectedArea"); mSelectedSubArea = SubAreas[0]; RaisePropertyChanged("SelectedSubArea"); mSelectedPipeClass = PipeClasses[0]; RaisePropertyChanged("SelectedPipeClass"); mSelectedPipeSize = PipeSizes[0]; RaisePropertyChanged("SelectedPipeSize"); mSelectedPipeFluidCode = PipeFluidCodes[0]; RaisePropertyChanged("SelectedPipeFluidCode"); mSelectedPipeSpecialFeature = PipeSpecialFeatures[0]; RaisePropertyChanged("SelectedPipeSpecialFeature"); mSelectedPAndIdDocument = PandIDDocuments[0]; RaisePropertyChanged("SelectedPAndIdDocument"); mSelectedComponentType = ComponentTypes[0]; RaisePropertyChanged("SelectedComponentType"); mSelectedManufacturer = Manufacturers[0]; RaisePropertyChanged("SelectedManufacturer"); mSelectedModel = Models[0]; RaisePropertyChanged("SelectedModel"); mSelectedIsActive = IsActiveChoices[0]; RaisePropertyChanged("SelectedIsActive"); }
public PipeClass SavePipeClass(PipeClass pipeClass) { using (CmsEntities cee = new CmsEntities()) { //Check if the pipe area exist var originalPipeClass = (from x in cee.PipeClasses where x.Id == pipeClass.Id select x).FirstOrDefault(); if (originalPipeClass == null) { //Add new Pipe Class pipeClass.Pipes = null; cee.PipeClasses.Add(pipeClass); } else { //Update existing PipeSzie originalPipeClass.Name = pipeClass.Name; originalPipeClass.Description = pipeClass.Description; } cee.SaveChanges(); } return pipeClass; }
private bool GetPipeClass(Worksheet worksheet, string pipeClass, Pipe newPipe, int rowIndex) { bool skipRow = false; if (!string.IsNullOrEmpty(pipeClass)) { //Check if the Class exist in the database PipeClass pipeClassObj = mPipeRelatedObjects.PipeClasses.Where(x => x.Name.ToLower() == pipeClass.Trim().ToLower()).FirstOrDefault(); if (pipeClassObj != null) { newPipe.ClassId = pipeClassObj.Id; } else { //Add new pipe class to the database pipeClassObj = new PipeClass(); pipeClassObj.Name = pipeClass; mCee.PipeClasses.AddObject(pipeClassObj); mCee.SaveChanges(); mPipeRelatedObjects.PipeClasses.Add(pipeClassObj); RaiseMessage(MessageType.Added, string.Format("WorkSheet '{0}' Line '{1}': Added new '{2}' class to database.", worksheet.Name, rowIndex, pipeClass)); newPipe.ClassId = pipeClassObj.Id; } } else { RaiseMessage(MessageType.Warning, string.Format("WorkSheet '{0}' Line '{1}': Class is empty. Skipping this row.", worksheet.Name, rowIndex)); skipRow = true; } return skipRow; }
private void OkButtonHander(object parameter) { if (AreAllValid()) { //save CmsWebServiceClient cmsWebServiceClient = new CmsWebServiceClient(Utils.WcfBinding, Utils.WcfEndPoint); cmsWebServiceClient.SavePipeClassCompleted += (s1, e1) => { if (e1.Result != null) { mPipeClass = e1.Result; View.PipeClass = mPipeClass; View.DialogResult = true; } else { MessageBox.Show("Save Failed."); View.DialogResult = false; } }; cmsWebServiceClient.SavePipeClassAsync(mPipeClass); } }