public List <AccidenteActoSubEstandarBE> ListaTodosActivo(int IdAccidente)
{
Database db = DatabaseFactory.CreateDatabase("cnSSOMABD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_AccidenteActoSubEstandar_ListaTodosActivo");
db.AddInParameter(dbCommand, "pIdAccidente", DbType.Int32, IdAccidente);
IDataReader reader = db.ExecuteReader(dbCommand);
List <AccidenteActoSubEstandarBE> AccidenteActoSubEstandarlist = new List <AccidenteActoSubEstandarBE>();
AccidenteActoSubEstandarBE AccidenteActoSubEstandar;
while (reader.Read())
{
AccidenteActoSubEstandar = new AccidenteActoSubEstandarBE();
AccidenteActoSubEstandar.IdEmpresa = Int32.Parse(reader["IdEmpresa"].ToString());
AccidenteActoSubEstandar.IdAccidente = Int32.Parse(reader["idAccidente"].ToString());
AccidenteActoSubEstandar.IdAccidenteActoSubEstandar = Int32.Parse(reader["idAccidenteActoSubEstandar"].ToString());
AccidenteActoSubEstandar.IdActoSubEstandar = Int32.Parse(reader["IdActoSubEstandar"].ToString());
AccidenteActoSubEstandar.DescActoSubEstandar = reader["DescActoSubEstandar"].ToString();
AccidenteActoSubEstandar.FlagEstado = Boolean.Parse(reader["flagestado"].ToString());
AccidenteActoSubEstandar.TipoOper = 4; //CONSULTAR
AccidenteActoSubEstandarlist.Add(AccidenteActoSubEstandar);
}
reader.Close();
reader.Dispose();
return(AccidenteActoSubEstandarlist);
}
public void Elimina(AccidenteActoSubEstandarBE pItem)
{
try
{
AccidenteActoSubEstandarDL AccidenteActoSubEstandar = new AccidenteActoSubEstandarDL();
AccidenteActoSubEstandar.Elimina(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public AccidenteActoSubEstandarBE Selecciona(int IdAccidenteActoSubEstandar)
{
try
{
AccidenteActoSubEstandarDL AccidenteActoSubEstandar = new AccidenteActoSubEstandarDL();
AccidenteActoSubEstandarBE objEmp = AccidenteActoSubEstandar.Selecciona(IdAccidenteActoSubEstandar);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(AccidenteActoSubEstandarBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnSSOMABD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_AccidenteActoSubEstandar_Elimina");
db.AddInParameter(dbCommand, "pIdAccidenteActoSubEstandar", DbType.Int32, pItem.IdAccidenteActoSubEstandar);
db.AddInParameter(dbCommand, "pIdEmpresa", DbType.Int32, pItem.IdEmpresa);
db.AddInParameter(dbCommand, "pUsuario", DbType.String, pItem.Usuario);
db.AddInParameter(dbCommand, "pMaquina", DbType.String, pItem.Maquina);
db.ExecuteNonQuery(dbCommand);
}
public AccidenteActoSubEstandarBE Selecciona(int IdAccidenteActoSubEstandar)
{
Database db = DatabaseFactory.CreateDatabase("cnSSOMABD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_AccidenteActoSubEstandar_Selecciona");
db.AddInParameter(dbCommand, "pidAccidenteActoSubEstandar", DbType.Int32, IdAccidenteActoSubEstandar);
IDataReader reader = db.ExecuteReader(dbCommand);
AccidenteActoSubEstandarBE AccidenteActoSubEstandar = null;
while (reader.Read())
{
AccidenteActoSubEstandar = new AccidenteActoSubEstandarBE();
AccidenteActoSubEstandar.IdEmpresa = Int32.Parse(reader["IdEmpresa"].ToString());
AccidenteActoSubEstandar.IdAccidente = Int32.Parse(reader["idAccidente"].ToString());
AccidenteActoSubEstandar.IdAccidenteActoSubEstandar = Int32.Parse(reader["idAccidenteActoSubEstandar"].ToString());
AccidenteActoSubEstandar.IdActoSubEstandar = Int32.Parse(reader["IdActoSubEstandar"].ToString());
AccidenteActoSubEstandar.DescActoSubEstandar = reader["DescActoSubEstandar"].ToString();
AccidenteActoSubEstandar.FlagEstado = Boolean.Parse(reader["flagestado"].ToString());
}
reader.Close();
reader.Dispose();
return(AccidenteActoSubEstandar);
}
