public static IEnumerable<string> GetBusinessUnitNames(string searchstring) { using (var dvrdbContext = new dvradiusEntities()) { return dvrdbContext.GetBusinessUnitsAutoPopulate(searchstring).ToList(); } }
private Employee GetFirstTeleCaller() { using (var data = new dvradiusEntities()) { return (from emp in data.Employees select emp).Take(1).FirstOrDefault(); } }
private IEnumerable<BusinessUnit> GetTop5BU() { using (var data = new dvradiusEntities()) { return (from bu in data.BusinessUnits.Include("Address") where bu.Address != null && bu.SecondaryContactNumber != null && bu.Name != null && bu.Address.Area != null select bu).Take(5).ToList(); } }
public Caller GetCaller(string phoneNumber) { var data = new dvradiusEntities(); return data.Callers.FirstOrDefault(caller => caller.PhoneNumber.Contains(phoneNumber)); }