Esempio n. 1
0
        /// <summary>
        ///  Connects to the database and returns the Author by its ID.
        /// </summary>
        /// <param name="authorID"></param>
        /// We get  Author`s ID and we use it to find the right element(Author) to return.
        /// <returns></returns>
        ///

        public AuthorDTO GetAuthorByID(int authorID)
        {
            //var getAuthorById = AuthorContext.spGetAuthorByID(authorID).FirstOrDefault();
            //var authorDto = Mapper.Map<AuthorDTOTEST>(getAuthorById);
            //AuthorDTOTEST returnedDto = AutoMapper.Mapper.Map<AuthorDTOTEST>(getAuthorById);

            var       returnauthor = AuthorContext.author_table.Find(authorID);
            AuthorDTO objDTO       = new AuthorDTO();

            objDTO.author_age     = returnauthor.author_age;
            objDTO.author_country = returnauthor.author_country;
            objDTO.author_name    = returnauthor.author_name;

            return(objDTO);
        }
Esempio n. 2
0
 /// <summary>
 /// Connects to the database, updating the right entry using an the entrie`s ID(which is a param)
 /// with new info given as a param of the same type
 /// </summary>
 /// <param name="updateAuthor"></param>
 /// <param name="authorID"></param>
 public void UpdateAuthor(AuthorDTO updateAuthor, int authorID)
 {
     AuthorContext.spUpdateAuthor(updateAuthor.author_name, updateAuthor.author_country, updateAuthor.author_age, authorID);
 }
Esempio n. 3
0
 /// <summary>
 /// Connects to the database and adds a new element in it(the database), by getting the new element as a parameter.
 /// </summary>
 /// <param name="newAuthor"></param>
 public void AddNewAuthor(AuthorDTO newAuthor)
 {
     AuthorContext.spAddNewAuthor(newAuthor.author_name, newAuthor.author_age, newAuthor.author_country);
 }