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