public SaveResult SaveTune(UserTuneViewModel userTuneViewModel) { SaveResult saveResult = new SaveResult(); try { pidhubEntities entity = new pidhubEntities(); Tune tune; // if Tune ID is not present then create a new Tune, else get the existing entity if (userTuneViewModel.TuneID == 0) { tune = new Tune(); } else { tune = (from t in entity.Tunes where t.Tune_ID == userTuneViewModel.TuneID select t).FirstOrDefault(); } // update values in entity tune.Quad_ID = userTuneViewModel.QuadID; tune.TuneName = userTuneViewModel.TuneName; tune.Roll_P = userTuneViewModel.Roll_P; tune.Pitch_P = userTuneViewModel.Pitch_P; tune.Yaw_P = userTuneViewModel.Yaw_P; tune.Roll_I = userTuneViewModel.Roll_I; tune.Pitch_I = userTuneViewModel.Pitch_I; tune.Yaw_I = userTuneViewModel.Yaw_I; tune.Roll_D = userTuneViewModel.Roll_D; tune.Pitch_D = userTuneViewModel.Pitch_D; tune.Yaw_D = userTuneViewModel.Yaw_D; tune.Roll_Rate = userTuneViewModel.Roll_Rate; tune.Pitch_Rate = userTuneViewModel.Pitch_Rate; tune.Pitch_RCRate = userTuneViewModel.Pitch_RCRate; tune.Yaw_Rate = userTuneViewModel.Yaw_Rate; tune.Yaw_RCRate = userTuneViewModel.Yaw_RCRate; tune.Roll_RCRate = userTuneViewModel.Roll_RCRate; tune.Roll_RCCurve = userTuneViewModel.Roll_RCCurve; tune.Pitch_RCCurve = userTuneViewModel.Pitch_RCCurve; tune.Yaw_RCCurve = userTuneViewModel.Yaw_RCCurve; tune.Roll_RCExpo = userTuneViewModel.Roll_RCExpo; tune.Pitch_RCExpo = userTuneViewModel.Pitch_RCExpo; tune.Yaw_RCExpo = userTuneViewModel.Yaw_RCExpo; // if this is a new Tune then must 'Add' to entity if (userTuneViewModel.TuneID == 0) { entity.Tunes.Add(tune); } entity.SaveChanges(); } catch (Exception ex) { saveResult.ErrorMessage = String.Format("There was an error saving your tune: {0}.", ex.Message); } return(saveResult); }
public UserAccountViewModel CreateUserAccount(UserAccountViewModel userViewModel) { try { pidhubEntities entity = new pidhubEntities(); UserAccount userAccount = new UserAccount() { PilotName = userViewModel.PilotName, Email = userViewModel.Email, Password = userViewModel.Password }; entity.UserAccounts.Add(userAccount); entity.SaveChanges(); userViewModel.UserID = userAccount.User_ID; } catch (Exception ex) { //TODO Change method to return SaveResult //saveResult.ErrorMessage = String.Format("There was an error creating your account {0}.", ex.Message); } return(userViewModel); }
public SaveResult SaveQuad(QuadDetailViewModel quadDetailsViewModel) { SaveResult saveResult = new SaveResult(); try { pidhubEntities entity = new pidhubEntities(); Quad quad; if (quadDetailsViewModel.QuadID == 0) { quad = new Quad(); } else { quad = (from q in entity.Quads where q.Quad_ID == quadDetailsViewModel.QuadID select q).FirstOrDefault(); } quad.User_ID = quadDetailsViewModel.UserID; quad.QuadName = quadDetailsViewModel.QuadName; quad.FlightControllerSoftwareID = quadDetailsViewModel.SelectedFCSoftwareID; quad.FlightControllerHardwareID = quadDetailsViewModel.SelectedFCHardwareID; quad.FrameID = quadDetailsViewModel.SelectedFrameID; quad.MotorID = quadDetailsViewModel.SelectedMotorID; quad.ESCID = quadDetailsViewModel.SelectedESCID; quad.PropID = quadDetailsViewModel.SelectedPropID; quad.BatteryID = quadDetailsViewModel.SelectedBatteryID; if (quadDetailsViewModel.QuadID == 0) { entity.Quads.Add(quad); } entity.SaveChanges(); } catch (Exception ex) { saveResult.ErrorMessage = String.Format("There was an error saving your quad: {0}.", ex.Message); } return(saveResult); }
public SaveResult DeleteTune(int tuneID) { SaveResult saveResult = new SaveResult(); try { pidhubEntities entity = new pidhubEntities(); var tune = (from t in entity.Tunes where t.Tune_ID == tuneID select t).FirstOrDefault(); entity.Tunes.Remove(tune); entity.SaveChanges(); } catch (Exception ex) { saveResult.ErrorMessage = String.Format("There was an error deleting your Tune: {0}", ex.Message); } return(saveResult); }
public SaveResult DeleteQuad(int quadID) { SaveResult saveResult = new SaveResult(); try { pidhubEntities entity = new pidhubEntities(); var quad = (from q in entity.Quads where q.Quad_ID == quadID select q).FirstOrDefault(); entity.Tunes.RemoveRange(quad.Tunes); entity.Quads.Remove(quad); entity.SaveChanges(); } catch (Exception ex) { saveResult.ErrorMessage = String.Format("There was an error deleting your quad: {0}.", ex.Message); } return(saveResult); }