public ServiceResponse <ExerciseTrainingResponse> Add(AddExerciseTrainingRequest addExerciseTrainingRequest) { using (DiaryContext db = new DiaryContext()) { var trainingUnit = db.TrainingUnits.FirstOrDefault(x => x.Id == addExerciseTrainingRequest.TrainingUnitId); if (trainingUnit == null) { return(new ServiceResponse <ExerciseTrainingResponse>(null, HttpStatusCode.NotFound, "Unable to find the training unit!")); } var exercise = db.Exercises.FirstOrDefault(x => x.Id == addExerciseTrainingRequest.ExerciseId); if (exercise == null) { return(new ServiceResponse <ExerciseTrainingResponse>(null, HttpStatusCode.NotFound, "Unable to find the exercise!")); } var exerciseDetails = db.ExercisesDetails.FirstOrDefault(x => x.Id == addExerciseTrainingRequest.ExerciseDetailsId); if (exerciseDetails == null) { return(new ServiceResponse <ExerciseTrainingResponse>(null, HttpStatusCode.NotFound, "Unable to find the exercise details!")); } var exerciseTraining = new ExerciseTraining { TrainingUnit = trainingUnit, Exercise = exercise, ExerciseDetails = exerciseDetails }; ExerciseTraining _ExerciseTraining = db.ExerciseTrainings.Add(exerciseTraining); db.SaveChanges(); return(new ServiceResponse <ExerciseTrainingResponse>(new ExerciseTrainingResponse(_ExerciseTraining), HttpStatusCode.OK, "ExerciseTraining added succesfully!")); } }
//Sets the DB Context for Testing Database public static void InitializeTestingDb() { DiaryContext.ConnectionName = "DiaryAppTest"; DiaryContext context = new DiaryContext(); context.Database.Initialize(true); }
public override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context) { context.OwinContext.Response.Headers.Add("Access-Control-Allow-Origin", new[] { "*" }); User user; using (var db = new DiaryContext()) using (var userManager = new UserManager <User, int>(new UserStore <User, CustomRole, int, CustomUserLogin, CustomUserRole, CustomUserClaim>(db))) { user = await userManager.FindAsync(context.UserName, context.Password); if (user == null) { context.SetError("invalid_grant", "The user name or password is incorrect."); return; } } var identity = new ClaimsIdentity(context.Options.AuthenticationType); identity.AddClaim(new Claim("sub", context.UserName)); identity.AddClaim(new Claim("role", "user")); context.Validated(identity); context.Ticket.Properties.Dictionary.Add(new KeyValuePair <string, string>("UserId", user.Id.ToString())); }
public ServiceResponse Delete(int id) { using (DiaryContext db = new DiaryContext()) { if (!db.Days.Any(x => x.Id == id)) { return(new ServiceResponse(HttpStatusCode.NotFound, "There is not existing day with given id!")); } var dayToRemove = db.Days.Include("Diary").Include("Dream").Include("TrainingUnits").FirstOrDefault(x => x.Id == id); TrainingService trainingService = new TrainingService(); foreach (var trainingUnit in dayToRemove.TrainingUnits) { trainingService.DeleteTrainingUnit(trainingUnit.Id); } if (dayToRemove.Dream != null) { db.Dreams.Remove(dayToRemove.Dream); } db.SaveChanges(); } using (DiaryContext db = new DiaryContext()) { var dayToRemove2 = db.Days.Include("Diary").Include("Dream").Include("TrainingUnits").FirstOrDefault(x => x.Id == id); db.Days.Remove(dayToRemove2); db.SaveChanges(); } return(new ServiceResponse(HttpStatusCode.OK, "Day deleted!")); }
private static void SetUpDevelopmentEntries() { using (var context = new DiaryContext()) { context.Entries.Add(new EntryModel()); } }
public ServiceResponse Delete(int id) { using (DiaryContext db = new DiaryContext()) { if (!db.Users.Any(x => x.Id == id)) { return(new ServiceResponse(HttpStatusCode.NotFound, "There is not existing user with given id!")); } var userToRemove = db.Users.Include(x => x.Diaries).Include(x => x.UserDetails).FirstOrDefault(x => x.Id == id); DiaryService diaryService = new DiaryService(); foreach (var diary in userToRemove.Diaries) { diaryService.Delete(diary.Id); } if (userToRemove.UserDetails != null) { db.UserDetails.Remove(userToRemove.UserDetails); } db.SaveChanges(); } using (DiaryContext db = new DiaryContext()) { var userToRemove = db.Users.Include(x => x.Diaries).Include(x => x.UserDetails).FirstOrDefault(x => x.Id == id); var userManager = new UserManager <User, int>(new UserStore <User, CustomRole, int, CustomUserLogin, CustomUserRole, CustomUserClaim>(db)); userManager.Delete(userToRemove); db.SaveChanges(); } return(new ServiceResponse(HttpStatusCode.OK, "User deleted!")); }
public ServiceResponse Delete(int id) { using (DiaryContext db = new DiaryContext()) { if (!db.Diaries.Any(x => x.Id == id)) { return(new ServiceResponse(HttpStatusCode.NotFound, "There is not existing user with given id!")); } var diaryToRemove = db.Diaries.Include(x => x.Days).Include(x => x.User).FirstOrDefault(x => x.Id == id); DayService dayService = new DayService(); foreach (var day in diaryToRemove.Days) { dayService.Delete(day.Id); } db.SaveChanges(); } using (DiaryContext db = new DiaryContext()) { var diaryToRemove2 = db.Diaries.Include(x => x.Days).Include(x => x.User).FirstOrDefault(x => x.Id == id); db.Diaries.Remove(diaryToRemove2); db.SaveChanges(); } return(new ServiceResponse(HttpStatusCode.OK, "User deleted!")); }
public ServiceResponse <UserDetailsResponse> UpdateDetails(UpdateUserDetailsRequest userDetailsRequest) { using (DiaryContext db = new DiaryContext()) { UserDetails userDetailsToUpdate = db.UserDetails.FirstOrDefault(x => x.Id == userDetailsRequest.UserId); if (userDetailsToUpdate == null) { return(new ServiceResponse <UserDetailsResponse>(null, HttpStatusCode.NotFound, "There are not existing user details with given id!")); } userDetailsToUpdate = db.UserDetails.FirstOrDefault(x => x.Id == userDetailsRequest.UserId); if (userDetailsRequest.Age > 0) { userDetailsToUpdate.Age = userDetailsRequest.Age; } if (userDetailsRequest.Height > 0) { userDetailsToUpdate.Height = userDetailsRequest.Height; } if (userDetailsRequest.Weight > 0) { userDetailsToUpdate.Weight = userDetailsRequest.Weight; } float[] results = CalculateBMIandBMR(userDetailsToUpdate.Weight, userDetailsToUpdate.Height, userDetailsToUpdate.Age); userDetailsToUpdate.BMI = results[0]; userDetailsToUpdate.BMR = results[1]; db.SaveChanges(); return(new ServiceResponse <UserDetailsResponse>(new UserDetailsResponse(userDetailsToUpdate), HttpStatusCode.OK, "UserDetails added succesfully!")); } }
public ServiceResponse <AvatarResponse> AddAvatar(AddAvatarRequest request) { Avatar avatar; using (DiaryContext db = new DiaryContext()) { var userDetails = db.UserDetails.FirstOrDefault(x => x.Id == request.UserDetailsId); if (userDetails == null) { return(new ServiceResponse <AvatarResponse>(null, HttpStatusCode.NotFound, "Unable to find the user details!")); } avatar = db.Avatars.FirstOrDefault(x => x.Id == userDetails.Id); if (avatar != null) { avatar.Image = Convert.FromBase64String(request.Image); } else { avatar = new Avatar() { Id = userDetails.Id, Image = Convert.FromBase64String(request.Image), UserDetails = userDetails }; db.Avatars.Add(avatar); } db.SaveChanges(); } return(new ServiceResponse <AvatarResponse>(new AvatarResponse(avatar), HttpStatusCode.OK, "Avatar created successfully")); }
public ServiceResponse <UserDetailsResponse> AddDetails(AddUserDetailsRequest userDetailsRequest) { using (DiaryContext db = new DiaryContext()) { User userVerification = db.Users.FirstOrDefault(x => x.Id == userDetailsRequest.UserId); if (userVerification == null || userVerification.UserDetails != null) { return(new ServiceResponse <UserDetailsResponse>(null, HttpStatusCode.BadRequest, "User does not exist or it already has a details")); } var userDetails = new UserDetails { Id = userDetailsRequest.UserId, Age = userDetailsRequest.Age, Height = userDetailsRequest.Height, Weight = userDetailsRequest.Weight, User = db.Users.FirstOrDefault(x => x.Id == userDetailsRequest.UserId) }; var BMIandBMR = CalculateBMIandBMR(userDetails.Weight, userDetails.Height, userDetails.Height); userDetails.BMI = BMIandBMR[0]; userDetails.BMR = BMIandBMR[1]; var _user = db.UserDetails.Add(userDetails); db.SaveChanges(); return(new ServiceResponse <UserDetailsResponse>(new UserDetailsResponse(_user), HttpStatusCode.OK, "UserDetails added succesfully!")); } }
public ServiceResponse <UserResponse> Update(UpdateUserRequest updateUserRequest) { User userToUpdate; using (DiaryContext db = new DiaryContext()) { if (!db.Users.Any(x => x.Id == updateUserRequest.Id)) { return(new ServiceResponse <UserResponse>(null, HttpStatusCode.NotFound, "There is not existing user with given id!")); } userToUpdate = db.Users.FirstOrDefault(x => x.Id == updateUserRequest.Id); if (!string.IsNullOrEmpty(updateUserRequest.Name)) { userToUpdate.Name = updateUserRequest.Name; } if (!string.IsNullOrEmpty(updateUserRequest.Surname)) { userToUpdate.Surname = updateUserRequest.Surname; } if (!string.IsNullOrEmpty(updateUserRequest.City)) { userToUpdate.City = updateUserRequest.City; } db.SaveChanges(); return(new ServiceResponse <UserResponse>(new UserResponse(userToUpdate), HttpStatusCode.OK, "User was updated successfully")); } }
private int SaveEntryReturnId(EntryModel entry) { using (var context = new DiaryContext()) { context.Entries.Add(entry); context.SaveChanges(); } return(entry.Id); }
private static void SetUpDevelopmentUser() { applicationUser = new ApplicationUser(); using (var context = new DiaryContext()) { context.Users.Add(applicationUser); context.SaveChanges(); } }
//public ServiceResponse<IEnumerable<DiaryResponse>> Read() //{ // List<Diary> diaries = new List<Diary>(); // using (DiaryContext db = new DiaryContext()) // { // diaries = db.Diaries.Include(x => x.Days).Include(x => x.User).ToList(); // } // List<DiaryResponse> diaryResponses = new List<DiaryResponse>(); // foreach (var item in diaries) // { // diaryResponses.Add(new DiaryResponse(item)); // } // return new ServiceResponse<IEnumerable<DiaryResponse>>(diaryResponses, HttpStatusCode.OK, "Table downloaded!"); //} //public ServiceResponse<DiaryResponse> ReadById(int id) //{ // DiaryResponse diaryResponse = GetDiary(id); // if(diaryResponse == null) // { // return new ServiceResponse<DiaryResponse>(null, HttpStatusCode.NotFound, "There is not existing diary with given id!"); // } // return new ServiceResponse<DiaryResponse>(diaryResponse, HttpStatusCode.OK, "Diary downloaded!"); //} public ServiceResponse <DiaryResponse> Update(UpdateDiaryRequest updateDiaryRequest) { Diary diaryToUpdate; using (DiaryContext db = new DiaryContext()) { if (!db.Diaries.Any(x => x.Id == updateDiaryRequest.Id)) { return(new ServiceResponse <DiaryResponse>(null, HttpStatusCode.NotFound, "There is not existing diary with given id!")); } diaryToUpdate = db.Diaries.FirstOrDefault(x => x.Id == updateDiaryRequest.Id); if (!string.IsNullOrEmpty(updateDiaryRequest.Conclusions)) { diaryToUpdate.Conclusions = updateDiaryRequest.Conclusions; } if (updateDiaryRequest.EndDate.Date.Year > 2019) { diaryToUpdate.EndDate = updateDiaryRequest.EndDate; } if (updateDiaryRequest.StartDate.Date.Year > 2019) { diaryToUpdate.StartDate = updateDiaryRequest.StartDate; } if (updateDiaryRequest.BenchPressStart != 0) { diaryToUpdate.BenchPressStart = updateDiaryRequest.BenchPressStart; } if (updateDiaryRequest.SquatStart != 0) { diaryToUpdate.SquatStart = updateDiaryRequest.SquatStart; } if (updateDiaryRequest.DeadliftStart != 0) { diaryToUpdate.DeadliftStart = updateDiaryRequest.DeadliftStart; } if (updateDiaryRequest.BenchPressEnd != 0) { diaryToUpdate.BenchPressEnd = updateDiaryRequest.BenchPressEnd; } if (updateDiaryRequest.SquatEnd != 0) { diaryToUpdate.SquatEnd = updateDiaryRequest.SquatEnd; } if (updateDiaryRequest.DeadliftEnd != 0) { diaryToUpdate.DeadliftEnd = updateDiaryRequest.DeadliftEnd; } if (updateDiaryRequest.Progress != 0) { diaryToUpdate.Progress = updateDiaryRequest.Progress; } db.SaveChanges(); return(new ServiceResponse <DiaryResponse>(new DiaryResponse(diaryToUpdate), HttpStatusCode.OK, "User was updated successfully")); } }
private IEntryModel FindEntryBy(int storedId) { IEntryModel entry; using (var context = new DiaryContext()) { entry = context.Entries.Find(storedId); } return(entry); }
public ExerciseTrainingResponse GetExerciseTraining(int id) { using (DiaryContext db = new DiaryContext()) { ExerciseTraining exerciseTraining = db.ExerciseTrainings.Include("Exercise").Include("ExerciseDetails").Include("TrainingUnit").FirstOrDefault(x => x.Id == id); if (exerciseTraining == null) { return(null); } return(new ExerciseTrainingResponse(exerciseTraining)); } }
public UserDetailsResponse ReadUserDetailsById(int id) { using (DiaryContext db = new DiaryContext()) { UserDetails userDetails = db.UserDetails.Include(x => x.Avatar).FirstOrDefault(x => x.Id == id); if (userDetails == null) { return(null); } return(new UserDetailsResponse(userDetails)); } }
public ExerciseEquipmentResponse GetExerciseEquipment(int id) { using (DiaryContext db = new DiaryContext()) { ExerciseEquipment exercise = db.ExerciseEquipment.FirstOrDefault(x => x.Id == id); if (exercise == null) { return(null); } return(new ExerciseEquipmentResponse(exercise)); } }
public TrainingUnitResponse GetTrainingUnit(int id) { using (DiaryContext db = new DiaryContext()) { TrainingUnit trainingUnit = db.TrainingUnits.Include("Day").Include("ExerciseTrainings").FirstOrDefault(x => x.Id == id); if (trainingUnit == null) { return(null); } return(new TrainingUnitResponse(trainingUnit)); } }
public DayResponse GetDay(int id) { using (DiaryContext db = new DiaryContext()) { Day day = db.Days.Include("Diary").Include("Dream").Include("TrainingUnits").FirstOrDefault(x => x.Id == id); if (day == null) { return(null); } return(new DayResponse(day, typeof(DayResponse))); } }
public DiaryResponse GetDiary(int id) { using (DiaryContext db = new DiaryContext()) { Diary diary = db.Diaries.Include(x => x.Days).Include(x => x.User).FirstOrDefault(x => x.Id == id); if (diary == null) { return(null); } return(new DiaryResponse(diary)); } }
public ExerciseResponse GetExercise(int id) { using (DiaryContext db = new DiaryContext()) { Exercise exercise = db.Exercises.Include("ExerciseTrainings").Include("ExerciseEquipment").FirstOrDefault(x => x.Id == id); if (exercise == null) { return(null); } return(new ExerciseResponse(exercise)); } }
public DiaryController(IOptions <CustomAppSettings> ASettings, DiaryContext ADBContext, IFoxDataService foxDataService, IHttpContextAccessor httpContextAccessor) { Settings = ASettings; HttpContextAccessor = httpContextAccessor; if (Settings != null) { Settings.Value.Configure(httpContextAccessor); } EntityMapper.Settings = Settings.Value; DBContext = ADBContext; FoxDataService = foxDataService; appointmentStatus = new AppointmentStatusHelper(FoxDataService); }
public async Task GetEntries(string username) { using (var context = new DiaryContext()) { var user = await context.Users .Include(b => b.Entries) .FirstOrDefaultAsync(b => b.Username == username); if (!user.LoggedIn) { await Clients.Caller.EntriesRetrieved(user.Entries); } } }
public ServiceResponse <ICollection <ExerciseDetailsResponse> > GetAllExerciseDetails() { using (DiaryContext db = new DiaryContext()) { var list = db.ExercisesDetails.ToList(); List <ExerciseDetailsResponse> list2 = new List <ExerciseDetailsResponse>(); foreach (var item in list) { list2.Add(new ExerciseDetailsResponse(item)); } return(new ServiceResponse <ICollection <ExerciseDetailsResponse> >(list2, HttpStatusCode.OK, "Table downloaded successfully")); } }
public ServiceResponse <ExerciseEquipmentResponse> Add(AddExerciseEquipmentRequest exerciseRequest) { using (DiaryContext db = new DiaryContext()) { var exerciseEquipment = new ExerciseEquipment { Name = exerciseRequest.Name }; ExerciseEquipment _exercise = db.ExerciseEquipment.Add(exerciseEquipment); db.SaveChanges(); return(new ServiceResponse <ExerciseEquipmentResponse>(new ExerciseEquipmentResponse(_exercise), HttpStatusCode.OK, "Exercise added succesfully!")); } }
public ServiceResponse <AvatarResponse> GetAvatar(int id) { Avatar avatar; using (DiaryContext db = new DiaryContext()) { avatar = db.Avatars.FirstOrDefault(x => x.Id == id); if (avatar == null) { return(new ServiceResponse <AvatarResponse>(null, HttpStatusCode.NotFound, "There is no existing avatar with given id!")); } } return(new ServiceResponse <AvatarResponse>(new AvatarResponse(avatar), HttpStatusCode.OK, "Avatar downloaded")); }
public ServiceResponse DeleteAvatar(int id) { using (DiaryContext db = new DiaryContext()) { if (!db.Avatars.Any(x => x.Id == id)) { return(new ServiceResponse(HttpStatusCode.NotFound, "There is no existing avatar with given id!")); } Avatar avatarToRemove = db.Avatars.FirstOrDefault(x => x.Id == id); db.Avatars.Remove(avatarToRemove); db.SaveChanges(); } return(new ServiceResponse(HttpStatusCode.OK, "Avatar deleted!")); }
public ServiceResponse SaveBrandingSettings(SaveBrandingRequest request) { using (DiaryContext db = new DiaryContext()) { var userDetails = db.UserDetails.FirstOrDefault(x => x.Id == request.Id); if (userDetails == null) { return(new ServiceResponse(HttpStatusCode.BadRequest, "There is no existing user details with given id!")); } userDetails.BrandingSettings = request.BrandingSettings; db.SaveChanges(); } return(new ServiceResponse(HttpStatusCode.OK, "Branding saved!")); }
public async Task SaveEntries(int entryId, string content) { bool saveSuccesful; using (var context = new DiaryContext()) { var entry = await context.Entries.FirstOrDefaultAsync(b => b.Id == entryId); entry.Content = content; await context.SaveChangesAsync(); saveSuccesful = entry != null; } await Clients.Caller.EntriesSaved(saveSuccesful); }