public DataTable LoadLoaiHopDongFromHoSoNhanVien(LoaiHopDongDTO loaiHopDongDTO)
{
string sql = LoaiHopDongDAO.Instance.LoadLoaiHopDongFromHoSoNhanVien(loaiHopDongDTO);
DataTable dt = Core.GetData(sql);
return(dt);
}
private void btnCapNhat_Click(object sender, EventArgs e)
{
LoaiHopDongDTO loaiHopDongDTO = new LoaiHopDongDTO();
loaiHopDongDTO.LoaiHopDongID = LoaiHopDongID;
loaiHopDongDTO.TenLoaiHopDong = txtLoaiHopDong.Text.Trim();
if (kt == 1)
{
if (txtLoaiHopDong.Text == "")
{
MessageBox.Show("Bạn chưa nhập loại hợp đồng");
}
else
{
if (LoaiHopDongBUS.Instance.ThemLoaiHopDong(loaiHopDongDTO) == -1)
{
MessageBox.Show("Lỗi khi thêm mới");
}
else
{
Load_DL();
}
}
}
else
{
LoaiHopDongBUS.Instance.UpdateLoaiHopDong(loaiHopDongDTO);
Load_DL();
Reset();
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
LoaiHopDongDTO loaiHopDongDTO = new LoaiHopDongDTO();
loaiHopDongDTO.LoaiHopDongID = LoaiHopDongID;
DataTable dt = LoaiHopDongBUS.Instance.LoadLoaiHopDongFromHoSoNhanVien(loaiHopDongDTO);
if (dt.Rows.Count > 0)
{
MessageBox.Show("Bạn phải xóa bản ghi trong Hợp đồng");
}
else
{
LoaiHopDongBUS.Instance.DeleteLoaiHopDong(loaiHopDongDTO);
Load_DL();
Reset();
}
}
public string DeleteLoaiHopDong(LoaiHopDongDTO loaiHopDongDTO)
{
string sql = "Delete LoaiHopDong where LoaiHopDongID = '" + loaiHopDongDTO.LoaiHopDongID + "'";
return(sql);
}
public string LoadLoaiHopDongFromHoSoNhanVien(LoaiHopDongDTO loaiHopDongDTO)
{
string sql = "Select * from HopDong where LoaiHopDongID = '" + loaiHopDongDTO.LoaiHopDongID + "'";
return(sql);
}
public string UpdateLoaiHopDong(LoaiHopDongDTO loaiHopDongDTO)
{
string sql = "Update LoaiHopDong set TenLoaiHopDong = N'" + loaiHopDongDTO.TenLoaiHopDong + "' where LoaiHopDongID = '" + loaiHopDongDTO.LoaiHopDongID + "'";
return(sql);
}
public string ThemLoaiHopDong(LoaiHopDongDTO loaiHopDongDTO)
{
string sql = "Insert into LoaiHopDong(TenLoaiHopDong) values(N'" + loaiHopDongDTO.TenLoaiHopDong + "')";
return(sql);
}
public void DeleteLoaiHopDong(LoaiHopDongDTO loaiHopDongDTO)
{
Core.RunSql(LoaiHopDongDAO.Instance.DeleteLoaiHopDong(loaiHopDongDTO));
}
public void UpdateLoaiHopDong(LoaiHopDongDTO loaiHopDongDTO)
{
Core.RunSql(LoaiHopDongDAO.Instance.UpdateLoaiHopDong(loaiHopDongDTO));
}
public int ThemLoaiHopDong(LoaiHopDongDTO loaiHopDongDTO)
{
return(Core.RunSql(LoaiHopDongDAO.Instance.ThemLoaiHopDong(loaiHopDongDTO)));
}
