public int Insert(MoTaCongViecDTO newrecord)
{
int result;
try
{
SqlConnection connect = new SqlConnection(SqlDataAccess.ConnectionString);
connect.Open();
try
{
SqlCommand cmd = new SqlCommand("sp_InsertMoTaCongViec", connect);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter vitrituyendung_param = cmd.Parameters.Add("@ViTriTuyenDung", System.Data.SqlDbType.NVarChar);
SqlParameter mota_param = cmd.Parameters.Add("@MoTa", System.Data.SqlDbType.NVarChar);
SqlParameter kynang_param = cmd.Parameters.Add("@KyNang", System.Data.SqlDbType.NVarChar);
vitrituyendung_param.Direction = System.Data.ParameterDirection.Input;
kynang_param.Direction = System.Data.ParameterDirection.Input;
mota_param.Direction = System.Data.ParameterDirection.Input;
vitrituyendung_param.Value = newrecord.ViTriTuyenDung;
kynang_param.Value = newrecord.MoTaCongViec;
mota_param.Value = newrecord.KyNangCongViec;
result = cmd.ExecuteNonQuery();
}
catch (System.Exception ex)
{
throw ex;
}
finally
{
connect.Close();
}
}
catch (Exception e)
{
throw e;
}
return result;
}
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);
}
public int Insert(MoTaCongViecDTO newrecord)
{
MoTaCongViecDAO dao = new MoTaCongViecDAO();
return dao.Insert(newrecord);
}