public static DOResume getUngVien(long ID)
{
string sql = "select * from RESUME where ID = @ID";
DatabaseFB db = HelpDB.getDatabase();
DbCommand cmd = db.GetSQLStringCommand(sql);
db.AddInParameter(cmd, "@ID", DbType.Int64, ID);
DataSet ds = new DataSet();
db.LoadDataSet(cmd, ds, "AA");
if (ds.Tables[0].Rows.Count == 0)
return null;
DateTime? NgaySinh = null;
if (ds.Tables[0].Rows[0]["NGAY_SINH"].ToString().Length > 0)
NgaySinh = (DateTime)ds.Tables[0].Rows[0]["NGAY_SINH"];
DOResume DR = new DOResume();
DR.ID=long.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
DR.MA_HO_SO = ds.Tables[0].Rows[0]["MA_HO_SO"].ToString();
DR.TEN= HelpString.TrimAllBlankAndCapitalWord(ds.Tables[0].Rows[0]["HO_TEN"].ToString());
DR.NGAY_SINH= NgaySinh;
DR.DIA_CHI=ds.Tables[0].Rows[0]["DIA_CHI"].ToString();
DR.DIEN_THOAI=ds.Tables[0].Rows[0]["DIEN_THOAI"].ToString();
DR.EMAIL=ds.Tables[0].Rows[0]["EMAIL"].ToString();
DR.GIOI_TINH=ds.Tables[0].Rows[0]["GIOI_TINH"].ToString();
if (ds.Tables[0].Rows[0]["TRINH_DO_CHUYEN_MON"].ToString() != "")
DR.TRINH_DO_CHUYEN_MON = HelpByte.BytesToUTF8String((Byte[])ds.Tables[0].Rows[0]["TRINH_DO_CHUYEN_MON"]);
if (ds.Tables[0].Rows[0]["QUA_TRINH_CONG_TAC"].ToString() != "")
DR.QUA_TRINH_CONG_TAC = HelpByte.BytesToUTF8String((Byte[])ds.Tables[0].Rows[0]["QUA_TRINH_CONG_TAC"]);
if (ds.Tables[0].Rows[0]["QUA_TRINH_DAO_TAO"].ToString() != "")
DR.QUA_TRINH_DAO_TAO = HelpByte.BytesToUTF8String((Byte[])ds.Tables[0].Rows[0]["QUA_TRINH_DAO_TAO"]);
DR.TINH_TRANG_HON_NHAN=ds.Tables[0].Rows[0]["TINH_TRANG_HON_NHAN"].ToString();
DR.LUONG_MONG_DOI=ds.Tables[0].Rows[0]["LUONG_MONG_DOI"].ToString();
if (ds.Tables[0].Rows[0]["TRINH_DO_NGOAI_NGU"].ToString() != "")
DR.TRINH_DO_NGOAI_NGU = HelpByte.BytesToUTF8String((Byte[])ds.Tables[0].Rows[0]["TRINH_DO_NGOAI_NGU"]);
if (ds.Tables[0].Rows[0]["THONG_TIN_KHAC"].ToString() != "")
DR.THONG_TIN_KHAC = HelpByte.BytesToUTF8String((Byte[])ds.Tables[0].Rows[0]["THONG_TIN_KHAC"]);
DR.NGAY_CAP_NHAT_HO_SO=(DateTime)ds.Tables[0].Rows[0]["NGAY_CAP_NHAT_HO_SO"];
DR.LOAI_HO_SO=(ds.Tables[0].Rows[0]["LOAI_HO_SO"].ToString().Length > 0) ? ds.Tables[0].Rows[0]["LOAI_HO_SO"].ToString() : "-1";
DR.TINH_TRANG_HO_SO=(ds.Tables[0].Rows[0]["TTHS_ID"].ToString().Trim().Length > 0) ? long.Parse(ds.Tables[0].Rows[0]["TTHS_ID"].ToString()) : -1;
return DR;
}
private void btn_DongY_Click(object sender, EventArgs e)
{
DataTable dsGuiPhongVan = gridControlMaster.DataSource as DataTable;
dsGuiPhongVan.AcceptChanges();
List<DOResume> dsGuiKhongDuoc = new List<DOResume>();
if (dsGuiPhongVan.Rows.Count > 0)
{
try
{
FrameworkParams.wait = new WaitingMsg();
foreach (DataRow item in dsGuiPhongVan.Rows)
{
if (item.RowState != DataRowState.Deleted)
{
DataSet ds = new DataSet();
ds.Tables.Add(ThongTinGuiPhongVan(item));
List<String> mailaddress = new List<string>();
mailaddress.Add(item["EMAIL"].ToString());
if (!Message.SentMessageTemplateHTMLOutside(mailaddress, ds, "Thư mời phỏng vấn", "Report\\ThuPhongVan.doc", null))
{
DOResume resume = new DOResume
{
TEN = item["TEN"].ToString(),
EMAIL = item["EMAIL"].ToString()
};
dsGuiKhongDuoc.Add(resume);
}
}
}
}
catch (Exception ex)
{
PLMessageBox.ShowErrorMessage(ex.Message);
}
finally
{
if (FrameworkParams.wait != null) FrameworkParams.wait.Finish();
if (dsGuiKhongDuoc.Count == 0)
{
PLMessageBox.ShowNotificationMessage("Thực hiện gửi mail thành công"); this.Close();
}
else
PLMessageBox.ShowNotificationMessage("Có " + dsGuiKhongDuoc.Count.ToString() + " email gửi không thành công.");
}
}
}
public static void ThongTinResume(WebBrowser Output, string filename, DOResume TTUngVien)
{
try
{
StreamReader strr = new StreamReader(filename);
string str = strr.ReadToEnd();
str =
str.Replace("%NgayThucHien%",
TTUngVien.NGAY_CAP_NHAT_HO_SO.Day + "/" + TTUngVien.NGAY_CAP_NHAT_HO_SO.Month + "/" +
TTUngVien.NGAY_CAP_NHAT_HO_SO.Year);
str = str.Replace("%HoTen%", HelpString.TrimAllBlankAndCapitalWord(TTUngVien.TEN));
str = str.Replace("%GioiTinh%", (TTUngVien.GIOI_TINH == "Y") ? "Nam" : "Nữ");
str =
str.Replace("%NgaySinh%", (TTUngVien.NGAY_SINH != null) ?
TTUngVien.NGAY_SINH.Value.Day + "/" + TTUngVien.NGAY_SINH.Value.Month + "/" + TTUngVien.NGAY_SINH.Value.Year : "");
str = str.Replace("%DiaChi%", TTUngVien.DIA_CHI);
string TinhTrangHonNhan = "Không rõ";
if (TTUngVien.TINH_TRANG_HON_NHAN == "0") TinhTrangHonNhan = "Độc thân";
else if (TTUngVien.TINH_TRANG_HON_NHAN == "1") TinhTrangHonNhan = "Kết hôn";
str = str.Replace("%TinhTrangHonNhan%", TinhTrangHonNhan);
str = str.Replace("%DienThoai%", TTUngVien.DIEN_THOAI);
str = str.Replace("%Email%", TTUngVien.EMAIL);
str = str.Replace("%LuongMongDoi%", TTUngVien.LUONG_MONG_DOI.ToString());
str = str.Replace("%QuaTrinhDaoTao%", TTUngVien.QUA_TRINH_DAO_TAO);
str = str.Replace("%QuaTrinhCongTac%", TTUngVien.QUA_TRINH_CONG_TAC);
str = str.Replace("%TrinhDoChuyenMon%", TTUngVien.TRINH_DO_CHUYEN_MON);
str = str.Replace("%TrinhDoNgoaiNgu%", TTUngVien.TRINH_DO_NGOAI_NGU);
str = str.Replace("%ThongTinKhac%", TTUngVien.THONG_TIN_KHAC);
str = str.Replace("%ViTriUngTuyen%", DAViTriUngTuyen.DanhSachVTUT(TTUngVien.ID));
Output.DocumentText = str;
strr.Close();
}
catch (Exception ex)
{
HelpMsgBox.ShowErrorMessage(ex.Message);
}
}
public static bool Update(DOResume dto)
{
string sql = "update RESUME set " +
"MA_HO_SO=@MA_HO_SO,HO_TEN = @HO_TEN," +
"NGAY_SINH = @NGAY_SINH," +
"DIA_CHI = @DIA_CHI," +
"DIEN_THOAI = @DIEN_THOAI," +
"EMAIL = @EMAIL," +
"GIOI_TINH = @GIOI_TINH," +
"TRINH_DO_CHUYEN_MON = @TRINH_DO_CHUYEN_MON," +
"QUA_TRINH_CONG_TAC = @QUA_TRINH_CONG_TAC," +
"QUA_TRINH_DAO_TAO = @QUA_TRINH_DAO_TAO," +
"TINH_TRANG_HON_NHAN = @TINH_TRANG_HON_NHAN," +
"LUONG_MONG_DOI = @LUONG_MONG_DOI," +
"TRINH_DO_NGOAI_NGU = @TRINH_DO_NGOAI_NGU," +
"THONG_TIN_KHAC = @THONG_TIN_KHAC," +
"NGAY_CAP_NHAT_HO_SO = @NGAY_CAP_NHAT_HO_SO, " +
"LOAI_HO_SO = @LOAI_HO_SO, " +
"TTHS_ID = @TINH_TRANG_HO_SO " +
"where ID = @ID ";
DatabaseFB db = HelpDB.getDatabase();
DbCommand cmd = db.GetSQLStringCommand(sql);
db.AddInParameter(cmd, "@ID", DbType.Int64, dto.ID);
db.AddInParameter(cmd, "@MA_HO_SO", DbType.String, dto.MA_HO_SO);
db.AddInParameter(cmd, "@HO_TEN", DbType.String, HelpString.TrimAllBlankAndCapitalWord(dto.TEN));
if (dto.NGAY_SINH != null)
db.AddInParameter(cmd, "@NGAY_SINH", DbType.DateTime, dto.NGAY_SINH);
else
db.AddInParameter(cmd, "@NGAY_SINH", DbType.DateTime, DBNull.Value);
db.AddInParameter(cmd, "@DIA_CHI", DbType.String, dto.DIA_CHI);
db.AddInParameter(cmd, "@DIEN_THOAI", DbType.String, dto.DIEN_THOAI);
db.AddInParameter(cmd, "@EMAIL", DbType.String, dto.EMAIL);
db.AddInParameter(cmd, "@GIOI_TINH", DbType.String, dto.GIOI_TINH);
db.AddInParameter(cmd, "@TRINH_DO_CHUYEN_MON", DbType.Binary, HelpByte.UTF8StringToBytes(dto.TRINH_DO_CHUYEN_MON));
db.AddInParameter(cmd, "@QUA_TRINH_CONG_TAC", DbType.Binary, HelpByte.UTF8StringToBytes(dto.QUA_TRINH_CONG_TAC));
db.AddInParameter(cmd, "@QUA_TRINH_DAO_TAO", DbType.Binary, HelpByte.UTF8StringToBytes(dto.QUA_TRINH_DAO_TAO));
db.AddInParameter(cmd, "@TINH_TRANG_HON_NHAN", DbType.String, dto.TINH_TRANG_HON_NHAN);
db.AddInParameter(cmd, "@LUONG_MONG_DOI", DbType.String, dto.LUONG_MONG_DOI);
db.AddInParameter(cmd, "@TRINH_DO_NGOAI_NGU", DbType.Binary, HelpByte.UTF8StringToBytes(dto.TRINH_DO_NGOAI_NGU));
db.AddInParameter(cmd, "@THONG_TIN_KHAC", DbType.Binary, HelpByte.UTF8StringToBytes(dto.THONG_TIN_KHAC));
db.AddInParameter(cmd, "@NGAY_CAP_NHAT_HO_SO", DbType.DateTime, dto.NGAY_CAP_NHAT_HO_SO);
db.AddInParameter(cmd, "@LOAI_HO_SO", DbType.String, dto.LOAI_HO_SO);
if (dto.TINH_TRANG_HO_SO != -1)
db.AddInParameter(cmd, "@TINH_TRANG_HO_SO", DbType.Int64, dto.TINH_TRANG_HO_SO);
else
db.AddInParameter(cmd, "@TINH_TRANG_HO_SO", DbType.Int64, DBNull.Value);
if (db.ExecuteNonQuery(cmd) > 0)
return true;
return false;
}
public static bool Insert(DOResume dto)
{
string sql = "";
if (dto.NGAY_SINH != null)
sql = "Insert into RESUME" +
"(ID,MA_HO_SO,HO_TEN,DIA_CHI,DIEN_THOAI,EMAIL,GIOI_TINH,TRINH_DO_CHUYEN_MON,QUA_TRINH_CONG_TAC,QUA_TRINH_DAO_TAO,TINH_TRANG_HON_NHAN,LUONG_MONG_DOI,TRINH_DO_NGOAI_NGU,THONG_TIN_KHAC,NGAY_CAP_NHAT_HO_SO,LOAI_HO_SO,NGAY_SINH,TTHS_ID) " +
"values" +
"(@ID,@MA_HO_SO,@TEN,@DIA_CHI,@DIEN_THOAI,@EMAIL,@GIOI_TINH,@TRINH_DO_CHUYEN_MON,@QUA_TRINH_CONG_TAC,@QUA_TRINH_DAO_TAO,@TINH_TRANG_HON_NHAN,@LUONG_MONG_DOI,@TRINH_DO_NGOAI_NGU,@THONG_TIN_KHAC,@NGAY_CAP_NHAT_HO_SO,@LOAI_HO_SO,@NGAY_SINH,@TINH_TRANG_HO_SO)";
else
sql = "Insert into RESUME" +
"(ID,MA_HO_SO,HO_TEN,DIA_CHI,DIEN_THOAI,EMAIL,GIOI_TINH,TRINH_DO_CHUYEN_MON,QUA_TRINH_CONG_TAC,QUA_TRINH_DAO_TAO,TINH_TRANG_HON_NHAN,LUONG_MONG_DOI,TRINH_DO_NGOAI_NGU,THONG_TIN_KHAC,NGAY_CAP_NHAT_HO_SO,LOAI_HO_SO,TTHS_ID) " +
"values" +
"(@ID,@MA_HO_SO,@TEN,@DIA_CHI,@DIEN_THOAI,@EMAIL,@GIOI_TINH,@TRINH_DO_CHUYEN_MON,@QUA_TRINH_CONG_TAC,@QUA_TRINH_DAO_TAO,@TINH_TRANG_HON_NHAN,@LUONG_MONG_DOI,@TRINH_DO_NGOAI_NGU,@THONG_TIN_KHAC,@NGAY_CAP_NHAT_HO_SO,@LOAI_HO_SO,@TINH_TRANG_HO_SO)";
DatabaseFB db = HelpDB.getDatabase();
DbCommand cmd = db.GetSQLStringCommand(sql);
db.AddInParameter(cmd, "@ID", DbType.Int64, dto.ID);
db.AddInParameter(cmd, "@MA_HO_SO", DbType.String, dto.MA_HO_SO);
db.AddInParameter(cmd, "@TEN", DbType.String, HelpString.TrimAllBlankAndCapitalWord(dto.TEN));
db.AddInParameter(cmd, "@DIA_CHI", DbType.String, dto.DIA_CHI);
db.AddInParameter(cmd, "@DIEN_THOAI", DbType.String, dto.DIEN_THOAI);
db.AddInParameter(cmd, "@EMAIL", DbType.String, dto.EMAIL);
db.AddInParameter(cmd, "@GIOI_TINH", DbType.String, dto.GIOI_TINH);
db.AddInParameter(cmd, "@TRINH_DO_CHUYEN_MON", DbType.Binary, HelpByte.UTF8StringToBytes(dto.TRINH_DO_CHUYEN_MON));
db.AddInParameter(cmd, "@QUA_TRINH_CONG_TAC", DbType.Binary, HelpByte.UTF8StringToBytes(dto.QUA_TRINH_CONG_TAC));
db.AddInParameter(cmd, "@QUA_TRINH_DAO_TAO", DbType.Binary, HelpByte.UTF8StringToBytes(dto.QUA_TRINH_DAO_TAO));
db.AddInParameter(cmd, "@TINH_TRANG_HON_NHAN", DbType.String, dto.TINH_TRANG_HON_NHAN);
db.AddInParameter(cmd, "@LUONG_MONG_DOI", DbType.String, dto.LUONG_MONG_DOI);
db.AddInParameter(cmd, "@TRINH_DO_NGOAI_NGU", DbType.Binary, HelpByte.UTF8StringToBytes(dto.TRINH_DO_NGOAI_NGU));
db.AddInParameter(cmd, "@THONG_TIN_KHAC", DbType.Binary, HelpByte.UTF8StringToBytes(dto.THONG_TIN_KHAC));
db.AddInParameter(cmd, "@NGAY_CAP_NHAT_HO_SO", DbType.DateTime, dto.NGAY_CAP_NHAT_HO_SO);
db.AddInParameter(cmd, "@LOAI_HO_SO", DbType.String, dto.LOAI_HO_SO);
if (dto.TINH_TRANG_HO_SO != -1)
db.AddInParameter(cmd, "@TINH_TRANG_HO_SO", DbType.Int64, dto.TINH_TRANG_HO_SO);
else
db.AddInParameter(cmd, "@TINH_TRANG_HO_SO", DbType.Int64, DBNull.Value);
if (dto.NGAY_SINH != null)
db.AddInParameter(cmd, "@NGAY_SINH", DbType.DateTime, dto.NGAY_SINH);
if (db.ExecuteNonQuery(cmd) > 0)
return true;
return false;
}
public static List<DOResume> GuiThuChonPhongVan(List<object> ids)
{
List<DOResume> Kq = new List<DOResume>();
DataSet ds = new DataSet();
string sql = "select * from RESUME where ID in (";
for (int i = 0; i < ids.Count; i++)
{
sql += ids[i].ToString();
if (i < ids.Count - 1)
sql += ",";
}
sql += ")";
DatabaseFB db = HelpDB.getDatabase();
DbCommand cmd = db.GetSQLStringCommand(sql);
db.LoadDataSet(cmd, ds, "AA");
if (ds.Tables[0].Rows.Count > 0)
{
for (int row = 0; row < ds.Tables[0].Rows.Count; row++)
{
DateTime? NgaySinh = null;
if(ds.Tables[0].Rows[row]["NGAY_SINH"].ToString().Length >0)
NgaySinh = (DateTime?)ds.Tables[0].Rows[row]["NGAY_SINH"] ;
DOResume Resume = new DOResume(HelpNumber.ParseInt64(ds.Tables[0].Rows[row]["ID"]),
ds.Tables[0].Rows[row]["MA_HO_SO"].ToString(),
ds.Tables[0].Rows[row]["HO_TEN"].ToString(),
NgaySinh ,
ds.Tables[0].Rows[row]["DIA_CHI"].ToString(),
ds.Tables[0].Rows[row]["DIEN_THOAI"].ToString(),
ds.Tables[0].Rows[row]["EMAIL"].ToString(),
ds.Tables[0].Rows[row]["GIOI_TINH"].ToString(),
HelpByte.BytesToUTF8String((byte[])ds.Tables[0].Rows[row]["TRINH_DO_CHUYEN_MON"]),
HelpByte.BytesToUTF8String((byte[])ds.Tables[0].Rows[row]["QUA_TRINH_CONG_TAC"]),
HelpByte.BytesToUTF8String((byte[])ds.Tables[0].Rows[row]["QUA_TRINH_DAO_TAO"]),
ds.Tables[0].Rows[row]["TINH_TRANG_HON_NHAN"].ToString(),
ds.Tables[0].Rows[row]["LUONG_MONG_DOI"].ToString(),
HelpByte.BytesToUTF8String((byte[])ds.Tables[0].Rows[row]["TRINH_DO_NGOAI_NGU"]),
HelpByte.BytesToUTF8String((byte[])ds.Tables[0].Rows[row]["THONG_TIN_KHAC"]),
(DateTime)ds.Tables[0].Rows[row]["NGAY_CAP_NHAT_HO_SO"],
ds.Tables[0].Rows[row]["LOAI_HO_SO"].ToString(),
long.Parse(ds.Tables[0].Rows[row]["TTHS_ID"].ToString())
);
Kq.Add(Resume);
}
}
return Kq;
}
private void btn_DongY_Click(object sender, EventArgs e)
{
DataTable dsGuiPhongVan = gridControlMaster.DataSource as DataTable;
for (int i = 0; i < dsGuiPhongVan.Rows.Count; i++)
{
if (dsGuiPhongVan.Rows[i].RowState == DataRowState.Deleted) continue;
dsGuiPhongVan.Rows[i].ClearErrors();
}
for (int i = 0; i < dsGuiPhongVan.Rows.Count;i++ )
{
if (dsGuiPhongVan.Rows[i].RowState == DataRowState.Deleted) continue;
if (string.Compare(dsGuiPhongVan.Rows[i]["GIO_PHONG_VAN"].ToString(), string.Empty) == 0)
dsGuiPhongVan.Rows[i].SetColumnError("GIO_PHONG_VAN", "Vui lòng chọn \"Ngày/giờ phỏng vấn\"!");
}
if (dsGuiPhongVan.HasErrors) return;
dsGuiPhongVan.AcceptChanges();
List<DOResume> dsGuiKhongDuoc = new List<DOResume>();
if (dsGuiPhongVan.Rows.Count > 0)
{
try
{
System.Windows.Forms.Application.DoEvents();
FrameworkParams.wait = new WaitingMsg();
foreach (DataRow item in dsGuiPhongVan.Rows)
{
if (item.RowState != DataRowState.Deleted)
{
DataSet ds = new DataSet();
ds.Tables.Add(ThongTinGuiPhongVan(item));
List<String> mailaddress = new List<string>();
mailaddress.Add(item["EMAIL"].ToString());
if (!HelpEmail.SentMessageTemplateHTMLOutside(mailaddress, ds, "Thư mời phỏng vấn", FrameworkParams.TEMPLETE_FOLDER + "\\ThuPhongVan.doc", null))
{
DOResume resume = new DOResume
{
TEN = item["TEN"].ToString(),
EMAIL = item["EMAIL"].ToString()
};
dsGuiKhongDuoc.Add(resume);
}
}
}
}
catch (Exception ex)
{
PLException.AddException(ex);
}
finally
{
if (FrameworkParams.wait != null) FrameworkParams.wait.Finish();
if (dsGuiKhongDuoc.Count == 0)
{
HelpMsgBox.ShowNotificationMessage("Thực hiện gửi mail thành công"); this.Close();
}
else
HelpMsgBox.ShowNotificationMessage("Có " + dsGuiKhongDuoc.Count.ToString() + " email gửi không thành công.");
}
}
}
//Ho tro Email cho Trung
private DataTable CoverDataTable(DOResume item)
{
DataTable dt = new DataTable("PhongVan");
dt.Columns.Add("DIA_CHI");
dt.Columns.Add("DIEN_THOAI");
dt.Columns.Add("EMAIL");
dt.Columns.Add("ID");
dt.Columns.Add("LOAI_HO_SO");
dt.Columns.Add("GIOI_TINH");
dt.Columns.Add("LUONG_MONG_DOI");
dt.Columns.Add("NGAY_CAP_NHAT_HO_SO");
dt.Columns.Add("NGAY_SINH");
dt.Columns.Add("QUA_TRINH_CONG_TAC");
dt.Columns.Add("QUA_TRINH_DAO_TAO");
dt.Columns.Add("TEN");
dt.Columns.Add("THONG_TIN_KHAC");
dt.Columns.Add("TINH_TRANG_HON_NHAN");
dt.Columns.Add("TRINH_DO_CHUYEN_MON");
dt.Columns.Add("TRINH_DO_NGOAI_NGU");
DataRow dr = dt.NewRow();
dr["DIA_CHI"] = item.DIA_CHI;
dr["DIEN_THOAI"] = item.DIEN_THOAI;
dr["ID"] = item.ID;
dr["EMAIL"] = item.EMAIL;
dr["LOAI_HO_SO"] = item.LOAI_HO_SO;
dr["GIOI_TINH"] = (item.GIOI_TINH == "Y") ? "Anh" : "Chị";
dr["LUONG_MONG_DOI"] = item.LUONG_MONG_DOI;
dr["NGAY_CAP_NHAT_HO_SO"] = item.NGAY_CAP_NHAT_HO_SO;
dr["NGAY_SINH"] = item.NGAY_SINH;
dr["QUA_TRINH_CONG_TAC"] = item.QUA_TRINH_CONG_TAC;
dr["QUA_TRINH_DAO_TAO"] = item.QUA_TRINH_DAO_TAO;
dr["TEN"] = item.TEN;
dr["THONG_TIN_KHAC"] = item.THONG_TIN_KHAC;
dr["TINH_TRANG_HON_NHAN"] = item.TINH_TRANG_HON_NHAN;
dr["TRINH_DO_CHUYEN_MON"] = item.TRINH_DO_CHUYEN_MON;
dr["TRINH_DO_NGOAI_NGU"] = item.TRINH_DO_NGOAI_NGU;
dt.Rows.Add(dr);
return dt;
}
private void btnSave_Click(object sender, EventArgs e)
{
if (this.IsAdd != null || CapNhatTTHS == true)
{
if (this.IsValidate())
{
if (UncheckAllVTUT())
{
HelpMsgBox.ShowNotificationMessage("Vui lòng chọn \"Vị trí tuyển dụng\"!");
return;
}
DateTime? NSinh = null;
if (NgaySinh.Text.Equals("") == true)
NSinh = null;
else
NSinh = (DateTime?)NgaySinh.EditValue;
long IDUngVien = (this.IsAdd == true) ? (int)HelpDB.getDatabase().GetID("GEN_RESUME_ID") : this.Id;
DOResume UngVien = new DOResume(IDUngVien, MaPhieu.Text,
HoTen.Text,
NSinh,
DiaChi.Text,
DienThoai.Text,
Email.Text,
(GTNam.Checked == true) ? "Y" : "N",
TrinhDoChuyenMon._getHTMLText(),
QuaTrinhCongTac._getHTMLText(),
QuaTrinhDaoTao._getHTMLText(),
TinhTrangHonNhan._getSelectedID().ToString(),
(LuongMongDoi.Value > 0) ? (LuongMongDoi.Value.ToString("#,###") + " " + LoaiTien.Text) : "",
TrinhDoNgoaiNgu._getHTMLText(),
ThongTinKhac._getHTMLText(),
DateTime.Now,
PLLoaiHoSo._getSelectedID().ToString(),
PLTinhTrangHoSo._getSelectedID()
);
if (this.IsAdd == true)
{
if (DAResume.Insert(UngVien))
{
ArrayList arrVTTuyen = getDanhSachUngTuyen(true);
for (int i = 0; i < arrVTTuyen.Count; i++)
{
DOUngTuyen UngTuyen = new DOUngTuyen(UngVien.ID, (long)arrVTTuyen[i]);
DAUngTuyen.Insert(UngTuyen);
}
}
}
else
{
if (CapNhatTTHS)
{
DAResume.Update(UngVien.ID, UngVien.TINH_TRANG_HO_SO, UngVien.NGAY_CAP_NHAT_HO_SO);
}
else
{
if (DAResume.Update(UngVien))
{
ArrayList arrVTTuyen = getDanhSachUngTuyen(false);
for (int i = 0; i < arrVTTuyen.Count; i++)
{
DOUngTuyen UngTuyen = new DOUngTuyen(UngVien.ID, (long)arrVTTuyen[i]);
if (DAUngTuyen.ExistsRow(UngTuyen))
{
if (DanhSachViTriUngTuyen.GetItemCheckState(i) == CheckState.Unchecked)
DAUngTuyen.Delete(UngTuyen);
}
else
{
if (DanhSachViTriUngTuyen.GetItemCheckState(i) == CheckState.Checked)
DAUngTuyen.Insert(UngTuyen);
}
}
}
}
}
HelpXtraForm.CloseFormNoConfirm(this);
}
}
}
