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