private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
int SelectedRow = gridView1.FocusedRowHandle;
if (SelectedRow > 0)
{
DataRow dr = gridView1.GetDataRow(SelectedRow);
string _value = dr["ProvinceCode"].ToString();
if (Class.App.ConfirmDeletion() == DialogResult.No)
{
return;
}
Class.CT_Provice dm = new Class.CT_Provice();
dm.ProvinceCode = _value;
if (dm.Delete())
{
Class.App.DeleteSuccessfully();
GetAllList_Province();
}
else
{
Class.App.DeleteNotSuccessfully();
}
}
}
private void Update_Tinh()
{
Class.CT_Provice dm = new Class.CT_Provice();
dm.ProvinceCode = txtCode.Text;
dm.ProvinceName = txtName.Text;
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 == "frmProvince")
{
(this.Owner as frmProvince).GetAllList_Province();
}
}
public void GetAllList_Province()
{
Class.CT_Provice dm = new Class.CT_Provice();
gridControl1.DataSource = dm.Get_All_CT_Province();
}
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;
}
}