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())
{
EvaluationBE objE_Evaluation = new EvaluationBE();
objE_Evaluation.IdEvaluation = int.Parse(gvEvaluation.GetFocusedRowCellValue("IdEvaluation").ToString());
objE_Evaluation.Login = Parametros.strUsuarioLogin;
objE_Evaluation.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objE_Evaluation.IdCompany = Parametros.intEmpresaId;
EvaluationBL objBL_Evaluation = new EvaluationBL();
objBL_Evaluation.Elimina(objE_Evaluation);
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())
{
EvaluationBL objBL_Evaluation = new EvaluationBL();
EvaluationBE objEvaluation = new EvaluationBE();
objEvaluation.IdEvaluation = IdEvaluation;
objEvaluation.NameEvaluation = txtDescripcion.Text;
objEvaluation.FlagState = true;
objEvaluation.Login = Parametros.strUsuarioLogin;
objEvaluation.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objEvaluation.IdCompany = Parametros.intEmpresaId;
if (pOperacion == Operacion.Nuevo)
{
objBL_Evaluation.Inserta(objEvaluation);
}
else
{
objBL_Evaluation.Actualiza(objEvaluation);
}
this.Close();
}
}
catch (Exception ex)
{
Cursor = Cursors.Default;
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void Elimina(EvaluationBE pItem)
{
try
{
EvaluationDL Evaluation = new EvaluationDL();
Evaluation.Elimina(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Actualiza(EvaluationBE pItem)
{
try
{
EvaluationDL Evaluation = new EvaluationDL();
Evaluation.Actualiza(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Inserta(EvaluationBE pItem)
{
try
{
EvaluationDL Evaluation = new EvaluationDL();
Evaluation.Inserta(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public EvaluationBE SeleccionaDescripcion(int IdCompany, string NameEvaluation)
{
try
{
EvaluationDL Evaluation = new EvaluationDL();
EvaluationBE objEmp = Evaluation.SeleccionaDescripcion(IdCompany, NameEvaluation);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public EvaluationBE Selecciona(int IdEvaluation)
{
try
{
EvaluationDL Evaluation = new EvaluationDL();
EvaluationBE objEmp = Evaluation.Selecciona(IdEvaluation);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(EvaluationBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Evaluation_Elimina");
db.AddInParameter(dbCommand, "pIdEvaluation", DbType.Int32, pItem.IdEvaluation);
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 frmManEvaluationEdit_Load(object sender, EventArgs e)
{
if (pOperacion == Operacion.Nuevo)
{
this.Text = "Evaluation - New";
}
else if (pOperacion == Operacion.Modificar)
{
this.Text = "Evaluation - Update";
EvaluationBE objE_Evaluation = null;
objE_Evaluation = new EvaluationBL().Selecciona(IdEvaluation);
if (objE_Evaluation != null)
{
txtDescripcion.Text = objE_Evaluation.NameEvaluation.Trim();
}
}
txtDescripcion.Select();
}
public EvaluationBE Selecciona(int IdEvaluation)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Evaluation_Selecciona");
db.AddInParameter(dbCommand, "pidEvaluation", DbType.Int32, IdEvaluation);
IDataReader reader = db.ExecuteReader(dbCommand);
EvaluationBE Evaluation = null;
while (reader.Read())
{
Evaluation = new EvaluationBE();
Evaluation.IdEvaluation = Int32.Parse(reader["idEvaluation"].ToString());
Evaluation.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
Evaluation.NameEvaluation = reader["NameEvaluation"].ToString();
Evaluation.FlagState = Boolean.Parse(reader["FlagState"].ToString());
}
reader.Close();
reader.Dispose();
return(Evaluation);
}
public void InicializarModificar()
{
if (gvEvaluation.RowCount > 0)
{
EvaluationBE objEvaluation = new EvaluationBE();
objEvaluation.IdEvaluation = int.Parse(gvEvaluation.GetFocusedRowCellValue("IdEvaluation").ToString());
frmManEvaluationEdit objManEvaluationEdit = new frmManEvaluationEdit();
objManEvaluationEdit.pOperacion = frmManEvaluationEdit.Operacion.Modificar;
objManEvaluationEdit.IdEvaluation = objEvaluation.IdEvaluation;
objManEvaluationEdit.pEvaluationBE = objEvaluation;
objManEvaluationEdit.StartPosition = FormStartPosition.CenterParent;
objManEvaluationEdit.ShowDialog();
Cargar();
}
else
{
MessageBox.Show("No se pudo editar");
}
}
public List <EvaluationBE> ListaTodosActivo(int IdCompany)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Evaluation_ListaTodosActivo");
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, IdCompany);
IDataReader reader = db.ExecuteReader(dbCommand);
List <EvaluationBE> Evaluationlist = new List <EvaluationBE>();
EvaluationBE Evaluation;
while (reader.Read())
{
Evaluation = new EvaluationBE();
Evaluation.IdEvaluation = Int32.Parse(reader["idEvaluation"].ToString());
Evaluation.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
Evaluation.NameEvaluation = reader["NameEvaluation"].ToString();
Evaluation.FlagState = Boolean.Parse(reader["FlagState"].ToString());
Evaluationlist.Add(Evaluation);
}
reader.Close();
reader.Dispose();
return(Evaluationlist);
}
