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);
}
