Click here to Skip to main content
15,867,756 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: How to fix error "the type or namespace name 'CustomerBAL' could not be found (are you missing a using directive or an assembly reference) Pin
Member 1357490013-Dec-17 22:56
Member 1357490013-Dec-17 22:56 
QuestionHow to incorporate pagination feature into my repository Pin
Mou_kol13-Dec-17 3:31
Mou_kol13-Dec-17 3:31 
see the sample code

This is books model
-----------------------
C#
public class Book
    {
        [Key]
        public int Id { get; set; }
        [Required]
        [MaxLength(30)]
        public string Title { get; set; }
        public string Authers { get; set; }
 
        [Column("Year")]
        [Display(Name = "Publish Year")]
        public string publishYear { get; set; }
 
        [Column("Price")]
        [Display(Name = "Price")]
        public decimal BasePrice { get; set; }
    }


Repository interface
--------------------
C#
public interface IBookRepository : IDisposable
        {
            IEnumerable<Book> GetBooks();
            Book GetBookByID(int bookId);
            void InsertBook(Book book);
            void DeleteBook(int bookID);
            void UpdateBook(Book book);
            void Save();
    }



Book repository
--------------------

C#
public class BookRepository : IBookRepository
    {
        private BookContext _context;
 
        public BookRepository(BookContext bookContext)
        {
            this._context = bookContext;
        }
 
        public IEnumerable<book> GetBooks()
        {
            return _context.Books.ToList();
        }
 
        public Book GetBookByID(int id)
        {
            return _context.Books.Find(id);
        }
 
        public void InsertBook(Book book)
        {
            _context.Books.Add(book);
        }
 
        public void DeleteBook(int bookID)
        {
            Book book = _context.Books.Find(bookID);
            _context.Books.Remove(book);
        }
 
        public void UpdateBook(Book book)
        {
            _context.Entry(book).State = EntityState.Modified;
        }
 
        public void Save()
        {
            _context.SaveChanges();
        }
 
        private bool disposed = false;
 
        protected virtual void Dispose(bool disposing)
        {
            if (!this.disposed)
            {
                if (disposing)
                {
                    _context.Dispose();
                }
            }
            this.disposed = true;
        }
 
        public void Dispose()
        {
            Dispose(true);
            GC.SuppressFinalize(this);
        }
    }

code taken from https://www.codeproject.com/Articles/644605/CRUD-Operations-Using-the-Repository-Pattern-in-MV

now tell me when i will fetch books then how could i do the pagination...say want to retrieve 20 books or

i like to mention author name and 20 records when fetching book.

please help me with sample code. thanks
AnswerRe: How to incorporate pagination feature into my repository Pin
Richard Deeming13-Dec-17 7:17
mveRichard Deeming13-Dec-17 7:17 
GeneralRe: How to incorporate pagination feature into my repository Pin
Mou_kol14-Dec-17 20:33
Mou_kol14-Dec-17 20:33 
GeneralRe: How to incorporate pagination feature into my repository Pin
F-ES Sitecore14-Dec-17 22:56
professionalF-ES Sitecore14-Dec-17 22:56 
GeneralRe: How to incorporate pagination feature into my repository Pin
Richard Deeming18-Dec-17 1:47
mveRichard Deeming18-Dec-17 1:47 
GeneralRe: How to incorporate pagination feature into my repository Pin
Mou_kol18-Dec-17 20:49
Mou_kol18-Dec-17 20:49 
GeneralRe: How to incorporate pagination feature into my repository Pin
Richard Deeming19-Dec-17 1:59
mveRichard Deeming19-Dec-17 1:59 
QuestionAm I approaching this problem the wrong way? Pin
samflex11-Dec-17 5:25
samflex11-Dec-17 5:25 
AnswerRe: Am I approaching this problem the wrong way? Pin
jkirkerx13-Dec-17 9:53
professionaljkirkerx13-Dec-17 9:53 
QuestionHow to setup and use VSTS for five user Pin
Mou_kol7-Dec-17 23:19
Mou_kol7-Dec-17 23:19 
AnswerRe: How to setup and use VSTS for five user Pin
Richard MacCutchan8-Dec-17 0:05
mveRichard MacCutchan8-Dec-17 0:05 
QuestionVisual Studio Update 15.5.0 - MVC View editor comes up with just black text Pin
jkirkerx7-Dec-17 13:38
professionaljkirkerx7-Dec-17 13:38 
AnswerRe: Visual Studio Update 15.5.0 - MVC View editor comes up with just black text Pin
Richard Deeming8-Dec-17 1:28
mveRichard Deeming8-Dec-17 1:28 
GeneralRe: Visual Studio Update 15.5.0 - MVC View editor comes up with just black text Pin
jkirkerx8-Dec-17 6:20
professionaljkirkerx8-Dec-17 6:20 
AnswerRe: Visual Studio Update 15.5.0 - MVC View editor comes up with just black text Pin
jkirkerx10-Dec-17 10:33
professionaljkirkerx10-Dec-17 10:33 
QuestionConsuming a homemade rest service in asp.net webform Pin
wilcodk7-Dec-17 2:47
wilcodk7-Dec-17 2:47 
AnswerRe: Consuming a homemade rest service in asp.net webform Pin
Richard Deeming7-Dec-17 8:54
mveRichard Deeming7-Dec-17 8:54 
GeneralRe: Consuming a homemade rest service in asp.net webform Pin
wilcodk7-Dec-17 22:20
wilcodk7-Dec-17 22:20 
QuestionPopulating pdf on the server Pin
Michael Clinton6-Dec-17 7:49
Michael Clinton6-Dec-17 7:49 
AnswerRe: Populating pdf on the server Pin
Richard Deeming6-Dec-17 9:43
mveRichard Deeming6-Dec-17 9:43 
QuestionHow to disable gridview by checkbox? Pin
samflex4-Dec-17 7:56
samflex4-Dec-17 7:56 
AnswerRe: How to disable gridview by checkbox? Pin
jkirkerx4-Dec-17 8:02
professionaljkirkerx4-Dec-17 8:02 
GeneralRe: How to disable gridview by checkbox? Pin
samflex4-Dec-17 8:48
samflex4-Dec-17 8:48 
GeneralRe: How to disable gridview by checkbox? Pin
jkirkerx4-Dec-17 10:11
professionaljkirkerx4-Dec-17 10:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.