private void FrmGetMaterias_Load(object sender, EventArgs e) { try { DataTable dt = CtrlAreas.GetAreaAll().Tables[0]; LueArea.Properties.DataSource = dt; LueArea.Properties.DisplayMember = "Nombre"; LueArea.Properties.ValueMember = "Codigo"; DevExpress.XtraEditors.Controls.LookUpColumnInfo col; col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Nombre", "Nombre", 100); //col.SortOrder = DevExpress.Data.ColumnSortOrder.Ascending; LueArea.Properties.Columns.Add(col); LueArea.ItemIndex = -1; } catch (Exception ex) { XtraMessageBox.Show(ex.Message, Resources.AppName, MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button2); return; } TxtNombre.Focus(); if (Modo == "E" && Id > 0) { CargarDatos(Id); } }
private void InsertarActualizar(string modo) { try { if (modo == "INSERT") { Area area = new Area(); area.Nombre = TxtNombre.Text.Trim(); if (CtrlAreas.Insertar(area) > 0) { XtraMessageBox.Show("Area insertada con exito.", Resources.AppName, MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button2); } } else { Area area = new Area(); area.Id = Id; area.Nombre = TxtNombre.Text.Trim(); if (CtrlAreas.Actualizar(area) > 0) { XtraMessageBox.Show("Area actualizada con exito.", Resources.AppName, MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button2); } } } catch (Exception ex) { XtraMessageBox.Show(ex.Message, Resources.AppName, MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button2); } }
public void Eliminar() { if (DgvGeneral.RowCount > 0 && DgvGeneral.GetFocusedRow() != null) { int idGeneral = Convert.ToInt32(DgvGeneral.GetFocusedRowCellValue("Id")); Area area = new Area(); area.Id = idGeneral; if (XtraMessageBox.Show("¿Esta seguro que desea eliminar el area?", "Eliminar", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { CtrlAreas.Eliminar(area); if (!BkgwBuscar.IsBusy) { PrgBuscar.Visible = true; BkgwBuscar.RunWorkerAsync(); } } } else { XtraMessageBox.Show("Debe seleccionar un registro.", Resources.AppName, MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void CargarDatos(int id) { Area us = new Area(); us.Id = id; DataSet ds = CtrlAreas.GetAreaOne(us); DataRow dr = ds.Tables[0].Rows[0]; TxtNombre.Text = dr["Nombre"].ToString(); }
public void LlenarDsConsulta() { try { DataSet ds = CtrlAreas.GetAreaAll(); dtConsulta = ds.Tables[0].Copy(); dsConsulta.Tables.Clear(); if (dsConsulta.Tables.Count == 0) { dsConsulta.Tables.Add(dtConsulta); } } catch (Exception ex) { XtraMessageBox.Show(ex.Message); } }