private void eliminarToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
if (XtraMessageBox.Show("Be sure to delete the record?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (!ValidarIngreso())
{
ElementTabletBE objE_TablaElemento = new ElementTabletBE();
objE_TablaElemento.IdElementTablet = int.Parse(gvTablaElemento.GetFocusedRowCellValue("IdElementTablet").ToString());
objE_TablaElemento.Login = Parametros.strUsuarioLogin;
objE_TablaElemento.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objE_TablaElemento.IdCompany = Parametros.intEmpresaId;
ElementTabletBL objBL_TablaElemento = new ElementTabletBL();
objBL_TablaElemento.Elimina(objE_TablaElemento);
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 <ElementTabletBE> ListaTodosActivo(int IdCompany, int IdTablet)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_ElementTablet_ListaTodosActivo");
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, IdCompany);
db.AddInParameter(dbCommand, "pIdTablet", DbType.Int32, IdTablet);
IDataReader reader = db.ExecuteReader(dbCommand);
List <ElementTabletBE> ElementTabletlist = new List <ElementTabletBE>();
ElementTabletBE ElementTablet;
while (reader.Read())
{
ElementTablet = new ElementTabletBE();
ElementTablet.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
ElementTablet.IdElementTablet = Int32.Parse(reader["idElementTablet"].ToString());
ElementTablet.IdTablet = Int32.Parse(reader["IdTablet"].ToString());
ElementTablet.NameTablet = reader["NameTablet"].ToString();
ElementTablet.Abbreviate = reader["Abbreviate"].ToString();
ElementTablet.NameElementTablet = reader["NameElementTablet"].ToString();
ElementTablet.FlagState = Boolean.Parse(reader["FlagState"].ToString());
ElementTabletlist.Add(ElementTablet);
}
reader.Close();
reader.Dispose();
//ElementTabletlist.Insert(0, new ElementTabletBE() { IdElementTablet = 0, NameElementTablet = "TODOS" });
return(ElementTabletlist);
}
public void InicializarModificar()
{
if (gvTablaElemento.RowCount > 0)
{
ElementTabletBE objTablaElemento = new ElementTabletBE();
objTablaElemento.IdTablet = int.Parse(gvTablaElemento.GetFocusedRowCellValue("IdTablet").ToString());
objTablaElemento.IdElementTablet = int.Parse(gvTablaElemento.GetFocusedRowCellValue("IdElementTablet").ToString());
objTablaElemento.NameTablet = gvTablaElemento.GetFocusedRowCellValue("NameTablet").ToString();
objTablaElemento.Abbreviate = gvTablaElemento.GetFocusedRowCellValue("Abbreviate").ToString();
objTablaElemento.NameElementTablet = gvTablaElemento.GetFocusedRowCellValue("NameElementTablet").ToString();
objTablaElemento.FlagState = Convert.ToBoolean(gvTablaElemento.GetFocusedRowCellValue("FlagState").ToString());
frmManTablaElementoEdit objManTablaEdit = new frmManTablaElementoEdit();
objManTablaEdit.pOperacion = frmManTablaElementoEdit.Operacion.Modificar;
objManTablaEdit.IdTablet = objTablaElemento.IdTablet;
objManTablaEdit.IdElementTablet = objTablaElemento.IdElementTablet;
objManTablaEdit.pElementTabletBE = objTablaElemento;
objManTablaEdit.StartPosition = FormStartPosition.CenterParent;
objManTablaEdit.ShowDialog();
Cargar();
}
else
{
MessageBox.Show("Edit");
}
}
public ElementTabletBE SeleccionaDescripcion(int IdTablet, string NameElementTablet)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_ElementTablet_SeleccionaDescripcion");
db.AddInParameter(dbCommand, "pIdTablet", DbType.Int32, IdTablet);
db.AddInParameter(dbCommand, "pNameElementTablet", DbType.String, NameElementTablet);
IDataReader reader = db.ExecuteReader(dbCommand);
ElementTabletBE ElementTablet = null;
while (reader.Read())
{
ElementTablet = new ElementTabletBE();
ElementTablet.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
ElementTablet.IdElementTablet = Int32.Parse(reader["idElementTablet"].ToString());
ElementTablet.IdTablet = Int32.Parse(reader["IdTablet"].ToString());
ElementTablet.NameTablet = reader["NameTablet"].ToString();
ElementTablet.Abbreviate = reader["Abbreviate"].ToString();
ElementTablet.NameElementTablet = reader["NameElementTablet"].ToString();
ElementTablet.FlagState = Boolean.Parse(reader["FlagState"].ToString());
}
reader.Close();
reader.Dispose();
//ElementTabletlist.Insert(0, new ElementTabletBE() { IdElementTablet = 0, NameElementTablet = "TODOS" });
return(ElementTablet);
}
public void Elimina(ElementTabletBE pItem)
{
try
{
ElementTabletDL ElementTablet = new ElementTabletDL();
ElementTablet.Elimina(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Actualiza(ElementTabletBE pItem)
{
try
{
ElementTabletDL ElementTablet = new ElementTabletDL();
ElementTablet.Actualiza(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public Int32 Inserta(ElementTabletBE pItem)
{
try
{
ElementTabletDL ElementTablet = new ElementTabletDL();
return(ElementTablet.Inserta(pItem));
}
catch (Exception ex)
{ throw ex; }
}
public ElementTabletBE SeleccionaDescripcion(int IdTablet, string DescElementTablet)
{
try
{
ElementTabletDL ElementTablet = new ElementTabletDL();
ElementTabletBE objEmp = ElementTablet.SeleccionaDescripcion(IdTablet, DescElementTablet);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(ElementTabletBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_ElementTablet_Elimina");
db.AddInParameter(dbCommand, "pIdElementTablet", DbType.Int32, pItem.IdElementTablet);
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(ElementTabletBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_ElementTablet_Actualiza");
db.AddInParameter(dbCommand, "pIdElementTablet", DbType.Int32, pItem.IdElementTablet);
db.AddInParameter(dbCommand, "pIdTablet", DbType.Int32, pItem.IdTablet);
db.AddInParameter(dbCommand, "pAbbreviate", DbType.String, pItem.Abbreviate);
db.AddInParameter(dbCommand, "pNameElementTablet", DbType.String, pItem.NameElementTablet);
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.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, pItem.IdCompany);
db.ExecuteNonQuery(dbCommand);
}
public Int32 Inserta(ElementTabletBE pItem)
{
Int32 intElementTablet = 0;
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_ElementTablet_Inserta");
db.AddOutParameter(dbCommand, "pIdElementTablet", DbType.Int32, pItem.IdElementTablet);
db.AddInParameter(dbCommand, "pIdTablet", DbType.Int32, pItem.IdTablet);
db.AddInParameter(dbCommand, "pAbbreviate", DbType.String, pItem.Abbreviate);
db.AddInParameter(dbCommand, "pNameElementTablet", DbType.String, pItem.NameElementTablet);
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.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, pItem.IdCompany);
db.ExecuteNonQuery(dbCommand);
intElementTablet = (int)db.GetParameterValue(dbCommand, "pIdElementTablet");
return(intElementTablet);
}
private void btnGrabar_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
if (!ValidarIngreso())
{
ElementTabletBL objBL_TablaElemento = new ElementTabletBL();
ElementTabletBE objTablaElemento = new ElementTabletBE();
objTablaElemento.IdTablet = IdTablet;
objTablaElemento.IdElementTablet = IdElementTablet;
objTablaElemento.Abbreviate = txtAbreviatura.Text;
objTablaElemento.NameElementTablet = txtDescripcion.Text;
objTablaElemento.FlagState = true;
objTablaElemento.Login = Parametros.strUsuarioLogin;
objTablaElemento.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objTablaElemento.IdCompany = Parametros.intEmpresaId;
if (pOperacion == Operacion.Nuevo)
{
objBL_TablaElemento.Inserta(objTablaElemento);
}
else
{
objBL_TablaElemento.Actualiza(objTablaElemento);
}
this.Close();
}
}
catch (Exception ex)
{
Cursor = Cursors.Default;
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
