public HttpResponseMessage UpdateWorkoutByUserId(UpdateWorkoutRequestModel objUpdateWorkoutRequestModel) { FResponse result = new FResponse(); 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 updateModel = _objIWorkoutRepository.UpdateWorkoutDetailsById(objUpdateWorkoutRequestModel, UserId); if (updateModel > 0) { result.StatusCode = Convert.ToInt32(HttpStatusCode.OK); result.Message = "Success!!"; } 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); return(_response); }
public int UpdateWorkoutDetailsById(UpdateWorkoutRequestModel objUpdateWorkoutRequestModel, Int64 UserId) { try { int updateWorDetails = _objFriendFitDBEntity.Database.ExecuteSqlCommand("UpdateWorkoutDetails @Description=@Description,@DateOfWorkout=@DateOfWorkout,@StartTime=@StartTime,@FinishTime=@FinishTime,@WorkoutNotes=@WorkoutNotes,@UserId=@UserId,@WorkOutId=@WorkOutId", new SqlParameter("Description", objUpdateWorkoutRequestModel.Description), new SqlParameter("DateOfWorkout", objUpdateWorkoutRequestModel.DateOfWorkout), new SqlParameter("StartTime", objUpdateWorkoutRequestModel.StartTime), new SqlParameter("FinishTime", objUpdateWorkoutRequestModel.FinishTime), new SqlParameter("WorkoutNotes", objUpdateWorkoutRequestModel.WorkoutNotes), new SqlParameter("UserId", UserId), new SqlParameter("WorkOutId", objUpdateWorkoutRequestModel.WorkOutId)); } catch (Exception ex) { } return(1); }