public static void issueBook(BookIssued book)
{
MySqlConnection con = DBConnection.getConnection();
if (con == null)
{
throw new Exception("Nu s-a putut realiza conexiunea");
}
MySqlCommand cmd = con.CreateCommand();
cmd.CommandText = "INSERT INTO booksissued(`Nume Prenume`,Autor,`Titlu Carte`,`Data Publicare`,Limba,`Nr Pagini`,`Data Imprumut`) VALUES(@numeprenume,@autor,@titlucarte,@datapublicare,@limba,@nrpagini,@dataimprumut)";
cmd.Parameters.AddWithValue("@numeprenume", book.Fullname);
cmd.Parameters.AddWithValue("@autor", book.Author);
cmd.Parameters.AddWithValue("@titlucarte", book.BookName);
cmd.Parameters.AddWithValue("@datapublicare", book.DateAdded);
cmd.Parameters.AddWithValue("@limba", book.Language);
cmd.Parameters.AddWithValue("@nrpagini", book.NumberOfPages);
cmd.Parameters.AddWithValue("dataimprumut", book.DateIssued);
if (cmd.ExecuteNonQuery() != 1)
{
MessageBox.Show("Nu s-a putut imprumuta cartea", "Atentionare", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
GUIController.checkBookIssueSuccess = true;
MessageBox.Show("Cartea a fost imprumutata", "Mesaj", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
con.Close();
}
private void btn_Issue_Click(object sender, EventArgs e)
{
BooksDao.getNumberOfIssuedBooks();
if (GUIController.numberOfIssuedBooks == true)
{
BookIssued bookissued = new BookIssued();
bookissued.Author = book.Author;
bookissued.BookName = book.BookName;
bookissued.Fullname = GUIController.getFullName;
bookissued.Language = book.Language;
bookissued.NumberOfPages = book.NumberOfPages;
bookissued.DateAdded = book.DateAdded;
var date = DateTime.Now.ToString("yyyy.MM.dd");
bookissued.DateIssued = Convert.ToDateTime(date);
try
{
BooksDao.issueBook(bookissued);
}
catch (Exception exp)
{
MessageBox.Show("Nicio carte selectata", "Atentionare", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
if (GUIController.checkBookIssueSuccess == true)
{
BooksDao.deleteBook(book);
dataBooksView.DataSource = BooksDao.showBooksTable();
}
}
else
{
MessageBox.Show("Prea multe carti imprumutate", "Atentionare", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public int DeleteBookIssued(int _BooksIssued)
{
BookIssued BookIssuedToDelete = context
.BooksIssued.SingleOrDefault(x => x.BookIssuedID == _BooksIssued);
context.BooksIssued.Remove(BookIssuedToDelete);
return(context.SaveChanges());
}
public HttpResponseMessage UpdateBookIssued([FromBody] BookIssued _BookIssued)
{
BookIssuedRepository ctxBookIssued = new BookIssuedRepository();
ctxBookIssued.UpdateBookIssued(_BookIssued);
HttpResponseMessage ms = Request.CreateResponse(HttpStatusCode.OK);
ms.Headers.Location = new Uri(Request.RequestUri + "/" + (_BookIssued.BookIssuedID).ToString());
return(ms);
}
public int UpdateBookIssued(BookIssued _BooksIssued)
{
BookIssued BookIssuedToUpdate = context.BooksIssued.SingleOrDefault(x => x.BookIssuedID == _BooksIssued.BookIssuedID);
BookIssuedToUpdate.BookIssuedStatusID = _BooksIssued.BookIssuedStatusID;
BookIssuedToUpdate.Coments = _BooksIssued.Coments;
BookIssuedToUpdate.IssueDate = _BooksIssued.IssueDate;
BookIssuedToUpdate.LateFee = _BooksIssued.LateFee;
BookIssuedToUpdate.OwnerID = _BooksIssued.OwnerID;
BookIssuedToUpdate.RetrunDate = _BooksIssued.RetrunDate;
return(context.SaveChanges());
}
public HttpResponseMessage GetBookIssuedByID(int id)
{
BookIssuedRepository ctxBookIssued = new BookIssuedRepository();
BookIssued _BookIssued = ctxBookIssued.GetBookIssued().FirstOrDefault(x => x.BookIssuedID == id);
if (_BookIssued != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, _BookIssued));
}
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Item not found"));
}
}
public static void deleteIssuedBook(BookIssued book)
{
MySqlConnection con = DBConnection.getConnection();
if (con == null)
{
throw new Exception("Nu s-a putut realiza conexiunea");
}
MySqlCommand cmd = con.CreateCommand();
cmd.CommandText = "DELETE FROM booksissued WHERE `Nume Prenume`=@numeprenume AND `Titlu Carte`=@titlucarte";
cmd.Parameters.AddWithValue("@numeprenume", book.Fullname);
cmd.Parameters.AddWithValue("@titlucarte", book.BookName);
if (cmd.ExecuteNonQuery() != 1)
{
throw new Exception("Stergerea nu s-a putut face.");
}
else
{
GUIController.checkDeleteIssuedBookSuccess = true;
}
con.Close();
}
public int IssueBook(BookIssued _BooksIssued)
{
throw new NotImplementedException();
}
public int InsertBookIssued(BookIssued _BooksIssued)
{
context.BooksIssued.Add(_BooksIssued);
return(context.SaveChanges());
}
