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