/// <summary>
/// Altera o cadastro
/// </summary>
/// <param name="usuarioBE"></param>
public void Alterar(StatusBE statusBE)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand command = db.GetSqlStringCommand("UPDATE Status SET Nome = " + statusBE.Nome + " Where id = " + statusBE.ID);
db.ExecuteNonQuery(command);
}
private void btnGrabar_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
if (!ValidarIngreso())
{
StatusBL objBL_Status = new StatusBL();
StatusBE objStatus = new StatusBE();
objStatus.IdStatus = IdStatus;
objStatus.NameStatus = txtDescripcion.Text;
objStatus.FlagState = true;
objStatus.Login = Parametros.strUsuarioLogin;
objStatus.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objStatus.IdCompany = Parametros.intEmpresaId;
if (pOperacion == Operacion.Nuevo)
{
objBL_Status.Inserta(objStatus);
}
else
{
objBL_Status.Actualiza(objStatus);
}
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())
{
StatusBE objE_Status = new StatusBE();
objE_Status.IdStatus = int.Parse(gvStatus.GetFocusedRowCellValue("IdStatus").ToString());
objE_Status.Login = Parametros.strUsuarioLogin;
objE_Status.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objE_Status.IdCompany = Parametros.intEmpresaId;
StatusBL objBL_Status = new StatusBL();
objBL_Status.Elimina(objE_Status);
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);
}
}
/// <summary>
/// Innclui um novo registro
/// </summary>
/// <param name="usuarioBE"></param>
public void Incluir(StatusBE statusBE)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand command = db.GetSqlStringCommand("INSERT INTO Status (Nome) VALUES (" + statusBE.Nome + ")");
db.ExecuteNonQuery(command);
}
public void Elimina(StatusBE pItem)
{
try
{
StatusDL Status = new StatusDL();
Status.Elimina(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Inserta(StatusBE pItem)
{
try
{
StatusDL Status = new StatusDL();
Status.Inserta(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Actualiza(StatusBE pItem)
{
try
{
StatusDL Status = new StatusDL();
Status.Actualiza(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public StatusBE Selecciona(int IdStatus)
{
try
{
StatusDL Status = new StatusDL();
StatusBE objEmp = Status.Selecciona(IdStatus);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public StatusBE SeleccionaDescripcion(int IdCompany, string NameStatus)
{
try
{
StatusDL Status = new StatusDL();
StatusBE objEmp = Status.SeleccionaDescripcion(IdCompany, NameStatus);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(StatusBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Status_Elimina");
db.AddInParameter(dbCommand, "pIdStatus", DbType.Int32, pItem.IdStatus);
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);
}
/// <summary>
/// Obtem dados do registro passando o ID
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public StatusBE Obter(int ID)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand command = db.GetSqlStringCommand("SELECT * FROM Status WHERE id = " + ID);
using (IDataReader dr = db.ExecuteReader(command))
{
StatusBE statusBE = new StatusBE();
if (dr.Read())
{
statusBE.ID = Convert.ToInt32(dr["ID"]);
statusBE.Nome = Convert.ToString(dr["Nome"]);
}
return(statusBE);
}
}
/// <summary>
/// Retorna uma lista de registro
/// </summary>
/// <returns></returns>
public List <StatusBE> Listar()
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand command = db.GetSqlStringCommand("SELECT * FROM Status");
List <StatusBE> Lista = new List <StatusBE>();
using (IDataReader dr = db.ExecuteReader(command))
{
while (dr.Read())
{
StatusBE statusBE = new StatusBE();
statusBE.ID = Convert.ToInt32(dr["ID"]);
statusBE.Nome = Convert.ToString(dr["Nome"]);
Lista.Add(statusBE);
}
}
return(Lista);
}
private void frmManStatusEdit_Load(object sender, EventArgs e)
{
if (pOperacion == Operacion.Nuevo)
{
this.Text = "Status - New";
}
else if (pOperacion == Operacion.Modificar)
{
this.Text = "Status - Update";
StatusBE objE_Status = null;
objE_Status = new StatusBL().Selecciona(IdStatus);
if (objE_Status != null)
{
txtDescripcion.Text = objE_Status.NameStatus.Trim();
}
}
txtDescripcion.Select();
}
public StatusBE Selecciona(int IdStatus)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Status_Selecciona");
db.AddInParameter(dbCommand, "pidStatus", DbType.Int32, IdStatus);
IDataReader reader = db.ExecuteReader(dbCommand);
StatusBE Status = null;
while (reader.Read())
{
Status = new StatusBE();
Status.IdStatus = Int32.Parse(reader["idStatus"].ToString());
Status.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
Status.NameStatus = reader["NameStatus"].ToString();
Status.FlagState = Boolean.Parse(reader["FlagState"].ToString());
}
reader.Close();
reader.Dispose();
return(Status);
}
public void InicializarModificar()
{
if (gvStatus.RowCount > 0)
{
StatusBE objStatus = new StatusBE();
objStatus.IdStatus = int.Parse(gvStatus.GetFocusedRowCellValue("IdStatus").ToString());
frmManStatusEdit objManStatusEdit = new frmManStatusEdit();
objManStatusEdit.pOperacion = frmManStatusEdit.Operacion.Modificar;
objManStatusEdit.IdStatus = objStatus.IdStatus;
objManStatusEdit.pStatusBE = objStatus;
objManStatusEdit.StartPosition = FormStartPosition.CenterParent;
objManStatusEdit.ShowDialog();
Cargar();
}
else
{
MessageBox.Show("No se pudo editar");
}
}
public List <StatusBE> ListaTodosActivo(int IdCompany)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Status_ListaTodosActivo");
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, IdCompany);
IDataReader reader = db.ExecuteReader(dbCommand);
List <StatusBE> Statuslist = new List <StatusBE>();
StatusBE Status;
while (reader.Read())
{
Status = new StatusBE();
Status.IdStatus = Int32.Parse(reader["idStatus"].ToString());
Status.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
Status.NameStatus = reader["NameStatus"].ToString();
Status.FlagState = Boolean.Parse(reader["FlagState"].ToString());
Statuslist.Add(Status);
}
reader.Close();
reader.Dispose();
return(Statuslist);
}
public List <StatusBE> Select(StatusBE obj)
{
return(new StatusDao().Select <StatusBE>(obj).ToList());
}
public StatusBE SelectId(StatusBE obj)
{
return(new StatusDao().SelectId <StatusBE>(obj));
}
public bool Delete(StatusBE obj)
{
return(new StatusDao().Delete(obj).Value);
}
public bool Update(StatusBE obj)
{
var result = new StatusDao().Update(obj);
return(result.Value);
}
public bool Insert(StatusBE obj)
{
var result = new StatusDao().Insert(obj);
return(Convert.ToBoolean(result));
}
