コード例 #1
0
        public ActionResult Contacts(int currentPage = 1, string orderBy = "id", string order = "asc", string searchBy = "name", string searchByValue = "")
        {
            DbConnection conn = new DbConnection();

            conn.SqlCommand.Connection.Open();

            ContactLogic contactlogic     = new ContactLogic();
            int          numberOfContacts = contactlogic.GetTotalNumberOfContacts(conn, searchBy, searchByValue);

            conn.SqlCommand.Parameters.Clear();

            searchByValue = searchByValue == "undefined" ? "" : searchByValue;
            searchBy      = searchBy == "undefined" ? "name" : searchBy;
            conn.Reader   = contactlogic.GetListOfContactsWithPagination(conn, currentPage, orderBy, order, searchBy, searchByValue);

            ContactsViewModel listOfContacts = new ContactsViewModel
            {
                Contacts = contactlogic.GenerateListOfContactsFromSqlDataReader(conn.Reader),
                NumberOfPaginationPages = contactlogic.GenerateNumberOfPaginationPagesFromTotalNumberOfContacts(currentPage, numberOfContacts),
                CurrentPage             = currentPage,
                CurrentOrder            = order,
                OrderBy = orderBy,
                TotalNumberOfContacts = numberOfContacts,
                SearchBy      = searchBy,
                SearchByValue = searchByValue
            };

            conn.SqlCommand.Connection.Close();

            return(View(listOfContacts));
        }