private void laGiangVien_Click(object sender, EventArgs e)
{
frmDTGiangVien frmDTGiangVien = new frmDTGiangVien();
frmDTGiangVien.WindowState = FormWindowState.Maximized;
frmDTGiangVien.Show();
//this.Close();
}
private void windowsUIButtonPanelCloseButton_Click(object sender, EventArgs e)
{
this.Close();
//frmDaoTao frmDaoTao = new frmDaoTao();
//frmDaoTao.Show();
frmDTGiangVien frmDTGiangVien = new frmDTGiangVien();
frmDTGiangVien.WindowState = FormWindowState.Maximized;
frmDTGiangVien.Show();
}
private void btnXoaGV_ItemClick(object sender, ItemClickEventArgs e)
{
String hoTen = gridVGiangVien.Columns.View.GetFocusedRowCellValue("hoTen").ToString();
String maGV = gridVGiangVien.Columns.View.GetFocusedRowCellValue("maGV").ToString();
DialogResult dialogResult = MessageBox.Show("Bạn có chắc chắn muốn xóa \n Giảng viên: " + hoTen + "\n Mã số: " + maGV, "Cảnh báo", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand sqlCmd = new SqlCommand("xoaGiangVien", con)
{
CommandType = CommandType.StoredProcedure
};
sqlCmd.Parameters.AddWithValue("@maGV", maGV);
sqlCmd.ExecuteNonQuery();
sqlCmd = new SqlCommand("deleteTaiKhoan", con)
{
CommandType = CommandType.StoredProcedure
};
sqlCmd.Parameters.AddWithValue("@tenTK", maGV);
sqlCmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Xóa thành công ^^");
this.Close();
frmDTGiangVien frmDTGiangVien = new frmDTGiangVien();
frmDTGiangVien.WindowState = FormWindowState.Maximized;
frmDTGiangVien.Show();
}
else if (dialogResult == DialogResult.No)
{
//do something else
}
}
private void windowsUIButtonPanelMain_Click(object sender, EventArgs e)
{
if (thaoTac.Equals("Them"))
{
if (strFilePath == "")
{
/*if (ImageByArray.Length != 0)
* ImageByArray = new byte[] { };*/
MessageBox.Show("Vui lòng chọn hình đại diện ^^");
OpenFileDialog ofd = new OpenFileDialog();
ofd.Filter = "Images(.jpg,.png)|*.png;*.jpg";
if (ofd.ShowDialog() == DialogResult.OK)
{
strFilePath = ofd.FileName;
picGiangVien.Image = new Bitmap(strFilePath);
}
Image temp = new Bitmap(strFilePath);
MemoryStream strm = new MemoryStream();
temp.Save(strm, System.Drawing.Imaging.ImageFormat.Jpeg);
ImageByArray = strm.ToArray();
}
else
{
Image temp = new Bitmap(strFilePath);
MemoryStream strm = new MemoryStream();
temp.Save(strm, System.Drawing.Imaging.ImageFormat.Jpeg);
ImageByArray = strm.ToArray();
}
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand sqlCmd = new SqlCommand("GV_Insert", con)
{
CommandType = CommandType.StoredProcedure
};
sqlCmd.Parameters.AddWithValue("@maGV", txtMaGV.Text);
sqlCmd.Parameters.AddWithValue("@hoTen", txtHoTen.Text);
if (radNam.Checked == true)
{
sqlCmd.Parameters.AddWithValue("@gioiTinh", "Nam");
}
else
{
sqlCmd.Parameters.AddWithValue("@gioiTinh", "Nữ");
}
sqlCmd.Parameters.AddWithValue("@diaChi", txtDiaChi.Text);
sqlCmd.Parameters.AddWithValue("@SDT", txtMSoDT.Text);
sqlCmd.Parameters.AddWithValue("@ngaySinh", Convert.ToDateTime(txtNgaySinh.Text));
sqlCmd.Parameters.AddWithValue("@noiSinh", txtNoiSinh.Text);
sqlCmd.Parameters.AddWithValue("@trinhDo", cbTrinhDo.Text);
sqlCmd.Parameters.AddWithValue("@thamNien", txtMThamNien.Text);
sqlCmd.Parameters.AddWithValue("@quyen", 2);
sqlCmd.Parameters.AddWithValue("@maKhoa", cbKhoa.SelectedValue.ToString());
/*if (cbKhoa.Text.Equals("Công Nghệ Thông Tin"))
* {
* sqlCmd.Parameters.AddWithValue("@maKhoa", "CNTT");
* }
* else
* {
* sqlCmd.Parameters.AddWithValue("@maKhoa", "MMT");
* }*/
sqlCmd.Parameters.AddWithValue("@hinh", ImageByArray);
sqlCmd.Parameters.AddWithValue("@email", txtEmail.Text);
sqlCmd.ExecuteNonQuery();
sqlCmd = new SqlCommand("themTaiKhoan", con)
{
CommandType = CommandType.StoredProcedure
};
sqlCmd.Parameters.AddWithValue("@tenTK", txtMaGV.Text);
sqlCmd.Parameters.AddWithValue("@matKhau", "1");
sqlCmd.Parameters.AddWithValue("@quyen", 2);
sqlCmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Lưu thành công ^^");
this.Close();
//frmDTGiangVien frm = new frmDTGiangVien();
//frm.WindowState = FormWindowState.Maximized;
//frm.Show();
}
else
{
if (strFilePath != "" && ImageByArray != null)
{
/*if (ImageByArray.Length != 0)
* ImageByArray = new byte[] { };
* // MessageBox.Show("Vui lòng chọn hình đại diện ^^");
* OpenFileDialog ofd = new OpenFileDialog();
* ofd.Filter = "Images(.jpg,.png)|*.png;*.jpg";
* if (ofd.ShowDialog() == DialogResult.OK)
* {
* strFilePath = ofd.FileName;
* picGiangVien.Image = new Bitmap(strFilePath);
* }*/
Image temp = new Bitmap(strFilePath);
MemoryStream strm = new MemoryStream();
temp.Save(strm, System.Drawing.Imaging.ImageFormat.Jpeg);
ImageByArray = strm.ToArray();
}
else
{
if (ImageByArray == null)
{
Image temp = new Bitmap(strFilePath);
MemoryStream strm = new MemoryStream();
temp.Save(strm, System.Drawing.Imaging.ImageFormat.Jpeg);
ImageByArray = strm.ToArray();
}
//picGiangVien.Image = Image.FromStream(new MemoryStream(ImageByArray));
}
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand sqlCmd = new SqlCommand("GV_Update", con)
{
CommandType = CommandType.StoredProcedure
};
sqlCmd.Parameters.AddWithValue("@maGV", txtMaGV.Text);
sqlCmd.Parameters.AddWithValue("@hoTen", txtHoTen.Text);
if (radNam.Checked == true)
{
sqlCmd.Parameters.AddWithValue("@gioiTinh", "Nam");
}
else
{
sqlCmd.Parameters.AddWithValue("@gioiTinh", "Nữ");
}
sqlCmd.Parameters.AddWithValue("@diaChi", txtDiaChi.Text);
sqlCmd.Parameters.AddWithValue("@SDT", txtMSoDT.Text);
sqlCmd.Parameters.AddWithValue("@ngaySinh", Convert.ToDateTime(txtNgaySinh.Text));
sqlCmd.Parameters.AddWithValue("@noiSinh", txtNoiSinh.Text);
sqlCmd.Parameters.AddWithValue("@trinhDo", cbTrinhDo.Text);
sqlCmd.Parameters.AddWithValue("@thamNien", txtMThamNien.Text);
sqlCmd.Parameters.AddWithValue("@quyen", 2);
sqlCmd.Parameters.AddWithValue("@maKhoa", cbKhoa.SelectedValue.ToString());
/*if (cbKhoa.Text.Equals("Công Nghệ Thông Tin"))
* {
* sqlCmd.Parameters.AddWithValue("@maKhoa", "CNTT");
* }
* else
* {
* sqlCmd.Parameters.AddWithValue("@maKhoa", "MMT");
* }*/
sqlCmd.Parameters.AddWithValue("@hinh", ImageByArray);
sqlCmd.Parameters.AddWithValue("@email", txtEmail.Text);
sqlCmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Lưu thành công ^^");
this.Close();
}
frmDTGiangVien frmDTGiangVien = new frmDTGiangVien();
frmDTGiangVien.WindowState = FormWindowState.Maximized;
frmDTGiangVien.Show();
}
