public bool deletedata(En_GiaoVien en)
{
string query = string.Format("DELETE FROM GiaoVien WHERE MaGV=@MaGV");
SqlParameter[] sqlPara = new SqlParameter[1];
sqlPara[0] = new SqlParameter("@MaGV", en.MaGV);
return(cnn.executeDeleteQuery(query, sqlPara));
}
public bool deletedata(En_User en)
{
string query = string.Format("DELETE FROM [User] WHERE TaiKhoan=@TaiKhoan");
SqlParameter[] sqlPara = new SqlParameter[1];
sqlPara[0] = new SqlParameter("@TaiKhoan", en.TaiKhoan);
return(cnn.executeDeleteQuery(query, sqlPara));
}
public bool deletedata(En_Lop en)
{
string query = string.Format("DELETE FROM Lop WHERE MaL=@MaL");
SqlParameter[] sqlPara = new SqlParameter[1];
sqlPara[0] = new SqlParameter("@MaL", en.MaL);
return(cnn.executeDeleteQuery(query, sqlPara));
}
public bool deletedata(En_MonHoc en)
{
string query = string.Format("DELETE FROM MonHoc WHERE MaMH=@MaMH");
SqlParameter[] sqlPara = new SqlParameter[1];
sqlPara[0] = new SqlParameter("@MaMH", en.MaMH);
return(cnn.executeDeleteQuery(query, sqlPara));
}
public bool deletedata(En_Diem en)
{
string query = string.Format("DELETE FROM Diem WHERE id=@id");
SqlParameter[] sqlPara = new SqlParameter[1];
sqlPara[0] = new SqlParameter("@id", en.id);
return(cnn.executeDeleteQuery(query, sqlPara));
}