public HttpResponseMessage ListOfSchedule(ListOfWorkoutRequestModel objListOfWorkoutRequestModel, string Search) { ScheduleListResponseModel result = new ScheduleListResponseModel(); FResponse res = 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(); result.Response.scheduleLists = _objIScheduleExerciseRepository.ScheduleList(objListOfWorkoutRequestModel, Search).ToList(); if (result.Response.scheduleLists.Count > 0) { result.Response.StatusCode = Convert.ToInt32(HttpStatusCode.OK); result.Response.Message = "Success!!"; } else { result.Response.StatusCode = Convert.ToInt32(HttpStatusCode.NotFound); result.Response.Message = "No Records"; } } catch (Exception ex) { res.StatusCode = Convert.ToInt32(HttpStatusCode.BadRequest); _response = Request.CreateResponse(HttpStatusCode.InternalServerError, "Some error occurred"); } _response = Request.CreateResponse(HttpStatusCode.OK, result); return(_response); }
public List <WorkoutList> WorkoutList(ListOfWorkoutRequestModel objListOfWorkoutRequestModel) { List <WorkoutList> model = new List <ApiModel.APIResponseModel.WorkoutList>(); try { model = _objFriendFitDBEntity.Database.SqlQuery <WorkoutList>("WorkoutList @UserId=@UserId", new SqlParameter("UserId", objListOfWorkoutRequestModel.UserId)).ToList(); } catch (Exception ex) { } return(model); }