public Models.CreateViewModel GetCreateViewModel(Models.RetrieveViewModel rvm)
{
Models.CreateViewModel cvm = new Models.CreateViewModel();
CDLContext db = new CDLContext();
Bridge bridge = new Bridge();
bridge = db.Bridge.Where(b => b.Latitude <= rvm.Latitude + 0.001 && b.Latitude >= rvm.Latitude - 0.001 &&
b.Longitude <= rvm.Longitude + 0.001 && b.Longitude >= rvm.Longitude - 0.001).FirstOrDefault();
if (bridge != null) //found match
{
cvm.Latitude = bridge.Latitude;
cvm.Longitude = bridge.Longitude;
cvm.Address1 = bridge.Address1;
cvm.City = bridge.City;
cvm.State = bridge.State.PostalCode;
cvm.PostalCode = bridge.PostalCode;
cvm.Height = bridge.Height;
cvm.BridgeId = bridge.BridgeId;
if (bridge.Weights.Count >= 1)
cvm.WeightStraight = bridge.Weights.ElementAt(0).maxWeight;
if (bridge.Weights.Count >= 2)
cvm.WeightSingle = bridge.Weights.ElementAt(1).maxWeight;
if (bridge.Weights.Count >= 3)
cvm.WeightDouble = bridge.Weights.ElementAt(2).maxWeight;
}
else
{ cvm = null; }
return cvm;
}
public void DropBridge(Models.CreateViewModel cvm)
{
CDLContext db = new CDLContext();
Bridge bridge = new Bridge();
bridge = db.Bridge.Find(cvm.BridgeId);
db.Bridge.Remove(bridge);
db.SaveChanges();
}
public Models.DisplayRestrictedViewModel GetDisplayRestrictedViewModelByCityAndState(Models.RetrieveByCityViewModel rbcvm)
{
CDLContext db = new CDLContext();
Models.DisplayRestrictedViewModel drvm = new Models.DisplayRestrictedViewModel();
List<Bridge> bridges = new List<Bridge>();
drvm.Bridges = bridges; // list of bridges to populate for new view model
drvm.Bridges = db.Bridge.Where(b => (b.State.PostalCode == rbcvm.State && b.City == rbcvm.City)).ToList();
return drvm;
}
public UserData GetUserDataFromUserId(int userId)
{
CDLContext db = new CDLContext();
var user = db.User
.First(u => u.UserId == userId);
UserData result = new UserData();
result.Email = user.Email;
result.FirstName = user.FirstName;
result.LastName = user.LastName;
result.UserId = user.UserId;
result.Username = user.Username;
result.Roles = db.UserRole
.Where(userRole => userRole.UserId == userId)
.Select(userRole => userRole.Role.Name)
.ToArray();
return result;
}
public Models.DisplayRestrictedViewModel GetDisplayRestrictedViewModel(Models.RestrictedIndexViewModel rivm)
{
CDLContext db = new CDLContext();
Models.DisplayRestrictedViewModel drvm = new Models.DisplayRestrictedViewModel();
List<Bridge> bridges = new List<Bridge>();
//"Straight Truck", "Single Trailer", "Double Trailer"
if (rivm.SelectedTruckType == "Single Trailer")
rivm.Type = TruckType.Single;
else if (rivm.SelectedTruckType == "Double Trailer")
rivm.Type = TruckType.Double;
else // (rivm.SelectedTruckType == "Straight Truck")
rivm.Type = TruckType.Straight;
drvm.Bridges = bridges; // list of bridges to populate for new view model
drvm.Bridges = db.Bridge.Where(b => ((b.Height <= rivm.Height) || b.Weights.Any(w => w.maxWeight <= rivm.Weight && w.TruckType == rivm.Type))
&& (b.State.PostalCode == rivm.State && b.City == rivm.City)).ToList();
return drvm;
}
public List<Models.Service.BridgeServiceModel> GetListBridgeServiceModel()
{
List<Models.Service.BridgeServiceModel> lbsm = new List<Models.Service.BridgeServiceModel>();
CDLContext db = new CDLContext();
List<Bridge> bridges = new List<Bridge>();
bridges = db.Bridge.ToList();
foreach(var b in bridges)
{
var bsm = new Models.Service.BridgeServiceModel();
bsm.Guid = b.Guid;
bsm.Latitude = b.Latitude;
bsm.Longitude = b.Longitude;
bsm.Location = b.Address1;
bsm.City = b.City;
if (b.Height == null)
b.Height = 0;
bsm.heightRestriction = (float) b.Height;
if (b.Weights.Count >= 1)
bsm.weightStraightTruck = (float) b.Weights.ElementAt(0).maxWeight;
if (b.Weights.Count >= 2)
bsm.weightSingleTrailer = (float) b.Weights.ElementAt(1).maxWeight;
if (b.Weights.Count >= 3)
bsm.weightDoubleTrailer = (float) b.Weights.ElementAt(2).maxWeight;
lbsm.Add(bsm);
}
//lbsm = db.Bridge.ToList().Select(b => new { b.Guid, b.Height, b.Latitude, b.Longitude }).ToList();
return lbsm;
}
private static void SeedUser(CDLContext context)
{
context.User.AddOrUpdate(u => u.Email,
new User() { Username = "******", FirstName = "Donovan", LastName = "May", Email = "*****@*****.**" },
new User() { Username = "******", FirstName = "Freddie", LastName = "Mack", Email = "*****@*****.**" },
new User() { Username = "******", FirstName = "Darth", LastName = "Vader", Email = "*****@*****.**" },
new User() { Username = "******", FirstName = "Loke", LastName = "Groundrunner", Email = "*****@*****.**" },
new User() { Username = "******", FirstName = "Grumpy", LastName = "Pants", Email = "*****@*****.**" },
new User() { Username = "******", FirstName = "Captain", LastName = "Crunch", Email = "*****@*****.**" });
context.SaveChanges();
}
private static void SeedUserAddress(CDLContext context)
{
context.UserAddress.AddOrUpdate(a => new { a.Address1 },
new UserAddress() { Address1 = "1234 Dearborn Pkwy", Address2 = "Address Line 2", City = "Houston", PostalCode = "12345", StateId = 43, UserId = 1 },
new UserAddress() { Address1 = "5678 Transit St", Address2 = "Address Line 2", City = "Houston", PostalCode = "12345", StateId = 43, UserId = 2 },
new UserAddress() { Address1 = "8912 Stone Rd", Address2 = "Address Line 2", City = "Houston", PostalCode = "12345", StateId = 43, UserId = 3 },
new UserAddress() { Address1 = "12 Black St", Address2 = "Address Line 2", City = "Houston", PostalCode = "12345", StateId = 43, UserId = 4 },
new UserAddress() { Address1 = "8932 Fisk Rd", Address2 = "Address Line 2", City = "Houston", PostalCode = "12345", StateId = 43, UserId = 5 },
new UserAddress() { Address1 = "4023 Carriage Lane", Address2 = "Address Line 2", City = "Houston", PostalCode = "12345", StateId = 43, UserId = 6 }
);
context.SaveChanges();
}
private static void SeedRoles(CDLContext context)
{
context.Roles.AddOrUpdate(r => r.Name,
new Role() { Name = Role.ADMINISTRATOR },
new Role() { Name = Role.STAFF },
new Role() { Name = Role.USER }
);
context.SaveChanges();
}
private static void SeedState(CDLContext context)
{
context.State.AddOrUpdate(s => s.PostalCode,
new State() { Name = "Alabama", PostalCode = "AL", CountryId = 1 },
new State() { Name = "Alaska", PostalCode = "AK", CountryId = 1 },
new State() { Name = "Arizona", PostalCode = "AZ", CountryId = 1 },
new State() { Name = "Arkansas", PostalCode = "AR", CountryId = 1 },
new State() { Name = "California", PostalCode = "CA", CountryId = 1 }, //5
new State() { Name = "Colorado", PostalCode = "CO", CountryId = 1 },
new State() { Name = "Connecticut", PostalCode = "CT", CountryId = 1 },
new State() { Name = "Deleware", PostalCode = "DE", CountryId = 1 },
new State() { Name = "Florida", PostalCode = "FL", CountryId = 1 },
new State() { Name = "Georgia", PostalCode = "GA", CountryId = 1 }, //10
new State() { Name = "Hawaii", PostalCode = "HI", CountryId = 1 },
new State() { Name = "Idaho", PostalCode = "ID", CountryId = 1 },
new State() { Name = "Illinois", PostalCode = "IL", CountryId = 1 },
new State() { Name = "Indiana", PostalCode = "IN", CountryId = 1 },
new State() { Name = "Iowa", PostalCode = "IA", CountryId = 1 },
new State() { Name = "Kansas", PostalCode = "KS", CountryId = 1 }, //16
new State() { Name = "Kentucky", PostalCode = "KY", CountryId = 1 },
new State() { Name = "Lousiana", PostalCode = "LA", CountryId = 1 },
new State() { Name = "Maine", PostalCode = "ME", CountryId = 1 },
new State() { Name = "Maryland", PostalCode = "MD", CountryId = 1 }, //20
new State() { Name = "Massachucetts", PostalCode = "MA", CountryId = 1 },
new State() { Name = "Michigan", PostalCode = "MI", CountryId = 1 },
new State() { Name = "Minnesota", PostalCode = "MN", CountryId = 1 },
new State() { Name = "Mississippi", PostalCode = "MS", CountryId = 1 },
new State() { Name = "Missouri", PostalCode = "MO", CountryId = 1 },//25
new State() { Name = "Montana", PostalCode = "MT", CountryId = 1 },
new State() { Name = "Nebraska", PostalCode = "NE", CountryId = 1 },
new State() { Name = "Nevada", PostalCode = "NV", CountryId = 1 },
new State() { Name = "New Hampshire", PostalCode = "NH", CountryId = 1 },
new State() { Name = "New Jersey", PostalCode = "NJ", CountryId = 1 },//30
new State() { Name = "New Mexico", PostalCode = "NM", CountryId = 1 },
new State() { Name = "New York", PostalCode = "NY", CountryId = 1 },
new State() { Name = "North Carolina", PostalCode = "NC", CountryId = 1 },
new State() { Name = "North Dakota", PostalCode = "ND", CountryId = 1 },
new State() { Name = "Ohio", PostalCode = "OH", CountryId = 1 }, //35
new State() { Name = "Oklahoma", PostalCode = "OK", CountryId = 1 },
new State() { Name = "Oregon", PostalCode = "OR", CountryId = 1 },
new State() { Name = "Pennsylvania", PostalCode = "PA", CountryId = 1 },
new State() { Name = "Rhode Island", PostalCode = "RI", CountryId = 1 },
new State() { Name = "South Carolina", PostalCode = "SC", CountryId = 1 }, //40
new State() { Name = "South Dakota", PostalCode = "SD", CountryId = 1 },
new State() { Name = "Tennessee", PostalCode = "TN", CountryId = 1 },
new State() { Name = "Texas", PostalCode = "TX", CountryId = 1 },
new State() { Name = "Utah", PostalCode = "UT", CountryId = 1 },
new State() { Name = "Vermont", PostalCode = "VT", CountryId = 1 }, //45
new State() { Name = "Virginia", PostalCode = "VA", CountryId = 1 },
new State() { Name = "Washington", PostalCode = "WA", CountryId = 1 },
new State() { Name = "West Virgina", PostalCode = "WV", CountryId = 1 },
new State() { Name = "Wisconsin", PostalCode = "WI", CountryId = 1 },
new State() { Name = "Wyoming", PostalCode = "WY", CountryId = 1 } //50
);
context.SaveChanges();
}
private static void SeedBridge(CDLContext context)
{
context.Bridge.AddOrUpdate(b => new { b.Address1 },
//new Bridge()
//{
// Guid = Guid.NewGuid(),
// Height = 14.0f,
// LastUpdated = DateTime.UtcNow,
// NumTimesReported = 1,
// Address1 = "Airport Blvd @ Mykawa Rd",
// City = "Houston",
// PostalCode = "12345",
// StateId = 43,
// Latitude = 29.645679f,
// Longitude = -95.312018f
//},
// new Bridge()
// {
// Guid = Guid.NewGuid(),
// Height = 10.5f,
// LastUpdated = DateTime.UtcNow,
// NumTimesReported = 3,
// Address1 = "LawnDale St @ San Antonio St",
// City = "Houston",
// PostalCode = "12345",
// StateId = 43,
// Latitude = 29.716600f,
// Longitude = -95.284102f
// },
// new Bridge()
// {
// Guid = Guid.NewGuid(),
// Height = 12.5f,
// LastUpdated = DateTime.UtcNow,
// NumTimesReported = 2,
// Address1 = "Griggs Rd @ Evergreen Dr",
// City = "Houston",
// PostalCode = "12345",
// StateId = 43,
// Latitude = 29.716824f,
// Longitude = -95.290153f
// },
// new Bridge()
// {
// Guid = Guid.NewGuid(),
// Height = 14.0f,
// LastUpdated = DateTime.UtcNow,
// NumTimesReported = 1,
// Address1 = "Telephone Rd @ Tellespen St",
// City = "Houston",
// PostalCode = "12345",
// StateId = 43,
// Latitude = 29.726216f,
// Longitude = -95.324743f
// },
// new Bridge()
// {
// Guid = Guid.NewGuid(),
// Height = 10.5f,
// LastUpdated = DateTime.UtcNow,
// NumTimesReported = 3,
// Address1 = "N Transit @ Green St",
// City = "Lockport",
// PostalCode = "14094",
// StateId = 32,
// Latitude = 43.172961f,
// Longitude = -78.696839f
// },
// new Bridge()
// {
// Guid = Guid.NewGuid(),
// Height = 12.5f,
// LastUpdated = DateTime.UtcNow,
// NumTimesReported = 2,
// Address1 = "Cold Springs Rd @ Chestnut Ridge",
// City = "Hartland",
// PostalCode = "14032",
// StateId = 32,
// Latitude = 43.183789f,
// Longitude = -78.662099f
// },
// new Bridge()
// {
// Guid = Guid.NewGuid(),
// Height = 11.5f,
// LastUpdated = DateTime.UtcNow,
// NumTimesReported = 1,
// Address1 = "Genesse St @ Wasmuth Ave",
// City = "Buffalo",
// PostalCode = "14201",
// StateId = 32,
// Latitude = 42.906426f,
// Longitude = -78.828771f
// },
// new Bridge()
// {
// Guid = Guid.NewGuid(),
// Height = 9.5f,
// LastUpdated = DateTime.UtcNow,
// NumTimesReported = 1,
// Address1 = "Main St @ Fillmore Ave",
// City = "Buffalo",
// PostalCode = "14094",
// StateId = 32,
// Latitude = 42.935793f,
// Longitude = -78.842268f
// },
// // BridgeId = 9 -- weight
// new Bridge()
// {
// Guid = Guid.NewGuid(),
// Height = null,
// LastUpdated = DateTime.UtcNow,
// NumTimesReported = 2,
// Address1 = "W 21st ST N @ N Mclean",
// City = "Wichita",
// PostalCode = "12235",
// StateId = 16,
// Latitude = 37.722997f,
// Longitude = -97.383435f
// },
// new Bridge()
// {
// Guid = Guid.NewGuid(),
// Height = null,
// LastUpdated = DateTime.UtcNow,
// NumTimesReported = 3,
// Address1 = "W Zoo Blvd @ W Windmill",
// City = "Wichita",
// PostalCode = "122345",
// StateId = 16,
// Latitude = 37.715515f,
// Longitude = -97.401448f
// },
// new Bridge()
// {
// Guid = Guid.NewGuid(),
// Height = null,
// LastUpdated = DateTime.UtcNow,
// NumTimesReported = 5,
// Address1 = "E 83rd St S @ N River St",
// City = "Derby",
// PostalCode = "12245",
// StateId = 16,
// Latitude = 37.544321f,
// Longitude = -97.276087f
// },
// // Derby Texas
// new Bridge()
// {
// Guid = Guid.NewGuid(),
// Height = null,
// LastUpdated = DateTime.UtcNow,
// NumTimesReported = 1,
// Address1 = "S Pleasant Vally Rd @ E Ceasar Chavez St",
// City = "Austin",
// PostalCode = "12345",
// StateId = 43,
// Latitude = 30.250127f,
// Longitude = -97.713454f
// },
// // Utah
// new Bridge()
// {
// Guid = Guid.NewGuid(),
// Height = null,
// LastUpdated = DateTime.UtcNow,
// NumTimesReported = 3,
// Address1 = "900 S Indiana Ave @ 2015 W St",
// City = "Lockport",
// PostalCode = "14094",
// StateId = 44,
// Latitude = 40.750405f,
// Longitude = -111.952765f
// },
// new Bridge()
// {
// Guid = Guid.NewGuid(),
// Height = null,
// LastUpdated = DateTime.UtcNow,
// NumTimesReported = 2,
// Address1 = "Grant St @ Amherst St",
// City = "Buffalo",
// PostalCode = "14120",
// StateId = 32,
// Latitude = 42.936865f,
// Longitude = -78.888992f
// },
// new Bridge()
// {
// Guid = Guid.NewGuid(),
// Height = null,
// LastUpdated = DateTime.UtcNow,
// NumTimesReported = 1,
// Address1 = "Elmwood Ave @ Scajaquada Expy",
// City = "Buffalo",
// PostalCode = "14120",
// StateId = 32,
// Latitude = 42.934681f,
// Longitude = -78.877662f
// },
// new Bridge()
// {
// Guid = Guid.NewGuid(),
// Height = null,
// LastUpdated = DateTime.UtcNow,
// NumTimesReported = 1,
// Address1 = "Deleware Ave @ Forest Ave",
// City = "Buffalo",
// PostalCode = "14120",
// StateId = 32,
// Latitude = 42.929230f,
// Longitude = -78.865517f
// },
// new Bridge()
// {
// Guid = Guid.NewGuid(),
// Height = null,
// LastUpdated = DateTime.UtcNow,
// NumTimesReported = 2,
// Address1 = "E Orem @ Webercrest",
// City = "Houston",
// PostalCode = "12345",
// StateId = 43,
// Latitude = 29.625505f,
// Longitude = -95.329292f
// },
// new Bridge()
// {
// Guid = Guid.NewGuid(),
// Height = null,
// LastUpdated = DateTime.UtcNow,
// NumTimesReported = 3,
// Address1 = "W Orem @ East of Almeda",
// City = "Houston",
// PostalCode = "12345",
// StateId = 43,
// Latitude = 29.627398f,
// Longitude = -95.407172f
// },
// new Bridge()
// {
// Guid = Guid.NewGuid(),
// Height = null,
// LastUpdated = DateTime.UtcNow,
// NumTimesReported = 5,
// Address1 = "Memorial Dr @ Sawer",
// City = "Houston",
// PostalCode = "12345",
// StateId = 43,
// Latitude = 29.762623f,
// Longitude = -95.381595f
// },
new Bridge()
{
Guid = Guid.NewGuid(),
Height = null,
LastUpdated = DateTime.UtcNow,
NumTimesReported = 5,
Address1 = "Youngstown Wilson Rd @ 3 mi east of Youngstown",
City = "Youngstown",
PostalCode = "14174",
StateId = 32,
Latitude = 43.271437f,
Longitude = -78.957582f
},
new Bridge()
{
Guid = Guid.NewGuid(),
Height = null,
LastUpdated = DateTime.UtcNow,
NumTimesReported = 5,
Address1 = "Willow Rd @ 0.1 mi SE of South Wilson",
City = "Wilson",
PostalCode = "14172",
StateId = 32,
Latitude = 43.231428f,
Longitude = -78.811626f
},
new Bridge()
{
Guid = Guid.NewGuid(),
Height = null,
LastUpdated = DateTime.UtcNow,
NumTimesReported = 5,
Address1 = "Canal Rd @ 1.8 mi E of Lockport",
City = "Lockport",
PostalCode = "14094",
StateId = 32,
Latitude = 43.193392f,
Longitude = -78.633129f
},
new Bridge()
{
Guid = Guid.NewGuid(),
Height = null,
LastUpdated = DateTime.UtcNow,
NumTimesReported = 5,
Address1 = "Day Rd @ 1.0 mi E of Lockport",
City = "Lockport",
PostalCode = "14094",
StateId = 32,
Latitude = 43.190049f,
Longitude = -78.650769f
},
new Bridge()
{
Guid = Guid.NewGuid(),
Height = null,
LastUpdated = DateTime.UtcNow,
NumTimesReported = 5,
Address1 = "Interstate 190 @ 0.5 mi N JCT I190 & SH198",
City = "Buffalo",
PostalCode = "14207",
StateId = 32,
Latitude = 42.931774f,
Longitude = -78.901448f
},
new Bridge()
{
Guid = Guid.NewGuid(),
Height = null,
LastUpdated = DateTime.UtcNow,
NumTimesReported = 5,
Address1 = "Robert Rich Way @ 2.5 mi S JCT RTS I190<198",
City = "Buffalo",
PostalCode = "14213",
StateId = 43,
Latitude = 42.915199f,
Longitude = -78.901543f
}
);
}
private static void SeedMembership(CDLContext context)
{
try
{
context.Memberships.AddOrUpdate(m => m.UserId, //userID is PK
new Membership() { UserId = 1, CreateDate = DateTime.UtcNow, IsConfirmed = true, PasswordFailuresSinceLastSuccess = 0, Password = "******", PasswordSalt = "" },
new Membership() { UserId = 2, CreateDate = DateTime.UtcNow, IsConfirmed = true, PasswordFailuresSinceLastSuccess = 0, Password = "******", PasswordSalt = "" },
new Membership() { UserId = 3, CreateDate = DateTime.UtcNow, IsConfirmed = true, PasswordFailuresSinceLastSuccess = 0, Password = "******", PasswordSalt = "" },
new Membership() { UserId = 4, CreateDate = DateTime.UtcNow, IsConfirmed = true, PasswordFailuresSinceLastSuccess = 0, Password = "******", PasswordSalt = "" },
new Membership() { UserId = 5, CreateDate = DateTime.UtcNow, IsConfirmed = true, PasswordFailuresSinceLastSuccess = 0, Password = "******", PasswordSalt = "" },
new Membership() { UserId = 6, CreateDate = DateTime.UtcNow, IsConfirmed = true, PasswordFailuresSinceLastSuccess = 0, Password = "******", PasswordSalt = "" }
);
context.SaveChanges();
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
//// Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
// eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
public void SaveCreateViewModel(Models.CreateViewModel cvm)
{
CDLContext db = new CDLContext();
Bridge bridge = new Bridge();
List<Weight> weights = new List<Weight>();
Weight weight1 = new Weight();
Weight weight2 = new Weight();
Weight weight3 = new Weight();
State st = new State();
st = db.State.Where(s => cvm.State == s.PostalCode).FirstOrDefault();
bridge.Address1 = cvm.Address1;
bridge.City = cvm.City;
bridge.State = st;
bridge.PostalCode = cvm.PostalCode;
bridge.LastUpdated = DateTime.UtcNow;
bridge.Height = cvm.Height;
bridge.Latitude = cvm.Latitude;
bridge.Longitude = cvm.Longitude;
weight1.maxWeight = cvm.WeightStraight;
weight1.TruckType = TruckType.Straight;
weights.Add(weight1);
weight2.maxWeight = cvm.WeightSingle;
weight2.TruckType = TruckType.Single;
weights.Add(weight2);
weight3.maxWeight = cvm.WeightDouble;
weight3.TruckType = TruckType.Double;
weights.Add(weight3);
bridge.Weights = weights;
db.Bridge.Add(bridge);
db.SaveChanges();
}
public List<Models.CreateViewModel> GetListViewModel(Models.RetrieveViewModel rvm)
{
List<Models.CreateViewModel> lcvm = new List<Models.CreateViewModel>();
CDLContext db = new CDLContext();
GeoCoordinate gc = new GeoCoordinate(rvm.Latitude, rvm.Longitude);
List<Bridge> bridges = new List<Bridge>();
bridges = db.Bridge.ToList();
foreach (var b in bridges)
{
var cvm = new Models.CreateViewModel();
cvm.Address1 = b.Address1;
cvm.City = b.City;
cvm.State = b.State.Name;
cvm.PostalCode = b.PostalCode;
cvm.Latitude = b.Latitude;
cvm.Longitude = b.Longitude;
var bridgeGC = new GeoCoordinate();
bridgeGC.Latitude = cvm.Latitude;
bridgeGC.Longitude = cvm.Longitude;
if (b.Height == null)
b.Height = 0;
cvm.Height = (float)b.Height;
if (b.Weights.Count >= 1)
cvm.WeightStraight = b.Weights.ElementAt(0).maxWeight;
if (b.Weights.Count >= 2)
cvm.WeightSingle = b.Weights.ElementAt(1).maxWeight;
if (b.Weights.Count >= 3)
cvm.WeightDouble = b.Weights.ElementAt(2).maxWeight;
if (bridgeGC.GetDistanceTo(gc) <= rvm.Distance * 1609.344) // within distance passsed in keep it
{
lcvm.Add(cvm);
}
}
return lcvm;
}
private static void SeedUserRoles(CDLContext context)
{
context.UserRole.AddOrUpdate(ur => ur.UserId,
new UserRole() { UserId = 1, RoleId = 1 },
new UserRole() { UserId = 2, RoleId = 2 },
new UserRole() { UserId = 3, RoleId = 3 },
new UserRole() { UserId = 4, RoleId = 1 },
new UserRole() { UserId = 5, RoleId = 2 },
new UserRole() { UserId = 6, RoleId = 3 }
);
context.SaveChanges();
}
public List<CDLRouteHelper.Models.Service.BridgeServiceModel> GetListBridgesByAll(double latitude, double longitude, float height, float weight, string trucktype, float distance)
{
List<Bridge> bFoundL = new List<Bridge>();
List<CDLRouteHelper.Models.Service.BridgeServiceModel> lbsm = new List<CDLRouteHelper.Models.Service.BridgeServiceModel>();
CDLContext db = new CDLContext();
TruckType tType;
//"Straight Truck", "Single Trailer", "Double Trailer"
if (trucktype == "Single")
tType = TruckType.Single;
else if (trucktype == "Double")
tType = TruckType.Double;
else // (tType == "Straight Truck")
tType = TruckType.Straight;
bFoundL = db.Bridge.Where(b => ((b.Height <= height) || b.Weights.Any(w => w.maxWeight <= weight && w.TruckType == tType))).ToList();
var gc = new GeoCoordinate();
gc.Latitude = latitude;
gc.Longitude = longitude;
foreach (var b in bFoundL)
{
var bsm = new Models.Service.BridgeServiceModel();
bsm.Guid = b.Guid;
bsm.Latitude = b.Latitude;
bsm.Longitude = b.Longitude;
bsm.Location = b.Address1;
bsm.City = b.City;
var bridgeGC = new GeoCoordinate();
bridgeGC.Latitude = bsm.Latitude;
bridgeGC.Longitude = bsm.Longitude;
if (b.Height == null)
b.Height = 0;
bsm.heightRestriction = (float)b.Height;
if (b.Weights.Count >= 1)
if (b.Weights.ElementAt(0).maxWeight != null)
{
bsm.weightStraightTruck = (float)b.Weights.ElementAt(0).maxWeight; ;
}
if (b.Weights.Count >= 2)
if (b.Weights.ElementAt(1).maxWeight != null)
{
bsm.weightSingleTrailer = (float)b.Weights.ElementAt(1).maxWeight;
}
if (b.Weights.Count >= 3)
if (b.Weights.ElementAt(2).maxWeight != null)
{
bsm.weightDoubleTrailer = (float)b.Weights.ElementAt(2).maxWeight;
}
if (bridgeGC.GetDistanceTo(gc) <= distance * 1609.344) // within distance passsed in keep it
{
lbsm.Add(bsm);
}
}
//bReturnL.Add(new Bridge { Address1 = "f32df2", City = "SomeCity", Latitude=43.17296218, Longitude=-78.696838, BridgeId=1});
//bReturnL.Add(new Bridge { Address1 = "f32df2", City = "SomeCity", Latitude = 43.1837882995605, Longitude = -78.6621017456055 });
return lbsm;
}
public void UpdateCreateViewModel(Models.CreateViewModel cvm)
{
CDLContext db = new CDLContext();
Bridge bridge = new Bridge();
bridge = db.Bridge.Find(cvm.BridgeId);
State st = new State();
st = db.State.Where(s => cvm.State == s.PostalCode).FirstOrDefault();
bridge.Address1 = cvm.Address1;
bridge.City = cvm.City;
bridge.State = st;
bridge.PostalCode = cvm.PostalCode;
bridge.LastUpdated = DateTime.UtcNow;
bridge.Height = cvm.Height;
bridge.Latitude = cvm.Latitude;
bridge.Longitude = cvm.Longitude;
if (bridge.Weights.Count >= 1)
bridge.Weights.ElementAt(0).maxWeight = cvm.WeightStraight;
if (bridge.Weights.Count >= 2)
bridge.Weights.ElementAt(1).maxWeight = cvm.WeightSingle;
if (bridge.Weights.Count >= 3)
bridge.Weights.ElementAt(2).maxWeight = cvm.WeightDouble;
db.SaveChanges();
}
private static void SeedWeight(CDLContext context)
{
context.Weight.AddOrUpdate(w => new { w.BridgeId, w.TruckType },
//new Weight() { BridgeId = 1, maxWeight = null, TruckType = Model.TruckType.Straight },
//new Weight() { BridgeId = 1, maxWeight = null, TruckType = Model.TruckType.Single },
//new Weight() { BridgeId = 1, maxWeight = null, TruckType = Model.TruckType.Double },
//new Weight() { BridgeId = 2, maxWeight = null, TruckType = Model.TruckType.Straight },
//new Weight() { BridgeId = 2, maxWeight = null, TruckType = Model.TruckType.Single },
//new Weight() { BridgeId = 2, maxWeight = null, TruckType = Model.TruckType.Double },
//new Weight() { BridgeId = 3, maxWeight = null, TruckType = Model.TruckType.Straight },
//new Weight() { BridgeId = 3, maxWeight = null, TruckType = Model.TruckType.Single },
//new Weight() { BridgeId = 3, maxWeight = null, TruckType = Model.TruckType.Double },
//new Weight() { BridgeId = 4, maxWeight = null, TruckType = Model.TruckType.Straight },
//new Weight() { BridgeId = 4, maxWeight = null, TruckType = Model.TruckType.Single },
//new Weight() { BridgeId = 4, maxWeight = null, TruckType = Model.TruckType.Double },
//new Weight() { BridgeId = 5, maxWeight = null, TruckType = Model.TruckType.Straight },
//new Weight() { BridgeId = 5, maxWeight = null, TruckType = Model.TruckType.Single },
//new Weight() { BridgeId = 5, maxWeight = null, TruckType = Model.TruckType.Double },
//new Weight() { BridgeId = 6, maxWeight = null, TruckType = Model.TruckType.Straight },
//new Weight() { BridgeId = 6, maxWeight = null, TruckType = Model.TruckType.Single },
//new Weight() { BridgeId = 6, maxWeight = null, TruckType = Model.TruckType.Double },
//new Weight() { BridgeId = 7, maxWeight = null, TruckType = Model.TruckType.Straight },
//new Weight() { BridgeId = 7, maxWeight = null, TruckType = Model.TruckType.Single },
//new Weight() { BridgeId = 7, maxWeight = null, TruckType = Model.TruckType.Double },
//new Weight() { BridgeId = 8, maxWeight = null, TruckType = Model.TruckType.Straight },
//new Weight() { BridgeId = 8, maxWeight = null, TruckType = Model.TruckType.Single },
//new Weight() { BridgeId = 8, maxWeight = null, TruckType = Model.TruckType.Double },
//new Weight() { BridgeId = 9, maxWeight = 15f, TruckType = Model.TruckType.Straight },
//new Weight() { BridgeId = 9, maxWeight = 22f, TruckType = Model.TruckType.Single },
//new Weight() { BridgeId = 9, maxWeight = 25f, TruckType = Model.TruckType.Double },
//new Weight() { BridgeId = 10, maxWeight = 15f, TruckType = Model.TruckType.Straight },
//new Weight() { BridgeId = 10, maxWeight = 15f, TruckType = Model.TruckType.Single },
//new Weight() { BridgeId = 10, maxWeight = 15f, TruckType = Model.TruckType.Double },
//new Weight() { BridgeId = 11, maxWeight = 12f, TruckType = Model.TruckType.Straight },
//new Weight() { BridgeId = 11, maxWeight = 12f, TruckType = Model.TruckType.Single },
//new Weight() { BridgeId = 11, maxWeight = 12f, TruckType = Model.TruckType.Double },
//new Weight() { BridgeId = 12, maxWeight = 50f, TruckType = Model.TruckType.Straight },
//new Weight() { BridgeId = 12, maxWeight = 50f, TruckType = Model.TruckType.Single },
//new Weight() { BridgeId = 12, maxWeight = 50f, TruckType = Model.TruckType.Double },
//new Weight() { BridgeId = 13, maxWeight = 35f, TruckType = Model.TruckType.Straight },
//new Weight() { BridgeId = 13, maxWeight = 35f, TruckType = Model.TruckType.Single },
//new Weight() { BridgeId = 13, maxWeight = 35f, TruckType = Model.TruckType.Double },
//new Weight() { BridgeId = 14, maxWeight = 22f, TruckType = Model.TruckType.Straight },
//new Weight() { BridgeId = 14, maxWeight = 22f, TruckType = Model.TruckType.Single },
//new Weight() { BridgeId = 14, maxWeight = 22f, TruckType = Model.TruckType.Double },
//new Weight() { BridgeId = 15, maxWeight = 11.5f, TruckType = Model.TruckType.Straight },
//new Weight() { BridgeId = 15, maxWeight = 11.5f, TruckType = Model.TruckType.Single },
//new Weight() { BridgeId = 15, maxWeight = 11.5f, TruckType = Model.TruckType.Double },
//new Weight() { BridgeId = 16, maxWeight = 20f, TruckType = Model.TruckType.Straight },
//new Weight() { BridgeId = 16, maxWeight = 30f, TruckType = Model.TruckType.Single },
//new Weight() { BridgeId = 16, maxWeight = 40f, TruckType = Model.TruckType.Double },
//new Weight() { BridgeId = 17, maxWeight = 20f, TruckType = Model.TruckType.Straight },
//new Weight() { BridgeId = 17, maxWeight = 25f, TruckType = Model.TruckType.Single },
//new Weight() { BridgeId = 17, maxWeight = 25f, TruckType = Model.TruckType.Double },
//new Weight() { BridgeId = 18, maxWeight = 10f, TruckType = Model.TruckType.Straight },
//new Weight() { BridgeId = 18, maxWeight = 15f, TruckType = Model.TruckType.Single },
//new Weight() { BridgeId = 18, maxWeight = 20f, TruckType = Model.TruckType.Double },
//new Weight() { BridgeId = 19, maxWeight = 20f, TruckType = Model.TruckType.Straight },
//new Weight() { BridgeId = 19, maxWeight = 20f, TruckType = Model.TruckType.Single },
//new Weight() { BridgeId = 19, maxWeight = 20f, TruckType = Model.TruckType.Double },
new Weight() { BridgeId = 1, maxWeight = 3f, TruckType = Model.TruckType.Straight },
new Weight() { BridgeId = 1, maxWeight = 3f, TruckType = Model.TruckType.Single },
new Weight() { BridgeId = 1, maxWeight = 3f, TruckType = Model.TruckType.Double },
new Weight() { BridgeId = 2, maxWeight = 15f, TruckType = Model.TruckType.Straight },
new Weight() { BridgeId = 2, maxWeight = 15f, TruckType = Model.TruckType.Single },
new Weight() { BridgeId = 2, maxWeight = 15f, TruckType = Model.TruckType.Double },
new Weight() { BridgeId = 3, maxWeight = 20f, TruckType = Model.TruckType.Straight },
new Weight() { BridgeId = 3, maxWeight = 20f, TruckType = Model.TruckType.Single },
new Weight() { BridgeId = 3, maxWeight = 20f, TruckType = Model.TruckType.Double },
new Weight() { BridgeId = 4, maxWeight = 20f, TruckType = Model.TruckType.Straight },
new Weight() { BridgeId = 4, maxWeight = 20f, TruckType = Model.TruckType.Single },
new Weight() { BridgeId = 4, maxWeight = 20f, TruckType = Model.TruckType.Double },
new Weight() { BridgeId = 5, maxWeight = 32f, TruckType = Model.TruckType.Straight },
new Weight() { BridgeId = 5, maxWeight = 32f, TruckType = Model.TruckType.Single },
new Weight() { BridgeId = 5, maxWeight = 32f, TruckType = Model.TruckType.Double },
new Weight() { BridgeId = 6, maxWeight = 15f, TruckType = Model.TruckType.Straight },
new Weight() { BridgeId = 6, maxWeight = 15f, TruckType = Model.TruckType.Single },
new Weight() { BridgeId = 6, maxWeight = 15f, TruckType = Model.TruckType.Double }
);
}
public List<Models.Service.BridgeServiceModel> GetListByDistanceFrom(double latitude, double longitude, float distance)
{
List<Models.Service.BridgeServiceModel> lbsm = new List<Models.Service.BridgeServiceModel>();
CDLContext db = new CDLContext();
GeoCoordinate gc = new GeoCoordinate(latitude, longitude);
List<Bridge> bridges = new List<Bridge>();
//bridges = db.Bridge.Where(b =>
// (1000D * _eQuatorialEarthRadius * 2D * Math.Atan2(Math.Sqrt(Math.Pow(Math.Sin((double)((b.Latitude - latitude) * _d2r) / 2D), 2D) + Math.Cos(latitude * _d2r) * Math.Cos((double)b.Latitude * _d2r) * Math.Pow(Math.Sin((double)((b.Longitude - longitude) * _d2r) / 2D), 2D)), Math.Sqrt(1D - Math.Pow(Math.Sin((double)((b.Longitude - latitude) * _d2r) / 2D), 2D) + Math.Cos(latitude * _d2r) * Math.Cos((double)b.Latitude * _d2r) * Math.Pow(Math.Sin((((double)b.Longitude - longitude) * _d2r) / 2D), 2D))) <= distance)
//== true ).ToList();
//(1000D * _eQuatorialEarthRadius * 2D * Math.Atan2(Math.Sqrt(Math.Pow(Math.Sin((double)((b.Latitude - latitude) * _d2r) / 2D), 2D) + Math.Cos(latitude * _d2r) * Math.Cos((double)b.Latitude * _d2r) * Math.Pow(Math.Sin((double)((b.Longitude - longitude) * _d2r) / 2D), 2D)), Math.Sqrt(1D - Math.Pow(Math.Sin((double)((b.Longitude - latitude) * _d2r) / 2D), 2D) + Math.Cos(latitude * _d2r) * Math.Cos((double)b.Latitude * _d2r) * Math.Pow(Math.Sin((((double)b.Longitude - longitude) * _d2r) / 2D), 2D))) <= distance)
//bridges = (from b in db.Bridge
// where (1000D * (b.Latitude - Math.Abs(latitude)) <= distance)
// select b).ToList();
bridges = db.Bridge.ToList();
foreach (var b in bridges)
{
var bsm = new Models.Service.BridgeServiceModel();
bsm.Guid = b.Guid;
bsm.Latitude = b.Latitude;
bsm.Longitude = b.Longitude;
bsm.Location = b.Address1;
bsm.City = b.City;
var bridgeGC = new GeoCoordinate();
bridgeGC.Latitude = bsm.Latitude;
bridgeGC.Longitude = bsm.Longitude;
if (b.Height == null)
b.Height = 0;
bsm.heightRestriction = (float) b.Height;
if (b.Weights.Count >= 1)
if (b.Weights.ElementAt(0).maxWeight != null)
{
bsm.weightStraightTruck = (float)b.Weights.ElementAt(0).maxWeight; ;
}
if (b.Weights.Count >= 2)
if (b.Weights.ElementAt(1).maxWeight != null)
{
bsm.weightSingleTrailer = (float)b.Weights.ElementAt(1).maxWeight;
}
if (b.Weights.Count >= 3)
if (b.Weights.ElementAt(2).maxWeight != null)
{
bsm.weightDoubleTrailer = (float)b.Weights.ElementAt(2).maxWeight;
}
if(bridgeGC.GetDistanceTo(gc) <= distance * 1609.344) // within distance passsed in keep it
{
lbsm.Add(bsm);
}
}
return lbsm;
}
