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