//Constructor public viewmodel_reviewStageThree() { //Read all items from the table. System.Collections.Generic.List <Models.model_gunownership> itemCollection = Models.model_gunownership.GetAll().Result; //Filter and assign items based on Race, feature. Models.model_gunownership item_Black = itemCollection.Find(i => i.Race == "Black"); Models.model_gunownership item_White = itemCollection.Find(i => i.Race == "White"); Models.model_gunownership item_Other = itemCollection.Find(i => i.Race == "Other"); PropertyRace1 = item_White.Race; PropertyTotal1 = item_White.OwnGunNo + item_White.OwnGunNotAnswered + item_White.OwnGunRefused + item_White.OwnGunYes; PropertyRace2 = item_Black.Race; PropertyTotal2 = item_Black.OwnGunNo + item_Black.OwnGunNotAnswered + item_Black.OwnGunRefused + item_Black.OwnGunYes; PropertyRace3 = item_Other.Race; PropertyTotal3 = item_Other.OwnGunNo + item_Other.OwnGunNotAnswered + item_Other.OwnGunRefused + item_Other.OwnGunYes; List <Microcharts.Entry> entries = new List <Microcharts.Entry> { new Microcharts.Entry(item_White.OwnGunNo) { Color = SKColor.Parse("#a83232"), Label = "OwnGun", ValueLabel = "No" }, new Microcharts.Entry(item_White.OwnGunNotAnswered) { Color = SKColor.Parse("#9a32a8"), Label = "OwnGun", ValueLabel = "Not Answered" }, new Microcharts.Entry(item_White.OwnGunRefused) { Color = SKColor.Parse("#3238a8"), Label = "OwnGun", ValueLabel = "Refused" }, new Microcharts.Entry(item_White.OwnGunYes) { Color = SKColor.Parse("#32a842"), Label = "OwnGun", ValueLabel = "Yes" } }; PropertyData = new BarChart() { Entries = entries, BackgroundColor = SKColors.Transparent }; }
//Constructor public viewmodel_reviewStageTwo() { var mguns = Models.model_gunownership.GetAll(); if (mguns.Result.Count == 0) { // Application.Current.MainPage.DisplayAlert("Warning", "Model empty", null, "Ok"); Models.model_gunownership mWhite = new Models.model_gunownership(); Models.model_gunownership mBlack = new Models.model_gunownership(); Models.model_gunownership mOther = new Models.model_gunownership(); mWhite.Race = "White"; mWhite.OwnGunYes = 12448; mWhite.OwnGunNo = 15235; mWhite.OwnGunRefused = 266; mWhite.OwnGunNotAnswered = 18401; mWhite.SaveItem(); mBlack.Race = "Black"; mBlack.OwnGunYes = 1269; mBlack.OwnGunNo = 3586; mBlack.OwnGunRefused = 39; mBlack.OwnGunNotAnswered = 3032; mBlack.SaveItem(); mOther.Race = "Other"; mOther.OwnGunYes = 283; mOther.OwnGunNo = 1323; mOther.OwnGunRefused = 10; mOther.OwnGunNotAnswered = 1169; mOther.SaveItem(); } else { //Application.Current.MainPage.DisplayAlert("Warning", "Model has content", null, "Ok"); } }