private void UpdateReservationContent(DateTime startDate)
{
string startDate_string = startDate.ToShortDateString();
DateTime endDate = startDate.AddDays(6);
string endDate_string = endDate.ToShortDateString();
OleDbConnection cn = new OleDbConnection(); //Connection
OleDbCommand cmd = new OleDbCommand(); //Command
OleDbDataReader dr;
String path = Assembly.GetExecutingAssembly().Location;
path = path.Replace("bin\\Debug\\ICTProjectPOS.exe", "RestaurantDB.accdb");
String connectionString = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}", path);
cn.ConnectionString = @connectionString;
cmd.Connection = cn;
try
{
cmd.CommandText = "SELECT * FROM Reservation WHERE ResDate BETWEEN startDate AND endDate";
cmd.Parameters.AddWithValue("startDate", startDate_string);
cmd.Parameters.AddWithValue("endDate", endDate_string);
cn.Open();
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
Reservation_Weekly reservation = new Reservation_Weekly(dr[7].ToString(), dr[8].ToString());
reservation_weekly.Add(reservation);
}
}
cn.Close();
}
catch
{
// empty
}
UpdateAgendaButtons(startDate);
}
private void UpdateReservationContent(DateTime startDate)
{
string startDate_string = startDate.ToShortDateString();
DateTime endDate = startDate.AddDays(6);
string endDate_string = endDate.ToShortDateString();
OleDbConnection cn = new OleDbConnection(); //Connection
OleDbCommand cmd = new OleDbCommand(); //Command
OleDbDataReader dr;
String path = Assembly.GetExecutingAssembly().Location;
path = path.Replace("bin\\Debug\\ICTProjectPOS.exe", "RestaurantDB.accdb");
String connectionString = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}", path);
cn.ConnectionString = @connectionString;
cmd.Connection = cn;
try
{
cmd.CommandText = "SELECT * FROM Reservation WHERE ResDate BETWEEN startDate AND endDate";
cmd.Parameters.AddWithValue("startDate", startDate_string);
cmd.Parameters.AddWithValue("endDate", endDate_string);
cn.Open();
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
Reservation_Weekly reservation = new Reservation_Weekly(dr[7].ToString(), dr[8].ToString());
reservation_weekly.Add(reservation);
}
}
cn.Close();
}
catch
{
// empty
}
UpdateAgendaButtons(startDate);
}
