public void themdulieu(Entity_RenLuyen et)
{
cn.ThucthiSQL(@"INSERT INTO tblRenLuyen (MaSV, MaNamHoc, RenLuyen) VALUES (N'" + et.MaSV + "',N'" + et.MaNamHoc + "',N'" + et.RenLuyen + "')");
}
public void themdulieu(Entity_NguoiDung et)
{
cn.ThucthiSQL(@"INSERT INTO tblNguoiDung (TaiKhoan,TenNguoiDung, MatKhau, LoaiNguoiDung, MaXacNhan) VALUES (N'" + et.TaiKhoan + "',N'" + et.TenNguoiDung + "',N'" + et.MatKhau + "',N'" + et.LoaiNguoiDung + "',N'" + et.MaXacNhan + "')");
}
public void themdulieu(Entity_SinhVien et)
{
cn.ThucthiSQL(@"INSERT INTO tblSinhVien (MaSV, HoSV, TenSV, NgaySinh, GioiTinh, QueQuan, MaLop)
VALUES (N'" + et.MaSV + "',N'" + et.HoSV + "',N'" + et.TenSV + "',N'" + et.NgaySinh + "',N'" + et.GioiTinh + "',N'" + et.QueQuan + "',N'" + et.MaLop + "')");
}
public void themdulieu(Entity_NamHoc et)
{
cn.ThucthiSQL("INSERT INTO tblNamHoc (MaNamHoc, NamHoc) VALUES (N'" + et.MaNamHoc + "',N'" + et.NamHoc + "')");
}
public void themdulieu(Entity_MonHoc et)
{
cn.ThucthiSQL(@"INSERT INTO tblMonHoc (MaMH, TenMH, SoTC) VALUES (N'" + et.MaMH + "',N'" + et.TenMH + "',N'" + et.SoTC + "')");
}
public void themdulieu(Entity_Diem et)
{
cn.ThucthiSQL(@"INSERT INTO tblDiem (MaSV, MaMH,MaNamHoc, DiemCC,DiemKT1,DiemKT2,DiemGK,DiemThi) VALUES (N'" + et.MaSV + "',N'" + et.MaMH + "',N'" + et.MaNamHoc + "',N'" + et.DiemCC + "',N'" + et.DiemKT1 + "',N'" + et.DiemKT2 + "',N'" + et.DiemGK + "',N'" + et.DiemThi + "')");
}
public void themdulieu(Entity_ChuyenNganh et)
{
cn.ThucthiSQL(@"INSERT INTO tblChuyenNganh (MaChuyenNganh, TenChuyenNganh) VALUES (N'" + et.MaChuyenNganh + "',N'" + et.TenChuyenNganh + "')");
}
public void themdulieu(Entity_Lop et)
{
cn.ThucthiSQL(@"INSERT INTO tblLop (MaLop, TenLop, MaChuyenNganh,SiSo) VALUES (N'" + et.MaLop + "',N'" + et.TenLop + "',N'" + et.MaChuyenNganh + "',N'" + et.SiSo + "')");
}