public ActionResult Edit(BookDataObject book)
{
CommandServiceClient commandService = new CommandServiceClient();
commandService.UpdateBook(book.AggregateRootId, book.Title, book.Author, book.Description, book.ISBN, book.Pages, book.Inventory);
commandService.Close();
return(RedirectToAction("Index", "Books"));
}
public ActionResult Create(BookDataObject book)
{
CommandServiceClient commandService = new CommandServiceClient();
commandService.AddBook(book.Title, book.Author, book.Description, book.ISBN, book.Pages, book.Inventory);
commandService.Close();
return(RedirectToAction("Index"));
}
private void ConvertFromReader(SqlDataReader reader, BookDataObject obj)
{
obj.Author = Convert.ToString(reader["Author"]);
obj.Description = Convert.ToString(reader["Description"]);
obj.Inventory = Convert.ToInt32(reader["Inventory"]);
obj.ISBN = Convert.ToString(reader["ISBN"]);
obj.Pages = Convert.ToInt32(reader["Pages"]);
obj.Title = Convert.ToString(reader["Title"]);
obj.ID = Guid.Parse(Convert.ToString(reader["ID"]));
obj.AggregateRootId = Convert.ToInt64(reader["AggregateRootId"]);
}
public BookDataObject GetBookByGuid(Guid guid)
{
BookDataObject book = null;
string sql = @"SELECT * FROM [Books] WHERE [ID]=@id";
using (SqlDataReader reader = SqlHelper.ExecuteReader(this.QueryDBConnectionString,
CommandType.Text,
sql,
new SqlParameter("@id", guid)))
{
while (reader.Read())
{
book = new BookDataObject();
this.ConvertFromReader(reader, book);
break;
}
reader.Close();
}
return(book);
}
public List <BookDataObject> GetBooks()
{
BookDataObject book = null;
List <BookDataObject> books = new List <BookDataObject>();
string sql = "SELECT * FROM [Books]";
using (SqlDataReader reader = SqlHelper.ExecuteReader(this.QueryDBConnectionString,
CommandType.Text,
sql))
{
while (reader.Read())
{
book = new BookDataObject();
this.ConvertFromReader(reader, book);
books.Add(book);
}
reader.Close();
}
return(books);
}
