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