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