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");
}
}
