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