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