public bool AddTeeTime(TeeTime selectedTeeTime) { using var connection = new SqlConnection(ConnectionString); using var command = new SqlCommand("EditTeeTime", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@Date", SqlDbType.Date).Value = selectedTeeTime.Date.Date; command.Parameters.Add("@Time", SqlDbType.Time).Value = selectedTeeTime.Time.TimeOfDay; command.Parameters.Add("@golfer1", SqlDbType.VarChar).Value = selectedTeeTime.Golfer1.FullName == "Vacant" ? null : selectedTeeTime.Golfer1.FullName; command.Parameters.Add("@golfer2", SqlDbType.VarChar).Value = selectedTeeTime.Golfer2.FullName == "Vacant" ? null : selectedTeeTime.Golfer2.FullName; command.Parameters.Add("@golfer3", SqlDbType.VarChar).Value = selectedTeeTime.Golfer3.FullName == "Vacant" ? null : selectedTeeTime.Golfer3.FullName; command.Parameters.Add("@golfer4", SqlDbType.VarChar).Value = selectedTeeTime.Golfer4.FullName == "Vacant" ? null : selectedTeeTime.Golfer4.FullName; command.Parameters.Add("@bookerId", SqlDbType.NVarChar).Value = selectedTeeTime.BookerId == "Vacant" ? null : selectedTeeTime.BookerId; //Open the connection and execute the reader connection.Open(); var success = command.ExecuteNonQuery(); connection.Close(); return(success != 0); }
public TeeAssignInfo(TeeAssign teeAssign, TeeTime teeTime, Member member, Course course) { TeeAsign = teeAssign; TeeTime = teeTime; Member = member; Course = course; }
public void InitialGoldLvLTeeTimeList() { convertDate = DateTime.ParseExact(datepicker, "yyyy-MM-dd", CultureInfo.InvariantCulture).ToString("MM/dd/yyyy", CultureInfo.InvariantCulture); TeeTime InitialTeeTime; DateTime InitialTime = new DateTime(2020, 05, 01, 07, 00, 00); InitialTeeTime = new TeeTime(); InitialTeeTime.Teetime = InitialTime.ToString("HH:mm"); InitialTeeTime.Date = convertDate; GoldLvLAvailableTeeTimeList.Add(InitialTeeTime); for (int i = 1; i < 97; i++) { if (i % 2 > 0) { InitialTeeTime = new TeeTime(); InitialTime = InitialTime.AddMinutes(7); InitialTeeTime.Teetime = InitialTime.ToString("HH:mm"); InitialTeeTime.Date = convertDate; GoldLvLAvailableTeeTimeList.Add(InitialTeeTime); } else { InitialTeeTime = new TeeTime(); InitialTime = InitialTime.AddMinutes(8); InitialTeeTime.Teetime = InitialTime.ToString("HH:mm"); InitialTeeTime.Date = convertDate; GoldLvLAvailableTeeTimeList.Add(InitialTeeTime); } } AvailableTeeTimeList = GoldLvLAvailableTeeTimeList; }
public IList <TeeTime> GetAvailableTeeTimes(int courseId, DateTime arrivalDate, DateTime departureDate) { List <TeeTime> teeTimes = new List <TeeTime>(); try { using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand cmd = new SqlCommand(SqlQueryTeeTime, connection); cmd.Parameters.AddWithValue("@courseId", courseId); cmd.Parameters.AddWithValue("@arrivalDate", arrivalDate.ToShortDateString()); cmd.Parameters.AddWithValue("@departureDate", departureDate.ToShortDateString()); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { TeeTime teeTime = ConvertReaderToTeeTime(reader); teeTimes.Add(teeTime); } } } catch (SqlException se) { Console.WriteLine("There has been an error"); } return(teeTimes); }
List <TeeAssignInfo> getForTeeTimeCommon(int teeTimeId, bool max) { TeeTime teeTime = _context.TeeTime.FirstOrDefault(r => r.TeeTimeId == teeTimeId); Course course = _context.Course.FirstOrDefault(r => r.CourseId == teeTime.CourseId); var TeeAssigns = _context.TeeAssign.Where(r => r.TeeTimeId == teeTimeId).OrderBy(r => r.Group).ThenBy(r => r.Order).ThenBy(r => r.TeeAssignId); List <TeeAssignInfo> TeeAssignInfos = new List <TeeAssignInfo>(); foreach (TeeAssign teeAssign in TeeAssigns) { Member member = _context.Member.FirstOrDefault(r => r.MemberId == teeAssign.MemberId); //TeeTime teeTime = _context.TeeTime.FirstOrDefault(r => r.TeeTimeId == teeAssign.TeeTimeId); //Course course = _context.Course.FirstOrDefault(r => r.CourseId == teeTime.CourseId); TeeAssignInfo teeAssignInfo = new TeeAssignInfo(teeAssign, teeTime, member, course); TeeAssignInfos.Add(teeAssignInfo); } if (max == true) { while (TeeAssignInfos.Count < teeTime.NumPlayers) { TeeAssign teeAssign = new TeeAssign(); teeAssign.TeeTimeId = teeTimeId; Member member = new Member(); TeeAssignInfo teeAssignInfo = new TeeAssignInfo(teeAssign, teeTime, member, course); TeeAssignInfos.Add(teeAssignInfo); } } return(TeeAssignInfos); }
public void CancelTeeTimeHandler(string teeTime, string userId, ISession session, string sessionKey, UserManager <ApplicationUser> userManager, ClaimsPrincipal user) { bool confirmation = false; var allTeeTimes = session.Get <IEnumerable <TeeTime> >(sessionKey); if (long.TryParse(teeTime, out long teeTimeTicks)) { TeeTime teeTimeToCancel = allTeeTimes?.FirstOrDefault(t => t.Datetime.Ticks == teeTimeTicks); Domain.CBS requestDirector = new Domain.CBS(userId, Startup.ConnectionString); if (teeTimeToCancel != null) { if ((user.IsInRole("Golfer") && teeTimeToCancel.Golfers.Exists(q => q.UserId == userManager.GetUserId(user))) || teeTimeToCancel.Golfers.Exists(q => q.UserId == userId)) { confirmation = requestDirector.CancelTeeTime(new DateTime(teeTimeTicks)); } } if (confirmation) { session.SetString("success", $"{(teeTimeToCancel.ReservedBy == userId ? "Tee Time cancelled" : "Golfer removed ")} successfully"); } } else { session.SetString("danger", "Tee time could not be canceled"); } }
public TeeTimeInfo(TeeTime teeTime, Member member, Course course, List <TeeAssignInfo> teeAssignInfos) { TeeTime = teeTime; Member = member; Course = course; TeeAssignInfos = teeAssignInfos; }
public async Task <IActionResult> Edit(int id, TeeTimeCreateViewModel model) { if (id != model.TeeTimeId) { return(NotFound()); } if (ModelState.IsValid) { try { DateTime ts; if (!DateTime.TryParse(model.TeeTimeTS.ToString(), out ts)) { ModelState.AddModelError("TeeTimeTS", "Invalid Date"); model.Courses = _courseData.getSelectList(); model.Member = _memberData.get(model.ReservedById); ; return(View(model)); } if (ts < _dateTime.getNow()) { ModelState.AddModelError("TeeTimeTS", "Please specify a future Date and Time"); model.Courses = _courseData.getSelectList(); model.Member = _memberData.get(model.ReservedById); return(View(model)); } TeeTime teeTime = new TeeTime(); teeTime.TeeTimeId = model.TeeTimeId; teeTime.ReservedById = model.ReservedById; teeTime.TeeTimeTS = ts; teeTime.CourseId = model.CourseId; teeTime.NumPlayers = model.NumPlayers; teeTime.MajorTour = model.MajorTour; teeTime.TeeTimeInterval = model.TeeTimeInterval; teeTime.LockWithdrawDays = model.LockWithdrawDays; teeTime.AutoAssign = false; _context.Update(teeTime); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } catch (DbUpdateConcurrencyException) { if (!TeeTimeExists(model.TeeTimeId)) { return(NotFound()); } else { throw; } } } model.Courses = _courseData.getSelectList(); model.Member = _memberData.get(model.ReservedById); return(View(model)); }
public bool ReserveTeeTime(TeeTime requestedTeeTime, out string message) { bool confirmation; DailyTeeSheets teeSheetManager = new DailyTeeSheets(MemberNumber, connectionString); confirmation = teeSheetManager.ReserveTeeTime(requestedTeeTime, out message); return(confirmation); }
public void OnGet() { DateTime selectedtime = DateTime.Parse(Request.Query["time"]); DateTime selecteddate = DateTime.Parse(Request.Query["date"]); selectedteetime = RequestDirector.FindTeeTime(selecteddate, selectedtime); authenticatedUser = UserManager.GetUser(UserManager.GetUserIdFromEmail(User.Identity.Name)); }
public bool DeleteTeeTime(TeeTime selectedTeeTime) { bool Confirmation = false; TeeTimes dataManager = new TeeTimes(); Confirmation = dataManager.DeleteTeeTime(selectedTeeTime); return(Confirmation); }
private TeeTime ConvertReaderToTeeTime(SqlDataReader reader) { TeeTime teeTime = new TeeTime(); teeTime.Id = Convert.ToInt32(reader["teeTimeId"]); return(teeTime); }
public bool ReserveTeeTime(TeeTime NewTeeTime, string MembershipLevel) { bool Confirmation; Reservations ReservationManager = new Reservations(); Confirmation = ReservationManager.AddReservation(NewTeeTime, MembershipLevel); return(Confirmation); }
public bool DeleteTeeTime(TeeTime selectedTeeTime) { bool Success = false; SqlConnection clubbaistConnection = new SqlConnection(); clubbaistConnection.ConnectionString = Startup.ConnectionString; SqlCommand DeleteTeeTimeCommand = new SqlCommand(); DeleteTeeTimeCommand.CommandType = CommandType.StoredProcedure; DeleteTeeTimeCommand.Connection = clubbaistConnection; DeleteTeeTimeCommand.CommandText = "DeleteTeeTime"; SqlParameter dateParameter = new SqlParameter(); dateParameter.ParameterName = "@Date"; dateParameter.SqlDbType = SqlDbType.DateTime; dateParameter.Value = selectedTeeTime.Date; dateParameter.Direction = ParameterDirection.Input; SqlParameter timeParameter = new SqlParameter(); timeParameter.ParameterName = "@Time"; timeParameter.SqlDbType = SqlDbType.Time; timeParameter.Value = selectedTeeTime.Time; timeParameter.Direction = ParameterDirection.Input; SqlParameter ReturnCodeParameter = new SqlParameter(); ReturnCodeParameter.ParameterName = "@ReturnCode"; ReturnCodeParameter.SqlDbType = SqlDbType.Int; ReturnCodeParameter.Direction = ParameterDirection.ReturnValue; DeleteTeeTimeCommand.Parameters.Add(dateParameter); DeleteTeeTimeCommand.Parameters.Add(timeParameter); DeleteTeeTimeCommand.Parameters.Add(ReturnCodeParameter); try { clubbaistConnection.Open(); DeleteTeeTimeCommand.ExecuteNonQuery(); int returnValue = (int)ReturnCodeParameter.Value; if (returnValue == 0) { Success = true; } clubbaistConnection.Close(); } catch { Success = false; } return(Success); }
public TeeTimeInfo getTeeTimeInfo(TeeTime teeTime) { Member member = _context.Member.FirstOrDefault(r => r.MemberId == teeTime.ReservedById); Course course = _context.Course.FirstOrDefault(r => r.CourseId == teeTime.CourseId); List <TeeAssignInfo> teeAssignInfos = _teeAssignInfo.getForTeeTime(teeTime.TeeTimeId); TeeTimeInfo teeTimeInfo = new TeeTimeInfo(teeTime, member, course, teeAssignInfos); return(teeTimeInfo); }
public TeeTime GetMajorTeeTime(DateTime dateTime) { DateTime date = dateTime.Date; DateTime datePlus1 = date.AddDays(1); TeeTime teeTime = _context.TeeTime.FirstOrDefault(r => r.TeeTimeTS >= date && r.TeeTimeTS < datePlus1 && r.MajorTour == true); return(teeTime); }
public void InitialCopperLvLTeeTimeList() { convertDate = DateTime.ParseExact(datepicker, "yyyy-MM-dd", CultureInfo.InvariantCulture).ToString("MM/dd/yyyy", CultureInfo.InvariantCulture); TeeTime InitialTeeTime; InitialTeeTime = new TeeTime(); InitialTeeTime.Teetime = ""; InitialTeeTime.Date = convertDate; GoldLvLAvailableTeeTimeList.Add(InitialTeeTime); }
public void UpdateTeeTimeHelper(string[] golfers, bool checkedIn, TeeTime teeTimeToUpdate, UserManager <ApplicationUser> userManager, string phone, int numberOfCarts, out bool confirmation, out string message) { Domain.CBS requestDirector = new Domain.CBS(Startup.ConnectionString); List <string> updatedGolfers = golfers.Length > 4 - teeTimeToUpdate.Golfers.Count ? golfers.ToList() .GetRange(0, 4 - teeTimeToUpdate.Golfers.Count) : golfers.ToList(); updatedGolfers = (from user in userManager.Users where updatedGolfers.Contains(user.MemberNumber) select user.Id).ToList(); confirmation = requestDirector.UpdateTeeTime(teeTimeToUpdate.Datetime, phone, numberOfCarts, updatedGolfers, checkedIn, out message); }
public List <TeeTime> GetTeeTimeByMemberAndDate(int MemberID, DateTime Date) { SqlConnection dbConnection = new SqlConnection(); //School //dbConnection.ConnectionString = "Persist Security Info=false;Integrated Security=true;Server=(LocalDb)\\MSSQLLocalDB;Database=ClubBaist;"; //home dbConnection.ConnectionString = "Persist Security Info=false;Integrated Security=true;Server=.;Database=ClubBaist;"; dbConnection.Open(); SqlCommand getTeeTimesCommand = new SqlCommand(); getTeeTimesCommand.Connection = dbConnection; getTeeTimesCommand.CommandText = "GetTeeTimeByDateAndMember"; getTeeTimesCommand.CommandType = CommandType.StoredProcedure; SqlParameter memberParam = new SqlParameter(); memberParam.SqlDbType = SqlDbType.Int; memberParam.SqlValue = MemberID; memberParam.ParameterName = "@MemberID"; SqlParameter dayParam = new SqlParameter(); dayParam.SqlDbType = SqlDbType.Date; dayParam.SqlValue = Date; dayParam.ParameterName = "@Date"; getTeeTimesCommand.Parameters.Add(memberParam); getTeeTimesCommand.Parameters.Add(dayParam); SqlDataReader dbReader = getTeeTimesCommand.ExecuteReader(); List <TeeTime> teeTimes = new List <TeeTime>(); if (dbReader.HasRows) { while (dbReader.Read()) { string date = dbReader["ScheduledTime"].ToString(); TeeTime teeTime = new TeeTime(); teeTime.TeeTimeID = int.Parse(dbReader["TeeTimeID"].ToString()); teeTime.ScheduledTime = Convert.ToDateTime(date); teeTime.Carts = int.Parse(dbReader["Carts"].ToString()); teeTimes.Add(teeTime); } } dbConnection.Close(); return(teeTimes); }
public void OnPost() { error = true; TeeTime newTeeTime = new TeeTime(); CBS teetimes = new CBS(); SearchParameter = SearchParameter; CBS systemControl = new CBS(); string[] subs = Submit.Split(' '); switch (subs[0]) { case "Search": SearchParameter = SearchParameter; teetimes.CreateTeeSheet(SearchParameter); Console.WriteLine(SearchParameter); _sampleObjectCollection = teetimes.GetDailyTeeTimeSheet(SearchParameter.Date); break; case "Select": SearchParameter = SearchParameter; newTeeTimeTime = (DateTime.Parse(subs[1]).Add(DateTime.Parse(subs[2]).TimeOfDay)); _sampleObjectCollection = teetimes.GetDailyTeeTimeSheet(SearchParameter.Date); break; case "Submit": _sampleObjectCollection = teetimes.GetDailyTeeTimeSheet(SearchParameter.Date); SearchParameter = SearchParameter; newTeeTime = systemControl.GetTeeTime(DateTime.Parse(subs[1]), DateTime.Parse(subs[2])); if (newTeeTime != null) { newTeeTime.NumCarts = newNumOfCarts; newTeeTime.NumPlayers = newNumOfPlayers; newTeeTime.TeeTimeDate = DateTime.Parse(subs[2]); newTeeTime.MemberNumber = newMemberNumber; newTeeTime.EmployeeName = ""; error = systemControl.BookNewTeeTime(newTeeTime); Message = $"Tee Time Booked for {subs[1]} {subs[2]}"; } else { error = true; Message = "Error"; } break; } }
public int getLockWithdrawDays(DateTime dateTime) { int days = 5; DateTime date = dateTime.Date; DateTime datePlus1 = date.AddDays(1); TeeTime teeTime = _context.TeeTime.FirstOrDefault(r => r.TeeTimeTS >= date && r.TeeTimeTS < datePlus1 && r.MajorTour == true); if (teeTime != null) { days = teeTime.LockWithdrawDays; } return(days); }
public void InitialTeeTimeList() { TeeTime InitialTeeTime; InitialTeeTime = new TeeTime(); DateTime InitialTime = new DateTime(2020, 05, 01, 07, 00, 00); for (int i = 1; i < 24; i++) { InitialTeeTime = new TeeTime(); InitialTime = InitialTime.AddMinutes(30); InitialTeeTime.Teetime = InitialTime.ToString("HH:mm"); InitialTeeTimes.Add(InitialTeeTime); } }
public List <TeeTime> GetAvailableTeeTimeList(List <TeeTime> AvailableTeeTimeList, string Date) { SqlConnection SampleConnection = new SqlConnection(); SampleConnection.ConnectionString = connectionString; SampleConnection.Open(); SqlCommand SampleCommand = new SqlCommand(); SampleCommand.Connection = SampleConnection; SampleCommand.CommandType = CommandType.StoredProcedure; SampleCommand.CommandText = "GetTeeTime"; SqlParameter SampleCommandParameter = new SqlParameter { ParameterName = "@Date", SqlDbType = SqlDbType.VarChar, Direction = ParameterDirection.Input, SqlValue = Date }; SampleCommand.Parameters.Add(SampleCommandParameter); SqlDataReader SampleDataReader; SampleDataReader = SampleCommand.ExecuteReader(); if (SampleDataReader.HasRows) { while (SampleDataReader.Read()) { TeeTime BookedTeeTime = new TeeTime(); BookedTeeTime.Date = SampleDataReader["Date"].ToString(); BookedTeeTime.Teetime = SampleDataReader["Teetime"].ToString(); for (int i = 0; i < AvailableTeeTimeList.Count; i++) { if (AvailableTeeTimeList[i].Teetime == BookedTeeTime.Teetime) { AvailableTeeTimeList.Remove(AvailableTeeTimeList[i]); } } } } SampleDataReader.Close(); SampleConnection.Close(); return(AvailableTeeTimeList); }
public void OnGet() { AuthenticatedUser = ClubBaistUsers.GetUserFromUserName(User.Identity.Name); SelectedDate = DateTime.Parse(Request.Query["date"]); SelectedTime = DateTime.Parse(Request.Query["time"]); SelectedTeeTime = _requestDirector.FindTeeTime(SelectedDate, SelectedTime); ReservedGolfer1Name = SelectedTeeTime.Golfer1.FullName; ReservedGolfer2Name = SelectedTeeTime.Golfer2.FullName; ReservedGolfer3Name = SelectedTeeTime.Golfer3.FullName; ReservedGolfer4Name = SelectedTeeTime.Golfer4.FullName; ReservedGolfer1CheckedIn = SelectedTeeTime.Golfer1CheckedIn; ReservedGolfer2CheckedIn = SelectedTeeTime.Golfer2CheckedIn; ReservedGolfer3CheckedIn = SelectedTeeTime.Golfer3CheckedIn; ReservedGolfer4CheckedIn = SelectedTeeTime.Golfer4CheckedIn; }
public IEnumerable <TeeAssignInfo> getAll() { var TeeAssigns = _context.TeeAssign.Where(r => r.RecordStatus == RecordState.Active).OrderBy(r => r.Group).ThenBy(r => r.Order).ThenBy(r => r.TeeTimeId); List <TeeAssignInfo> TeeAssignInfos = new List <TeeAssignInfo>(); foreach (TeeAssign teeAssign in TeeAssigns) { Member member = _context.Member.FirstOrDefault(r => r.MemberId == teeAssign.MemberId); TeeTime teeTime = _context.TeeTime.FirstOrDefault(r => r.TeeTimeId == teeAssign.TeeTimeId); Course course = _context.Course.FirstOrDefault(r => r.CourseId == teeTime.CourseId); TeeAssignInfo teeAssignInfo = new TeeAssignInfo(teeAssign, teeTime, member, course); TeeAssignInfos.Add(teeAssignInfo); } return(TeeAssignInfos); }
public bool majorTourDay(DateTime dateTime) { bool rc = false; DateTime date = dateTime.Date; DateTime datePlus1 = date.AddDays(1); TeeTime teeTime = _context.TeeTime.FirstOrDefault(r => r.TeeTimeTS >= date && r.TeeTimeTS < datePlus1 && r.MajorTour == true); if (teeTime != null) { rc = true; } return(rc); }
public bool DeleteTeeTime(TeeTime teeTime, string user, string password) { bool success = false; TeeTime item = new TeeTime(); Console.WriteLine("Delete Tee Time "); Console.WriteLine(teeTime.TeeTimeDate); ConfigurationBuilder configurationBuilder = new ConfigurationBuilder(); configurationBuilder.SetBasePath(Directory.GetCurrentDirectory()); configurationBuilder.AddJsonFile("appsettings.json"); IConfiguration configuration = configurationBuilder.Build(); SqlConnection ClubBaistConnection = new SqlConnection(configuration.GetConnectionString("BAIS3230")); ClubBaistConnection.Open(); // SqlTransaction sqlTransaction = ClubBaistConnection.BeginTransaction(); SqlCommand BookTeeTimeCommand = new SqlCommand { Connection = ClubBaistConnection, CommandType = CommandType.StoredProcedure, CommandText = "DeleteTeeTime" }; SqlParameter ASampleCommandParameter = new SqlParameter { ParameterName = "@TeeTimeDateTime", SqlDbType = SqlDbType.DateTime, Direction = ParameterDirection.Input, SqlValue = teeTime.TeeTimeDate }; BookTeeTimeCommand.Parameters.Add(ASampleCommandParameter); try { BookTeeTimeCommand.ExecuteNonQuery(); } catch (Exception e) { Console.WriteLine($"Booking Tee Time Error - {e}"); success = false; } ClubBaistConnection.Close(); return(success); }
public TeeTime GetTeeTime(DateTime selectedTime, DateTime selectedDate) { var requestedTeeTime = new TeeTime(); using var connection = new SqlConnection(ConnectionString); using var command = new SqlCommand("GetTeeTimeByDateAndTime", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@Date", SqlDbType.VarChar).Value = selectedDate; command.Parameters.Add("@Time", SqlDbType.VarChar).Value = selectedTime; //Open the connection and execute the reader connection.Open(); var reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) // Mapping the program Object to Database { requestedTeeTime.Date = (DateTime)reader[0]; requestedTeeTime.Time = new DateTime(((TimeSpan)reader[1]).Ticks); requestedTeeTime.Golfer1 = !DBNull.Value.Equals(reader[2]) ? _userManager.GetUserFromId((string)reader[2]) : new Shareholder(); requestedTeeTime.Golfer2 = !DBNull.Value.Equals(reader[3]) ? _userManager.GetUserFromId((string)reader[3]) : new Shareholder(); requestedTeeTime.Golfer3 = !DBNull.Value.Equals(reader[4]) ? _userManager.GetUserFromId((string)reader[4]) : new Shareholder(); requestedTeeTime.Golfer4 = !DBNull.Value.Equals(reader[5]) ? _userManager.GetUserFromId((string)reader[5]) : new Shareholder(); requestedTeeTime.BookerId = !DBNull.Value.Equals(reader[6]) ? (string)reader[6] : " "; requestedTeeTime.Golfer1CheckedIn = (bool)reader[7]; requestedTeeTime.Golfer2CheckedIn = (bool)reader[8]; requestedTeeTime.Golfer3CheckedIn = (bool)reader[9]; requestedTeeTime.Golfer4CheckedIn = (bool)reader[10]; } } reader.Close(); return(requestedTeeTime); }
public void BookTeeTime(TeeTimeBooking teetime) { using (SquawCreekDeVryEntities db = new SquawCreekDeVryEntities()) { TeeTime tt = new TeeTime(); tt.BookedBy = teetime.BookedBy; tt.Cart = teetime.Cart; tt.Id = Guid.NewGuid(); tt.Member = teetime.Member; tt.NumberOfPlayers = teetime.NumberOfPlayers; tt.Paid = false; tt.ScheduleTime = teetime.ScheduledTime; tt.Created = DateTime.Now; db.TeeTimes.Add(tt); db.SaveChanges(); } }
public JsonResult SaveDataBookTeeTimeReservation(BookTeeTimeReservation objBoookstanding) { bool isStatus = false; string message = string.Empty; int hours = objBoookstanding.Hour; int minutes = objBoookstanding.Minute; if (objBoookstanding.AMorPM == "PM" && hours != 12) { hours += 12; } string datetime = objBoookstanding.Date; datetime += " " + hours.ToString() + ":" + minutes.ToString(); TeeTime NewTeeTime = new TeeTime(); DateTime DateT = DateTime.Parse(datetime); try { NewTeeTime = new TeeTime(DateT, DateT, Session["MemberName"].ToString(), objBoookstanding.MemberName2, objBoookstanding.MemberName3, objBoookstanding.MemberName4, Convert.ToInt32(Session["MemberNumber"]), objBoookstanding.NumberOfPlayers, objBoookstanding.PhoneNumber, Convert.ToInt32(objBoookstanding.NumberOfCarts), "N/A"); ClubBAISTRequestDirector CBRD = new ClubBAISTRequestDirector(); if (CBRD.ReserveTeeTime(NewTeeTime, Session["MembershipLevel"].ToString())) { isStatus = true; message = "Reservation was successfuly made."; } else { message = "Reservation could not be made."; } } catch (Exception ex) { return(Json(new { Status = isStatus, message = ex.Message.ToString() }, JsonRequestBehavior.AllowGet)); } return(Json(new { Status = isStatus, message = message }, JsonRequestBehavior.AllowGet)); }