/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int ThemPhanLop(PhanLopInfo info)
{
DataService ds = new DataService();
SqlCommand cmd = new SqlCommand("INSERT INTO PHAN_LOP VALUES(@maHocSinhLop, @maLop, @maHocSinh)");
cmd.Parameters.Add("maHocSinhLop", SqlDbType.VarChar).Value = info.MaHocSinhLop;
cmd.Parameters.Add("maLop", SqlDbType.VarChar).Value = info.MaLop;
cmd.Parameters.Add("maHocSinh", SqlDbType.VarChar).Value = info.MaHocSinh;
return(ds.ExecuteNonQuery(cmd));
}
/// <summary>
///
/// </summary>
/// <param name="dgvDS"></param>
/// <param name="bnDS"></param>
/// <param name="phanLop"></param>
/// <param name="monHoc"></param>
/// <param name="hocKy"></param>
public void HienThiDS(DataGridView dgvDS, BindingNavigator bnDS, PhanLopInfo phanLop, MonHocInfo monHoc, HocKyInfo hocKy)
{
if (this.Data == null)
{
this.Data = new DiemData();
}
BindingSource bs = new BindingSource();
bs.DataSource = this.Data.LayDS(phanLop, monHoc, hocKy);
dgvDS.DataSource = bs;
bnDS.BindingSource = bs;
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btLuu_Click(object sender, EventArgs e)
{
//Dua con tro de bindingNavigatorPositionItem
this.bindingNavigatorPositionItem.Focus();
//Bind de dong cuoi de cap nhat thong tin tren DataGridView
this.bnDS.BindingSource.Position = int.Parse(this.bindingNavigatorPositionItem.Text);
//Neu luu thanh cong
if (!this.Controller.Update())
{
if (MessageBox.Show("Không thể lưu!\nBạn cần nhập đầy đủ thông tin trước khi lưu lại!\nBạn có muốn tiếp tục không?", "Lưu Học sinh", MessageBoxButtons.YesNo, MessageBoxIcon.Error) == DialogResult.No)
{
this.Controller.Data.LayDS();
this.btThemMoi.Enabled = true;
this.btXoa.Enabled = true;
this.btBoQua.Enabled = false;
this.btLuu.Enabled = false;
this.itThemMoi.Enabled = true;
this.itXoa.Enabled = true;
this.itBoQua.Enabled = false;
this.itLuu.Enabled = false;
}
}
else
{
//Neu trang thai la Them, them hoc sinh vao phan lop.
if (this.IsThem)
{
//Luu Hoc sinh vao phan lop
PhanLopController phanLopCtrl = new PhanLopController();
PhanLopInfo phanLopInfo = new PhanLopInfo();
phanLopInfo.MaHocSinhLop = PhanLopController.PhatSinhMa(this.LopInfo.MaLop);
phanLopInfo.MaLop = this.LopInfo.MaLop;
phanLopInfo.MaHocSinh = ((DataRowView)this.bnDS.BindingSource.Current)["MaHocSinh"].ToString();
phanLopCtrl.ThemPhanLop(phanLopInfo);
this.IsThem = false;
}
this.btThemMoi.Enabled = true;
this.btXoa.Enabled = true;
this.btBoQua.Enabled = false;
this.btLuu.Enabled = false;
this.itThemMoi.Enabled = true;
this.itXoa.Enabled = true;
this.itBoQua.Enabled = false;
this.itLuu.Enabled = false;
}
}
/// <summary>
///
/// </summary>
/// <param name="phanLop"></param>
/// <param name="monHoc"></param>
/// <param name="hocKy"></param>
/// <returns></returns>
public DataTable LayDS(PhanLopInfo phanLop, MonHocInfo monHoc, HocKyInfo hocKy)
{
if (this.DataService == null)
{
this.DataService = new DataService();
}
SqlCommand cmd = new SqlCommand("SELECT * FROM DIEM WHERE MaHocSinhLop=@maHocSinhLop AND MaMonHoc=@maMonHoc AND MaHocKy=@maHocKy");
cmd.Parameters.Add("maHocSinhlop", SqlDbType.VarChar).Value = phanLop.MaHocSinhLop;
cmd.Parameters.Add("maMonHoc", SqlDbType.VarChar).Value = monHoc.MaMonHoc;
cmd.Parameters.Add("maHocKy", SqlDbType.VarChar).Value = hocKy.MaHocKy;
this.DataService.Load(cmd);
return(this.DataService);
}
/// <summary>
/// Lay mot doi tuong phan lop tu ma lop
/// </summary>
/// <param name="maHocSinhLop"></param>
/// <returns></returns>
public PhanLopInfo LayTuMa(String maHocSinhLop)
{
if (this.Data == null)
{
this.Data = new PhanLopData();
}
DataTable table = this.Data.LayTuMa(maHocSinhLop);
if (table.Rows.Count > 0)
{
PhanLopInfo info = new PhanLopInfo();
info.MaHocSinhLop = table.Rows[0]["MaHocSinhLop"].ToString();
info.MaHocSinh = table.Rows[0]["MaHocSinh"].ToString();
info.MaLop = table.Rows[0]["MaLop"].ToString();
return(info);
}
return(null);
}
/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int ThemPhanLop(PhanLopInfo info)
{
PhanLopData phanLopData = new PhanLopData();
return(phanLopData.ThemPhanLop(info));
}
