public bool sua(QuyDinh_DTO qd) { string query = string.Empty; query += "UPDATE QuyDinh SET [tenQD] = @tenQD, [noidung] = @noidung WHERE [maQD] = @maQD"; using (SqlConnection _cnn = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = _cnn; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = query; cmd.Parameters.AddWithValue("@maQD", qd.maQD); cmd.Parameters.AddWithValue("@tenQD", qd.tenQD); cmd.Parameters.AddWithValue("@noidung", qd.noidung); try { _cnn.Open(); cmd.ExecuteNonQuery(); _cnn.Close(); _cnn.Dispose(); } catch (Exception ex) { _cnn.Close(); return(false); } } } return(true); }
public bool them(QuyDinh_DTO qd) { string query = string.Empty; query += "INSERT INTO [QuyDinh] ([maQD], [tenQD], [noidung])"; query += "VALUES (@maQD, @tenQD, @noidung)"; using (SqlConnection _cnn = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = _cnn; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = query; cmd.Parameters.AddWithValue("@maQD", qd.maQD); cmd.Parameters.AddWithValue("@tenQD", qd.tenQD); cmd.Parameters.AddWithValue("@noidung", qd.noidung); try { _cnn.Open(); cmd.ExecuteNonQuery(); _cnn.Close(); _cnn.Dispose(); } catch (Exception ex) { _cnn.Close(); return(false); } } } return(true); }
private void btnDelete_Click(object sender, EventArgs e) { //1. Map data from GUI QuyDinh_DTO qd = new QuyDinh_DTO(); qd.maQD = txtmaQD.Text; //2. Kiểm tra data hợp lệ or not //3. Xóa trong DB bool kq = qdBus.xoa(qd); if (kq == false) { MessageBox.Show("Xóa thất bại. Vui lòng kiểm tra lại dũ liệu"); } else { txtmaQD.Text = ""; txttenQD.Text = ""; txtnoidung.Text = ""; MessageBox.Show("Xóa thành công"); this.loadData_Vao_GridView(); } }
private void XóaQuyĐịnhToolStripMenuItem_Click(object sender, EventArgs e) { // ' Get the current cell location. int currentRowIndex = dgvQuyDinh.CurrentCellAddress.Y;// 'current row selected //'Verify that indexing OK if (-1 < currentRowIndex && currentRowIndex < dgvQuyDinh.RowCount) { QuyDinh_DTO qd = (QuyDinh_DTO)dgvQuyDinh.Rows[currentRowIndex].DataBoundItem; if (qd != null) { bool kq = qdBus.xoa(qd); if (kq == false) { MessageBox.Show("Xóa quy định thất bại. Vui lòng kiểm tra lại dữ liệu"); } else { MessageBox.Show("Xóa quy định thành công"); this.loadData_Vao_GridView(); } } } }
public List <QuyDinh_DTO> selectByKeyWord(string sKeyword) { string query = string.Empty; query += "SELECT [maQD], [tenQD], [noidung]"; query += "FROM [QuyDinh]"; query += " WHERE ([maQD] LIKE CONCAT('%',@sKeyword,'%'))"; query += " OR ([tenQD] LIKE CONCAT('%',@sKeyword,'%'))"; query += " OR ([noidung] LIKE CONCAT('%',@sKeyword,'%'))"; List <QuyDinh_DTO> lsQuyDinh = new List <QuyDinh_DTO>(); using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = query; cmd.Parameters.AddWithValue("@sKeyword", sKeyword); try { con.Open(); SqlDataReader reader = null; reader = cmd.ExecuteReader(); if (reader.HasRows == true) { while (reader.Read()) { QuyDinh_DTO qd = new QuyDinh_DTO(); qd.maQD = reader["maQD"].ToString(); qd.tenQD = reader["tenQD"].ToString(); qd.noidung = reader["noidung"].ToString(); lsQuyDinh.Add(qd); } } con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); return(null); } } } return(lsQuyDinh); }
public List <QuyDinh_DTO> select() { string query = string.Empty; query += "SELECT [maQD], [tenQD], [noidung]"; query += "FROM [QuyDinh]"; List <QuyDinh_DTO> lsQuyDinh = new List <QuyDinh_DTO>(); using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = query; try { con.Open(); SqlDataReader reader = null; reader = cmd.ExecuteReader(); if (reader.HasRows == true) { while (reader.Read()) { QuyDinh_DTO qd = new QuyDinh_DTO(); qd.maQD = reader["maQD"].ToString(); qd.tenQD = reader["tenQD"].ToString(); qd.noidung = reader["noidung"].ToString(); lsQuyDinh.Add(qd); } } con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); return(null); } } } return(lsQuyDinh); }
public bool sua(QuyDinh_DTO qd) { bool re = qdDal.sua(qd); return(re); }
public bool them(QuyDinh_DTO qd) { bool re = qdDal.them(qd); return(re); }