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