private string GetBookStudentIssue() { if (StringUtil.NotNullAndNotBlank(Request.Form["rec_id"]) && StringUtil.NotNullAndNotBlank(Request.Form["student_id"])) { BookIssueService = new book_issueService(); bookRecordService = new Book_recordService(); studentService = new StudentService(); student Std = studentService.GetByIdFull(Request.Form["student_id"].ToString()); if (Std == null) { return("0"); } List <object> BookIssuesOBJ = BookIssueService.SearchAdvanced(new Dictionary <string, object>() { { "student_id", Request.Form["student_id"].ToString() }, { "book_record_id", Request.Form["rec_id"].ToString() }, { "book_return", "0" }, { "issue_type", "issue" }, }); if (BookIssuesOBJ == null || BookIssuesOBJ.Count == 0) { return("0"); } book_issue StudentBookIssue = (book_issue)BookIssuesOBJ.ElementAt(0); if (StudentBookIssue == null) { return("0"); } book_record BookRecord = (book_record)bookRecordService.GetById(Request.Form["rec_id"]); if (BookRecord == null) { return("0"); } book_record BookRecordToSend = (book_record)ObjectUtil.GetObjectValues(new string[] { "id", "book_id", "available" }, BookRecord); if (BookRecord.book != null) { BookRecordToSend.book = (book)ObjectUtil.GetObjectValues(new string[] { "id", "title" }, BookRecord.book); } book_issue BookIssueToSend = (book_issue)ObjectUtil.GetObjectValues(new string[] { "id", "book_record_id", "book_return" }, StudentBookIssue); BookIssueToSend.book_record = BookRecordToSend; return(JsonConvert.SerializeObject(BookIssueToSend)); } return("0"); }
protected void ButtonReturn_Click(object sender, EventArgs e) { try { book_issue BS = new book_issue(); BS.id = StringUtil.GenerateRandomChar(10); //BS.book_issue_id = (TextBoxIssueRecordId.Text.Trim()); //add student Student = (student)StudentService.GetById(TextBoxStudentID.Text); if (Student == null) { return; } string Student_ID = Student.id; string RecId = (TextBoxIssueRecordId.Text.Trim()); List <object> BookIssuesOBJ = BookIssueService.SearchAdvanced(new Dictionary <string, object>() { { "student_id", Student_ID }, { "book_record_id", RecId }, { "issue_type", "issue" }, { "book_return", "0" } }); if (BookIssuesOBJ == null || BookIssuesOBJ.Count == 0) { return; } book_issue reffBookIssue = (book_issue)BookIssuesOBJ.ElementAt(0); if (reffBookIssue.book_return != 0) { return; } BS.book_issue_id = reffBookIssue.id; // book_issue reffBookIssue = (book_issue)BookIssueService.GetById(BS.book_issue_id); if (!BookIssue.ExistBookRecord(BS.book_issue_id, BookIssuesReturn) && null != reffBookIssue) { //Check book_isue where book_rec_id = rec book_return != null || 0 and issue.student_id = std_id string StudentId = TextBoxStudentID.Text; if (BookIssueService.GetByBookIssueIdReturned(reffBookIssue.id).Count == 0) { book_record BookRecord = (book_record)bookRecordService.GetById(reffBookIssue.book_record_id); //BS.book_issue2 = reffBookIssue; BS.book_record_id = BookRecord.id; book Book = (book)ObjectUtil.GetObjectValues(new string[] { "id", "title" }, BookRecord.book); book_record BookRec = (book_record)ObjectUtil.GetObjectValues(new string[] { "id", "book_id", "available" }, BookRecord); BookRec.book = Book; BS.book_record = BookRec; BookIssuesReturn.Add(BS); } } }catch (HttpUnhandledException ex) { throw ex; } ButtonSearch_Click(sender, e); ViewState["BookIssuesReturn"] = BookIssuesReturn; PopulateBooksToReturn(); }