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()) { SeasonBE objE_Season = new SeasonBE(); objE_Season.IdSeason = int.Parse(gvSeason.GetFocusedRowCellValue("IdSeason").ToString()); objE_Season.Login = Parametros.strUsuarioLogin; objE_Season.Machine = WindowsIdentity.GetCurrent().Name.ToString(); objE_Season.IdCompany = Parametros.intEmpresaId; SeasonBL objBL_Season = new SeasonBL(); objBL_Season.Elimina(objE_Season); 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()) { SeasonBL objBL_Season = new SeasonBL(); SeasonBE objSeason = new SeasonBE(); objSeason.IdSeason = IdSeason; objSeason.NameSeason = txtDescripcion.Text; objSeason.FlagState = true; objSeason.Login = Parametros.strUsuarioLogin; objSeason.Machine = WindowsIdentity.GetCurrent().Name.ToString(); objSeason.IdCompany = Parametros.intEmpresaId; if (pOperacion == Operacion.Nuevo) { objBL_Season.Inserta(objSeason); } else { objBL_Season.Actualiza(objSeason); } this.Close(); } } catch (Exception ex) { Cursor = Cursors.Default; XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void Elimina(SeasonBE pItem) { try { SeasonDL Season = new SeasonDL(); Season.Elimina(pItem); } catch (Exception ex) { throw ex; } }
public void Inserta(SeasonBE pItem) { try { SeasonDL Season = new SeasonDL(); Season.Inserta(pItem); } catch (Exception ex) { throw ex; } }
public void Actualiza(SeasonBE pItem) { try { SeasonDL Season = new SeasonDL(); Season.Actualiza(pItem); } catch (Exception ex) { throw ex; } }
public SeasonBE SeleccionaDescripcion(int IdCompany, string NameSeason) { try { SeasonDL Season = new SeasonDL(); SeasonBE objEmp = Season.SeleccionaDescripcion(IdCompany, NameSeason); return(objEmp); } catch (Exception ex) { throw ex; } }
public SeasonBE Selecciona(int IdSeason) { try { SeasonDL Season = new SeasonDL(); SeasonBE objEmp = Season.Selecciona(IdSeason); return(objEmp); } catch (Exception ex) { throw ex; } }
public void Elimina(SeasonBE pItem) { Database db = DatabaseFactory.CreateDatabase("cnERPBD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_Season_Elimina"); db.AddInParameter(dbCommand, "pIdSeason", DbType.Int32, pItem.IdSeason); 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 frmManSeasonEdit_Load(object sender, EventArgs e) { if (pOperacion == Operacion.Nuevo) { this.Text = "Season - New"; } else if (pOperacion == Operacion.Modificar) { this.Text = "Season - Update"; SeasonBE objE_Season = null; objE_Season = new SeasonBL().Selecciona(IdSeason); if (objE_Season != null) { txtDescripcion.Text = objE_Season.NameSeason.Trim(); } } txtDescripcion.Select(); }
public void InicializarModificar() { if (gvSeason.RowCount > 0) { SeasonBE objSeason = new SeasonBE(); objSeason.IdSeason = int.Parse(gvSeason.GetFocusedRowCellValue("IdSeason").ToString()); frmManSeasonEdit objManSeasonEdit = new frmManSeasonEdit(); objManSeasonEdit.pOperacion = frmManSeasonEdit.Operacion.Modificar; objManSeasonEdit.IdSeason = objSeason.IdSeason; objManSeasonEdit.pSeasonBE = objSeason; objManSeasonEdit.StartPosition = FormStartPosition.CenterParent; objManSeasonEdit.ShowDialog(); Cargar(); } else { MessageBox.Show("No se pudo editar"); } }
public SeasonBE Selecciona(int IdSeason) { Database db = DatabaseFactory.CreateDatabase("cnERPBD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_Season_Selecciona"); db.AddInParameter(dbCommand, "pidSeason", DbType.Int32, IdSeason); IDataReader reader = db.ExecuteReader(dbCommand); SeasonBE Season = null; while (reader.Read()) { Season = new SeasonBE(); Season.IdSeason = Int32.Parse(reader["idSeason"].ToString()); Season.IdCompany = Int32.Parse(reader["IdCompany"].ToString()); Season.NameSeason = reader["NameSeason"].ToString(); Season.FlagState = Boolean.Parse(reader["FlagState"].ToString()); } reader.Close(); reader.Dispose(); return(Season); }
public List <SeasonBE> ListaTodosActivo(int IdCompany) { Database db = DatabaseFactory.CreateDatabase("cnERPBD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_Season_ListaTodosActivo"); db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, IdCompany); IDataReader reader = db.ExecuteReader(dbCommand); List <SeasonBE> Seasonlist = new List <SeasonBE>(); SeasonBE Season; while (reader.Read()) { Season = new SeasonBE(); Season.IdSeason = Int32.Parse(reader["idSeason"].ToString()); Season.IdCompany = Int32.Parse(reader["IdCompany"].ToString()); Season.NameSeason = reader["NameSeason"].ToString(); Season.FlagState = Boolean.Parse(reader["FlagState"].ToString()); Seasonlist.Add(Season); } reader.Close(); reader.Dispose(); return(Seasonlist); }