private static void LoadSMTCodes(RMSSystem rmsSystem) { using (var conn = new SqlConnection(Settings.Classic)) { conn.Open(); using (var smtCodesData = new DataSet()) { const string smtSelect = "SELECT DISTINCT [Image_Code_Link], [Category], [Code], [Description], [Code_Name], [Global] ,[Code_Length] FROM [VSI_SYSTEM].[dbo].[Image_Code] WHERE Category IN ('SMT', 'ABP', 'BOD', 'MCD', 'MDB', 'PDF')"; using (var adapter = new SqlDataAdapter(smtSelect, conn)) adapter.Fill(smtCodesData, "ImageInfo"); Log.Info("Importing {0} SMT Codes for Scars/Marks", smtCodesData.Tables["ImageInfo"].Rows.Count); foreach (DataRow smtCodeRow in smtCodesData.Tables["ImageInfo"].Rows) { // Find or create SMT Code record var classicId = Convert.ToInt32(smtCodeRow["Image_Code_Link"].ToString()); var imageInfo = (rmsSystem.ImageInfo).FirstOrDefault(i => i.ClassicId == classicId); if (imageInfo == null) { var category = (smtCodeRow["Category"] as string).Trim(); var code = (smtCodeRow["Code"] as string).Trim(); var description = (smtCodeRow["Description"] as string).Trim(); var codeName = (smtCodeRow["Code_Name"] as string).Trim(); var global = smtCodeRow["Global"] as bool?; var codeLength = smtCodeRow["Code_Length"] as int?; rmsSystem.CreateImageInfo(classicId, category, code, description, codeName, global, codeLength); } } } } }
public void CreateImageInfo() { var result = rmssystem.CreateImageInfo(123, "data", "data", "data", "data", true, 1); result.Should().BeOfType(typeof(ImageInfo)); }