private bool BeUniqueMidPointName(MidPoint midpoint, string midpointName)
{
GPSNavigationSystemContext _db = new GPSNavigationSystemContext();
var dbCategory = _db.MidPoints
.Where(x => x.MidPointName.Equals(midpointName))
.SingleOrDefault();
if (dbCategory == null)
{
return(true);
}
return(dbCategory.MidPointID == midpoint.MidPointID);
}
private bool BeUniqueCategory(Category category, string categoryName)
{
GPSNavigationSystemContext _db = new GPSNavigationSystemContext();
var dbCategory = _db.Categories
.Where(x => x.CategoryName.Equals(categoryName))
.SingleOrDefault();
if (dbCategory == null)
{
return(true);
}
return(dbCategory.CategoryID == category.CategoryID);
}
private bool BeUniqueStreet(Street instance, string street)
{
GPSNavigationSystemContext _db = new GPSNavigationSystemContext();
var dbStreet = _db.Street
.Where(x => x.StreetName == street)
.SingleOrDefault();
if (dbStreet == null)
{
return(true);
}
return(dbStreet.StreetID == instance.StreetID);
}
private bool BeUniqueSign(TrafficSign instance, string sign)
{
GPSNavigationSystemContext _db = new GPSNavigationSystemContext();
var dbSign = _db.TrafficSigns
.Where(x => x.TrafficSignName == sign)
.SingleOrDefault();
if (dbSign == null)
{
return(true);
}
return(dbSign.TrafficSignID == instance.TrafficSignID);
}
private bool BeUniqueStationName(StationLocation instance, string stationName)
{
GPSNavigationSystemContext _db = new GPSNavigationSystemContext();
var sbStation = _db.StationLocations
.Where(x => x.StationName == stationName &&
x.StationType == instance.StationType)
.SingleOrDefault();
if (sbStation == null)
{
return(true);
}
return(sbStation.StationLocationID == instance.StationLocationID);
}
private bool BeUniqueStationDestination(StationDestination instance, int stationID)
{
GPSNavigationSystemContext _db = new GPSNavigationSystemContext();
var dbSD = _db.StationDestinations
.Where(x => x.StationLocationID == stationID &&
x.DestinationID == instance.DestinationID)
.SingleOrDefault();
if (dbSD == null)
{
return(true);
}
return(dbSD.StationDestinationID == instance.StationDestinationID);
}
private bool BeUniqueHouse(House house, string houseNo)
{
GPSNavigationSystemContext _db = new GPSNavigationSystemContext();
var dbHouse = _db.Houses
.Where(x => x.HouseNumber.Equals(houseNo) &&
x.StreetID.Equals(house.StreetID))
.SingleOrDefault();
if (dbHouse == null)
{
return(true);
}
return(dbHouse.HouseID == house.HouseID);
}
private bool BeUniqueServiceProvider(ServiceProvider sp, string serviceProvider)
{
GPSNavigationSystemContext _db = new GPSNavigationSystemContext();
var dbServiceProvider = _db.ServiceProviders
.Where(x => x.ServiceProviderName.Equals(serviceProvider))
.SingleOrDefault();
if (dbServiceProvider == null)
{
return(true);
}
return(dbServiceProvider.ServiceProviderID == sp.ServiceProviderID);
}
private bool BeUniqueDestination(Destination destinaion, string destination)
{
GPSNavigationSystemContext _db = new GPSNavigationSystemContext();
var dbDestination = _db.Destinations
.Where(x => x.DestinationName.Equals(destination))
.SingleOrDefault();
if (dbDestination == null)
{
return(true);
}
return(dbDestination.DestinationID == destinaion.DestinationID);
}
private bool BeUniqueServiceProvider(ServiceProviderLocation instance,
int serviceProviderID)
{
GPSNavigationSystemContext _db = new GPSNavigationSystemContext();
var dbSPLocation = _db.ServiceProviderLocations
.Where(x => x.ServiceProviderID == serviceProviderID &&
x.ServiceProviderLongitude == instance.ServiceProviderLongitude &&
x.ServiceProviderLatitude == instance.ServiceProviderLatitude)
.SingleOrDefault();
// if the item doesnt exist it will return null
if (dbSPLocation == null)
{
return(true);
}
return(dbSPLocation.ServiceProviderLocationID == instance.ServiceProviderLocationID);
}
private bool BeUniqueTrafficSign(TrafficSignLocation instance, int trafficSignID)
{
GPSNavigationSystemContext _db = new GPSNavigationSystemContext();
var dbTSLocation = _db.TrafficSignLocations
.Where(x => x.TrafficSignID == trafficSignID &&
x.TSLocationEndLatitude == instance.TSLocationEndLatitude &&
x.TSLocationEndLongitude == instance.TSLocationEndLongitude &&
x.TSLocationStartLatitude == instance.TSLocationStartLatitude &&
x.TSLocationStartLongitude == instance.TSLocationStartLongitude)
.SingleOrDefault();
if (dbTSLocation == null)
{
return(true);
}
return(dbTSLocation.TrafficSignLocationID == instance.TrafficSignLocationID);
}
private bool BeUniqueUserName(User instance, string username)
{
GPSNavigationSystemContext _db = new GPSNavigationSystemContext();
var dbUser = _db.Users
.Where(x => x.username == username)
.SingleOrDefault();
if (dbUser == null)
{
return(true);
}
else
{
return(false);
}
//return dbUser.username == instance.username;
}
