private void btnUpdate_Click(object sender, EventArgs e)
{
int currentRowIndex = dtgChucVu.CurrentCellAddress.Y;
CHUCVU_DTO chucvu = new CHUCVU_DTO(dtgChucVu.CurrentRow.Cells[0].Value.ToString(), txbTenChucVu.Text, float.Parse(txbHeSoCV.Text), txbGhiChu.Text);
if (-1 < currentRowIndex && currentRowIndex < dtgChucVu.RowCount)
{
MessageBox.Show("Cập nhập Thành Công " + chucvu.MaCV);
CHUCVU_DAL.Instance.UpdateChucVu(chucvu);
}
loadListDanhChucVu();
}
public List <CHUCVU_DTO> LoadListChucVu()
{
List <CHUCVU_DTO> Chucvu = new List <CHUCVU_DTO>();
string query = "SELECT * FROM dbo.CHUCVU ";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
CHUCVU_DTO chucvu = new CHUCVU_DTO(item);
Chucvu.Add(chucvu);
}
return(Chucvu);
}
private void button1_Click(object sender, EventArgs e)
{
string MaChucVu = txbMaChucVu.Text;
string TenChucVu = txbTenChucVu.Text;
float HeSo = float.Parse(txbHeSoCV.Text);
string GhiChu = txbGhiChu.Text;
CHUCVU_DTO chucvu = new CHUCVU_DTO(MaChucVu, TenChucVu, HeSo, GhiChu);
if (CHUCVU_DAL.Instance.checkIsExist(chucvu.MaCV))
{
MessageBox.Show("Mã Chức Vụ đã tồn tại, thêm thất bại");
}
else
{
CHUCVU_DAL.Instance.addChucVu(chucvu);
MessageBox.Show("Thêm thành công Chức Vụ");
}
}
public void UpdateChucVu(CHUCVU_DTO chucvu)
{
string query = string.Format("UPDATE dbo.CHUCVU SET TenCV = N'{0}', HeSoCV = N'{1}', GhiChu = N'{2}' WHERE MaCV = N'{3}' ", chucvu.TenCV, chucvu.HeSoCV, chucvu.GhiChu, chucvu.MaCV);
DataProvider.Instance.ExecuteNonQuery(query);
}
public void addChucVu(CHUCVU_DTO chucvu)
{
string query = string.Format("INSERT INTO dbo.CHUCVU (MaCV,TenCV,HeSoCV,GhiChu) VALUES (N'{0}',N'{1}',{2},N'{3}')", chucvu.MaCV, chucvu.TenCV, chucvu.HeSoCV, chucvu.GhiChu);
DataTable result = DataProvider.Instance.ExecuteQuery(query);
}
