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