public string RequestForThisBook(Book book, BookReader reader)
{
BookGateway aBookGateway = new BookGateway();
if (aBookGateway.CheckIfthisBookExist(book))
{
if (aBookGateway.CheckBookQuantity(book) > 0)
{
if (aRequestGateway.RequestForThisBook(book, reader))
{
return("Request Successfull");
}
else
{
return("Error found");
}
}
else
{
return("Not Available now");
}
}
else
{
return("This book is not exist in the library");
}
}
public AjaxResult CreateReader([FromBody] BookReader readerJs)
{
var _result = new AjaxResult();
_bookReaderBL = new BookReaderBL();
try
{
// Check BookReaderID trùng hay không
Dictionary <string, object> dict = new Dictionary <string, object>();
dict["BookReaderCode"] = readerJs.BookReaderCode;
List <BookReader> listReader = _bookReaderBL.SelectBookReaderByCode(dict);
if (listReader.Count > 0)
{
_result.Success = false;
_result.Message = "Mã thẻ " + readerJs.BookReaderCode + " đã được sử dụng. Vui lòng kiểm tra lại.";
}
else
{
//Tiến hành Insert bản ghi
readerJs.CreatedDate = DateTime.Now;
readerJs.CreaterID = Guid.Parse("666C3824-0105-9E5B-B86B-0226A45DB0D2");
_bookReaderBL.AddNewBookReader(readerJs);
_result.Success = true;
_result.Message = "Cất thành công";
}
}
catch (Exception ex)
{
_result.Success = false;
_result.Message = "Có lỗi đã xảy ra, thực hiện chức năng thất bại";
}
return(_result);
}
public void UpdateBookReaderTest()
{
int bookReaderIndex = context.bookReader.Count - 1;
var oldBookReader = repository.GetBookReader(bookReaderIndex);
var newBookReader = new BookReader()
{
Age = 34,
FirstName = "Roma",
LastName = "Świerk",
Telephone = "123456789"
};
int beforeSize = context.bookReader.Count;
repository.UpdateBookReader(oldBookReader, newBookReader);
int afterSize = context.bookReader.Count;
var bookReaderAfterUpdate = repository.GetBookReader(bookReaderIndex);
// compare sizes
Assert.AreEqual(beforeSize, afterSize);
// compare references (should be different because we only change properties)
Assert.IsFalse(object.ReferenceEquals(bookReaderAfterUpdate, newBookReader));
// compare properties
Assert.AreEqual(newBookReader.Age, bookReaderAfterUpdate.Age);
Assert.AreEqual(newBookReader.FirstName, bookReaderAfterUpdate.FirstName);
Assert.AreEqual(newBookReader.LastName, bookReaderAfterUpdate.LastName);
Assert.AreEqual(newBookReader.Telephone, bookReaderAfterUpdate.Telephone);
}
public void AddBookReaderTest()
{
int beforeSize = context.bookReaders.Count;
var beforeLastBookReader = context.bookReaders.Last();
var bookReaderToAdd = new BookReader()
{
Age = 35,
FirstName = "Wiktor",
LastName = "Forst",
Telephone = "123456789"
};
service.AddBookReader(bookReaderToAdd);
int afterSize = context.bookReaders.Count;
var afterLastBookReader = context.bookReaders.Last();
// check sizes
Assert.AreNotEqual(beforeSize, afterSize);
// check if last books aren't equal
Assert.AreNotEqual(beforeLastBookReader, afterLastBookReader);
// check if the book is in the list
Assert.IsTrue(context.bookReaders.Contains(bookReaderToAdd));
}
public void AddBookReaderTest()
{
int beforeSize = context.bookReader.Count;
var beforeLastBookReader = context.bookReader.Last();
var bookReaderToAdd = new BookReader()
{
Age = 18,
FirstName = "Oskar",
LastName = "Neuman",
Telephone = "665456789"
};
repository.AddBookReader(bookReaderToAdd);
int afterSize = context.bookReader.Count;
var afterLastBookReader = context.bookReader.Last();
// check sizes
Assert.AreNotEqual(beforeSize, afterSize);
// check if last books aren't equal
Assert.AreNotEqual(beforeLastBookReader, afterLastBookReader);
// check if the book is in the list
Assert.IsTrue(context.bookReader.Contains(bookReaderToAdd));
}
// will be called in background thread
List <Book> LoadBooksInBackground(string path)
{
using (var stream = File.OpenRead(path))
{
var books = BookReader.Read(stream);
return(books);
}
}
public string UpdateThisBookReader(BookReader updtReader)
{
if (aBookReaderGateway.UpdateThisBookReader(updtReader))
{
return("Update Successful");
}
return("Error found");
}
public static void Read(string path)
{
var files = Directory.GetFiles(path, "*.txt");
foreach (var filePath in files)
{
var book = BookReader.Read(filePath);
bookStore.Add(book);
}
}
public ReaderUI(BookReader aBookReader)
{
InitializeComponent();
readerIDTextBox.Text = aBookReader.ReaderID;
readerNameTextBox.Text = aBookReader.ReaderName;
bookTakenTextBox.Text = Convert.ToString(aBookReader.Booktaken);
LoadBookListGridView();
LoadRequestedBookGridView();
CheckRequestStauts();
}
public ActionResult <BookReader> Post(BookReader booksReader)
{
var response = booksReadersService.AddBookReader(booksReader);
if (response != null)
{
return(BadRequest(new { message = "You have already take one copy of the book!" }));
}
return(Ok());
}
public void AddBookReader(BookReader bookReader)
{
// check if given book reader exists in repository
if (!repository.GetAllBookReaders().Contains(bookReader))
{
repository.AddBookReader(bookReader);
}
else
{
throw new ArgumentException("Nie można dodać czytelnika do repozytirum, czytelnik już istnieje");
}
}
public void DeleteBookReader(BookReader bookReader)
{
// check if given book reader exists in repository
if (repository.GetAllBookReaders().Contains(bookReader))
{
repository.DeleteBookReader(bookReader);
}
else
{
throw new ArgumentException("Nie można usunąć czytelnika z repozytorium, czytelnik nie istnieje");
}
}
public void UpdateBookReader(BookReader oldBookReader, BookReader newBookReader)
{
// check if old book reader exists in the repository
if (repository.GetAllBookReaders().Contains(oldBookReader))
{
repository.UpdateBookReader(oldBookReader, newBookReader);
}
else
{
throw new ArgumentException("Nie można zaktualizować czytelnika, czytelnik nie istnieje");
}
}
public void DeleteBookReaderTestException()
{
var bookReaderToDelete = new BookReader()
{
Age = 99,
FirstName = "Testowy",
LastName = "Testowy",
Telephone = "123456789"
};
service.DeleteBookReader(bookReaderToDelete);
}
public void AddEventTestException2()
{
var bookState = context.bookStates[0];
var bookReader = new BookReader()
{
Age = 99,
FirstName = "Tester",
LastName = "Kodu",
Telephone = "123456789"
};
service.AddEvent(bookReader, bookState);
}
// filter and search methods
// get all events for specified book reader
public IEnumerable <Event> EventsForBookReader(BookReader bookReader)
{
List <Event> events = new List <Event>();
foreach (Event e in repository.GetAllEvents())
{
if (e.BookReader == bookReader)
{
events.Add(e);
}
}
return(events);
}
private void button1_Click(object sender, EventArgs e)
{
var book = Initializer.db.Books.SingleOrDefault(c => c.Name == textBox1.Text);
if (book != null)
{
TimeSpan timeSpan = new TimeSpan();
book.NumberInStock--;
Initializer.db.Entry(book).State = EntityState.Modified;
if (book.NumberInStock < 1)
{
MessageBox.Show("There are no such books available!");
return;
}
switch (comboBox1.SelectedIndex)
{
case 0:
timeSpan = new TimeSpan(7, 0, 0, 0);
break;
case 1:
timeSpan = new TimeSpan(14, 0, 0, 0);
break;
case 2:
timeSpan = new TimeSpan(21, 0, 0, 0);
break;
}
var bookreader = new BookReader
{
BookID = book.ID,
ReaderID = Reader.ID,
DateTaken = DateTime.Now,
DateMustBeReturned = DateTime.Now + timeSpan
};
Initializer.db.BooksReaders.Add(bookreader);
Initializer.db.SaveChanges();
MessageBox.Show("Book has successfully been added to reader!");
this.Dispose();
}
else
{
MessageBox.Show("There's no such book in the database!");
this.Dispose();
}
}
public bool UpdateThisBookReader(BookReader updtReader)
{
Connection.Open();
string query = "UPDATE t_reader SET reader_name = '" + updtReader.ReaderName + "' , email = '" + updtReader.Email + "' WHERE reader_id = '" + updtReader.ReaderID + "' ";
SqlCommand command = new SqlCommand(query, Connection);
int affectedRow = command.ExecuteNonQuery();
Connection.Close();
if (affectedRow > 0)
{
return(true);
}
return(false);
}
public bool SaveThisBookReader(BookReader aBookReader)
{
Connection.Open();
string query = "INSERT INTO t_reader (reader_id,reader_name,email) VALUES ('" + aBookReader.ReaderID + "','" + aBookReader.ReaderName + "','" + aBookReader.Email + "')";
SqlCommand command = new SqlCommand(query, Connection);
int affectedRow = command.ExecuteNonQuery();
Connection.Close();
if (affectedRow > 0)
{
return(true);
}
return(false);
}
public bool RequestForThisBook(Book book, BookReader reader)
{
Connection.Open();
string query = "INSERT INTO t_temporary_table (reader_id,book_id,status) VALUES ('" + reader.ReaderID + "','" + book.BookID + "','requested')";
SqlCommand command = new SqlCommand(query, Connection);
int affectedRow = command.ExecuteNonQuery();
Connection.Close();
if (affectedRow > 0)
{
return(true);
}
return(false);
}
public string SaveThisBookReader(BookReader aBookReader)
{
if (aBookReaderGateway.CheckIfExist(aBookReader))
{
return("This ID is already exist");
}
else
{
if (aBookReaderGateway.SaveThisBookReader(aBookReader))
{
return("Saved");
}
return("not saved");
}
}
public bool BookReaderLogin(BookReader aBookReader)
{
BookReader bBookReader = new BookReader();
bBookReader = aBookReaderGateway.BookReaderLogin(aBookReader.ReaderID);
if (aBookReader.ReaderID == bBookReader.ReaderID)
{
return(true);
}
else
{
return(false);
}
}
private void updateBookReaderButton_Click(object sender, EventArgs e)
{
BookReader updtReader = new BookReader();
BookReaderManager aBookReaderManager = new BookReaderManager();
updtReader.ReaderID = updateBookReaderIDtextBox.Text;
updtReader.ReaderName = updateBookReaderNameTextBox.Text;
updtReader.Email = UpdateEmailTextBox.Text;
MessageBox.Show(aBookReaderManager.UpdateThisBookReader(updtReader));
updateBookReaderIDtextBox.Clear();
UpdateEmailTextBox.Clear();
updateBookReaderNameTextBox.Clear();
LoadReaderListGridView();
}
private void addButton_Click(object sender, EventArgs e)
{
RequestManager aRequestManager = new RequestManager();
Book book = new Book();
book.BookID = addBookIDTextBox.Text;
BookReader cReader = new BookReader();
cReader.ReaderID = readerIDTextBox.Text;
MessageBox.Show(aRequestManager.RequestForThisBook(book, cReader));
addButton.Enabled = false;
addBookIDTextBox.Clear();
CheckRequestStauts();
LoadRequestedBookGridView();
}
public List <BookReader> LoadBookreaderGridview()
{
Connection.Open();
string query = "SELECT * FROM t_reader";
SqlCommand command = new SqlCommand(query, Connection);
SqlDataReader aReader = command.ExecuteReader();
List <BookReader> readerList = new List <BookReader>();
while (aReader.Read())
{
BookReader bBookReader = new BookReader();
bBookReader.ReaderID = aReader["reader_id"].ToString();
bBookReader.ReaderName = aReader["reader_name"].ToString();
bBookReader.Email = aReader["email"].ToString();
if (aReader["book_taken"].ToString() == "")
{
bBookReader.Booktaken = 0;
}
else
{
bBookReader.Booktaken = (int)aReader["book_taken"];
}
if (aReader["date_of_taken"].ToString() == "")
{
bBookReader.DateOfTakeBook = Convert.ToDateTime(null);
}
else
{
bBookReader.DateOfTakeBook = Convert.ToDateTime(aReader["date_of_taken"]);
}
if (aReader["date_of_return"].ToString() == "")
{
bBookReader.DateOfReturnBook = Convert.ToDateTime(null);
}
else
{
bBookReader.DateOfReturnBook = Convert.ToDateTime(aReader["date_of_return"]);
}
readerList.Add(bBookReader);
}
Connection.Close();
return(readerList);
}
public BookReader BookReaderLogin(string bookReaderID)
{
Connection.Open();
string query = "SELECT * FROM t_reader WHERE reader_id = '" + bookReaderID + "'";
SqlCommand command = new SqlCommand(query, Connection);
SqlDataReader aReader = command.ExecuteReader();
BookReader bookReader = new BookReader();
while (aReader.Read())
{
bookReader.ReaderID = aReader["reader_id"].ToString();
}
Connection.Close();
return(bookReader);
}
public bool CheckIfExist(BookReader aBookReader)
{
Connection.Open();
string query = "SELECT * FROM t_reader WHERE reader_id = '" + aBookReader.ReaderID + "'";
SqlCommand command = new SqlCommand(query, Connection);
SqlDataReader aReader = command.ExecuteReader();
while (aReader.Read())
{
Connection.Close();
return(true);
}
Connection.Close();
return(false);
}
public void TestUnionVector()
{
var fbb = new FlatBufferBuilder(100);
var rapunzel = Rapunzel.CreateRapunzel(fbb, 40).Value;
var characterTypes = new[]
{
Character.MuLan,
Character.Belle,
Character.Other,
};
var characterTypesOffset = Movie.CreateCharactersTypeVector(fbb, characterTypes);
var characters = new[]
{
Attacker.CreateAttacker(fbb, 10).Value,
BookReader.CreateBookReader(fbb, 20).Value,
fbb.CreateSharedString("Chip").Value,
};
var charactersOffset = Movie.CreateCharactersVector(fbb, characters);
var movieOffset = Movie.CreateMovie(
fbb,
Character.Rapunzel,
rapunzel,
characterTypesOffset,
charactersOffset);
Movie.FinishMovieBuffer(fbb, movieOffset);
var movie = Movie.GetRootAsMovie(fbb.DataBuffer);
Assert.AreEqual(Character.Rapunzel, movie.MainCharacterType);
Assert.AreEqual(40, movie.MainCharacter <Rapunzel>().Value.HairLength);
Assert.AreEqual(3, movie.CharactersLength);
Assert.AreEqual(Character.MuLan, movie.CharactersType(0));
Assert.AreEqual(10, movie.Characters <Attacker>(0).Value.SwordAttackDamage);
Assert.AreEqual(Character.Belle, movie.CharactersType(1));
Assert.AreEqual(20, movie.Characters <BookReader>(1).Value.BooksRead);
Assert.AreEqual(Character.Other, movie.CharactersType(2));
Assert.AreEqual("Chip", movie.CharactersAsString(2));
TestObjectAPI(movie);
}
public AjaxResult EditReader([FromBody] BookReader readerJs)
{
var _result = new AjaxResult();
_bookReaderBL = new BookReaderBL();
Dictionary <string, object> dict = new Dictionary <string, object>();
try
{
// Khởi tạo giá trị cho dictionary
dict["BookReaderCode"] = readerJs.BookReaderCode;
dict["BookReaderID"] = readerJs.BookReaderID;
// Check trùng BookReaderCode ghi trước khi cho update
List <BookReader> listReader = _bookReaderBL.SelectReaderByCodeAndDifferentID(dict);
if (listReader.Count > 0)
{
_result.Success = false;
_result.Message = "Mã thẻ " + readerJs.BookReaderCode + " đã được sử dụng. Vui lòng kiểm tra lại.";
}
else
{
readerJs.ModifiedDate = DateTime.Now;
readerJs.CreaterID = Guid.Parse("666C3824-0105-9E5B-B86B-0226A45DB0D2");
int result = _bookReaderBL.UpdateBookReader(readerJs);
if (result > 0)
{
_result.Success = true;
_result.Message = "Cất thành công";
}
else
{
_result.Success = false;
_result.Message = "Có lỗi đã xảy ra, thực hiện chức năng thất bại";
}
}
}
catch
{
_result.Success = false;
_result.Message = "Có lỗi đã xảy ra, thực hiện chức năng thất bại";
}
return(_result);
}
public static int Pack(FlatBuffers.FlatBufferBuilder builder, CharacterUnion _o)
{
switch (_o.Type)
{
default: return(0);
case Character.MuLan: return(Attacker.Pack(builder, _o.AsMuLan()).Value);
case Character.Rapunzel: return(Rapunzel.Pack(builder, _o.AsRapunzel()).Value);
case Character.Belle: return(BookReader.Pack(builder, _o.AsBelle()).Value);
case Character.BookFan: return(BookReader.Pack(builder, _o.AsBookFan()).Value);
case Character.Other: return(builder.CreateString(_o.AsOther()).Value);
case Character.Unused: return(builder.CreateString(_o.AsUnused()).Value);
}
}
