public bool CreateStandingTeeTimeRequest(StandingTeeTime request) { bool Confirmation = false; StandingTeeTimes dataManager = new StandingTeeTimes(); Confirmation = dataManager.CreateStandingTeeTimeRequest(request); return(Confirmation); }
public IActionResult OnPost() { Confirmation = false; StandingTeeTime request = new StandingTeeTime(); if (ModelState.IsValid) { CBS RequestDirector = new CBS(); DateTime.TryParse(StartDate, out DateTime startDate); DateTime.TryParse(EndDate, out DateTime endDate); TimeSpan time = Convert.ToDateTime(Time).TimeOfDay; int memberNumber1; int memberNumber2; int memberNumber3; int memberNumber4; int.TryParse(MemberNumber1, out memberNumber1); int.TryParse(MemberNumber2, out memberNumber2); int.TryParse(MemberNumber3, out memberNumber3); int.TryParse(MemberNumber4, out memberNumber4); request.MemberNumber1 = memberNumber1; request.MemberNumber2 = memberNumber2; request.MemberNumber3 = memberNumber3; request.MemberNumber4 = memberNumber4; request.MemberName1 = MemberName1; request.MemberName2 = MemberName2; request.MemberName3 = MemberName3; request.MemberName4 = MemberName4; request.DayOfWeek = startDate; request.Time = time; request.StartDate = startDate; request.EndDate = endDate; Confirmation = RequestDirector.CreateStandingTeeTimeRequest(request); if (Confirmation) { TempData["Alert"] = $"Successfully Created Standing Tee Time Request"; return(RedirectToPage("/Index")); } else { TempData["Danger"] = true; Alert = $"Could Not Create Standing Tee Time Request"; } } return(Page()); }
public IActionResult OnPostCancel() { FoundStandingTeeTime = HttpContext.Session.Get <StandingTeeTime>(nameof(FoundStandingTeeTime)); Domain.CBS requestDirector = new Domain.CBS(Startup.ConnectionString); if (requestDirector.CancelStandingTeeTime(FoundStandingTeeTime.StartDate, FoundStandingTeeTime.EndDate, FoundStandingTeeTime.RequestedTime)) { HttpContext.Session.SetString("success", "Standing tee time request cancelled succcessfully"); } else { HttpContext.Session.SetString("danger", "Standing tee time request could not be cancelled"); } return(LocalRedirect("/")); }
public void OnPost() { bool confirm = false; CBS systemControl = new CBS(); string[] subs = Submit.Split(' '); switch (subs[0]) { case "Cancel": StandingTeeTime teeTime = new StandingTeeTime(); teeTime.StandingTeeTimeID = int.Parse(subs[1]); teeTime.IsCancelled = true; confirm = systemControl.ModifyStandingTeeTime(teeTime); break; } _sampleObjectCollection = systemControl.GetStandingTeeTimeList(); }
public List <StandingTeeTime> GetStandingRequests() { 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 = "GetStandingRequests"; getTeeTimesCommand.CommandType = CommandType.StoredProcedure; List <StandingTeeTime> teeTimeRequests = new List <StandingTeeTime>(); SqlDataReader dbReader = getTeeTimesCommand.ExecuteReader(); if (dbReader.HasRows) { while (dbReader.Read()) { StandingTeeTime teetimeRequest = new StandingTeeTime(); string id = dbReader["StandingTeeTimeID"].ToString(); teetimeRequest.StandingTeeTimeID = int.Parse(id); teetimeRequest.StartDate = Convert.ToDateTime(dbReader["StartDate"].ToString()); teetimeRequest.EndDate = Convert.ToDateTime(dbReader["EndDate"].ToString()); teetimeRequest.TeeTimeTime = Convert.ToDateTime(dbReader["TeeTimeTime"].ToString()); teetimeRequest.Approved = (bool)dbReader["Approved"]; teeTimeRequests.Add(teetimeRequest); } } dbConnection.Close(); return(teeTimeRequests); }
public void OnPost() { // Message = "OnPost"; if (ModelState.IsValid) { bool Confirmation; StandingTeeTime newStandingTeeTimeRequest = new StandingTeeTime { ShareHolderNumber = Member1NumField, MemberNumber2 = Member2NumField, MemberNumber3 = Member3NumField, MemberNumber4 = Member4NumField, ShareHolderName = Member1NameField, Member2Name = Member2NameField, Member3Name = Member3NameField, Member4Name = Member4NameField, DateStart = StartDateField, DateEnd = EndDateField, TeeTimeTime = TeeTimeTimeField, RequestedDayOfWeek = Convert.ToInt32(DayOfWeek) + 1 }; CBS RequestDirector = new CBS(); Confirmation = RequestDirector.InsertStandingTeeTimeRequest(newStandingTeeTimeRequest); if (Confirmation == false) { Message = $"Successfully added Standing Tee Time Request for {Member1NameField}"; } else { Message = $"Error adding Standing Tee Time Request for {Member1NameField}"; } } else { Message = $"Not Valid"; } }
public List <StandingTeeTime> GetStandingTeeTimeRequests(string user, string password) { List <StandingTeeTime> standingTeeTimeRequests; 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(); SqlCommand UpdateMACommand = new SqlCommand(); SqlCommand MACommand = new SqlCommand { Connection = ClubBaistConnection, CommandType = CommandType.StoredProcedure, CommandText = "GetStandingTeeTimes" }; SqlDataReader ApplicationReader; ApplicationReader = MACommand.ExecuteReader(); standingTeeTimeRequests = new List <StandingTeeTime>(); if (ApplicationReader.HasRows) { Console.WriteLine("Columns:"); Console.WriteLine("--------"); for (int index = 0; index < ApplicationReader.FieldCount; index++) { Console.WriteLine(ApplicationReader.GetName(index)); } Console.WriteLine("Values:"); Console.WriteLine("-------"); for (int index = 0; index < ApplicationReader.FieldCount; index++) { while (ApplicationReader.Read()) { StandingTeeTime tee = new StandingTeeTime(); tee.StandingTeeTimeID = int.Parse(ApplicationReader.GetValue("StandingTeeTimeID").ToString()); tee.ShareHolderNumber = int.Parse(ApplicationReader.GetValue("ShareHolderNumber").ToString()); tee.MemberNumber2 = int.Parse(ApplicationReader.GetValue("MemberNumber2").ToString()); tee.MemberNumber3 = int.Parse(ApplicationReader.GetValue("MemberNumber3").ToString()); tee.MemberNumber4 = int.Parse(ApplicationReader.GetValue("MemberNumber4").ToString()); tee.ShareHolderName = ApplicationReader.GetValue("ShareholderName").ToString(); tee.Member2Name = ApplicationReader.GetValue("MemberName2").ToString(); tee.Member3Name = ApplicationReader.GetValue("MemberName3").ToString(); tee.Member4Name = ApplicationReader.GetValue("MemberName4").ToString(); tee.DateStart = DateTime.Parse(ApplicationReader.GetValue("StartDate").ToString()); tee.DateEnd = DateTime.Parse(ApplicationReader.GetValue("EndDate").ToString()); tee.TeeTimeTime = DateTime.Parse(ApplicationReader.GetValue("TeeTimeTime").ToString()); tee.RequestedDayOfWeek = int.Parse(ApplicationReader.GetValue("RequestedDayOfWeek").ToString()); tee.RequestedDayOfWeek = tee.RequestedDayOfWeek - 1; tee.IsApproved = bool.Parse(ApplicationReader.GetValue("IsApproved").ToString()); standingTeeTimeRequests.Add(tee); } } } ApplicationReader.Close(); ClubBaistConnection.Close(); return(standingTeeTimeRequests); }
public bool ModifyStandingTeeTimeRequest(StandingTeeTime newStandingTeeTimeRequest, string user, string password) { bool sqlError = false; Console.WriteLine("ModifyStandingTeeTime"); 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(); SqlCommand addStandingTeeTimeRequestCommand = new SqlCommand() { CommandText = "ModifyStandingTeeTime", CommandType = CommandType.StoredProcedure, Connection = ClubBaistConnection, }; SqlParameter StandingTeeTimeIDParam = new SqlParameter() { Direction = ParameterDirection.Input, ParameterName = "@StandingTeeTimeID", SqlDbType = SqlDbType.Int, SqlValue = newStandingTeeTimeRequest.StandingTeeTimeID }; addStandingTeeTimeRequestCommand.Parameters.Add(StandingTeeTimeIDParam); SqlParameter ShareHolderNumberParam = new SqlParameter() { Direction = ParameterDirection.Input, ParameterName = "@ShareHolderNumber", SqlDbType = SqlDbType.Int, SqlValue = newStandingTeeTimeRequest.ShareHolderNumber }; addStandingTeeTimeRequestCommand.Parameters.Add(ShareHolderNumberParam); SqlParameter MemberNumber2Param = new SqlParameter() { Direction = ParameterDirection.Input, ParameterName = "@MemberNumber2", SqlDbType = SqlDbType.Int, SqlValue = newStandingTeeTimeRequest.MemberNumber2 }; addStandingTeeTimeRequestCommand.Parameters.Add(MemberNumber2Param); SqlParameter MemberNumber3Param = new SqlParameter() { Direction = ParameterDirection.Input, ParameterName = "@MemberNumber3", SqlDbType = SqlDbType.Int, SqlValue = newStandingTeeTimeRequest.MemberNumber3 }; addStandingTeeTimeRequestCommand.Parameters.Add(MemberNumber3Param); SqlParameter MemberNumber4Param = new SqlParameter() { Direction = ParameterDirection.Input, ParameterName = "@MemberNumber4", SqlDbType = SqlDbType.Int, SqlValue = newStandingTeeTimeRequest.MemberNumber4 }; addStandingTeeTimeRequestCommand.Parameters.Add(MemberNumber4Param); SqlParameter ShareHolderNameParam = new SqlParameter() { Direction = ParameterDirection.Input, ParameterName = "@ShareHolderName", SqlDbType = SqlDbType.NVarChar, SqlValue = newStandingTeeTimeRequest.ShareHolderName }; addStandingTeeTimeRequestCommand.Parameters.Add(ShareHolderNameParam); SqlParameter Member2NameParam = new SqlParameter() { Direction = ParameterDirection.Input, ParameterName = "@Member2Name", SqlDbType = SqlDbType.NVarChar, SqlValue = newStandingTeeTimeRequest.Member2Name }; addStandingTeeTimeRequestCommand.Parameters.Add(Member2NameParam); SqlParameter Member3NameParam = new SqlParameter() { Direction = ParameterDirection.Input, ParameterName = "@Member3Name", SqlDbType = SqlDbType.NVarChar, SqlValue = newStandingTeeTimeRequest.Member3Name }; addStandingTeeTimeRequestCommand.Parameters.Add(Member3NameParam); SqlParameter Member4NameParam = new SqlParameter() { Direction = ParameterDirection.Input, ParameterName = "@Member4Name", SqlDbType = SqlDbType.NVarChar, SqlValue = newStandingTeeTimeRequest.Member4Name }; addStandingTeeTimeRequestCommand.Parameters.Add(Member4NameParam); SqlParameter StartDateParam = new SqlParameter() { Direction = ParameterDirection.Input, ParameterName = "@StartDate", SqlDbType = SqlDbType.Date, SqlValue = newStandingTeeTimeRequest.DateStart.Date }; addStandingTeeTimeRequestCommand.Parameters.Add(StartDateParam); SqlParameter EndDateParam = new SqlParameter() { Direction = ParameterDirection.Input, ParameterName = "@EndDate", SqlDbType = SqlDbType.Date, SqlValue = newStandingTeeTimeRequest.DateEnd.Date }; addStandingTeeTimeRequestCommand.Parameters.Add(EndDateParam); SqlParameter TeeTimeTimeParam = new SqlParameter() { Direction = ParameterDirection.Input, ParameterName = "@TeeTimeTime", SqlDbType = SqlDbType.Time, SqlValue = newStandingTeeTimeRequest.TeeTimeTime.TimeOfDay }; addStandingTeeTimeRequestCommand.Parameters.Add(TeeTimeTimeParam); SqlParameter EmployeeNameParam = new SqlParameter() { Direction = ParameterDirection.Input, ParameterName = "@EmployeeName", SqlDbType = SqlDbType.NVarChar, SqlValue = newStandingTeeTimeRequest.EmployeeName }; addStandingTeeTimeRequestCommand.Parameters.Add(EmployeeNameParam); SqlParameter RequestedDayOfWeekParam = new SqlParameter() { Direction = ParameterDirection.Input, ParameterName = "@RequestedDayofWeek", SqlDbType = SqlDbType.Int, SqlValue = newStandingTeeTimeRequest.RequestedDayOfWeek }; addStandingTeeTimeRequestCommand.Parameters.Add(RequestedDayOfWeekParam); SqlParameter EmployeeNumberParam = new SqlParameter() { Direction = ParameterDirection.Input, ParameterName = "@EmployeeNumber", SqlDbType = SqlDbType.Int, SqlValue = newStandingTeeTimeRequest.EmployeeNumber }; addStandingTeeTimeRequestCommand.Parameters.Add(EmployeeNumberParam); SqlParameter IsCancelledParam = new SqlParameter() { Direction = ParameterDirection.Input, ParameterName = "@IsCancelled", SqlDbType = SqlDbType.Bit, SqlValue = newStandingTeeTimeRequest.IsCancelled }; addStandingTeeTimeRequestCommand.Parameters.Add(IsCancelledParam); SqlParameter IsApprovedParam = new SqlParameter() { Direction = ParameterDirection.Input, ParameterName = "@IsApproved", SqlDbType = SqlDbType.Bit, SqlValue = newStandingTeeTimeRequest.IsApproved }; addStandingTeeTimeRequestCommand.Parameters.Add(IsApprovedParam); try { addStandingTeeTimeRequestCommand.ExecuteNonQuery(); } catch (Exception e) { Console.WriteLine($"addStandingTeeTimeRequest Error - {e}"); sqlError = true; } ClubBaistConnection.Close(); return(sqlError); }
public void OnGet() { Domain.CBS requestDirector = new Domain.CBS(Startup.ConnectionString); FoundStandingTeeTime = requestDirector.FindStandingTeeTimeRequest(userManager.GetUserId(User)); HttpContext.Session.Put(nameof(FoundStandingTeeTime), FoundStandingTeeTime); }
public IActionResult OnPostSubmit() { Domain.CBS requestDirector = new Domain.CBS(Startup.ConnectionString); if (requestDirector.FindStandingTeeTimeRequest(userManager.GetUserId(User)) != null) { return(Redirect("/MaxStandingTeeTimeRequest")); } ErrorMessages.Clear(); bool isError = false; var errors = from error in ModelState where (error.Key == nameof(SuppliedMemberNumbers) || error.Key == nameof(StartDate) || error.Key == nameof(EndDate)) && error.Value.ValidationState == Microsoft.AspNetCore.Mvc.ModelBinding.ModelValidationState.Invalid && error.Value.Errors.Any() select error.Value.Errors; if (errors.Any()) { ErrorMessages.AddRange(from errorMessage in errors select errorMessage into messages from m in messages select m.ErrorMessage); isError = true; } var signedInMember = userManager.FindByNameAsync(User.Identity.Name).GetAwaiter().GetResult(); requestDirector = new Domain.CBS(signedInMember.Id, Startup.ConnectionString); StartDate = (DateTime)TempData.Peek(nameof(StartDate)); EndDate = (DateTime)TempData.Peek(nameof(EndDate)); StandingTeeTime requestedStandingTeeTime = new StandingTeeTime() { StartDate = StartDate, EndDate = EndDate, RequestedTime = DateTime.Parse(TempData.Peek("selectedTime").ToString()) }; SuppliedMemberNumbers = SuppliedMemberNumbers.Where(s => !string.IsNullOrEmpty(s)).ToArray(); for (int i = 0; i < SuppliedMemberNumbers.Length; i++) { SuppliedMemberNumbers[i] = SuppliedMemberNumbers[i].Trim(); } var userIds = (from user in dbContext.Users where SuppliedMemberNumbers.Contains(user.MemberNumber) select user.Id).ToList(); if (userIds.Count() != SuppliedMemberNumbers.Count()) { ErrorMessages.Add("One or more supplied member numbers do not exist"); isError = true; } if (SuppliedMemberNumbers.Contains(signedInMember.MemberNumber)) { ErrorMessages.Add("Do not enter your own member number"); isError = true; } if (StartDate.DayOfWeek != EndDate.DayOfWeek) { ErrorMessages.Add($"Day of week for start date ({StartDate.DayOfWeek}) must match day of week for end date ({EndDate.DayOfWeek})"); isError = true; } string currentUser = userManager.GetUserId(User); requestedStandingTeeTime.Members = userIds.Append(currentUser).ToList(); requestedStandingTeeTime.SubmittedBy = userManager.GetUserId(User); if (isError) { TempData.Put(nameof(ErrorMessages), ErrorMessages); return(Redirect(Request.Headers["Referer"])); } if (!requestDirector.RequestStandingTeeTime(requestedStandingTeeTime, out string message)) { ErrorMessages.Add(message); TempData.Put(nameof(ErrorMessages), ErrorMessages); return(Redirect(Request.Headers["Referer"])); } Confirmation = true; return(Page()); }
public StandingTeeTime FindStandingTeeTimeRequest(int MemberNumber) { SqlConnection clubbaistConnection = new SqlConnection(); clubbaistConnection.ConnectionString = Startup.ConnectionString; SqlCommand FindStandingTeeTimeRequestCommand = new SqlCommand(); FindStandingTeeTimeRequestCommand.CommandType = CommandType.StoredProcedure; FindStandingTeeTimeRequestCommand.Connection = clubbaistConnection; FindStandingTeeTimeRequestCommand.CommandText = "FindStandingTeeTimeRequest"; SqlParameter memberNumberParameter = new SqlParameter(); memberNumberParameter.ParameterName = "@MemberNumber1"; memberNumberParameter.SqlDbType = SqlDbType.Int; memberNumberParameter.Value = MemberNumber; SqlParameter ReturnCodeParameter = new SqlParameter(); ReturnCodeParameter.ParameterName = "@ReturnCode"; ReturnCodeParameter.SqlDbType = SqlDbType.Int; ReturnCodeParameter.Direction = ParameterDirection.ReturnValue; FindStandingTeeTimeRequestCommand.Parameters.Add(memberNumberParameter); FindStandingTeeTimeRequestCommand.Parameters.Add(ReturnCodeParameter); StandingTeeTime Request = new StandingTeeTime(); try { clubbaistConnection.Open(); SqlDataReader reader; reader = FindStandingTeeTimeRequestCommand.ExecuteReader(); while (reader.Read()) { Request.StandingTeeTimeID = (int)reader["StandingTeeTimeID"]; Request.DayOfWeek = (DateTime)reader["DayOfWeek"]; Request.EndDate = (DateTime)reader["EndDate"]; Request.MemberName1 = reader["MemberName1"].ToString(); Request.MemberName2 = reader["MemberName2"].ToString(); Request.MemberName3 = reader["MemberName3"].ToString(); Request.MemberName4 = reader["MemberName4"].ToString(); Request.MemberNumber1 = (int)reader["MemberNumber1"]; Request.MemberNumber2 = (int)reader["MemberNumber2"]; Request.MemberNumber3 = (int)reader["MemberNumber3"]; Request.MemberNumber4 = (int)reader["MemberNumber4"]; Request.StartDate = (DateTime)reader["StartDate"]; Request.EndDate = (DateTime)reader["EndDate"]; Request.Time = (TimeSpan)reader["Time"]; } clubbaistConnection.Close(); } catch { } return(Request); }
public bool CreateStandingTeeTimeRequest(StandingTeeTime request) { bool Success = false; SqlConnection clubbaistConnection = new SqlConnection(); clubbaistConnection.ConnectionString = Startup.ConnectionString; SqlCommand CreateStandingTeeTimeRequestCommand = new SqlCommand(); CreateStandingTeeTimeRequestCommand.CommandType = CommandType.StoredProcedure; CreateStandingTeeTimeRequestCommand.Connection = clubbaistConnection; CreateStandingTeeTimeRequestCommand.CommandText = "CreateStandingTeeTimeRequest"; SqlParameter memberNumber1Parameter = new SqlParameter(); memberNumber1Parameter.ParameterName = "@MemberNumber1"; memberNumber1Parameter.SqlDbType = SqlDbType.Int; memberNumber1Parameter.Value = request.MemberNumber1; SqlParameter memberNumber2Parameter = new SqlParameter(); memberNumber2Parameter.ParameterName = "@MemberNumber2"; memberNumber2Parameter.SqlDbType = SqlDbType.Int; memberNumber2Parameter.Value = request.MemberNumber2; SqlParameter memberNumber3Parameter = new SqlParameter(); memberNumber3Parameter.ParameterName = "@MemberNumber3"; memberNumber3Parameter.SqlDbType = SqlDbType.Int; memberNumber3Parameter.Value = request.MemberNumber3; SqlParameter memberNumber4Parameter = new SqlParameter(); memberNumber4Parameter.ParameterName = "@MemberNumber4"; memberNumber4Parameter.SqlDbType = SqlDbType.Int; memberNumber4Parameter.Value = request.MemberNumber4; SqlParameter memberName1Parameter = new SqlParameter(); memberName1Parameter.ParameterName = "@MemberName1"; memberName1Parameter.SqlDbType = SqlDbType.NVarChar; memberName1Parameter.Value = request.MemberName1; SqlParameter memberName2Parameter = new SqlParameter(); memberName2Parameter.ParameterName = "@MemberName2"; memberName2Parameter.SqlDbType = SqlDbType.NVarChar; memberName2Parameter.Value = request.MemberName2; SqlParameter memberName3Parameter = new SqlParameter(); memberName3Parameter.ParameterName = "@MemberName3"; memberName3Parameter.SqlDbType = SqlDbType.NVarChar; memberName3Parameter.Value = request.MemberName3; SqlParameter memberName4Parameter = new SqlParameter(); memberName4Parameter.ParameterName = "@MemberName4"; memberName4Parameter.SqlDbType = SqlDbType.NVarChar; memberName4Parameter.Value = request.MemberName4; SqlParameter dayOfWeekParameter = new SqlParameter(); dayOfWeekParameter.ParameterName = "@DayOfWeek"; dayOfWeekParameter.SqlDbType = SqlDbType.DateTime; dayOfWeekParameter.Value = request.DayOfWeek; SqlParameter timeParameter = new SqlParameter(); timeParameter.ParameterName = "@Time"; timeParameter.SqlDbType = SqlDbType.Time; timeParameter.Value = request.Time; SqlParameter startDateParameter = new SqlParameter(); startDateParameter.ParameterName = "@StartDate"; startDateParameter.SqlDbType = SqlDbType.DateTime; startDateParameter.Value = request.StartDate; SqlParameter endDateParameter = new SqlParameter(); endDateParameter.ParameterName = "@EndDate"; endDateParameter.SqlDbType = SqlDbType.DateTime; endDateParameter.Value = request.EndDate; SqlParameter ReturnCodeParameter = new SqlParameter(); ReturnCodeParameter.ParameterName = "@ReturnCode"; ReturnCodeParameter.SqlDbType = SqlDbType.Int; ReturnCodeParameter.Direction = ParameterDirection.ReturnValue; CreateStandingTeeTimeRequestCommand.Parameters.Add(memberNumber1Parameter); CreateStandingTeeTimeRequestCommand.Parameters.Add(memberNumber2Parameter); CreateStandingTeeTimeRequestCommand.Parameters.Add(memberNumber3Parameter); CreateStandingTeeTimeRequestCommand.Parameters.Add(memberNumber4Parameter); CreateStandingTeeTimeRequestCommand.Parameters.Add(memberName1Parameter); CreateStandingTeeTimeRequestCommand.Parameters.Add(memberName2Parameter); CreateStandingTeeTimeRequestCommand.Parameters.Add(memberName3Parameter); CreateStandingTeeTimeRequestCommand.Parameters.Add(memberName4Parameter); CreateStandingTeeTimeRequestCommand.Parameters.Add(dayOfWeekParameter); CreateStandingTeeTimeRequestCommand.Parameters.Add(timeParameter); CreateStandingTeeTimeRequestCommand.Parameters.Add(startDateParameter); CreateStandingTeeTimeRequestCommand.Parameters.Add(endDateParameter); CreateStandingTeeTimeRequestCommand.Parameters.Add(ReturnCodeParameter); try { clubbaistConnection.Open(); CreateStandingTeeTimeRequestCommand.ExecuteNonQuery(); int returnValue = (int)ReturnCodeParameter.Value; if (returnValue == 0) { Success = true; } clubbaistConnection.Close(); } catch { Success = false; } return(Success); }
public bool RequestStandingTeeTime(StandingTeeTime requestedStandingTeeTime, out string message) { StandingTeeTimeRequests standingTeeTimeManager = new StandingTeeTimeRequests(connectionString); return(standingTeeTimeManager.RequestStandingTeeTime(requestedStandingTeeTime, out message)); }