Ejemplo n.º 1
0
        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);
        }
Ejemplo n.º 2
0
        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);
        }
Ejemplo n.º 3
0
        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);
        }