public void When_Invalid_ViewModel_Return_Model_To_View() { booksController.ModelState.AddModelError("fel", "fel"); var createBook = new CreateBook(); var result = (ViewResult)booksController.Create(createBook); Assert.That(result.Model, Is.SameAs(createBook)); }
public ActionResult Create(CreateBook createBook) { if(!ModelState.IsValid) { return View(createBook); } booksRepository.Save(new Book{ Title = createBook.Title }); return RedirectToAction("Index"); }
public string[] createBookDataBase(CreateBook bookData) { string[] returnValue = new string[2]; returnValue[0] = "0"; returnValue[1] = "0"; DataBase Base = new DataBase(); using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString())) { try { StaffDataBase sDB = new StaffDataBase(); List<string> CreateFileName = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name); Sqlconn.Open(); string sql = "INSERT INTO BookDatabase (Unit, BookCodeID, BookName, CategoryID, Author, Press, PressDate, Remark, ArchivingDate, Status, " + "CreateFileBy, CreateFileDate, UpFileBy, UpFileDate, isDeleted ,bookUseTo,bookComefrom ,bookGeter,bookScrapstatus) VALUES " + "(@Unit, @BookCodeID, @BookName, @CategoryID, @Author, @Press, @PressDate, @Remark, @ArchivingDate, 1, " + "@CreateFileBy, (getDate()), @UpFileBy, (getDate()), 0 , @bookUseTo,@bookComefrom ,@bookGeter,@bookScrapstatus)"; // bookUseTo,bookComefrom ,bookGeter,bookScrapstatus SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@Unit", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(CreateFileName[2]); cmd.Parameters.Add("@BookCodeID", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(bookData.bookNumber); cmd.Parameters.Add("@BookName", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(bookData.bookTitle); cmd.Parameters.Add("@CategoryID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(bookData.bookClassification); cmd.Parameters.Add("@Author", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(bookData.bookAuthor); cmd.Parameters.Add("@Press", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(bookData.bookPress); cmd.Parameters.Add("@PressDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(bookData.bookPressDate); cmd.Parameters.Add("@Remark", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(bookData.bookRemark); cmd.Parameters.Add("@ArchivingDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(bookData.bookFilingDate); cmd.Parameters.Add("@CreateFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]); cmd.Parameters.Add("@UpFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]); cmd.Parameters.Add("@bookUseTo", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(bookData.bookUseTo); cmd.Parameters.Add("@bookComefrom", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(bookData.bookComefrom); cmd.Parameters.Add("@bookGeter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(bookData.bookGeter); cmd.Parameters.Add("@bookScrapstatus", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(bookData.bookScrapstatus); returnValue[0] = cmd.ExecuteNonQuery().ToString(); if (returnValue[0] != "0") { Int64 Column = 0; sql = "select IDENT_CURRENT('BookDatabase') AS bID"; cmd = new SqlCommand(sql, Sqlconn); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { Column = Int64.Parse(dr["bID"].ToString()); } dr.Close(); if (Column != 0) { // sql = "SELECT Count(*) AS QCOUNT FROM BookDatabase WHERE CategoryID=(@CategoryID) and Unit = @Unit "; sql = "SELECT top 1 CAST (SUBSTRING(BookCodeID,6,4 ) as int) AS QCOUNT FROM BookDatabase WHERE CategoryID=(@CategoryID) and Unit = @Unit order by BookCodeID desc "; cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@CategoryID", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(bookData.bookClassification); cmd.Parameters.Add("@Unit", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(CreateFileName[2]); SqlDataReader dr2 = cmd.ExecuteReader(); string stuNumber = "1"; if (dr2.Read()) { stuNumber = (Chk.CheckStringtoIntFunction(dr2["QCOUNT"].ToString()) + 1).ToString();//cmd.ExecuteScalar().ToString(); } dr2.Close(); string stuIDName = CreateFileName[2] + Chk.CheckStringFunction(bookData.bookClassificationCode) + stuNumber.PadLeft(4, '0'); sql = "UPDATE BookDatabase SET BookCodeID=(@BookCodeID) WHERE BookID=(@BID) "; cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@BID", SqlDbType.BigInt).Value = Column; cmd.Parameters.Add("@BookCodeID", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(stuIDName); returnValue[0] = cmd.ExecuteNonQuery().ToString(); } } Sqlconn.Close(); } catch (Exception e) { returnValue[0] = "-1"; returnValue[1] = e.Message.ToString(); } } return returnValue; }
public List<CreateBook> searchBook(int indexpage, SearchBook bookData) { List<CreateBook> returnValue = new List<CreateBook>(); DataBase Base = new DataBase(); string ConditionReturn = this.SearchBookConditionReturn(bookData, "BookDatabase"); using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString())) { try { StaffDataBase sDB = new StaffDataBase(); List<string> CreateFileName = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name); Sqlconn.Open(); string sql = "SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY BookDatabase.BookID DESC) " + "AS RowNum, BookDatabase.*, BookCategory.CategoryCode, BookCategory.CategoryName FROM BookDatabase " + "RIGHT JOIN BookCategory ON BookDatabase.CategoryID=BookCategory.ID " + "WHERE BookDatabase.isDeleted=0 " + ConditionReturn + " ) " + "AS NewTable " + "WHERE RowNum >= (@indexpage-" + PageMinNumFunction() + ") AND RowNum <= (@indexpage)"; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@indexpage", SqlDbType.Int).Value = indexpage; cmd.Parameters.Add("@txtbookNumber", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(bookData.txtbookNumber); cmd.Parameters.Add("@txtbookTitle", SqlDbType.NVarChar).Value = "%" + Chk.CheckStringFunction(bookData.txtbookTitle) + "%"; cmd.Parameters.Add("@txtbookClassification", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(bookData.txtbookClassification); cmd.Parameters.Add("@txtbookAuthor", SqlDbType.NVarChar).Value = "%" + Chk.CheckStringFunction(bookData.txtbookAuthor) + "%"; cmd.Parameters.Add("@txtbookPress", SqlDbType.NVarChar).Value = "%" + Chk.CheckStringFunction(bookData.txtbookPress) + "%"; SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { CreateBook addValue = new CreateBook(); addValue.bID = dr["BookID"].ToString(); addValue.bookNumber = dr["BookCodeID"].ToString(); addValue.bookTitle = dr["BookName"].ToString(); addValue.bookClassification = dr["CategoryID"].ToString(); addValue.bookClassificationCode = dr["CategoryCode"].ToString(); addValue.bookClassificationName = dr["CategoryName"].ToString(); addValue.bookAuthor = dr["Author"].ToString(); addValue.bookPress = dr["Press"].ToString(); addValue.bookPressDate = DateTime.Parse(dr["PressDate"].ToString()).ToString("yyyy-MM-dd"); addValue.bookRemark = dr["Remark"].ToString(); addValue.bookFilingDate = DateTime.Parse(dr["ArchivingDate"].ToString()).ToString("yyyy-MM-dd"); addValue.bookStatus = dr["Status"].ToString(); addValue.bookScrapstatus = dr["bookScrapstatus"].ToString(); addValue.bookUseTo = dr["bookUseto"].ToString(); addValue.bookGeter = dr["bookgeter"].ToString(); addValue.bookComefrom = dr["bookcomefrom"].ToString(); addValue.checkNo = "1"; returnValue.Add(addValue); } dr.Close(); Sqlconn.Close(); } catch (Exception e) { CreateBook addValue = new CreateBook(); addValue.checkNo = "-1"; addValue.errorMsg = e.Message.ToString(); returnValue.Add(addValue); } } return returnValue; }
public string[] GetBookIDData(CreateBook bookData) { string[] returnValue = new string[2]; returnValue[0] = ""; DataBase Base = new DataBase(); using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString())) { try { StaffDataBase sDB = new StaffDataBase(); List<string> CreateFileName = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name); Sqlconn.Open(); string sql = ""; //sql = "SELECT Count(*) AS QCOUNT FROM BookDatabase WHERE CategoryID=(@CategoryID) and Unit = @Unit "; sql = "SELECT top 1 CAST (SUBSTRING(BookCodeID,6,4 ) as int) AS QCOUNT FROM BookDatabase WHERE CategoryID=(@CategoryID) and Unit = @Unit order by BookCodeID desc "; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@CategoryID", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(bookData.bookClassification); cmd.Parameters.Add("@Unit", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(CreateFileName[2]); SqlDataReader dr = cmd.ExecuteReader(); string stuNumber = "1"; if (dr.Read()) { stuNumber = (Chk.CheckStringtoIntFunction(dr["QCOUNT"].ToString()) + 1).ToString(); } returnValue[0] = CreateFileName[2] + Chk.CheckStringFunction(bookData.bookClassificationCode) + stuNumber.PadLeft(4, '0'); //returnValue = stuIDName; } catch { } finally { Sqlconn.Close(); } } return returnValue; }
public IActionResult Post([FromBody] CreateBook command) { _booksManagerActor.Tell(command); return(Accepted()); }
public ConsoleReaderActor(IActorFactory actorFactory) { _actorFactory = actorFactory; ReceiveAsync <object>(async _ => { _consoleWriterActor.Tell(new Messages.ConsoleWriterMessages.PrintInstructions()); var read = Console.ReadLine(); switch (read) { case "1": CreateBook createBook = new CreateBook("Domain-driven design", "Eric J. Evans", 500, 20); _booksManagerActor.Tell(createBook); break; case "2": var books = await _booksManagerActor.Ask <IEnumerable <BookDto> >(GetBooks.Instance); string json = JsonConvert.SerializeObject(books, Formatting.Indented); _consoleWriterActor.Tell(new Messages.ConsoleWriterMessages.PrintMessage { Message = json }); break; case "3": BookDto bookDto = null; var latestGuid = await _booksManagerActor.Ask <Guid>(new GetLatestGuid()); if (latestGuid != null) { bookDto = await _booksManagerActor.Ask <BookDto>(new GetBookById(latestGuid)); } if (bookDto == null) { _consoleWriterActor.Tell(new Messages.ConsoleWriterMessages.PrintMessage { Message = "Not found" }); } else { string jsonBookDto = JsonConvert.SerializeObject(bookDto, Formatting.Indented); _consoleWriterActor.Tell(new Messages.ConsoleWriterMessages.PrintMessage { Message = jsonBookDto }); } break; case "4": _badActorActor.Tell(new Messages.BadActorMessage.DoThrowUnknownExcpetion()); break; case "5": _badActorActor.Tell(new Messages.BadActorMessage.DoThrownArithmeticException()); break; case "6": _badActorActor.Tell(new Messages.BadActorMessage.DoThrownInsanelyBadException()); break; case "7": _badActorActor.Tell(new Messages.BadActorMessage.DoNotSupportedException()); break; default: if (!string.IsNullOrEmpty(read) && String.Equals(read, ExitCommand, StringComparison.OrdinalIgnoreCase)) { // shut down the system (acquire handle to system via // this actors context) Context.System.Terminate(); return; } break; } Self.Tell("continue"); }); }
public async Task <IActionResult> Post(CreateBook book) { var result = await _mediator.Send(book); return(Ok(result)); }
public async Task <ActionResult> Post([FromBody] CreateBook command) { await CommandDispatcher.DispatchAsync(command); return(Created("books", new object())); }
public SingleBook CreateBook(CreateBook book) => (SingleBook)Send.Post <SingleBook>(MainPoint, HttpStatusCode.OK, book);
public string[] createBookDataBase(CreateBook bookData) { AdministrationDataBase aDB = new AdministrationDataBase(); aDB.libraryFunction(); if (int.Parse(aDB._StaffhaveRoles[2]) == 1) { return aDB.createBookDataBase(bookData); } else { return new string[2] { _noRole, _errorMsg }; } }