public static void InsertRecord(StandardCollationModel standardCollation)
{
var sqlToInsertStandardCollation =
"INSERT INTO [dbo].[StandardCollation]" +
"([StandardId]" +
",[ReferenceNumber]" +
",[Title]" +
",[StandardData]" +
",[IsLIve])" +
"VALUES" +
"(@standardId" +
",@referenceNumber" +
",@Title" +
",@standardData" +
",@isLive);";
DatabaseService.Execute(sqlToInsertStandardCollation, standardCollation);
var sqlToInsertOption =
"INSERT INTO [dbo].[Options]" +
"([StdCode]" +
",[OptionName]" +
",[IsLive])" +
"VALUES" +
"(@stdCode" +
",@optionName" +
",@isLive);";
foreach (var optionDataModel in standardCollation.Options)
{
DatabaseService.Execute(sqlToInsertOption, optionDataModel);
}
}
public static void InsertRecord(StandardCollationModel standardCollation)
{
var sqlToInsert = @"INSERT INTO [dbo].[StandardCollation]
([StandardId]
,[ReferenceNumber]
,[Title]
,[StandardData])
VALUES
(@standardId
,@referenceNumber
,@Title
,@standardData);";
DatabaseService.Execute(sqlToInsert, standardCollation);
}
public void SetupOrganisationTests()
{
_databaseConnection = new SqlConnection(_databaseService.WebConfiguration.SqlConnectionString);
_unitOfWork = new UnitOfWork(_databaseConnection);
_repository = new StandardRepository(_unitOfWork);
_standardId1 = 1;
_standardId2 = 10;
_standardId3 = 100;
_referenceNumber1 = "ST0001";
_referenceNumber2 = "ST0010";
_title1 = "Standard 1";
_title2 = "Standard title 2";
_title3 = "standard title 3";
_standardDataLevel1 = 4;
_standardData1 = "{\"Level\": " + _standardDataLevel1 + " }";
_standardCollation1 = new StandardCollationModel
{
StandardId = _standardId1,
ReferenceNumber = _referenceNumber1,
Title = _title1,
StandardData = _standardData1
};
_standardCollation2 = new StandardCollationModel
{
StandardId = _standardId2,
ReferenceNumber = _referenceNumber2,
Title = _title2,
StandardData = null
};
_standardCollation3 = new StandardCollationModel
{
StandardId = _standardId3,
ReferenceNumber = null,
Title = _title3,
StandardData = null
};
StandardCollationHandler.InsertRecords(new List <StandardCollationModel> {
_standardCollation1, _standardCollation2, _standardCollation3
});
}
