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();
}
}
}
