private string GetCode(long parameterID, WaterCodeType type)
{
string code = "";
using (SqlConnection conn = new SqlConnection(_connectionString))
{
conn.Open();
using (SqlCommand parameterLookup = new SqlCommand(string.Format("select * from WaterDataParameters where ID={0}", parameterID), conn))
using (SqlDataReader reader = parameterLookup.ExecuteReader())
{
if (reader.Read())
{
switch (type)
{
case WaterCodeType.PARAMETER:
code = reader.GetString(1).TrimEnd();
break;
case WaterCodeType.STATISTIC:
code = reader.GetString(3).TrimEnd();
break;
default:
return(code);
}
}
reader.Close();
}//End Using SQL Command
} //End Using SQL Conection
return(code);
}
private string GetCode(long parameterID, WaterCodeType type)
{
string code = "";
using (SqlConnection conn = new SqlConnection(_connectionString))
{
conn.Open();
using (SqlCommand parameterLookup = new SqlCommand(string.Format("select * from WaterDataParameters where ID={0}", parameterID), conn))
using (SqlDataReader reader = parameterLookup.ExecuteReader())
{
if (reader.Read())
{
switch (type)
{
case WaterCodeType.PARAMETER:
code = reader.GetString(1).TrimEnd();
break;
case WaterCodeType.STATISTIC:
code = reader.GetString(3).TrimEnd();
break;
default:
return code;
}
}
reader.Close();
} //End Using SQL Command
} //End Using SQL Conection
return code;
}
