/// <summary>
/// Form load
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmGiaoVien_Load(object sender, EventArgs e)
{
//Khoi tao doi tuong m_Controller
if (this.Controller == null)
{
this.Controller = new GiaoVienController();
}
//Khoi tao doi tuong m_MonHocController
if (this.MonHocController == null)
{
this.MonHocController = new MonHocController();
}
//Hien thi ComboBox mon hoc
this.MonHocController.HienThiCombobox(this.cmbMonHoc);
//Hien thi DataGridViewComboBoxColumn mon hoc
this.MonHocController.HienThiDataGridComboBoxColumn(this.colMonHoc);
//Hien thi DS Giao vien
this.Controller.HienThiDS(this.dgvDS, this.bnDS, this.txtMaGiaoVien, this.txtHoTen, this.dpNgaySinh, this.cbxGioiTinh, this.cmbMonHoc, this.txtDienThoai, this.txtNoiSinh, this.txtDiaChi);
//Neu trong danh sach khong co dong nao
if (this.dgvDS.Rows.Count == 0)
{
this.btXoa.Enabled = false;
this.itXoa.Enabled = false;
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
Mhc = new MonHocController();
string s = string.Format("Do you want delete data? with Mã Môn là: {0}", IDmember);
if (IDmember == null)
{
MessageBox.Show("No Select!!", "Thông tin", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
if (MessageBox.Show(s, "Xóa Dữ liệu", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
if (Mhc.XoaMH(IDmember))
{
MessageBox.Show("Thành Công", "Thông tin", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Lỗi", "Thông tin", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Hienthi(_Query);
}
}
}
private void bbiSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
mhc = new MonHocController();
if (mhc.CheckErr(txtTenMon.Text.Trim(), txtTenMon.Text.Trim(), txtHeSo.Text.Trim()))
{
if (_ID == null)
{
if (mhc.ThemMH(txtMaMH.Text.Trim(), txtTenMon.Text.Trim(), txtHeSo.Text.Trim()))
{
MessageBox.Show("Thành Công", "Thông tin", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Lỗi", "Thông tin", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
if (mhc.SuaMH(txtMaMH.Text.Trim(), txtTenMon.Text.Trim(), txtHeSo.Text.Trim(), txtMaMH.Text.Trim()))
{
MessageBox.Show("Thành Công", "Thông tin", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Lỗi", "Thông tin", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmLopMonHoc_Load(object sender, EventArgs e)
{
if (this.LopMonHocController == null)
{
this.LopMonHocController = new LopMonHocController();
}
if (this.NamHocController == null)
{
this.NamHocController = new NamHocController();
}
if (this.KhoiLopController == null)
{
this.KhoiLopController = new KhoiLopController();
}
if (this.LopController == null)
{
this.LopController = new LopController();
}
if (this.MonHocController == null)
{
this.MonHocController = new MonHocController();
}
this.NamHocController.HienThiCombobox(this.cmbNamHoc);
this.KhoiLopController.HienThiCombobox(this.cmbKhoiLop);
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmMonHoc_Load(object sender, EventArgs e)
{
//Khoi tao doi tuong m_Controller
if (this.Controller == null)
{
this.Controller = new MonHocController();
}
this.Controller.HienThiDS(dgvDS, bnDS);
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmbHocKy_SelectedIndexChanged(object sender, EventArgs e)
{
if ((this.cmbHocKy.SelectedIndex != -1) && (this.lvDSLopHoc.SelectedItems.Count > 0))
{
PhanLopInfo phanLop = new PhanLopController().LayTuMa(((DataRow)((object[])this.lvDSLopHoc.SelectedItems[0].Tag)[1])["MaHocSinhLop"].ToString());
MonHocInfo monHoc = new MonHocController().LayTuMa(((DataRowView)this.cmbMonHoc.SelectedItem).Row.ItemArray[2].ToString());
HocKyInfo hocKy = new HocKyController().LayTuMa(((DataRowView)this.cmbHocKy.SelectedItem).Row.ItemArray[0].ToString());
this.DiemController.HienThiDS(this.dgvDSDiem, this.bnDSDiem, phanLop, monHoc, hocKy);
}
else
{
this.DiemController.Data.DataService.Clear();
}
}
private void frmTimGiaoVien1_Load(object sender, EventArgs e)
{
//Khoi tao doi tuong m_Controller
if (this.Controller == null)
{
this.Controller = new GiaoVienController();
}
//Khoi tao doi tuong m_MonHocController
if (this.MonHocController == null)
{
this.MonHocController = new MonHocController();
}
this.MonHocController.HienThiDataGridComboBoxColumn(this.colMonHoc);
}
/// <summary>
///
/// </summary>
public string PhatSinhMa()
{
string lastID = new MonHocController().LayMaCuoi();
int numOfLastID;
//khi chua co record nao trong csdl this lastID se la "", khi co ta bat dau tu 1
if (lastID == "")
{
numOfLastID = 1;
}
else
{
numOfLastID = int.Parse(lastID.Substring(2, 2));
numOfLastID++;
}
return("MH" + (numOfLastID + 100).ToString().Substring(1, 2));
}
private void btnSua_Click(object sender, EventArgs e)
{
Mhc = new MonHocController();
if (!Mhc.CheckErr(txtMaMon.Text.Trim(), txtTenMonHoc.Text.Trim(), txtHeSo.Text.Trim()))
{
return;
}
if (Mhc.SuaMH(txtMaMon.Text, txtTenMonHoc.Text, txtHeSo.Text, IDmember))
{
MessageBox.Show("Thành Công", "Thông tin", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Lỗi", "Thông tin", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Hienthi(_Query);
dtgrv.Refresh();
}
public frmThaoTacmMH(string id)
{
InitializeComponent();
_ID = id;
mhc = new MonHocController();
MonHoc mh = new MonHoc();
//Xử lý mã lớp
DataTable dt = sqlHelper.Query("SELECT Malop FROM Lop");
if (id == null)
{
txtMaMH.Enabled = true;
return;
}
mh = mhc.GetData(id);
txtMaMH.Text = mh.MaMon;
txtTenMon.Text = mh.TenMon;
txtHeSo.Text = mh.HeSo;
}
public void Hienthi()
{
lstMH = MonHocController.getAllDataSubject();
DataTable dt = ViewHelper.ToDataTable <MonHoc>(lstMH);
dtgMonHoc.DataSource = dt;
dtgMonHoc.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dt.Columns["MaMon"].ColumnName = "Mã Môn";
dt.Columns["TenMon"].ColumnName = "Tên Môn";
dt.Columns["Khoi"].ColumnName = "Khối";
int i = 0;
foreach (DataGridViewColumn col in dtgMonHoc.Columns)
{
col.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
col.HeaderCell.Style.Font = new Font("Arial", 12F, FontStyle.Bold, GraphicsUnit.Pixel);
dtgMonHoc.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
i++;
}
try { dtgMonHoc.CurrentCell = dtgMonHoc[CurCl, CurR]; } catch { }
dtgMonHoc.Refresh();
}
public frmMonHoc(MonHocController mh)
{
InitializeComponent();
this.Controller = mh;
}
public frmMonHoc()
{
InitializeComponent();
this.Controller = new MonHocController();
}
