public void Initialize()
{
tran = new TransactionScope();
dal = new CardSqlDAL(connectionString);
//Add a test deck
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
Deck test = new Deck()
{
Name = "Test Deck",
Description = "Test Decription",
DateCreated = DateTime.Now,
PublicDeck = false,
ForReview = false,
UserId = 1
};
SqlCommand cmd = new SqlCommand("INSERT INTO decks (name, description, date_created, is_public, for_review, users_id) VALUES (@name, @desc, @date_created, @is_public, @for_review, @user_id); SELECT CAST(SCOPE_IDENTITY() as int);", conn);
cmd.Parameters.AddWithValue("@name", test.Name);
cmd.Parameters.AddWithValue("@desc", test.Description);
cmd.Parameters.AddWithValue("@date_created", test.DateCreated);
cmd.Parameters.AddWithValue("@is_public", test.PublicDeck);
cmd.Parameters.AddWithValue("@for_review", test.ForReview);
cmd.Parameters.AddWithValue("@user_id", test.UserId);
testDeckId = (int)cmd.ExecuteScalar();
}
}
public DecksController(IDeckDAL decksSqlDAL, ICardDAL cardSqlDAL, ITagDAL tagSqlDAL, IUsersDAL userSqlDAL, IAuthProvider authProvider)
{
this.decksSqlDAL = decksSqlDAL;
this.cardSqlDAL = cardSqlDAL;
this.tagSqlDAL = tagSqlDAL;
this.userSqlDAL = userSqlDAL;
this.authProvider = authProvider;
}
public void Initialize()
{
tran = new TransactionScope();
dal = new DeckSqlDAL(connectionString);
cardDal = new CardSqlDAL(connectionString);
usersDeckCount = dal.GetDecksbyUserId(1).Count;
testDeck = new Deck()
{
Name = "Test Deck",
Description = "Test Decription",
DateCreated = DateTime.Now,
PublicDeck = false,
ForReview = false,
UserId = 1
};
testDeckId = dal.CreateDeck(testDeck);
}
public CardService(ICardDAL cardDAL)
{
this.cardDAL = cardDAL;
}
public DeckSqlDAL(string connectionString)
{
this.connectionString = connectionString;
cardSqlDAL = new CardSqlDAL(connectionString);
}
