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));