int ILocationInterface.SaveLocation(Location objLocation) { int locationId = 0; var location = All.AsNoTracking().Where(x => x.StateId == objLocation.StateId && x.PincodeId == objLocation.PincodeId && x.CityId == objLocation.CityId); if (location.Any()) { location = location.AsNoTracking().Where(x => x.Address.Equals(objLocation.Address, StringComparison.InvariantCultureIgnoreCase)); } if (location.Any()) { locationId = location.First().LocationId; } else { Add(objLocation); _context.SaveChanges(); _context.Entry(objLocation).State = EntityState.Detached; locationId = objLocation.LocationId; } GetLatLon(objLocation); return(locationId); }
public LstPersonnel GetPersonnelByEmail(string email) { return(All.AsNoTracking().FirstOrDefault(x => x.Email.Equals(email, StringComparison.InvariantCultureIgnoreCase))); }
public IEnumerable <CourseModel> SearchCourses(string text) => All .AsNoTracking() .Include(c => c.StudyGroup) .ThenInclude(g => g.University) .Where(c => c.CodeStandardized.Contains(text) || c.FullNameStandardized.Contains(text));