private void btnGrabar_Click(object sender, EventArgs e) { try { Cursor = Cursors.WaitCursor; if (!ValidarIngreso()) { ParteLesionadaBL objBL_ParteLesionada = new ParteLesionadaBL(); ParteLesionadaBE objParteLesionada = new ParteLesionadaBE(); objParteLesionada.IdParteLesionada = IdParteLesionada; objParteLesionada.DescParteLesionada = txtDescripcion.Text; objParteLesionada.FlagEstado = true; objParteLesionada.Usuario = Parametros.strUsuarioLogin; objParteLesionada.Maquina = WindowsIdentity.GetCurrent().Name.ToString(); objParteLesionada.IdEmpresa = Parametros.intEmpresaId; if (pOperacion == Operacion.Nuevo) { objBL_ParteLesionada.Inserta(objParteLesionada); } else { objBL_ParteLesionada.Actualiza(objParteLesionada); } this.Close(); } } catch (Exception ex) { Cursor = Cursors.Default; XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void tlbMenu_DeleteClick() { try { Cursor = Cursors.WaitCursor; if (XtraMessageBox.Show("Esta seguro de eliminar el registro?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (!ValidarIngreso()) { ParteLesionadaBE objE_ParteLesionada = new ParteLesionadaBE(); objE_ParteLesionada.IdParteLesionada = int.Parse(gvParteLesionada.GetFocusedRowCellValue("IdParteLesionada").ToString()); objE_ParteLesionada.Usuario = Parametros.strUsuarioLogin; objE_ParteLesionada.Maquina = WindowsIdentity.GetCurrent().Name.ToString(); objE_ParteLesionada.IdEmpresa = Parametros.intEmpresaId; ParteLesionadaBL objBL_ParteLesionada = new ParteLesionadaBL(); objBL_ParteLesionada.Elimina(objE_ParteLesionada); XtraMessageBox.Show("El registro se eliminó correctamente", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); Cargar(); } } Cursor = Cursors.Default; } catch (Exception ex) { Cursor = Cursors.Default; XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void Elimina(ParteLesionadaBE pItem) { try { ParteLesionadaDL ParteLesionada = new ParteLesionadaDL(); ParteLesionada.Elimina(pItem); } catch (Exception ex) { throw ex; } }
public void Actualiza(ParteLesionadaBE pItem) { try { ParteLesionadaDL ParteLesionada = new ParteLesionadaDL(); ParteLesionada.Actualiza(pItem); } catch (Exception ex) { throw ex; } }
public ParteLesionadaBE Selecciona(int IdParteLesionada) { try { ParteLesionadaDL ParteLesionada = new ParteLesionadaDL(); ParteLesionadaBE objEmp = ParteLesionada.Selecciona(IdParteLesionada); return(objEmp); } catch (Exception ex) { throw ex; } }
public void Elimina(ParteLesionadaBE pItem) { Database db = DatabaseFactory.CreateDatabase("cnSSOMABD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_ParteLesionada_Elimina"); db.AddInParameter(dbCommand, "pIdParteLesionada", DbType.Int32, pItem.IdParteLesionada); db.AddInParameter(dbCommand, "pIdEmpresa", DbType.Int32, pItem.IdEmpresa); db.AddInParameter(dbCommand, "pUsuario", DbType.String, pItem.Usuario); db.AddInParameter(dbCommand, "pMaquina", DbType.String, pItem.Maquina); db.ExecuteNonQuery(dbCommand); }
public ParteLesionadaBE Selecciona(int idParteLesionada) { Database db = DatabaseFactory.CreateDatabase("cnSSOMABD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_ParteLesionada_Selecciona"); db.AddInParameter(dbCommand, "pidParteLesionada", DbType.Int32, idParteLesionada); IDataReader reader = db.ExecuteReader(dbCommand); ParteLesionadaBE ParteLesionada = null; while (reader.Read()) { ParteLesionada = new ParteLesionadaBE(); ParteLesionada.IdParteLesionada = Int32.Parse(reader["idParteLesionada"].ToString()); ParteLesionada.DescParteLesionada = reader["descParteLesionada"].ToString(); ParteLesionada.FlagEstado = Boolean.Parse(reader["flagestado"].ToString()); } reader.Close(); reader.Dispose(); return(ParteLesionada); }
public List <ParteLesionadaBE> ListaCombo(int IdEmpresa) { Database db = DatabaseFactory.CreateDatabase("cnSSOMABD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_ParteLesionada_ListaCombo"); db.AddInParameter(dbCommand, "pIdEmpresa", DbType.Int32, IdEmpresa); IDataReader reader = db.ExecuteReader(dbCommand); List <ParteLesionadaBE> ParteLesionadalist = new List <ParteLesionadaBE>(); ParteLesionadaBE ParteLesionada; while (reader.Read()) { ParteLesionada = new ParteLesionadaBE(); ParteLesionada.IdParteLesionada = Int32.Parse(reader["idParteLesionada"].ToString()); ParteLesionada.DescParteLesionada = reader["descParteLesionada"].ToString(); ParteLesionadalist.Add(ParteLesionada); } reader.Close(); reader.Dispose(); return(ParteLesionadalist); }
public void InicializarModificar() { if (gvParteLesionada.RowCount > 0) { ParteLesionadaBE objParteLesionada = new ParteLesionadaBE(); objParteLesionada.IdParteLesionada = int.Parse(gvParteLesionada.GetFocusedRowCellValue("IdParteLesionada").ToString()); objParteLesionada.DescParteLesionada = gvParteLesionada.GetFocusedRowCellValue("DescParteLesionada").ToString(); objParteLesionada.FlagEstado = Convert.ToBoolean(gvParteLesionada.GetFocusedRowCellValue("FlagEstado").ToString()); frmManParteLesionadaEdit objManParteLesionadaEdit = new frmManParteLesionadaEdit(); objManParteLesionadaEdit.pOperacion = frmManParteLesionadaEdit.Operacion.Modificar; objManParteLesionadaEdit.IdParteLesionada = objParteLesionada.IdParteLesionada; objManParteLesionadaEdit.pParteLesionadaBE = objParteLesionada; objManParteLesionadaEdit.StartPosition = FormStartPosition.CenterParent; objManParteLesionadaEdit.ShowDialog(); Cargar(); } else { MessageBox.Show("No se pudo editar"); } }