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