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())
{
TypeBE objE_Type = new TypeBE();
objE_Type.IdType = int.Parse(gvType.GetFocusedRowCellValue("IdType").ToString());
objE_Type.Login = Parametros.strUsuarioLogin;
objE_Type.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objE_Type.IdCompany = Parametros.intEmpresaId;
TypeBL objBL_Type = new TypeBL();
objBL_Type.Elimina(objE_Type);
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 List <TypeBE> ListaTodosActivo(int IdCompany)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Type_ListaTodosActivo");
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, IdCompany);
IDataReader reader = db.ExecuteReader(dbCommand);
List <TypeBE> Typelist = new List <TypeBE>();
TypeBE Type;
while (reader.Read())
{
Type = new TypeBE();
Type.IdType = Int32.Parse(reader["idType"].ToString());
Type.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
Type.Abbreviate = reader["Abbreviate"].ToString();
Type.NameType = reader["NameType"].ToString();
Type.FlagState = Boolean.Parse(reader["FlagState"].ToString());
Typelist.Add(Type);
}
reader.Close();
reader.Dispose();
return(Typelist);
}
public void Elimina(TypeBE pItem)
{
try
{
TypeDL Type = new TypeDL();
Type.Elimina(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Actualiza(TypeBE pItem)
{
try
{
TypeDL Type = new TypeDL();
Type.Actualiza(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Inserta(TypeBE pItem)
{
try
{
TypeDL Type = new TypeDL();
Type.Inserta(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public TypeBE SeleccionaDescripcion(int IdCompany, string NameType)
{
try
{
TypeDL Type = new TypeDL();
TypeBE objEmp = Type.SeleccionaDescripcion(IdCompany, NameType);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public TypeBE Selecciona(int IdType)
{
try
{
TypeDL Type = new TypeDL();
TypeBE objEmp = Type.Selecciona(IdType);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(TypeBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Type_Elimina");
db.AddInParameter(dbCommand, "pIdType", DbType.Int32, pItem.IdType);
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(TypeBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Type_Actualiza");
db.AddInParameter(dbCommand, "pIdType", DbType.Int32, pItem.IdType);
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, pItem.IdCompany);
db.AddInParameter(dbCommand, "pAbbreviate", DbType.String, pItem.Abbreviate);
db.AddInParameter(dbCommand, "pNameType", DbType.String, pItem.NameType);
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 frmManTypeEdit_Load(object sender, EventArgs e)
{
if (pOperacion == Operacion.Nuevo)
{
this.Text = "Type - New";
}
else if (pOperacion == Operacion.Modificar)
{
this.Text = "Type - Update";
TypeBE objE_Type = null;
objE_Type = new TypeBL().Selecciona(IdType);
if (objE_Type != null)
{
txtAbbreviate.Text = objE_Type.Abbreviate;
txtDescripcion.Text = objE_Type.NameType.Trim();
}
}
txtAbbreviate.Select();
}
public void InicializarModificar()
{
if (gvType.RowCount > 0)
{
TypeBE objType = new TypeBE();
objType.IdType = int.Parse(gvType.GetFocusedRowCellValue("IdType").ToString());
frmManTypeEdit objManTypeEdit = new frmManTypeEdit();
objManTypeEdit.pOperacion = frmManTypeEdit.Operacion.Modificar;
objManTypeEdit.IdType = objType.IdType;
objManTypeEdit.pTypeBE = objType;
objManTypeEdit.StartPosition = FormStartPosition.CenterParent;
objManTypeEdit.ShowDialog();
Cargar();
}
else
{
MessageBox.Show("No se pudo editar");
}
}
public TypeBE Selecciona(int IdType)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Type_Selecciona");
db.AddInParameter(dbCommand, "pidType", DbType.Int32, IdType);
IDataReader reader = db.ExecuteReader(dbCommand);
TypeBE Type = null;
while (reader.Read())
{
Type = new TypeBE();
Type.IdType = Int32.Parse(reader["idType"].ToString());
Type.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
Type.Abbreviate = reader["Abbreviate"].ToString();
Type.NameType = reader["NameType"].ToString();
Type.FlagState = Boolean.Parse(reader["FlagState"].ToString());
}
reader.Close();
reader.Dispose();
return(Type);
}
private void btnGrabar_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
if (!ValidarIngreso())
{
TypeBL objBL_Type = new TypeBL();
TypeBE objType = new TypeBE();
objType.IdType = IdType;
objType.Abbreviate = txtAbbreviate.Text;
objType.NameType = txtDescripcion.Text;
objType.FlagState = true;
objType.Login = Parametros.strUsuarioLogin;
objType.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objType.IdCompany = Parametros.intEmpresaId;
if (pOperacion == Operacion.Nuevo)
{
objBL_Type.Inserta(objType);
}
else
{
objBL_Type.Actualiza(objType);
}
this.Close();
}
}
catch (Exception ex)
{
Cursor = Cursors.Default;
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Aceptar1()
{
_Be = (TypeBE)gvType.GetRow(gvType.FocusedRowHandle);
this.DialogResult = DialogResult.OK;
}
