private void barButtonItem1_ItemClick(object sender, ItemClickEventArgs e) { QLLoai themloai = new QLLoai(); themloai.Show(); this.Hide(); }
private void bbiRefresh_ItemClick(object sender, ItemClickEventArgs e) { this.Hide(); QLLoai loai = new QLLoai(); loai.Show(); }
private void btn_return_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { QLLoai ban = new QLLoai(); ban.Show(); this.Hide(); }
private void bbiNew_ItemClick(object sender, ItemClickEventArgs e) { DialogResult r; r = MessageBox.Show("Bạn có muốn lưu?", "Lưu thông tin", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (r == DialogResult.Yes) { MySqlConnection conn = getDB.getData(); conn.Open(); try { string tenloai = txtTenLoai.Text.Trim(); string sql = "insert into loai(TenLoai) values ('" + tenloai + "')"; MySqlCommand cmd = new MySqlCommand(sql, conn); if (cmd.ExecuteNonQuery() == 1) { MessageBox.Show("Thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Fails", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch { MessageBox.Show("Lỗi", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { conn.Close(); conn.Dispose(); this.Hide(); QLLoai themloai = new QLLoai(); themloai.Show(); } } }
private void btn_sua_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { int maca = int.Parse(maca1); DialogResult r; r = MessageBox.Show("Bạn có muốn lưu?", "Lưu thông tin", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (r == DialogResult.Yes) { MySqlConnection conn = getDB.getData(); conn.Open(); string tenca = txtTenCa.Text.Trim(); string sql = "update ca set TenCa ='" + tenca + "' where MaCa =" + maca; try { MySqlCommand cmd = new MySqlCommand(sql, conn); if (cmd.ExecuteNonQuery() == 1) { MessageBox.Show("Thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Fails", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch { MessageBox.Show("Lỗi", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { conn.Close(); conn.Dispose(); QLLoai ban = new QLLoai(); ban.Show(); this.Hide(); } } }