public HttpResponseMessage AddWorkoutSchedule(AddScheduleRequestModel objAddScheduleRequestModel)
        {
            FResponse result = new FResponse();

            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 = _objIScheduleRepository.AddSchedule(objAddScheduleRequestModel, UserId);
                    if (value > 0)
                    {
                        result.WorkoutId  = value;
                        result.StatusCode = Convert.ToInt32(HttpStatusCode.OK);
                        result.Message    = "Workout Schedule 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 AddSchedule(AddScheduleRequestModel objAddScheduleRequestModel, Int64 UserId)
        {
            //TimeZoneInfo GetUTCTime = TimeZoneInfo.FindSystemTimeZoneById("Greenwich Mean Time");
            //DateTime UTCTime = DateTime.UtcNow;
            //DateTime localDateTime = DateTime.Now.ToLocalTime();
            //TimeSpan dd = (UTCTime - localDateTime);

            //TimeZoneInfo timeZoneInfo_india = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time");
            //DateTime India = TimeZoneInfo.ConvertTime(DateTime.Now, timeZoneInfo_india);
            //DateTime localDateTime = DateTime.Now.ToLocalTime();
            //TimeSpan dd = (India - localDateTime);
            TimeSpan newtime;
            TimeSpan span3;

            //var GetCountryId = _objFriendFitDBEntity.UserProfiles.Where(s => s.Id == UserId).FirstOrDefault();
            var GetCountryId = _objFriendFitDBEntity.UserProfiles.Where(s => s.Id == UserId).FirstOrDefault();

            if (GetCountryId.CountryId == 91)
            {
                span3   = TimeSpan.FromMinutes(0);
                newtime = objAddScheduleRequestModel.ScheduleTime;
            }
            else
            {
                span3   = TimeSpan.FromMinutes(270);
                newtime = objAddScheduleRequestModel.ScheduleTime.Subtract(span3);
                if (newtime.TotalDays >= 1)
                {
                    span3 = TimeSpan.FromDays(1);
                    TimeSpan span5    = TimeSpan.FromMinutes(270);
                    TimeSpan newtime1 = objAddScheduleRequestModel.ScheduleTime.Subtract(span3);
                    newtime = newtime1.Subtract(span5);
                }
            }

            //var GetCountryId = _objFriendFitDBEntity.UserProfiles.Where(s => s.Id == UserId).FirstOrDefault();

            //switch (GetCountryId.CountryId)
            //{
            //    case 1: //canada
            //        span3 = TimeSpan.FromMinutes(300);
            //        break;
            //    case 2:
            //        span3 = TimeSpan.FromMinutes(-330);
            //        break;
            //    case 44: //UK
            //        span3 = TimeSpan.FromMinutes(0);
            //        break;
            //    case 61: //australia
            //        span3 = TimeSpan.FromMinutes(-600);
            //        break;
            //    case 91: //india
            //        span3 = TimeSpan.FromMinutes(-330);
            //        break;
            //    case 973: //BAHRAIN
            //        span3 = TimeSpan.FromMinutes(-180);
            //        break;
            //    default:
            //        span3 = TimeSpan.FromMinutes(-330);
            //        break;
            //}
            //TimeSpan TImeSp = objAddScheduleRequestModel.ScheduleTime;
            //TimeSpan Start_UTCTime = TImeSp.Add(span3);

            //DateTime time = DateTime.Today.Add(newtime);
            //string displayTime = time.ToString("hh:mm tt");
            //TimeSpan GetScdeduleTime = Convert.ToDateTime(displayTime).TimeOfDay;

            WorkOutSchedule objWorkOutSchedule = new WorkOutSchedule()
            {
                Monday           = objAddScheduleRequestModel.Monday,
                Tuesday          = objAddScheduleRequestModel.Tuesday,
                Wednesday        = objAddScheduleRequestModel.Wednesday,
                Thursday         = objAddScheduleRequestModel.Thursday,
                Friday           = objAddScheduleRequestModel.Friday,
                Saturday         = objAddScheduleRequestModel.Saturday,
                Sunday           = objAddScheduleRequestModel.Sunday,
                RecurrenceId     = objAddScheduleRequestModel.RecurrenceId,
                ScheduleTime     = objAddScheduleRequestModel.ScheduleTime,
                ScheduleTime_UTC = newtime,
                TextMeTime       = objAddScheduleRequestModel.TextMeTime,
                TextFriendTime   = objAddScheduleRequestModel.TextFriendTime,
                StartDate        = objAddScheduleRequestModel.StartDate,
                EndDate          = objAddScheduleRequestModel.EndDate,
                CreatedDate      = DateTime.Now,
                CreatedBy        = UserId,
                IsActive         = true,
                RowStatus        = false,
                UserId           = UserId,
                WorkoutId        = 0,
                WorkoutText      = objAddScheduleRequestModel.WorkoutText
            };

            _objFriendFitDBEntity.WorkOutSchedules.Add(objWorkOutSchedule);
            _objFriendFitDBEntity.SaveChanges();


            Int64 workoutId  = _objFriendFitDBEntity.WorkOutSchedules.Where(x => x.WorkoutText == objWorkOutSchedule.WorkoutText).FirstOrDefault().Id;
            var   BulkInsert = _objFriendFitDBEntity.InsertBulkworkout(Convert.ToInt32(workoutId));

            return(Convert.ToInt32(workoutId));
        }