public void XoaNamHoc(QLKTX.BusinessObject.NamHocInfo namhoc)
{
com = new SqlCommand();
com.CommandText = "Delete NamHoc where MANAMHOC=@maso";
com.Parameters.Add("@maso", SqlDbType.VarChar, 5).Value = namhoc.MaNamHoc;
ser.Load(com);
}
public void SuaNamHoc(QLKTX.BusinessObject.NamHocInfo namhoc)
{
com = new SqlCommand();
com.CommandText = "Update NamHoc set TENNAMHOC = @ten,NGAYBATDAU= @ngayBatdau,NGAYKETTHUC=@ngayKetThuc where MANAMHOC=@maso";
com.Parameters.Add("@maso", SqlDbType.VarChar, 5).Value = namhoc.MaNamHoc;
com.Parameters.Add("@ten", SqlDbType.NVarChar, 20).Value = namhoc.TenNamHoc;
com.Parameters.Add("@ngayBatDau", SqlDbType.DateTime).Value = namhoc.NgayBatDau;
com.Parameters.Add("@ngayKetThuc", SqlDbType.DateTime).Value = namhoc.NgayKetThuc;
ser.Load(com);
}
public void ThemNamHoc(QLKTX.BusinessObject.NamHocInfo namhoc)
{
com = new SqlCommand();
com.CommandText = "Insert Into NamHoc values(@maso,@ten,@ngayBatdau,@ngayKetThuc)";
com.Parameters.Add("@maso", SqlDbType.VarChar, 5).Value = namhoc.MaNamHoc;
com.Parameters.Add("@ten", SqlDbType.NVarChar, 20).Value = namhoc.TenNamHoc;
com.Parameters.Add("@ngayBatDau", SqlDbType.DateTime).Value = namhoc.NgayBatDau;
com.Parameters.Add("@ngayKetThuc", SqlDbType.DateTime).Value = namhoc.NgayKetThuc;
ser.Load(com);
}
