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