public ClassicMasterProperty FindMasterProperty(int link)
{
using (var vsiData = new VSI_DATAContext())
{
var masterProperty = new Master_Property_Repository(vsiData).Properties.FirstOrDefault(n => n.Master_Property_Link == link);
var adapter = new ClassicMasterPropertyAdapter(_codeResolver);
return(adapter.Translate(masterProperty));
}
}
public ClassicImage FindImageByMasterNameLink(int masterNameLink)
{
using (var vsiData = new VSI_DATAContext())
{
return(new Images_Repository(vsiData).Images.Where(o => o.Master_Name_Link == masterNameLink)
.Select(ClassicImageProjection)
.FirstOrDefault());
}
}
public ClassicMasterAddress FindMasterAddress(int link)
{
using (var vsiData = new VSI_DATAContext())
{
var masterAddress = new Master_Address_Repository(vsiData).Addresses.FirstOrDefault(n => n.Master_Address_Link == link);
var adapter = new ClassicMasterAddressAdapter(_codeResolver);
return(adapter.Translate(masterAddress));
}
}
public ClassicMasterVehicle FindMasterVehicle(int link)
{
using (var vsiData = new VSI_DATAContext())
{
var masterVehicle = new Master_Vehicle_Repository(vsiData).Vehicles.FirstOrDefault(n => n.Master_Vehicle_Link == link);
var adapter = new ClassicMasterVehicleAdapter(_codeResolver);
return(adapter.Translate(masterVehicle));
}
}
/// <summary>
/// Finds the Master Name Alias (Person) with the given Master Name Alias link.
/// </summary>
public ClassicMasterAlias FindMasterNameAlias(int link)
{
using (var vsiData = new VSI_DATAContext())
{
var masterNameAlias = new Master_Name_Alias_Repository(vsiData).PersonAliases.FirstOrDefault(n => n.Master_Name_Alias_Link == link);
var adapter = new ClassicMasterAliasAdapter(_codeResolver);
return(adapter.Translate(masterNameAlias));
}
}
public ClassicBodyMarks FindBodyMark(int bodyMarkLink)
{
using (var vsiData = new VSI_DATAContext())
{
var bodyMarks = new Master_Name_BodyMark_Repository(vsiData).BodyMarks.FirstOrDefault(n => n.BodyMarks_Link == bodyMarkLink);
var adapter = new ClassicBodyMarksAdapter(_codeResolver);
return(adapter.Translate(bodyMarks));
}
}
/// <summary>
/// Finds all aliases of the business with the given Master Name link.
/// </summary>
public List <ClassicMasterAlias> FindMasterBusinessAliases(int masterPersonLink)
{
var aliases = new List <ClassicMasterAlias>();
using (var vsiData = new VSI_DATAContext())
{
var adapter = new ClassicMasterAliasAdapter(_codeResolver);
foreach (
var alias in
new Master_Name_Alias_Repository(vsiData).BusinessAliases.Where(
n => n.Master_Name_Link == masterPersonLink))
{
aliases.Add(adapter.Translate(alias));
}
}
return(aliases);
}
public List <ClassicBodyMarks> FindBodyMarks(int masterPersonLink)
{
var bodyMarks = new List <ClassicBodyMarks>();
using (var vsiData = new VSI_DATAContext())
{
var adapter = new ClassicBodyMarksAdapter(_codeResolver);
foreach (
var bodyMark in
new Master_Name_BodyMark_Repository(vsiData).BodyMarks.Where(
n => n.Master_Name_Link == masterPersonLink))
{
bodyMarks.Add(adapter.Translate(bodyMark));
}
}
return(bodyMarks);
}
private bool BodyMarkChangedOrNew(ScarMarkTattoo scarMarkTattoo)
{
using (var vsiData = new VSI_DATAContext())
{
BodyMarks bodyMarks = new Master_Name_BodyMark_Repository(vsiData).BodyMarks.FirstOrDefault(n => n.BodyMarks_Link == scarMarkTattoo.BodyMarkId);
if (bodyMarks == null)
{
return(true);
}
else
{
if (IsNotEqual(scarMarkTattoo.SMT.Code, bodyMarks.SMT))
{
return(true);
}
if (IsNotEqual(scarMarkTattoo.TypeSMT.Description, bodyMarks.Type_SMT))
{
return(true);
}
if (scarMarkTattoo.Active.ToUpper() == "TRUE" && bodyMarks.Active != true)
{
return(true);
}
if (scarMarkTattoo.Active.ToUpper() == "FALSE" && bodyMarks.Active != false)
{
return(true);
}
if (IsNotEqual(scarMarkTattoo.Description, bodyMarks.Description))
{
return(true);
}
if (IsNotEqual(scarMarkTattoo.Location.Description, bodyMarks.Location))
{
return(true);
}
if (IsNotEqual(scarMarkTattoo.NCICSMT.Code, bodyMarks.NCIC_SMT))
{
return(true);
}
}
}
return(false);
}
public Stream GetImageThumbnail(long id)
{
// TODO: Come back to this method. Ideally, we could stream the data right out of the database, but this
// may be OK right now because the thumbnails are almost always guaranteed not to be large.
MemoryStream stream = null;
using (var vsiData = new VSI_DATAContext())
{
var image = new Images_Repository(vsiData).Images.Where(o => o.Images_Link == id)
.Select(i => i.The_ThumbNail)
.FirstOrDefault();
if (image != null)
{
// Note: It is the caller's responsibility to close the stream.
stream = new MemoryStream(image);
}
}
return(stream);
}
public MasterAddressProcessor()
{
_vsiData = new VSI_DATAContext();
}
public MasterScarMarkTattooProcessor(IMasterScarMarkTattooResolver scarMarkTattooResolver)
{
_vsiData = new VSI_DATAContext();
_scarMarkTattooResolver = scarMarkTattooResolver;
}
public MasterNameProcessor(IMasterPersonResolver masterpersonResolver)
{
_vsiData = new VSI_DATAContext();
_masterpersonResolver = masterpersonResolver;
}
public ResolveMasterName(VSI_DATAContext vsiData, IPerson person)
{
_person = person;
_vsiData = vsiData;
}
public Master_Property_Repository(VSI_DATAContext vsiDataContext)
{
_vsiDataContext = vsiDataContext;
}
public MasterScarMarkTattooResolver()
{
_vsiData = new VSI_DATAContext();
}
public MasterGunResolver()
{
_vsiData = new VSI_DATAContext();
}
public MasterPropertyProcessor(IMasterPropertyResolver masterPropertyResolver)
{
_vsiData = new VSI_DATAContext();
_masterPropertyResolver = masterPropertyResolver;
}
public Master_Name_Repository(VSI_DATAContext vsiDataContext)
{
_vsiDataContext = vsiDataContext;
}
public MasterGunProcessor(IMasterGunResolver masterGunResolver)
{
_vsiData = new VSI_DATAContext();
_masterGunResolver = masterGunResolver;
}
public MasterVehicleResolver()
{
_vsiData = new VSI_DATAContext();
}
public MasterPropertyResolver()
{
_vsiData = new VSI_DATAContext();
}
public Images_Repository(VSI_DATAContext vsiDataContext)
{
_vsiDataContext = vsiDataContext;
}
public MasterPersonResolver(IClassicRMSMasterIndicesRepository repository)
{
_repository = repository;
_vsiData = new VSI_DATAContext();
}
public MasterVehicleProcessor(IMasterVehicleResolver masterVehicleResolver)
{
_vsiData = new VSI_DATAContext();
_masterVehicleResolver = masterVehicleResolver;
}
