public async Task Core_Data_StoredProcedure_Update()
{
var testItem = new CustomerInfo();
var reader = new EntityReader <CustomerInfo>(new ConnectionStringFactory().GetDefaultConnection());
var customerTests = new CustomerInfoTests();
await customerTests.Core_Entity_CustomerInfo_Insert();
testItem = reader.GetByKey(CustomerTests.RecycleBin.LastOrDefault());
var updateProc = new StoredProcedure <CustomerInfo>()
{
StoredProcedureName = "CustomerInfoUpdate",
Parameters = new List <SqlParameter>()
{
new SqlParameter("@Key", testItem.Key),
new SqlParameter("@FirstName", testItem.FirstName),
new SqlParameter("@MiddleName", testItem.MiddleName),
new SqlParameter("@LastName", testItem.LastName),
new SqlParameter("@BirthDate", testItem.BirthDate),
new SqlParameter("@GenderId", testItem.GenderId),
new SqlParameter("@CustomerTypeId", testItem.CustomerTypeId)
}
};
Assert.IsTrue(updateProc.StoredProcedureName.Length > 0);
Assert.IsTrue(updateProc.Parameters.Count() > 0);
}
public async Task Core_Data_StoredProcedure_Delete()
{
var testItem = new CustomerInfo();
var reader = new EntityReader <CustomerInfo>(new ConnectionStringFactory().GetDefaultConnection());
var customerTests = new CustomerInfoTests();
await customerTests.Core_Entity_CustomerInfo_Insert();
testItem = reader.GetByKey(CustomerTests.RecycleBin.LastOrDefault());
var deleteProc = new StoredProcedure <CustomerInfo>()
{
StoredProcedureName = "CustomerInfoDelete",
Parameters = new List <SqlParameter>()
{
new SqlParameter("@Key", testItem.Key)
}
};
Assert.IsTrue(deleteProc.StoredProcedureName.Length > 0);
Assert.IsTrue(deleteProc.Parameters.Count() > 0);
}
public static async Task ClassInit(TestContext context)
{
// Database is required for these tests
var databaseAccess = false;
using (var connection = new SqlConnection(new ConnectionStringFactory().GetDefaultConnection()))
{
databaseAccess = connection.CanOpen();
}
Assert.IsTrue(databaseAccess, @"App_Data\\ConnectionStrings.config DefaultConnection is not able to connect to SQL Server. Please check your connection string and try again.");
// Need a few records to test with across all functions
var customerTests = new CustomerInfoTests();
await customerTests.Core_Entity_CustomerInfo_Insert();
await customerTests.Core_Entity_CustomerInfo_Insert();
await customerTests.Core_Entity_CustomerInfo_Insert();
await customerTests.Core_Entity_CustomerInfo_Insert();
await customerTests.Core_Entity_CustomerInfo_Insert();
}
public static async Task Cleanup()
{
await CustomerInfoTests.Cleanup();
}
