public int UpdateArea(AreaData area) { Dictionary<string, object> sqlStoredProcedureParams = new Dictionary<string, object>(); sqlStoredProcedureParams.Add("maKhuVuc", area.AreaId); sqlStoredProcedureParams.Add("tenKhuVuc", area.AreaName); sqlStoredProcedureParams.Add("ghiChu", area.Note); return provider.ExecuteNonQuery("KHUVUC_proc_update", sqlStoredProcedureParams); }
public List<AreaData> GetAllArea() { List<AreaData> listArea = new List<AreaData>(); DataTable dt = provider.ExecuteReader("KHUVUC_proc_load"); foreach (DataRow row in dt.Rows) { AreaData area = new AreaData(); area.AreaId = row["MaKhuVuc"].ToString(); area.AreaName = row["TenKhuVuc"].ToString(); listArea.Add(area); } return listArea; }
private void btnThem_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtKhuVuc.Text.Trim())) { MessageDialogHelper.CreateErrorMessage("Tên khu vực không được để trống."); return; } AreaData areaToSave = new AreaData(); areaToSave.AreaName = txtKhuVuc.Text.Trim(); LocatorBll.AreaAndTableBll.AreaToSave = areaToSave; if (LocatorBll.AreaAndTableBll.AddArea()) { if (MessageDialogHelper.CreateInformationMessage("Lưu thành công.") == DialogResult.OK) this.Close(); } }
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; }
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; }
public int DeleteArea(AreaData area) { Dictionary<string, object> sqlStoredProcedureParams = new Dictionary<string, object>(); sqlStoredProcedureParams.Add("maKhuVuc", area.AreaId); return provider.ExecuteNonQuery("KHUVUC_proc_delete", sqlStoredProcedureParams); }