예제 #1
0
 public void CreateBook(Book book)
 {
     using (SqlConnection connection = base.GetConnection())
     {
         SqlCommand command = new SqlCommand("_BookUpdate", connection) {
             CommandType = CommandType.StoredProcedure
         };
         command.Parameters.AddWithValue("@Type", 0);
         command.Parameters.AddWithValue("@BookID", 0);
         command.Parameters.AddWithValue("@ProductID", book.ProductID);
         command.Parameters.AddWithValue("@FromDate", book.FromDate);
         command.Parameters.AddWithValue("@ToDate", book.ToDate);
         command.Parameters.AddWithValue("@Actived", book.Actived);
         command.Parameters.AddWithValue("@FullName", book.FullName);
         command.Parameters.AddWithValue("@Email", book.Email);
         command.Parameters.AddWithValue("@Phone", book.Phone);
         command.Parameters.AddWithValue("@Address", book.Address);
         command.Parameters.AddWithValue("@Road", book.Road);
         command.Parameters.AddWithValue("@Other", book.Other);
         command.Parameters.AddWithValue("@FromCity", book.FromCity);
         command.Parameters.AddWithValue("@ToCity", book.ToCity);
         command.Parameters.AddWithValue("@FromDistrict", book.FromDistrict);
         command.Parameters.AddWithValue("@FromAddress", book.FromAddress);
         command.Parameters.AddWithValue("@ToDistrict", book.ToDistrict);
         command.Parameters.AddWithValue("@ToAddress", book.ToAddress);
         connection.Open();
         if (command.ExecuteNonQuery() <= 0)
         {
             throw new DataAccessException("Lỗi kh\x00f4ng thể tao moi");
         }
         command.Dispose();
     }
 }
예제 #2
0
 public void UpdateBook(Book book)
 {
     new BookDAO().UpdateBook(book);
 }
예제 #3
0
 public void CreateBook(Book book)
 {
     new BookDAO().CreateBook(book);
 }