private void CreateSingleTableReservation(int reservationId, DinnerTable dinnerTable)
{
string sp = "sp_table_reservations_insert";
using (SqlConnection conn = new SqlConnection(GlobalConfig.ConnString(db)))
{
try
{
using (SqlCommand cmd = new SqlCommand(sp, conn))
{
cmd.Parameters.Add(new SqlParameter("@ReservationId", reservationId));
cmd.Parameters.Add(new SqlParameter("@DinnerTableId", dinnerTable.Id));
cmd.Parameters.Add(new SqlParameter("@TableReservationId", DbType.Int32));
cmd.Parameters["@TableReservationId"].Direction = ParameterDirection.Output;
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
cmd.ExecuteNonQuery();
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
}
public int CreateDinnerTable(DinnerTable table)
{
// Name of stored procedure
string sp = "sp_dinner_tables_insert";
try
{
using (SqlConnection conn = new SqlConnection(GlobalConfig.ConnString(db)))
{
using (SqlCommand cmd = new SqlCommand(sp, conn))
{
// Create INPUT parameters
cmd.Parameters.Add(new SqlParameter("@AreaId", table.AreaId));
cmd.Parameters.Add(new SqlParameter("@Name", table.Name));
cmd.Parameters.Add(new SqlParameter("@Seats", table.Seats));
// Create OUTPUT parameter
cmd.Parameters.Add(new SqlParameter("@Id", table.Id));
cmd.Parameters["@Id"].Direction = ParameterDirection.Output;
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
cmd.ExecuteNonQuery();
table.Id = (int)cmd.Parameters["@Id"].Value;
}
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
return(table.Id);
}
static void Main(string[] args)
{
SqlConnector db = new SqlConnector();
DinnerTable newTable = new DinnerTable("31");
Console.WriteLine(db.CreateDinnerTable(newTable));
List <DinnerTable> buffetTables = new List <DinnerTable>();
List <DinnerTable> sushiTables = new List <DinnerTable>();
for (int i = 1; i <= 50; i++)
{
buffetTables.Add(new DinnerTable()
{
Id = i, Name = i.ToString(), Seats = 2
});
}
for (int i = 1; i <= 30; i++)
{
sushiTables.Add(new DinnerTable()
{
Id = i, Name = i.ToString(), Seats = 2
});
}
Area buffet = new Area()
{
Id = 1, Name = "buffet", DinnerTables = buffetTables
};
Area sushi = new Area()
{
Id = 2, Name = "sushi", DinnerTables = sushiTables
};
List <Area> areas = new List <Area>();
areas.Add(buffet);
areas.Add(sushi);
Restaurant bamboo = new Restaurant()
{
Id = 1, Name = "Bamboo", PhoneNumber = 12345678, Areas = areas
};
//Console.WriteLine(bamboo.ToString());
//SqlConnector conn = new SqlConnector();
//string result = conn.Connect();
//Console.WriteLine(result);
Console.ReadKey();
}
private List <DinnerTable> GetReservedTables(int reservationId)
{
List <DinnerTable> tables = new List <DinnerTable>();
string sql = $"SELECT dinner_tables.id, dinner_tables.table_name, dinner_tables.seats, dinner_tables.area_id ";
sql += "FROM dinner_tables ";
sql += "INNER JOIN table_reservations ON table_reservations.dinner_table_id=dinner_tables.id ";
sql += "INNER JOIN reservations ON reservations.id=table_reservations.reservation_id ";
sql += "WHERE reservation_id = @id ";
try
{
using (SqlConnection conn = new SqlConnection(GlobalConfig.ConnString(db)))
{
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("@id", SqlDbType.Int).Value = reservationId;
using (cmd)
{
try
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
int tableId = reader.GetOrdinal("id");
int tableName = reader.GetOrdinal("table_name");
int tableSeats = reader.GetOrdinal("seats");
int tableAreaId = reader.GetOrdinal("area_id");
while (reader.Read())
{
DinnerTable table = new DinnerTable();
table.Id = reader.GetInt32(tableId);
table.Name = reader.GetString(tableName);
table.Seats = reader.GetInt32(tableSeats);
table.AreaId = reader.GetInt32(tableAreaId);
tables.Add(table);
}
reader.Close();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
return(tables);
}
static void Main(string[] args)
{
parseArgs(args);
PhilosophersDinner = new DinnerTable(PhilosophersCount);
while (PhilosophersDinner.PhilosophersHungry())
{
Thread.Sleep(10);
}
PhilosophersDinner.dinnerEnded();
PhilosophersDinner.printStatistics();
while (true)
{
Thread.Sleep(10);
}
}
// CONSTRUCTOR
public ReservationEditorViewModel()
{
ArrivalStatuses = new ObservableCollection <ArrivalStatus>();
CurrentFreeTables = new ObservableCollection <DinnerTable>();
SelectedReservedTables = new ObservableCollection <DinnerTable>();
SelectedTableFromFreeTables = new DinnerTable();
SelectedTableFromReservationTables = new DinnerTable();
CurrentReservation = new Reservation();
SelectedArea = new Area();
SelectedTimeIn = new TimeUnit();
SelectedTimeOut = new TimeUnit();
SelectedGuest = new Guest();
LoadRestaurantData();
LoadCommands();
//LoadDummyData();
}
private List <DinnerTable> GetTables(int areaId)
{
List <DinnerTable> tables = new List <DinnerTable>();
string sql = $"SELECT * FROM dinner_tables WHERE area_id = @id";
try
{
using (SqlConnection conn = new SqlConnection(GlobalConfig.ConnString(db)))
{
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("@id", SqlDbType.Int).Value = areaId;
using (cmd)
{
try
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
DinnerTable table = new DinnerTable();
table.Id = reader.GetInt32(0);
table.AreaId = reader.GetInt32(1);
table.Name = reader.GetString(2);
table.Seats = reader.GetInt32(3);
tables.Add(table);
}
reader.Close();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
return(tables);
}
public static void Main(string[] args)
{
Console.WriteLine("Hello, this is interview prep.");
//LinkedListProblems.kthToLast_Test();
//SQProblems.SortStack_Test();
//BinaryTreeProblems.Test_BinaryTreeInit();
//BinaryTreeProblems.Test_CreateMinimalTree();
//BitManipulationProblems.Test_GetBit();
//BitManipulationProblems.Test_SetBit();
//DynamicProgramming.Test_TripleStep();
//DynamicProgramming.Test_TowerOfHanoi();
//SA.MaxProfit.MaxProfit_Test();
//MultiThreadingExample.Run();
DinnerTable dt = new DinnerTable(4);
dt.StartDining();
}
protected override void LoadState()
{
dinnerTable = new(ParsedFileLines(SittingArrangementRule.Parse));
}
protected override void ResetState()
{
dinnerTable = null;
}
static void Main(string[] args)
{
DinnerTable dinner = new DinnerTable();
dinner.Start();
}
