protected void OrderBtn_Click(object sender, EventArgs e) { DBFunctions db = new DBFunctions(); int uid = int.Parse(Session["userid"].ToString()); int mid = db.getmemberid(uid); IssueBook ib = new IssueBook {MemberID=mid,BookID=id,Status=0}; db.placeOrder(ib); Response.Redirect("AvailableBooks.aspx"); }
// GET: IssueBooks/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } IssueBook issueBook = db.IssueBooks.Find(id); if (issueBook == null) { return(HttpNotFound()); } ViewBag.BookId = new SelectList(db.Books, "Id", "BookName", issueBook.BookId); ViewBag.StatusId = new SelectList(db.Status, "Id", "Status1", issueBook.StatusId); ViewBag.StudentId = new SelectList(db.Students, "Id", "StudentName", issueBook.StudentId); return(View(issueBook)); }
public bool ValidateNewIssueAndSendToDA(IssueBook issueBookOBj) { if (issueBookOBj.iID == 0 /*|| addMemberOBj.name == "" || addMemberOBj.contactNo == "" || addMemberOBj.email == "" || addMemberOBj.address == ""*/) { return(false); } else { IssueBookDA issueBookDAobj = new IssueBookDA(); bool result = issueBookDAobj.SaveNewIssueToDB(issueBookOBj); //IssueDetailsDA issueDetailsDAobj = new IssueDetailsDA(); //bool result = issueDetailsDAobj.SaveNewIssueDatailsToDB(isssueBookOBj); return(result); } }
public ActionResult IssueBook([FromBody] IssueBook issueBook) { try { var isBookIssue = _bookIssueService.BookIssueToStudent(issueBook.StudentId, issueBook.BookBarCode); if (isBookIssue) { return(Ok("Book Successfully Issued")); } else { return(NotFound("Issue Book Failed")); } } catch (Exception e) { return(BadRequest(e.Message)); } }
public ActionResult IssueBook([FromBody] IssueBook BookIssue)/// StudentID,Barcode { try { var IsIssued = _ManageLibraryServices.IssueBook(BookIssue.StudentId, BookIssue.BookBarCode); if (IsIssued) { return(Ok("Book Issued Successfully")); } else { return(NotFound("Failed to Issue Book")); } } catch (Exception e) { return(BadRequest(e.Message)); } }
private void UpdateReturn(IssueBook selectedIssueBook) { DateTime now = DateTime.Now; try { SqlConnectionObj.Open(); string query = string.Format("Update tbl_Issueed set Return_date='{0}' where Book_id={1} and student_Reg='{2}' and Issue_date='{3}'", now, selectedIssueBook.Book.Id, selectedIssueBook.Student.RegNo, selectedIssueBook.DateTime); SqlCommandObj.CommandText = query; SqlCommandObj.ExecuteNonQuery(); } catch (Exception exception) { throw new Exception("Error occurred during return this book.", exception); } finally { SqlConnectionObj.Close(); } }
public ActionResult ReturnBook(int id) { db.Configuration.ProxyCreationEnabled = false; IssueBook books = new IssueBook(); Setting ss = db.Settings.FirstOrDefault(); books = db.IssueBooks.Where(x => x.Sid == id).First(); DateTime todaydate = System.DateTime.Now; var diff = (todaydate.Day - books.LastDate.Day); if (Convert.ToInt32(diff) < 0) { books.returnfine = 0; } else { books.returnfine = ss.Fine * Convert.ToInt32(diff); } return(PartialView("~/Views/CheckStatus/ReturnBook.cshtml", books)); }
public async Task <SharedLookUpResponse> DeleteIssueBookAsync(int issueBookId) { IssueBook issueBook = await iMSDbContext.IssueBooks.FirstOrDefaultAsync(x => x.Id == issueBookId); if (issueBook == null) { return new SharedLookUpResponse { Message = "There is no Issue Book with this id", HasError = true, ErrorType = SharedLookUpResponseType.Code } } ; else { iMSDbContext.IssueBooks.Remove(issueBook); await iMSDbContext.SaveChangesAsync(); return(new SharedLookUpResponse { HasError = false, Message = "Issue book deleted successfully" }); } }
protected void IssueButton_Click(object sender, EventArgs e) { if (memberIdTextBox.Text != "" && bookIdTextBox.Text != "") { IssueBook issueBook = new IssueBook(); Book book = new Book(); Member member = new Member(); member.Id = Convert.ToInt32(memberIdTextBox.Text); issueBook.Member = member; book.BookId = Convert.ToInt32(bookIdTextBox.Text); issueBook.Book = book; issueBook.StartDate = startDateTextBox.Text; issueBook.ReturnDate = returnDateTextBox.Text; if (memberManager.GetMemberForIssuedBook(member.Id) == true && bookManager.CheckBookCurrentStock(book.BookId) == true) { if (!issuedBookManager.CheckIssuedBookExisting(member.Id, book.BookId)) { string message = issuedBookManager.IssuedBook(issueBook); string message2 = bookManager.UpdateBookForCurrentStock(book); Response.Write("<script>alert('" + message + "');</script>"); GridView1.DataBind(); Clean(); } else { Response.Write("<script>alert('This Member Already Has The book');</script>"); } } else { Response.Write("<script>alert('Please Insert Book Id and Member Id or Book Stock out');</script>"); } } else { Response.Write("<script>alert('Please Insert Book Id and Member Id');</script>"); } }
private void returnToolStripMenuItem_Click(object sender, EventArgs e) { IssueBook selectedIssueBook = GetSelectedIssueBook(); int selectIndex = resultListView.SelectedIndices[0]; if (selectedIssueBook != null) { DialogResult result = MessageBox.Show(@"Do you want to return " + selectedIssueBook.Book.Title + ".", "Return Book", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { try { issueManager.ReturnBook(selectedIssueBook); resultListView.Items.RemoveAt(selectIndex); MessageBox.Show("You have successfully return this book."); } catch (Exception exception) { MessageBox.Show(exception.Message, @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
// PUT: odata/IssueBooks(5) public IHttpActionResult Put([FromODataUri] int key, Delta <IssueBook> patch) { Validate(patch.GetEntity()); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } IssueBook issueBook = db.IssueBooks.Find(key); if (issueBook == null) { return(NotFound()); } patch.Put(issueBook); try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!IssueBookExists(key)) { return(NotFound()); } else { throw; } } return(Updated(issueBook)); }
public void BookIssue(IssueBook bookIssue) { /**validation check student and book**/ if (!IsValidStudent(bookIssue)) { throw new SystemException("Student information not available "); } else if (!IsBookInfoExist(bookIssue)) { throw new SystemException("Book information not available "); } else if (!IsAvailableCopy(bookIssue)) { throw new SystemException("Book copy not available "); } else { bookIssue.BookId = _libraryUnitOfWork.BookIssueRepository.GetBook(bookIssue.Barcode).Id; } _libraryUnitOfWork.BookIssueRepository.BookIssue(bookIssue); BookStockUpdate(bookIssue); _libraryUnitOfWork.Save(); }
public void placeOrder(IssueBook book) { using (db = new CollegeERPDBEntities()) { db.IssueBooks.Add(book); db.SaveChanges(); AdminMails_tbl amail = new AdminMails_tbl { SenderID = book.LibraryMember.UserID, Message = book.LibraryMember.Candidate_tbl.Name + " has Requested for " + book.Book.Title, Date = DateTime.Now.Date, Subject = "Book Request", Status = 0 }; addadminmail(amail); } }
public void IssueBook(IssueBook issueBook) { _context.IssueBooks.Add(issueBook); }
public void ReturnBook(IssueBook selectedIssueBook) { bookGateway.UpdateBook(selectedIssueBook.Book.Id, selectedIssueBook.IssueCopy, 2); UpdateReturn(selectedIssueBook); }
public void BookStockUpdate(IssueBook bookIssue) { var book = _libraryUnitOfWork.BookIssueRepository.GetBook(bookIssue.Barcode); book.Copycount -= 1; }
public ActionResult IssueBooks(Models.IssueBook issuebook, Int64[] BooksID, Int64 StudentID, Int64 ClassID, DateTime IssueDate, DateTime ReturnDate, Int64 IssueID = 0) { IssueBook issuebooks = new IssueBook(); var userid = User.Identity.GetUserId(); var schoolid = db.LibrarienDetail.Where(x => x.UserId == userid).Select(c => c.SchoolId).FirstOrDefault(); var Status = "N.A"; try { if (IssueID != null) { var exist = db.IssueBook.Where(a => a.IssueID == IssueID).FirstOrDefault(); if (exist != null) { exist.IssueDate = issuebook.IssueDate; exist.StudentID = issuebook.StudentID; // exist.BookID = issuebook.BookID; exist.ReturnDate = issuebook.ReturnDate; exist.SchoolId = schoolid; exist.IssueBy = userid; exist.ClassID = issuebook.ClassID; db.SaveChanges(); Status = "Succeeded"; } else { issuebooks.IssueDate = issuebook.IssueDate; issuebooks.StudentID = issuebook.StudentID; //issuebooks.BookID = issuebook.BookID; issuebooks.ReturnDate = issuebook.ReturnDate; issuebooks.SchoolId = schoolid; issuebooks.IssueBy = userid; issuebooks.ClassID = issuebook.ClassID; db.IssueBook.Add(issuebooks); int i = db.SaveChanges(); if (i > 0) { var issueid = db.IssueBook.Where(s => s.SchoolId == schoolid).Max(c => c.IssueID); for (int j = 0; j < BooksID.Length; j++) { BookIssueDetail bookissuedet = new BookIssueDetail(); bookissuedet.BookID = BooksID[j]; bookissuedet.IssueID = issueid; db.BookIssueDetail.Add(bookissuedet); db.SaveChanges(); var bookid = BooksID[j]; var existbook = db.BookDetail.Where(x => x.BookID == bookid).FirstOrDefault(); existbook.TotalCopies = existbook.TotalCopies - 1; db.SaveChanges(); } } Status = "Succeeded"; } } } catch (Exception ex) { Status = "Unsucceeded " + ex; } return(Json(Status, JsonRequestBehavior.AllowGet)); }
public void IssueBook([FromBody] IssueBook BookIssue)/// StudentID,Barcode { _ManageLibraryServices.IssueBook(BookIssue.StudentId, BookIssue.BookBarCode); }
public void ReturnBook(IssueBook selectedIssueBook) { issueGateway.ReturnBook(selectedIssueBook); }
public ActionResult <double> CheckFineForEachBook([FromBody] IssueBook issueBook)//Id,Barcode { return(_reportingService.CheckLateFee(issueBook.StudentId, issueBook.BookBarCode)); }
public void Delete(IssueBook issueBook) { _issueBookService.Delete(issueBook); }
public void IssueBook([FromBody] IssueBook issueBook) { _bookIssueService.BookIssueToStudent(issueBook.StudentId, issueBook.BookBarCode); }
public void BookIssue(IssueBook issueBook) { _context.Add(issueBook); }