internal bool AddLocationToMap(NewHorizonsDBContext context) { bool result = true; Markers markers = new Markers() { UserID = UserId, Name = Name, Adress = Address, Hours = Hours, Description = Description, LatLng = LatLng, }; try { context.Markers.Add(markers); context.SaveChanges(); } catch { result = false; } return(result); }
internal static List <AddLocationToMapViewModel> GetAllLocations(NewHorizonsDBContext context) { var dbLocations = context.Markers .ToList(); if (dbLocations != null) { List <AddLocationToMapViewModel> allLocations = new List <AddLocationToMapViewModel>(); foreach (var location in dbLocations) { allLocations.Add(new AddLocationToMapViewModel() { Name = location.Name, Address = location.Adress, Hours = location.Hours, Description = location.Description, LatLng = location.LatLng, }); } return(allLocations); } else { return(null); } }
internal static bool DeleteMarker(NewHorizonsDBContext context, int locID) { bool locationDeleted; var location = context.Markers.Where(l => l.ID == locID).FirstOrDefault(); if (location != null) { context.Remove(location); context.SaveChanges(); locationDeleted = true; } else { locationDeleted = false; } return(locationDeleted); }
internal static bool UpdateMarker(NewHorizonsDBContext context, EditLocationViewModel model) { bool locationUpdated; var location = context.Markers.Where(l => l.ID == model.ID).FirstOrDefault(); if (location != null) { location.Name = model.Name; location.Hours = model.Hours; location.Adress = model.Adress; location.Description = model.Description; context.SaveChanges(); locationUpdated = true; } else { locationUpdated = false; } return(locationUpdated); }
internal static List <EditLocationViewModel> DisplayList(NewHorizonsDBContext context, string userID) { var list = context.Markers.Where(l => l.UserID == userID).ToList(); if (list.Count > 0) { List <EditLocationViewModel> locationList = new List <EditLocationViewModel>(); foreach (var l in list) { locationList.Add(new EditLocationViewModel() { ID = l.ID, Name = l.Name, Adress = l.Adress, UserID = l.UserID, Description = l.Description, Hours = l.Hours, LatLng = l.LatLng }); } return(locationList); } return(null); }
public UserController(NewHorizonsDBContext context, UserManager <ApplicationUser> userManager) { this.context = context; this.userManager = userManager; }
public AdminController(ApplicationDbContext context, NewHorizonsDBContext contextNH, UserManager <ApplicationUser> userManager) { this.contextNH = contextNH; this.context = context; this.userManager = userManager; }
internal static List <HandleLocationViewModel> GetLocations(NewHorizonsDBContext contextNH, ApplicationDbContext context, AdminIndexViewModel model) { List <HandleLocationViewModel> locationList = new List <HandleLocationViewModel>(); if (model.Name != null) { var listDB = contextNH.Markers.Where(m => m.Name.Contains(model.Name)).ToList(); if (listDB != null) { foreach (var m in listDB) { locationList.Add(new HandleLocationViewModel() { ID = m.ID, Name = m.Name, Adress = m.Adress, Hours = m.Hours, Description = m.Description, UserID = m.UserID }); } return(locationList); } else { return(null); } } if (model.Email != null) { var user = context.Users.Where(u => u.Email == model.Email).FirstOrDefault(); if (user != null) { var listDB = contextNH.Markers.Where(m => m.UserID == user.Id).ToList(); if (listDB != null) { foreach (var m in listDB) { locationList.Add(new HandleLocationViewModel() { ID = m.ID, Name = m.Name, Adress = m.Adress, Hours = m.Hours, Description = m.Description, UserID = m.UserID }); } return(locationList); } else { return(null); } } else { return(null); } } else { return(null); } }