public void GetInitialDailyTeeTimeSheet()
{
DailyTeeTimeSheet InitialTeeTime;
DateTime InitialTime = new DateTime(2020, 05, 01, 07, 00, 00);
InitialTeeTime = new DailyTeeTimeSheet();
InitialTeeTime.Teetime = InitialTime.ToString("HH:mm");
InitialDailyTeeTimeSheet.Add(InitialTeeTime);
for (int i = 1; i < 97; i++)
{
if (i % 2 > 0)
{
InitialTeeTime = new DailyTeeTimeSheet();
InitialTime = InitialTime.AddMinutes(7);
InitialTeeTime.Teetime = InitialTime.ToString("HH:mm");
InitialDailyTeeTimeSheet.Add(InitialTeeTime);
}
else
{
InitialTeeTime = new DailyTeeTimeSheet();
InitialTime = InitialTime.AddMinutes(8);
InitialTeeTime.Teetime = InitialTime.ToString("HH:mm");
InitialDailyTeeTimeSheet.Add(InitialTeeTime);
}
}
DailyTeeSheet = RequestDirector.GetDailyTeeTimeSheet(InitialDailyTeeTimeSheet, convertDate);
}
public bool UpdateTeeTime(DailyTeeTimeSheet DedesireTeeTime, List <TeeTimeMember> Members)
{
SqlConnection CSConnection = new SqlConnection();
CSConnection.ConnectionString = connectionString;
CSConnection.Open();
SqlCommand addTeeTime = new SqlCommand();
addTeeTime.CommandType = CommandType.StoredProcedure;
addTeeTime.Connection = CSConnection;
addTeeTime.CommandText = "UpdateTeeTime";
addTeeTime.Parameters.AddWithValue("@Date", DedesireTeeTime.Date);
addTeeTime.Parameters.AddWithValue("@Teetime", DedesireTeeTime.Teetime);
addTeeTime.Parameters.AddWithValue("@Phone", DedesireTeeTime.Phone);
addTeeTime.Parameters.AddWithValue("@NumberOfCarts", DedesireTeeTime.NumberOfCarts);
SqlParameter returnCode = new SqlParameter();
returnCode.ParameterName = "@ReturnCode";
returnCode.Direction = ParameterDirection.ReturnValue;
returnCode.SqlDbType = SqlDbType.Int;
addTeeTime.Parameters.Add(returnCode);
SqlDataReader DataReader;
DataReader = addTeeTime.ExecuteReader();
CSConnection.Close();
confirmation = (((int)returnCode.Value) == 0);
addTeeTimeMember(Members);
return(confirmation);
}
public void OnPostGetBookedTeeTime()
{
convertDate = DateTime.ParseExact(BookedDate, "yyyy-MM-dd", CultureInfo.InvariantCulture).ToString("MM/dd/yyyy", CultureInfo.InvariantCulture);
DailyTeeTimeSheet BookedTeeTimeInfo = new DailyTeeTimeSheet();
BookedTeeTimeInfo = RequestDirector.GetBookedTeeTime(BookedMemberNumber, convertDate, BookedTeeTime);
if (BookedTeeTimeInfo.Date == null)
{
DateFormMessage = "TeeTime Does not exist";
}
else
{
AList = BookedTeeTimeInfo.Teetime;
Member1Number = BookedTeeTimeInfo.Member1Number;
Member2Number = BookedTeeTimeInfo.Member2Number;
Member3Number = BookedTeeTimeInfo.Member3Number;
Member4Number = BookedTeeTimeInfo.Member4Number;
Phone = BookedTeeTimeInfo.Phone;
NumOfCarts = BookedTeeTimeInfo.NumberOfCarts;
Time = BookedTeeTimeInfo.Time;
GetAvilableTeeTimeForUpdate();
}
}
public List <DailyTeeTimeSheet> GetDailyTeeTimeSheet(List <DailyTeeTimeSheet> InitialDailyTeeTimeSheet, string Date)
{
SqlConnection SampleConnection = new SqlConnection();
SampleConnection.ConnectionString = connectionString;
SampleConnection.Open();
SqlCommand SampleCommand = new SqlCommand();
SampleCommand.Connection = SampleConnection;
SampleCommand.CommandType = CommandType.StoredProcedure;
SampleCommand.CommandText = "GetDailyTeeSheet";
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())
{
DailyTeeTimeSheet BookedTeeTime = new DailyTeeTimeSheet();
BookedTeeTime.Date = SampleDataReader["Date"].ToString();
BookedTeeTime.Teetime = SampleDataReader["Teetime"].ToString();
BookedTeeTime.Phone = SampleDataReader["Phone"].ToString();
BookedTeeTime.NumberOfCarts = int.Parse(SampleDataReader["NumberOfCarts"].ToString());
BookedTeeTime.Time = decimal.Parse(SampleDataReader["Time"].ToString());
BookedTeeTime.MemberName = SampleDataReader["MemberName"].ToString();
for (int i = 0; i < InitialDailyTeeTimeSheet.Count; i++)
{
if (BookedTeeTime.Teetime == InitialDailyTeeTimeSheet[i].Teetime)
{
InitialDailyTeeTimeSheet[i].Date = BookedTeeTime.Date;
InitialDailyTeeTimeSheet[i].Phone = BookedTeeTime.Phone;
InitialDailyTeeTimeSheet[i].NumberOfCarts = BookedTeeTime.NumberOfCarts;
InitialDailyTeeTimeSheet[i].Time = BookedTeeTime.Time;
InitialDailyTeeTimeSheet[i].MemberName = InitialDailyTeeTimeSheet[i].MemberName + BookedTeeTime.MemberName + ',';
InitialDailyTeeTimeSheet[i].NumberOfPlayer++;
}
}
}
}
SampleDataReader.Close();
SampleConnection.Close();
return(InitialDailyTeeTimeSheet);
}
public void AddTeeTime()
{
bool AllMemberQualified = true;
DailyTeeTimeSheet DedesireTeeTime = new DailyTeeTimeSheet();
DedesireTeeTime.Date = Date;
DedesireTeeTime.Teetime = AList;
DedesireTeeTime.Member1Number = Member1Number;
DedesireTeeTime.Member2Number = Member2Number;
DedesireTeeTime.Member3Number = Member3Number;
DedesireTeeTime.Member4Number = Member4Number;
DedesireTeeTime.Phone = Phone;
DedesireTeeTime.NumberOfCarts = NumOfCarts;
DedesireTeeTime.Time = Time;
List <TeeTimeMember> MemberList = new List <TeeTimeMember>();
TeeTimeMember member = new TeeTimeMember();
member.Date = DedesireTeeTime.Date;
member.Teetime = DedesireTeeTime.Teetime;
member.MemberNumber = DedesireTeeTime.Member1Number;
MemberList.Add(member);
if (Member2Number != null)
{
member = new TeeTimeMember();
member.Date = DedesireTeeTime.Date;
member.Teetime = DedesireTeeTime.Teetime;
member.MemberNumber = DedesireTeeTime.Member2Number;
MemberList.Add(member);
}
if (Member3Number != null)
{
member = new TeeTimeMember();
member.Date = DedesireTeeTime.Date;
member.Teetime = DedesireTeeTime.Teetime;
member.MemberNumber = DedesireTeeTime.Member3Number;
MemberList.Add(member);
}
if (Member4Number != null)
{
member = new TeeTimeMember();
member.Date = DedesireTeeTime.Date;
member.Teetime = DedesireTeeTime.Teetime;
member.MemberNumber = DedesireTeeTime.Member4Number;
MemberList.Add(member);
}
foreach (TeeTimeMember member1 in MemberList)
{
if (ISMemberNumberQualified(member1.MemberNumber) == false)
{
Message = "Number Number: " + member1.MemberNumber + " Not exist or not qualified; " + Message;
AllMemberQualified = false;
}
}
if (AllMemberQualified == true)
{
bool Confirmation = RequestDirector.AddTeeTime(DedesireTeeTime, MemberList);
if (Confirmation == true)
{
Message = "Successfully Booked TeeTime on " + Date + " at " + AList;
}
else
{
Message = "Booked TeeTime: Failed";
}
}
}
public DailyTeeTimeSheet GetBookedTeeTime(string MemberNumber, string Date, string TeeTime)
{
SqlConnection SampleConnection = new SqlConnection();
SampleConnection.ConnectionString = connectionString;
SampleConnection.Open();
SqlCommand GetTeeTime = new SqlCommand();
GetTeeTime.Connection = SampleConnection;
GetTeeTime.CommandType = CommandType.StoredProcedure;
GetTeeTime.CommandText = "GetBookedTeeTime";
GetTeeTime.Parameters.AddWithValue("@Date", Date);
GetTeeTime.Parameters.AddWithValue("@TeeTime", TeeTime);
GetTeeTime.Parameters.AddWithValue("@MemberNumber", MemberNumber);
SqlDataReader SampleDataReader;
SampleDataReader = GetTeeTime.ExecuteReader();
DailyTeeTimeSheet BookedTeeTime = new DailyTeeTimeSheet();
List <string> BookedMembers = new List <string>();
if (SampleDataReader.HasRows)
{
while (SampleDataReader.Read())
{
BookedTeeTime.Date = SampleDataReader["Date"].ToString();
BookedTeeTime.Teetime = SampleDataReader["Teetime"].ToString();
BookedTeeTime.Member1Number = SampleDataReader["MemberNumber"].ToString();
BookedTeeTime.Phone = SampleDataReader["Phone"].ToString();
BookedTeeTime.NumberOfCarts = int.Parse(SampleDataReader["NumberOfCarts"].ToString());
}
SampleDataReader.Close();
SqlCommand GetTeeTimeWithMembers = new SqlCommand();
GetTeeTimeWithMembers.Connection = SampleConnection;
GetTeeTimeWithMembers.CommandType = CommandType.StoredProcedure;
GetTeeTimeWithMembers.CommandText = "GetTeeTimeWithMembers";
GetTeeTimeWithMembers.Parameters.AddWithValue("@Date", Date);
GetTeeTimeWithMembers.Parameters.AddWithValue("@TeeTime", TeeTime);
SqlDataReader SampleDataReader2;
SampleDataReader2 = GetTeeTimeWithMembers.ExecuteReader();
if (SampleDataReader2.HasRows)
{
while (SampleDataReader2.Read())
{
BookedMembers.Add(SampleDataReader2["MemberNumber"].ToString());
}
}
int memberCount = BookedMembers.Count();
while (memberCount < 4)
{
BookedMembers.Add(null);
memberCount++;
}
BookedMembers.Remove(BookedTeeTime.Member1Number);
BookedTeeTime.Member2Number = BookedMembers[0];
BookedTeeTime.Member3Number = BookedMembers[1];
BookedTeeTime.Member4Number = BookedMembers[2];
SampleDataReader2.Close();
SampleConnection.Close();
}
else
{
SampleDataReader.Close();
SampleConnection.Close();
}
return(BookedTeeTime);
}
public void UpdateTeeTime()
{
bool AllMemberQualified = true;
DailyTeeTimeSheet DedesireTeeTime = new DailyTeeTimeSheet();
DedesireTeeTime.Date = DateTime.ParseExact(OriginalDate, "yyyy-MM-dd", CultureInfo.InvariantCulture).ToString("MM/dd/yyyy", CultureInfo.InvariantCulture);;
DedesireTeeTime.Teetime = AList;
DedesireTeeTime.Member1Number = Member1Number;
DedesireTeeTime.Member2Number = Member2Number;
DedesireTeeTime.Member3Number = Member3Number;
DedesireTeeTime.Member4Number = Member4Number;
DedesireTeeTime.Phone = Phone;
DedesireTeeTime.NumberOfCarts = NumOfCarts;
DedesireTeeTime.Time = Time;
List <TeeTimeMember> MemberList = new List <TeeTimeMember>();
TeeTimeMember member = new TeeTimeMember();
member.Date = DedesireTeeTime.Date;
member.Teetime = DedesireTeeTime.Teetime;
member.MemberNumber = DedesireTeeTime.Member1Number;
MemberList.Add(member);
if (Member2Number != null)
{
member = new TeeTimeMember();
member.Date = DedesireTeeTime.Date;
member.Teetime = DedesireTeeTime.Teetime;
member.MemberNumber = DedesireTeeTime.Member2Number;
MemberList.Add(member);
}
if (Member3Number != null)
{
member = new TeeTimeMember();
member.Date = DedesireTeeTime.Date;
member.Teetime = DedesireTeeTime.Teetime;
member.MemberNumber = DedesireTeeTime.Member3Number;
MemberList.Add(member);
}
if (Member4Number != null)
{
member = new TeeTimeMember();
member.Date = DedesireTeeTime.Date;
member.Teetime = DedesireTeeTime.Teetime;
member.MemberNumber = DedesireTeeTime.Member4Number;
MemberList.Add(member);
}
foreach (TeeTimeMember member1 in MemberList)
{
if (ISMemberNumberQualified(member1.MemberNumber) == false)
{
Message = "Number Number: " + member1.MemberNumber + " Not exist or not qualified; " + Message;
AllMemberQualified = false;
}
}
if (AllMemberQualified == true)
{
bool Confirmation = RequestDirector.UpdateTeeTime(DedesireTeeTime, MemberList);
if (Confirmation == true)
{
Message = "Successfully Modified TeeTime on " + DedesireTeeTime.Date + " at " + AList;
AList = null;
Member1Number = null;
Member2Number = null;
Member3Number = null;
Member4Number = null;
Phone = null;
NumOfCarts = 0;
}
else
{
Message = "Booked TeeTime: Failed";
}
}
}
