private void UpdateSoDangKyMax(ref DoanhNghiep doanhNghiep, CommonENum.THU_TUC_ID thuTuc = CommonENum.THU_TUC_ID.THU_TUC_99, int soDangKyMax = 1)
{
if (doanhNghiep != null)
{
var maThuTuc = (int)thuTuc;
switch (maThuTuc)
{
case 0: doanhNghiep.SoThuTuc0CA = soDangKyMax; break;
case 1: doanhNghiep.SoThuTuc1CA = soDangKyMax; break;
case 2: doanhNghiep.SoThuTuc2CA = soDangKyMax; break;
case 3: doanhNghiep.SoThuTuc3CA = soDangKyMax; break;
case 4: doanhNghiep.SoThuTuc4CA = soDangKyMax; break;
case 5: doanhNghiep.SoThuTuc5CA = soDangKyMax; break;
case 6: doanhNghiep.SoThuTuc6CA = soDangKyMax; break;
case 7: doanhNghiep.SoThuTuc7CA = soDangKyMax; break;
case 8: doanhNghiep.SoThuTuc8CA = soDangKyMax; break;
case 9: doanhNghiep.SoThuTuc9CA = soDangKyMax; break;;
case 10: doanhNghiep.SoThuTuc10CA = soDangKyMax; break;
}
}
}
private int SoDangKyMax(DoanhNghiep doanhNghiep, CommonENum.THU_TUC_ID thuTuc = CommonENum.THU_TUC_ID.THU_TUC_99)
{
if (doanhNghiep != null)
{
var maThuTuc = (int)thuTuc;
switch (maThuTuc)
{
case 0: return(doanhNghiep.SoThuTuc0CA.HasValue ? doanhNghiep.SoThuTuc0CA.Value : 0);
case 1: return(doanhNghiep.SoThuTuc1CA.HasValue ? doanhNghiep.SoThuTuc1CA.Value : 0);
case 2: return(doanhNghiep.SoThuTuc2CA.HasValue ? doanhNghiep.SoThuTuc2CA.Value : 0);
case 3: return(doanhNghiep.SoThuTuc3CA.HasValue ? doanhNghiep.SoThuTuc3CA.Value : 0);
case 4: return(doanhNghiep.SoThuTuc4CA.HasValue ? doanhNghiep.SoThuTuc4CA.Value : 0);
case 5: return(doanhNghiep.SoThuTuc5CA.HasValue ? doanhNghiep.SoThuTuc5CA.Value : 0);
case 6: return(doanhNghiep.SoThuTuc6CA.HasValue ? doanhNghiep.SoThuTuc6CA.Value : 0);
case 7: return(doanhNghiep.SoThuTuc7CA.HasValue ? doanhNghiep.SoThuTuc7CA.Value : 0);
case 8: return(doanhNghiep.SoThuTuc8CA.HasValue ? doanhNghiep.SoThuTuc8CA.Value : 0);
case 9: return(doanhNghiep.SoThuTuc9CA.HasValue ? doanhNghiep.SoThuTuc9CA.Value : 0);
case 10: return(doanhNghiep.SoThuTuc10CA.HasValue ? doanhNghiep.SoThuTuc10CA.Value : 0);
}
}
return(0);
}
private string SetPath(DoanhNghiep dn)
{
var path = "";
path = !string.IsNullOrEmpty(dn.Tinh) ? RemoveUnicode(dn.Tinh).ToLower().Trim().Replace(" ", "-") : "unknown";
path = path + @"\" + dn.MaSoThue + @"\hosophaply\";
return(path);
}
protected void btnSave_Click(object sender, EventArgs e)
{
DoanhNghiep objDoanhNghiep = new DoanhNghiep();
objDoanhNghiep.delData(itemId);
Response.Redirect("DoanhNghiep.aspx");
}
public DoanhNghiep Update(DoanhNghiep DoanhNghiep)
{
if (this._db.State == ConnectionState.Closed)
{
_db.Open();
}
var sqlQuery = "UPDATE " + tableName + " SET " + propUpdate + " WHERE Ma = @Ma";
this._db.Execute(sqlQuery, DoanhNghiep);
return(DoanhNghiep);
}
public DoanhNghiep Add(DoanhNghiep doanhNghiep)
{
if (this._db.State == ConnectionState.Closed)
{
_db.Open();
}
var sqlQuery = "INSERT INTO " + tableName + " (" + propName + ") VALUES(" + propValue + "); " + "SELECT CAST(SCOPE_IDENTITY() as int)";
var doanhNghiepId = this._db.Query <int>(sqlQuery, doanhNghiep).Single();
doanhNghiep.Id = doanhNghiepId;
return(doanhNghiep);
}
public DoanhNghiep Find(string mst, List <DoanhNghiep> lstDoanhNghiep)
{
try
{
DoanhNghiep[] lst = new DoanhNghiep[lstDoanhNghiep.Count];
lstDoanhNghiep.CopyTo(lst);
var node = lst.Where(x => !string.IsNullOrEmpty(x.Ma) && x.Ma == mst);
return(node.FirstOrDefault());
}
catch
{
return(new DoanhNghiep());
}
}
public static DoanhNghiepDTO FromEntity(DoanhNghiep item)
{
return(new DoanhNghiepDTO()
{
Id = item.Id,
NgayUngTuyen = item.NgayUngTuyen,
TenDoanhNghiep = item.TenDoanhNghiep,
LogoDoanhNghiep = item.LogoDoanhNghiep,
Account = item.Account,
SĐT = item.SĐT,
Email = item.Email,
DiaChi = item.DiaChi,
GioiThieu = item.GioiThieu,
BaiTuyenDung = item.BaiTuyenDung?.Select(BaiTuyenDungDTO.FromEntity),
});
}
private void ImportPMQLDA()
{
string jsonPage, fullUrlAPI;
List <DoanhNghiepModel> lstDNDetail = new List <DoanhNghiepModel>();
DoanhNghiepRepos doanhNghiepRepos = new DoanhNghiepRepos();
for (int i = 1; i <= pageTotal; i++)
{
try
{
fullUrlAPI = string.Format(APIUrl.APIListDoanhNghiep, apiUrl, 100, i);
jsonPage = Library.GetReleases(fullUrlAPI);
var _obj = JsonConvert.DeserializeObject <ObjFromJson>(jsonPage);
lstDNDetail = Library.GetListDoanhNghiepFormMaSoThue(_obj.LtsItems.Select(x => x.MaSoThue).ToList());
for (int j = 0, n = lstDNDetail.Count; j < n; j++)
{
DoanhNghiep doanhNghiep = new DoanhNghiep()
{
Ma = lstDNDetail[j].MaSoThue,
DiaChi = lstDNDetail[j].DiaChiCongTy,
DienThoai = "",
Email = "",
NguoiDaiDien = lstDNDetail[j].GiamDoc,
ChucVu = !string.IsNullOrEmpty(lstDNDetail[j].GiamDoc) ? "Giám đốc" : "",
Ten = lstDNDetail[j].Title,
ThoiGian = !string.IsNullOrEmpty(lstDNDetail[j].QuyetDinhThanhLap_NgayCap) ? Convert.ToDateTime(lstDNDetail[j].QuyetDinhThanhLap_NgayCap) : (DateTime?)null
};
doanhNghiepRepos.Add(doanhNghiep);
}
//Show trạng thái trên form
this.Invoke(new Action(() =>
{
toolStripProgressBar1.Value = (int)Math.Round((double)i * 100 / pageTotal);
toolStripStatusLabel1.Text = "Đang convert: " + diaBanText + " (" + toolStripProgressBar1.Value + "%)";
}));
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Có lỗi xảy ra");
}
}
}
public async Task <IActionResult> Get(int id)
{
if (id.ToString() == null)
{
return(BadRequest(new
{
success = false,
error = "id is not null"
}));
}
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
DoanhNghiep doanhNghiep = await doanhNghiepRepository.Get(w => w.ma_doanh_nghiep == id);
if (doanhNghiep == null)
{
return(NotFound(new
{
success = false,
error = "Company is not found"
}));
}
return(Ok(new
{
success = true,
data = doanhNghiep
}));
}
catch (Exception e)
{
return(NotFound(new
{
success = false,
error = "Company is not found + " + e.InnerException.Message
}));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ACCOUNT"] == null)
{
Response.Redirect("../Login.aspx");
}
else
{
DataTable tblPermission = (DataTable)Session["Permission"];
_Permission = new Account().PermissionPage(tblPermission, System.IO.Path.GetFileName(Request.PhysicalPath));
if (_Permission == null || (bool)_Permission["View"] != true)
{
Response.Redirect("default.aspx");
}
}
if (Request.QueryString["id"] != null && Request.QueryString["id"].ToString().Trim() != "")
{
itemId = int.Parse(Request["id"].ToString());
}
if (!Page.IsPostBack)
{
LuongToiThieuVung();
if (itemId > 0)
{
#region load thong tin tin tham dinh
DataRow rowTroCapThatNghiep = new NLDTroCapThatNghiep().getItem(itemId);
DataTable tblNguoiLaoDong = new NguoiLaoDong().getDataById((int)rowTroCapThatNghiep["IDNguoiLaoDong"]);
if (tblNguoiLaoDong.Rows.Count > 0)
{
txtHoVaTen.Text = tblNguoiLaoDong.Rows[0]["HoVaTen"].ToString();
hdIDNguoiLaoDong.Value = tblNguoiLaoDong.Rows[0]["IDNguoiLaoDong"].ToString();
txtNgaySinh.Value = ((DateTime)tblNguoiLaoDong.Rows[0]["NgaySinh"]).ToString("dd/MM/yyyy");
if (tblNguoiLaoDong.Rows[0]["IdGioiTinh"].ToString().Trim() == "0")
{
chkGioiTinhNu.Checked = true;
chkGioiTinhNam.Checked = false;
}
else
{
chkGioiTinhNam.Checked = true;
chkGioiTinhNu.Checked = false;
}
txtCMND.Text = tblNguoiLaoDong.Rows[0]["CMND"].ToString();
// Noi Cap CMND
txtNoiCap.Text = tblNguoiLaoDong.Rows[0]["NoiCap"].ToString();
if (tblNguoiLaoDong.Rows[0]["NgayCapCMND"].ToString().Trim() != "" && ((DateTime)tblNguoiLaoDong.Rows[0]["NgayCapCMND"]).ToString("yyyy") != "1900")
{
txtNgayCap.Value = ((DateTime)tblNguoiLaoDong.Rows[0]["NgayCapCMND"]).ToString("dd/MM/yyyy");
}
txtSoBHXH.Text = tblNguoiLaoDong.Rows[0]["BHXH"].ToString();
txtSoDienThoai.Text = tblNguoiLaoDong.Rows[0]["DienThoai"].ToString();
// noi truong tru
string thuongtru = "";
thuongtru += tblNguoiLaoDong.Rows[0]["Xom_TT"].ToString() + ", ";
thuongtru += tblNguoiLaoDong.Rows[0]["Xa_TT"].ToString() + ", ";
thuongtru += tblNguoiLaoDong.Rows[0]["Huyen_TT"].ToString() + ", ";
thuongtru += tblNguoiLaoDong.Rows[0]["Tinh_TT"].ToString();
txtNoiThuongTru.Text = thuongtru;
string choohientai = "";
choohientai += tblNguoiLaoDong.Rows[0]["Xom_DC"].ToString() + ", ";
choohientai += tblNguoiLaoDong.Rows[0]["Xa_DC"].ToString() + ", ";
choohientai += tblNguoiLaoDong.Rows[0]["Huyen_DC"].ToString() + ", ";
choohientai += tblNguoiLaoDong.Rows[0]["Tinh_DC"].ToString();
txtChoOHienTai.Text = choohientai;
txtSoThangDongBHXH.Text = rowTroCapThatNghiep["SoThangDongBHXH"].ToString();
if (rowTroCapThatNghiep["NgayNghiViec"] != null && rowTroCapThatNghiep["NgayNghiViec"].ToString() != "")
{
txtNgayNghiViec.Value = ((DateTime)rowTroCapThatNghiep["NgayNghiViec"]).ToString("dd/MM/yyyy");
}
if (rowTroCapThatNghiep["NgayNopHoSo"] != null && rowTroCapThatNghiep["NgayNopHoSo"].ToString() != "")
{
DateTime NgayHoanThien = (DateTime)rowTroCapThatNghiep["NgayNopHoSo"];
txtNgayNopHoSo.Value = NgayHoanThien.ToString("dd/MM/yyyy");
lblNgayDangKy.Text = ((DateTime)rowTroCapThatNghiep["NgayNopHoSo"]).ToString("dd/MM/yyyy");
}
}
DataTable tblTinhHuong = new TinhHuong().getDataById(itemId);
if (tblTinhHuong.Rows.Count > 0)
{
ddlLuongToiThieu.SelectedValue = Math.Round((decimal)tblTinhHuong.Rows[0]["LuongToiThieuVung"], 0).ToString();
txtThangThu1.Value = tblTinhHuong.Rows[0]["ThangDong1"].ToString();
txtMucDongThang1.Text = Math.Round((decimal)tblTinhHuong.Rows[0]["MucDong1"], 0).ToString();
txtThangThu2.Value = tblTinhHuong.Rows[0]["ThangDong2"].ToString();
txtMucDongThang2.Text = Math.Round((decimal)tblTinhHuong.Rows[0]["MucDong2"], 0).ToString();
txtThangThu3.Value = tblTinhHuong.Rows[0]["ThangDong3"].ToString();
txtMucDongthang3.Text = Math.Round((decimal)tblTinhHuong.Rows[0]["MucDong3"], 0).ToString();
txtThangThu4.Value = tblTinhHuong.Rows[0]["ThangDong4"].ToString();
txtMucDongThang4.Text = Math.Round((decimal)tblTinhHuong.Rows[0]["MucDong4"], 0).ToString();
txtThangThu5.Value = tblTinhHuong.Rows[0]["ThangDong5"].ToString();
txtMucDongThang5.Text = Math.Round((decimal)tblTinhHuong.Rows[0]["MucDong5"], 0).ToString();
txtThangThu6.Value = tblTinhHuong.Rows[0]["ThangDong6"].ToString();
txtMucDongThang6.Text = Math.Round((decimal)tblTinhHuong.Rows[0]["MucDong6"], 0).ToString();
int SoThangHuong = (int)tblTinhHuong.Rows[0]["SoThangHuongBHXH"];
txtSoThangHuong.Text = SoThangHuong.ToString();
txtMucHuongToiDa.Text = Math.Round((decimal)tblTinhHuong.Rows[0]["MucHuongToiDa"], 0).ToString();
txtLuongTrungBinh.Text = Math.Round((decimal)tblTinhHuong.Rows[0]["LuongTrungBinh"], 0).ToString();
txtMucHuong.Text = Math.Round((decimal)tblTinhHuong.Rows[0]["MucHuong"], 0).ToString();
txtSoThangBaoLuu.Text = tblTinhHuong.Rows[0]["SoThangBaoLuuBHXH"].ToString();
txtHuongTuNgay.Value = ((DateTime)tblTinhHuong.Rows[0]["HuongTuNgay"]).ToString("dd/MM/yyyy");
txtHuongDenNgay.Value = ((DateTime)tblTinhHuong.Rows[0]["HuongDenNgay"]).ToString("dd/MM/yyyy");
int IDDoanhNghiep = 0;
int.TryParse(rowTroCapThatNghiep["IdQuaTrinhCongTacGanNhat"].ToString(), out IDDoanhNghiep);
DataTable tblDoanhNghiep = new DoanhNghiep().getDataById(IDDoanhNghiep);
if (tblDoanhNghiep.Rows.Count > 0)
{
txtTenCongTy.Text = tblDoanhNghiep.Rows[0]["TenDonVi"].ToString();
}
}
#endregion
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ACCOUNT"] == null)
{
Response.Redirect("../Login.aspx");
}
Session["TITLE"] = "THÔNG TIN TUYỂN DỤNG";
try
{
this.itemId = int.Parse(Request["id"].ToString());
}
catch
{
this.itemId = 0;
}
try
{
this.IdDonVi = int.Parse(Request.QueryString["did"].ToString());
}
catch
{
this.IdDonVi = 0;
}
try
{
this.tenDonVi = Request.QueryString["n"].ToString();
}
catch
{
this.tenDonVi = "";
}
if (!Page.IsPostBack)
{
DoanhNghiep objDoanhNghiep = new DoanhNghiep();
DataTable objdata = objDoanhNghiep.getDataById(this.IdDonVi);
if (objdata.Rows.Count > 0)
{
this.txtIDDonVi.Value = objdata.Rows[0]["IDDonVi"].ToString();
this.txtTenDonVi.Text = objdata.Rows[0]["TenDonVi"].ToString();
nganhnghebuf = objdata.Rows[0]["IDNganhNghe"].ToString();
}
}
this.txtIDTuyenDung.Value = this.itemId.ToString();
if (!Page.IsPostBack)
{
if (Session["TuyenDungMessage"] != null)
{
this.lblMsg.Text = Session["TuyenDungMessage"].ToString();
Session["TuyenDungMessage"] = null;
}
this.ddlNhomNganh.DataSource = this.objNhomNganh.getDataCategoryToCombobox();
this.ddlNhomNganh.DataTextField = "NameNhomNganh";
this.ddlNhomNganh.DataValueField = "IdNhomNganh";
this.ddlNhomNganh.DataBind();
this.ddlNhomNganh.SelectedValue = "0";
this.ddlIDTinh.DataSource = this.objProvincer.getDataCategoryToCombobox();
this.ddlIDTinh.DataTextField = "Name";
this.ddlIDTinh.DataValueField = "Id";
this.ddlIDTinh.DataBind();
this.ddlIDTinh.SelectedValue = "0";
ViTri objViTri = new ViTri();
this.ddlIdVitri.DataSource = objViTri.getDataCategoryToCombobox();
this.ddlIdVitri.DataTextField = "NameViTri";
this.ddlIdVitri.DataValueField = "ID";
this.ddlIdVitri.DataBind();
this.ddlIdVitri.SelectedValue = "0";
this.ddlIDChucVu.DataSource = this.objChucVu.getDataCategoryToCombobox();
this.ddlIDChucVu.DataTextField = "NameChucVu";
this.ddlIDChucVu.DataValueField = "IDChucVu";
this.ddlIDChucVu.DataBind();
this.ddlIDChucVu.SelectedValue = "0";
TrinhDoTinHoc objTrinhDoTinHoc = new TrinhDoTinHoc();
this.ddlTinHoc.DataSource = objTrinhDoTinHoc.getDataCategoryToCombobox();
this.ddlTinHoc.DataTextField = "NameTrinhDo";
this.ddlTinHoc.DataValueField = "ID";
this.ddlTinHoc.DataBind();
this.ddlTinHoc.SelectedValue = "0";
TrinhDoNgoaiNgu objTrinhDoNgoaiNgu = new TrinhDoNgoaiNgu();
this.ddlTrinhDoNgoaiNgu.DataSource = objTrinhDoNgoaiNgu.getDataCategoryToCombobox();
this.ddlTrinhDoNgoaiNgu.DataTextField = "NameTrinhDo";
this.ddlTrinhDoNgoaiNgu.DataValueField = "ID";
this.ddlTrinhDoNgoaiNgu.DataBind();
this.ddlTrinhDoNgoaiNgu.SelectedValue = "0";
this.ddlIDDoTuoi.DataSource = this.objDoTuoi.getDataCategoryToCombobox();
this.ddlIDDoTuoi.DataTextField = "NameDoTuoi";
this.ddlIDDoTuoi.DataValueField = "IDDoTuoi";
this.ddlIDDoTuoi.DataBind();
this.ddlIDDoTuoi.SelectedValue = "0";
this.ddlIDGioiTinh.DataSource = this.objGioiTinh.getDataCategoryToCombobox("Nam/nữ");
this.ddlIDGioiTinh.DataTextField = "NameGioiTinh";
this.ddlIDGioiTinh.DataValueField = "IDGioiTinh";
this.ddlIDGioiTinh.DataBind();
this.ddlIDGioiTinh.SelectedValue = "0";
this.ddlIDTrinhDoChuyenMon.DataSource = this.objTrinhDoChuyenMon.getDataCategoryToCombobox();
this.ddlIDTrinhDoChuyenMon.DataTextField = "NameTrinhDoChuyenMon";
this.ddlIDTrinhDoChuyenMon.DataValueField = "IDTrinhDoChuyenMon";
this.ddlIDTrinhDoChuyenMon.DataBind();
this.ddlIDTrinhDoChuyenMon.SelectedValue = "0";
this.ddlIDMucLuong.DataSource = this.objMucluong.getDataCategoryToCombobox();
this.ddlIDMucLuong.DataTextField = "NameMucLuong";
this.ddlIDMucLuong.DataValueField = "IDMucLuong";
this.ddlIDMucLuong.DataBind();
this.ddlIDMucLuong.SelectedValue = "0";
NgoaiNgu objNgoaiNgu = new NgoaiNgu();
this.ddlyeuCauNgoaiNgu.DataSource = objNgoaiNgu.getDataCategoryToCombobox();
this.ddlyeuCauNgoaiNgu.DataTextField = "NameNgoaiNgu";
this.ddlyeuCauNgoaiNgu.DataValueField = "IDNgoaiNgu";
this.ddlyeuCauNgoaiNgu.DataBind();
this.ddlyeuCauNgoaiNgu.SelectedValue = "0";
TinHoc objTinHoc = new TinHoc();
this.ddlyeuCauTinHoc.DataSource = objTinHoc.getDataCategoryToCombobox();
this.ddlyeuCauTinHoc.DataTextField = "NameTinHoc";
this.ddlyeuCauTinHoc.DataValueField = "IDTinHoc";
this.ddlyeuCauTinHoc.DataBind();
this.ddlyeuCauTinHoc.SelectedValue = "0";
}
if (!Page.IsPostBack && this.itemId > 0)
{
this.objTable = this.objTuyenDung.getDataById(this.itemId);
if (this.objTable.Rows.Count > 0)
{
this.txtMaTuyenDung.Text = this.objTable.Rows[0]["MaTuyenDung"].ToString();
this.txtIDDonVi.Value = this.objTable.Rows[0]["IDDonVi"].ToString();
this.txtTenDonVi.Text = this.objTable.Rows[0]["TenDonVi"].ToString();
this.ddlNhomNganh.SelectedValue = this.objTable.Rows[0]["IDNhomNghanh"].ToString();
this.ddlNganhNghe.DataSource = this.objNganhNghe.getDataCategoryToCombobox(this.ddlNhomNganh.SelectedValue.ToString());
this.ddlNganhNghe.DataTextField = "NameDTNganhNghe";
this.ddlNganhNghe.DataValueField = "IDDTNganhNghe";
this.ddlNganhNghe.DataBind();
this.ddlNganhNghe.SelectedValue = this.objTable.Rows[0]["IDNganhNghe"].ToString();
this.ddlIDChucVu.SelectedValue = this.objTable.Rows[0]["IDChucVu"].ToString();
this.ddlTrinhDoNgoaiNgu.SelectedValue = this.objTable.Rows[0]["IdTrinhDoNgoaiNgu"].ToString();
this.ddlTinHoc.SelectedValue = this.objTable.Rows[0]["IdTrinhDoTinHoc"].ToString();
this.ddlIdVitri.SelectedValue = this.objTable.Rows[0]["IdViTri"].ToString();
this.txtSoLuongTuyenDung.Text = this.objTable.Rows[0]["SoLuongTuyenDung"].ToString();
this.ddlIDDoTuoi.SelectedValue = this.objTable.Rows[0]["IDDoTuoi"].ToString();
this.ddlIDGioiTinh.SelectedValue = this.objTable.Rows[0]["IDGioiTinh"].ToString();
this.txtUuTien.Text = this.objTable.Rows[0]["UuTien"].ToString();
this.ddlIDTrinhDoChuyenMon.SelectedValue = this.objTable.Rows[0]["IDTrinhDoChuyenMon"].ToString();
this.txtNoiDungKhac.Text = this.objTable.Rows[0]["NoiDungKhac"].ToString();
this.txtMoTa.Text = this.objTable.Rows[0]["MoTa"].ToString();
this.txtDiaDiem.Text = this.objTable.Rows[0]["DiaDiem"].ToString();
this.ddlIDMucLuong.SelectedValue = this.objTable.Rows[0]["IDMucLuong"].ToString();
this.ckbNuocNgoai.Checked = bool.Parse(this.objTable.Rows[0]["NuocNgoai"].ToString());
this.txtQuyenLoi.Text = this.objTable.Rows[0]["QuyenLoi"].ToString();
this.txtNgayBatDau.Value = DateTime.Parse(this.objTable.Rows[0]["NgayBatDau"].ToString()).ToString("dd/MM/yyyy");
this.txtNgayKetThuc.Value = DateTime.Parse(this.objTable.Rows[0]["NgayKetThuc"].ToString()).ToString("dd/MM/yyyy");
this.ckbState.Checked = bool.Parse(this.objTable.Rows[0]["State"].ToString());
this.ddlyeuCauNgoaiNgu.SelectedValue = this.objTable.Rows[0]["YCNgoaiNgu"].ToString();
this.ddlyeuCauTinHoc.SelectedValue = this.objTable.Rows[0]["YCTinHoc"].ToString();
this.txtNamKinhNghiem.Text = this.objTable.Rows[0]["NamKinhNghiem"].ToString();
this.ddlThoiGianLamViec.SelectedValue = this.objTable.Rows[0]["ThoiGianLamViec"].ToString();
this.txtIdQuocGia.Value = this.objTable.Rows[0]["IdQuocGia"].ToString();
this.txtNameQuocGia.Value = this.objTable.Rows[0]["NameQuocGia"].ToString();
}
}
this.txtMaTuyenDung.Focus();
}
public async Task <IActionResult> GetList([FromQuery] string?ten_doanh_nghiep, DateTime?startTime, int?pageIndex)
{
try
{
string tempt = null;
ListResponse <DanhSachDN_Job> list = new ListResponse <DanhSachDN_Job>();
DoanhNghiep doanhNghiep = new DoanhNghiep();
int key = 0;
while (key == 0)
{
if ((ten_doanh_nghiep == null) && (startTime == null))
{
key = 1; break;
}
if ((ten_doanh_nghiep == null) && (startTime != null))
{
key = 2; break;
}
if ((ten_doanh_nghiep != null) && (startTime == null))
{
key = 3; break;
}
if ((ten_doanh_nghiep != null) && (startTime != null))
{
key = 4; break;
}
}
switch (key)
{
case 1:
list = await danhSachDNJobRepository.GetList(tempt, pageIndex, w => w.trang_thai == false);
break;
case 2:
list = await danhSachDNJobRepository.GetList(tempt, pageIndex, w => w.trang_thai == false && w.ngay_dang >= startTime);
break;
case 3:
doanhNghiep = await doanhNghiepRepository.Get(w => w.ten_doanh_nghiep == ten_doanh_nghiep);
if (doanhNghiep == null)
{
return(NotFound(new
{
data = "No results"
}));
}
else
{
list = await danhSachDNJobRepository.GetList(tempt, pageIndex, w => w.trang_thai == false && w.ma_doanh_nghiep == doanhNghiep.ma_doanh_nghiep);
}
break;
case 4:
doanhNghiep = await doanhNghiepRepository.Get(w => w.ten_doanh_nghiep == ten_doanh_nghiep);
if (doanhNghiep == null)
{
return(NotFound(new
{
data = "No results"
}));
}
else
{
list = await danhSachDNJobRepository.GetList(tempt, pageIndex, w => w.trang_thai == false && w.ma_doanh_nghiep == doanhNghiep.ma_doanh_nghiep && w.ngay_dang >= startTime);
}
break;
}
if (list != null)
{
return(Ok(new
{
code = 200,
data = list,
success = "sucesss"
}));
}
else
{
return(NotFound(new
{
data = "Null"
}));
}
}
catch (NullReferenceException e)
{
return(BadRequest(new
{
code = 400,
error = "Get list job of company Fail : Error" + e.InnerException.Message
}));
}
}
public async Task <ServiceResult> UpdateDoanhNghiep(DoanhNghiep doanhNghiep)
{
await _doanhNghiepRepository.UpdateAsync(doanhNghiep);
return(ServiceResult.Success);
}
public async Task UpdateDoanhNghiep(DoanhNghiep doanhNghiep)
{
await _doanhNghiepRepository.UpdateAsync(doanhNghiep);
}
public async Task CreateDoanhNghiep(DoanhNghiep doanhNghiep)
{
await _doanhNghiepRepository.AddAsync(doanhNghiep);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ACCOUNT"] == null)
{
Response.Redirect("../Login.aspx");
}
Session["TITLE"] = "THÔNG TIN TUYỂN DỤNG";
try
{
string[] abc = Request["id"].ToString().Split(',');
counti = abc.Length;
arrayItem = new int[counti];
for (int i = 0; i < counti; i++)
{
arrayItem[i] = int.Parse(abc[i]);
}
}
catch
{
counti = 0;
}
if (!Page.IsPostBack && counti != 0)
{
objData = objTuyenDung.getDataView(arrayItem);
if (objData.Rows.Count > 0)
{
DoanhNghiep objDoanhNghiep = new DoanhNghiep();
DataTable objDataDN = objDoanhNghiep.getDataViewById((int)objData.Rows[0]["IDDonVi"]);
if (objDataDN.Rows.Count > 0)
{
nameDoanhNghiep = objDataDN.Rows[0]["TenDonVi"].ToString().ToUpper();
nameNganhNghe = objDataDN.Rows[0]["NganhNgheName"].ToString();
}
Mucluong objMucLuong = new Mucluong();
nameMucLuong = objMucLuong.getNameMucLuongById((int)objData.Rows[0]["IDMucLuong"]);
diaDiem = objData.Rows[0]["DiaDiem"].ToString();
dtlTuyenDung.DataSource = objData.DefaultView;
dtlTuyenDung.DataBind();
//nameViTri = objData.Rows[0]["SoLuongTuyenDung"].ToString() + " ";
//try
//{
// nameViTri = objViTri.getNameViTriById((int)objData.Rows[0]["IdViTri"]);
//}
//catch
//{
// nameViTri = " nhân viên";
//}
//mota = objData.Rows[0]["MoTa"].ToString();
quyenLoi = objData.Rows[0]["QuyenLoi"].ToString();
this.AboutUsData = this.objAboutUs.getData();
}
}
}
public async Task <IActionResult> CreateAccount([FromBody] CreateAccountCompanyCommand command)
{
try
{
if (command.password != command.password_confirm)
{
return(BadRequest(new
{
error = "The password comfirm is not the same as The password"
}));
}
else
{
// password Length of password is >= 8 and any character is number and any character is upper and case better to have a special then Symbol
var expectedPasswordPattern = new Regex(@"^(?=.*?[A-Z])(?=.*?[a-z])(?=.*?[0-9])(?=.*?[#?!@$%^&*-]).{8,}$");
var isValidPassword = expectedPasswordPattern.IsMatch(command.password);
if (isValidPassword == true)
{
// Get account by email
Account account = new Account();
account = await accountRepository.Get(w => w.email == command.email);
if (account == null)
{
KhachHang kh = new KhachHang();
// Add new customer
kh.ten_kh = command.ten_kh;
kh.sdt = command.sdt;
await khachHangRepository.Create(kh);
int ma = 0;
// Add Company
DoanhNghiep dn = new DoanhNghiep();
Account account_new = new Account();
account_new.ma_kh = kh.ma_kh;
DoanhNghiep ct = new DoanhNghiep();
ct = await doanhNghiepRepository.Get(w => w.ten_doanh_nghiep == command.ten_doanh_nghiep);
if (ct != null)
{
account_new.ma_dn = ct.ma_doanh_nghiep;
ma = ct.ma_doanh_nghiep;
dn.ma_doanh_nghiep = ct.ma_doanh_nghiep;
}
else
{
//await doanhNghiepService.Sort();
// Add company
dn.ten_doanh_nghiep = command.ten_doanh_nghiep;
dn.mo_ta = command.mo_ta;
dn.ma_doanh_nghiep = doanhNghiepService.Count() + 1;
await doanhNghiepRepository.Create(dn);
account_new.ma_dn = dn.ma_doanh_nghiep;
ma = dn.ma_doanh_nghiep;
}
// get ma_thanh_pho
var ma_tp = await thanhPhoService.GetId(command.ten_thanh_pho);
// Add Dia chi
DiaChi address = new DiaChi();
address.ma_doanh_nghiep = ma;
address.ma_thanh_pho = ma_tp;
address.mo_ta = command.dia_chi_cu_the;
await diaChiRepository.Create(address);
// Add account
account_new.email = command.email;
account_new.password = HashHelper.Hash(command.password);
account_new.rolecode = 2;
account_new.createtime = DateTime.Now;
try
{
await accountRepository.Create(account_new);
return(Ok(new
{
code = 200,
success = "register is success"
}));
}
catch (Exception e)
{
return(BadRequest(new
{
error = "Add account fail - " + e.InnerException.Message
}));
}
}
else
{
return(BadRequest(new
{
code = 400,
error = "Email is exist"
}));
}
}
else
{
return(BadRequest(new
{
code = 404,
error = "password Length of password is >= 8 and any character is number and any character is upper and case better to have a special then Symbol"
}));
}
}
}
catch (Exception e)
{
return(BadRequest(new
{
code = 400,
error = "Create account of Company fail + " + e.InnerException.Message
}));
}
}
protected void btnXuatExcel_Click(object sender, EventArgs e)
{
string str = txtSearch.Value.Trim();
DateTime TuNgay = new DateTime(1900, 1, 1), DenNgay = new DateTime(9999, 1, 1);
if (txtTuNgay.Value.Trim() != "")
{
TuNgay = Convert.ToDateTime(txtTuNgay.Value, new CultureInfo("vi-VN"));
}
if (txtDenNgay.Value.Trim() != "")
{
DenNgay = Convert.ToDateTime(txtDenNgay.Value, new CultureInfo("vi-VN"));
}
DataTable MyTB = new BaoCao().DanhSachLaoDongHuongTCTN(TuNgay, DenNgay);
string data = "<table cellpadding='0' cellspacing='0'>";
data += "<tr><td colspan='4'><div align='center' style='font-size:14px; font-family:Times New Roman'>SỞ LAO ĐỘNG TB&XH NGHỆ AN<br />";
data += "<strong>TRUNG TÂM DỊCH VỤ VIỆC LÀM</strong> </div></td>";
data += "<td colspan='5'><div align='center' style='font-size:14px; font-family:Times New Roman'>CỘNG HÒA XÃ HỘI CHỦ NGHĨA VIỆT NAM<strong><br />";
data += "Độc lập - Tự do - Hạnh phúc</strong></div></td></tr>";
data += "<tr><td style='text-align:center;font-family:Times New Roman;font-weight:bold;font-size:14px;padding:10pt;' colspan='9'>DANH SÁCH LAO ĐỘNG HOÀN THÀNH HỒ SƠ HƯỞNG CHẾ ĐỘ BHTN</td></tr>";
data += "<tr><td style='text-align:center;font-family:Times New Roman;font-weight:bold;font-size:14px;padding:10pt;' colspan='9'>";
if (txtTuNgay.Value != "" && txtDenNgay.Value != "")
{
data += "Từ ngày: " + txtTuNgay.Value + " " + "Đến ngày: " + txtDenNgay.Value;
}
data += "</td></tr>";
data += "<tr><td style='text-align:center;font-family:Times New Roman;font-weight:bold;font-size:12px;padding:10pt;border-bottom-width:thin;border-bottom-color:Black;border-bottom-style:solid;border-right-width:thin;border-right-color:Black;border-right-style:solid;border-top-width:thin;border-top-color:Black;border-top-style:solid;'>STT</td>";
data += "<td style='text-align:center;font-family:Times New Roman;font-weight:bold;font-size:12px;padding:10pt;border-bottom-width:thin;border-bottom-color:Black;border-bottom-style:solid;border-right-width:thin;border-right-color:Black;border-right-style:solid;border-top-width:thin;border-top-color:Black;border-top-style:solid;'>Số BHXH</td>";
data += "<td style='text-align:center;font-family:Times New Roman;font-weight:bold;font-size:12px;padding:10pt;border-bottom-width:thin;border-bottom-color:Black;border-bottom-style:solid;border-right-width:thin;border-right-color:Black;border-right-style:solid;border-top-width:thin;border-top-color:Black;border-top-style:solid;'>Họ tên</td>";
data += "<td style='text-align:center;font-family:Times New Roman;font-weight:bold;font-size:12px;padding:10pt;border-bottom-width:thin;border-bottom-color:Black;border-bottom-style:solid;border-right-width:thin;border-right-color:Black;border-right-style:solid;border-top-width:thin;border-top-color:Black;border-top-style:solid;'>Ngày sinh</td>";
data += "<td style='text-align:center;font-family:Times New Roman;font-weight:bold;font-size:12px;padding:10pt;border-bottom-width:thin;border-bottom-color:Black;border-bottom-style:solid;border-right-width:thin;border-right-color:Black;border-right-style:solid;border-top-width:thin;border-top-color:Black;border-top-style:solid;'>Giới tính</td>";
data += "<td style='text-align:center;font-family:Times New Roman;font-weight:bold;font-size:12px;padding:10pt;border-bottom-width:thin;border-bottom-color:Black;border-bottom-style:solid;border-right-width:thin;border-right-color:Black;border-right-style:solid;border-top-width:thin;border-top-color:Black;border-top-style:solid;'>Nơi ở hiện nay</td>";
data += "<td style='text-align:center;font-family:Times New Roman;font-weight:bold;font-size:12px;padding:10pt;border-bottom-width:thin;border-bottom-color:Black;border-bottom-style:solid;border-right-width:thin;border-right-color:Black;border-right-style:solid;border-top-width:thin;border-top-color:Black;border-top-style:solid;'>CMND</td>";
data += "<td style='text-align:center;font-family:Times New Roman;font-weight:bold;font-size:12px;padding:10pt;border-bottom-width:thin;border-bottom-color:Black;border-bottom-style:solid;border-right-width:thin;border-right-color:Black;border-right-style:solid;border-top-width:thin;border-top-color:Black;border-top-style:solid;'>Ngày tiếp nhận</td>";
data += "<td style='text-align:center;font-family:Times New Roman;font-weight:bold;font-size:12px;padding:10pt;border-bottom-width:thin;border-bottom-color:Black;border-bottom-style:solid;border-right-width:thin;border-right-color:Black;border-right-style:solid;border-top-width:thin;border-top-color:Black;border-top-style:solid;'>Tên công ty</td></tr>";
for (int i = 0; i < MyTB.Rows.Count; i++)
{
data += "<tr><td style='text-align:left;font-family:Times New Roman;font-weight:normal;font-size:12px;padding:10pt;border-bottom-width:thin;border-bottom-color:Black;border-bottom-style:solid;border-right-width:thin;border-right-color:Black;border-right-style:solid;border-top-width:thin;border-top-color:Black;border-top-style:solid;'>" + (i + 1).ToString();
data += "</td><td style='text-align:left;font-family:Times New Roman;font-weight:normal;font-size:12px;padding:10pt;border-bottom-width:thin;border-bottom-color:Black;border-bottom-style:solid;border-right-width:thin;border-right-color:Black;border-right-style:solid;border-top-width:thin;border-top-color:Black;border-top-style:solid;'>" + MyTB.Rows[i]["BHXH"].ToString();
data += "</td><td style='text-align:center;font-family:Times New Roman;font-weight:normal;font-size:12px;padding:10pt;border-bottom-width:thin;border-bottom-color:Black;border-bottom-style:solid;border-right-width:thin;border-right-color:Black;border-right-style:solid;border-top-width:thin;border-top-color:Black;border-top-style:solid;'>" + MyTB.Rows[i]["HoVaTen"].ToString();
data += "</td><td style='text-align:center;font-family:Times New Roman;font-weight:normal;font-size:12px;padding:10pt;border-bottom-width:thin;border-bottom-color:Black;border-bottom-style:solid;border-right-width:thin;border-right-color:Black;border-right-style:solid;border-top-width:thin;border-top-color:Black;border-top-style:solid;'>" + ((DateTime)MyTB.Rows[i]["NgaySinh"]).ToString("dd/MM/yyyy");
data += "</td><td style='text-align:center;font-family:Times New Roman;font-weight:normal;font-size:12px;padding:10pt;border-bottom-width:thin;border-bottom-color:Black;border-bottom-style:solid;border-right-width:thin;border-right-color:Black;border-right-style:solid;border-top-width:thin;border-top-color:Black;border-top-style:solid;'>" + GetGoiTinh((int)MyTB.Rows[i]["IDGioiTinh"]);
data += "</td><td style='text-align:center;font-family:Times New Roman;font-weight:normal;font-size:12px;padding:10pt;border-bottom-width:thin;border-bottom-color:Black;border-bottom-style:solid;border-right-width:thin;border-right-color:Black;border-right-style:solid;border-top-width:thin;border-top-color:Black;border-top-style:solid;'>" + GetDiaChi(MyTB.Rows[i]["Tinh_DC"].ToString(), MyTB.Rows[i]["Huyen_DC"].ToString(), MyTB.Rows[i]["Xa_DC"].ToString(), MyTB.Rows[i]["Xom_DC"].ToString());
data += "</td><td style='text-align:center;font-family:Times New Roman;font-weight:normal;font-size:12px;padding:10pt;border-bottom-width:thin;border-bottom-color:Black;border-bottom-style:solid;border-right-width:thin;border-right-color:Black;border-right-style:solid;border-top-width:thin;border-top-color:Black;border-top-style:solid;'>" + MyTB.Rows[i]["CMND"].ToString();
data += "<td style='text-align:center;font-family:Times New Roman;font-weight:bold;font-size:12px;padding:10pt;border-bottom-width:thin;border-bottom-color:Black;border-bottom-style:solid;border-right-width:thin;border-right-color:Black;border-right-style:solid;border-top-width:thin;border-top-color:Black;border-top-style:solid;'>" + ((DateTime)MyTB.Rows[i]["NgayNopHoSo"]).ToString("dd/MM/yyyy");
string tencongty = "";
try
{
DataTable tblDoanhNghiep = new DoanhNghiep().getDataById((int)MyTB.Rows[i]["IdDoanhNghiep"]);
tencongty = tblDoanhNghiep.Rows[0]["TenDonVi"].ToString();
}
catch {
}
data += "</td><td style='text-align:center;font-family:Times New Roman;font-weight:normal;font-size:12px;padding:10pt;border-bottom-width:thin;border-bottom-color:Black;border-bottom-style:solid;border-right-width:thin;border-right-color:Black;border-right-style:solid;border-top-width:thin;border-top-color:Black;border-top-style:solid;'>" + tencongty;
data += "</td></tr>";
}
data += "<tr><td style='text-align:center;font-family:Times New Roman;font-weight:bold;font-size:14px;padding:10pt;' colspan='9'>";
data += "<tr><td colspan='3'style='text-align:center;font-family:Times New Roman;font-weight:bold;font-size:12px;padding:10pt;'>NGƯỜI LẬP</td>";
data += "<td colspan='3'style='text-align:center;font-family:Times New Roman;font-weight:bold;font-size:12px;padding:10pt;'>TRƯỞNG PHÒNG BHTN</td>";
data += "<td colspan='3'style='text-align:center;font-family:Times New Roman;font-weight:bold;font-size:12px;padding:10pt;'>KT. GIÁM ĐỐC PHÓ GIÁM ĐỐC</td></tr>";
data += "</table>";
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("content-disposition", "attachment;filename=Bao-cao-BHTN.xls");
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.Charset = "Utf-8";
EnableViewState = false;
Response.Write(data);
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ACCOUNT"] == null)
{
Response.Redirect("../Login.aspx");
}
// Session["TITLE"] = "THÔNG TIN TUYỂN DỤNG";
try
{
this.itemId = int.Parse(Request["did"].ToString());
}
catch
{
this.itemId = 0;
}
try
{
this.IdDonVi = int.Parse(Request.QueryString["did"].ToString());
}
catch
{
this.IdDonVi = 0;
}
try
{
this.tenDonVi = Request.QueryString["n"].ToString();
}
catch
{
this.tenDonVi = "";
}
if (!Page.IsPostBack)
{
DoanhNghiep objDoanhNghiep = new DoanhNghiep();
DataTable objdata = objDoanhNghiep.getDataById(this.IdDonVi);
if (objdata.Rows.Count > 0)
{
this.txtTenDonVi.Text = objdata.Rows[0]["TenDonVi"].ToString();
nganhnghebuf = objdata.Rows[0]["IDNganhNghe"].ToString();
}
}
if (!Page.IsPostBack)
{
if (Session["TuyenDungMessage"] != null)
{
Session["TuyenDungMessage"] = null;
}
this.ddlNhomNganh.DataSource = this.objNhomNganh.getDataCategoryToCombobox();
this.ddlNhomNganh.DataTextField = "NameNhomNganh";
this.ddlNhomNganh.DataValueField = "IdNhomNganh";
this.ddlNhomNganh.DataBind();
this.ddlNhomNganh.SelectedValue = "0";
ViTri objViTri = new ViTri();
this.ddlIdVitri.DataSource = objViTri.getDataCategoryToCombobox();
this.ddlIdVitri.DataTextField = "NameViTri";
this.ddlIdVitri.DataValueField = "ID";
this.ddlIdVitri.DataBind();
this.ddlIdVitri.SelectedValue = "0";
this.ddlIDChucVu.DataSource = this.objChucVu.getDataCategoryToCombobox();
this.ddlIDChucVu.DataTextField = "NameChucVu";
this.ddlIDChucVu.DataValueField = "IDChucVu";
this.ddlIDChucVu.DataBind();
this.ddlIDChucVu.SelectedValue = "0";
this.ddlIDNganhNghe.DataSource = this.objBusiness.getDataCategoryToCombobox();
this.ddlIDNganhNghe.DataTextField = "Name";
this.ddlIDNganhNghe.DataValueField = "Id";
this.ddlIDNganhNghe.DataBind();
this.ddlIDNganhNghe.SelectedValue = nganhnghebuf;
this.ddlIDDoTuoi.DataSource = this.objDoTuoi.getDataCategoryToCombobox();
this.ddlIDDoTuoi.DataTextField = "NameDoTuoi";
this.ddlIDDoTuoi.DataValueField = "IDDoTuoi";
this.ddlIDDoTuoi.DataBind();
this.ddlIDDoTuoi.SelectedValue = "0";
this.ddlIDGioiTinh.DataSource = this.objGioiTinh.getDataCategoryToCombobox("Nam/nữ");
this.ddlIDGioiTinh.DataTextField = "NameGioiTinh";
this.ddlIDGioiTinh.DataValueField = "IDGioiTinh";
this.ddlIDGioiTinh.DataBind();
this.ddlIDGioiTinh.SelectedValue = "0";
this.ddlIDTrinhDoChuyenMon.DataSource = this.objTrinhDoChuyenMon.getDataCategoryToCombobox();
this.ddlIDTrinhDoChuyenMon.DataTextField = "NameTrinhDoChuyenMon";
this.ddlIDTrinhDoChuyenMon.DataValueField = "IDTrinhDoChuyenMon";
this.ddlIDTrinhDoChuyenMon.DataBind();
this.ddlIDTrinhDoChuyenMon.SelectedValue = "0";
this.ddlIDMucLuong.DataSource = this.objMucluong.getDataCategoryToCombobox();
this.ddlIDMucLuong.DataTextField = "NameMucLuong";
this.ddlIDMucLuong.DataValueField = "IDMucLuong";
this.ddlIDMucLuong.DataBind();
this.ddlIDMucLuong.SelectedValue = "0";
NgoaiNgu objNgoaiNgu = new NgoaiNgu();
this.ddlyeuCauNgoaiNgu.DataSource = objNgoaiNgu.getDataCategoryToCombobox();
this.ddlyeuCauNgoaiNgu.DataTextField = "NameNgoaiNgu";
this.ddlyeuCauNgoaiNgu.DataValueField = "IDNgoaiNgu";
this.ddlyeuCauNgoaiNgu.DataBind();
this.ddlyeuCauNgoaiNgu.SelectedValue = "0";
TinHoc objTinHoc = new TinHoc();
this.ddlyeuCauTinHoc.DataSource = objTinHoc.getDataCategoryToCombobox();
this.ddlyeuCauTinHoc.DataTextField = "NameTinHoc";
this.ddlyeuCauTinHoc.DataValueField = "IDTinHoc";
this.ddlyeuCauTinHoc.DataBind();
this.ddlyeuCauTinHoc.SelectedValue = "0";
}
if (!Page.IsPostBack)
{
getData(); /*------------------------------------*/
this.objTable = this.objTuyenDung.getDataById(this.itemId);
if (this.objTable.Rows.Count > 0)
{
this.txtTenDonVi.Text = this.objTable.Rows[0]["TenDonVi"].ToString().ToUpper();
this.ddlNhomNganh.SelectedValue = this.objTable.Rows[0]["IDNhomNghanh"].ToString();
this.ddlIDChucVu.SelectedValue = this.objTable.Rows[0]["IDChucVu"].ToString();
this.ddlIdVitri.SelectedValue = this.objTable.Rows[0]["IdViTri"].ToString();
this.ddlIDNganhNghe.SelectedValue = this.objTable.Rows[0]["IDNganhNghe"].ToString();
this.lblIDNganhNghe.Text = this.ddlIDNganhNghe.SelectedItem.Text;
this.ddlIDDoTuoi.SelectedValue = this.objTable.Rows[0]["IDDoTuoi"].ToString();
this.ddlIDGioiTinh.SelectedValue = this.objTable.Rows[0]["IDGioiTinh"].ToString();
this.ddlIDTrinhDoChuyenMon.SelectedValue = this.objTable.Rows[0]["IDTrinhDoChuyenMon"].ToString();
this.ddlIDMucLuong.SelectedValue = this.objTable.Rows[0]["IDMucLuong"].ToString();
this.lblIDMucLuong.Text = this.ddlIDMucLuong.SelectedItem.Text;
this.txtQuyenLoi.Text = this.objTable.Rows[0]["QuyenLoi"].ToString();
this.ddlyeuCauNgoaiNgu.SelectedValue = this.objTable.Rows[0]["YCNgoaiNgu"].ToString();
this.ddlyeuCauTinHoc.SelectedValue = this.objTable.Rows[0]["YCTinHoc"].ToString();
this.txtDiaDiem.Text = this.objTable.Rows[0]["DiaDiem"].ToString();
this.ddlThoiGianLamViec.SelectedValue = this.objTable.Rows[0]["ThoiGianLamViec"].ToString();
}
}
}
