private void button3_Click(object sender, EventArgs e) { Insert insert = new Insert(); this.Hide(); insert.Show(); }
private void button1_Click(object sender, EventArgs e) { KeyValue keyValue = new KeyValue(); KeyValue kvuk = new KeyValue(); KeyValue kvfknew = new KeyValue(); string tableName = comboBox2.SelectedItem.ToString(); string databaseName = comboBox1.SelectedItem.ToString(); foreach (Control control in this.Controls) { if (control.GetType().Name == "TextBox") { List<PrimaryKey> pkeys = DataLayer.Configuration.GetPrimaryKey(tableName); if (pkeys.Count(x => x.Key == control.Name) > 0) { bool exists = DataLayer.DataAccess.CheckRestriction(databaseName, tableName, control.Text); if (!exists) { MessageBox.Show("The primary key " + control.Name + " already exists!"); return; } } List<UniqueKey> ukeys = DataLayer.Configuration.GetUniqueKeys(tableName); if (ukeys.Count(x => x.Key == control.Name) > 0) { bool exists = DataLayer.DataAccess.CheckRestriction(databaseName, tableName, "uk", control.Text); if (exists) { MessageBox.Show("The unique key " + control.Name + " already exists!"); return; } } List<ForeignKey> fkeys = DataLayer.Configuration.GetForeignKeys(tableName); if (fkeys != null && fkeys.Count(x => x.Key == control.Name) > 0) { ForeignKey fkey = fkeys.FirstOrDefault(x => x.Key == control.Name); bool exists = DataLayer.DataAccess.CheckRestriction(databaseName, fkey, control.Text); if (!exists) { MessageBox.Show("The foreign key " + control.Name + " : " + control.Text + " does not exists!"); return; } } if (pkeys.Count(x => x.Key == control.Name) > 0) { keyValue.key += control.Text; keyValue.key += "#"; } else { keyValue.value += control.Text; keyValue.value += "#"; } if (ukeys.Count(x => x.Key == control.Name) > 0) { kvuk.key += control.Text; kvuk.key += "#"; } else if (pkeys.Count(x => x.Key == control.Name) > 0 && ukeys.Count > 0) { kvuk.value += control.Text; kvuk.value += "#"; } if (fkeys != null && fkeys.Count(x => x.Key == control.Name) > 0 && fkeys.Count > 0) { kvfknew.key += control.Text; } else if (pkeys.Count(x => x.Key == control.Name) > 0) { kvfknew.value = control.Text; } } } if (!string.IsNullOrEmpty(keyValue.key)) { keyValue.key = keyValue.key.Remove(keyValue.key.Length - 1, 1); } if (keyValue.value != null && keyValue.value.Length > 0) { keyValue.value = keyValue.value.Remove(keyValue.value.Length - 1, 1); } if (!string.IsNullOrEmpty(kvuk.key)) { kvuk.key = kvuk.key.Remove(kvuk.key.Length - 1, 1); } if (kvuk.value != null && kvuk.value.Length > 0) { kvuk.value = kvuk.value.Remove(kvuk.value.Length - 1, 1); } DataLayer.DataAccess.InsertInTable(comboBox1.SelectedItem.ToString(), tableName, keyValue); if (kvuk.key != null) DataLayer.DataAccess.InsertInTable(comboBox1.SelectedItem.ToString(), tableName + "uk", kvuk); if (kvfknew.key != null) DataLayer.DataAccess.UpdateExistingFK(databaseName, tableName, kvfknew); // DataLayer.DataAccess.InsertInTable(comboBox1.SelectedItem.ToString(), tableName + "fk", kvfk); MessageBox.Show("Value added successfully !"); Insert insert = new Insert(); this.Dispose(); insert.Show(); }
private void button3_Click(object sender, EventArgs e) { Insert insert = new Insert(); this.Hide(); insert.Show(); }
private void button1_Click(object sender, EventArgs e) { KeyValue keyValue = new KeyValue(); KeyValue kvuk = new KeyValue(); KeyValue kvfknew = new KeyValue(); string tableName = comboBox2.SelectedItem.ToString(); string databaseName = comboBox1.SelectedItem.ToString(); foreach (Control control in this.Controls) { if (control.GetType().Name == "TextBox") { List <PrimaryKey> pkeys = DataLayer.Configuration.GetPrimaryKey(tableName); if (pkeys.Count(x => x.Key == control.Name) > 0) { bool exists = DataLayer.DataAccess.CheckRestriction(databaseName, tableName, control.Text); if (!exists) { MessageBox.Show("The primary key " + control.Name + " already exists!"); return; } } List <UniqueKey> ukeys = DataLayer.Configuration.GetUniqueKeys(tableName); if (ukeys.Count(x => x.Key == control.Name) > 0) { bool exists = DataLayer.DataAccess.CheckRestriction(databaseName, tableName, "uk", control.Text); if (exists) { MessageBox.Show("The unique key " + control.Name + " already exists!"); return; } } List <ForeignKey> fkeys = DataLayer.Configuration.GetForeignKeys(tableName); if (fkeys != null && fkeys.Count(x => x.Key == control.Name) > 0) { ForeignKey fkey = fkeys.FirstOrDefault(x => x.Key == control.Name); bool exists = DataLayer.DataAccess.CheckRestriction(databaseName, fkey, control.Text); if (!exists) { MessageBox.Show("The foreign key " + control.Name + " : " + control.Text + " does not exists!"); return; } } if (pkeys.Count(x => x.Key == control.Name) > 0) { keyValue.key += control.Text; keyValue.key += "#"; } else { keyValue.value += control.Text; keyValue.value += "#"; } if (ukeys.Count(x => x.Key == control.Name) > 0) { kvuk.key += control.Text; kvuk.key += "#"; } else if (pkeys.Count(x => x.Key == control.Name) > 0 && ukeys.Count > 0) { kvuk.value += control.Text; kvuk.value += "#"; } if (fkeys != null && fkeys.Count(x => x.Key == control.Name) > 0 && fkeys.Count > 0) { kvfknew.key += control.Text; } else if (pkeys.Count(x => x.Key == control.Name) > 0) { kvfknew.value = control.Text; } } } if (!string.IsNullOrEmpty(keyValue.key)) { keyValue.key = keyValue.key.Remove(keyValue.key.Length - 1, 1); } if (keyValue.value != null && keyValue.value.Length > 0) { keyValue.value = keyValue.value.Remove(keyValue.value.Length - 1, 1); } if (!string.IsNullOrEmpty(kvuk.key)) { kvuk.key = kvuk.key.Remove(kvuk.key.Length - 1, 1); } if (kvuk.value != null && kvuk.value.Length > 0) { kvuk.value = kvuk.value.Remove(kvuk.value.Length - 1, 1); } DataLayer.DataAccess.InsertInTable(comboBox1.SelectedItem.ToString(), tableName, keyValue); if (kvuk.key != null) { DataLayer.DataAccess.InsertInTable(comboBox1.SelectedItem.ToString(), tableName + "uk", kvuk); } if (kvfknew.key != null) { DataLayer.DataAccess.UpdateExistingFK(databaseName, tableName, kvfknew); } // DataLayer.DataAccess.InsertInTable(comboBox1.SelectedItem.ToString(), tableName + "fk", kvfk); MessageBox.Show("Value added successfully !"); Insert insert = new Insert(); this.Dispose(); insert.Show(); }