Example #1
0
        public void RemoveBook(IFullBooks books)
        {
            string storedProcedure = StoredProcedures.RemoveItem.ToString();
            var    obj             = new
            {
                ItemsID = books.ItemsID
            };

            using (var conn = Create_Connection())
            {
                conn.Execute(storedProcedure, obj, commandType: CommandType.StoredProcedure);
            }
        }
Example #2
0
        public void EditBook(IFullBooks books)
        {
            string storedProcedure = StoredProcedures.EditBook.ToString();
            var    obj             = new
            {
                Title       = books.Title,
                ISBN        = books.ISBN,
                Author      = books.Author,
                Publisher   = books.Publisher,
                Category    = books.Category,
                Pages       = books.Pages,
                Price       = books.Price,
                Description = books.Description,
                Date        = books.Date,
                ID          = books.ItemsID
            };

            using (var conn = Create_Connection())
            {
                conn.Execute(storedProcedure, obj, commandType: CommandType.StoredProcedure);
            }
        }
Example #3
0
 public void RemoveBookProcess(IFullBooks books)
 {
     _repo.RemoveBook(books);
 }
Example #4
0
 public void EditBookProcess(IFullBooks books)
 {
     _repo.EditBook(books);
 }
Example #5
0
 public void CreateBookProcess(IFullBooks books)
 {
     _repo.CreateBook(books);
 }
Example #6
0
 public void RemoveBook(IFullBooks books)
 {
     return;
 }
Example #7
0
 public void EditBook(IFullBooks books)
 {
     return;
 }
Example #8
0
 public void CreateBook(IFullBooks books)
 {
     return;
 }