public DailyTeeSheet ViewDailyTeeSheet(DateTime date)
{
DailyTeeSheet dailyTeeSheet = new DailyTeeSheet();
TeeTimes dataManager = new TeeTimes();
dailyTeeSheet = dataManager.FindDailyTeeSheet(date);
return(dailyTeeSheet);
}
public DailyTeeSheet FindDailyTeeSheet(DateTime date)
{
SqlConnection clubbaistConnection = new SqlConnection();
clubbaistConnection.ConnectionString = Startup.ConnectionString;
SqlCommand findDailyTeeSheetCommand = new SqlCommand();
findDailyTeeSheetCommand.CommandType = CommandType.StoredProcedure;
findDailyTeeSheetCommand.Connection = clubbaistConnection;
findDailyTeeSheetCommand.CommandText = "FindDailyTeeSheet";
SqlParameter dailyTeeSheetdate = new SqlParameter();
dailyTeeSheetdate.ParameterName = "@Date";
dailyTeeSheetdate.SqlDbType = SqlDbType.Date;
dailyTeeSheetdate.Value = date;
dailyTeeSheetdate.Direction = ParameterDirection.Input;
SqlParameter returnCodeParameter = new SqlParameter();
returnCodeParameter.ParameterName = "@ReturnCode";
returnCodeParameter.SqlDbType = SqlDbType.Int;
returnCodeParameter.Direction = ParameterDirection.ReturnValue;
findDailyTeeSheetCommand.Parameters.Add(returnCodeParameter);
findDailyTeeSheetCommand.Parameters.Add(dailyTeeSheetdate);
DailyTeeSheet dailyTeeSheet = new DailyTeeSheet();
List <TeeTime> teeTimes = new List <TeeTime>();
try
{
clubbaistConnection.Open();
SqlDataReader reader;
reader = findDailyTeeSheetCommand.ExecuteReader();
var time = TimeSpan.FromHours(7);
for (var i = 0; i < 97; i++)
{
var teeTime = new TeeTime();
teeTime.Date = date;
teeTime.Time = time;
teeTime.Golfer1 = null;
teeTime.Golfer2 = null;
teeTime.Golfer3 = null;
teeTime.Golfer4 = null;
teeTimes.Add(teeTime);
if (i % 2 == 0)
{
time += TimeSpan.FromMinutes(7);
}
else
{
time += TimeSpan.FromMinutes(8);
}
}
while (reader.Read())
{
for (var i = 0; i < teeTimes.Count; i++)
{
if (teeTimes[i].Time.Equals(reader["Time"]))
{
teeTimes[i].Date = (DateTime)reader["Date"];
teeTimes[i].Time = (TimeSpan)reader["Time"];
teeTimes[i].Golfer1 = reader["Golfer1"] == DBNull.Value
? string.Empty
: reader["Golfer1"].ToString();
teeTimes[i].Golfer2 = reader["Golfer2"] == DBNull.Value
? string.Empty
: reader["Golfer2"].ToString();
teeTimes[i].Golfer3 = reader["Golfer3"] == DBNull.Value
? string.Empty
: reader["Golfer3"].ToString();
teeTimes[i].Golfer4 = reader["Golfer4"] == DBNull.Value
? string.Empty
: reader["Golfer4"].ToString();
}
}
}
dailyTeeSheet.TeeTimes = teeTimes;
dailyTeeSheet.Date = date;
clubbaistConnection.Close();
}
catch
{
}
return(dailyTeeSheet);
}
public void OnPost()
{
var selectedDate = DateTime.Parse(Request.Query["date"]);
RequestedDailyTeeSheet = _requestDirector.FindDailyTeeSheet(selectedDate, ClubBaistUsers.GetUserFromUserName(User.Identity.Name));
}
public IActionResult OnPostCreateTeeTime()
{
Confirmation = false;
CBS RequestDirector = new CBS();
int SelectTest = selectedGolferNumber;
Golfer selectedGolfer = new Golfer();
var tempGolfers = TempData.Get <List <Golfer> >("key");
foreach (var g in tempGolfers)
{
if (g.MemberNumber == selectedGolferNumber)
{
selectedGolfer = g;
}
}
DailyTeeSheet verifyTeeSheet = new DailyTeeSheet();
TeeTime newTeeTime = new TeeTime();
TimeSpan time = Convert.ToDateTime(selectedTime).TimeOfDay;
if (User.Identity.Name == "Club Clerk" || User.Identity.Name == "Club ProShop")
{
newTeeTime.CreatedBy = selectedGolfer.MemberNumber;
}
else
{
Int32.TryParse(User.Claims.SingleOrDefault(c => c.Type == "MemberNumber").Value, out int createdBy);
newTeeTime.CreatedBy = createdBy;
}
if (User.Identity.Name == "Club Clerk" || User.Identity.Name == "Club ProShop")
{
newTeeTime.Golfer1 = selectedGolfer.FirstName + " " + selectedGolfer.LastName;
}
else
{
newTeeTime.Golfer1 = User.Identity.Name;
}
newTeeTime.Date = selectedDateTemp;
newTeeTime.Time = time;
newTeeTime.Golfer2 = Golfer2;
newTeeTime.Golfer3 = Golfer3;
newTeeTime.Golfer4 = Golfer4;
Confirmation = RequestDirector.CreateTeeTime(newTeeTime);
if (Confirmation)
{
TempData["Alert"] = $"Successfully Created Tee Time";
return(RedirectToPage("/Index"));
}
else
{
TempData["Danger"] = true;
Alert = $"Could Not Create Tee Time";
dailyTeeSheet = null;
}
return(Page());
}
