/// <summary>
/// On creating the view controller for a specific recordId, the form is checked to see which parameters are required, and the relevant input fields are queued up for adding to the page.
/// The relevant data is then extracted from the database for the specific field, and added as the initial value for that field.
/// </summary>
/// <param name="recId">recordID</param>
public FormPageVM(int recId)
{
using (SQLiteConnection conn = new SQLiteConnection(Preferences.Get("databaseLocation", "")))
{
//Get the record and its corresponding variable values
var queriedrec = conn.GetWithChildren <Record>(recId);
ReadOnly = queriedrec.readOnly;
RecId = recId;
var txts = queriedrec.texts;
var nums = queriedrec.numerics;
var bools = queriedrec.booleans;
//Compile the GUID
BDCGUIDtext = "<<BDC><" + queriedrec.recordId + ">>";
var formId = queriedrec.formId;
var formTemp = conn.Table <Form>().Where(Form => Form.formId == formId).FirstOrDefault();
formType = conn.GetWithChildren <Form>(formTemp.Id);
foreach (var formField in formType.formFields.OrderBy(f => f.order))
{
var label = new Label();
if (formField.title != null && formField.title != String.Empty)
{
label.Text = formField.title;
}
else
{
label.Text = formField.description;
}
if (formField.mandatory)
{
label.Text = label.Text + " *";
}
label.FontAttributes = FontAttributes.Bold;
label.Margin = new Thickness(0, 10, 0, 0);
label.SetAppThemeColor(Label.TextColorProperty, Color.Black, Color.White);
if (formField.typeId != 31) //Add label next to checkbox for boolean
{
Assets.Add(label);
}
if (formField.typeId == 11 || formField.typeId == 61)
{
try
{
var text = conn.Table <TextData>().Select(t => t).Where(TextData => TextData.record_fk == RecId).Where(TextData => TextData.formFieldId == formField.fieldId).FirstOrDefault();
var textField = new CustomEntry();
if (text == null)
{
//CreateNew
var txt = new TextData {
textId = Guid.NewGuid().ToString(), title = String.Empty, value = String.Empty, formFieldId = formField.fieldId, record_fk = recId
};
conn.Insert(txt);
txts.Add(txt);
queriedrec.texts = txts;
conn.UpdateWithChildren(queriedrec);
text = txt;
}
textField = new CustomEntry {
Text = text.value.ToString()
};
textField.Keyboard = Keyboard.Text;
textField.Placeholder = formField.description;
textField.ClearButtonVisibility = ClearButtonVisibility.WhileEditing;
textField.ReturnType = ReturnType.Done;
textField.Margin = new Thickness(0, 0, 0, 10);
textField.ValueId = text.Id;
textField.TypeId = formField.typeId;
textField.TextChanged += TextFieldChanged;
textField.IsEnabled = !ReadOnly;
textField.Mandatory = formField.mandatory;
var empty = String.IsNullOrEmpty(textField.Text);
if (formField.mandatory)
{
Validation.Add((int)textField.ValueId, !empty);
}
if (ReadOnly)
{
textField.SetAppThemeColor(Label.BackgroundColorProperty, Color.FromRgb(0.95, 0.95, 0.95), Color.FromRgb(0.2, 0.2, 0.2));
}
Assets.Add(textField);
}
catch (Exception e)
{
Console.WriteLine("Could not create field" + e);
}
}
else if (formField.typeId == 41)
{
try
{
var text = conn.Table <TextData>().Select(t => t).Where(TextData => TextData.record_fk == RecId).Where(TextData => TextData.formFieldId == formField.fieldId).Take(1).FirstOrDefault();
var dateField = new CustomDatePicker();
var timeField = new CustomTimePicker();
var nowButton = new Button();
var clearButton = new Button();
var stack = new CustomStackLayout()
{
Orientation = StackOrientation.Horizontal,
Children =
{
dateField, timeField, nowButton, clearButton
}
};
stack.WidthRequest = 350;
stack.HorizontalOptions = LayoutOptions.Start;
if (text == null)
{
//CreateNew
var txt = new TextData {
textId = Guid.NewGuid().ToString(), title = String.Empty, value = String.Empty, formFieldId = formField.fieldId, record_fk = recId
};
conn.Insert(txt);
txts.Add(txt);
queriedrec.texts = txts;
conn.UpdateWithChildren(queriedrec);
text = txt;
}
List <string> choices = Form.FetchFormChoicesForDropdown(formField.fieldId);
try
{
var dt = DateTime.ParseExact(text.value, "yyyy-MM-ddTHH:mm:sszzz", null);
if (text.value != null && text.value != String.Empty)
{
dateField.NullableDate = dt.Date;
timeField.NullableDate = new TimeSpan(dt.TimeOfDay.Hours, dt.TimeOfDay.Minutes, 0);
}
}
catch (Exception exp)
{
Console.WriteLine(exp);
}
dateField.Margin = new Thickness(0, 0, 0, 10);
dateField.ValueId = text.Id;
dateField.TypeId = formField.typeId;
dateField.Format = "dd MMMM yyyy";
dateField.IsEnabled = !ReadOnly;
dateField.WidthRequest = 170;
dateField.HeightRequest = 40;
dateField.Mandatory = formField.mandatory;
dateField.VerticalOptions = LayoutOptions.StartAndExpand;
dateField.PropertyChanged += DateFieldChanged;
var empty = (dateField.NullableDate == null);
if (formField.mandatory)
{
Validation.Add((int)dateField.ValueId, !empty);
}
if (ReadOnly)
{
dateField.SetAppThemeColor(Label.BackgroundColorProperty, Color.FromRgb(0.95, 0.95, 0.95), Color.FromRgb(0.2, 0.2, 0.2));
}
timeField.Margin = new Thickness(0, 0, 0, 0);
timeField.ValueId = text.Id;
timeField.TypeId = formField.typeId;
timeField.Format = "HH:mm";
timeField.IsEnabled = !ReadOnly;
timeField.WidthRequest = 70;
timeField.HeightRequest = 40;
timeField.VerticalOptions = LayoutOptions.StartAndExpand;
timeField.Mandatory = formField.mandatory;
timeField.PropertyChanged += TimeFieldChanged;
if (ReadOnly)
{
timeField.SetAppThemeColor(Label.BackgroundColorProperty, Color.FromRgb(0.95, 0.95, 0.95), Color.FromRgb(0.2, 0.2, 0.2));
}
Dictionary <String, Object> dic = new Dictionary <string, object>();
dic.Add("text", text);
dic.Add("date", dateField);
dic.Add("time", timeField);
var nowCommand = new Command(FillOutDate);
nowButton.Text = "JETZT";
nowButton.TextTransform = TextTransform.Uppercase;
nowButton.FontSize = 12;
nowButton.Style = (Style)Xamarin.Forms.Application.Current.Resources["TransparentButtonStyle"];
nowButton.Command = nowCommand;
nowButton.CommandParameter = dic;
nowButton.Margin = new Thickness(10, 0, 0, 0);
nowButton.WidthRequest = 40;
nowButton.HeightRequest = 40;
nowButton.VerticalOptions = LayoutOptions.StartAndExpand;
nowButton.IsVisible = !ReadOnly;
var clearCommand = new Command(ClearDate);
clearButton.Text = "ⓧ";
clearButton.FontSize = 20;
clearButton.Style = (Style)Xamarin.Forms.Application.Current.Resources["TransparentButtonStyle"];
clearButton.Command = clearCommand;
clearButton.CommandParameter = dic;
clearButton.Margin = new Thickness(10, 0, 10, 0);
clearButton.WidthRequest = 30;
clearButton.HeightRequest = 40;
clearButton.VerticalOptions = LayoutOptions.StartAndExpand;
clearButton.IsVisible = !ReadOnly;
stack.Margin = new Thickness(0, 0, 0, 10);
stack.ValueId = text.Id;
stack.TypeId = formField.typeId;
Assets.Add(stack);
}
catch (Exception e)
{
Console.WriteLine("Could not create field" + e);
}
}
else if (formField.typeId == 51)
{
try
{
var text = conn.Table <TextData>().Select(t => t).Where(TextData => TextData.record_fk == RecId).Where(TextData => TextData.formFieldId == formField.fieldId).Take(1).FirstOrDefault();
var textField = new CustomPicker();
if (text == null)
{
//CreateNew
var txt = new TextData {
textId = Guid.NewGuid().ToString(), title = String.Empty, value = String.Empty, formFieldId = formField.fieldId, record_fk = recId
};
conn.Insert(txt);
txts.Add(txt);
queriedrec.texts = txts;
conn.UpdateWithChildren(queriedrec);
text = txt;
}
List <string> choices = Form.FetchFormChoicesForDropdown(formField.Id);
textField.ItemsSource = choices;
textField.ValueId = text.Id;
textField.TypeId = formField.Id;
textField.Title = formField.description;
textField.IsEnabled = !ReadOnly;
textField.Mandatory = formField.mandatory;
if (formField.mandatory)
{
Validation.Add((int)textField.ValueId, textField.SelectedItem != null || (text.value != null && text.value != String.Empty));
}
if (ReadOnly)
{
textField.SetAppThemeColor(Label.BackgroundColorProperty, Color.FromRgb(0.95, 0.95, 0.95), Color.FromRgb(0.2, 0.2, 0.2));
}
textField.SelectedIndexChanged += DidSelectFromChoices;
if (text.fieldChoiceId != null)
{
textField.SelectedIndex = choices.FindIndex(a => a.Contains(text.value));
if (textField.SelectedIndex == -1 && (text.value != null && text.value != String.Empty))
{
textField.Title = text.value;
}
textField.SelectedItem = text.value;
}
else if (text.value != null && text.value != String.Empty)
{
textField.Title = text.value;
}
textField.Margin = new Thickness(0, 0, 0, 10);
Assets.Add(textField);
}
catch (Exception e)
{
Console.WriteLine("Could not create field" + e);
}
}
else if (formField.typeId == 21)
{
try
{
var num = conn.Table <NumericData>().Select(n => n).Where(NumericData => NumericData.record_fk == RecId).Where(NumericData => NumericData.formFieldId == formField.fieldId).Take(1).FirstOrDefault();
var textField = new CustomEntry();
if (num == null)
{
//CreateNew
var nm = new NumericData {
numericId = Guid.NewGuid().ToString(), title = String.Empty, value = null, formFieldId = formField.fieldId, record_fk = recId
};
conn.Insert(nm);
nums.Add(nm);
queriedrec.texts = txts;
conn.UpdateWithChildren(queriedrec);
num = nm;
}
textField = new CustomEntry {
Text = ((double)num.value).ToString("F", CultureInfo.CreateSpecificCulture("de-CH"))
};
textField.Keyboard = Keyboard.Numeric;
textField.ClearButtonVisibility = ClearButtonVisibility.WhileEditing;
textField.ReturnType = ReturnType.Done;
textField.Margin = new Thickness(0, 0, 0, 10);
textField.ValueId = num.Id;
textField.TypeId = formField.typeId;
textField.IsEnabled = !ReadOnly;
textField.Mandatory = formField.mandatory;
var empty = String.IsNullOrEmpty(textField.Text);
if (formField.mandatory)
{
Validation.Add((int)textField.ValueId, !empty);
}
if (ReadOnly)
{
textField.SetAppThemeColor(Label.BackgroundColorProperty, Color.FromRgb(0.95, 0.95, 0.95), Color.FromRgb(0.2, 0.2, 0.2));
}
textField.TextChanged += NumericFieldChanged;
Assets.Add(textField);
}
catch (Exception e)
{
Console.WriteLine("Could not create field" + e);
}
}
else if (formField.typeId == 31)
{
try
{
var boolValue = conn.Table <BooleanData>().Select(n => n).Where(BooleanData => BooleanData.record_fk == RecId).Where(BooleanData => BooleanData.formFieldId == formField.fieldId).Take(1).FirstOrDefault();
var checkBox = new CustomCheckBox();
if (boolValue == null)
{
//CreateNew
boolValue = new BooleanData {
booleanId = Guid.NewGuid().ToString(), title = String.Empty, value = false, formFieldId = formField.fieldId, record_fk = recId
};
conn.Insert(boolValue);
bools.Add(boolValue);
queriedrec.booleans = bools;
conn.UpdateWithChildren(queriedrec);
}
if (boolValue != null)
{
checkBox.IsChecked = (bool)boolValue.value;
}
checkBox.Margin = new Thickness(0, 0, 0, 0);
checkBox.ValueId = boolValue.Id;
checkBox.TypeId = formField.typeId;
checkBox.IsEnabled = !ReadOnly;
if (ReadOnly)
{
checkBox.Color = Color.LightGray;
}
checkBox.CheckedChanged += BooleanFieldChanged;
checkBox.VerticalOptions = LayoutOptions.Fill;
checkBox.HorizontalOptions = LayoutOptions.Start;
label.VerticalOptions = LayoutOptions.Fill;
label.VerticalTextAlignment = TextAlignment.Center;
label.Margin = new Thickness(0, 0, 0, 0);
var stack = new CustomStackLayout()
{
Orientation = StackOrientation.Horizontal,
HorizontalOptions = LayoutOptions.Start,
VerticalOptions = LayoutOptions.Fill,
Children =
{
checkBox, label
}
};
stack.Margin = new Thickness(0, 0, 0, 10);
Assets.Add(stack);
}
catch (Exception e)
{
Console.WriteLine("Could not create field" + e);
}
}
}
var geomlabel = new Label();
geomlabel.Text = "Zugeordnete Geometrie";
geomlabel.FontAttributes = FontAttributes.Bold;
geomlabel.Margin = new Thickness(0, 10, 0, 0);
Assets.Add(geomlabel);
AssociatedGeometry = new CustomPicker();
Geoms = ReferenceGeometry.GetAllGeometries().Where(g => g.status < 3).OrderBy(g => g.geometryName).ToList();
foreach (var gm in Geoms)
{
if (gm.geometryName == null)
{
gm.geometryName = String.Empty; //Avoid a crash on android from null strings
}
}
var general = new ReferenceGeometry()
{
geometryName = "Allgemeine Beobachtung"
};
AssociatedGeometry.ItemsSource = Geoms;
AssociatedGeometry.ItemsSource.Insert(0, general);
AssociatedGeometry.ItemDisplayBinding = new Binding("geometryName");
AssociatedGeometry.TypeId = -999;
if (queriedrec.geometry_fk != null)
{
var geom = ReferenceGeometry.GetGeometry((int)queriedrec.geometry_fk);
var selectedGeomIndex = Geoms.FindIndex(a => a.Id == geom.Id);
AssociatedGeometry.SelectedIndex = selectedGeomIndex++;
}
else
{
AssociatedGeometry.SelectedIndex = 0;
}
AssociatedGeometry.Margin = new Thickness(0, 0, 0, 10);
AssociatedGeometry.IsEnabled = !ReadOnly;
if (ReadOnly)
{
AssociatedGeometry.SetAppThemeColor(Label.BackgroundColorProperty, Color.FromRgb(0.95, 0.95, 0.95), Color.FromRgb(0.2, 0.2, 0.2));
}
AssociatedGeometry.SelectedIndexChanged += DidSelectNewGeometry;
Assets.Add(AssociatedGeometry);
}
var DeleteButton = new Button();
DeleteCommand = new Command(OnDelete, ValidateDelete);
DeleteButton.ImageSource = "delete.png";
DeleteButton.Command = DeleteCommand;
DeleteButton.Style = (Style)Xamarin.Forms.Application.Current.Resources["DangerButtonStyle"];
DeleteButton.Margin = new Thickness(0, 10);
DeleteButton.CornerRadius = 10;
DeleteButton.TextTransform = TextTransform.Uppercase;
DeleteButton.WidthRequest = 50;
var GUIDButton = new Button();
GUIDCommand = new Command(CopyGUID);
GUIDButton.Text = "GUID";
GUIDButton.BackgroundColor = (Color)Xamarin.Forms.Application.Current.Resources["BioDivGreen"];
GUIDButton.Command = GUIDCommand;
GUIDButton.HorizontalOptions = LayoutOptions.FillAndExpand;
GUIDButton.TextColor = Color.White;
GUIDButton.Margin = new Thickness(0, 10);
GUIDButton.CornerRadius = 10;
GUIDButton.TextTransform = TextTransform.Uppercase;
GUIDButton.WidthRequest = 250;
var buttonLayout = new FlexLayout
{
Children =
{
DeleteButton, GUIDButton
}
};
buttonLayout.Direction = FlexDirection.Row;
buttonLayout.JustifyContent = FlexJustify.SpaceAround;
buttonLayout.HorizontalOptions = LayoutOptions.FillAndExpand;
buttonLayout.AlignContent = FlexAlignContent.SpaceAround;
Assets.Add(buttonLayout);
SaveCommand = new Command(OnSave, ValidateSave);
CancelCommand = new Command(OnCancel);
this.PropertyChanged +=
(_, __) => SaveCommand.ChangeCanExecute();
}
/// <summary>
/// Based on the current sorting and filtering methods, read the groups into which the records should be sorted, then read the records associated with each of these groups. When reading the records, we also need to know their associated forms and geometries
/// </summary>
public void UpdateRecords()
{
Activity = true;
var recs = new List <GroupedFormRec>();
if (recs != null && SortBy != "Formulartyp")
{
if (FilterBy == "Formulartyp")
{
var frm = Form.FetchForm((int)Form_pk);
foreach (var group in App.RecordLists.RecordsByGeometry)
{
var newGroup = new GroupedFormRec();
newGroup.LongGeomName = group.LongGeomName;
newGroup.ShortGeomName = group.ShortGeomName;
newGroup.GeomId = group.GeomId;
newGroup.ShowButton = group.ShowButton;
newGroup.Geom = group.Geom;
foreach (FormRec form in group)
{
if (form.FormId == frm.formId)
{
newGroup.Add(form);
}
}
recs.Add(newGroup);
}
}
else if (FilterBy == "Geometrie" && Object_pk != null)
{
var obj = ReferenceGeometry.GetGeometry((int)Object_pk);
foreach (var group in App.RecordLists.RecordsByGeometry)
{
try
{
if (group.GeomId == obj.Id)
{
recs.Add(group);
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
}
else
{
recs = App.RecordLists.RecordsByGeometry;
}
Records = new ObservableCollection <GroupedFormRec>(recs);
}
else if (recs != null && SortBy == "Formulartyp")
{
if (FilterBy == "Formulartyp")
{
var frm = Form.FetchForm((int)Form_pk);
foreach (var group in App.RecordLists.RecordsByForm)
{
var newGroup = new GroupedFormRec();
newGroup.LongGeomName = group.LongGeomName;
newGroup.ShortGeomName = group.ShortGeomName;
newGroup.GeomId = group.GeomId;
newGroup.ShowButton = group.ShowButton;
newGroup.Geom = group.Geom;
foreach (FormRec form in group)
{
if (form.FormId == frm.formId)
{
newGroup.Add(form);
}
}
recs.Add(newGroup);
}
}
else if (FilterBy == "Geometrie" && Object_pk != null)
{
var obj = ReferenceGeometry.GetGeometry((int)Object_pk);
foreach (var group in App.RecordLists.RecordsByForm)
{
var newGroup = new GroupedFormRec();
newGroup.LongGeomName = group.LongGeomName;
newGroup.ShortGeomName = group.ShortGeomName;
newGroup.GeomId = group.GeomId;
newGroup.ShowButton = group.ShowButton;
newGroup.Geom = group.Geom;
foreach (FormRec form in group)
{
if (form.GeomId == obj.Id)
{
newGroup.Add(form);
}
}
recs.Add(newGroup);
}
}
else
{
recs = App.RecordLists.RecordsByForm;
}
Records = new ObservableCollection <GroupedFormRec>(recs);
}
else
{
Records = new ObservableCollection <GroupedFormRec>();
}
OnPropertyChanged("Records");
Activity = false;
}