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