//UPDATE
public bool update(Componenti componente, string connectString)
{
bool esito = false;
using (SqlConnection connection = new SqlConnection(connectString))
{
using (SqlCommand dbCMD = new SqlCommand())
{
try
{
dbCMD.CommandType = System.Data.CommandType.Text;
dbCMD.Connection = connection;
dbCMD.CommandText = string.Format(Query.updateComponente, componente.NomeApplicazione, componente.Descrizione, componente.DataInserimento, componente.id);
connection.Open();
esito = dbCMD.ExecuteNonQuery() > 0;
}
catch (Exception)
{
throw;
}
finally
{
connection.Close();
}
}
}
return(esito);
}
public Componenti GetComponenteByAppName(string nome, string connectString)
{
Componenti componente = new Componenti();
using (SqlConnection connection = new SqlConnection(connectString))
{
using (SqlCommand dbCMD = new SqlCommand())
{
try
{
dbCMD.CommandType = System.Data.CommandType.Text;
dbCMD.Connection = connection;
dbCMD.CommandText = string.Format(Query.GetComponenteByAppName, nome);
connection.Open();
using (var reader = dbCMD.ExecuteReader())
{
while (reader.Read())
{
componente.id = reader.GetInt32(0);
componente.NomeApplicazione = reader.GetString(1);
componente.Descrizione = reader.GetString(2);
componente.DataInserimento = reader.GetDateTime(3);
}
}
}
catch (Exception)
{
throw;
}
finally
{
connection.Close();
}
}
}
return(componente);
}
