public ActionResult UpdateBook(Models.Book book) { Models.BookService library = new Models.BookService(); ViewBag.bookClassData = this.codeService.GetBookClassDropdownlist(); ViewBag.borrowerData = this.codeService.GetBorrowerDropdownlist(); ViewBag.statusData = this.codeService.GetBookStatusDropdownlist(); if (library.UpdateBook(book) == 1 && (book.book_Status == "B" || book.book_Status == "C")) { //成功更新一筆資料且為借出狀態,則新增一筆借閱紀錄 if (library.InsertBookIntoLendRecord(book) == 1) { ModelState.Clear(); } else { TempData["updateSuccessfully"] = "系統出現問題"; } } else if (library.UpdateBook(book) == 1) { //更新書籍內容,並未更新借閱狀態 ModelState.Clear(); } else { //更新一筆資料失敗 TempData["updateSuccessfully"] = "系統出現問題"; } return(View(book)); }
public int EditBook(Models.Book book) { string sql = @"UPDATE BOOK_DATA SET BOOK_NAME = @BookName, BOOK_AUTHOR = @BookAuthor, BOOK_PUBLISHER = @BookPublisher, BOOK_NOTE = @BookNote, BOOK_BOUGHT_DATE = @BookBuyDate, BOOK_CLASS_ID = @BookClassID, BOOK_KEEPER = @KeeperID, BOOK_STATUS = @BookStatusID WHERE BOOK_ID = @BookID;"; int EmployeeId; using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString())) { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add(new SqlParameter("@BookName", book.BookName)); cmd.Parameters.Add(new SqlParameter("@BookAuthor", book.BookAuthor)); cmd.Parameters.Add(new SqlParameter("@BookPublisher", book.BookPublisher)); cmd.Parameters.Add(new SqlParameter("@BookNote", book.BookNote)); cmd.Parameters.Add(new SqlParameter("@BookBuyDate", book.BuyDate)); cmd.Parameters.Add(new SqlParameter("@BookClassID", book.BookClassID)); cmd.Parameters.Add(new SqlParameter("@KeeperID", book.KeeperID)); cmd.Parameters.Add(new SqlParameter("@BookStatusID", book.BookStatusID)); EmployeeId = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); } return(EmployeeId); }
public void deleteBook(int nId) { List <Models.Book> books = getBooks(); Models.Book toRem = null; for (var enu = books.GetEnumerator(); enu.MoveNext();) { if (enu.Current.Id == nId) { toRem = enu.Current; } } if (toRem != null) { books.Remove(toRem); } List <String> jsons = new List <string>(); for (var enu = books.GetEnumerator(); enu.MoveNext();) { jsons.Add(Newtonsoft.Json.JsonConvert.SerializeObject(enu.Current)); } String[] lines = jsons.ToArray <string>(); System.IO.File.WriteAllLines(strBooksBase, lines, Encoding.Unicode); }
public void SeedData() { Book book1 = new Models.Book { Title = "Wolf Road", DateAdded = DateTime.Now, Price = 20, Key = "Wolf Road" }; //var fiction = Categories.Add(new Category { Name = "Fiction" }).Entity; //Error: Unable to create or track an entity of type 'Category' because it has a null primary or alternate key value. var fiction = Categories.Add(new Category { Name = "Fiction", Key = "Fiction" }).Entity; Category cat2 = new Category { Name = "Children", Key = "Children" }; Category cat3 = new Category { Name = "Cooking", Key = "Cooking" }; Categories.AddRange(cat2, cat3); book1.Category = fiction; var author1 = Authors.Add(new Models.Author { Name = "Beth Lewis", Key = "Beth Lewis" }).Entity; Authors.Add(new Models.Author { Name = "Unknown", Key = "Unknown" }); book1.Author = author1; Books.Add(book1); SaveChanges(); }
public async Task PostBook_Valid_Returns201CreatedAsync() { var filters = new Models.BookOptionFilter { BookId = 1, }; var saveBook = new SaveBook() { Name = "x", Description = "x", }; var book = new Models.Book() { BookId = 1 }; this.BookRepositoryMock .Setup(x => x.AddAsync(It.IsAny <Models.Book>(), It.IsAny <CancellationToken>())) .ReturnsAsync(book); var response = await this.client.PostAsJsonAsync("book", saveBook).ConfigureAwait(false); Assert.Equal(HttpStatusCode.Created, response.StatusCode); Assert.Equal(ContentType.RestfulJson, response.Content.Headers.ContentType?.MediaType); var bookViewModel = await response.Content.ReadAsAsync <Book>(this.formatters).ConfigureAwait(false); var uriString = AddQueryString("/book", filters); Assert.Equal(new Uri($"http://localhost{uriString}"), response.Headers.Location); }
//得到sql中的数据 public void GetItems() { using (var statement = sqlConn.Prepare(@"SELECT * FROM Item")) { while (SQLiteResult.ROW == statement.Step()) { //一条记录的类型为空,则代表是一个新的账本的记录而不是一条账目的记录 if ((string)statement[5] == "") { Models.Book tempBook = new Models.Book((string)statement[1], (double)statement[6], (string)statement[0]); allBooks.Add(tempBook); } else { foreach (Models.Book book in allBooks) { //寻找相同账本id的账本,并加入该账本 if (book.id == (string)statement[0]) { book.AddAccount(DateTime.Parse((string)statement[3]), (Int64)statement[4] == 1, (string)statement[5], (double)statement[6], (string)statement[7], (string)statement[2]); } } } } } }
//删除账本 public void DeleteBook() { //数据库删除选中账本 DeleteItem(selectedBook); allBooks.Remove(selectedBook); selectedBook = null; }
//[ValidateAntiForgeryToken] public IActionResult AddOrEdit(Models.Book book) { try { // TODO: Add insert logic here if (ModelState.IsValid) { if (_bookRepo.AddOrEdit(book)) { return(Json(new { success = true, message = "Saved Successfull" })); } else { return(Json(new { success = false, message = "Saved Failed" })); } } return(Json(new { success = false, message = "Model state is invalid!" })); } catch (Exception) { //return Json(new { success = false, message = e.Message }); throw; } }
public IActionResult Result([Bind("Name")] Models.Book book) { if (book.Name == null) { ModelState.AddModelError(string.Empty, "您的输入信息过少!"); Add_Cookie("History", book.Name); ViewData["History"] = book.Name; IEnumerable <Manage.Models.Book> EmptyList = null; return(View("Result", EmptyList)); } if (book.Name.Count() < 2) { ModelState.AddModelError(string.Empty, "您的输入信息过少!"); Add_Cookie("History", book.Name); ViewData["History"] = book.Name; IEnumerable <Manage.Models.Book> EmptyList = null; return(View("Result", EmptyList)); } var searchBooks = Search_method(book); //添加Cookie Add_Cookie("History", book.Name); ViewData["History"] = book.Name; //Add_SearchLog(searchBooks); return(View(searchBooks)); }
public async Task <IActionResult> OnPostDelAsync(int purchase) { Models.Book book = _context.Book.Find(_context.Purchase.Find(purchase).BookId); if (_context.Purchase.Find(purchase).PurStatus == 1) { _context.Purchase.Remove(_context.Purchase.Find(purchase)); _context.SaveChanges(); Console.WriteLine("已完成,不修改数据库" + book.Quantity); } else if (_context.Purchase.Find(purchase).PurStatus == 0) { Console.WriteLine("修改前" + book.Quantity); book.Quantity += _context.Purchase.Find(purchase).PurQuan; _context.Book.Update(book); _context.Purchase.Remove(_context.Purchase.Find(purchase)); _context.SaveChanges(); Console.WriteLine("修改后" + book.Quantity); } return(RedirectToPage()); }
public IActionResult Index() { IList <Models.Book> bookList = new List <Models.Book>(); //ViewBag.Output = "Everythignb's connected"; //load poeple.xml string path = Request.PathBase + "App_Data/books.xml"; XmlDocument doc = new XmlDocument(); if (System.IO.File.Exists(path)) { doc.Load(path); XmlNodeList books = doc.GetElementsByTagName("book"); foreach (XmlElement b in books) { Models.Book book = new Models.Book(); book.Id = b.GetElementsByTagName("id")[0].InnerText; //Attempt at ID string oz = book.Id; int theId = int.Parse(oz); book.Id = theId; book.Title = b.GetElementsByTagName("title")[0].InnerText; book.FirstName = b.GetElementsByTagName("firstname")[0].InnerText; book.MiddleName = b.GetElementsByTagName("middlename")[0].InnerText; book.LastName = b.GetElementsByTagName("lastname")[0].InnerText; bookList.Add(book); } } return(View(bookList)); }
// Insert Book public bool InsertBook(Models.Book arg) { DataTable dt = new DataTable(); string sql = @"INSERT INTO BOOK_DATA (BOOK_NAME, BOOK_AUTHOR, BOOK_PUBLISHER, BOOK_NOTE, BOOK_BOUGHT_DATE, BOOK_CLASS_ID, BOOK_STATUS, CREATE_DATE, MODIFY_DATE) VALUES (@BookName, @Author, @Publisher, @Introduction, CONVERT(DATETIME, @BuyDate), @BookClassId, 'A', CONVERT(DATETIME, @CreateDate), CONVERT(DATETIME, @ModDate))" ; using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString())) { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add(new SqlParameter("@BookName", arg.BookName == null ? string.Empty : arg.BookName)); cmd.Parameters.Add(new SqlParameter("@Author", arg.Author == null ? string.Empty : arg.Author)); cmd.Parameters.Add(new SqlParameter("@Publisher", arg.Publisher == null ? string.Empty : arg.Publisher)); cmd.Parameters.Add(new SqlParameter("@Introduction", arg.Introduction == null ? string.Empty : arg.Introduction)); cmd.Parameters.Add(new SqlParameter("@BuyDate", arg.BuyDate == null ? string.Empty : arg.BuyDate)); cmd.Parameters.Add(new SqlParameter("@BookClassId", arg.BookClassId == null ? string.Empty : arg.BookClassId)); cmd.Parameters.Add(new SqlParameter("@CreateDate", arg.CreateDate == null ? string.Empty : arg.CreateDate)); cmd.Parameters.Add(new SqlParameter("@ModDate", arg.ModDate == null ? string.Empty : arg.ModDate)); SqlDataAdapter sqlAdapter = new SqlDataAdapter(cmd); sqlAdapter.Fill(dt); conn.Close(); } return(true); }
public async Task <IActionResult> PutBook(int id, Models.Book book) { if (id == null) { return(StatusCode(StatusCodes.Status500InternalServerError, "Could not found the ID: " + id)); } if (id != book.BookId) { return(StatusCode(StatusCodes.Status500InternalServerError, "Could not found the ID: " + id)); } try { await _bookService.PutBook(id, book); return(StatusCode(StatusCodes.Status200OK, "Book succesfully updated! ")); } catch (DbUpdateConcurrencyException) { Models.Book bookModel = await _bookService.GetBook(id); if (bookModel == null) { return(NotFound()); } else { throw; } } }
private void booksListbox_SelectedIndexChanged(object sender, EventArgs e) { Models.Book book = booksListbox.SelectedItem as Models.Book; Models.DatabaseContext databaseContext = null; try { databaseContext = new Models.DatabaseContext(); Models.Book selectedBook = databaseContext.Books .Where(current => current.Id == book.Id) .FirstOrDefault(); byte[] ImageArray = (byte[])selectedBook.ImageByteArray; if (ImageArray.Length == 0) { bookPictureBox.Image = defaultImage; } else { bookPictureBox.Image = Image.FromStream(new System.IO.MemoryStream(ImageArray)); } } catch (Exception) { throw; } }
public ActionResult EditBook(int?id) { Book toEdit; if (id != null) { toEdit = db.tabBook.Find(id); if (toEdit == null) { return(new HttpNotFoundResult()); } } else { toEdit = new Models.Book(); toEdit.YearOfPublish = DateTime.Now; } List <SelectListItem> listaZPoz0 = new List <SelectListItem>(); listaZPoz0.Add(new SelectListItem { Text = "wybierz autora", Value = "" }); List <SelectListItem> listaAutorow = (from item in db.tabAuthor orderby item.LastName select new SelectListItem { Value = item.Id.ToString(), Text = item.LastName + " " + item.FirstName }).ToList(); listaZPoz0.AddRange(listaAutorow); ViewBag.Autorzy = listaZPoz0; return(View(toEdit)); }
public void UpdateBookData(Models.Book arg) { DataTable dt = new DataTable(); string sql = @"UPDATE BOOK_DATA SET BOOK_NAME = @BookName, BOOK_AUTHOR = @Author, BOOK_PUBLISHER = @Publisher, BOOK_NOTE = @Introduction, BOOK_BOUGHT_DATE = CONVERT(DATETIME, @BuyDate), BOOK_CLASS_ID = @BookClassId, BOOK_STATUS = @BookStatusId, BOOK_KEEPER = @KeeperId WHERE BOOK_ID = @BookId"; using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString())) { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); SqlDataAdapter sqlAdapter = new SqlDataAdapter(cmd); cmd.Parameters.Add(new SqlParameter("@BookName", arg.BookName == null ? "" : arg.BookName.ToString())); cmd.Parameters.Add(new SqlParameter("@Author", arg.Author == null ? "" : arg.Author.ToString())); cmd.Parameters.Add(new SqlParameter("@Publisher", arg.Publisher == null ? "" : arg.Publisher.ToString())); cmd.Parameters.Add(new SqlParameter("@Introduction", arg.Introduction == null ? "" : arg.Introduction.ToString())); cmd.Parameters.Add(new SqlParameter("@BuyDate", arg.BuyDate == null ? "" : arg.BuyDate.ToString())); cmd.Parameters.Add(new SqlParameter("@BookClassId", arg.BookClassId == null ? "" : arg.BookClassId.ToString())); cmd.Parameters.Add(new SqlParameter("@BookStatusId", arg.BookStatusId == null ? "" : arg.BookStatusId.ToString())); cmd.Parameters.Add(new SqlParameter("@KeeperId", arg.KeeperId == null ? "" : arg.KeeperId.ToString())); cmd.Parameters.Add(new SqlParameter("@BookId", arg.BookId)); sqlAdapter.Fill(dt); conn.Close(); } }
public IActionResult Create(Models.Book b) { string path = Request.PathBase + "App_data/books.xml"; XmlDocument doc = new XmlDocument(); if (System.IO.File.Exists(path)) { doc.Load(path); XmlElement book = _CreateBookElement(doc, b); doc.DocumentElement.AppendChild(book); } else { //doesn't exist so add stuff XmlNode dec = doc.CreateXmlDeclaration("1.0", "utf-8", ""); doc.AppendChild(dec); XmlNode root = doc.CreateElement("books"); XmlElement book = _CreateBookElement(doc, b); root.AppendChild(book); doc.AppendChild(root); } doc.Save(path); return(View()); }
public IActionResult Index() { IList <Models.Book> bookList = new List <Models.Book>(); //load book.xml string path = Request.PathBase + "App_Data/books.xml"; XmlDocument doc = new XmlDocument(); if (System.IO.File.Exists(path)) { doc.Load(path); XmlNodeList books = doc.GetElementsByTagName("book"); foreach (XmlElement b in books) { Models.Book book = new Models.Book(); book.FirstName = b.GetElementsByTagName("firstname")[0].InnerText; book.LastName = b.GetElementsByTagName("lastname")[0].InnerText; //book.MiddleName = b.GetElementsByTagName("middlename")[0].InnerText; book.Id = b.GetElementsByTagName("id")[0].InnerText; book.Title = b.GetElementsByTagName("title")[0].InnerText; bookList.Add(book); } } return(View(bookList)); }
//添加一个账本 public void AddBook(string name, double budget) { Models.Book toAdd = new Models.Book(name, budget); allBooks.Add(toAdd); //数据库插入一个账本 InsertItem(toAdd); }
public IActionResult Create(Models.Book b) { //load book.xml string path = Request.PathBase + "App_Data/books.xml"; XmlDocument doc = new XmlDocument(); if (System.IO.File.Exists(path)) { //if file exist, just load it and create new person doc.Load(path); //create a new person XmlElement book = _CreateBookElement(doc, b); //get the root element doc.DocumentElement.AppendChild(book); } else { //if file does not exist, create and create new person XmlNode dec = doc.CreateXmlDeclaration("1.0", "utf-8", ""); doc.AppendChild(dec); XmlNode root = doc.CreateElement("books"); //create a new person XmlElement book = _CreateBookElement(doc, b); root.AppendChild(book); doc.AppendChild(root); } doc.Save(path); return(View()); }
public Book(Models.Book x) { Id = x.Id; Title = x.Title; AuthorFullName = x.Author?.FullName ?? ""; AuthorId = x.AuthorId; }
private XmlElement _CreateBookElement(XmlDocument doc, Models.Book newBook) { XmlElement book = doc.CreateElement("book"); XmlNode id = doc.CreateElement("id"); XmlNode title = doc.CreateElement("title"); id.InnerText = newBook.Id; title.InnerText = newBook.Title; XmlNode author = doc.CreateElement("author"); XmlNode first = doc.CreateElement("firstname"); XmlNode last = doc.CreateElement("lastname"); first.InnerText = newBook.FirstName; last.InnerText = newBook.LastName; author.AppendChild(first); author.AppendChild(last); book.AppendChild(id); book.AppendChild(title); book.AppendChild(author); return(book); }
public IActionResult Index() { IList <Models.Book> bookList = new List <Models.Book>(); //load books.xml string path = Request.PathBase + "App_Data/books.xml"; XmlDocument doc = new XmlDocument(); if (System.IO.File.Exists(path)) { doc.Load(path); XmlNodeList books = doc.GetElementsByTagName("book"); foreach (XmlElement b in books) { Models.Book book = new Models.Book(); book.ID = Int32.Parse(b.GetElementsByTagName("id")[0].InnerText); book.Title = b.GetElementsByTagName("title")[0].InnerText; book.AuthorTitle = b.GetElementsByTagName("author")[0].Attributes["title"].Value; book.FirstName = b.GetElementsByTagName("firstname")[0].InnerText; if (b.GetElementsByTagName("middlename").Count > 0) { book.MiddleName = b.GetElementsByTagName("middlename")[0].InnerText; } else { book.MiddleName = ""; } book.LastName = b.GetElementsByTagName("lastname")[0].InnerText; bookList.Add(book); } } return(View(bookList)); }
public async Task <IActionResult> SelectGreetings([FromForm] SelectGreetings selectGreetings) { var userId = _userManager.GetUserId(User); var greetings = await _applicationDbContext.Greetings .Where(g => selectGreetings.Greetings.Any(sg => sg == g.Id)) .ToListAsync(); var newBook = new Models.Book { UserId = userId, EventId = selectGreetings.EventId, Greetings = greetings }; _applicationDbContext.Books.Add(newBook); await _applicationDbContext.SaveChangesAsync(); return(View("Create", new BookDetails { BookId = newBook.Id, EventId = selectGreetings.EventId, Greetings = greetings.Select(g => new Greeting { Id = g.Id, File = g.File, Signature = g.Signature, Text = g.Text }).ToList() })); }
public int AddBook(Models.Book book) { string sql = @"INSERT INTO BOOK_DATA ( BOOK_NAME, BOOK_AUTHOR, BOOK_PUBLISHER, BOOK_NOTE, BOOK_BOUGHT_DATE, BOOK_CLASS_ID, BOOK_STATUS ) VALUES ( @BOOK_NAME, @BOOK_AUTHOR, @BOOK_PUBLISHER, @BOOK_NOTE, @BOOK_BOUGHT_DATE, @BOOK_CLASS_ID, 'A' ) SELECT SCOPE_IDENTITY();" ; int BookID; using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString())) { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add(new SqlParameter("@BOOK_NAME", book.BookName)); cmd.Parameters.Add(new SqlParameter("@BOOK_AUTHOR", book.BookAuthor)); cmd.Parameters.Add(new SqlParameter("@BOOK_PUBLISHER", book.BookPublisher)); cmd.Parameters.Add(new SqlParameter("@BOOK_NOTE", book.BookNote)); cmd.Parameters.Add(new SqlParameter("@BOOK_BOUGHT_DATE", book.BuyDate)); cmd.Parameters.Add(new SqlParameter("@BOOK_CLASS_ID", book.BookClassID)); BookID = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); } return(BookID); }
private XmlElement CreateBookElement(XmlDocument doc, Models.Book newBook) { XmlElement book = doc.CreateElement("book"); XmlNode Title = doc.CreateElement("title"); Title.InnerText = newBook.Title; XmlNode Authorname = doc.CreateElement("author"); XmlNode Firstname = doc.CreateElement("firstname"); Firstname.InnerText = newBook.Firstname; XmlNode Lastname = doc.CreateElement("lastname"); Lastname.InnerText = newBook.Lastname; Authorname.AppendChild(Firstname); Authorname.AppendChild(Lastname); book.AppendChild(Authorname); return(book); }
public void addbook(Book obj) { Models.Book item = new Book(obj); this.allItems.Add(item); DBModels.DBViewModels.InsertDatabase(item); this.selectedItem = null; }
public BookDto(Models.Book entity) { Id = entity.Id; Index = entity.Index; Name = entity.Name; Purpose = entity.Purpose; }
public void updateBook(int nId, Models.Book cBook) { List <Models.Book> books = getBooks(); int id = -1; for (var enu = books.GetEnumerator(); enu.MoveNext();) { if (enu.Current.Id == nId) { id = books.IndexOf(enu.Current); } } if (id != -1) { books.RemoveAt(id); books.Insert(id, cBook); } List <String> jsons = new List <string>(); for (var enu = books.GetEnumerator(); enu.MoveNext();) { jsons.Add(Newtonsoft.Json.JsonConvert.SerializeObject(enu.Current)); } String[] lines = jsons.ToArray <string>(); System.IO.File.WriteAllLines(strBooksBase, lines, Encoding.Unicode); }
public ActionResult Create(Models.Book p) {//insert new <person> to people.xml string path = AppDomain.CurrentDomain.BaseDirectory + "App_Data\\books.xml"; XmlDocument doc = new XmlDocument(); // create file if it doesn't exist if (System.IO.File.Exists(path)) { doc.Load(path); //exists, so load XmlNode root = doc.SelectSingleNode("books"); //get root XmlElement book = CreateBookElement(doc, p); root.AppendChild(book); //append new person to <book> } else { //doesn't exist so add stuff XmlNode dec = doc.CreateXmlDeclaration("1.0", "utf-8", ""); doc.AppendChild(dec); XmlNode root = doc.CreateElement("books"); XmlNode book = CreateBookElement(doc, p); root.AppendChild(book); //append new person to <people> doc.AppendChild(root); //since it's a new file, it's not saved yet //append <people> the document } doc.Save(path); return(View()); }