public string AddReserveDetails(ReservationDetails res) { string msg; SqlConnection con = new SqlConnection(connString); con.Open(); SqlCommand command = new SqlCommand("Main.AddReservationDetailsAndUpdateCourtSchedule", con); command.CommandType = CommandType.StoredProcedure; var date = DateTime.Now; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@sched", SqlDbType.NVarChar, 50).Value = res.schedId.ToDbParameter(); command.Parameters.Add("@user", SqlDbType.NVarChar, 15).Value = res.userId.ToDbParameter(); command.Parameters.AddWithValue("@date", SqlDbType.DateTime).Value = date; command.ExecuteNonQuery(); con.Close(); msg = "You have Reserve a Court!"; return(msg); }
public List <ReservationDetails> DisplayReservation(int user_id) { List <ReservationDetails> log = new List <ReservationDetails>(); using (SqlConnection con = new SqlConnection(connString)) { SqlCommand cmd = new SqlCommand("Main.GetActiveReserveDetailsByUserID", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("user", user_id); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { TimeSpan? time = new TimeSpan(); DateTime date = new DateTime(); ReservationDetails p = new ReservationDetails(); p.Name = rdr.SafeGetString(0); p.Province = rdr.SafeGetString(1); p.City = rdr.SafeGetString(2); time = rdr.SafeGetTime(3); p.StartTime = time.ToString(); time = rdr.SafeGetTime(4); p.EndTime = time.ToString(); date = rdr.SafeGetDateTime(5); p.DateEffective = date.ToString("d"); p.Address = rdr.SafeGetString(6); p.Status = rdr.SafeGetString(7); p.reserveId = rdr.SafeGetInt32(8); log.Add(p); } con.Close(); } return(log); }