Example #1
0
        //Een nieuw genre toevoegen in database
        public static int AddGenre(Genre genre)
        {
            try
            {
                String sSQL = "INSERT INTO Genre(Name) VALUES(@Name)";

                DbParameter par1 = Database.AddParameter("@Name", genre.Name);
                if (par1.Value == null) par1.Value = DBNull.Value;

                DbParameter[] pars = new DbParameter[] { par1 };
                int affected = Database.ModifyData(sSQL, pars);

                return affected;
            }
            catch (Exception ex) { Console.WriteLine(ex.Message); return 0; }
        }
Example #2
0
        //Een bestaand genre bewerken
        public static int EditGenre(Genre genre)
        {
            try
            {
                String sSQL = "Update Genre Set Name=@Name WHERE ID=@ID";

                DbParameter par1 = Database.AddParameter("@Name", genre.Name);
                if (par1.Value == null) par1.Value = DBNull.Value;

                DbParameter par2 = Database.AddParameter("@ID", genre.Id);
                if (par2.Value == null) par2.Value = DBNull.Value;

                DbParameter[] pars = new DbParameter[] { par1, par2 };
                int affected = Database.ModifyData(sSQL, pars);

                return affected;
            }
            catch (Exception ex) { Console.WriteLine(ex.Message); return 0; }
        }