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())
{
TypeDesignBE objE_TypeDesign = new TypeDesignBE();
objE_TypeDesign.IdTypeDesign = int.Parse(gvTypeDesign.GetFocusedRowCellValue("IdTypeDesign").ToString());
objE_TypeDesign.Login = Parametros.strUsuarioLogin;
objE_TypeDesign.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objE_TypeDesign.IdCompany = Parametros.intEmpresaId;
TypeDesignBL objBL_TypeDesign = new TypeDesignBL();
objBL_TypeDesign.Elimina(objE_TypeDesign);
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())
{
TypeDesignBL objBL_TypeDesign = new TypeDesignBL();
TypeDesignBE objTypeDesign = new TypeDesignBE();
objTypeDesign.IdTypeDesign = IdTypeDesign;
objTypeDesign.NameTypeDesign = txtDescripcion.Text;
objTypeDesign.FlagState = true;
objTypeDesign.Login = Parametros.strUsuarioLogin;
objTypeDesign.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objTypeDesign.IdCompany = Parametros.intEmpresaId;
if (pOperacion == Operacion.Nuevo)
{
objBL_TypeDesign.Inserta(objTypeDesign);
}
else
{
objBL_TypeDesign.Actualiza(objTypeDesign);
}
this.Close();
}
}
catch (Exception ex)
{
Cursor = Cursors.Default;
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void Elimina(TypeDesignBE pItem)
{
try
{
TypeDesignDL TypeDesign = new TypeDesignDL();
TypeDesign.Elimina(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Actualiza(TypeDesignBE pItem)
{
try
{
TypeDesignDL TypeDesign = new TypeDesignDL();
TypeDesign.Actualiza(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public TypeDesignBE SeleccionaDescripcion(int IdCompany, string NameTypeDesign)
{
try
{
TypeDesignDL TypeDesign = new TypeDesignDL();
TypeDesignBE objEmp = TypeDesign.SeleccionaDescripcion(IdCompany, NameTypeDesign);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public TypeDesignBE Selecciona(int IdTypeDesign)
{
try
{
TypeDesignDL TypeDesign = new TypeDesignDL();
TypeDesignBE objEmp = TypeDesign.Selecciona(IdTypeDesign);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(TypeDesignBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_TypeDesign_Elimina");
db.AddInParameter(dbCommand, "pIdTypeDesign", DbType.Int32, pItem.IdTypeDesign);
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 frmManTypeDesignEdit_Load(object sender, EventArgs e)
{
if (pOperacion == Operacion.Nuevo)
{
this.Text = "TypeDesign - New";
}
else if (pOperacion == Operacion.Modificar)
{
this.Text = "TypeDesign - Update";
TypeDesignBE objE_TypeDesign = null;
objE_TypeDesign = new TypeDesignBL().Selecciona(IdTypeDesign);
if (objE_TypeDesign != null)
{
txtDescripcion.Text = objE_TypeDesign.NameTypeDesign.Trim();
}
}
txtDescripcion.Select();
}
public void InicializarModificar()
{
if (gvTypeDesign.RowCount > 0)
{
TypeDesignBE objTypeDesign = new TypeDesignBE();
objTypeDesign.IdTypeDesign = int.Parse(gvTypeDesign.GetFocusedRowCellValue("IdTypeDesign").ToString());
frmManTypeDesignEdit objManTypeDesignEdit = new frmManTypeDesignEdit();
objManTypeDesignEdit.pOperacion = frmManTypeDesignEdit.Operacion.Modificar;
objManTypeDesignEdit.IdTypeDesign = objTypeDesign.IdTypeDesign;
objManTypeDesignEdit.pTypeDesignBE = objTypeDesign;
objManTypeDesignEdit.StartPosition = FormStartPosition.CenterParent;
objManTypeDesignEdit.ShowDialog();
Cargar();
}
else
{
MessageBox.Show("No se pudo editar");
}
}
public TypeDesignBE Selecciona(int IdTypeDesign)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_TypeDesign_Selecciona");
db.AddInParameter(dbCommand, "pidTypeDesign", DbType.Int32, IdTypeDesign);
IDataReader reader = db.ExecuteReader(dbCommand);
TypeDesignBE TypeDesign = null;
while (reader.Read())
{
TypeDesign = new TypeDesignBE();
TypeDesign.IdTypeDesign = Int32.Parse(reader["idTypeDesign"].ToString());
TypeDesign.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
TypeDesign.NameTypeDesign = reader["NameTypeDesign"].ToString();
TypeDesign.FlagState = Boolean.Parse(reader["FlagState"].ToString());
}
reader.Close();
reader.Dispose();
return(TypeDesign);
}
public List <TypeDesignBE> ListaTodosActivo(int IdCompany)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_TypeDesign_ListaTodosActivo");
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, IdCompany);
IDataReader reader = db.ExecuteReader(dbCommand);
List <TypeDesignBE> TypeDesignlist = new List <TypeDesignBE>();
TypeDesignBE TypeDesign;
while (reader.Read())
{
TypeDesign = new TypeDesignBE();
TypeDesign.IdTypeDesign = Int32.Parse(reader["idTypeDesign"].ToString());
TypeDesign.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
TypeDesign.NameTypeDesign = reader["NameTypeDesign"].ToString();
TypeDesign.FlagState = Boolean.Parse(reader["FlagState"].ToString());
TypeDesignlist.Add(TypeDesign);
}
reader.Close();
reader.Dispose();
return(TypeDesignlist);
}
