public int AddTable(TableData table) { Dictionary<string, object> sqlStoredProcedureParams = new Dictionary<string, object>(); sqlStoredProcedureParams.Add("maBan", table.TableId); sqlStoredProcedureParams.Add("tenBan", table.TableName); sqlStoredProcedureParams.Add("maKhuVuc", table.Area.AreaId); sqlStoredProcedureParams.Add("ghiChu", table.Note); return provider.ExecuteNonQuery("BAN_proc_insert", sqlStoredProcedureParams); }
/// <summary> /// Lấy ra bill chưa thanh toán cuối cùng của bàn. /// </summary> /// <param name="table"></param> /// <returns></returns> public BillData GetLastBill(TableData table) { BillData bill = new BillData(); Dictionary<string, object> sqlStoredProcedureParams = new Dictionary<string, object>(); sqlStoredProcedureParams.Add("maBan", table.TableId); DataTable dt = provider.ExecuteReader("HOADON_proc_get_last_bill", sqlStoredProcedureParams); if (dt.Rows.Count == 1) { bill.BillId = dt.Rows[0]["MaHoaDon"].ToString(); bill.Table = new TableData { TableId = dt.Rows[0]["MaBan"].ToString() }; bill.TableLiquidate = new TableData { TableId = dt.Rows[0]["MaBanThanhToan"].ToString() }; bill.Time = DateTime.Parse(dt.Rows[0]["ThoiGian"].ToString()); bill.TotalMoney = Decimal.Parse(dt.Rows[0]["TongTien"].ToString()); } return bill; }
public List<TableData> GetAllTable(AreaData area) { List<TableData> listTable = new List<TableData>(); Dictionary<string, object> sqlStoredProcedureParams = new Dictionary<string, object>(); sqlStoredProcedureParams.Add("maKhuVuc", area.AreaId); DataTable dt = provider.ExecuteReader("BAN_proc_load_with_MaKhuVuc", sqlStoredProcedureParams); foreach (DataRow row in dt.Rows) { TableData table = new TableData(); table.TableId = row["MaBan"].ToString(); table.TableName = row["TenBan"].ToString(); table.Area = area; table.TableState = row["TinhTrang"].ToString(); table.Note = row["GhiChu"].ToString(); listTable.Add(table); } return listTable; }
private void btnDongY_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtTenBan.Text.Trim())) { MessageDialogHelper.CreateErrorMessage("Tên bàn không được để trống."); return; } TableData tableToSave = new TableData(); tableToSave.TableName = txtTenBan.Text.Trim(); tableToSave.Area = LocatorBll.AreaAndTableBll.AreaSelected; tableToSave.TableState = "Trong"; LocatorBll.AreaAndTableBll.TableToSave = tableToSave; if (LocatorBll.AreaAndTableBll.AddTable()) { if (MessageDialogHelper.CreateInformationMessage("Lưu thành công.") == DialogResult.OK) this.Close(); } }
public List<TableData> GetAllTable() { List<TableData> listTable = new List<TableData>(); DataTable dt = provider.ExecuteReader("BAN_proc_load"); foreach (DataRow row in dt.Rows) { TableData table = new TableData(); table.TableId = row["MaBan"].ToString(); table.TableName = row["TenBan"].ToString(); table.Area = new AreaData { AreaId = row["MaKhuVuc"].ToString(), AreaName = row["TenKhuVuc"].ToString() }; table.TableState = row["TinhTrang"].ToString(); listTable.Add(table); } return listTable; }
public List<TableData> GetAllTableToChoose(AreaData area) { List<TableData> listTable = new List<TableData>(); TableData all = new TableData(); all.TableName = "Tất cả bàn"; listTable.Add(all); DataTable dt = null; if (string.IsNullOrEmpty(area.AreaId)) { dt = provider.ExecuteReader("BAN_proc_load"); } else { Dictionary<string, object> sqlStoredProcedureParams = new Dictionary<string, object>(); sqlStoredProcedureParams.Add("maKhuVuc", area.AreaId); dt = provider.ExecuteReader("BAN_proc_load_with_MaKhuVuc", sqlStoredProcedureParams); } foreach (DataRow row in dt.Rows) { TableData table = new TableData(); table.TableId = row["MaBan"].ToString(); table.TableName = row["TenBan"].ToString(); table.Area = new AreaData { AreaId = row["MaKhuVuc"].ToString() }; listTable.Add(table); } return listTable; }
private void updateInfo(TableData table) { lblTenBan.Text = table.TableName; string trangthai = "???"; string TableState = table.TableState; if ("Trong".Equals(TableState)) { trangthai = "Trống"; } else if ("CoNguoi".Equals(TableState)) { trangthai = "Có Người"; } else if ("ChuaDon".Equals(TableState)) { trangthai = "Chưa Dọn"; } else if ("DaDat".Equals(TableState)) { trangthai = "Đã Đặt Trước"; } lblTrangThai.Text = trangthai; if (homePageBll.BillOfTableSelected != null && homePageBll.BillOfTableSelected.TableLiquidate != null) { TableData tableLiquidate = null; tableLiquidate = LocatorDataSource.TableDS.GetTable(homePageBll.BillOfTableSelected.TableLiquidate); if (tableLiquidate != null) { lblBanThanhToan.Text = tableLiquidate.TableName; } } else { lblBanThanhToan.Text = String.Empty; } }
public int DeleteTable(TableData table) { Dictionary<string, object> sqlStoredProcedureParams = new Dictionary<string, object>(); sqlStoredProcedureParams.Add("maBan", table.TableId); return provider.ExecuteNonQuery("BAN_proc_delete", sqlStoredProcedureParams); }
public TableData GetTable(TableData table) { TableData getTable = new TableData(); Dictionary<string, object> sqlStoredProcedureParams = new Dictionary<string, object>(); sqlStoredProcedureParams.Add("maBan", table.TableId); DataTable dt = provider.ExecuteReader("BAN_proc_get", sqlStoredProcedureParams); if (dt.Rows.Count == 1) { getTable.TableId = dt.Rows[0]["MaBan"].ToString(); getTable.TableName = dt.Rows[0]["TenBan"].ToString(); getTable.Area = new AreaData { AreaId = dt.Rows[0]["MaKhuVuc"].ToString(), AreaName = dt.Rows[0]["TenKhuVuc"].ToString() }; getTable.TableState = dt.Rows[0]["TinhTrang"].ToString(); } return getTable; }