private void btnGrabar_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
if (!ValidarIngreso())
{
TypeStyleBL objBL_TypeStyle = new TypeStyleBL();
TypeStyleBE objTypeStyle = new TypeStyleBE();
objTypeStyle.IdTypeStyle = IdTypeStyle;
objTypeStyle.NameTypeStyle = txtDescripcion.Text;
objTypeStyle.FlagState = true;
objTypeStyle.Login = Parametros.strUsuarioLogin;
objTypeStyle.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objTypeStyle.IdCompany = Parametros.intEmpresaId;
if (pOperacion == Operacion.Nuevo)
{
objBL_TypeStyle.Inserta(objTypeStyle);
}
else
{
objBL_TypeStyle.Actualiza(objTypeStyle);
}
this.Close();
}
}
catch (Exception ex)
{
Cursor = Cursors.Default;
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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())
{
TypeStyleBE objE_TypeStyle = new TypeStyleBE();
objE_TypeStyle.IdTypeStyle = int.Parse(gvTypeStyle.GetFocusedRowCellValue("IdTypeStyle").ToString());
objE_TypeStyle.Login = Parametros.strUsuarioLogin;
objE_TypeStyle.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objE_TypeStyle.IdCompany = Parametros.intEmpresaId;
TypeStyleBL objBL_TypeStyle = new TypeStyleBL();
objBL_TypeStyle.Elimina(objE_TypeStyle);
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(TypeStyleBE pItem)
{
try
{
TypeStyleDL TypeStyle = new TypeStyleDL();
TypeStyle.Elimina(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Actualiza(TypeStyleBE pItem)
{
try
{
TypeStyleDL TypeStyle = new TypeStyleDL();
TypeStyle.Actualiza(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public TypeStyleBE SeleccionaDescripcion(int IdCompany, string NameTypeStyle)
{
try
{
TypeStyleDL TypeStyle = new TypeStyleDL();
TypeStyleBE objEmp = TypeStyle.SeleccionaDescripcion(IdCompany, NameTypeStyle);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public TypeStyleBE Selecciona(int IdTypeStyle)
{
try
{
TypeStyleDL TypeStyle = new TypeStyleDL();
TypeStyleBE objEmp = TypeStyle.Selecciona(IdTypeStyle);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(TypeStyleBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_TypeStyle_Elimina");
db.AddInParameter(dbCommand, "pIdTypeStyle", DbType.Int32, pItem.IdTypeStyle);
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 frmManTypeStyleEdit_Load(object sender, EventArgs e)
{
if (pOperacion == Operacion.Nuevo)
{
this.Text = "TypeStyle - New";
}
else if (pOperacion == Operacion.Modificar)
{
this.Text = "TypeStyle - Update";
TypeStyleBE objE_TypeStyle = null;
objE_TypeStyle = new TypeStyleBL().Selecciona(IdTypeStyle);
if (objE_TypeStyle != null)
{
txtDescripcion.Text = objE_TypeStyle.NameTypeStyle.Trim();
}
}
txtDescripcion.Select();
}
public void InicializarModificar()
{
if (gvTypeStyle.RowCount > 0)
{
TypeStyleBE objTypeStyle = new TypeStyleBE();
objTypeStyle.IdTypeStyle = int.Parse(gvTypeStyle.GetFocusedRowCellValue("IdTypeStyle").ToString());
frmManTypeStyleEdit objManTypeStyleEdit = new frmManTypeStyleEdit();
objManTypeStyleEdit.pOperacion = frmManTypeStyleEdit.Operacion.Modificar;
objManTypeStyleEdit.IdTypeStyle = objTypeStyle.IdTypeStyle;
objManTypeStyleEdit.pTypeStyleBE = objTypeStyle;
objManTypeStyleEdit.StartPosition = FormStartPosition.CenterParent;
objManTypeStyleEdit.ShowDialog();
Cargar();
}
else
{
MessageBox.Show("No se pudo editar");
}
}
public TypeStyleBE Selecciona(int IdTypeStyle)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_TypeStyle_Selecciona");
db.AddInParameter(dbCommand, "pidTypeStyle", DbType.Int32, IdTypeStyle);
IDataReader reader = db.ExecuteReader(dbCommand);
TypeStyleBE TypeStyle = null;
while (reader.Read())
{
TypeStyle = new TypeStyleBE();
TypeStyle.IdTypeStyle = Int32.Parse(reader["idTypeStyle"].ToString());
TypeStyle.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
TypeStyle.NameTypeStyle = reader["NameTypeStyle"].ToString();
TypeStyle.FlagState = Boolean.Parse(reader["FlagState"].ToString());
}
reader.Close();
reader.Dispose();
return(TypeStyle);
}
public List <TypeStyleBE> ListaTodosActivo(int IdCompany)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_TypeStyle_ListaTodosActivo");
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, IdCompany);
IDataReader reader = db.ExecuteReader(dbCommand);
List <TypeStyleBE> TypeStylelist = new List <TypeStyleBE>();
TypeStyleBE TypeStyle;
while (reader.Read())
{
TypeStyle = new TypeStyleBE();
TypeStyle.IdTypeStyle = Int32.Parse(reader["idTypeStyle"].ToString());
TypeStyle.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
TypeStyle.NameTypeStyle = reader["NameTypeStyle"].ToString();
TypeStyle.FlagState = Boolean.Parse(reader["FlagState"].ToString());
TypeStylelist.Add(TypeStyle);
}
reader.Close();
reader.Dispose();
return(TypeStylelist);
}
