public List <AuthorCLS> FilterAuthor(string data) { List <AuthorCLS> listAuthor = new List <AuthorCLS>(); using (var db = new BlazorLibraryDBContext()) { if (data != null || data == "--Selected One Item--") { listAuthor = (from author in db.Authors join country in db.Countries on author.CountryId equals country.Id join gender in db.SexTypes on author.SexTypeId equals gender.Id where author.Active == 1 && author.Id == Convert.ToInt32(data) select new AuthorCLS { Id = author.Id, Fullname = author.Username, CountryName = country.CountryName, SexTypeName = gender.SexTypeName, Description = author.Description }).ToList(); } return(listAuthor); } }
public List <BookTypeCLS> Filter(string data) { List <BookTypeCLS> bookList = new List <BookTypeCLS>(); using (BlazorLibraryDBContext db = new BlazorLibraryDBContext()) { if (data == null) { bookList = (from bookType in db.BookTypes where bookType.Active == 1 select new BookTypeCLS { Id = bookType.Id, BookTypeName = bookType.BookTypeName, Description = bookType.Description }).ToList(); } else { bookList = (from bookType in db.BookTypes where bookType.Active == 1 && bookType.BookTypeName.Contains(data) select new BookTypeCLS { Id = bookType.Id, BookTypeName = bookType.BookTypeName, Description = bookType.Description }).ToList(); } } return(bookList); }
public List <CountryCLS> CountryList() { List <CountryCLS> listCountry = new List <CountryCLS>(); using (var db = new BlazorLibraryDBContext()) { listCountry = (from country in db.Countries where country.Active == 1 select new CountryCLS { Id = country.Id, CountryName = country.CountryName }).ToList(); } return(listCountry); }
public List <BookTypeCLS> Get() { List <BookTypeCLS> bookList = new List <BookTypeCLS>(); using (BlazorLibraryDBContext db = new BlazorLibraryDBContext()) { bookList = (from bookType in db.BookTypes where bookType.Active == 1 select new BookTypeCLS { Id = bookType.Id, BookTypeName = bookType.BookTypeName, Description = bookType.Description }).ToList(); } return(bookList); }
public int DeleteData(string data) { int changeRow = 0; try { using (var db = new BlazorLibraryDBContext()) { Author aut = db.Authors.Where(p => p.Id == Convert.ToInt32(data)).First(); aut.Active = 0; db.SaveChanges(); return(changeRow = 1); } } catch (Exception ex) { return(changeRow = 0); } }
public List <AuthorCLS> Index() { List <AuthorCLS> listAuthor = new List <AuthorCLS>(); using (var db = new BlazorLibraryDBContext()) { listAuthor = (from author in db.Authors join country in db.Countries on author.CountryId equals country.Id join gender in db.SexTypes on author.SexTypeId equals gender.Id where author.Active == 1 select new AuthorCLS { Id = author.Id, Fullname = author.Username, CountryName = country.CountryName, SexTypeName = gender.SexTypeName, Description = author.Description }).ToList(); } return(listAuthor); }