public TeeTime GetTeeTime(DateTime RequestedDate, DateTime timeslot)
{
SqlConnection ClubBaistConnection = new SqlConnection();
ClubBaistConnection.ConnectionString = @"Data Source= (LocalDB)\MSSQLLocalDB;
Initial Catalog = aspnet-ClubBaistGolfManagement-53bc9b9d-9d6a-45d4-8429-2a2761773502;
Integrated Security = True; MultipleActiveResultSets=True";
SqlCommand thecommand = new SqlCommand();
thecommand.CommandType = CommandType.StoredProcedure;
thecommand.Connection = ClubBaistConnection;
thecommand.CommandText = "FindTeeTime";
SqlParameter date = new SqlParameter();
date.ParameterName = "@date";
date.SqlDbType = SqlDbType.DateTime;
date.Value = RequestedDate;
date.Direction = ParameterDirection.Input;
thecommand.Parameters.Add(date);
SqlParameter time = new SqlParameter();
time.ParameterName = "@time";
time.SqlDbType = SqlDbType.DateTime;
time.Value = timeslot;
time.Direction = ParameterDirection.Input;
thecommand.Parameters.Add(time);
ClubBaistConnection.Open();
SqlDataReader theDataReader;
theDataReader = thecommand.ExecuteReader();
TeeTime requestedteetime = new TeeTime();
if (theDataReader.HasRows)
{
while (theDataReader.Read())
{
requestedteetime.Date = DateTime.Parse(theDataReader["Date"].ToString());
requestedteetime.TimeSlot = DateTime.Parse(theDataReader["TimeSlot"].ToString());
requestedteetime.Player1 = !DBNull.Value.Equals(theDataReader["Player1Number"]) ? (Player)UserManager.GetUser((String)theDataReader["Player1Number"]) : new Shareholder();
requestedteetime.Player2 = !DBNull.Value.Equals(theDataReader["Player2Number"]) ? (Player)UserManager.GetUser((String)theDataReader["Player2Number"]) : new Shareholder();
requestedteetime.Player3 = !DBNull.Value.Equals(theDataReader["Player3Number"]) ? (Player)UserManager.GetUser((String)theDataReader["Player3Number"]) : new Shareholder();
requestedteetime.Player4 = !DBNull.Value.Equals(theDataReader["Player4Number"]) ? (Player)UserManager.GetUser((String)theDataReader["Player4Number"]) : new Shareholder();
requestedteetime.BookerNumber = theDataReader["BookerNumber"].ToString();
requestedteetime.Player1CheckedIn = bool.Parse(theDataReader["Player1CheckedIn"].ToString());
requestedteetime.Player2CheckedIn = bool.Parse(theDataReader["Player2CheckedIn"].ToString());
requestedteetime.Player3CheckedIn = bool.Parse(theDataReader["Player3CheckedIn"].ToString());
requestedteetime.Player4CheckedIn = bool.Parse(theDataReader["Player4CheckedIn"].ToString());
}
}
theDataReader.Close();
ClubBaistConnection.Close();
return(requestedteetime);
}
public StandingTeeTimeRequest GetReservedStandingTeeTime(string DayOfWeek, DateTime requestedTime,
DateTime requestedStartDate, DateTime requestedEndDate)
{
StandingTeeTimeRequest standingteetimerequest = new StandingTeeTimeRequest();
SqlConnection ClubBaistConnection = new SqlConnection();
ClubBaistConnection.ConnectionString = @"Data Source= (LocalDB)\MSSQLLocalDB;
Initial Catalog = aspnet-ClubBaistGolfManagement-53bc9b9d-9d6a-45d4-8429-2a2761773502;
Integrated Security = True; MultipleActiveResultSets=True";
SqlCommand thecommand = new SqlCommand();
thecommand.CommandType = CommandType.StoredProcedure;
thecommand.Connection = ClubBaistConnection;
thecommand.CommandText = "GetReservedStandingTeeTime";
SqlParameter day = new SqlParameter();
day.ParameterName = "@dayofweek";
day.SqlDbType = SqlDbType.VarChar;
day.Value = DayOfWeek;
day.Direction = ParameterDirection.Input;
thecommand.Parameters.Add(day);
SqlParameter time = new SqlParameter();
time.ParameterName = "@time";
time.SqlDbType = SqlDbType.Time;
time.Value = requestedTime;
time.Direction = ParameterDirection.Input;
thecommand.Parameters.Add(time);
SqlParameter startDate = new SqlParameter();
startDate.ParameterName = "@startDate";
startDate.SqlDbType = SqlDbType.Date;
startDate.Value = requestedStartDate;
startDate.Direction = ParameterDirection.Input;
thecommand.Parameters.Add(startDate);
SqlParameter endDate = new SqlParameter();
endDate.ParameterName = "@endDate";
endDate.SqlDbType = SqlDbType.Date;
endDate.Value = requestedEndDate;
endDate.Direction = ParameterDirection.Input;
thecommand.Parameters.Add(endDate);
ClubBaistConnection.Open();
SqlDataReader theDataReader;
theDataReader = thecommand.ExecuteReader();
CBSUsers UserManager = new CBSUsers();
if (theDataReader.HasRows)
{
while (theDataReader.Read())
{
standingteetimerequest.RequestedTime = DateTime.Parse(theDataReader["RequestedTeeTime"].ToString());
standingteetimerequest.DayofWeek = theDataReader["DayofWeek"].ToString();
standingteetimerequest.RequestedEndDate = DateTime.Parse(theDataReader["RequestedEndDate"].ToString());
standingteetimerequest.Shareholder1 = !string.IsNullOrEmpty(theDataReader["Shareholder1Number"].ToString())
? UserManager.GetUser((string)(theDataReader["Shareholder1Number"]))
: new Shareholder();
standingteetimerequest.Shareholder2 = !string.IsNullOrEmpty(theDataReader["Shareholder2Number"].ToString())
? UserManager.GetUser((string)(theDataReader["Shareholder2Number"]))
: new Shareholder();
standingteetimerequest.Shareholder3 = !string.IsNullOrEmpty(theDataReader["Shareholder3Number"].ToString())
? UserManager.GetUser((string)(theDataReader["Shareholder3Number"]))
: new Shareholder();
standingteetimerequest.Shareholder4 = !string.IsNullOrEmpty(theDataReader["Shareholder4Number"].ToString())
? UserManager.GetUser((string)(theDataReader["Shareholder4Number"]))
: new Shareholder();
}
theDataReader.Close();
ClubBaistConnection.Close();
}
return(standingteetimerequest);
}