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