Beispiel #1
0
        public static int Delete(int id)
        {
            try
            {
                using (DVDCentralEntities dc = new DVDCentralEntities())
                {
                    //get the row i want to delete
                    tblDirector deleteRow = (from dt in dc.tblDirectors
                                             where dt.Id == id
                                             select dt).FirstOrDefault();

                    if (deleteRow != null)
                    {
                        dc.tblDirectors.Remove(deleteRow);
                        return(dc.SaveChanges());
                    }
                    else
                    {
                        throw new Exception("Row not found");
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Beispiel #2
0
        public static int Delete(int id)
        {
            try
            {
                using (DVDCentralEntities dc = new DVDCentralEntities())
                {
                    tblDirector deleterow = dc.tblDirectors.FirstOrDefault(dt => dt.Id == id);

                    if (deleterow != null)
                    {
                        // Remove the row
                        dc.tblDirectors.Remove(deleterow);

                        // Commit/Save the changes
                        return(dc.SaveChanges());
                    }
                    else
                    {
                        throw new Exception("Row was not found.");
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Beispiel #3
0
        public static int Insert(Director director)
        {
            try
            {
                using (DVDCentralEntities dc = new DVDCentralEntities())
                {
                    tblDirector tblDirector = new tblDirector();

                    tblDirector.FirstName = director.FirstName;
                    tblDirector.LastName  = director.LastName;

                    //example of ternary operator
                    tblDirector.Id = dc.tblDirectors.Any() ? dc.tblDirectors.Max(dt => dt.Id) + 1 : 1;

                    //Change the ID of the inserted Student
                    director.Id = tblDirector.Id;

                    dc.tblDirectors.Add(tblDirector);
                    return(dc.SaveChanges());
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Beispiel #4
0
        public static int Update(Director director)
        {
            try
            {
                using (DVDCentralEntities dc = new DVDCentralEntities())
                {
                    //get the row i want to update
                    tblDirector updateRow = (from dt in dc.tblDirectors
                                             where dt.Id == director.Id
                                             select dt).FirstOrDefault();

                    if (updateRow != null)
                    {
                        updateRow.FirstName = director.FirstName;
                        updateRow.LastName  = director.LastName;

                        return(dc.SaveChanges());
                    }
                    else
                    {
                        throw new Exception("Row not found");
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Beispiel #5
0
        public static bool Insert(Director director)
        {
            try
            {
                using (DVDCentralEntities dc = new DVDCentralEntities())
                {
                    // Make a new row
                    tblDirector newrow = new tblDirector();

                    // Set the properties
                    // Ternary Operator condition ? true : false
                    newrow.Id        = dc.tblDirectors.Any() ? dc.tblDirectors.Max(p => p.Id) + 1 : 1; // If there are any rows, get the max id and add 1, if not use 1
                    newrow.FirstName = director.FirstName;
                    newrow.LastName  = director.LastName;

                    // Do the Insert
                    dc.tblDirectors.Add(newrow);

                    // Commit the insert
                    dc.SaveChanges();

                    return(true);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Beispiel #6
0
        public static int Update(Director director)
        {
            using (DVDCentralEntities dc = new DVDCentralEntities())
            {
                try
                {
                    tblDirector updatedrow = dc.tblDirectors.Where(dt => dt.Id == director.Id).FirstOrDefault();

                    // Check to see if object exists
                    if (director != null)
                    {
                        // Update the proper fields
                        updatedrow.FirstName = director.FirstName;
                        updatedrow.LastName  = director.LastName;

                        // Save and commit changes
                        return(dc.SaveChanges());
                    }
                    else
                    {
                        // throw an exception stating the row was not found
                        throw new Exception("Row was not found.");
                    }
                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }
        }
Beispiel #7
0
        public static Director LoadById(int id)
        {
            try
            {
                using (DVDCentralEntities dc = new DVDCentralEntities())
                {
                    tblDirector row = (from dt in dc.tblDirectors
                                       where dt.Id == id
                                       select dt).FirstOrDefault();

                    if (row != null)
                    {
                        return new Director {
                                   Id = row.Id, FirstName = row.FirstName, LastName = row.LastName
                        }
                    }
                    ;
                    else
                    {
                        throw new Exception("Row was not found");
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Beispiel #8
0
        public void LoadById()
        {
            try
            {
                using (DVDEntities dc = new DVDEntities())
                {
                    //Make sure that the ID is set and valid
                    if (this.Id >= 0)
                    {
                        tblDirector director = dc.tblDirectors.FirstOrDefault(d => d.Id == this.Id);

                        //Make sure that a director was retrieved
                        if (director != null)
                        {
                            //Set the properties on this director
                            this.FirstName = director.FirstName;
                            this.LastName  = director.LastName;
                        }
                        else
                        {
                            throw new Exception("No director to load with this Id");
                        }
                    }
                    else
                    {
                        throw new Exception("Director Id not Valid");
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        //Insert the director into the db, and generate a new Id for it.
        public int Insert()
        {
            try
            {
                using (MusicEntities dc = new MusicEntities())
                {
                    //Create a new Id
                    this.Id = Guid.NewGuid();

                    //Set the properties
                    tblDirector director = new tblDirector
                    {
                        Id        = this.Id,
                        FirstName = this.FirstName,
                        LastName  = this.LastName,
                        Bio       = this.Bio,
                        BirthDate = this.BirthDate
                    };

                    //Add it to the table and save changes
                    dc.tblDirectors.Add(director);
                    return(dc.SaveChanges());
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Beispiel #10
0
        public void Delete()
        {
            using (DVDEntities dc = new DVDEntities())
            {
                tblDirector director = dc.tblDirectors.FirstOrDefault(d => d.Id == -99);
                dc.tblDirectors.Remove(director);
                int rowsEffected = dc.SaveChanges();

                Assert.IsTrue(rowsEffected == 1);
            }
        }
Beispiel #11
0
        public void Update()
        {
            using (DVDEntities dc = new DVDEntities())
            {
                tblDirector director = dc.tblDirectors.FirstOrDefault(d => d.Id == -99);
                director.LastName = "TestingUpdate";

                //Save changed property
                dc.SaveChanges();

                tblDirector updatedDirector = dc.tblDirectors.FirstOrDefault(d => d.LastName == "TestingUpdate");
                Assert.AreEqual(director.Id, updatedDirector.Id);
            }
        }
Beispiel #12
0
        public void InsertTest()
        {
            tblDirector newrow = new tblDirector();

            // Set the column values
            newrow.Id        = -99;
            newrow.FirstName = "Ronald";
            newrow.LastName  = "McDonald";

            // Insert of the row
            dc.tblDirectors.Add(newrow);

            // Commit the changes (insert a row) and then return the rows affected.
            int rowsaffected = dc.SaveChanges();

            Assert.AreNotEqual(0, rowsaffected);
        }
Beispiel #13
0
        public void InsertTest()
        {
            using (DVDCentralEntities dc = new DVDCentralEntities())
            {
                tblDirector newrow = new tblDirector();

                newrow.Id        = -99;
                newrow.FirstName = "Johnny";
                newrow.LastName  = "Johnny";


                dc.tblDirectors.Add(newrow);

                int results = dc.SaveChanges();

                Assert.IsTrue(results == 1);
            }
        }
Beispiel #14
0
        public static int Delete(int id)
        {
            try
            {
                using (DVDCentralEntities dc = new DVDCentralEntities())
                {
                    tblDirector deleterow = (from dt in dc.tblDirectors
                                             where dt.Id == id
                                             select dt).FirstOrDefault();

                    dc.tblDirectors.Remove(deleterow);
                    return(dc.SaveChanges());
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Beispiel #15
0
        public void UpdateTest()
        {
            tblDirector existingDirector = (from dt in dc.tblDirectors
                                            where dt.Id == -99
                                            select dt).FirstOrDefault();

            if (existingDirector != null)
            {
                // Update the First and Last Name
                existingDirector.FirstName = "Ronald";
                existingDirector.FirstName = "McDon";
                dc.SaveChanges();
            }

            tblDirector updatedDirector = (from dt in dc.tblDirectors
                                           where dt.Id == -99
                                           select dt).FirstOrDefault();

            Assert.AreEqual(existingDirector, updatedDirector);
        }
        //Retrieve the director from the database with this Id
        public void LoadById()
        {
            try
            {
                using (MusicEntities dc = new MusicEntities())
                {
                    //Retrieve from the db
                    tblDirector director = dc.tblDirectors.FirstOrDefault(p => p.Id == this.Id);

                    //Set this director's properties
                    this.FirstName = director.FirstName;
                    this.LastName  = director.LastName;
                    this.Bio       = director.Bio;
                    this.BirthDate = director.BirthDate;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public int Delete()
        {
            try
            {
                using (MusicEntities dc = new MusicEntities())
                {
                    //Retrieve it from the DB
                    tblDirector director = dc.tblDirectors.FirstOrDefault(p => p.Id == this.Id);

                    //Remove the director
                    dc.tblDirectors.Remove(director);

                    //Save the changes
                    return(dc.SaveChanges());
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Beispiel #18
0
        public static int Update(int id, string firstName, string lastName)
        {
            try
            {
                using (DVDCentralEntities dc = new DVDCentralEntities())
                {
                    tblDirector updaterow = (from dt in dc.tblDirectors
                                             where dt.Id == id
                                             select dt).FirstOrDefault();

                    updaterow.FirstName = firstName;
                    updaterow.LastName  = lastName;

                    return(dc.SaveChanges());
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Beispiel #19
0
        public void Insert()
        {
            using (DVDEntities dc = new DVDEntities())
            {
                //Create a director
                tblDirector director = new tblDirector {
                    Id        = -99,
                    FirstName = "TestDirector",
                    LastName  = "TestDirector"
                };

                //Insert the row
                dc.tblDirectors.Add(director);

                //Commit the changes
                int rowsInserted = dc.SaveChanges();

                //Make sure that one row was inserted
                Assert.IsTrue(rowsInserted == 1);
            }
        }
Beispiel #20
0
        public void UpdateTest()
        {
            using (DVDCentralEntities dc = new DVDCentralEntities())
            {
                //get row that I want to update
                //SELECT * gtp, tblDegreeType where id = -99
                tblDirector row = (from dt in dc.tblDirectors
                                   where dt.Id == -99
                                   select dt).FirstOrDefault();

                //change the values to something else
                if (row != null)
                {
                    row.FirstName = "Test"; row.LastName = "Tester";
                }

                //save changes
                int results = dc.SaveChanges();

                Assert.AreNotEqual(0, results);
            }
        }
Beispiel #21
0
        public int Update()
        {
            try
            {
                using (DVDEntities dc = new DVDEntities())
                {
                    //Make sure that the ID is set and valid
                    if (this.Id >= 0)
                    {
                        tblDirector director = dc.tblDirectors.FirstOrDefault(d => d.Id == this.Id);

                        //Make sure that a director was retrieved
                        if (director != null)
                        {
                            //Update the proterties on the director
                            director.FirstName = this.FirstName;
                            director.LastName  = this.LastName;

                            //return the number of rows effected
                            return(dc.SaveChanges());
                        }
                        else
                        {
                            throw new Exception("No director to load with this Id");
                        }
                    }
                    else
                    {
                        throw new Exception("Director Id not Valid");
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Beispiel #22
0
        public static Director LoadById(int id)
        {
            try
            {
                if (id != 0)
                {
                    using (DVDCentralEntities dc = new DVDCentralEntities())
                    {
                        tblDirector tbldirector = dc.tblDirectors.FirstOrDefault(p => p.Id == id);

                        if (tbldirector != null)
                        {
                            Director director = new Director
                            {
                                Id        = tbldirector.Id,
                                FirstName = tbldirector.FirstName,
                                LastName  = tbldirector.LastName
                            };

                            return(director);
                        }
                        else
                        {
                            throw new Exception("Row was not found.");
                        }
                    }
                }
                else
                {
                    throw new Exception("Please provide an id");
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Beispiel #23
0
        public int Insert()
        {
            try
            {
                using (DVDEntities dc = new DVDEntities())
                {
                    tblDirector director = new tblDirector
                    {
                        FirstName = this.FirstName,
                        LastName  = this.LastName,
                        Id        = dc.tblDirectors.Any() ? dc.tblDirectors.Max(d => d.Id) + 1 : 1
                    };
                    this.Id = director.Id;
                    dc.tblDirectors.Add(director);

                    //Return the rows effected
                    return(dc.SaveChanges());
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Beispiel #24
0
        public static int Insert(out int id, string firstName, string lastName)
        {
            try
            {
                using (DVDCentralEntities dc = new DVDCentralEntities())
                {
                    tblDirector newrow = new tblDirector();

                    newrow.FirstName = firstName;
                    newrow.LastName  = lastName;

                    newrow.Id = dc.tblDirectors.Any() ? dc.tblDirectors.Max(dt => dt.Id) + 1 : 1;

                    id = newrow.Id;

                    dc.tblDirectors.Add(newrow);
                    return(dc.SaveChanges());
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public int Update()
        {
            try
            {
                using (MusicEntities dc = new MusicEntities())
                {
                    //Retrieve the record from the DB
                    tblDirector director = dc.tblDirectors.FirstOrDefault(c => c.Id == this.Id);

                    //Update the properties
                    director.FirstName = this.FirstName;
                    director.LastName  = this.LastName;
                    director.Bio       = this.Bio;
                    director.BirthDate = this.BirthDate;

                    //Save the changes
                    return(dc.SaveChanges());
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }