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