/// <summary> /// Book is Assigned to the Borrower /// </summary> /// <param> AssignBookModel</param> /// <returns>bool<BorrowersModel> </returns> public bool Post_AssignBook(AssignBookModel aBookModel) { AssignBookModel aBook = new AssignBookModel(); aBookModel.AssignedDate = DateTime.Now; //Current Assign Date aBookModel.DueDate = DateTime.Now.AddDays(7); //7 Days time to return book return(aBook.AssignBook(aBookModel)); }
///<summary> /// DeAssign the Book incase user has retruned it ///</summary> ///<param> BookId</param> ///<param> BorrowerId</param> ///<returns>bool<BorrowersModel> </returns> public bool GetDeAssignBook(int BookId, int BorrowerId) { AssignBookModel aBook = new AssignBookModel(); aBook.BorrowerID = BorrowerId; aBook.BookID = BookId; return(aBook.DeAssignBook(aBook)); }
///<summary> ///All Issued books History ///</summary> ///<param> jQueryDataTableParamModel</param> ///<param> searchCriteria</param> ///<returns>bool<BorrowersModel> </returns> public JqDataTable <object[]> Post_AllAssignedBooks(jQueryDataTableParamModel param, string searchCriteria, string type) { try { SearchCriteria criteria = ConvertFromJsonToObject <SearchCriteria>(searchCriteria); int startIndex = 0; if (param.iDisplayStart > 0) { startIndex = param.iDisplayStart + 1; } else { startIndex = param.iDisplayStart; } criteria.StartIndex = startIndex; criteria.EndIndex = param.iDisplayStart + param.iDisplayLength; criteria.SortOrder = param.sSortDir_0; criteria.SortingCol = param.iSortCol_0; if (String.IsNullOrWhiteSpace(criteria.Text)) { criteria.Text = String.Empty; } AssignBookModel obj = new AssignBookModel(); int count = obj.TotalAssigned(criteria); var data = new List <object[]>(); IList <AssignBookModel> bModel = new List <AssignBookModel>(); bModel = obj.GetAllAssignedBooks(criteria); foreach (AssignBookModel item in bModel) { var array = new object[8]; array[0] = item.Title; array[1] = item.FirstName + "," + item.LastName; array[2] = Convert.ToDateTime(item.AssignedDate).ToString("MMMM d, yyyy"); array[3] = Convert.ToDateTime(item.DueDate).ToString("MMMM d, yyyy");; array[4] = (item.isCurrentlyAssigned == true) ? "N" : "Y"; array[5] = (DateTime.Now - item.DueDate).TotalDays > 0 && item.isCurrentlyAssigned == true ? "Y" : "N"; array[6] = item.BorrowerID; array[7] = item.BookID; data.Add(array); } return(new JqDataTable <object[]> { sEcho = param.sEcho, iTotalRecords = count, iTotalDisplayRecords = count, aaData = data }); } catch (Exception e) { return(null); } }