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