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()) { PhaseBE objE_Phase = new PhaseBE(); objE_Phase.IdPhase = int.Parse(gvPhase.GetFocusedRowCellValue("IdPhase").ToString()); objE_Phase.Login = Parametros.strUsuarioLogin; objE_Phase.Machine = WindowsIdentity.GetCurrent().Name.ToString(); objE_Phase.IdCompany = Parametros.intEmpresaId; PhaseBL objBL_Phase = new PhaseBL(); objBL_Phase.Elimina(objE_Phase); 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); } }
private void btnGrabar_Click(object sender, EventArgs e) { try { Cursor = Cursors.WaitCursor; if (!ValidarIngreso()) { PhaseBL objBL_Phase = new PhaseBL(); PhaseBE objPhase = new PhaseBE(); objPhase.IdPhase = IdPhase; objPhase.NamePhase = txtDescripcion.Text; objPhase.FlagState = true; objPhase.Login = Parametros.strUsuarioLogin; objPhase.Machine = WindowsIdentity.GetCurrent().Name.ToString(); objPhase.IdCompany = Parametros.intEmpresaId; if (pOperacion == Operacion.Nuevo) { objBL_Phase.Inserta(objPhase); } else { objBL_Phase.Actualiza(objPhase); } this.Close(); } } catch (Exception ex) { Cursor = Cursors.Default; XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void Elimina(PhaseBE pItem) { try { PhaseDL Phase = new PhaseDL(); Phase.Elimina(pItem); } catch (Exception ex) { throw ex; } }
public void Actualiza(PhaseBE pItem) { try { PhaseDL Phase = new PhaseDL(); Phase.Actualiza(pItem); } catch (Exception ex) { throw ex; } }
public void Inserta(PhaseBE pItem) { try { PhaseDL Phase = new PhaseDL(); Phase.Inserta(pItem); } catch (Exception ex) { throw ex; } }
public PhaseBE SeleccionaDescripcion(int IdCompany, string NamePhase) { try { PhaseDL Phase = new PhaseDL(); PhaseBE objEmp = Phase.SeleccionaDescripcion(IdCompany, NamePhase); return(objEmp); } catch (Exception ex) { throw ex; } }
public PhaseBE Selecciona(int IdPhase) { try { PhaseDL Phase = new PhaseDL(); PhaseBE objEmp = Phase.Selecciona(IdPhase); return(objEmp); } catch (Exception ex) { throw ex; } }
public void Elimina(PhaseBE pItem) { Database db = DatabaseFactory.CreateDatabase("cnERPBD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_Phase_Elimina"); db.AddInParameter(dbCommand, "pIdPhase", DbType.Int32, pItem.IdPhase); 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); }
private void frmManPhaseEdit_Load(object sender, EventArgs e) { if (pOperacion == Operacion.Nuevo) { this.Text = "Phase - New"; } else if (pOperacion == Operacion.Modificar) { this.Text = "Phase - Update"; PhaseBE objE_Phase = null; objE_Phase = new PhaseBL().Selecciona(IdPhase); if (objE_Phase != null) { txtDescripcion.Text = objE_Phase.NamePhase.Trim(); } } txtDescripcion.Select(); }
public PhaseBE Selecciona(int IdPhase) { Database db = DatabaseFactory.CreateDatabase("cnERPBD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_Phase_Selecciona"); db.AddInParameter(dbCommand, "pidPhase", DbType.Int32, IdPhase); IDataReader reader = db.ExecuteReader(dbCommand); PhaseBE Phase = null; while (reader.Read()) { Phase = new PhaseBE(); Phase.IdPhase = Int32.Parse(reader["idPhase"].ToString()); Phase.IdCompany = Int32.Parse(reader["IdCompany"].ToString()); Phase.NamePhase = reader["NamePhase"].ToString(); Phase.FlagState = Boolean.Parse(reader["FlagState"].ToString()); } reader.Close(); reader.Dispose(); return(Phase); }
public void InicializarModificar() { if (gvPhase.RowCount > 0) { PhaseBE objPhase = new PhaseBE(); objPhase.IdPhase = int.Parse(gvPhase.GetFocusedRowCellValue("IdPhase").ToString()); frmManPhaseEdit objManPhaseEdit = new frmManPhaseEdit(); objManPhaseEdit.pOperacion = frmManPhaseEdit.Operacion.Modificar; objManPhaseEdit.IdPhase = objPhase.IdPhase; objManPhaseEdit.pPhaseBE = objPhase; objManPhaseEdit.StartPosition = FormStartPosition.CenterParent; objManPhaseEdit.ShowDialog(); Cargar(); } else { MessageBox.Show("No se pudo editar"); } }
public List <PhaseBE> ListaTodosActivo(int IdCompany) { Database db = DatabaseFactory.CreateDatabase("cnERPBD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_Phase_ListaTodosActivo"); db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, IdCompany); IDataReader reader = db.ExecuteReader(dbCommand); List <PhaseBE> Phaselist = new List <PhaseBE>(); PhaseBE Phase; while (reader.Read()) { Phase = new PhaseBE(); Phase.IdPhase = Int32.Parse(reader["idPhase"].ToString()); Phase.IdCompany = Int32.Parse(reader["IdCompany"].ToString()); Phase.NamePhase = reader["NamePhase"].ToString(); Phase.FlagState = Boolean.Parse(reader["FlagState"].ToString()); Phaselist.Add(Phase); } reader.Close(); reader.Dispose(); return(Phaselist); }