public Profondita GetProfonditaByLevel(string nome, string connectString) { Profondita livello = new Profondita(); 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.GetProfonditaByLivello, nome); connection.Open(); using (var reader = dbCMD.ExecuteReader()) { while (reader.Read()) { livello.id = reader.GetInt32(0); livello.Livello_Tracciamento = reader.GetString(1); } } } catch (Exception) { throw; } finally { connection.Close(); } } } return(livello); }
protected string GetValidationError(string propertyName) { if (Array.IndexOf(ValidatedProperties, propertyName) < 0) { return(null); } string error = null; switch (propertyName) { case "Profondita": { error = InputCheck.MaggioreDiZero(Profondita.ToString()); } break; case "SicurezzaZ": { if (SicurezzaZ <= InizioZ) { error = "Must be higher than StartZ"; } } break; default: Debug.Fail("Unexpected property : " + propertyName); break; } return(error); }
//UPDATE public bool update(Profondita profondita, 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.updateProfondita, profondita.Livello_Tracciamento, profondita.id); connection.Open(); esito = dbCMD.ExecuteNonQuery() > 0; } catch (Exception) { throw; } finally { connection.Close(); } } } return(esito); }