private void btnDel_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
int selectrow = GridItemdetail.FocusedRowHandle;
if (selectrow > 0)
{
DataRow drow = GridItemdetail.GetDataRow(selectrow);
string _value = drow["PositionCode"].ToString();
if (Class.App.ConfirmDeletion() == DialogResult.No)
{
return;
}
Class.Danhmuc_Chucvu dmcv = new Class.Danhmuc_Chucvu();
dmcv.PositionCode = _value;
if (dmcv.Delete())
{
Class.App.DeleteSuccessfully();
GetAllList_Position();
}
else
{
Class.App.DeleteNotSuccessfully();
}
}
}
private void Call_info_toCBO()
{
Class.DanhMuc_ChiNhanh cn = new Class.DanhMuc_ChiNhanh();
DataTable dtcn = cn.Danhsachchinhanh();
cboOldBranch.Properties.DataSource = dtcn;
cboOldBranch.Properties.ValueMember = "BranchCode";
cboOldBranch.Properties.DisplayMember = "BranchName";
cboNewBranch.Properties.DataSource = dtcn;
cboNewBranch.Properties.ValueMember = "BranchCode";
cboNewBranch.Properties.DisplayMember = "BranchName";
Class.DanhMuc_PhongBan pb = new Class.DanhMuc_PhongBan();
DataTable dtpb = pb.GetAllList_DEPARTMENT();
cboOldDepartment.Properties.DataSource = dtpb;
cboOldDepartment.Properties.ValueMember = "DepartmentCode";
cboOldDepartment.Properties.DisplayMember = "DepartmentName";
// cboNewDepartment.Properties.DataSource = dtpb;
// cboNewDepartment.Properties.ValueMember = "DepartmentCode";
// cboNewDepartment.Properties.DisplayMember = "DepartmentName";
Class.Danhmuc_Chucvu cv = new Class.Danhmuc_Chucvu();
DataTable dtcv = cv.GetAlllist_Position();;
txtNewPosition.Properties.Items.Clear();
txtOldPosition.Properties.Items.Clear();
for (int i = 0; i < dtcv.Rows.Count; i++)
{
txtNewPosition.Properties.Items.Add(dtcv.Rows[i]["PositionName"].ToString());
txtOldPosition.Properties.Items.Add(dtcv.Rows[i]["PositionName"].ToString());
}
}
private void Update_ChucVu()
{
Class.Danhmuc_Chucvu dm = new Class.Danhmuc_Chucvu();
dm.PositionCode = txtCode.Text;
dm.PositionName = txtName.Text;
dm.IsManager = checkActive.Checked;
dm.Description = txtDescription.Text;
dm.Active = checkActive.Checked;
if (txtCode.Enabled == true)
{
if (dm.Insert())
{
Class.App.SaveSuccessfully();
}
else
{
Class.App.SaveNotSuccessfully();
}
}
else
{
if (dm.Update())
{
Class.App.SaveSuccessfully();
}
else
{
Class.App.SaveNotSuccessfully();
}
}
if (_reCallFunction == "frmDanhMuc_ChucVu")
{
(this.Owner as frmDanhMuc_ChucVu).GetAllList_Position();
}
}
private void call_info(string Form_name, string code)
{
Class.Danhmuc_Chucvu dmcv = new Class.Danhmuc_Chucvu();
DataTable dt = dmcv.GetPositionByCode(code);
txtCode.Text = dt.Rows[0]["PositionCode"].ToString();
txtName.Text = dt.Rows[0]["PositionName"].ToString();
checkIsManager.Checked = (bool)dt.Rows[0]["IsManager"];
txtDescription.Text = dt.Rows[0]["Description"].ToString();
checkActive.Checked = (bool)dt.Rows[0]["Active"];
}
public void GetList_Position()
{
Class.Danhmuc_Chucvu dm = new Class.Danhmuc_Chucvu();
DataTable dt = dm.GetAlllist_Position();
txtPosition.Properties.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
txtPosition.Properties.Items.Add(dt.Rows[i]["PositionName"].ToString());
}
}
private void btnUpdateNew_Click(object sender, EventArgs e)
{
if (txtName.Text.Length < 1)
{
Class.App.InputNotAccess();
return;
}
Class.Danhmuc_Chucvu dmcv = new Class.Danhmuc_Chucvu();
dmcv.PositionCode = txtCode.Text;
dmcv.PositionName = txtName.Text;
dmcv.IsManager = checkIsManager.Checked;
dmcv.Description = txtDescription.Text;
dmcv.Active = checkActive.Checked;
if (txtCode.Enabled == true)
{
if (dmcv.Insert())
{
Class.App.SaveSuccessfully();
}
else
{
Class.App.SaveNotSuccessfully();
}
}
else
{
if (dmcv.Update())
{
Class.App.SaveSuccessfully();
}
else
{
Class.App.SaveNotSuccessfully();
}
}
// xac dinh du lieu co thay doi de reload form danh muc.
(this.Owner as frmDanhMuc_ChucVu).GetAllList_Position();
txtCode.Enabled = true;
txtName.Text = "";
txtDescription.Text = "";
this.Text = "Thêm chức vụ";
txtCode.Text = call_Code_New();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (txtName.Text.Length < 1)
{
Class.App.InputNotAccess();
return;
}
Class.Danhmuc_Chucvu dmcv = new Class.Danhmuc_Chucvu();
dmcv.PositionCode = txtCode.Text;
dmcv.PositionName = txtName.Text;
dmcv.IsManager = checkIsManager.Checked;
dmcv.Description = txtDescription.Text;
dmcv.Active = checkActive.Checked;
if (txtCode.Enabled == true)
{
if (dmcv.Insert())
{
Class.App.SaveSuccessfully();
}
else
{
Class.App.SaveNotSuccessfully();
}
if (dmcv.Update())
{
Class.App.SaveSuccessfully();
}
else
{
Class.App.SaveNotSuccessfully();
}
(this.Owner as frmDanhMuc_ChucVu).GetAllList_Position();
this.Close();
}
}
private string call_Code_New()
{
Class.Danhmuc_Chucvu dmcv = new Class.Danhmuc_Chucvu();
return(dmcv.GetNewCode());
}
public void GetAllList_Position()
{
Class.Danhmuc_Chucvu dm = new Class.Danhmuc_Chucvu();
Griditem.DataSource = dm.GetAlllist_Position();
}
private string Call_Code_New(string Form_Name)
{
string code = "";
switch (Form_Name)
{
case "TT":
Class.CT_Provice dmtt = new Class.CT_Provice();
code = dmtt.GetNewCode();
break;
case "HV":
Class.Danhmuc_Hocvan dmhv = new Class.Danhmuc_Hocvan();
code = dmhv.GetNewCode();
break;
case "BC":
Class.Danhmuc_Hocvan dmbc = new Class.Danhmuc_Hocvan();
code = dmbc.GetNewCode();
break;
case "CV":
Class.Danhmuc_Chucvu dmcv = new Class.Danhmuc_Chucvu();
code = dmcv.GetNewCode();
break;
case "CM":
Class.DanhMuc_ChuyenMon dmcm = new Class.DanhMuc_ChuyenMon();
code = dmcm.GetNewCode();
break;
case "QG":
Class.DanhMuc_QuocGia dmqg = new Class.DanhMuc_QuocGia();
code = dmqg.GetNewCode();
break;
case "DT":
Class.DanhMuc_DanToc dmdt = new Class.DanhMuc_DanToc();
code = dmdt.GetNewCode();
break;
case "TG":
Class.DanhMuc_TonGiao dmtg = new Class.DanhMuc_TonGiao();
code = dmtg.GetNewCode();
break;
case "QHGD":
Class.DanhMuc_GiaDinh dmgd = new Class.DanhMuc_GiaDinh();
code = dmgd.GetNewCode();
break;
case "TH":
Class.DanhMuc_TinHoc dmth = new Class.DanhMuc_TinHoc();
code = dmth.GetNewCode();
break;
case "NN":
Class.DanhMuc_NgoaiNgu dmnn = new Class.DanhMuc_NgoaiNgu();
code = dmnn.GetNewCode();
break;
case "KN":
Class.DanhMuc_KyNang dmkn = new Class.DanhMuc_KyNang();
code = dmkn.GetNewCode();
break;
}
return(code);
}
private void call_info(string Form_Name, string code)
{
switch (Form_Name)
{
case "TH":
Class.DanhMuc_TinHoc dmth = new Class.DanhMuc_TinHoc();
DataTable dtth = dmth.GetInformaticByCode(code);
txtCode.Text = dtth.Rows[0]["InformaticCode"].ToString();
txtName.Text = dtth.Rows[0]["InformaticName"].ToString();
txtDescription.Text = dtth.Rows[0]["Description"].ToString();
checkActive.Checked = (bool)dtth.Rows[0]["Active"];
break;
case "NN":
Class.DanhMuc_NgoaiNgu dmnn = new Class.DanhMuc_NgoaiNgu();
DataTable dtnn = dmnn.GetLanguageByCode(code);
txtCode.Text = dtnn.Rows[0]["LanguageCode"].ToString();
txtName.Text = dtnn.Rows[0]["LanguageName"].ToString();
txtDescription.Text = dtnn.Rows[0]["Description"].ToString();
checkActive.Checked = (bool)dtnn.Rows[0]["Active"];
break;
case "KN":
Class.DanhMuc_KyNang dmkn = new Class.DanhMuc_KyNang();
DataTable dtkn = dmkn.GetSkillByCode(code);
txtCode.Text = dtkn.Rows[0]["SkillCode"].ToString();
txtName.Text = dtkn.Rows[0]["SkillName"].ToString();
txtDescription.Text = dtkn.Rows[0]["Description"].ToString();
checkActive.Checked = (bool)dtkn.Rows[0]["Active"];
break;
case "TT":
Class.CT_Provice dmtt = new Class.CT_Provice();
DataTable dttt = dmtt.GetProvinceByCode(code);
txtCode.Text = dttt.Rows[0]["ProvinceCode"].ToString();
txtName.Text = dttt.Rows[0]["ProvinceName"].ToString();
txtDescription.Text = dttt.Rows[0]["Description"].ToString();
checkActive.Checked = (bool)dttt.Rows[0]["Active"];
break;
case "HV":
Class.Danhmuc_Hocvan dmhv = new Class.Danhmuc_Hocvan();
DataTable dthv = dmhv.GetEducationByCode(code);
txtCode.Text = dthv.Rows[0]["EducationCode"].ToString();
txtName.Text = dthv.Rows[0]["EducationName"].ToString();
txtDescription.Text = dthv.Rows[0]["Description"].ToString();
checkActive.Checked = (bool)dthv.Rows[0]["Active"];
break;
case "BC":
Class.DanhMuc_BangCap dmbc = new Class.DanhMuc_BangCap();
DataTable dtbc = dmbc.GetDegreeByCode(code);
txtCode.Text = dtbc.Rows[0]["DegreeCode"].ToString();
txtName.Text = dtbc.Rows[0]["DegreeName"].ToString();
txtDescription.Text = dtbc.Rows[0]["Description"].ToString();
checkActive.Checked = (bool)dtbc.Rows[0]["Active"];
break;
case "CV":
Class.Danhmuc_Chucvu dmcv = new Class.Danhmuc_Chucvu();
DataTable dtcv = dmcv.GetPositionByCode(code);
txtCode.Text = dtcv.Rows[0]["PositionCode"].ToString();
txtName.Text = dtcv.Rows[0]["PositionName"].ToString();
txtDescription.Text = dtcv.Rows[0]["Description"].ToString();
checkActive.Checked = (bool)dtcv.Rows[0]["Active"];
break;
case "CM":
Class.DanhMuc_ChuyenMon dmcm = new Class.DanhMuc_ChuyenMon();
DataTable dtcm = dmcm.GetProfessionalByCode(code);
txtCode.Text = dtcm.Rows[0]["ProfessionalCode"].ToString();
txtName.Text = dtcm.Rows[0]["ProfessionalName"].ToString();
txtDescription.Text = dtcm.Rows[0]["Description"].ToString();
checkActive.Checked = (bool)dtcm.Rows[0]["Active"];
break;
case "QG":
Class.DanhMuc_QuocGia dmqg = new Class.DanhMuc_QuocGia();
DataTable dtqg = dmqg.GetNationalityByCode(code);
txtCode.Text = dtqg.Rows[0]["NationalityCode"].ToString();
txtName.Text = dtqg.Rows[0]["NationalityName"].ToString();
txtDescription.Text = dtqg.Rows[0]["Description"].ToString();
checkActive.Checked = (bool)dtqg.Rows[0]["Active"];
break;
case "DT":
Class.DanhMuc_DanToc dmdt = new Class.DanhMuc_DanToc();
DataTable dtdt = dmdt.GetEthnicByCode(code);
txtCode.Text = dtdt.Rows[0]["EthnicCode"].ToString();
txtName.Text = dtdt.Rows[0]["EthnicName"].ToString();
txtDescription.Text = dtdt.Rows[0]["Description"].ToString();
checkActive.Checked = (bool)dtdt.Rows[0]["Active"];
break;
case "TG":
Class.DanhMuc_TonGiao dmtg = new Class.DanhMuc_TonGiao();
DataTable dttg = dmtg.GetReligionByCode(code);
txtCode.Text = dttg.Rows[0]["ReligionCode"].ToString();
txtDescription.Text = dttg.Rows[0]["ReligionName"].ToString();
txtName.Text = dttg.Rows[0]["Description"].ToString();
checkActive.Checked = (bool)dttg.Rows[0]["Active"];
break;
case "QHGD":
Class.DanhMuc_GiaDinh dmgd = new Class.DanhMuc_GiaDinh();
DataTable dtgd = dmgd.GetRelativeByCode(code);
txtCode.Text = dtgd.Rows[0]["RelativeCode"].ToString();
txtDescription.Text = dtgd.Rows[0]["RelativeName"].ToString();
txtName.Text = dtgd.Rows[0]["Description"].ToString();
checkActive.Checked = (bool)dtgd.Rows[0]["Active"];
break;
}
}
