public ActionResult CreateBook(BOOK bk)
{
BOOKS bks = new BOOKS();
bks.createBook(bk);
return(View());
}
private void BtnAddedBook_OnClick(object sender, RoutedEventArgs e)
{
try
{
Logger.Info("Getting started: BtnAddedBook_OnClick");
BOOK book = GetWindowFields();
ThreadPool.QueueUserWorkItem(obj =>
{
Manager.Entity = book;
Manager.AddNewRow();
if (Manager.IsOk)
{
this.GuiSync(Close);
}
});
}
catch (Exception ex)
{
Logger.Error(ex);
MessageBox.Show(ex.Message, "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public IHttpActionResult PutBOOK(long id, BOOK bOOK)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != bOOK.ID)
{
return(BadRequest());
}
db.Entry(bOOK).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!BOOKExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void Update(BOOK bookObj)
{
using (var db = new LibDb())
{
var b = db.BOOKs.Include(x => x.AUTHORs).ToList().Find(d => d.ISBN ==
bookObj.ISBN);
b.AUTHORs.Clear();
db.SaveChanges();
}
var newAuthors = bookObj.AUTHORs;
bookObj.AUTHORs = new List <AUTHOR>();
using (var db = new LibDb())
{
db.BOOKs.Attach(bookObj);
db.Entry(bookObj).State = EntityState.Modified;
foreach (var author in newAuthors)
{
db.AUTHORs.Attach(author);
bookObj.AUTHORs.Add(author);
}
db.SaveChanges();
}
}
public IHttpActionResult PutBOOK(long id, [FromBody] BOOK bOOK)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
//return Json(new { success = false, errors = ModelState.Values.Where(i => i.Errors.Count > 0) });
}
if (id != bOOK.ID)
{
return(BadRequest());
}
db.Entry(bOOK).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!BOOKExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void Delete(BOOK bookObj)
{
using (var db = new LibDb())
{
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
db.BOOKs.Attach(bookObj);
foreach (var au in bookObj.AUTHORs)
{
db.AUTHORs.Attach(au);
}
try
{
bookObj.AUTHORs.Clear();
db.BOOKs.Remove(bookObj);
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
}
}
}
public void Delete(BOOK bookObj)
{
using (var db = new LibraryDBEntities1())
{
using (DbContextTransaction transaction = db.Database.BeginTransaction())
{
try
{
_bookObj = db.BOOKs.Find(bookObj.ISBN);
foreach (var item in _bookObj.AUTHORs.ToList())
{
_bookObj.AUTHORs.Remove(item);
}
db.BOOKs.Remove(_bookObj);
Shared.save(db);
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
}
}
}
public void DeleteBook(int?bookid)
{
BOOK book = dataAccess.BOOKs.Single(b => b.BOOKID == bookid);
dataAccess.BOOKs.DeleteOnSubmit(book);
dataAccess.SaveChanges();
}
public ActionResult Insert(BOOK entity)
{
var dao = new BookDAO();
dao.handleInsert(entity);
return(RedirectToAction("Management"));
}
public void TestBook()
{
using (LibraryDb db = LibraryDb.GetDbContext())
{
var books = BooksBl.GetBooks();
//add book test
BOOK book = new BOOK {
ISBN = "test", COUNT = 0, NAME = "test", PRICE = 0
};
BooksBl.AddNewCard(book);
BOOK dbBook = db.BOOKS.SingleOrDefault(b => b.ID == book.ID);
Assert.IsNotNull(dbBook);
//Change book test
dbBook.DESCRIPTION = someText;
BooksBl.UpdateBook(dbBook);
dbBook = db.BOOKS.SingleOrDefault(b => b.ID == book.ID);
Assert.AreEqual(true, dbBook?.DESCRIPTION == someText);
//deleted test book
BooksBl.BooksRemove(new[] { book.ID });
dbBook = db.BOOKS.SingleOrDefault(b => b.ID == book.ID);
Assert.IsNull(dbBook);
}
}
public void Update(BOOK bookObj)
{
using (var db = new swagbaseEntities1())
{
BOOK dummyBook = db.BOOKs.Include("AUTHORs").FirstOrDefault(a => a.ISBN == bookObj.ISBN);
db.BOOKs.Attach(dummyBook);
db.CLASSIFICATIONs.Attach(db.CLASSIFICATIONs.Find(bookObj.SignId));
dummyBook.pages = bookObj.pages;
dummyBook.Title = bookObj.Title;
dummyBook.publicationinfo = bookObj.publicationinfo;
dummyBook.PublicationYear = bookObj.PublicationYear;
dummyBook.ISBN = bookObj.ISBN;
dummyBook.AUTHORs.Clear();
List <int> authorsToDummy = bookObj.AUTHORs.Select(a => a.Aid).ToList();
foreach (int auth in authorsToDummy)
{
db.AUTHORs.Attach(db.AUTHORs.Find(auth));
dummyBook.AUTHORs.Add(db.AUTHORs.Find(auth));
}
dummyBook.pages = bookObj.pages;
dummyBook.Title = bookObj.Title;
dummyBook.publicationinfo = bookObj.publicationinfo;
dummyBook.PublicationYear = bookObj.PublicationYear;
dummyBook.SignId = bookObj.SignId;
//dummyBook.CLASSIFICATION = bookObj.CLASSIFICATION;
db.SaveChanges();
}
}
public static void UpdateBook(BOOK book, LibraryDb dbContext = null)
{
using (LibraryDb db = LibraryDb.GetDbContext(dbContext))
{
using (TransactionScope transaction = new TransactionScope())
{
if (book == null)
{
throw new ArgumentNullException($"book: {nameof(book)}");
}
BOOK dbBook = db.BOOKS.SingleOrDefault(b => b.ID == book.ID);
if (dbBook == null)
{
throw new Exception($"Книга с {book.ID} не найдена!");
}
dbBook.ISBN = book.ISBN;
dbBook.NAME = book.NAME;
dbBook.AUTHOR = book.AUTHOR;
dbBook.PUBLISHING = book.PUBLISHING;
dbBook.COUNT = book.COUNT;
dbBook.STATUS = book.STATUS;
dbBook.PRICE = book.PRICE;
dbBook.DESCRIPTION = book.DESCRIPTION;
db.SaveChanges();
transaction.Complete();
}
}
}
public void WithBookTest()
{
using (LibraryDb db = LibraryDb.GetDbContext())
{
BOOK book = new BOOK {
ISBN = "test", COUNT = 0, NAME = "test", PRICE = 0
};
using (DbManager <BOOK> manager = new DbManager <BOOK>(new ManagerBook(), book))
{
manager.AddNewRow();
BOOK dbBook = db.BOOKS.SingleOrDefault(b => b.ID == book.ID);
Assert.IsNotNull(dbBook);
//Change book test
dbBook.DESCRIPTION = someText;
manager.Entity = dbBook;
manager.UpdateRow();
dbBook = db.BOOKS.SingleOrDefault(b => b.ID == book.ID);
Assert.AreEqual(true, dbBook?.DESCRIPTION == someText);
//deleted test book
manager.RemoveRow();
dbBook = db.BOOKS.SingleOrDefault(b => b.ID == book.ID);
Assert.IsNull(dbBook);
}
}
}
public BOOK EditBook(BOOK eBook)
{
using (DbLibrary db = new DbLibrary())
{
db.Configuration.LazyLoadingEnabled = false;
BOOK book = db.BOOKs.Include(b => b.AUTHORs).FirstOrDefault(x => x.ISBN.Equals(eBook.ISBN));
book.AUTHORs.Clear();
db.SaveChanges();
}
using (DbLibrary db = new DbLibrary())
{
db.Configuration.LazyLoadingEnabled = false;
BOOK book = db.BOOKs.Include(b => b.CLASSIFICATION).FirstOrDefault(x => x.ISBN.Equals(eBook.ISBN));
db.Entry(book).CurrentValues.SetValues(eBook);
db.ChangeTracker.Entries <CLASSIFICATION>().ToList().ForEach(a => a.State = EntityState.Unchanged);
book.AUTHORs = new List <AUTHOR>();
foreach (var author in eBook.AUTHORs)
{
db.AUTHORs.Attach(author);
book.AUTHORs.Add(author);
}
db.SaveChanges();
return(book);
}
}
public void GetBestBooks()
{
int quantity = db.BOOK.Count();
//The number of people for each score level
int num1 = 0, num2 = 0, num3 = 0, num4 = 0, num5 = 0;
//Use dictionary to save the average score of each book
Dictionary <int, float> scores = new Dictionary <int, float>();
for (int i = 1; i <= quantity; i++)
{
num1 = db.Database.SqlQuery <int>("select count(*) from COMMENTS where SCORE=1 and BOOK_ID=" + i.ToString()).FirstOrDefault();
num2 = db.Database.SqlQuery <int>("select count(*) from COMMENTS where SCORE=2 and BOOK_ID=" + i.ToString()).FirstOrDefault();
num3 = db.Database.SqlQuery <int>("select count(*) from COMMENTS where SCORE=3 and BOOK_ID=" + i.ToString()).FirstOrDefault();
num4 = db.Database.SqlQuery <int>("select count(*) from COMMENTS where SCORE=4 and BOOK_ID=" + i.ToString()).FirstOrDefault();
num5 = db.Database.SqlQuery <int>("select count(*) from COMMENTS where SCORE=5 and BOOK_ID=" + i.ToString()).FirstOrDefault();
float total_score = num1 * 1 + num2 * 2 + num3 * 3 + num4 * 4 + num5 * 5;
float total_people = num1 + num2 + num3 + num4 + num5;
float average = total_score / total_people;
scores[i] = average;
}
//Sort the dictionary by value
Dictionary <int, float> sorted_scores = scores.OrderByDescending(o => o.Value).ToDictionary(p => p.Key, o => o.Value);
List <int> index = new List <int>(sorted_scores.Keys);
BOOK[] best_Books = new BOOK[5];
for (int i = 0; i < 5; i++)
{
best_Books[i] = db.BOOK.Find(index[i]);
}
//Use ViewBag to transfer the data
ViewBag.bBooks = best_Books;
}
public static void addNewBook(BOOK book)
{
using (var dtbEntity = new QLTVEntities1())
{
dtbEntity.BOOKS.Add(book);
dtbEntity.SaveChanges();
}
}
public void testBOK()
{
BOOKS bks = new BOOKS();
BOOK bk = new BOOK();
bk.NAME = "ali";
bks.createBook(bk);
}
public ActionResult DeleteConfirmed(long id)
{
BOOK bOOK = db.BOOKs.Find(id);
db.BOOKs.Remove(bOOK);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: BOOKTAGs/TAG[功能点20：按名称查书籍标签表]
public ActionResult SearchName(string bname)
{
BOOK temp = db.BOOK.Find(bname);
IQueryable <BOOKTAG> Que = from q in db.BOOKTAG where q.BOOKID == temp.BOOKID select q;
List <BOOKTAG> list = Que.ToList();
return(View(list));
}
public void Post(BOOK book)
{
book.state = true;
book.url = "";
book.isRemove = false;
_context.BOOKS.Add(book);
}
public IEnumerable <BOOK> getBook()
{
using (EntitiDBContext db = new EntitiDBContext())
{
BOOK sch = new BOOK();
return(db.BOOKS.OrderBy(x => x.NAME).ToList());
}
}
public ActionResult AddBook(BOOK book, List <int> Authors, List <int> Categories,
List <HttpPostedFileBase> bookImages, List <HttpPostedFileBase> bookSoftCopy)
{
try
{
book.CREATED_DATE = DateTime.Now;
book = BookModel.AddBook(book);
foreach (int aID in Authors)
{
BOOK_AUTHOR bookAuthor = new BOOK_AUTHOR();
bookAuthor.BOOKID = book.BOOKID;
bookAuthor.AUTHORID = aID;
AuthorModel.AddBookAuthor(bookAuthor);
}
foreach (int bCID in Categories)
{
BOOK_CATEGORY bookCat = new BOOK_CATEGORY();
bookCat.BOOKID = book.BOOKID;
bookCat.CATEGORYID = bCID;
CategoryModel.AddBookCategory(bookCat);
}
foreach (HttpPostedFileBase image in bookImages)
{
String fname = Generator.RandomString(10) + "." + image.FileName.Split('.')[image.FileName.Split('.').Length - 1];
string path = Server.MapPath("~/UserImages/") + fname;
BOOK_IMAGE bookImage = new BOOK_IMAGE();
bookImage.BOOKID = book.BOOKID;
bookImage.IMAGEPATH = "/UserImages/" + fname;
image.SaveAs(path);
BookModel.AddBookImage(bookImage);
}
if (bookSoftCopy != null)
{
foreach (HttpPostedFileBase bookSC in bookSoftCopy)
{
String fname = Generator.RandomString(10) + "." + bookSC.FileName.Split('.')[bookSC.FileName.Split('.').Length - 1];
string path = Server.MapPath("~/UserImages/") + fname;
BOOK_SOFTCOPY bSC = new BOOK_SOFTCOPY();
bSC.BOOKID = book.BOOKID;
bSC.FILEPATH = "/UserImages/" + fname;
bSC.FILESIZE = bookSC.ContentLength;
bookSC.SaveAs(path);
BookModel.AddBookSoftCopy(bSC);
}
}
ViewBag.Message = SuccessMessage.BOOK_ADDED;
}
catch (Exception e)
{
ViewBag.Message = e.Message;
}
initialiseViewBag();
return(View(book));
}
public ActionResult ByPublisherDisplay(OptionSelected model)
{
string optionSelected;
if (model.optionSelected != null)
{
optionSelected = model.optionSelected;
}
else
{
optionSelected = "";
}
var allBooks = db.BOOKs.ToList();
List <BOOK> booksToDisplay = new List <BOOK>();
foreach (var book in allBooks)
{
BOOK myBook = new BOOK();
if (model.optionSelected == book.PUBLISHER_CODE)
{
myBook.BOOK_CODE = book.BOOK_CODE;
myBook.PAPERBACK = book.PAPERBACK;
myBook.PRICE = book.PRICE;
myBook.TYPE = book.TYPE;
myBook.TITLE = book.TITLE;
}
booksToDisplay.Add(myBook);
}
// #5 LINQ Statement
var data = from p in db.PUBLISHERs select new { p.PUBLISHER_CODE, p.PUBLISHER_NAME };
int size = 0;
int counter = 0;
foreach (var publisher in data)
{
size++;
}
string[] publisherNames = new string[size];
string[] publisherCodes = new string[size];
foreach (var publisher in data)
{
publisherNames[counter] = publisher.PUBLISHER_NAME;
publisherCodes[counter] = publisher.PUBLISHER_CODE;
counter++;
}
ViewBag.publisherNames = publisherNames;
ViewBag.publisherCodes = publisherCodes;
ViewBag.booksToDisplay = booksToDisplay;
return(View());
}
public bool createBook(BOOK book)
{
using (EntitiDBContext db = new EntitiDBContext())
{
db.BOOKS.Add(book);
db.SaveChanges();
return(true);
}
}
public static void addNewBook(BOOK book)
{
using (var dtbEntity = new QLTVEntities1())
{
dtbEntity.BOOKS.Add(book);
dtbEntity.SaveChanges();
MessageBox.Show("Add successfully!");
}
}
public void Update(BOOK bookObj)
{
using (var db = new LibraryDBEntities1())
{
db.BOOKs.Attach(bookObj);
db.Entry(bookObj).State = EntityState.Modified;
Shared.save(db);
}
}
public void Update(BOOK bookObj)
{
using (var db = new Libdb())
{
db.BOOK.Attach(bookObj);
db.Entry(bookObj).State = EntityState.Modified;
db.SaveChanges();
}
}
// Begin action commands
private void registerCommand()
{
DeleteCommand = new RelayCommand <BOOK>(u => u != null, u => { Model.Books.handleDelete(u.ID); Refresh(); });
AddCommand = new RelayCommand <BOOK>(null, u => { Model.Books.handleInsert(u); Refresh(); });
UpdateCommand = new RelayCommand <BOOK>(u => u != null, u => { Model.Books.handleUpdate(u); Refresh(); });
EmptyCommand = new RelayCommand <BOOK>(u => u != null, u => { SelectedBook = new BOOK(); });
SetPicCommand = new RelayCommand <BOOK>(null, u => { this._setPic(); });
SearchCommand = new RelayCommand <USER>(null, u => { this.sortByName(); });
}
public void Delete(BOOK bookObj)
{
using (var db = new swagbaseEntities1())
{
BOOK bISBN = db.BOOKs.Find(bookObj.ISBN);
db.BOOKs.Remove(bISBN);
db.SaveChanges();
}
}
public ActionResult Create([Bind(Include = "BOOKNAME,PRICEPERCHAPTER")] BOOK book)
{
var value = Request.Form[3];
if (ModelState.IsValid)
{
//bookID:查book表
var que = db.BOOK.Count();
var bookID = (que + 1).ToString();
for (int i = 0; i < 8 - bookID.Length; i++)
{
bookID = '0' + bookID;
}
book.BOOKID = bookID;
//writerID:当前
string userid = Request.Cookies["_userid"].Value;
//starttime,updateTime:当前时间
book.STARTTIME = DateTime.Now.ToString("yyyy-MM-dd");
book.UPDATETIME = DateTime.Now.ToString("yyyy-MM-dd");
//downloadnum,collcectnum:0
book.DOWNLOADNUM = 0;
book.COLLECTNUM = 0;
//ifend:0
book.IFEND = 0;
//其余字段留空
db.BOOK.Add(book);
BOOKTAG booktag = new BOOKTAG();
booktag.BOOKID = bookID;
if (value == "0")
{
booktag.BOOKTAG1 = "玄幻";
}
else if (value == "1")
{
booktag.BOOKTAG1 = "仙侠";
}
else
{
booktag.BOOKTAG1 = "二次元";
}
//改作者表
WRITER writer = db.WRITER.Find(userid);
writer.NUMPRODUCTION = writer.NUMPRODUCTION + 1;
db.BOOKTAG.Add(booktag);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(View());
}
}
partial void DeleteBOOK(BOOK instance);
partial void UpdateBOOK(BOOK instance);
partial void InsertBOOK(BOOK instance);