public static Guid GetAddressTypeId(String title)
{
if (title == null || title == "") return Guid.Empty;
HITSWContext db = new HITSWContext();
Lookup_AddrType address_type = db.Lookup_AddrType.Where(e => e.ActiveRec == true && e.Title.Equals(title)).First();
db.Dispose();
return address_type.Id;
}
public static String GetEthnicityFromId(Guid id)
{
HITSWContext db = new HITSWContext();
var model = db.Lookup_Ethnicity.Find(id);
db.Dispose();
if (model == null) return "";
return model.Title;
}
public static String GetVirtualAddressTypeFromId(Guid id)
{
HITSWContext db = new HITSWContext();
var virtualaddress = db.Lookup_AddrType.Find(id);
db.Dispose();
if (virtualaddress == null) return "";
return virtualaddress.Title;
}
public static String GetVeteranFromId(Guid id)
{
HITSWContext db = new HITSWContext();
var model = db.Lookup_AddrBk.Find(id);
db.Dispose();
if (model == null) return "";
return model.Title;
}
public static String GetSalutationFromId(Guid id)
{
HITSWContext db = new HITSWContext();
var model = db.Lookup_GenderRelationship.Find(id);
db.Dispose();
if (model == null) return "";
return model.Title;
}
public static String GetPhoneFaxTypeFromId(Guid id)
{
HITSWContext db = new HITSWContext();
var phonefax = db.Lookup_PhoneFaxType.Find(id);
db.Dispose();
if (phonefax == null) return "";
return phonefax.Title;
}
public static String GetOrganizationTypeTitleFromId(Guid id)
{
HITSWContext db = new HITSWContext();
var organizationType = db.Lookup_ContactType.Find(id);
db.Dispose();
if (organizationType == null) return "";
return organizationType.Title;
}
public static String GetHighestEducationFromId(Guid id)
{
HITSWContext db = new HITSWContext();
var model = db.Lookup_EducationalLevel.Find(id);
db.Dispose();
if (model == null) return "";
return model.Title;
}
public static Guid GetOrganizationContactBasisId(Guid id)
{
HITSWContext db = new HITSWContext();
AddrBk_OrganizationUnit addrbk_organization_unit = db.AddrBk_OrganizationUnit.Find(id);
db.Dispose();
return addrbk_organization_unit.ContactBasis_LCID;
}
public static String GetOrganiationFromId(Guid id)
{
if (id == null) return "";
HITSWContext db = new HITSWContext();
var model = db.AddrBk_OrganizationUnit.Find(id);
db.Dispose();
if (model == null) return "";
return model.Name;
}
public static String GetMemberTypeFromId(Guid id)
{
HITSWContext db = new HITSWContext();
var model = db.Lookup_ContactType.Find(id);
db.Dispose();
if (model == null) return "";
return model.Title;
}
public static String GetMaritialStatusFromId(Guid id)
{
HITSWContext db = new HITSWContext();
var model = db.Lookup_MaritalStatus.Find(id);
db.Dispose();
if (model == null) return "";
return model.Title;
}
public static String GetLanguageFromId(Guid id)
{
HITSWContext db = new HITSWContext();
var language = db.Lookup_Language.Find(id);
db.Dispose();
if (language == null) return "";
return language.Title;
}
public static String GetInterestedProductServicesTitleFromId(Guid id)
{
HITSWContext db = new HITSWContext();
var model = db.Lookup_AddrBk.Find(id);
db.Dispose();
if (model == null) return "";
return model.Title;
}
public static String GetIndustrySectorFromId(Guid id)
{
HITSWContext db = new HITSWContext();
var industry = db.Lookup_IndustrySector.Find(id);
db.Dispose();
if (industry == null) return "";
return industry.Title;
}
public static Guid GetOrganizationLookUpBasisId(bool isExternalOrganization = true)
{
HITSWContext db = new HITSWContext();
Lookup_ContactBasis basis = new Lookup_ContactBasis();
if (isExternalOrganization)
basis = db.Lookup_ContactBasis.Where(e => e.Title == "External Organization").First();
else
basis = db.Lookup_ContactBasis.Where(e => e.Title == "Internal Organization").First();
db.Dispose();
return basis.Id;
}
public static Guid GetGeoBasisId(Guid id)
{
if (id == null) return Guid.Empty;
HITSWContext db = new HITSWContext();
AddrBk_GeographicalGroup addrbk_geographicalgroup = db.AddrBk_GeographicalGroup.Find(id);
db.Dispose();
return addrbk_geographicalgroup.GeoBasis_LCID;
}
public static String GetGeoBasisTitle(Guid id)
{
if (id == null) return "";
HITSWContext db = new HITSWContext();
AddrBk_GeographicalGroup addrbk_geographicalgroup = db.AddrBk_GeographicalGroup.Find(id);
Lookup_GeographicalBasis model = db.Lookup_GeographicalBasis.Find(addrbk_geographicalgroup.GeoBasis_LCID);
db.Dispose();
return model.Title.Trim();
}
