public static Dictionary <int, string> GetCompaniesListByFacilityCode(string facilityCode) { Dictionary <int, string> result; using (LookupEntities context = new LookupEntities()) { var divisions = (from d in context.Lookups_Division_Divisions where d.FacilityCode == facilityCode select d.CompanyID).Distinct(); if (divisions.Count() < 1) { return(null); } var companies = from c in context.Lookups_Company_Companies where divisions.Contains(c.CompanyID) orderby c.CorporationName select new { c.CompanyID, c.CorporationName }; result = companies.ToDictionary(r => r.CompanyID, r => r.CorporationName); } return(result); }
public static int NewPersonDivisionXrefEnty(int personDivisionXrefID) { int result = -1; using (LookupEntities context = new LookupEntities()) { var entity = new Lookups_Common_Entities(); entity.PersonDivisionXrefID = personDivisionXrefID; context.SaveChanges(); result = entity.EntityID; } return(result); }
public static IQueryable GetCounties() { var context = new LookupEntities(); var results = from result in context.Miscellaneous_Countries select new { result.CountryCode, result.CountryDescription, result.CountrySubdivisionTypeName }; return(results); }
public static IQueryable GetCountrySubdivisions(string countryCode) { var context = new LookupEntities(); var results = from result in context.Miscellaneous_CountrySubdivisions where result.CountryCode == countryCode select new { result.CountrySubdivisionCode, result.CountrySubdivisionName }; return(results); }
public static List <LEO_Officers> GetLEO_Officers() { List <LEO_Officers> result; using (LookupEntities context = new LookupEntities()) { var officers = from officer in context.LEO_Officers select officer; result = officers.ToList(); } return(result); }
public static LEO_Officers GetLEO_Officer(int personID) { LEO_Officers result = null; using (LookupEntities context = new LookupEntities()) { var officers = from officer in context.LEO_Officers where officer.PersonID == personID select officer; result = officers.FirstOrDefault(); } return(result); }
public static List <LEO_Officers> GetActiveLEO_Officers() { List <LEO_Officers> result; using (LookupEntities context = new LookupEntities()) { var officers = from officer in context.LEO_Officers where officer.BadgeStatusCode == "ACTV" select officer; result = officers.ToList(); } return(result); }
public static string GetRequirementCodeFromDescription(string description) { string code = string.Empty; using (LookupEntities context = new LookupEntities()) { var codes = from c in context.Lookups_Common_Requirement_Requirements where c.RequirementDescription == description || c.RequirementCode == description select c.RequirementCode; code = codes.FirstOrDefault(); } return(code); }
public static string GetMimeTypeFromFileName(string fileName) { string result = string.Empty; string ext = Path.GetExtension(fileName).Replace(".", ""); using (LookupEntities context = new LookupEntities()) { var extentions = from extention in context.Lookups_Common_Requirement_ContentTypes_Extensions where extention.FileExtention == ext select extention; result = extentions.FirstOrDefault().ContentTypeCode; } return(result); }
public static List <Lookups_Company_Companies> CompaniesWithActiveDivisions(string facilityCode) { List <Lookups_Company_Companies> companies = null; using (LookupEntities context = new LookupEntities()) { var divisions = (from d in context.Lookups_Division_Divisions where d.FacilityCode == facilityCode && d.DivisionStatusCode == "A" select d.CompanyID).Distinct(); companies = (from c in context.Lookups_Company_Companies where divisions.Contains(c.CompanyID) orderby c.CorporationName select c).ToList <Lookups_Company_Companies>(); } return(companies); }
public static Person_PersonDivisionXref GetPersonDivisionXref(int personID, int divisionID) { Person_PersonDivisionXref result = null; try { using (LookupEntities context = new LookupEntities()) { result = (from p in context.Person_PersonDivisionXref where p.PersonID == personID && p.DivisionID == divisionID select p).Single(); ; } } catch (Exception) { result = null; } return(result); }