private void btnThemHe4_Click(object sender, EventArgs e)
{
if (!DuLieuHopLe())
{
return;
}
string diemhe4chu = txtDiemHe4Chu.Text;
string xeploai = txtXepLoaiHe4.Text;
string danhgia = txtDanhGiaHe4.Text;
float diemhe4so = float.Parse(txtDiemHe4So.Text);
float diemhe10min = float.Parse(txtDiemHe10Min.Text);
float diemhe10max = float.Parse(txtDiemHe10Max.Text);
DiemHe4 diemhe4 = new DiemHe4(diemhe4chu, diemhe4so, diemhe10min, diemhe10max, xeploai, danhgia);
if (diemhe4BUS.Them(diemhe4))
{
MessageBox.Show("Thành công !");
bs.DataSource = diemhe4BUS.DanhSach();
}
else
{
MessageBox.Show("Lỗi !", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
txtDiemHe4Chu.Focus();
}
public bool Delete(DiemHe4 diemhe4)
{
string query = "DELETE FROM DiemHe4" +
" WHERE DiemHe4Chu=@DiemHe4Chu";
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@DiemHe4Chu", SqlDbType.VarChar);
sqlParameters[0].Value = diemhe4.DiemHe4So;
return(executeDeleteQuery(query, sqlParameters));
}
public bool Insert(DiemHe4 diemhe4)
{
string query = "INSERT INTO DiemHe4 (DiemHe4Chu, DiemHe4So, DiemHe10Min, DiemHe10Max, XepLoai, DanhGia) " +
"VALUES (@DiemHe4Chu, @DiemHe4So, @DiemHe10Min, @DiemHe10Max, @XepLoai, @DanhGia)";
SqlParameter[] sqlParameters = new SqlParameter[6];
sqlParameters[0] = new SqlParameter("@DiemHe4Chu", SqlDbType.VarChar);
sqlParameters[0].Value = diemhe4.DiemHe4So;
sqlParameters[1] = new SqlParameter("@DiemHe4So", SqlDbType.Float);
sqlParameters[1].Value = diemhe4.DiemHe4So;
sqlParameters[2] = new SqlParameter("@DiemHe10Min", SqlDbType.Float);
sqlParameters[2].Value = diemhe4.DiemHe10Min;
sqlParameters[3] = new SqlParameter("@DiemHe10Max", SqlDbType.Float);
sqlParameters[3].Value = diemhe4.DiemHe10Max;
sqlParameters[4] = new SqlParameter("@XepLoai", SqlDbType.VarChar);
sqlParameters[4].Value = diemhe4.XepLoai;
sqlParameters[5] = new SqlParameter("@DanhGia", SqlDbType.VarChar);
sqlParameters[5].Value = diemhe4.DanhGia;
return(executeInsertQuery(query, sqlParameters));
}
public bool Update(DiemHe4 diemhe4)
{
string query = "UPDATE DiemHe4" +
" SET DiemHe4So=@DiemHe4So, DiemHe10Min=@DiemHe10Min, DiemHe10Max=DiemHe10Max, XepLoai=@XepLoai, DanhGia=@DanhGia" +
" WHERE DiemHe4Chu=@DiemHe4Chu";
SqlParameter[] sqlParameters = new SqlParameter[6];
sqlParameters[0] = new SqlParameter("@DiemHe4Chu", SqlDbType.VarChar);
sqlParameters[0].Value = diemhe4.DiemHe4So;
sqlParameters[1] = new SqlParameter("@DiemHe4So", SqlDbType.Float);
sqlParameters[1].Value = diemhe4.DiemHe4So;
sqlParameters[2] = new SqlParameter("@DiemHe10Min", SqlDbType.Float);
sqlParameters[2].Value = diemhe4.DiemHe10Min;
sqlParameters[3] = new SqlParameter("@DiemHe10Max", SqlDbType.Float);
sqlParameters[3].Value = diemhe4.DiemHe10Max;
sqlParameters[4] = new SqlParameter("@XepLoai", SqlDbType.VarChar);
sqlParameters[4].Value = diemhe4.XepLoai;
sqlParameters[5] = new SqlParameter("@DanhGia", SqlDbType.VarChar);
sqlParameters[5].Value = diemhe4.DanhGia;
return(executeUpdateQuery(query, sqlParameters));
}
private void btnXoaHe4_Click(object sender, EventArgs e)
{
if (gridviewxemdiem.SelectedCells.Count <= 0)
{
return;
}
string diemhe4chu = gridviewxemdiem.SelectedCells[0].OwningRow.Cells[0].Value.ToString();
DiemHe4 diemhe4 = new DiemHe4();
diemhe4.DiemHe4Chu = diemhe4chu;
if (diemhe4BUS.Xoa(diemhe4))
{
MessageBox.Show("Thành công !");
bs.DataSource = diemhe4BUS.DanhSach();
}
else
{
MessageBox.Show("Lỗi !", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
txtDiemHe4Chu.Focus();
}
public bool Sua(DiemHe4 diemhe4)
{
bool result = false;
return(result);
}
