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