public BindingList <BacSyDTO> LayDanhSach() { BindingList <BacSyDTO> danhSach = new BindingList <BacSyDTO>(); OleDbConnection cn; cn = DataProvider.KetNoi(); string strSQL; strSQL = "Select * From DanhMucBacSy"; OleDbCommand cmd = new OleDbCommand(strSQL, cn); OleDbDataReader dr; dr = cmd.ExecuteReader(); while (dr.Read()) { BacSyDTO itemDTO = new BacSyDTO(); itemDTO.IdBacSy = (int)dr["Id"]; itemDTO.MaBacSy = (string)dr["MaBacSy"]; itemDTO.TenBacSy = (string)dr["TenBacSy"]; itemDTO.DiaChi = (string)dr["DiaChi"]; itemDTO.DienThoai = (string)dr["DienThoai"]; itemDTO.GhiChu = (string)dr["GhiChu"]; danhSach.Add(itemDTO); } return(danhSach); }
private void gvDanhMucBacSy_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { if (gvDanhMucBacSy.FocusedRowHandle > -1) { try { BacSyDTO itemDTO = new BacSyDTO(); BacSyBUS itemBUS = new BacSyBUS(); itemDTO.MaBacSy = gvDanhMucBacSy.GetFocusedRowCellValue("MaBacSy").ToString(); itemDTO.TenBacSy = gvDanhMucBacSy.GetFocusedRowCellValue("TenBacSy").ToString(); itemDTO.DiaChi = gvDanhMucBacSy.GetFocusedRowCellValue("DiaChi").ToString(); itemDTO.DienThoai = gvDanhMucBacSy.GetFocusedRowCellValue("DienThoai").ToString(); itemDTO.GhiChu = gvDanhMucBacSy.GetFocusedRowCellValue("GhiChu").ToString(); itemDTO.IdBacSy = int.Parse(gvDanhMucBacSy.GetFocusedRowCellValue("IdBacSy").ToString()); if (this.flagThem && gvDanhMucBacSy.FocusedRowHandle == gvDanhMucBacSy.RowCount - 2) { if (itemDTO.MaBacSy.Length > 0) { DialogResult hopThoai = MessageBox.Show("Bạn chắc chắn muốn thêm mới?", "Thêm mới", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (hopThoai == DialogResult.Yes) { itemBUS.Them(itemDTO); this.flagThem = false; } } else { MessageBox.Show("Bạn chưa nhập mã bác sỹ!", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { DialogResult hopThoai = MessageBox.Show("Bạn chắc chắn muốn cập nhật?", "Cập nhật", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (hopThoai == DialogResult.Yes) { itemBUS.Sua(itemDTO); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } this.LayDanhSachBacSy(); } }
public void Them(BacSyDTO itemDTO) { OleDbConnection cn; cn = DataProvider.KetNoi(); string strSQL; strSQL = "Insert into DanhMucBacSy (MaBacSy,TenBacSy,DiaChi,DienThoai,GhiChu) values (?, ?, ?, ?, ?)"; OleDbCommand cmd = new OleDbCommand(strSQL, cn); cmd.Parameters.Add("@MaBacSy", OleDbType.WChar).Value = itemDTO.MaBacSy; cmd.Parameters.Add("@TenBacSy", OleDbType.WChar).Value = itemDTO.TenBacSy; cmd.Parameters.Add("@DiaChi", OleDbType.WChar).Value = itemDTO.DiaChi; cmd.Parameters.Add("@DienThoai", OleDbType.WChar).Value = itemDTO.DienThoai; cmd.Parameters.Add("@GhiChu", OleDbType.WChar).Value = itemDTO.GhiChu; cmd.ExecuteNonQuery(); cn.Close(); }
public void Sua(BacSyDTO itemDTO) { OleDbConnection cn; cn = DataProvider.KetNoi(); string strSQL; strSQL = "Update DanhMucBacSy Set MaBacSy = ?, TenBacSy = ?, DiaChi = ?, DienThoai = ?, GhiChu = ? Where Id = ?"; OleDbCommand cmd = new OleDbCommand(strSQL, cn); cmd.Parameters.Add("@MaBacSy", OleDbType.WChar).Value = itemDTO.MaBacSy; cmd.Parameters.Add("@TenBacSy", OleDbType.WChar).Value = itemDTO.TenBacSy; cmd.Parameters.Add("@DiaChi", OleDbType.WChar).Value = itemDTO.DiaChi; cmd.Parameters.Add("@DienThoai", OleDbType.WChar).Value = itemDTO.DienThoai; cmd.Parameters.Add("@GhiChu", OleDbType.WChar).Value = itemDTO.GhiChu; cmd.Parameters.Add("@Id", OleDbType.Numeric).Value = itemDTO.IdBacSy; cmd.ExecuteNonQuery(); cn.Close(); }
public void Sua(BacSyDTO itemDTO) { BacSyDAO itemDAO = new BacSyDAO(); itemDAO.Sua(itemDTO); }
public void Them(BacSyDTO itemDTO) { BacSyDAO itemDAO = new BacSyDAO(); itemDAO.Them(itemDTO); }