//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); }