private Book get_book() { Book BooksApp = new Book { books = new List <booksAppModel>() }; BookAppDataDataContext db = new BookAppDataDataContext(); var q = db.BookAppDatebases.AsQueryable(); var buffer = (from i in q select new { i.BookName, i.Writer, i.PagesCount, i.Categories, i.id, }).ToList(); BooksApp.books = (from i in buffer select new booksAppModel { BookName = i.BookName, WriterName = i.Writer, PagesCount = Convert.ToInt32(i.PagesCount), Categories = (i.Categories), id = i.id, }).ToList(); return(BooksApp); }
protected void OnDelete(object sender, EventArgs e) { //Find the reference of the Repeater Item. RepeaterItem Item = (sender as LinkButton).Parent as RepeaterItem; int id_book = int.Parse((Item.FindControl("id") as TextBox).Text); BookAppDataDataContext db = new BookAppDataDataContext(); var DeleteBook = db.BookAppDatebases.First(c => c.id == id_book); db.BookAppDatebases.DeleteOnSubmit(DeleteBook); db.SubmitChanges(); get_books = get_book(); repeaterYukle(get_books); }
protected void OnUpdate(object sender, EventArgs e) { RepeaterItem Item = (sender as LinkButton).Parent as RepeaterItem; int id_book = int.Parse((Item.FindControl("id") as TextBox).Text); string bookName = ((Item.FindControl("txtbookName") as TextBox).Text); string Writer = (Item.FindControl("txtWriter") as TextBox).Text; string PageCount = (Item.FindControl("txtPageCount") as TextBox).Text; string Categori = (Item.FindControl("txtCategories") as TextBox).Text; BookAppDataDataContext db = new BookAppDataDataContext(); var get_book = db.BookAppDatebases.Single(c => c.id == id_book); get_book.BookName = bookName; get_book.Writer = Writer; get_book.PagesCount = Convert.ToInt32(PageCount); get_book.Categories = Categori; db.SubmitChanges(); }
protected void Save_Book(object sender, EventArgs e) { BookAppDataDataContext db = new BookAppDataDataContext(); try { BookAppDatebase Book = new BookAppDatebase { BookName = (txtBookName.Text), Writer = (txtWriter.Text), PagesCount = Convert.ToInt32(txtPageCount.Text), Categories = txtCategori.Text }; db.BookAppDatebases.InsertOnSubmit(Book); db.SubmitChanges(); } catch (Exception ex) { } }