public void updateItemList(CustomCollection collection)
{
infoPanel.Hide();
collectionPanel.Show();
collectionLabel.Text = collection.aliase;
selectedCollection = collection;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
dataGridView1.Update();
dataGridView1.Refresh();
List <dynamic> itemList = dbc.getDocuments(collection);
fieldSelectionBox.Items.Clear();
DataTable dt = new DataTable();
dt.Columns.Add("_id");
foreach (Attribute attr in collection.attributes)
{
var columnSpec = new DataColumn
{
DataType = typeof(String),
ColumnName = attr.name
};
if (attr.type == "date")
{
columnSpec.DataType = typeof(DateTime);
}
fieldSelectionBox.Items.Add(attr.name);
dt.Columns.Add(columnSpec);
}
fieldSelectionBox.SelectedItem = collection.attributes[0].name;
foreach (dynamic item in itemList)
{
DataRow row = dt.NewRow();
row["_id"] = item._id;
foreach (Attribute attr in collection.attributes)
{
String name = attr.name;
if (attr.type == "date")
{
String dateString = item[name];
if (dateString == null)
{
DateTime date = DateTime.ParseExact("01.01.2000", "d.M.yyyy", CultureInfo.InvariantCulture);
row[name] = date;
}
else
{
DateTime date = DateTime.ParseExact(dateString, "d.M.yyyy", CultureInfo.InvariantCulture);
row[name] = date;
}
}
else
{
row[name] = item[name];
}
}
dt.Rows.Add(row);
}
this.dataGridView1.AutoGenerateColumns = true;
this.dataGridView1.Columns.Clear();
dataGridView1.DataSource = dt;
if (dataGridView1.Columns["_id"] != null)
{
dataGridView1.Columns["_id"].Visible = false;
}
}
public EditItem(Main mainForm, CustomCollection customCol, DataGridViewRow selectedRow)
{
InitializeComponent();
dbc = new DatabaseController();
this.mainForm = mainForm;
this.customCol = customCol;
this.selectedRow = selectedRow;
tableLayoutPanel1.Controls.Clear();
tableLayoutPanel1.ColumnStyles.Clear();
tableLayoutPanel1.RowStyles.Clear();
tableLayoutPanel1.ColumnCount = 2;
tableLayoutPanel1.RowCount = customCol.attributes.Count;
tableLayoutPanel1.ColumnStyles.Add(new ColumnStyle(SizeType.AutoSize));
tableLayoutPanel1.ColumnStyles.Add(new ColumnStyle(SizeType.AutoSize));
for (int y = 0; y < customCol.attributes.Count; y++)
{
tableLayoutPanel1.RowStyles.Add(new RowStyle(SizeType.Absolute, 40F));
Label fieldName = new Label();
fieldName.Text = customCol.attributes[y].name;
fieldName.TextAlign = ContentAlignment.MiddleRight;
fieldName.Anchor = (AnchorStyles.Left | AnchorStyles.Right);
tableLayoutPanel1.Controls.Add(fieldName, 0, y);
if (customCol.attributes[y].type == "text")
{
TextBox fieldTextBox = new TextBox();
fieldTextBox.Text = selectedRow.Cells[customCol.attributes[y].name].Value.ToString();
fieldTextBox.Tag = customCol.attributes[y].name;
fieldTextBox.Anchor = (AnchorStyles.Left | AnchorStyles.Right);
tableLayoutPanel1.Controls.Add(fieldTextBox, 1, y);
}
else if (customCol.attributes[y].type == "number")
{
TextBox fieldTextBox = new TextBox();
fieldTextBox.Text = selectedRow.Cells[customCol.attributes[y].name].Value.ToString();
fieldTextBox.Tag = customCol.attributes[y].name;
fieldTextBox.Anchor = (AnchorStyles.Left | AnchorStyles.Right);
tableLayoutPanel1.Controls.Add(fieldTextBox, 1, y);
}
else if (customCol.attributes[y].type == "date")
{
DateTimePicker fieldDate = new DateTimePicker();
fieldDate.Text = selectedRow.Cells[customCol.attributes[y].name].Value.ToString();
fieldDate.Tag = customCol.attributes[y].name;
fieldDate.Anchor = (AnchorStyles.Left | AnchorStyles.Right);
tableLayoutPanel1.Controls.Add(fieldDate, 1, y);
}
}
tableLayoutPanel1.RowStyles.Add(new RowStyle(SizeType.Absolute, 40F));
tableLayoutPanel1.Controls.Add(new Label(), 0, customCol.attributes.Count);
tableLayoutPanel1.Controls.Add(new Label(), 1, customCol.attributes.Count);
}
public void setSelectedCollection(CustomCollection selectedCollection)
{
this.selectedCollection = selectedCollection;
}