/// <summary> /// /// </summary> public void Save() { EDBEntities eDB = new EDBEntities(); // To determine which items have been deleted in the collection, get all associations of the project stored in the database table first var tblObjectAssociations = eDB.tblObjectAssociations.Where(p => p.Project_ID == Globals.Project_ID); // Check if each association of the table exists in the associations collection // if not, delete the association in the table foreach (var objectAssociationRec in tblObjectAssociations) { var objectAssociationItem = GetObjectAssociation(objectAssociationRec.Object_ID, objectAssociationRec.Association_ID); if (objectAssociationItem == null) // association not found in collection { eDB.tblObjectAssociations.Remove(objectAssociationRec); } } // Add and update associations recursively SaveLevel(ObjectAssociations, eDB); try { eDB.SaveChanges(); } catch (Exception ex) { RadWindow.Alert(new DialogParameters() { Header = "Error", Content = "Fault while saving object associations:\n" + ex.Message }); } IsChanged = false; }
/// <summary> /// Select Project Command through command interface /// </summary> private void SelectProject(Object p) { ProjectModel selectedProject = GetProject((int)p); Globals.Project_ID = (int)p; Globals.ProjectSelected = true; ProjectSelected = true; Globals.ProjectName = selectedProject.ProjectName; Globals.ContractNo = selectedProject.ContractNo; selectedProject.LastOpened = DateTime.Now; // Store the current DateTime in the selected project record so it can be used to sort the project list EDBEntities eDB = new EDBEntities(); tblProject Rec = eDB.tblProjects.Where(o => o.ID == selectedProject.ID).FirstOrDefault(); Rec.LastOpened = selectedProject.LastOpened; Rec.LastOpenedBy = Environment.UserName; eDB.SaveChanges(); IsBackStageOpen = false; MainTitle = Globals.ContractNo + Globals.ProjectName; TypeViewModelLocator.GetTypeVM(); ObjectViewModelLocator.GetObjectVM(); TemplateViewModelLocator.GetTemplateVM(); PropertyViewModelLocator.GetPropertyVM(); AspectViewModelLocator.GetAspectVM(); AttributeViewModelLocator.GetAttributeVM(); ObjectAssociationViewModelLocator.GetObjectAssociationVM(); ObjectRequirementViewModelLocator.GetObjectRequirementVM(); TemplateAssociationViewModelLocator.GetTemplateAssociationVM(); TemplateRequirementViewModelLocator.GetTemplateRequirementVM(); }
/// <summary> /// /// </summary> public void Save() { EDBEntities eDB = new EDBEntities(); // To determine which items have been deleted in the collection, get all objects of the project stored in the database table first var tblTemplates = eDB.tblTemplates.Where(p => p.Project_ID == Globals.Project_ID); // Check if each template of the table exists in the templates collection // if not, delete the template in the table foreach (var templateRec in tblTemplates) { var templateItem = GetTemplate(templateRec.ID); if (templateItem == null) // template not found in collection { eDB.tblTemplates.Remove(templateRec); } } // Add and update templates recursively SaveLevel(Templates, eDB); try { eDB.SaveChanges(); } catch (Exception ex) { RadWindow.Alert(new DialogParameters() { Header = "Error", Content = "Fault while saving templates:\n" + ex.Message }); } SaveTreeState(); }
public void Save() { EDBEntities eDB = new EDBEntities(); SaveLevel(Aspects, eDB); try { eDB.SaveChanges(); } catch (Exception ex) { RadWindow.Alert("Fault while saving aspects: " + ex.Message); } IsChanged = false; }
public void Save() { EDBEntities eDB = new EDBEntities(); foreach (var typeItem in Types) { if (typeItem.IsNew) { tblType NewRec = new tblType(); var Rec = eDB.tblTypes.Add(NewRec); Rec.Type = typeItem.Type; Rec.Description = typeItem.Description; Rec.Image = typeItem.Image; Rec.TypeGroup = typeItem.TypeGroup; Rec.ShowOrder = typeItem.ShowOrder; Rec.Project_ID = Globals.Project_ID; typeItem.IsNew = false; typeItem.IsChanged = false; } if (typeItem.IsChanged) { tblType Rec = eDB.tblTypes.Where(o => o.ID == typeItem.ID).FirstOrDefault(); Rec.Type = typeItem.Type; Rec.Description = typeItem.Description; Rec.Image = typeItem.Image; Rec.ShowOrder = typeItem.ShowOrder; typeItem.IsChanged = false; } if (typeItem.IsDeleted) { tblType Rec = eDB.tblTypes.Where(o => o.ID == typeItem.ID).FirstOrDefault(); if (Rec != null) { eDB.tblTypes.Remove(Rec); } } } try { eDB.SaveChanges(); } catch (Exception ex) { RadWindow.Alert("Fault while saving object types: " + ex.Message); } }
public void Save() { EDBEntities eDB = new EDBEntities(); // To determine which items have been deleted in the collection, get all ControlObject of the project stored in the database table first var tblControlObjects = eDB.tblControlObjects.Where(p => p.Project_ID == Globals.Project_ID); // Check if each object of the table exists in the ControlObject collection // if not, delete the object in the table foreach (var ControllerRec in tblControlObjects) { var controllerItem = GetController(ControllerRec.ID); if (controllerItem == null) // object not found in collection { eDB.tblControlObjects.Remove(ControllerRec); } } // Add and update ControlObject recursively SaveLevel(ControlObjects, eDB); try { eDB.SaveChanges(); } catch (Exception ex) { RadWindow.Alert(new DialogParameters() { Header = "Error", Content = "Fault while saving ControlObject:\n" + ex.Message }); } SaveTreeState(); IsChanged = false; }
/// <summary> /// Saves all changes to the ViewModel /// </summary> private void Save() { EDBEntities eDB = new EDBEntities(); eDB.SaveChanges(); }