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