public HttpResponseMessage AddWorkout(AddWorkoutModelRequest objAddWorkoutModelRequest) { AddWorkoutResponseModel result = new AddWorkoutResponseModel(); if (ModelState.IsValid) { try { var headers = Request.Headers; string token = headers.Authorization.Parameter.ToString(); Int64 UserId = _objFriendFitDBEntity.Database.SqlQuery <Int64>("select UserId from UserToken where TokenCode={0}", token).FirstOrDefault(); int value = _objIWorkoutRepository.AddWorkout(objAddWorkoutModelRequest, UserId); Int64 WorkoutId = _objFriendFitDBEntity.Database.SqlQuery <Int64>("SELECT TOP 1 Id FROM WorkOut ORDER BY id DESC").FirstOrDefault(); if (value > 0) { result.WorkoutId = WorkoutId; result.StatusCode = Convert.ToInt32(HttpStatusCode.OK); result.Message = "Workout added successfully!"; } else { result.StatusCode = Convert.ToInt32(HttpStatusCode.NotAcceptable); result.Message = "Parameters are not correct"; } } catch (Exception ex) { result.StatusCode = Convert.ToInt32(HttpStatusCode.BadRequest); _response = Request.CreateResponse(HttpStatusCode.InternalServerError, "Some error occurred"); } _response = Request.CreateResponse(HttpStatusCode.OK, result); } else { ModelState.AddModelError("", "One or more errors occurred."); } return(_response); }
public int AddWorkout(AddWorkoutModelRequest objAddWorkoutModelRequest, Int64 UserId) { WorkOut objWork = new WorkOut() { UserId = objAddWorkoutModelRequest.UserId, Description = objAddWorkoutModelRequest.Description, DateOfWorkout = objAddWorkoutModelRequest.DateOfWorkout, StartTime = objAddWorkoutModelRequest.StartTime, FinishTime = objAddWorkoutModelRequest.FinishTime, WorkoutNotes = objAddWorkoutModelRequest.WorkoutNotes, Createdate = System.DateTime.Now, CreatedBy = UserId, IsActive = true, RowStatus = true, StatusId = 2, AutoFinishTime = objAddWorkoutModelRequest.AutoFinishTime, ScheduleWorkout = false }; _objFriendFitDBEntity.WorkOuts.Add(objWork); _objFriendFitDBEntity.SaveChanges(); return(1); }