public bool deletedata(En_LoaiDiem en)
{
string query = string.Format("DELETE FROM LoaiDiem WHERE MaLD=@MaLD");
SqlParameter[] sqlPara = new SqlParameter[1];
sqlPara[0] = new SqlParameter("@MaLD", en.MaLD);
return(cnn.executeDeleteQuery(query, sqlPara));
}
private void frmLoaiDiem_Load(object sender, EventArgs e)
{
en = new En_LoaiDiem();
NapTrangThai();
NapDuLieu();
EvenButton(0);
EnableOrDisable(true);
}
public bool updatedata(En_LoaiDiem en)
{
string query = string.Format("UPDATE LoaiDiem SET TenLD = @TenLD, TrangThai = @TrangThai, NgayCapNhat = @NgayCapNhat WHERE MaLD=@MaLD");
SqlParameter[] sqlPara = new SqlParameter[4];
sqlPara[0] = new SqlParameter("@TenLD", en.TenLD);
sqlPara[1] = new SqlParameter("@TrangThai", en.TrangThai);
sqlPara[2] = new SqlParameter("@NgayCapNhat", en.NgayCapNhat);
sqlPara[3] = new SqlParameter("@MaLD", en.MaLD);
return(cnn.executeUpdateQuery(query, sqlPara));
}
public bool insertdata(En_LoaiDiem en)
{
string query = string.Format("INSERT INTO LoaiDiem(MaLD, TenLD, TrangThai, NgayTao, NgayCapNhat) VALUES(@MaLD, @TenLD, @TrangThai, @NgayTao, @NgayCapNhat)");
SqlParameter[] sqlPara = new SqlParameter[5];
sqlPara[0] = new SqlParameter("@MaLD", en.MaLD);
sqlPara[1] = new SqlParameter("@TenLD", en.TenLD);
sqlPara[2] = new SqlParameter("@TrangThai", en.TrangThai);
sqlPara[3] = new SqlParameter("@NgayTao", en.NgayTao);
sqlPara[4] = new SqlParameter("@NgayCapNhat", en.NgayCapNhat);
return(cnn.executeInsertQuery(query, sqlPara));
}
public void deletedata(En_LoaiDiem en)
{
dal.deletedata(en);
}
public void updatedata(En_LoaiDiem en)
{
dal.updatedata(en);
}
public void insertdata(En_LoaiDiem en)
{
dal.insertdata(en);
}
