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());
}
