Esempio n. 1
0
        public Authors FindAuthor(int id)
        {
            MySqlConnection Connect       = new MySqlConnection(ConnectionString);
            Authors         result_author = new Authors();

            try
            {
                string query = "select * from authors where authorid = " + id;
                Debug.WriteLine("Connection Initialized...");
                Connect.Open();
                MySqlCommand    cmd       = new MySqlCommand(query, Connect);
                MySqlDataReader resultset = cmd.ExecuteReader();
                List <Authors>  authors   = new List <Authors>();

                while (resultset.Read())
                {
                    Authors currentauthor = new Authors();
                    for (int i = 0; i < resultset.FieldCount; i++)
                    {
                        string key   = resultset.GetName(i);
                        string value = resultset.GetString(i);
                        Debug.WriteLine("Attempting to transfer " + key + " data of " + value);
                        switch (key)
                        {
                        case "authorfname":
                            currentauthor.SetAuthorfname(value);
                            break;

                        case "authorlname":
                            currentauthor.SetAuthorlname(value);
                            break;
                        }
                    }
                    authors.Add(currentauthor);
                }
                result_author = authors[0];
            }
            catch (Exception ex)
            {
                Debug.WriteLine("Something went wrong in the find Author method!");
                Debug.WriteLine(ex.ToString());
            }
            Connect.Close();
            Debug.WriteLine("Database Connection Terminated.");

            return(result_author);
        }
Esempio n. 2
0
        public void Update_Author(int authorid, Authors new_author)
        {
            string query = "update authors set authorfname='{0}', authorlname='{1}' where authorid={2}";

            query = String.Format(query, new_author.GetAuthorfname(), new_author.GetAuthorlname(), authorid);
            MySqlConnection Connect = new MySqlConnection(ConnectionString);
            MySqlCommand    cmd     = new MySqlCommand(query, Connect);

            try
            {
                Connect.Open();
                cmd.ExecuteNonQuery();
                Debug.WriteLine("Executed query " + query);
            }
            catch (Exception ex)
            {
                Debug.WriteLine("Something went wrong in the Update_Author Method!");
                Debug.WriteLine(ex.ToString());
            }
            Connect.Close();
        }
Esempio n. 3
0
        //adding a new author
        public void Add_Author(Authors new_author)
        {
            string query = "insert into authors (authorfname, authorlname) values('{0}', '{1}')";

            query = String.Format(query, new_author.GetAuthorfname(), new_author.GetAuthorlname());
            MySqlConnection Connect = new MySqlConnection(ConnectionString);
            MySqlCommand    cmd     = new MySqlCommand(query, Connect);

            try
            {
                Connect.Open();
                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                Debug.WriteLine("Something went wrong in the Add_Author Method!");
                Debug.WriteLine(ex.ToString());
            }

            Connect.Close();
        }