Пример #1
0
        public List<Post> findPosts(string type)
        {
            postList = new List<Post>();


            using (SqlConnection cn = new SqlConnection())
            {//and status = false
                cn.ConnectionString = @"Data Source=kraka.ucn.dk;Initial Catalog=dmai0914_2Sem_6;Persist Security Info=True;User ID=dmai0914_2Sem_6;Password=IsAllowed";
                cn.Open();
                string strSQL = "Select * From Post where type=@type";
                using (SqlCommand myCommand = new SqlCommand(strSQL, cn))
                {
                    myCommand.Parameters.AddWithValue("@type", type);
                    try
                    {
                        SqlDataReader myDataReader = myCommand.ExecuteReader();

                        while (myDataReader.Read())
                        {
                            Post u = new Post();
                            u.id = (int)myDataReader["id"];
                            u.type = (string)myDataReader["type"];
                            u.details = (string)myDataReader["details"];
                            u.price = (string)myDataReader["price"];
                            u.phoneNr = (string)myDataReader["phoneNr"];
                            u.address = (string)myDataReader["address"];
                            u.postalCode = (string)myDataReader["postalCode"];
                            u.expiration = (DateTime)myDataReader["expiration"];
                            u.isReserved = (bool)myDataReader["isReserved"];
                            postList.Add(u);
                        }
                    }
                    catch (SqlException e)
                    {
                        //error
                        postList = null;
                    }

                }
                cn.Close();
            }
            return postList;
        }
Пример #2
0
        public Post loadPost(int id)
        {
            Post u = new Post();

            using (SqlConnection cn = new SqlConnection())
            {
                cn.ConnectionString = @"Data Source=kraka.ucn.dk;Initial Catalog=dmai0914_2Sem_6;Persist Security Info=True;User ID=dmai0914_2Sem_6;Password=IsAllowed";
                cn.Open();
                string strSQL = "Select * from Post where id = @id";
                using (SqlCommand myCommand = new SqlCommand(strSQL, cn))
                {
                    myCommand.Parameters.AddWithValue("@id", id);
                    try
                    {
                        SqlDataReader myDataReader = myCommand.ExecuteReader();
                    
                        if (myDataReader.Read())
                        {

                            u.type = (string)myDataReader["type"];
                            u.details = (string)myDataReader["details"];
                            u.price = (string)myDataReader["price"];
                            u.phoneNr = (string)myDataReader["phoneNr"];
                            u.address = (string)myDataReader["address"];
                            u.postalCode = (string)myDataReader["postalCode"];
                            u.expiration = (DateTime)myDataReader["expiration"];
                            u.isReserved = (bool)myDataReader["isReserved"];
                            

                        }
                    }
                    catch (SqlException e)
                    {

                    }
                }
                cn.Close();
            }
            // test for null values
            return u;
        }