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())
{
StatusPOBE objE_StatusPO = new StatusPOBE();
objE_StatusPO.IdStatusPO = int.Parse(gvStatusPO.GetFocusedRowCellValue("IdStatusPO").ToString());
objE_StatusPO.Login = Parametros.strUsuarioLogin;
objE_StatusPO.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objE_StatusPO.IdCompany = Parametros.intEmpresaId;
StatusPOBL objBL_StatusPO = new StatusPOBL();
objBL_StatusPO.Elimina(objE_StatusPO);
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())
{
StatusPOBL objBL_StatusPO = new StatusPOBL();
StatusPOBE objStatusPO = new StatusPOBE();
objStatusPO.IdStatusPO = IdStatusPO;
objStatusPO.NameStatusPO = txtDescripcion.Text;
objStatusPO.FlagState = true;
objStatusPO.Login = Parametros.strUsuarioLogin;
objStatusPO.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objStatusPO.IdCompany = Parametros.intEmpresaId;
if (pOperacion == Operacion.Nuevo)
{
objBL_StatusPO.Inserta(objStatusPO);
}
else
{
objBL_StatusPO.Actualiza(objStatusPO);
}
this.Close();
}
}
catch (Exception ex)
{
Cursor = Cursors.Default;
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void Elimina(StatusPOBE pItem)
{
try
{
StatusPODL StatusPO = new StatusPODL();
StatusPO.Elimina(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Actualiza(StatusPOBE pItem)
{
try
{
StatusPODL StatusPO = new StatusPODL();
StatusPO.Actualiza(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Inserta(StatusPOBE pItem)
{
try
{
StatusPODL StatusPO = new StatusPODL();
StatusPO.Inserta(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public StatusPOBE SeleccionaDescripcion(int IdCompany, string NameStatusPO)
{
try
{
StatusPODL StatusPO = new StatusPODL();
StatusPOBE objEmp = StatusPO.SeleccionaDescripcion(IdCompany, NameStatusPO);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public StatusPOBE Selecciona(int IdStatusPO)
{
try
{
StatusPODL StatusPO = new StatusPODL();
StatusPOBE objEmp = StatusPO.Selecciona(IdStatusPO);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(StatusPOBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_StatusPO_Elimina");
db.AddInParameter(dbCommand, "pIdStatusPO", DbType.Int32, pItem.IdStatusPO);
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 frmManStatusPOEdit_Load(object sender, EventArgs e)
{
if (pOperacion == Operacion.Nuevo)
{
this.Text = "StatusPO - New";
}
else if (pOperacion == Operacion.Modificar)
{
this.Text = "StatusPO - Update";
StatusPOBE objE_StatusPO = null;
objE_StatusPO = new StatusPOBL().Selecciona(IdStatusPO);
if (objE_StatusPO != null)
{
txtDescripcion.Text = objE_StatusPO.NameStatusPO.Trim();
}
}
txtDescripcion.Select();
}
public StatusPOBE Selecciona(int IdStatusPO)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_StatusPO_Selecciona");
db.AddInParameter(dbCommand, "pidStatusPO", DbType.Int32, IdStatusPO);
IDataReader reader = db.ExecuteReader(dbCommand);
StatusPOBE StatusPO = null;
while (reader.Read())
{
StatusPO = new StatusPOBE();
StatusPO.IdStatusPO = Int32.Parse(reader["idStatusPO"].ToString());
StatusPO.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
StatusPO.NameStatusPO = reader["NameStatusPO"].ToString();
StatusPO.FlagState = Boolean.Parse(reader["FlagState"].ToString());
}
reader.Close();
reader.Dispose();
return(StatusPO);
}
public void InicializarModificar()
{
if (gvStatusPO.RowCount > 0)
{
StatusPOBE objStatusPO = new StatusPOBE();
objStatusPO.IdStatusPO = int.Parse(gvStatusPO.GetFocusedRowCellValue("IdStatusPO").ToString());
frmManStatusPOEdit objManStatusPOEdit = new frmManStatusPOEdit();
objManStatusPOEdit.pOperacion = frmManStatusPOEdit.Operacion.Modificar;
objManStatusPOEdit.IdStatusPO = objStatusPO.IdStatusPO;
objManStatusPOEdit.pStatusPOBE = objStatusPO;
objManStatusPOEdit.StartPosition = FormStartPosition.CenterParent;
objManStatusPOEdit.ShowDialog();
Cargar();
}
else
{
MessageBox.Show("No se pudo editar");
}
}
public List <StatusPOBE> ListaTodosActivo(int IdCompany)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_StatusPO_ListaTodosActivo");
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, IdCompany);
IDataReader reader = db.ExecuteReader(dbCommand);
List <StatusPOBE> StatusPOlist = new List <StatusPOBE>();
StatusPOBE StatusPO;
while (reader.Read())
{
StatusPO = new StatusPOBE();
StatusPO.IdStatusPO = Int32.Parse(reader["idStatusPO"].ToString());
StatusPO.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
StatusPO.NameStatusPO = reader["NameStatusPO"].ToString();
StatusPO.FlagState = Boolean.Parse(reader["FlagState"].ToString());
StatusPOlist.Add(StatusPO);
}
reader.Close();
reader.Dispose();
return(StatusPOlist);
}
