public int Update(CTDiem ctd)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter(PARM_MACTDIEM, SqlDbType.Int),
new SqlParameter(PARM_MABANGDIEM, SqlDbType.Int),
new SqlParameter(PARM_MAHOCSINH, SqlDbType.Int),
new SqlParameter(PARM_MAMONHOC, SqlDbType.Int),
new SqlParameter(PARM_MALOAIDIEM, SqlDbType.Int),
new SqlParameter(PARM_DIEM, SqlDbType.Int),
new SqlParameter(PARM_DIEMTBMON, SqlDbType.Float),
new SqlParameter(PARM_MAGIAOVIEN, SqlDbType.Int),
};
parm[0].Value = ctd.Mactdiem;
parm[1].Value = ctd.Mabangdiem;
parm[2].Value = ctd.Mahocsinh;
parm[3].Value = ctd.Mamonhoc;
parm[4].Value = ctd.Maloaidiem;
parm[5].Value = ctd.Diem;
parm[6].Value = ctd.Diemtbmon;
parm[7].Value = ctd.Magiaovien;
return(DataAccessHelper.ExecuteNonQuery(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_CTDiem_Upd", parm));
}
public int Update(Diem d)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter(PARM_MABANGDIEM, SqlDbType.Int),
new SqlParameter(PARM_MALOP, SqlDbType.Int),
new SqlParameter(PARM_MAHOCSINH, SqlDbType.Int),
new SqlParameter(PARM_KIHOC, SqlDbType.Int),
new SqlParameter(PARM_NAMHOC, SqlDbType.NVarChar, 20),
new SqlParameter(PARM_DIEMTB, SqlDbType.Float),
new SqlParameter(PARM_HANHKIEM, SqlDbType.NVarChar, 20),
new SqlParameter(PARM_HOCLUC, SqlDbType.NVarChar, 20),
new SqlParameter(PARM_DANHHIEU, SqlDbType.NVarChar, 20),
new SqlParameter(PARM_MAGIAOVIEN, SqlDbType.Int),
};
parm[0].Value = d.Mabangdiem;
parm[1].Value = d.Malop;
parm[2].Value = d.Mahocsinh;
parm[3].Value = d.Kihoc;
parm[4].Value = d.Namhoc;
parm[5].Value = d.Diemtb;
parm[6].Value = d.Hanhkiem;
parm[7].Value = d.Hocluc;
parm[8].Value = d.Danhhieu;
parm[9].Value = d.Magiaovien;
return(DataAccessHelper.ExecuteNonQuery(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_Diem_Upd", parm));
}
public int Delete(int makhoihoc)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter(PARM_MAKHOIHOC, SqlDbType.Int)
};
parm[0].Value = makhoihoc;
return(DataAccessHelper.ExecuteNonQuery(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_KhoiHoc_Del", parm));
}
public int Insert(KhoiHoc kh)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter(PARM_TENKHOIHOC, SqlDbType.NVarChar, 20)
};
parm[0].Value = kh.Tenkhoihoc;
return(DataAccessHelper.ExecuteNonQuery(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_KhoiHoc_Insert", parm));
}
public int Delete(int magiaovien)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter(PARM_MAGIAOVIEN, SqlDbType.Int)
};
parm[0].Value = magiaovien;
return(DataAccessHelper.ExecuteNonQuery(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_GiaoVien_Del", parm));
}
public int Delete(int maloaidiem)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter(PARM_MALOAIDIEM, SqlDbType.Int)
};
parm[0].Value = maloaidiem;
return(DataAccessHelper.ExecuteNonQuery(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_LoaiDiem_Del", parm));
}
public int Delete(int mahocsinh)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter(PARM_MAHOCSINH, SqlDbType.Int)
};
parm[0].Value = mahocsinh;
return(DataAccessHelper.ExecuteNonQuery(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_HocSinh_Del", parm));
}
public int Insert(MonHoc mh)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter(PARM_TENMONHOC, SqlDbType.NVarChar, 20),
new SqlParameter(PARM_SOTIET, SqlDbType.Int),
};
parm[0].Value = mh.Tenmonhoc;
parm[1].Value = mh.Sotiet;
return(DataAccessHelper.ExecuteNonQuery(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_MonHoc_Insert", parm));
}
public int Update(LoaiDiem ld)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter(PARM_MALOAIDIEM, SqlDbType.Int),
new SqlParameter(PARM_TENLOAIDIEM, SqlDbType.NVarChar, 20),
new SqlParameter(PARM_HESO, SqlDbType.Int),
};
parm[0].Value = ld.Maloaidiem;
parm[1].Value = ld.Tenloaidiem;
parm[2].Value = ld.Heso;
return(DataAccessHelper.ExecuteNonQuery(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_LoaiDiem_Upd", parm));
}
public int Update(LopHoc l)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter(PARM_MALOP, SqlDbType.Int),
new SqlParameter(PARM_TENLOP, SqlDbType.NVarChar, 20),
new SqlParameter(PARM_MAKHOI, SqlDbType.Int),
new SqlParameter(PARM_MAGIAOVIEN, SqlDbType.Int),
new SqlParameter(PARM_SISO, SqlDbType.Int),
};
parm[0].Value = l.Malop;
parm[1].Value = l.Tenlop;
parm[2].Value = l.Makhoihoc;
parm[3].Value = l.Magiaovien;
parm[4].Value = l.Siso;
return(DataAccessHelper.ExecuteNonQuery(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_LopHoc_Upd", parm));
}
public int Update(GiaoVien gv)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter(PARM_MAGIAOVIEN, SqlDbType.Int),
new SqlParameter(PARM_TENGIAOVIEN, SqlDbType.NVarChar, 20),
new SqlParameter(PARM_NGAYSINH, SqlDbType.DateTime),
new SqlParameter(PARM_GIOITINH, SqlDbType.NVarChar, 3),
new SqlParameter(PARM_QUEQUAN, SqlDbType.NVarChar, 20),
new SqlParameter(PARM_SODT, SqlDbType.NVarChar, 11),
new SqlParameter(PARM_SOCMND, SqlDbType.NVarChar, 11),
};
parm[0].Value = gv.Magiaovien;
parm[1].Value = gv.Tengiaovien;
parm[2].Value = gv.Ngaysinh;
parm[3].Value = gv.Gioitinh;
parm[4].Value = gv.Quequan;
parm[5].Value = gv.Sodienthoai;
parm[6].Value = gv.Socmnd;
return(DataAccessHelper.ExecuteNonQuery(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_GiaoVien_Upd", parm));
}
public int Insert(HocSinh hs)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter(PARM_MALOP, SqlDbType.Int),
new SqlParameter(PARM_TENHOCSINH, SqlDbType.NVarChar, 20),
new SqlParameter(PARM_NGAYSINH, SqlDbType.DateTime),
new SqlParameter(PARM_GIOITINH, SqlDbType.NVarChar, 3),
new SqlParameter(PARM_QUEQUAN, SqlDbType.NVarChar, 20),
new SqlParameter(PARM_SODT, SqlDbType.NVarChar, 11),
new SqlParameter(PARM_SOCMND, SqlDbType.NVarChar, 11),
};
parm[0].Value = hs.Malop;
parm[1].Value = hs.Tenhocsinh;
parm[2].Value = hs.Ngaysinh;
parm[3].Value = hs.Gioitinh;
parm[4].Value = hs.Quequan;
parm[5].Value = hs.Sodienthoai;
parm[6].Value = hs.Socmnd;
return(DataAccessHelper.ExecuteNonQuery(DataAccessHelper.ConnectionString, CommandType.StoredProcedure, "tbl_HocSinh_Insert", parm));
}