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); }