public static List <Parameter> getAllParameters()
{
List <Parameter> allParameter = new List <Parameter>();
using (SqlConnection con = GetSqlConnection.getSqlConnection())
{
String selectAllStr = "select * from Product_Parameter";
SqlCommand cmd = new SqlCommand(selectAllStr, con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Parameter p = new Parameter();
p.id = Convert.ToInt32(reader["Id"]);
p.value = Convert.ToString(reader["param_desc"]);
allParameter.Add(p);
}
}
return(allParameter);
}
public static Boolean addParameter(Parameter param)
{
int result = 0;
using (SqlConnection con = GetSqlConnection.getSqlConnection())
{
String insertStr = "insert into Product_Parameter values(@value)";
SqlCommand cmd = new SqlCommand(insertStr, con);
cmd.Parameters.AddWithValue("@value", param.value);
con.Open();
result = cmd.ExecuteNonQuery();
}
return(result > 0 ? true : false);
}
public static Parameter getParameterById(string searchId)
{
Parameter result = new Parameter();
using (SqlConnection con = GetSqlConnection.getSqlConnection())
{
String selectAllStr = "select * from Product_Parameter where id = @id";
SqlCommand cmd = new SqlCommand(selectAllStr, con);
cmd.Parameters.AddWithValue("@id", searchId);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
result.id = Convert.ToInt32(reader["Id"]);
result.value = Convert.ToString(reader["param_desc"]);
}
}
return(result);
}