private void danhSáchSinhViênToolStripMenuItem_Click(object sender, EventArgs e)
{
frmSinhVien frmSinhVien = new frmSinhVien();
this.Hide();
frmSinhVien.f = this;
frmSinhVien.Show();
}
private void btnThoat_Click(object sender, EventArgs e)
{
Close();
Dispose();
disconnect();
frmSinhVien _frmSinhVien = new frmSinhVien();
_frmSinhVien.Show();
}
private void sinhVienToolStripMenuItem_Click(object sender, EventArgs e)
{
closeAllForm();
if (fSV.IsDisposed)
{
fSV = new frmSinhVien();
}
fSV.MdiParent = this;
fSV.WindowState = FormWindowState.Maximized;
fSV.Show();
}
private void barSinhVien_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
Form frm = this.KiemTraTonTai(typeof(frmSinhVien));
if (frm != null)
{
frm.Activate();
}
else
{
frmSinhVien f = new frmSinhVien();
f.MdiParent = this;
f.Show();
}
}
private void toolStripButtonSinhVien_Click(object sender, EventArgs e)
{
foreach (Form f in this.MdiChildren)
{
if (f.Name == "frmSinhVien")
{
f.Activate();
return;
}
}
frmSinhVien sv = new frmSinhVien();
sv.MdiParent = this;
sv.Show();
}
private void btnLuu_Click(object sender, EventArgs e)
{
kiemtra();
if (kt == true)
{
DataRow row = dt.NewRow();
row["fldFirstName"] = txthosv.Text;
row["fldLastName"] = txttensv.Text;
row["fldAge"] = txttuoi.Text;
if (cbogioitinh.Text == "Nam")
{
row["fldSex"] = 1;
}
else if (cbogioitinh.Text == "Nữ")
{
row["fldSex"] = 0;
}
row["fldCreatedDate"] = dtngay.Value;
row["fldClassID"] = cbolop.SelectedValue;
dt.Rows.Add(row);
SqlCommand commandInsert = new SqlCommand();
commandInsert.Connection = con;
commandInsert.CommandType = CommandType.Text;
commandInsert.CommandText = @"Insert tblStudent (fldFirstName, fldLastName, fldAge, fldSex, fldCreatedDate, fldClassID)
Values (@fldFirstName, @fldLastName, @fldAge, @fldSex, @fldCreatedDate, @fldClassID)";
commandInsert.Parameters.Add("fldFirstName", SqlDbType.NVarChar, 50, "fldFirstName");
commandInsert.Parameters.Add("fldLastName", SqlDbType.NVarChar, 50, "fldLastName");
commandInsert.Parameters.Add("fldAge", SqlDbType.Int, 50, "fldAge");
commandInsert.Parameters.Add("fldSex", SqlDbType.Int, 50, "fldSex");
commandInsert.Parameters.Add("fldCreatedDate", SqlDbType.DateTime, 50, "fldCreatedDate");
commandInsert.Parameters.Add("fldClassID", SqlDbType.Int, 50, "fldClassID");
da.InsertCommand = commandInsert;
da.Update(dt);
MessageBox.Show("Bạn đã thêm thành công !", "THÔNG BÁO", MessageBoxButtons.OK);
Close();
disconnect();
Dispose();
frmSinhVien _frmSinhVien = new frmSinhVien();
_frmSinhVien.Show();
}
}
private void sinhViToolStripMenuItem_Click(object sender, EventArgs e)
{
frmSinhVien _frmSinhVien = new frmSinhVien();
_frmSinhVien.Show();
}
private void btnSinhvien_Click(object sender, EventArgs e)
{
frmSinhVien _frmSinhVien = new frmSinhVien();
_frmSinhVien.Show();
}
