void Start() { bookCollider = GetComponent <BoxCollider>(); model = GetComponentsInChildren <MeshRenderer>(); bookLight = GetComponentInChildren <Light>(); instance = this; }
public List <object> GivingBook( GiveBookViewModel model, string userId, string selectedBookId, string selectedUserId) { var chackInputData = this.ChackInputData(selectedUserId, selectedBookId); List <object> result = new List <object>(); var allUsers = this.userService.GetUsers(model.AllUsers); var allBooks = this.allBooksServices.GetBooks(model.AllBooks, userId); var returnModel = new GiveBookViewModel() { AllBooks = allBooks, AllUsers = allUsers, }; if (string.IsNullOrEmpty(chackInputData)) { var selectedUser = this.SelectingUser(selectedUserId); var selectedBook = this.SelectingBook(selectedBookId); var book = this.context.Books.FirstOrDefault(b => b.Id == selectedBookId); var user = this.context.Users.FirstOrDefault(u => u.Id == selectedUserId); var chackGettetBook = this.ChackGivenBook(book); if (string.IsNullOrEmpty(chackGettetBook)) { GetBook getBook = new GetBook() { Book = book, BookId = selectedBookId, User = user, UserId = selectedUserId, }; this.context.GetBooks.Add(getBook); this.context.SaveChanges(); var libraryMessage = this.context.Users.FirstOrDefault(u => u.Id == userId); var message = $"Успешно взета книга от {libraryMessage.LibararyName} - {libraryMessage.Email}!"; this.messageService.AddMessageAtDB(selectedUserId, message); message = $"Успешно дадена книгана на {user.FirstName} {user.LastName} - {user.Email}!"; this.messageService.AddMessageAtDB(userId, message); result.Add(message); returnModel.SelectedBook = selectedBook; returnModel.SelectedUser = selectedUser; } else { result.Add(chackGettetBook); } } else { result.Add(chackInputData); } result.Add(returnModel); return(result); }
public void Test1() { var book1 = new GetBook("Book 1"); var book2 = new GetBook("Book 2"); Assert.Equal("Book 1", book1.Name); Assert.Equal("Book 2", book2.Name); }
public GetBookShould() { _bookServiceMock = new Mock <IBookService>(); _loggerMock = new Mock <ILogger <GetBook> >(); _httpRequestMock = new Mock <HttpRequest>(); _func = new GetBook( _bookServiceMock.Object, _loggerMock.Object); }
public IEnumerable <Book> SearchBooks([FromUri] GetBook book) { using (var db = new LibraryContext()) { var query = db.Books .Include(i => i.Author) .Include(i => i.Genre); var parsedQuery = Query.ParseBook(book, query); return(parsedQuery.ToList()); } }
private string ChackGivenBook(Book book) { GetBook chackGettetBook = this.context.GetBooks .FirstOrDefault(gb => gb.DeletedOn == null && gb.ReturnedOn == null && gb.BookId == book.Id); if (chackGettetBook != null) { return("Книгата е дадена на друг потребител!"); } return(null); }
private string ChackGivenBook(Book book) { GetBook chackGettetBook = this.context.GetBooks .FirstOrDefault(gb => gb.DeletedOn == null && gb.ReturnedOn == null && gb.BookId == book.Id); if (chackGettetBook != null) { return("Книгата е взета от читател за четене!"); } return(null); }
public Book GetBook(GetBook model) { try { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@Id", model.Id); Book list = SqlMapper.Query <Book>(con, "sp_GetBook", param: parameters, commandType: CommandType.StoredProcedure).FirstOrDefault(); return(list); } catch (Exception ex) { throw ex; } }
public async Task <IActionResult> Get(Guid id) { if (id == Guid.Empty) { return(BadRequest()); } var command = new GetBook(id, UserId); var result = await Mediator.Send(command); if (result == null) { return(NotFound()); } return(Ok(result)); }
private void btnAddBook_Click(object sender, EventArgs e) { try { if (int.Parse(dgvStockInfo.CurrentRow.Cells[7].Value.ToString()) - int.Parse(txtNum.Text) < 0) { MessageBox.Show("输入的数量大于库存数量"); } else { GetBook gb = new GetBook(); gb.GetBookNum = int.Parse(txtNum.Text); gb.ISBN = txtISBN.Text; gb.Signer = txtSigner.Text; gb.SignerPhone = txtSignerPhone.Text; gb.SignerIdentity = cmbIdentity.Text; if (cmbIdentity.SelectedItem.ToString() == "学生代表") { StudentClass student = common.GetAllCollegeInfo_Class(cmbStudentClass.Text); //以下拉框班级的文本值作参数调用方法GetAllCollegeInfo_Class()并赋值给实体类 gb.MajorInfoID = student.MajorInfoID; //获取实体类StudentClass中的专业编号赋值给实体类PlanBook中的专业编号 gb.StudentClassID = student.StudentClassID; //获取实体类StudentClass中的学院编号赋值给实体类PlanBook中的学院编号 gb.SchoolTermID = cmbSchoolTerm.SelectedIndex; //获取下拉框学年学期的索引值并赋值给实体类PlanBook里面的SchoolTermID字段 gb.CollegeID = cmbCollege.SelectedIndex; //获取下拉框学院名称的索引值并赋值给实体类PlanBook里面的CollegeID字段 } else { gb.CollegeID = 0; gb.SchoolTermID = 0; gb.StudentClassID = 0; } bllgb.UpdateGetBook(gb); DgvInfo(); text(); } } catch (Exception) { MessageBox.Show("请检查输入的值的类型是否正确"); //throw; } }
public void UpdateGetBook(GetBook gb) { SqlTransaction sqltran; using (SqlConnection conn = new SqlConnection(DBHelpers.Connection)) { conn.Open(); string sql1 = ""; string sql2 = "update BookStock set ArriveQuantity=ArriveQuantity-@GetBookNum2 where PlanBookID=(select PlanBookID from PlanBook where ISBN=@ISBN2) "; SqlCommand scm = new SqlCommand(); scm.Connection = conn; sqltran = conn.BeginTransaction(); scm.Transaction = sqltran; scm.Parameters.AddWithValue("@ISBN", gb.ISBN); scm.Parameters.AddWithValue("@GetBookNum", gb.GetBookNum); scm.Parameters.AddWithValue("@Signer", gb.Signer); scm.Parameters.AddWithValue("@SigerIdentity", gb.SignerIdentity); scm.Parameters.AddWithValue("@SigerPhone", gb.SignerPhone); if (gb.CollegeID == 0) { sql1 = "insert into GetBook(PlanBookID,GetBookNum,Signer,SignerIdentity,SignerPhone) select 'PlanBookID'=(select PlanBookID from PlanBook where ISBN=@ISBN),@GetBookNum,@Signer,@SigerIdentity,@SigerPhone"; } else { sql1 = "insert into GetBook(PlanBookID,GetBookNum,Signer,SignerIdentity,SignerPhone,CollegeID,StudentClassID,SchoolTermID) select 'PlanBookID'=(select PlanBookID from PlanBook where ISBN=@ISBN),@GetBookNum,@Signer,@SigerIdentity,@SigerPhone,@CollegeID,@StudentClassID,@SchoolTermID"; scm.Parameters.AddWithValue("@CollegeID", gb.CollegeID); scm.Parameters.AddWithValue("@StudentClassID", gb.StudentClassID); scm.Parameters.AddWithValue("@SchoolTermID", gb.SchoolTermID); } scm.CommandText = sql1; scm.ExecuteNonQuery(); scm.CommandText = sql2; scm.Parameters.AddWithValue("@GetBookNum2", gb.GetBookNum); scm.Parameters.AddWithValue("@ISBN2", gb.ISBN); scm.ExecuteNonQuery(); sqltran.Commit(); } }
static public IQueryable <Book> ParseBook(GetBook book, IQueryable <Book> query) { if (book != null) { if (!String.IsNullOrEmpty(book.BookTitle)) { query = query.Where(w => w.Title.Contains(book.BookTitle)); } if (!String.IsNullOrEmpty(book.BookAuthor)) { query = query.Where(w => w.Author.Name.Contains(book.BookAuthor)); } if (!String.IsNullOrEmpty(book.BookGenre)) { query = query.Where(w => w.Genre.DisplayName.Contains(book.BookGenre)); } } return(query); }
public void UpdateGetBook(GetBook gb) { dalgb.UpdateGetBook(gb); }
public IActionResult Book(GetBook model) { return(View(_bookRepository.GetBook(model))); }
public async Task <Book> Handle(GetBook request, CancellationToken cancellationToken) => await BookEntityHandler.Get(request.Id);