// Copy all values from the last record from the user with the same form
public void CopyRecordFromLastEntry(Record record, Form form, User user)
{
try
{
List <ChangeLogRecord> lastRecordChangeLogs = db.ChangeLogsRecords.AsNoTracking()
.Include(m => m.ChangeLog)
.Include(m => m.Record).ThenInclude(r => r.TextData)
.Include(m => m.Record).ThenInclude(r => r.NumericData)
.Include(m => m.Record).ThenInclude(r => r.BooleanData)
.Include(m => m.Record).ThenInclude(r => r.Form).ThenInclude(m => m.FormFormFields).ThenInclude(m => m.FormField)
.Where(m => m.ChangeLog.UserId == user.UserId && m.Record.FormId == form.FormId && m.ChangeLog.Log.Contains("created") && m.Record.StatusId != StatusEnum.deleted && m.Record != record).ToList();
if (lastRecordChangeLogs == null)
{
return;
}
ChangeLogRecord lastRecordChangeLog = lastRecordChangeLogs.OrderBy(m => m.ChangeLog.ChangeDate).Last();
foreach (FormFormField fff in lastRecordChangeLog.Record.Form.FormFormFields)
{
if ((fff.FormField.FieldTypeId == FieldTypeEnum.Choice) || (fff.FormField.FieldTypeId == FieldTypeEnum.Text) || (fff.FormField.FieldTypeId == FieldTypeEnum.DateTime))
{
TextData td = lastRecordChangeLog.Record.TextData.Where(m => m.FormFieldId == fff.FormFieldId).FirstOrDefault();
if (td != null)
{
TextData tdCopy = new TextData()
{
Id = Guid.NewGuid(), FormFieldId = fff.FormFieldId, Record = record, Value = td.Value
};
//if (record.TextData == null) record.TextData = new List<TextData>();
record.TextData.Add(tdCopy);
db.TextData.Add(tdCopy);
}
}
else if (fff.FormField.FieldTypeId == FieldTypeEnum.Number)
{
NumericData td = lastRecordChangeLog.Record.NumericData.Where(m => m.FormFieldId == fff.FormFieldId).FirstOrDefault();
if (td != null)
{
NumericData tdCopy = new NumericData()
{
Id = Guid.NewGuid(), FormFieldId = fff.FormFieldId, Record = record, Value = td.Value
};
//if (record.NumericData == null) record.NumericData = new List<NumericData>();
record.NumericData.Add(tdCopy);
db.NumericData.Add(tdCopy);
db.Entry(tdCopy).State = EntityState.Added;
}
}
else if (fff.FormField.FieldTypeId == FieldTypeEnum.Boolean)
{
BooleanData td = lastRecordChangeLog.Record.BooleanData.Where(m => m.FormFieldId == fff.FormFieldId).FirstOrDefault();
if (td != null)
{
BooleanData tdCopy = new BooleanData()
{
Id = Guid.NewGuid(), FormFieldId = fff.FormFieldId, Record = record, Value = td.Value
};
//if (record.BooleanData == null) record.BooleanData = new List<BooleanData>();
record.BooleanData.Add(tdCopy);
db.BooleanData.Add(tdCopy);
db.Entry(tdCopy).State = EntityState.Added;
}
}
}
}
catch (Exception e)
{
// No form found... we cannot copy anything
return;
}
//db.SaveChanges();
}
/// <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();
}
public BigRational?this[NumericData type]
{
get => _numericDatas.ContainsKey(type) ? _numericDatas[type] : (BigRational?)null;
