void LoadDetails()
{
var order = db.OrderTables.SingleOrDefault(x => x.OrderId == ord.OrderId);
tb = db.BidaTables.SingleOrDefault(x => x.TableId == ord.TableId);
if (tb.PlayTime == null)
{
time = 1;
}
else
{
time = (double)(order.PlayTime / 60);
}
price = time * (double)tb.Price;
if (cus != null)
{
if (cus.CusLevel == 3)
{
lblDiscount.Text = "20%";
discount = 20;
}
if (cus.CusLevel == 2)
{
lblDiscount.Text = "15%";
discount = 15;
}
if (cus.CusLevel == 1)
{
lblDiscount.Text = "10%";
discount = 10;
}
if (cus.CusLevel == 0)
{
lblDiscount.Text = "5%";
discount = 5;
}
}
else
{
lblDiscount.Text = discount.ToString();
}
total = (double)(price + order.Surcharge + totalSvPrice);
afterDiscount = total - (total * discount / 100);
lblTableName.Text = tb.TableName;
lblEndTime.Text = order.EndTime.ToString();
lblStartTime.Text = order.StartTime.ToString();
lblTotalTime.Text = time.ToString();
lblSurchagre.Text = order.Surcharge.ToString();
lblCaculatePrice.Text = time + " X " + tb.Price + " = " + price;
lblPricePlay.Text = price.ToString();
lblTotalPrice.Text = afterDiscount.ToString();
}
void TableDetails(int id)
{
tb = bida.BidaTables.SingleOrDefault(x => x.TableId == id);
txtTableName.Text = tb.TableName;
txtTablePrice.Text = tb.Price.ToString();
txtTiming.Text = TimeSpan.FromMinutes(Convert.ToDouble(tb.PlayTime)).ToString();
if (tb.StartTime != null)
{
timer.Start();
btnEndTime.Enabled = true;
}
}
private void LoadTable()
{
bida = new BidaDataContext();
flpTableList.Controls.Clear();
var lstTable = from t in bida.BidaTables
join c in bida.TableCategories
on t.TableCatID equals c.TableCatId
select new
{
Id = t.TableId,
Name = t.TableName,
CatName = c.TableCatName,
Status = t.TableStatus
};
//tạo button as bàn
foreach (var table in lstTable)
{
BidaTable bidaTable = bida.BidaTables.SingleOrDefault(x => x.TableId == table.Id);
string status;
Button btn = new Button()
{
Width = 120, Height = 120
};
btn.Click += btn_Click;
btn.Leave += btn_Leave;
btn.Tag = bidaTable;
if (table.Status == 1)
{
status = "Trống";
}
else
{
status = "Đang chơi";
}
switch (status)
{
case "Trống":
c = btn.BackColor = Color.LimeGreen;
break;
default:
c = btn.BackColor = Color.OrangeRed;
break;
}
btn.Text = table.Name + Environment.NewLine + Environment.NewLine + table.CatName + Environment.NewLine + Environment.NewLine + status;
//thêm btn vào flpanel
flpTableList.Controls.Add(btn);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
var table = db.BidaTables.SingleOrDefault(x => x.TableName.ToLower().Equals(txtTableName.Text.ToLower()));
if (table == null)
{
BidaTable tb = new BidaTable();
tb.TableName = txtTableName.Text;
tb.TableCatID = (cbxTableCat.SelectedItem as TableCategory).TableCatId;
tb.Price = Convert.ToDouble(txtPrice.Text);
tb.TableStatus = 1;
db.BidaTables.InsertOnSubmit(tb);
db.SubmitChanges();
MessageBox.Show("Thêm bàn thành công", "Thêm bàn", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Bàn đã tồn tại", "Thêm bàn", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
}
}
public frmUpdateTable(BidaTable table)
{
InitializeComponent();
tb = table;
db = new BidaDataContext();
}
public frmChangeTable(BidaTable table)
{
InitializeComponent();
db = new BidaDataContext();
tb = table;
}
