public void Initialize() { tran = new TransactionScope(); using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand command = new SqlCommand("insert into company values('testCompany', 'companyP')", connection); command.ExecuteNonQuery(); command = new SqlCommand("insert into user_info values('testUser', 'testUPas', (select company_id from company where company.password = '******' and company.name = 'testCompany'))", connection); command.ExecuteNonQuery(); command = new SqlCommand("insert into my_transaction values(1, 'revenue item', 900, '10/12/2012', (select company_id from user_info where user_name = 'testUser' and password = '******'), (select user_id from user_info where user_name = 'testUser' and password = '******'))", connection); command.ExecuteNonQuery(); command = new SqlCommand("insert into my_transaction values(0, 'expense item', 900, '10/12/2012', (select company_id from user_info where user_name = 'testUser' and password = '******'), (select user_id from user_info where user_name = 'testUser' and password = '******'))", connection); command.ExecuteNonQuery(); } u = CreateUser(); t = CreateTestTransaction(); }
//HelperMethod to create transaction private ModelClasses.Transaction CreateTestTransaction() { ModelClasses.Transaction t = new ModelClasses.Transaction() { IsRevenue = false, Description = "Rent", Amount = 1005.24, Date = DateTime.Now, }; return(t); }