public string MaDK_HCDC()
{
SqlConnection sql = DBUtils.GetDBConnection();
sql.Open();
SqlDataAdapter da = new SqlDataAdapter("select MaDK_HCDC from DK_HCDC", sql);
DataTable dt = new DataTable();
da.Fill(dt);
sql.Close();
string need = "HCDC";
int[] arr = new int[100];
for (int i = 0; i < dt.Rows.Count; i++)
{
string ma = dt.Rows[i]["MaDK_HCDC"].ToString();
string so = ma.Substring(4, 5);
int a = Int32.Parse(so);
arr[i] = a;
}
int kq = 0;
int n = 0;
do
{
while (kq <= arr[n])
{
kq++;
}
;
n++;
} while (kq <= arr[n]);
string mahcdc = "";
if (kq >= 10)
{
mahcdc = need + kq.ToString();
}
else
{
mahcdc = need + "0" + kq.ToString();
}
return(mahcdc);
}
private void btnLuu_Click(object sender, EventArgs e)
{
SqlConnection sql = DBUtils.GetDBConnection();
sql.Open();
if (this.dataGridView2.SelectedRows.Count > 0)
{
string nhom = cbTenNhom.SelectedValue.ToString().Trim();;
string loai = cbLoaiTN.SelectedValue.ToString().Trim();;
DateTime ngay = dateTimePicker.Value;
string gv = cbTenGV.SelectedValue.ToString().Trim();;
string phong = cbTenPhong.SelectedValue.ToString().Trim();;
string buoi = cbBuoi.SelectedValue.ToString().Trim();;
string tb = txtMaTB.Text.Trim();
int sl = Int32.Parse(txtSoLuong.Text.Trim());
//SqlCommand sc = new SqlCommand($"update DK_PTN set MaGVQL='{gv}',SoLuongTB={sl} where NgayDK='{ngay}' and MaBuoi='{buoi}' and MaNhom='{nhom}' and MaLoaiTN='{loai}' and MaPTN='{phong}' and MaTB='{tb}'", sql);
//sc.ExecuteNonQuery();
if (!exedata($"update DK_PTN set MaGVQL='{gv}',SoLuongTB={sl} where NgayDK='{ngay}' and MaBuoi='{buoi}' and MaNhom='{nhom}' and MaLoaiTN='{loai}' and MaPTN='{phong}' and MaTB='{tb}'"))
{
MessageBox.Show("Có Lỗi !");
}
else
{
MessageBox.Show("Thành công !");
}
SqlCommand cm = new SqlCommand("select * from DK_PTN", sql);
SqlDataAdapter adap = new SqlDataAdapter(cm);
DataTable dt = new DataTable();
adap.Fill(dt);
dataGridView2.DataSource = dt;
sql.Close();
cbTenNhom.Enabled = true;
cbLoaiTN.Enabled = true;
dateTimePicker.Enabled = true;
cbTenPhong.Enabled = true;
cbBuoi.Enabled = true;
btnLuu.Enabled = false;
dataGridView2.Enabled = true;
}
}
private void btnThem_Click(object sender, EventArgs e)
{
string masv = txtMaSV.Text.Trim();
string tensv = txtTenSV.Text.Trim();
DateTime ngaysinh = dateNgaySinh.Value;
int hocky = Int32.Parse(txtHocKy.Text.Trim());;
int namhoc = Int32.Parse(txtNamHoc.Text.Trim());;
string manhom = cbTenNhom.SelectedValue.ToString().Trim();
string malop = cbLop.SelectedValue.ToString().Trim();
SqlConnection sql = DBUtils.GetDBConnection();
sql.Open();
SqlCommand cm = new SqlCommand($"select count(*) as SoLuong from SinhVien where MaNhom = '{manhom}'", sql);
SqlDataAdapter adap = new SqlDataAdapter(cm);
DataTable dt = new DataTable();
adap.Fill(dt);
string so = dt.Rows[0]["SoLuong"].ToString();
if (Int32.Parse(so) >= 3)
{
MessageBox.Show("Nhóm Đủ người !");
return;
}
if (!exedata($"insert into SinhVien values('{masv}',N'{tensv}','{ngaysinh}',{hocky},{namhoc},'{manhom}','{malop}')"))
{
MessageBox.Show("Có Lỗi !");
}
else
{
MessageBox.Show("Thành công !");
}
//-------------------grid TB
cm = new SqlCommand("select * from SinhVien", sql);
adap = new SqlDataAdapter(cm);
dt = new DataTable();
adap.Fill(dt);
dataGridView1.DataSource = dt;
sql.Close();
}
private void btXoa_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("Bạn có muốn Xóa?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == DialogResult.Yes)
{
SqlConnection sql = DBUtils.GetDBConnection();
sql.Open();
SqlCommand cmd1 = new SqlCommand("delete from DK_DUNGCU where MaDK_HCDC = '" + dataGridView.Rows[dataGridView.CurrentCell.RowIndex].Cells[0].Value.ToString() + "'", sql);
cmd1.ExecuteNonQuery();
SqlCommand cmd2 = new SqlCommand("delete from DK_HoaChat where MaDK_HCDC = '" + dataGridView.Rows[dataGridView.CurrentCell.RowIndex].Cells[0].Value.ToString() + "'", sql);
cmd2.ExecuteNonQuery();
SqlCommand cmd3 = new SqlCommand("delete from DK_HCDC where MaDK_HCDC = '" + dataGridView.Rows[dataGridView.CurrentCell.RowIndex].Cells[0].Value.ToString() + "'", sql);
cmd3.ExecuteNonQuery();
sql.Close();
MessageBox.Show("Xóa thành công");
LoaddataGridView();
}
}
public Boolean exedata(string cmd)
{
SqlConnection sql = DBUtils.GetDBConnection();
sql.Open();
Boolean check = false;
try
{
SqlCommand sc = new SqlCommand(cmd, sql);
sc.ExecuteNonQuery();
check = true;
}
catch (Exception)
{
check = false;
}
sql.Close();
return(check);
}
private void US_dkHoaChat_Load(object sender, EventArgs e)
{
//-----------------Nhom
SqlConnection sql = DBUtils.GetDBConnection();
sql.Open();
SqlCommand cm = new SqlCommand("select * from NhomSV", sql);
SqlDataAdapter adap = new SqlDataAdapter(cm);
DataTable dt = new DataTable();
adap.Fill(dt);
cbbMaNhom.DisplayMember = "MaNhom";
cbbMaNhom.ValueMember = "TenNhom";
cbbMaNhom.DataSource = dt;
//-------------------GVQL
cm = new SqlCommand("select MaGVQL,TenGVQL from GV_QLTN", sql);
adap = new SqlDataAdapter(cm);
dt = new DataTable();
adap.Fill(dt);
cbbTenGVQL.DisplayMember = "TenGVQL";
cbbTenGVQL.ValueMember = "MaGVQL";
cbbTenGVQL.DataSource = dt;
txtMaGVQL.Text = dt.Rows[cbbTenGVQL.SelectedIndex]["MaGVQL"].ToString();
txtMaDK_HCDC.Enabled = false;
txtTenNhom.Enabled = false;
txtMaGVQL.Enabled = false;
txtMaHC.Enabled = false;
txtTenHC.Enabled = false;
btnLuu.Enabled = false;
LoaddataGridView();
cm = new SqlCommand("select* from HoaChat", sql);
adap = new SqlDataAdapter(cm);
dt = new DataTable();
adap.Fill(dt);
dataGridView1.DataSource = dt;
sql.Close();
}
private void btnLuu_Click(object sender, EventArgs e)
{
SqlConnection sql = DBUtils.GetDBConnection();
sql.Open();
if (this.dataGridView1.SelectedRows.Count > 0)
{
string masv = txtMaSV.Text.Trim();
string tensv = txtTenSV.Text.Trim();
DateTime ngaysinh = dateNgaySinh.Value;
int hocky = Int32.Parse(txtHocKy.Text.Trim());;
int namhoc = Int32.Parse(txtNamHoc.Text.Trim());;
string manhom = cbTenNhom.SelectedValue.ToString().Trim();
string malop = cbLop.SelectedValue.ToString().Trim();
//SqlCommand sc = new SqlCommand($"update DK_PTN set MaGVQL='{gv}',SoLuongTB={sl} where NgayDK='{ngay}' and MaBuoi='{buoi}' and MaNhom='{nhom}' and MaLoaiTN='{loai}' and MaPTN='{phong}' and MaTB='{tb}'", sql);
//sc.ExecuteNonQuery();
if (!exedata($"update SinhVien set TenSV='{tensv}',NgaySinh='{ngaysinh}',HocKy={hocky},NamHoc={namhoc},MaNhom='{manhom}',MaLop='{malop}' where MaSV='{masv}'"))
{
MessageBox.Show("Có Lỗi !");
}
else
{
MessageBox.Show("Thành công !");
}
SqlCommand cm = new SqlCommand("select * from SinhVien", sql);
SqlDataAdapter adap = new SqlDataAdapter(cm);
DataTable dt = new DataTable();
adap.Fill(dt);
dataGridView1.DataSource = dt;
sql.Close();
txtMaSV.Enabled = true;
btnLuu.Enabled = false;
btnSua.Enabled = true;
dataGridView1.Enabled = true;
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (this.dataGridView2.SelectedRows.Count > 0)
{
DateTime ngay = DateTime.Parse(this.dataGridView2.Rows[this.dataGridView2.CurrentRow.Index].Cells[0].Value.ToString());
if (!exedata($"delete from DK_PTN where NgayDK='{ngay}'"))
{
MessageBox.Show("Có Lỗi !");
}
else
{
MessageBox.Show("Thành công !");
}
SqlConnection sql = DBUtils.GetDBConnection();
sql.Open();
SqlCommand cm = new SqlCommand("select * from DK_PTN", sql);
SqlDataAdapter adap = new SqlDataAdapter(cm);
DataTable dt = new DataTable();
adap.Fill(dt);
dataGridView2.DataSource = dt;
sql.Close();
}
}
private void US_dkPTN_Load(object sender, EventArgs e)
{
//-----------load nhom
SqlConnection sql = DBUtils.GetDBConnection();
sql.Open();
SqlCommand cm = new SqlCommand("select MaNhom,TenNhom from NhomSV", sql);
SqlDataAdapter adap = new SqlDataAdapter(cm);
DataTable dt = new DataTable();
adap.Fill(dt);
cbTenNhom.DisplayMember = "TenNhom";
cbTenNhom.ValueMember = "MaNhom";
cbTenNhom.DataSource = dt;
//-----------load loại TN
cm = new SqlCommand("select MaLoaiTN,TenLoai from Loai_TN", sql);
adap = new SqlDataAdapter(cm);
dt = new DataTable();
adap.Fill(dt);
cbLoaiTN.DisplayMember = "TenLoai";
cbLoaiTN.ValueMember = "MaLoaiTN";
cbLoaiTN.DataSource = dt;
//-----------load loại TN
cm = new SqlCommand("select MaPTN,TenPTN from PhongThiNghiem", sql);
adap = new SqlDataAdapter(cm);
dt = new DataTable();
adap.Fill(dt);
cbTenPhong.DisplayMember = "MaPTN";
cbTenPhong.ValueMember = "MaPTN";
cbTenPhong.DataSource = dt;
//-------------------GVQL
cm = new SqlCommand("select MaGVQL,TenGVQL from GV_QLTN", sql);
adap = new SqlDataAdapter(cm);
dt = new DataTable();
adap.Fill(dt);
cbTenGV.DisplayMember = "MaGVQL";
cbTenGV.ValueMember = "MaGVQL";
cbTenGV.DataSource = dt;
//---------------------Buổi
cm = new SqlCommand("select MaBuoi,Tiet from Buoi", sql);
adap = new SqlDataAdapter(cm);
dt = new DataTable();
adap.Fill(dt);
cbBuoi.DisplayMember = "MaBuoi";
cbBuoi.ValueMember = "MaBuoi";
cbBuoi.DataSource = dt;
//-------------------grid TB
cm = new SqlCommand("select MaTB,TenTB from ThietBi", sql);
adap = new SqlDataAdapter(cm);
dt = new DataTable();
adap.Fill(dt);
dataGridView_ThietBi.DataSource = dt;
cm = new SqlCommand("select * from ThietBi", sql);
adap = new SqlDataAdapter(cm);
dt = new DataTable();
adap.Fill(dt);
dataGridView_ThietBi.DataSource = dt;
cm = new SqlCommand("select * from DK_PTN", sql);
adap = new SqlDataAdapter(cm);
dt = new DataTable();
adap.Fill(dt);
dataGridView2.DataSource = dt;
sql.Close();
txtMaTB.Enabled = false;
btnLuu.Enabled = false;
sql.Close();
}
