public HttpResponseMessage UpdateScheduleWorkout(UpdateScheduleWorkoutRequestModel objUpdateScheduleWorkoutRequestModel, Int64 ScheduleId)
{
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 = _objIScheduleRepository.UpdateScheduleWorkout(objUpdateScheduleWorkoutRequestModel, ScheduleId, 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 UpdateScheduleWorkout(UpdateScheduleWorkoutRequestModel objUpdateScheduleWorkoutRequestModel, Int64 ScheduleId, Int64 UserId)
{
try
{
int rowEffected = _objFriendFitDBEntity.Database.ExecuteSqlCommand("UpdateScheduleWorkout @ScheduleId=@ScheduleId,@UserId=@UserId,@Monday=@Monday,@Tuesday=@Tuesday,@Wednesday=@Wednesday,@Thursday = @Thursday,@Friday = @Friday,@Saturday = @Saturday,@Sunday = @Sunday,@RecurrenceId = @RecurrenceId,@ScheduleTime = @ScheduleTime,@TextMeTime = @TextMeTime,@TextFriendTime = @TextFriendTime,@StartDate = @StartDate,@EndDate = @EndDate",
new SqlParameter("ScheduleId", ScheduleId),
new SqlParameter("UserId", UserId),
new SqlParameter("Monday", objUpdateScheduleWorkoutRequestModel.Monday),
new SqlParameter("Tuesday", objUpdateScheduleWorkoutRequestModel.Tuesday),
new SqlParameter("Wednesday", objUpdateScheduleWorkoutRequestModel.Wednesday),
new SqlParameter("Thursday", objUpdateScheduleWorkoutRequestModel.Thursday),
new SqlParameter("Friday", objUpdateScheduleWorkoutRequestModel.Friday),
new SqlParameter("Saturday", objUpdateScheduleWorkoutRequestModel.Saturday),
new SqlParameter("Sunday", objUpdateScheduleWorkoutRequestModel.Sunday),
new SqlParameter("RecurrenceId", objUpdateScheduleWorkoutRequestModel.RecurrenceId),
new SqlParameter("ScheduleTime", objUpdateScheduleWorkoutRequestModel.ScheduleTime),
new SqlParameter("TextMeTime", objUpdateScheduleWorkoutRequestModel.TextMeTime),
new SqlParameter("TextFriendTime", objUpdateScheduleWorkoutRequestModel.TextFriendTime),
new SqlParameter("StartDate", objUpdateScheduleWorkoutRequestModel.StartDate),
new SqlParameter("EndDate", objUpdateScheduleWorkoutRequestModel.EndDate));
}
catch (Exception ex)
{
return(0);
}
return(1);
}
