示例#1
0
        public int Insert(TinTuyenDungDTO newrecord)
        {
            int result;
            try
            {
                SqlConnection connect = new SqlConnection(SqlDataAccess.ConnectionString);
                connect.Open();
                try
                {
                    SqlCommand cmd = new SqlCommand("sp_insertTINTUYENDUNG", connect);
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;
                    SqlParameter ViTriTuyenDung_param = cmd.Parameters.Add("@ViTriTuyenDung", System.Data.SqlDbType.NVarChar);
                    SqlParameter MoTaCongViec_param = cmd.Parameters.Add("@MoTaCongViec", System.Data.SqlDbType.NVarChar);
                    SqlParameter KyNangCongViec_param = cmd.Parameters.Add("@KyNangCongViec", System.Data.SqlDbType.NVarChar);
                    SqlParameter MaSoCongViec_param = cmd.Parameters.Add("@MaSoCongViec", System.Data.SqlDbType.NVarChar);
                    SqlParameter LoaiUngVien_param = cmd.Parameters.Add("@LoaiUngVien", System.Data.SqlDbType.Int);
                    SqlParameter NhaTuyenDung_param = cmd.Parameters.Add("@NhaTuyenDung", System.Data.SqlDbType.Int);

                    ViTriTuyenDung_param.Direction = System.Data.ParameterDirection.Input;
                    MoTaCongViec_param.Direction = System.Data.ParameterDirection.Input;
                    KyNangCongViec_param.Direction = System.Data.ParameterDirection.Input;
                    MaSoCongViec_param.Direction = System.Data.ParameterDirection.Input;
                    LoaiUngVien_param.Direction = System.Data.ParameterDirection.Input;
                    NhaTuyenDung_param.Direction = System.Data.ParameterDirection.Input;

                    ViTriTuyenDung_param.Value = newrecord.ViTriTuyenDung;
                    MoTaCongViec_param.Value = newrecord.MoTaCongViec;
                    KyNangCongViec_param.Value = newrecord.KyNangCongViec;
                    MaSoCongViec_param.Value = newrecord.MaSoCongViec;
                    LoaiUngVien_param.Value = newrecord.LoaiUngVien;
                    NhaTuyenDung_param.Value = newrecord.NhanTuyenDung;

                    result = cmd.ExecuteNonQuery();
                }
                catch (System.Exception ex)
                {
                    throw ex;
                }
                finally
                {
                    connect.Close();
                }
            }
            catch (Exception e)
            {
                throw e;
            }
            return result;
        }
示例#2
0
 public int Insert(TinTuyenDungDTO newrecord)
 {
     TinTuyenDungDAO dao = new TinTuyenDungDAO();
     return dao.Insert(newrecord);
 }
        protected void DongY_Click(object sender, EventArgs e)
        {
            MoTaCongViecDTO motacongviec = new MoTaCongViecDTO();
            motacongviec.KyNangCongViec = KyNangCongViec.Value.ToString();
            motacongviec.MoTaCongViec = MoTaCongViec.Value.ToString();
            motacongviec.ViTriTuyenDung = ViTriTuyenDung.Value.ToString();

            ThongTinViecLamDTO thongtinvieclam = new ThongTinViecLamDTO();
            thongtinvieclam.MaSoCongViec = MaSoCongViec.Value.ToString();
            thongtinvieclam.SoLuong = Int32.Parse(SoLuong.Value.ToString());
            thongtinvieclam.TuoiMin = Int32.Parse(TuoiMin.Value.ToString());
            thongtinvieclam.TuoiMax = Int32.Parse(TuoiMax.Value.ToString());
            thongtinvieclam.QuocGia = Int32.Parse(QuocGiaList.Value.ToString());
            thongtinvieclam.TinhThanh = Int32.Parse(TinhThanhList.Value.ToString());
            thongtinvieclam.MucLuong = Int32.Parse(MucLuong.Value.ToString());
            thongtinvieclam.PhuCapKhac = PhuCap.Value.ToString();
            thongtinvieclam.SoNamKinhNghiem = Int32.Parse(KinhNghiem.Value.ToString());
            //thongtinvieclam.HanNopSoSo = DateTime.Parse(HanNopHoSo.Value.ToString());
            thongtinvieclam.GioiTinh = Int32.Parse(GioiTinh.Value.ToString());

            LoaiCongViecDTO LoaiCongViec = new LoaiCongViecDTO();

            if (Checkbox1.Checked == true)
            {
                LoaiCongViec.TenCongViec = "Full-time";
            }
            if (Checkbox2.Checked == true)
            {
                LoaiCongViec.TenCongViec = "Part-time";
            }
            if (Checkbox3.Checked == true)
            {
                LoaiCongViec.MoTa = "Nhân viên chính thức";
            }
            if (Checkbox4.Checked == true)
            {
                LoaiCongViec.MoTa = "Thời vụ";
            }
            if (Checkbox5.Checked == true)
            {
                LoaiCongViec.MoTa = "Tự do";
            }
            LoaiCongViec.TrongSo = 1;
            LoaiCongViecBUS busLoaiCV = new LoaiCongViecBUS();

            thongtinvieclam.LoaiCongViec = busLoaiCV.GetIDLoaiCV(LoaiCongViec);

            ThongTinViecLamBUS busThongTin = new ThongTinViecLamBUS();
            busThongTin.Insert(thongtinvieclam);

            LoaiUngVienDTO LoaiUngVien = new LoaiUngVienDTO();
            LoaiUngVien.NganhNghe = NganhNghe.Value.ToString();
            LoaiUngVien.CapBac = CapBac.Value.ToString();
            LoaiUngVien.BangCap = BangCap.Value.ToString();

            LoaiUngVienBUS busLoaiUV = new LoaiUngVienBUS();
            busLoaiUV.insert(LoaiUngVien);

            NhaTuyenDungBUS busNhaTD = new NhaTuyenDungBUS();
            TinTuyenDungDTO TinTuyenDung = new TinTuyenDungDTO();
            String strEmail = Email.Value.ToString();
            TinTuyenDung.NhanTuyenDung = busNhaTD.GetIDNhaTuyenDung(strEmail);
            TinTuyenDung.LoaiUngVien = busLoaiUV.GetIDLoaiUV(LoaiUngVien);
            TinTuyenDung.MaSoCongViec = thongtinvieclam.MaSoCongViec;
            TinTuyenDung.ViTriTuyenDung = motacongviec.ViTriTuyenDung;
            TinTuyenDung.MoTaCongViec = motacongviec.MoTaCongViec;
            TinTuyenDung.KyNangCongViec = motacongviec.KyNangCongViec;

            TinTuyenDungBUS BusTTT = new TinTuyenDungBUS();
            BusTTT.Insert(TinTuyenDung);
        }