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