private void LoadHDTV(string loaiHD)
{
if (loaiHD == "all")
{
gridItem.DataSource = dttv;
if (dttv.Rows.Count > 0)
{
DataView dv = new DataView();
dv = dttv.DefaultView;
dv.RowFilter = "";
}
}
else if (loaiHD == "now")
{
gridItem.DataSource = dttv;
if (dttv.Rows.Count > 0)
{
DataView dv = new DataView();
dv = dttv.DefaultView;
dv.RowFilter = "IsCurrent='" + true + "' and Status<3";
}
}
else if (loaiHD == "end")
{
Class.NhanVien_HopDong_ThoiVu tv = new Class.NhanVien_HopDong_ThoiVu();
DataTable dttv2 = tv.HRM_CONTRACT_SEASON_GetListExpiration();
gridItem.DataSource = dttv2;
}
}
private void btnDel_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
int SelectedRow = gridItemDetail.FocusedRowHandle;
if (SelectedRow >= 0)
{
DataRow drow = gridItemDetail.GetDataRow(SelectedRow);
string _value = drow["ContractCode"].ToString();
string _manv = drow["EmployeeCode"].ToString();
if (Class.App.ConfirmDeletion() == DialogResult.No)
{
return;
}
Class.NhanVien_HopDong_ThoiVu hd = new Class.NhanVien_HopDong_ThoiVu();
hd.ContractCode = _value;
hd.EmployeeCode = _manv;
if (hd.Delete())
{
Class.App.DeleteSuccessfully();
HRM_CONTRACT_SEASON_GetList();
}
else
{
Class.App.DeleteNotSuccessfully();
}
}
}
private void call_info(string Form_name, string code)
{
Class.NhanVien_HopDong_ThoiVu hd = new Class.NhanVien_HopDong_ThoiVu();
hd.ContractCode = code;
DataTable dt = hd.HRM_CONTRACT_SEASON_Get();
txtSigner.Text = dt.Rows[0]["Signer"].ToString();
txtSignerNationality.Text = dt.Rows[0]["SignerNationality"].ToString();
txtSignerPosition.Text = dt.Rows[0]["SignerPosition"].ToString();
txtCompany.Text = dt.Rows[0]["Company"].ToString();
txtAddress.Text = dt.Rows[0]["Address"].ToString();
txtTel.Text = dt.Rows[0]["Tel"].ToString();
checkIsCurrent.Checked = (bool)dt.Rows[0]["IsCurrent"];
txtEmployeeCode.EditValue = dt.Rows[0]["EmployeeCode"].ToString();
Class.NhanVien_ThoiVu nv = new Class.NhanVien_ThoiVu();
nv.EmployeeCode = dt.Rows[0]["EmployeeCode"].ToString();
DataTable dtinfo = nv.HRM_EMPLOYEE_SEASON_Get();
txtFullName.Text = dtinfo.Rows[0]["FirstName"].ToString() + " " + dtinfo.Rows[0]["LastName"].ToString();
dateBirthday.DateTime = (DateTime)dtinfo.Rows[0]["Birthday"];
txtPosition.Text = dtinfo.Rows[0]["Position"].ToString();
txtNationality.Text = dtinfo.Rows[0]["Nationality"].ToString();
txtIDCard.Text = dtinfo.Rows[0]["IDCard"].ToString();
dateIDCardDate.DateTime = (DateTime)dtinfo.Rows[0]["IDCardDate"];
txtIDCardPlace.Text = dtinfo.Rows[0]["IDCardPlace"].ToString();
txtBranchName.Text = dtinfo.Rows[0]["BranchName"].ToString();
//tab thong tin hop dong
txtContractCode.Text = dt.Rows[0]["ContractCode"].ToString();
txtContractTime.Text = dt.Rows[0]["ContractTime"].ToString();
txtContractYear.Text = dt.Rows[0]["ContractYear"].ToString();
dateSignDate.DateTime = (DateTime)dt.Rows[0]["SignDate"];
dateFromDate.DateTime = (DateTime)dt.Rows[0]["FromDate"];
if (dt.Rows[0]["ToDate"] != DBNull.Value)
{
dateToDate.DateTime = (DateTime)dt.Rows[0]["ToDate"];
}
txtBasicSalary.Value = (decimal)dt.Rows[0]["BasicSalary"];
txtPayForm.Text = dt.Rows[0]["PayForm"].ToString();
txtPayDate.Value = (int)dt.Rows[0]["PayDate"];
txtAllowance.Text = dt.Rows[0]["Allowance"].ToString();
txtInsurance.Text = dt.Rows[0]["Insurance"].ToString();
txtWorkTime.Text = dt.Rows[0]["WorkTime"].ToString();
txtDescription.Text = dt.Rows[0]["Description"].ToString();
}
private void btnPrint_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
int SelectedRow = gridItemDetail.FocusedRowHandle;
if (SelectedRow >= 0)
{
Waiting.ShowWaitForm();
Waiting.SetWaitFormDescription("Đang tải trang in hợp đồng thời vụ");
DataRow drow = gridItemDetail.GetDataRow(SelectedRow);
string _value = drow["ContractCode"].ToString();
Class.NhanVien_HopDong_ThoiVu hd = new Class.NhanVien_HopDong_ThoiVu();
hd.ContractCode = _value;
DataTable dt = hd.HRM_CONTRACT_SEASON_GetPrintByCode();
// Reports.reportHopDongThoiVu rp = new Reports.reportHopDongThoiVu();
// rp.DataSource = dt;
// rp.ShowDesigner();
// rp.ShowPreview();
Waiting.CloseWaitForm();
}
}
public void HRM_CONTRACT_SEASON_GetList()
{
Class.NhanVien_HopDong_ThoiVu hdtv = new Class.NhanVien_HopDong_ThoiVu();
dttv = hdtv.HRM_CONTRACT_SEASON_GetList();
gridItem.DataSource = dttv;
}
private void Update_HopDongLaoDong()
{
Waiting.ShowWaitForm();
Waiting.SetWaitFormDescription("Đang khởi tạo yêu cầu..");
Class.NhanVien_HopDong_ThoiVu hd = new Class.NhanVien_HopDong_ThoiVu();
hd.ContractCode = txtContractCode.Text;
hd.EmployeeCode = txtEmployeeCode.EditValue.ToString();
hd.ContractTime = txtContractTime.Text;
hd.ContractYear = int.Parse(txtContractYear.Text);
hd.SignDate = dateSignDate.DateTime;
hd.FromDate = dateFromDate.DateTime;
hd.ToDate = dateToDate.DateTime;
hd.BasicSalary = txtBasicSalary.Value;
hd.PayForm = txtPayForm.Text;
hd.PayDate = txtPayDate.Text;
hd.Allowance = txtAllowance.Text;
hd.Insurance = txtInsurance.Text;
hd.WorkTime = txtWorkTime.Text;
hd.Signer = txtSigner.Text;
hd.SignerPosition = txtSignerPosition.Text;
hd.SignerNationality = txtSignerNationality.Text;
hd.Company = txtCompany.Text;
hd.Address = txtAddress.Text;
hd.Tel = txtTel.Text;
hd.Description = txtDescription.Text;
hd.IsCurrent = checkIsCurrent.Checked;
if (txtContractCode.Enabled == true)
{
Waiting.SetWaitFormDescription("Đang thực hiện thêm..");
if (hd.Insert())
{
Waiting.SetWaitFormDescription("Đang tải dữ liệu..");
(this.Owner as frmDanhSachHopDong_Season).HRM_CONTRACT_SEASON_GetList();
Waiting.CloseWaitForm();
Class.App.SaveSuccessfully();
}
else
{
Waiting.CloseWaitForm();
Class.App.SaveNotSuccessfully();
}
}
else
{
Waiting.SetWaitFormDescription("Đang thực hiện cập nhật..");
if (hd.Update())
{
Waiting.SetWaitFormDescription("Đang tải dữ liệu..");
(this.Owner as frmDanhSachHopDong_Season).HRM_CONTRACT_SEASON_GetList();
Waiting.CloseWaitForm();
Class.App.SaveSuccessfully();
}
else
{
Waiting.CloseWaitForm();
Class.App.SaveNotSuccessfully();
}
}
}
private void xulyTaoCodeHopdong()
{
if (_Add_New == true)
{
if (txtFullName.Text != "[Họ và tên nhân viên]")
{
Class.NhanVien_HopDong_ThoiVu hd = new Class.NhanVien_HopDong_ThoiVu();
hd.ContractYear = int.Parse(txtContractYear.Text);
DataTable dt = hd.HRM_CONTRACT_SEASON_GetByYear();
hd.EmployeeCode = txtEmployeeCode.EditValue.ToString();
DataTable dthdbynv = hd.HRM_CONTRACT_SEASON_GetByEmployee();
if (dt.Rows.Count > 0)
{
string _idCheck;
string[] cat;
int next_ID = 0;
int next_ID2 = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
_idCheck = dt.Rows[i]["ContractCode"].ToString();
cat = _idCheck.Split('-');
next_ID2 = int.Parse(cat.GetValue(0).ToString());
if ((next_ID2 - next_ID) > 1)
{
break;
}
next_ID = int.Parse(cat.GetValue(0).ToString());
}
next_ID++;
if (next_ID.ToString().Length == 1)
{
txtContractCode.Text = "00" + next_ID.ToString() + "-" + txtContractYear.Text;
}
if (next_ID.ToString().Length == 2)
{
txtContractCode.Text = "0" + next_ID.ToString() + "-" + txtContractYear.Text;
}
if (next_ID.ToString().Length == 3)
{
txtContractCode.Text = next_ID.ToString() + "-" + txtContractYear.Text;
}
}
else
{
txtContractCode.Text = "001-" + txtContractYear.Text;
}
// kiem tra ky hop dong truc tiep ko co thu viec
int solanHD = 1;
solanHD = dthdbynv.Rows.Count + 1;
txtContractCode.Text = txtContractCode.Text + "/HDTVu-Lan" + solanHD;
if (dthdbynv.Rows.Count > 0)
{
if (dthdbynv.Rows[dthdbynv.Rows.Count - 1]["ToDate"] != DBNull.Value)
{
DateTime _dateNgaykt = (DateTime)dthdbynv.Rows[dthdbynv.Rows.Count - 1]["ToDate"];
DateTime _dateNgayKyTiep = _dateNgaykt.AddDays(1);
dateFromDate.DateTime = _dateNgayKyTiep;
dateSignDate.DateTime = _dateNgayKyTiep;
dateFromDate_Validated(null, null);
}
}
else
{
// la HDTV se lay ngay tu ngay bat dau lam viec
dateFromDate.DateTime = DateBegin;
dateSignDate.DateTime = DateBegin;
dateFromDate_Validated(null, null);
}
}
else
{
MessageBox.Show("Vui Lòng chọn nhân viên ký hợp đồng trước");
TabControl.SelectedTabPage = TabPage1;
}
}
//txtContractTime_SelectedIndexChanged(null, null);
// tam thoi han che khong cho lam lap 4 hop dong lao dong
//if (txtContractCode.Text.Contains("Lan4"))
//{
// MessageBox.Show("Hợp đồng Lao động chỉ chấp nhận nhỏ hơn 4 lần, Vui lòng kiểm tra lại hoặc liên hệ Người Quản Trị", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
//}
}
