Пример #1
0
        // Method to update data in DB from our application
        public bool Update(Pombo p)
        {
            // Create default return type and set its value to false
            bool isSuccessful = false;

            // Connect DB
            SQLiteConnection connection = new SQLiteConnection(myConStr);

            try
            {
                // SQL to update data in our DB
                string sql = "UPDATE TablePombos SET Número=@Número, Nome=@Nome, Data=@Data, Género=@Género, NúmeroPai=@NúmeroPai, NúmeroMãe=@NúmeroMãe, Estado=@Estado, Imagem=@Imagem WHERE ID=@ID";

                // Create SQL command using SQL and connection
                SQLiteCommand cmd = new SQLiteCommand(sql, connection);
                // Create parameters to add data
                cmd.Parameters.AddWithValue("@Número", p.Number);
                cmd.Parameters.AddWithValue("@Nome", p.Name);
                cmd.Parameters.AddWithValue("@Data", p.Date);
                cmd.Parameters.AddWithValue("@Género", p.Gender);
                cmd.Parameters.AddWithValue("@NúmeroPai", p.DadNumber);
                cmd.Parameters.AddWithValue("@NúmeroMãe", p.MomNumber);
                cmd.Parameters.AddWithValue("@Estado", p.State);
                cmd.Parameters.AddWithValue("@Imagem", p.Image);
                cmd.Parameters.AddWithValue("ID", p.PomboID);

                // Connection open
                connection.Open();
                int rows = cmd.ExecuteNonQuery();
                // If the Query runs successfully then the value of rows will be greater than zero, else its value is zero
                if (rows > 0)
                {
                    // Success
                    isSuccessful = true;
                }
                else
                {
                    // Error
                    isSuccessful = false;
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString());
            }
            finally
            {
                connection.Close();
            }
            return(isSuccessful);
        }
Пример #2
0
        // Insert data into DB
        public bool Insert(Pombo p)
        {
            // Create default return type and set its value to false
            bool isSuccessful = false;

            // Connect DB
            SQLiteConnection connection = new SQLiteConnection(myConStr);

            try
            {
                // Create SQL Query to insert data
                string sql = "INSERT INTO TablePombos (Número, Nome, Data, Género, NúmeroPai, NúmeroMãe, Estado, Notas, Imagem) VALUES (@Número, @Nome, @Data, @Género, @NúmeroPai, @NúmeroMãe, @Estado, @Notas, @Imagem)";
                // Create SQL command using SQL and connection
                SQLiteCommand cmd = new SQLiteCommand(sql, connection);
                // Create parameters to add data
                cmd.Parameters.AddWithValue("@Número", p.Number);
                cmd.Parameters.AddWithValue("@Nome", p.Name);
                cmd.Parameters.AddWithValue("@Data", p.Date);
                cmd.Parameters.AddWithValue("@Género", p.Gender);
                cmd.Parameters.AddWithValue("@NúmeroPai", p.DadNumber);
                cmd.Parameters.AddWithValue("@NúmeroMãe", p.MomNumber);
                cmd.Parameters.AddWithValue("@Estado", p.State);
                cmd.Parameters.AddWithValue("@Notas", p.Notes);
                cmd.Parameters.AddWithValue("@Imagem", p.Image);

                // Connection open
                connection.Open();
                int rows = cmd.ExecuteNonQuery();
                // If the Query runs successfully then the value of rows will be greater than zero, else its value is zero
                if (rows > 0)
                {
                    // Success
                    isSuccessful = true;
                }
                else
                {
                    // Error
                    isSuccessful = false;
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString());
            }
            finally
            {
                connection.Close();
            }
            return(isSuccessful);
        }
Пример #3
0
        // Method to delete data in DB from our application
        public bool Delete(Pombo p)
        {
            // Create default return type and set its value to false
            bool isSuccessful = false;

            // Connect DB
            SQLiteConnection connection = new SQLiteConnection(myConStr);

            try
            {
                // SQL to delete data in our DB
                string sql = "DELETE FROM TablePombos WHERE ID=@ID";

                // Create SQL command using SQL and connection
                SQLiteCommand cmd = new SQLiteCommand(sql, connection);
                // Create parameters to add data
                cmd.Parameters.AddWithValue("@ID", p.PomboID);

                // Connection open
                connection.Open();
                int rows = cmd.ExecuteNonQuery();
                // If the Query runs successfully then the value of rows will be greater than zero, else its value is zero
                if (rows > 0)
                {
                    // Success
                    isSuccessful = true;
                }
                else
                {
                    // Error
                    isSuccessful = false;
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString());
            }
            finally
            {
                connection.Close();
            }
            return(isSuccessful);
        }