private void btnDelete_Click(object sender, EventArgs e) { DataSet ds = new DataSet(); try { if (string.IsNullOrWhiteSpace(txtID.Text)) { clsMessages.ShowInformation("Vui lòng chọn dòng dữ liệu muốn xóa!"); return; } long lID = Convert.ToInt64(txtID.Text); ds = BranchOfficeDAO.BranchOffice_Del(lID); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && Convert.ToInt32(ds.Tables[0].Rows[0]["Result"]) == 1) { clsMessages.ShowInformation("Xóa thành công!"); LoadDataToForm(); } else { clsMessages.ShowWarning(ds.Tables[0].Rows[0]["ErrorDesc"].ToString()); } } catch (Exception ex) { clsMessages.ShowErrorException(ex); } finally { ds.Dispose(); } }
private void btnSearch_Click(object sender, EventArgs e) { DataSet ds = new DataSet(); try { BranchOfficeDTO objBranch = new BranchOfficeDTO(); objBranch.ID = -1; objBranch.Name = txtName.Text; objBranch.Phone = txtPhone.Text; objBranch.Fax = txtFax.Text; objBranch.IDLocation = Convert.ToInt64((cboLocation.SelectedItem as clsComboItem).Value); ds = BranchOfficeDAO.BranchOffice_Search(objBranch); if (ds != null && ds.Tables.Count > 0) { dgvBranchOffice.DataSource = ds.Tables[0].Copy(); } else { clsMessages.ShowWarning("Không tìm thấy"); } } catch (Exception ex) { clsMessages.ShowErrorException(ex); } finally { ds.Dispose(); } }
public void LoadDataToForm() { DataSet ds = new DataSet(); DataTable dt = new DataTable(); try { ds = BranchOfficeDAO.BranchOffice_GetAll(); if (ds != null && ds.Tables.Count > 0) { dt = ds.Tables[0].Copy(); dgvBranchOffice.DataSource = dt.Copy(); dt.Clear(); } ds.Clear(); } catch (Exception ex) { clsMessages.ShowErrorException(ex); } finally { ds.Dispose(); dt.Dispose(); } }
private void LoadDataToCombobox() { DataSet ds = new DataSet(); DataTable dt = new DataTable(); try { ds = BranchOfficeDAO.LoadDataCombobox().Copy(); if (ds != null && ds.Tables.Count > 0) { dt = ds.Tables[0].Copy(); cboBranchOffice.Items.Add(new clsComboItem(-1, "")); foreach (DataRow item in dt.Rows) { clsComboItem itemCbo = new clsComboItem(); itemCbo.Value = item["Value"]; itemCbo.Display = item["Display"].ToString(); cboBranchOffice.Items.Add(itemCbo); } cboBranchOffice.SelectedIndex = dt.Rows.Count > 0 ? 0 : -1; dt.Clear(); } ds.Clear(); } catch (Exception ex) { clsMessages.ShowErrorException(ex); } finally { ds.Dispose(); dt.Dispose(); } }
private void btnSave_Click(object sender, EventArgs e) { DataSet ds = new DataSet(); try { BranchOfficeDTO obj = new BranchOfficeDTO(); obj.ID = -1; obj.Name = txtName.Text; obj.Phone = txtPhone.Text; obj.Fax = txtFax.Text; obj.IDLocation = Convert.ToInt64((cboLocation.SelectedItem as clsComboItem).Value); ds = BranchOfficeDAO.BranchOffice_InsUpd(obj); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && Convert.ToInt32(ds.Tables[0].Rows[0]["Result"]) == 1) { clsMessages.ShowInformation("Thêm thành công!"); frmParent.LoadDataToForm(); this.Close(); } else { clsMessages.ShowWarning("Thêm thất bại!"); } } catch (Exception ex) { clsMessages.ShowErrorException(ex); } finally { ds.Dispose(); } }
private void btnSave_Click(object sender, EventArgs e) { DataSet ds = new DataSet(); try { BranchOfficeDTO obj = new BranchOfficeDTO(); if (string.IsNullOrWhiteSpace(txtID.Text)) { clsMessages.ShowInformation("Vui lòng chọn dòng dữ liệu muốn sửa!"); return; } obj.ID = Convert.ToInt64(txtID.Text); obj.Name = txtName.Text; obj.Phone = txtPhone.Text; obj.Fax = txtFax.Text; obj.IDLocation = Convert.ToInt64((cboLocation.SelectedItem as clsComboItem).Value); ds = BranchOfficeDAO.BranchOffice_InsUpd(obj); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && Convert.ToInt32(ds.Tables[0].Rows[0]["Result"]) == 1) { clsMessages.ShowInformation("Cập nhật thành công!"); LoadDataToForm(); } else { clsMessages.ShowWarning("Cập nhật thất bại!"); } } catch (Exception ex) { clsMessages.ShowErrorException(ex); } finally { ds.Dispose(); } }