//returns ModelsMissingPhotos which contains a List<int> for models:
//Production, ProductionPhotos, Sponsor, and Cast that dont have a picture.
public static ModelsMissingPhotos FindModelsNoPics()
{
var admin = new AdminController();
ModelsMissingPhotos modelsWithNoPics = new ModelsMissingPhotos();
modelsWithNoPics.cast_members = admin.db.CastMembers.Where(p => p.PhotoId == null).OrderBy(p => p.CastMemberID).
Select(p => p.CastMemberID).ToList();
modelsWithNoPics.productions = admin.db.Productions.Where(p => p.DefaultPhoto == null).OrderBy(p => p.ProductionId).
Select(p => p.ProductionId).ToList();
modelsWithNoPics.production_photos = admin.db.ProductionPhotos.Where(p => p.PhotoId == null).OrderBy(p => p.ProPhotoId).
Select(p => p.ProPhotoId).ToList();
modelsWithNoPics.sponsors = admin.db.Sponsors.Where(p => p.LogoId == null).OrderBy(p => p.LogoId).
Select(p => p.SponsorId).ToList();
return(modelsWithNoPics);
}
private void UpdateAdminSettings()
{
//flowchart: reads json file, deserializes, updates the values, serializes new string, and writes result to json file
List <int> currentProd = FindCurrentProductions();
ModelsMissingPhotos miss = FindModelsNoPics();
string json_path = Server.MapPath(Url.Content("~/AdminSettings.json"));
string json_string = null;
using (StreamReader reader = new StreamReader(json_path))
{
json_string = reader.ReadToEnd();
}
JObject json_content = (JObject)JsonConvert.DeserializeObject(json_string);
json_content.Property("current_productions").Value = JToken.FromObject(currentProd);
json_content.Property("models_missing_photos").Value = JToken.FromObject(miss);
string updated_json = JsonConvert.SerializeObject(json_content, Formatting.Indented);
System.IO.File.WriteAllText(json_path, updated_json);
}