/// <summary>
/// Event Control Delete row
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void simpleButton3_Click(object sender, EventArgs e)
{
try
{
string id = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, gridView1.Columns[0]).ToString();
string empName = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, gridView1.Columns[1]).ToString();
Employee_basic obj = new Employee_basic();
DialogResult warning = (MessageBox.Show("Bạn thật sự muốn xóa nhân viên : " + empName, "Cảnh báo!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning));
if (warning == DialogResult.Yes)
{
obj.EMPLOYEE_ID = id;
bool temp = OracleHelper.ExcuteNonQuery(PKG_LOAD_DATA.NAME, PKG_LOAD_DATA.DELETE_EMPLOYEE, obj);
if (temp)
{
rgvEmployee_Load();
XtraMessageBox.Show("Xoá nhân viên thành công!", "Success");
}
else
{
XtraMessageBox.Show("Xoá nhân viên không thành công!", "Error");
}
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "Error!");
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
try
{
int selectedindex = dgvEmployee.Rows.IndexOf((
GridViewDataRowInfo
)dgvEmployee.CurrentRow);
string id = dgvEmployee.Rows[selectedindex].Cells[0].Value.ToString();
string empName = dgvEmployee.Rows[selectedindex].Cells[1].Value.ToString();
Employee_basic obj = new Employee_basic();
DialogResult warning = (MessageBox.Show("Bạn thật sự muốn xóa nhân viên : " + empName, "Cảnh báo!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning));
if (warning == DialogResult.Yes)
{
obj.EMPLOYEE_ID = id;
bool temp = OracleHelper.ExcuteNonQuery(PKG_LOAD_DATA.NAME, PKG_LOAD_DATA.DELETE_EMPLOYEE, obj);
if (temp)
{
rgvEmployee_Load();
RadMessageBox.Show("Xoá nhân viên thành công!", "Success");
}
else
{
RadMessageBox.Show("Xoá nhân viên không thành công!", "Error");
}
}
}
catch (Exception ex)
{
RadMessageBox.Show(ex.Message, "Error!");
}
}
public void rgvEmployee_Load()
{
Employee_basic objSearch = new Employee_basic();
objSearch.ORG_ID = OrgId;
List <Employee_basic> lstOrg =
OracleHelper.ExcuteSelectMultiObject <Employee_basic>(PKG_LOAD_DATA.NAME,
PKG_LOAD_DATA.GET_EMPLOYEE_BY_ORG, objSearch);
dgvEmployee.DataSource = lstOrg;
}
public JsonResult LoadData()
{
Employee_basic objSearch = new Employee_basic();
objSearch.ORG_ID = 1;
List <Employee_basic> model =
OracleHelper.ExcuteSelectMultiObject <Employee_basic>(PKG_LOAD_DATA.NAME,
PKG_LOAD_DATA.GET_EMPLOYEE_BY_ORG, objSearch);
IQueryable <Employee_basic> query = model.AsQueryable();
return(Json(new
{
data = query,
status = true
}, JsonRequestBehavior.AllowGet));
}
public void BinhdingData()
{
if (IsInsert == false)
{
DataTable dt = new DataTable();
Employee_basic objSearch = new Employee_basic();
objSearch.EMPLOYEE_ID = ID;
List <Employee_basic> lstOrg =
OracleHelper.ExcuteSelectMultiObject <Employee_basic>(PKG_LOAD_DATA.NAME,
PKG_LOAD_DATA.GET_EMPLOYEE_BY_ID, objSearch);
dt = ConvertHelper.ListToDataTable(lstOrg);
txtMaNV.Text = ID;
try
{
txtHoTen.Text = dt.Rows[0]["FULL_NAME"].ToString();
}
catch (Exception)
{
txtHoTen.Text = "";
}
try
{
txtCMTND.Text = dt.Rows[0]["ID_NO"].ToString();
}
catch (Exception)
{
txtCMTND.Text = "";
}
try
{
txtDiaChi.Text = dt.Rows[0]["PER_ADDRESS"].ToString();
}
catch (Exception)
{
txtDiaChi.Text = "";
}
try
{
txtEmail.Text = dt.Rows[0]["EMAIL"].ToString();
}
catch (Exception)
{
txtEmail.Text = "";
}
try
{
txtNoiCap.Text = dt.Rows[0]["ID_PLACE"].ToString();
}
catch (Exception)
{
txtNoiCap.Text = "";
}
try
{
dtpNgaySinh.Text = dt.Rows[0]["BIRTH_DATE"].ToString();
}
catch (Exception)
{
dtpNgaySinh.Text = "";
}
//if (dt.Rows[0]["EMPTYPE"].ToString() == "PartTime")
//{
// cmbLoaiNV.Properties.NullText = "PartTime";
//}
//else
//{
// cmbLoaiNV.Properties.NullText = "FullTime";
//}
//if (dt.Rows[0]["MARRIED"].ToString() == "ad")
//{
//}
//else
//{
// cmbHonNhan.Text = null;
//}
try
{
cmbViTri.EditValue = dt.Rows[0]["TITLE_NAME"].ToString();
}
catch (Exception)
{
cmbViTri.EditValue = "";
}
}
}
