public static void Main()
{
// <Snippet3>
ArrivalStatus status1 = new ArrivalStatus();
Console.WriteLine("Arrival Status: {0} ({0:D})", status1);
// The example displays the following output:
// Arrival Status: OnTime (0)
// </Snippet3>
// <Snippet4>
ArrivalStatus status2 = (ArrivalStatus)1;
Console.WriteLine("Arrival Status: {0} ({0:D})", status2);
// The example displays the following output:
// Arrival Status: Early (1)
// </Snippet4>
// <Snippet5>
int value3 = 2;
ArrivalStatus status3 = (ArrivalStatus)value3;
int value4 = (int)status3;
// </Snippet5>
// <Snippet6>
int number = -1;
ArrivalStatus arrived = (ArrivalStatus)ArrivalStatus.ToObject(typeof(ArrivalStatus), number);
// </Snippet6>
}
public void ToStringFormattingTest()
{
ArrivalStatus status = ArrivalStatus.Late;
Assert.Equal("Late", status.ToString("G"));
Assert.Equal("Late", status.ToString("F"));
Assert.Equal("-1", status.ToString("D"));
Assert.Equal("FFFFFFFF", status.ToString("X"));
}
public static void Main()
{
// <Snippet8>
ArrivalStatus status = ArrivalStatus.Early;
var number = Convert.ChangeType(status, Enum.GetUnderlyingType(typeof(ArrivalStatus)));
Console.WriteLine("Converted {0} to {1}", status, number);
// The example displays the following output:
// Converted Early to 1
// </Snippet8>
}
// CONSTRUCTOR
public ReservationManagerViewModel()
{
SqlConnector conn = new SqlConnector();
// Restaurant Id is hardcoded because I only have 1 restaurant, else it should have been selected by the user.
int restaurantId = 1;
SelectedRestaurant = conn.GetRestaurant(restaurantId);
SelectedArea = SelectedRestaurant.Areas[0];
ArrivalStatuses = conn.GetArrivalStatuses();
//ArrivalStatusButtons = new List<Button>();
SelectedArrivalStatus = new ArrivalStatus();
SelectedDateReservations = new ObservableCollection <Reservation>();
UpdateSelectedDateReservations();
LoadCommands();
//MessageBox.Show(SelectedRestaurant.ToString());
}
public static void Main()
{
// <Snippet10>
string[] formats = { "G", "F", "D", "X" };
ArrivalStatus status = ArrivalStatus.Late;
foreach (var fmt in formats)
{
Console.WriteLine(status.ToString(fmt));
}
// The example displays the following output:
// Late
// Late
// -1
// FFFFFFFF
// </Snippet10>
}
private static void GetEnumByName()
{
// <Snippet11>
string[] names = Enum.GetNames(typeof(ArrivalStatus));
Console.WriteLine("Members of {0}:", typeof(ArrivalStatus).Name);
Array.Sort(names);
foreach (var name in names)
{
ArrivalStatus status = (ArrivalStatus)Enum.Parse(typeof(ArrivalStatus), name);
Console.WriteLine(" {0} ({0:D})", status);
}
// The example displays the following output:
// Members of ArrivalStatus:
// Early (1)
// Late (-1)
// OnTime (0)
// Unknown (-3)
// </Snippet11>
}
public void IsDefinedTest()
{
// "-2 값은 정의되지 않았기 때문에 false를 리턴해야 한다"
Assert.False(Enum.IsDefined(typeof(ArrivalStatus), -2));
Assert.True(Enum.IsDefined(typeof(ArrivalStatus), -3));
// "underlying type이 int이기 때문에 정의 안한 값으로 할당해도 문제가 없어야 한다"
ArrivalStatus status = (ArrivalStatus)(-4);
Assert.Equal("-4", status.ToString());
// 그래서 안전하게 값을 받아서 enum type으로 변경을 할때에는 IsDefined() 사용
if (!Enum.IsDefined(typeof(ArrivalStatus), status))
{
status = ArrivalStatus.Unknown;
}
Assert.Equal(ArrivalStatus.Unknown, status);
}
private static void GetEnumByValue()
{
// <Snippet12>
var values = Enum.GetValues(typeof(ArrivalStatus));
Console.WriteLine("Members of {0}:", typeof(ArrivalStatus).Name);
foreach (var value in values)
{
ArrivalStatus status = (ArrivalStatus)Enum.ToObject(typeof(ArrivalStatus), value);
Console.WriteLine(" {0} ({0:D})", status);
}
// The example displays the following output:
// Members of ArrivalStatus:
// OnTime (0)
// Early (1)
// Unknown (-3)
// Late (-1)
// </Snippet12>
}
public static void Main()
{
// <Snippet9>
string number = "-1";
string name = "Early";
try {
ArrivalStatus status1 = (ArrivalStatus)Enum.Parse(typeof(ArrivalStatus), number);
if (!(Enum.IsDefined(typeof(ArrivalStatus), status1)))
{
status1 = ArrivalStatus.Unknown;
}
Console.WriteLine("Converted '{0}' to {1}", number, status1);
}
catch (FormatException) {
Console.WriteLine("Unable to convert '{0}' to an ArrivalStatus value.",
number);
}
ArrivalStatus status2;
if (Enum.TryParse <ArrivalStatus>(name, out status2))
{
if (!(Enum.IsDefined(typeof(ArrivalStatus), status2)))
{
status2 = ArrivalStatus.Unknown;
}
Console.WriteLine("Converted '{0}' to {1}", name, status2);
}
else
{
Console.WriteLine("Unable to convert '{0}' to an ArrivalStatus value.",
number);
}
// The example displays the following output:
// Converted '-1' to Late
// Converted 'Early' to Early
// </Snippet9>
}
public List <ArrivalStatus> GetArrivalStatuses()
{
List <ArrivalStatus> arrivalStatuses = new List <ArrivalStatus>();
string sql = "SELECT * FROM arrival_statuses ORDER BY id";
try
{
using (SqlConnection conn = new SqlConnection(GlobalConfig.ConnString(db)))
{
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
try
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ArrivalStatus arrivalStatus = new ArrivalStatus();
arrivalStatus.Id = Convert.ToInt32(reader["id"]);
arrivalStatus.Status = reader["status"].ToString();
arrivalStatus.Color = reader["color"].ToString();
arrivalStatuses.Add(arrivalStatus);
}
reader.Close();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
return(arrivalStatuses);
}
public static void Main()
{
ArrivalStatus status = ArrivalStatus.OnTime;
Console.WriteLine("Arrival Status: {0} ({0:D})", status);
}
public static void Main()
{
ArrivalStatus status1 = new ArrivalStatus();
Console.WriteLine("Arrival Status: {0} ({0:D})", status1);
}
public List <Reservation> GetReservations(DateTime selectedDate, Area selectedArea)
{
List <Reservation> reservations = new List <Reservation>();
// Name of stored procedure
string sp = "sp_reservations_get_for_date_area";
try
{
using (SqlConnection conn = new SqlConnection(GlobalConfig.ConnString(db)))
{
SqlCommand cmd = new SqlCommand(sp, conn);
cmd.Parameters.Add(new SqlParameter("@Date", selectedDate));
cmd.Parameters.Add(new SqlParameter("@AreaId", selectedArea.Id));
using (cmd)
{
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
try
{
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Guest guest = new Guest();
if (!reader.IsDBNull(0))
{
guest.Id = reader.GetInt32(0);
}
if (!reader.IsDBNull(1))
{
guest.FirstName = reader.GetString(1);
}
if (!reader.IsDBNull(2))
{
guest.LastName = reader.GetString(2);
}
if (!reader.IsDBNull(3))
{
guest.PhoneNumber = reader.GetInt32(3);
}
ArrivalStatus arrivalStatus = new ArrivalStatus();
arrivalStatus.Id = reader.GetInt32(4);
arrivalStatus.Status = reader.GetString(5);
Reservation reservation = new Reservation();
reservation.Area.Id = reader.GetInt32(6);
reservation.TimeIn = reader.GetDateTime(7);
if (!reader.IsDBNull(8))
{
reservation.TimeOut = reader.GetDateTime(8);
}
reservation.WantedSeats = reader.GetInt32(9);
reservation.ModifyDate = reader.GetDateTime(10);
reservation.Id = reader.GetInt32(11);
reservation.Guest = guest;
reservation.ArrivalStatus = arrivalStatus;
reservations.Add(reservation);
}
reader.Close();
}
catch (Exception e)
{
MessageBox.Show($"GetReservations: {e.Message}");
}
}
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
foreach (var reservation in reservations)
{
reservation.Tables = GetReservedTables(reservation.Id);
}
return(reservations);
}
