public DatabaseItemViewModel(Buglist buglistItem) { this.ItemIdentification = buglistItem.Id; this.FailureType = buglistItem.FailureType; this.StatusType = buglistItem.StatusType; this.ControllerType = buglistItem.ControllerType; this.HardwareIdentificationLevel1 = buglistItem.HardwareIdentificationLevel1; this.HardwareIdentificationLevel2 = buglistItem.HardwareIdentificationLevel2; this.Bug = buglistItem.Bug; this.Comment = buglistItem.Comment; this.Priority = buglistItem.Priority; this.DateFound = buglistItem.DateFound; this.DateFixed = buglistItem.DateFixed; }
/// <summary> /// Adds a buglist item in the database. /// </summary> /// <param name="buglistItem">The buglist item.</param> public void AddBuglistItem(Application.BuglistView.Buglist buglistItem) { EntityFramework.Buglist buglistDatabase = new Buglist(); buglistDatabase.Id = buglistItem.Id; buglistDatabase.FailureType_Id = this.GetFailureTypId(buglistItem.FailureType); buglistDatabase.StatusType_Id = this.GetStatusTypeId(buglistItem.StatusType); buglistDatabase.ControllerType_Id = this.GetControllerTypId(buglistItem.ControllerType); buglistDatabase.HardwareIdentificationLevel1_Id = this.GetHardwareIdentificationLevel1Id(buglistItem.HardwareIdentificationLevel1); buglistDatabase.HardwareIdentificationLevel2_Id = this.GetHardwareIdentificationLevel2Id(buglistItem.HardwareIdentificationLevel2); buglistDatabase.Bug = buglistItem.Bug; buglistDatabase.Comment = buglistItem.Comment; buglistDatabase.Priority_Id = this.GetPriorityId(buglistItem.Priority); buglistDatabase.DateFound = buglistItem.DateFound; buglistDatabase.DateFixed = buglistItem.DateFixed; databaseContext.Buglist.Add(buglistDatabase); databaseContext.SaveChanges(); }
/// <summary> /// Updates the buglist item in database. /// </summary> /// <param name="buglistItem">The buglist item.</param> public void UpdateBuglistItemInDatabase(Application.BuglistView.Buglist buglistItem) { Buglist buglistItemToUpdate = databaseContext.Buglist.Where(x => x.Id == buglistItem.Id).FirstOrDefault(); if (buglistItemToUpdate != null) { buglistItemToUpdate.FailureType_Id = this.GetFailureTypId(buglistItem.FailureType); buglistItemToUpdate.StatusType_Id = this.GetStatusTypeId(buglistItem.StatusType); buglistItemToUpdate.ControllerType_Id = this.GetControllerTypId(buglistItem.ControllerType); buglistItemToUpdate.HardwareIdentificationLevel1_Id = this.GetHardwareIdentificationLevel1Id(buglistItem.HardwareIdentificationLevel1); buglistItemToUpdate.HardwareIdentificationLevel2_Id = this.GetHardwareIdentificationLevel2Id(buglistItem.HardwareIdentificationLevel2); buglistItemToUpdate.Bug = buglistItem.Bug; buglistItemToUpdate.Comment = buglistItem.Comment; buglistItemToUpdate.Priority_Id = this.GetPriorityId(buglistItem.Priority); buglistItemToUpdate.DateFound = buglistItem.DateFound; buglistItemToUpdate.DateFixed = buglistItem.DateFixed; } databaseContext.SaveChanges(); }
private void SaveItem(DatabaseItemViewModel databaseItemViewModel) { //update database view first this.LoadBuglistDataGrid(); //Create new item if software item has identification number -1 if (this.detailedInformationViewModel.IsNewItemSet) { Buglist buglistItem = this.detailedInformationViewModel.GetBuglistItem(); //check if the buglist item already exist in the database List <Buglist> buglistItems = this.etic2Model.BuglistItem.GetApplicationBuglist(); if (buglistItems.Any(x => x.Bug == databaseItemViewModel.Bug)) { this.ViewModelEvents.OnUserFeedback(this, new UserFeedbackInfoEventArgs(string.Format("{0} does already exist in database and can not be saved again!", databaseItemViewModel.Bug))); return; } this.etic2Model.BuglistItem.AddBuglistItem(buglistItem); buglistItem = this.etic2Model.BuglistItem.GetApplicationBuglistItem(buglistItem.Bug); if (buglistItem != null) { this.detailedInformationViewModel.SetDetailedInformation(new DatabaseItemViewModel(buglistItem)); } } else { //only save dateFixed if the status type is not open if (databaseItemViewModel.StatusType == "open") { this.etic2Model.BuglistItem.UpdateBuglistItemInDatabase(new Buglist() { Id = databaseItemViewModel.ItemIdentification, FailureType = databaseItemViewModel.FailureType, StatusType = databaseItemViewModel.StatusType, ControllerType = databaseItemViewModel.ControllerType, HardwareIdentificationLevel1 = databaseItemViewModel.HardwareIdentificationLevel1, HardwareIdentificationLevel2 = databaseItemViewModel.HardwareIdentificationLevel2, Bug = databaseItemViewModel.Bug, Comment = databaseItemViewModel.Comment, Priority = databaseItemViewModel.Priority, DateFound = databaseItemViewModel.DateFound, DateFixed = null }); } else { this.etic2Model.BuglistItem.UpdateBuglistItemInDatabase(new Buglist() { Id = databaseItemViewModel.ItemIdentification, FailureType = databaseItemViewModel.FailureType, StatusType = databaseItemViewModel.StatusType, ControllerType = databaseItemViewModel.ControllerType, HardwareIdentificationLevel1 = databaseItemViewModel.HardwareIdentificationLevel1, HardwareIdentificationLevel2 = databaseItemViewModel.HardwareIdentificationLevel2, Bug = databaseItemViewModel.Bug, Comment = databaseItemViewModel.Comment, Priority = databaseItemViewModel.Priority, DateFound = databaseItemViewModel.DateFound, DateFixed = databaseItemViewModel.DateFixed }); } } this.LoadBuglistDataGrid(); this.buglistDatabaseDataGridViewModel.SelectedDatabaseItemViewModel = this.buglistDatabaseDataGridViewModel.DatabaseItemViewModels.Where( x => x.Bug == databaseItemViewModel.Bug).FirstOrDefault(); }