private void btnGrabar_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
if (!ValidarIngreso())
{
OccupationBL objBL_Cargo = new OccupationBL();
OccupationBE objCargo = new OccupationBE();
objCargo.IdOccupation = IdOccupation;
objCargo.NameOccupation = txtDescripcion.Text;
objCargo.FlagState = true;
objCargo.Login = Parametros.strUsuarioLogin;
objCargo.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objCargo.IdCompany = Parametros.intEmpresaId;
if (pOperacion == Operacion.Nuevo)
{
objBL_Cargo.Inserta(objCargo);
}
else
{
objBL_Cargo.Actualiza(objCargo);
}
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())
{
OccupationBE objE_Cargo = new OccupationBE();
objE_Cargo.IdOccupation = int.Parse(gvCargo.GetFocusedRowCellValue("IdOccupation").ToString());
objE_Cargo.Login = Parametros.strUsuarioLogin;
objE_Cargo.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objE_Cargo.IdCompany = Parametros.intEmpresaId;
OccupationBL objBL_Cargo = new OccupationBL();
objBL_Cargo.Elimina(objE_Cargo);
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(OccupationBE pItem)
{
try
{
OccupationDL Occupation = new OccupationDL();
Occupation.Elimina(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Actualiza(OccupationBE pItem)
{
try
{
OccupationDL Occupation = new OccupationDL();
Occupation.Actualiza(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Inserta(OccupationBE pItem)
{
try
{
OccupationDL Occupation = new OccupationDL();
Occupation.Inserta(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public OccupationBE SeleccionaDescripcion(string Descripcion)
{
try
{
OccupationDL Occupation = new OccupationDL();
OccupationBE objEmp = Occupation.SeleccionaDescripcion(Descripcion);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public OccupationBE Selecciona(int IdOccupation)
{
try
{
OccupationDL Occupation = new OccupationDL();
OccupationBE objEmp = Occupation.Selecciona(IdOccupation);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(OccupationBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Occupation_Elimina");
db.AddInParameter(dbCommand, "pIdOccupation", DbType.Int32, pItem.IdOccupation);
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 OccupationBE SeleccionaDescripcion(string Descripcion)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Occupation_SeleccionaDescripcion");
db.AddInParameter(dbCommand, "pNameOccupation", DbType.String, Descripcion);
IDataReader reader = db.ExecuteReader(dbCommand);
OccupationBE Occupation = null;
while (reader.Read())
{
Occupation = new OccupationBE();
Occupation.IdOccupation = Int32.Parse(reader["idOccupation"].ToString());
Occupation.NameOccupation = reader["NameOccupation"].ToString();
Occupation.FlagState = Boolean.Parse(reader["FlagState"].ToString());
}
reader.Close();
reader.Dispose();
return(Occupation);
}
public void InicializarModificar()
{
if (gvCargo.RowCount > 0)
{
OccupationBE objCargo = new OccupationBE();
objCargo.IdOccupation = int.Parse(gvCargo.GetFocusedRowCellValue("IdOccupation").ToString());
objCargo.NameOccupation = gvCargo.GetFocusedRowCellValue("NameOccupation").ToString();
objCargo.FlagState = Convert.ToBoolean(gvCargo.GetFocusedRowCellValue("FlagState").ToString());
frmManCargoEdit objManCargoEdit = new frmManCargoEdit();
objManCargoEdit.pOperacion = frmManCargoEdit.Operacion.Modificar;
objManCargoEdit.IdOccupation = objCargo.IdOccupation;
objManCargoEdit.pOccupationBE = objCargo;
objManCargoEdit.StartPosition = FormStartPosition.CenterParent;
objManCargoEdit.ShowDialog();
Cargar();
}
else
{
MessageBox.Show("No se pudo editar");
}
}
public List <OccupationBE> ListaTodosActivo(int IdCompany)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Occupation_ListaTodosActivo");
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, IdCompany);
IDataReader reader = db.ExecuteReader(dbCommand);
List <OccupationBE> Occupationlist = new List <OccupationBE>();
OccupationBE Occupation;
while (reader.Read())
{
Occupation = new OccupationBE();
Occupation.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
Occupation.IdOccupation = Int32.Parse(reader["idOccupation"].ToString());
Occupation.NameOccupation = reader["NameOccupation"].ToString();
Occupation.FlagState = Boolean.Parse(reader["FlagState"].ToString());
Occupationlist.Add(Occupation);
}
reader.Close();
reader.Dispose();
return(Occupationlist);
}
