public List <ORAPersonaleVVF> GetByCodSede(string codiceSede)
{
var context = new DBContext();
var infoCon = context.GetConnectionFromCodiceSede(codiceSede);
var listaPersonale = new List <ORAPersonaleVVF>();
OracleConnection conn = new OracleConnection(infoCon.ConnectionString);
conn.Open();
OracleCommand cmd = new OracleCommand
{
Connection = conn,
CommandText = "SELECT NVL(COGNOME,' '), NVL(NOME,' '), NVL(MATDIP,0), NVL(COD_DISTACCAMENTO,0) FROM SALAOPER.PERSONALE p"
};
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
var personaSingola = new ORAPersonaleVVF
{
CodFiscale = dr.GetString(2),
Nominativo = $"{dr.GetString(1)}.{dr.GetString(0)}",
Sede = $"{codiceSede}.{dr.GetInt32(3).ToString()}"
};
listaPersonale.Add(personaSingola);
}
return(listaPersonale);
}
public ORAPersonaleVVF GetByCF(string codiceSede, string codiceFiscale)
{
var context = new DBContext();
var infoCon = context.GetConnectionFromCodiceSede(codiceSede);
OracleConnection conn = new OracleConnection(infoCon.ConnectionString);
conn.Open();
OracleCommand cmd = new OracleCommand
{
Connection = conn,
CommandText = "SELECT NVL(COGNOME,' '), NVL(NOME,' '), NVL(MATDIP,0), NVL(COD_DISTACCAMENTO,0) FROM SALAOPER.PERSONALE p WHERE MATDIP = :COD_FISC"
};
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new OracleParameter("COD_FISC", codiceFiscale));
OracleDataReader dr = cmd.ExecuteReader();
var personaSingola = new ORAPersonaleVVF();
while (dr.Read())
{
personaSingola.CodFiscale = dr.GetString(2);
personaSingola.Nominativo = $"{dr.GetString(1)}.{dr.GetString(0)}";
personaSingola.Sede = $"{codiceSede}.{dr.GetInt32(3).ToString()}";
}
return(personaSingola);
}
public static PersonaleVVF Map(ORAPersonaleVVF persona)
{
return(new PersonaleVVF
{
CodFiscale = persona.CodFiscale,
Nominativo = persona.Nominativo,
CodSede = persona.Sede
});
}
