private void btnGrabar_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
if (!ValidarIngreso())
{
TabletBL objBL_Tabla = new TabletBL();
TabletBE objTabla = new TabletBE();
objTabla.IdTablet = IdTablet;
objTabla.NameTablet = txtDescripcion.Text;
objTabla.FlagState = true;
objTabla.Login = Parametros.strUsuarioLogin;
objTabla.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objTabla.IdCompany = Parametros.intEmpresaId;
if (pOperacion == Operacion.Nuevo)
{
objBL_Tabla.Inserta(objTabla);
}
else
{
objBL_Tabla.Actualiza(objTabla);
}
this.Close();
}
}
catch (Exception ex)
{
Cursor = Cursors.Default;
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void Elimina(TabletBE pItem)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
TabletDL Tablet = new TabletDL();
ElementTabletDL ElementTablet = new ElementTabletDL();
List <ElementTabletBE> pListaElementTablet = null;
pListaElementTablet = new ElementTabletBL().ListaTodosActivo(pItem.IdCompany, pItem.IdTablet);
//Eliminar los elementos de la Tablet
foreach (var item in pListaElementTablet)
{
ElementTablet.Elimina(item);
}
Tablet.Elimina(pItem);
ts.Complete();
}
}
catch (Exception ex)
{ throw ex; }
}
private void tlbMenu_DeleteClick()
{
try
{
Cursor = Cursors.WaitCursor;
if (XtraMessageBox.Show("Be sure to delete the record?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (!ValidarIngreso())
{
TabletBE objE_Tabla = new TabletBE();
objE_Tabla.IdTablet = int.Parse(gvTabla.GetFocusedRowCellValue("IdTablet").ToString());
objE_Tabla.Login = Parametros.strUsuarioLogin;
objE_Tabla.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objE_Tabla.IdCompany = Parametros.intEmpresaId;
TabletBL objBL_Tabla = new TabletBL();
objBL_Tabla.Elimina(objE_Tabla);
XtraMessageBox.Show("The record was successfully deleted.", 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 Actualiza(TabletBE pItem)
{
try
{
TabletDL Tablet = new TabletDL();
Tablet.Actualiza(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Inserta(TabletBE pItem)
{
try
{
TabletDL Tablet = new TabletDL();
Tablet.Inserta(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(TabletBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Tablet_Elimina");
db.AddInParameter(dbCommand, "pIdTablet", DbType.Int32, pItem.IdTablet);
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, pItem.IdCompany);
db.AddInParameter(dbCommand, "pLogin", DbType.String, pItem.Login);
db.AddInParameter(dbCommand, "pMachine", DbType.String, pItem.Machine);
db.ExecuteNonQuery(dbCommand);
}
public void InicializarModificar()
{
if (gvTabla.RowCount > 0)
{
TabletBE objTabla = new TabletBE();
objTabla.IdTablet = int.Parse(gvTabla.GetFocusedRowCellValue("IdTablet").ToString());
objTabla.NameTablet = gvTabla.GetFocusedRowCellValue("NameTablet").ToString();
objTabla.FlagState = Convert.ToBoolean(gvTabla.GetFocusedRowCellValue("FlagState").ToString());
frmManTablaEdit objManTablaEdit = new frmManTablaEdit();
objManTablaEdit.pOperacion = frmManTablaEdit.Operacion.Modificar;
objManTablaEdit.IdTablet = objTabla.IdTablet;
objManTablaEdit.pTabletBE = objTabla;
objManTablaEdit.StartPosition = FormStartPosition.CenterParent;
objManTablaEdit.ShowDialog();
Cargar();
}
else
{
MessageBox.Show("Edit");
}
}
public List <TabletBE> ListaTodosActivo(int IdCompany)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Tablet_ListaTodosActivo");
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, IdCompany);
IDataReader reader = db.ExecuteReader(dbCommand);
List <TabletBE> Tabletlist = new List <TabletBE>();
TabletBE Tablet;
while (reader.Read())
{
Tablet = new TabletBE();
Tablet.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
Tablet.IdTablet = Int32.Parse(reader["idTablet"].ToString());
Tablet.NameTablet = reader["NameTablet"].ToString();
Tablet.FlagState = Boolean.Parse(reader["FlagState"].ToString());
Tabletlist.Add(Tablet);
}
reader.Close();
reader.Dispose();
return(Tabletlist);
}
