public static void UpsertPersonAccountInfo(PersonAccountInfo personAccountInfo) { using (var db = new LiteDatabase(dbName)) { var col = db.GetCollection <PersonAccountInfo>(PersonAccountInfo.CollectionName); col.Upsert(personAccountInfo); } }
public static void UpdateIdPersonAccountInfo(Person person, int newId) { using (var db = new LiteDatabase(dbName)) { PersonAccountInfo pai = getPAIforPerson(person); var col = db.GetCollection <PersonAccountInfo>(PersonAccountInfo.CollectionName); col.EnsureIndex(x => x.personId); col.Delete(pai.personId); pai.personId = newId; col.Insert(pai); } }
public static Control[] accountInfoCardPage(Form form, PersonAccountInfo ai) { List <Control> controls = new List <Control>(); DataColumn[] fields = PersonAccountInfo.dataColumns; object[] data = ai.getAsObjArr(); int startHeight = 50; int startLeft = 20; Size defSize = new Size(250, 80); for (int i = 0; i < fields.Length; i++) { Label lbl = new Label(); lbl.Text = fields[i].ColumnName; lbl.Size = defSize; lbl.Top = startHeight + (i * lbl.Size.Height) + 10; lbl.Left = startLeft; if (fields[i].DataType == typeof(DateTime)) { DateTimePicker dbox = new DateTimePicker(); dbox.Format = DateTimePickerFormat.Short; try { dbox.Value = (DateTime)data[i]; } catch (System.ArgumentOutOfRangeException) { dbox.Format = DateTimePickerFormat.Custom; dbox.CustomFormat = " "; dbox.Validated += new EventHandler(dBoxValidated); dbox.MouseDown += new MouseEventHandler(dBoxValidated); void dBoxValidated(object sender, EventArgs e) { dbox.Format = DateTimePickerFormat.Short; } } setControlBounds(dbox); controls.Add(dbox); } else { TextBox tbox = new TextBox(); if (i < data.Length && data[i] != null) { tbox.Text = data[i].ToString(); } setControlBounds(tbox); controls.Add(tbox); } void setControlBounds(Control control) { control.Top = lbl.Top; control.Left = lbl.Left + lbl.Size.Width + 10; control.Size = defSize; control.Name = lbl.Text; if (control is TextBox) { control.TextChanged += new EventHandler(ctrlTextChanged); } else if (control is ComboBox) { ComboBox cb = (ComboBox)control; cb.SelectedValueChanged += new EventHandler(ctrlTextChanged); } else if (control is DateTimePicker) { DateTimePicker db = (DateTimePicker)control; db.ValueChanged += new EventHandler(ctrlValidated); } void ctrlTextChanged(object sender, EventArgs e) { Control ctrl = (Control)sender; ctrl.Validated += new EventHandler(ctrlValidated); } void ctrlValidated(object sender, EventArgs e) { Control ctrl = (Control)sender; int fieldId = fields.ToList().IndexOf(fields.Where(x => x.ColumnName == ctrl.Name).First()); if (ctrl is DateTimePicker) { DateTime date; if (DateTime.TryParse(ctrl.Text, out date)) { data[fieldId] = date; } } else { if (fields[fieldId].DataType == typeof(int)) { int num; if (int.TryParse(ctrl.Text, out num)) { if (fields[fieldId].Unique) { System.Windows.Forms.MessageBox.Show("Der Primärschlüssel kann nicht geändert werden!", "Meldung"); // person = DBCon.UpdateIdPerson(person, num); // data[fieldId] = num; // control.Parent.Dispose(); } else { data[fieldId] = num; } } } else { data[fieldId] = control.Text; } } ai.setAsObjArr(data); DBCon.UpsertPersonAccountInfo(ai); } } controls.Add(lbl); } return(controls.ToArray()); }
public static Control[] memberCardPage(Form form1, Person person) { List <Control> controls = new List <Control>(); DataColumn[] fields = Person.dataColumns; object[] data = person.getAsObjArr(); int startHeight = 50; int startLeft = 20; Size defSize = new Size(250, 80); int fieldsPerCol = fields.Count() / 2; for (int i = 0; i < fields.Count(); i++) { Label lbl = new Label(); lbl.Text = fields[i].ColumnName; lbl.Size = defSize; lbl.Top = startHeight + (i % fieldsPerCol) * (lbl.Size.Height) + 20; lbl.Left = (i < fieldsPerCol) ? startLeft : (startLeft + defSize.Width * 2 + 50); if (fields[i].DataType == typeof(Person.type)) { ComboBox cbox = new ComboBox(); cbox.DropDownStyle = ComboBoxStyle.DropDownList; foreach (var item in DBObject.GetEnumList <Person.type>()) { cbox.Items.Add(item); } if (i < data.Length && data[i] != null) { cbox.SelectedItem = data[i]; } else { cbox.Text = Person.type.Left.ToString(); } setControlBounds(cbox); controls.Add(cbox); } else if (fields[i].DataType == typeof(Person.paymentType)) { ComboBox cbox = new ComboBox(); cbox.DropDownStyle = ComboBoxStyle.DropDownList; foreach (var item in DBObject.GetEnumList <Person.paymentType>()) { cbox.Items.Add(item); } if (i < data.Length && data[i] != null) { cbox.SelectedItem = data[i]; } else { cbox.Text = Person.paymentType.None.ToString(); } setControlBounds(cbox); controls.Add(cbox); Button btn = new Button(); btn.Image = Image.FromFile("./img/folder_contacts_smol.png"); btn.Height = cbox.Size.Height + 5; btn.Width = btn.Height + 5; btn.Top = cbox.Top; btn.Left = cbox.Left + cbox.Size.Width + 10; btn.Click += new EventHandler(paiBtnClicked); void paiBtnClicked(object sender, EventArgs e) { PersonAccountInfo pai = DBCon.getPAIforPerson(person); if (pai == null) { pai = new PersonAccountInfo(); pai.personId = person.id; pai.personName = person.lastName + ", " + person.firstName; pai.mandateId = person.id; DBCon.UpsertPersonAccountInfo(pai); AccountInfoCard aic = new AccountInfoCard(pai); aic.ShowDialog(); } else { AccountInfoCard aic = new AccountInfoCard(pai); aic.ShowDialog(); } } controls.Add(btn); } else if (fields[i].DataType == typeof(DateTime)) { DateTimePicker dbox = new DateTimePicker(); dbox.Format = DateTimePickerFormat.Short; try { dbox.Value = (DateTime)data[i]; } catch (System.ArgumentOutOfRangeException) { // dbox.Enabled = false; dbox.Format = DateTimePickerFormat.Custom; dbox.CustomFormat = " "; dbox.Validated += new EventHandler(dBoxValidated); dbox.MouseDown += new MouseEventHandler(dBoxValidated); void dBoxValidated(object sender, EventArgs e) { dbox.Format = DateTimePickerFormat.Short; } } setControlBounds(dbox); controls.Add(dbox); } else { TextBox tbox = new TextBox(); if (i < data.Length && data[i] != null) { tbox.Text = data[i].ToString(); } setControlBounds(tbox); controls.Add(tbox); } void setControlBounds(Control control) { control.Top = lbl.Top; control.Left = lbl.Left + lbl.Size.Width + 10; control.Size = defSize; control.Name = lbl.Text; if (control is TextBox) { control.TextChanged += new EventHandler(ctrlTextChanged); } else if ((control is ComboBox)) { ComboBox cb = (ComboBox)control; cb.SelectedValueChanged += new EventHandler(ctrlTextChanged); } else if (control is DateTimePicker) { DateTimePicker db = (DateTimePicker)control; db.ValueChanged += new EventHandler(ctrlValidated); } void ctrlTextChanged(object sender, EventArgs e) { Control ctrl = (Control)sender; ctrl.Validated += new EventHandler(ctrlValidated); } void ctrlValidated(object sender, EventArgs e) { Control ctrl = (Control)sender; int fieldId = fields.ToList().IndexOf(fields.Where(x => x.ColumnName == ctrl.Name).First()); if (ctrl is ComboBox) { Enum.TryParse(fields[fieldId].DataType, ctrl.Text, out data[fieldId]); } else if (ctrl is DateTimePicker) { DateTime date; if (DateTime.TryParse(ctrl.Text, out date)) { data[fieldId] = date; } } else { if (fields[fieldId].DataType == typeof(int)) { int num; if (int.TryParse(ctrl.Text, out num)) { if (fields[fieldId].Unique && person != null) { System.Windows.Forms.MessageBox.Show("Nach einer Primärschlüsseländerung muss die aktuelle Seite geschlossen werden!", "Meldung"); person = DBCon.UpdateIdPerson(person, num); data[fieldId] = num; control.Parent.Dispose(); } else { data[fieldId] = num; } } } else { data[fieldId] = control.Text; } } person.setAsObjArr(data); DBCon.UpsertPerson(person); } } controls.Add(lbl); } return(controls.ToArray()); }
public AccountInfoCard(PersonAccountInfo pai) { this.Text = "Kontoinformationen " + pai.personName; this.WindowState = FormWindowState.Maximized; this.Controls.AddRange(ControlLists.accountInfoCardPage(this, pai)); }