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()) { CarpetaBE objE_Carpeta = new CarpetaBE(); objE_Carpeta.IdCarpeta = int.Parse(gvCarpeta.GetFocusedRowCellValue("IdCarpeta").ToString()); objE_Carpeta.Usuario = Parametros.strUsuarioLogin; objE_Carpeta.Maquina = WindowsIdentity.GetCurrent().Name.ToString(); objE_Carpeta.IdEmpresa = Parametros.intEmpresaId; CarpetaBL objBL_Carpeta = new CarpetaBL(); objBL_Carpeta.Elimina(objE_Carpeta); 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); } }
private void btnGrabar_Click(object sender, EventArgs e) { try { Cursor = Cursors.WaitCursor; if (!ValidarIngreso()) { CarpetaBL objBL_Carpeta = new CarpetaBL(); CarpetaBE objCarpeta = new CarpetaBE(); objCarpeta.IdCarpeta = IdCarpeta; objCarpeta.DescCarpeta = txtDescripcion.Text; objCarpeta.FlagEstado = true; objCarpeta.Usuario = Parametros.strUsuarioLogin; objCarpeta.Maquina = WindowsIdentity.GetCurrent().Name.ToString(); objCarpeta.IdEmpresa = Parametros.intEmpresaId; if (pOperacion == Operacion.Nuevo) { objBL_Carpeta.Inserta(objCarpeta); } else { objBL_Carpeta.Actualiza(objCarpeta); } this.Close(); } } catch (Exception ex) { Cursor = Cursors.Default; XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void Elimina(CarpetaBE pItem) { try { CarpetaDL Carpeta = new CarpetaDL(); Carpeta.Elimina(pItem); } catch (Exception ex) { throw ex; } }
public void Actualiza(CarpetaBE pItem) { try { CarpetaDL Carpeta = new CarpetaDL(); Carpeta.Actualiza(pItem); } catch (Exception ex) { throw ex; } }
public void Inserta(CarpetaBE pItem) { try { CarpetaDL Carpeta = new CarpetaDL(); Carpeta.Inserta(pItem); } catch (Exception ex) { throw ex; } }
public CarpetaBE Selecciona(int IdCarpeta) { try { CarpetaDL Carpeta = new CarpetaDL(); CarpetaBE objEmp = Carpeta.Selecciona(IdCarpeta); return(objEmp); } catch (Exception ex) { throw ex; } }
public void Elimina(CarpetaBE pItem) { Database db = DatabaseFactory.CreateDatabase("cnSSOMABD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_Carpeta_Elimina"); db.AddInParameter(dbCommand, "pIdCarpeta", DbType.Int32, pItem.IdCarpeta); 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 CarpetaBE Selecciona(int idCarpeta) { Database db = DatabaseFactory.CreateDatabase("cnSSOMABD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_Carpeta_Selecciona"); db.AddInParameter(dbCommand, "pidCarpeta", DbType.Int32, idCarpeta); IDataReader reader = db.ExecuteReader(dbCommand); CarpetaBE Carpeta = null; while (reader.Read()) { Carpeta = new CarpetaBE(); Carpeta.IdCarpeta = Int32.Parse(reader["idCarpeta"].ToString()); Carpeta.DescCarpeta = reader["descCarpeta"].ToString(); Carpeta.FlagEstado = Boolean.Parse(reader["flagestado"].ToString()); } reader.Close(); reader.Dispose(); return(Carpeta); }
public List <CarpetaBE> ListaCombo(int IdEmpresa) { Database db = DatabaseFactory.CreateDatabase("cnSSOMABD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_Carpeta_ListaCombo"); db.AddInParameter(dbCommand, "pIdEmpresa", DbType.Int32, IdEmpresa); IDataReader reader = db.ExecuteReader(dbCommand); List <CarpetaBE> Carpetalist = new List <CarpetaBE>(); CarpetaBE Carpeta; while (reader.Read()) { Carpeta = new CarpetaBE(); Carpeta.IdCarpeta = Int32.Parse(reader["idCarpeta"].ToString()); Carpeta.DescCarpeta = reader["descCarpeta"].ToString(); Carpetalist.Add(Carpeta); } reader.Close(); reader.Dispose(); return(Carpetalist); }
public void InicializarModificar() { if (gvCarpeta.RowCount > 0) { CarpetaBE objCarpeta = new CarpetaBE(); objCarpeta.IdCarpeta = int.Parse(gvCarpeta.GetFocusedRowCellValue("IdCarpeta").ToString()); objCarpeta.DescCarpeta = gvCarpeta.GetFocusedRowCellValue("DescCarpeta").ToString(); objCarpeta.FlagEstado = Convert.ToBoolean(gvCarpeta.GetFocusedRowCellValue("FlagEstado").ToString()); frmManCarpetaEdit objManCarpetaEdit = new frmManCarpetaEdit(); objManCarpetaEdit.pOperacion = frmManCarpetaEdit.Operacion.Modificar; objManCarpetaEdit.IdCarpeta = objCarpeta.IdCarpeta; objManCarpetaEdit.pCarpetaBE = objCarpeta; objManCarpetaEdit.StartPosition = FormStartPosition.CenterParent; objManCarpetaEdit.ShowDialog(); Cargar(); } else { MessageBox.Show("No se pudo editar"); } }