public void Test_Chon_ComboBox_Nhap_Thong_Tin_Qua_Dai_3() { Search_Book test_search = new Search_Book(); string cbbox = "MaLv"; string txtbox = "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa";//31 ky tu string actual = test_search.search_1(cbbox, txtbox); string expected = "Mã lĩnh vực quá dài"; Assert.AreEqual(expected, actual); }
public void Test_Chon_ComboBox_Bo_Trong_Thong_Tin_2() { Search_Book test_search = new Search_Book(); string cbbox = "TENSACH"; string txtbox = ""; string actual = test_search.search_1(cbbox, txtbox); string expected = "select*from tblSach where TENSACH like '%%'"; Assert.AreEqual(expected, actual); }
public void Test_Bo_Trong_ComboBox_Bo_Trong_Thong_Tin() { Search_Book test_search = new Search_Book(); string cbbox = ""; string txtbox = ""; string actual = test_search.search_1(cbbox, txtbox); string expected = "select * from tblSach"; Assert.AreEqual(expected, actual); }
public void Test_Nhap_Dung_Thong_Tin_Tim_Kiem_3() { Search_Book test_search = new Search_Book(); string cbbox = "MANXB"; string txtbox = "NXB01"; string actual = test_search.search_1(cbbox, txtbox); string expected = "select*from tblSach where MANXB like '%" + txtbox + "%'"; Assert.AreEqual(expected, actual); }
public void Test_Nhap_Dung_Thong_Tin_Tim_Kiem() { Search_Book test_search = new Search_Book(); string cbbox = "MASACH"; string txtbox = "S02"; string actual = test_search.search_1(cbbox, txtbox); string expected = "select*from tblSach where " + cbbox + " like " + "'%" + txtbox + "%'"; Assert.AreEqual(expected, actual); }
public async Task <IActionResult> Index(string sortOrder, string searchNameString, string searchAuthorString, int page = 1, int pageSize = 10) { ViewData["CurrentSort"] = sortOrder; ViewData["NameParm"] = searchNameString; ViewData["AuthorParm"] = searchAuthorString; var search = new Search_Book() { Author = searchAuthorString, SortType = sortOrder, Name = searchNameString, PageIndex = page, PageSize = pageSize }; return(View(await _booksService.SearchAsync(search))); }
public void Test_Nhap_sai_dinh_dang_ngay() { Search_Book test_search = new Search_Book(); string cbbox = "NGAYNHAP"; string txtbox = "30/02/2019";//31 ky tu CheckDate date = new CheckDate(); string actual1 = date.Check_Date(txtbox); string expected1 = "Ngày không hợp lệ"; Assert.AreEqual(expected1, actual1); string actual2 = test_search.search_1(cbbox, txtbox); string expected2 = "select * from tblSach"; Assert.AreEqual(expected2, actual2); }//1919 2119
public void Test_Nhap_sai_dinh_dang_nam() { Search_Book test_search = new Search_Book(); string cbbox = "NAMXB"; string txtbox = "aaaa";//31 ky tu CheckDate date = new CheckDate(); string actual1 = date.Check_Year(txtbox); string expected1 = "Năm không hợp lệ"; Assert.AreEqual(expected1, actual1); string actual2 = test_search.search_1(cbbox, txtbox); string expected2 = "select * from tblSach"; Assert.AreEqual(expected2, actual2); }//1919 2119
public async Task <ServiceResult <PaginatedList <Book> > > SearchAsync(Search_Book search) { try { var books = from b in _db.Books select b; if (search.Type.HasValue) { books = books.Where(x => x.Type == search.Type.Value); } if (search.Name.IsNotNull()) { books = books.Where(x => x.Name.Contains(search.Name)); } if (search.Author.IsNotNull()) { books = books.Where(x => x.Author.Contains(search.Author)); } if (search.BeganCreateDT.HasValue) { books = books.Where(x => x.CreateDT >= search.BeganCreateDT.Value); } if (search.EndCreateDT.HasValue) { books = books.Where(x => x.CreateDT < search.EndCreateDT.Value); } switch (search.SortType) { case "createdt_desc": books = books.OrderByDescending(x => x.CreateDT); break; case "createdt": books = books.OrderBy(x => x.CreateDT); break; case "name_desc": books = books.OrderByDescending(x => x.Name); break; case "name": books = books.OrderBy(x => x.Name); break; case "author_desc": books = books.OrderByDescending(s => s.Author); break; case "author": books = books.OrderBy(s => s.Author); break; default: books = books.OrderByDescending(s => s.Id); break; } var result = await PaginatedList <Book> .CreateAsync(books.AsNoTracking(), search.PageIndex, search.PageSize); return(ServiceResult <PaginatedList <Book> > .Success(result)); } catch (Exception ex) { return(ServiceResult <PaginatedList <Book> > .Error(ex)); } }