/// <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 = ""; } } }