/// <summary>
/// Initializes Tables of the Company and add them to TableList property.
/// </summary>
private void InitTableCollection()
{
Dictionary<int, Table> dt = new Dictionary<int, Table>();
SqlConnection conn = new SqlConnection(
ConfigurationManager.ConnectionStrings["TotoCafeDB"].ConnectionString
);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT [Table].TableID, [Table].TableName, [Table].AvailabilityID FROM [Table] " +
"INNER JOIN Availability ON [Table].AvailabilityID = Availability.AvailabilityID " +
"WHERE (Availability.Availability = @Availability) AND ([Table].CompanyID = @CompanyID) " +
"ORDER BY [Table].TableName";
cmd.Parameters.AddWithValue("@CompanyID", this.CompanyID);
cmd.Parameters.AddWithValue("@Availability", "AVAILABLE");
cmd.Connection = conn;
try
{
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Table t = new Table();
t.TableID = int.Parse(dr["TableID"].ToString());
t.TableName = dr["TableName"].ToString();
t.AvailabilityID = int.Parse(dr["AvailabilityID"].ToString());
t.CompanyID = this.CompanyID;
t.QrCode = "TotoCafe-" + this.CompanyID.ToString() + "-" + t.TableID;
t.InitActiveController();//Current open controller..
dt.Add(t.TableID, t);
}
}
catch (Exception) { }
finally { conn.Close(); }
this.Tables = dt;
}