public List <DestinationBE> ListaTodosActivo(int IdCompany)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Destination_ListaTodosActivo");
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, IdCompany);
IDataReader reader = db.ExecuteReader(dbCommand);
List <DestinationBE> Destinationlist = new List <DestinationBE>();
DestinationBE Destination;
while (reader.Read())
{
Destination = new DestinationBE();
Destination.IdDestination = Int32.Parse(reader["idDestination"].ToString());
Destination.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
Destination.NameDestination = reader["NameDestination"].ToString();
Destination.NumberLineCertificate = Int32.Parse(reader["NumberLineCertificate"].ToString());
Destination.FlagState = Boolean.Parse(reader["FlagState"].ToString());
Destinationlist.Add(Destination);
}
reader.Close();
reader.Dispose();
return(Destinationlist);
}
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())
{
DestinationBE objE_Destination = new DestinationBE();
objE_Destination.IdDestination = int.Parse(gvDestination.GetFocusedRowCellValue("IdDestination").ToString());
objE_Destination.Login = Parametros.strUsuarioLogin;
objE_Destination.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objE_Destination.IdCompany = Parametros.intEmpresaId;
DestinationBL objBL_Destination = new DestinationBL();
objBL_Destination.Elimina(objE_Destination);
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);
}
}
public void Elimina(DestinationBE pItem)
{
try
{
DestinationDL Destination = new DestinationDL();
Destination.Elimina(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Actualiza(DestinationBE pItem)
{
try
{
DestinationDL Destination = new DestinationDL();
Destination.Actualiza(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public DestinationBE SeleccionaDescripcion(int IdCompany, string NameDestination)
{
try
{
DestinationDL Destination = new DestinationDL();
DestinationBE objEmp = Destination.SeleccionaDescripcion(IdCompany, NameDestination);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public DestinationBE Selecciona(int IdDestination)
{
try
{
DestinationDL Destination = new DestinationDL();
DestinationBE objEmp = Destination.Selecciona(IdDestination);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(DestinationBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Destination_Elimina");
db.AddInParameter(dbCommand, "pIdDestination", DbType.Int32, pItem.IdDestination);
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);
}
public void Actualiza(DestinationBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Destination_Actualiza");
db.AddInParameter(dbCommand, "pIdDestination", DbType.Int32, pItem.IdDestination);
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, pItem.IdCompany);
db.AddInParameter(dbCommand, "pNameDestination", DbType.String, pItem.NameDestination);
db.AddInParameter(dbCommand, "pNumberLineCertificate", DbType.Int32, pItem.NumberLineCertificate);
db.AddInParameter(dbCommand, "pFlagState", DbType.Boolean, pItem.FlagState);
db.AddInParameter(dbCommand, "pLogin", DbType.String, pItem.Login);
db.AddInParameter(dbCommand, "pMachine", DbType.String, pItem.Machine);
db.ExecuteNonQuery(dbCommand);
}
private void frmManDestinationEdit_Load(object sender, EventArgs e)
{
if (pOperacion == Operacion.Nuevo)
{
this.Text = "Destination - New";
}
else if (pOperacion == Operacion.Modificar)
{
this.Text = "Destination - Update";
DestinationBE objE_Destination = null;
objE_Destination = new DestinationBL().Selecciona(IdDestination);
if (objE_Destination != null)
{
txtDescripcion.Text = objE_Destination.NameDestination.Trim();
txtNumberLineCertificate.EditValue = objE_Destination.NumberLineCertificate;
}
}
txtDescripcion.Select();
}
public void InicializarModificar()
{
if (gvDestination.RowCount > 0)
{
DestinationBE objDestination = new DestinationBE();
objDestination.IdDestination = int.Parse(gvDestination.GetFocusedRowCellValue("IdDestination").ToString());
frmManDestinationEdit objManDestinationEdit = new frmManDestinationEdit();
objManDestinationEdit.pOperacion = frmManDestinationEdit.Operacion.Modificar;
objManDestinationEdit.IdDestination = objDestination.IdDestination;
objManDestinationEdit.pDestinationBE = objDestination;
objManDestinationEdit.StartPosition = FormStartPosition.CenterParent;
objManDestinationEdit.ShowDialog();
Cargar();
}
else
{
MessageBox.Show("No se pudo editar");
}
}
public DestinationBE Selecciona(int IdDestination)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Destination_Selecciona");
db.AddInParameter(dbCommand, "pidDestination", DbType.Int32, IdDestination);
IDataReader reader = db.ExecuteReader(dbCommand);
DestinationBE Destination = null;
while (reader.Read())
{
Destination = new DestinationBE();
Destination.IdDestination = Int32.Parse(reader["idDestination"].ToString());
Destination.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
Destination.NameDestination = reader["NameDestination"].ToString();
Destination.NumberLineCertificate = Int32.Parse(reader["NumberLineCertificate"].ToString());
Destination.FlagState = Boolean.Parse(reader["FlagState"].ToString());
}
reader.Close();
reader.Dispose();
return(Destination);
}
private void btnGrabar_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
if (!ValidarIngreso())
{
DestinationBL objBL_Destination = new DestinationBL();
DestinationBE objDestination = new DestinationBE();
objDestination.IdDestination = IdDestination;
objDestination.NameDestination = txtDescripcion.Text;
objDestination.NumberLineCertificate = Convert.ToInt32(txtNumberLineCertificate.Text);
objDestination.FlagState = true;
objDestination.Login = Parametros.strUsuarioLogin;
objDestination.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objDestination.IdCompany = Parametros.intEmpresaId;
if (pOperacion == Operacion.Nuevo)
{
objBL_Destination.Inserta(objDestination);
}
else
{
objBL_Destination.Actualiza(objDestination);
}
this.Close();
}
}
catch (Exception ex)
{
Cursor = Cursors.Default;
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Aceptar1()
{
_Be = (DestinationBE)gvDestination.GetRow(gvDestination.FocusedRowHandle);
this.DialogResult = DialogResult.OK;
}
