/****************************************Functions**************************************************/
private void C_Click(object sender, EventArgs e)
{
// our code .............
FileStream fs = new FileStream("table_name.txt", FileMode.OpenOrCreate);
StreamReader sr = new StreamReader(fs);
string table_name = sr.ReadLine();
sr.Close();
fs.Close();
List <tables> table_list = new List <tables>();
table_list = get_List_of_Tables();
tables tab = new tables();
tab.table_name = table_name;
List <Columns> col_list = new List <Columns>();
for (int i = 0; i < dataGridView1.RowCount - 1; i++)
{
Columns temp_col = new Columns();
temp_col.name = dataGridView1.Rows[i].Cells[0].Value.ToString();
temp_col.type = dataGridView1.Rows[i].Cells[1].Value.ToString();
if (dataGridView1.Rows[i].Cells[2].Value != null)
{
tab.Primary_keys.Add(temp_col.name);
}
col_list.Add(temp_col);
}
tab.Table_colums = col_list;
table_list.Add(tab);
Save(table_list);
DataTable t = new DataTable();
dataGridView1.DataSource = t;
if (Constrain_T.instance.Visible == false)
{
Constrain_T.instance.Visible = true;
}
if (!panel.Controls.Contains(Constrain_T.instance))
{
panel.Controls.Add(Constrain_T.instance);
Constrain_T.instance.Dock = DockStyle.Fill;
Constrain_T.instance.BringToFront();
}
else
{
Constrain_T.instance.BringToFront();
}
}
private void combo_T_Names_SelectedIndexChanged(object sender, EventArgs e)
{
List <tables> table_list = new List <tables>();
table_list = get_List_of_Tables();
tables table = new tables();
string table_name = combo_T_Names.SelectedItem.ToString();
for (int i = 0; i < table_list.Count; i++)
{
if (table_list.ElementAt(i).table_name == table_name)
{
table = table_list.ElementAt(i);
break;
}
}
DataTable temp = new DataTable();
for (int i = 0; i < table.Table_colums.Count; i++)
{
temp.Rows.Add();
}
dataGridView1.DataSource = temp;
for (int i = 0; i < table.Table_colums.Count; i++)
{
if (table.Primary_keys.Contains(table.Table_colums[i].name.ToString()))
{
dataGridView1.Rows[i].Cells[2].Value = true;
}
}
for (int i = 0; i < table.Table_colums.Count; i++)
{
dataGridView1.Rows[i].Cells[0].Value = table.Table_colums[i].name.ToString();
dataGridView1.Rows[i].Cells[1].Value = table.Table_colums[i].type.ToString();
}
}
/****************************************Functions**************************************************/
private void button3_Click(object sender, EventArgs e)
{
if (combo_T_Names.Text == "")
{
MessageBox.Show("Please Select Table", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
List <tables> table_list = new List <tables>();
table_list = get_List_of_Tables();
tables tab = new tables();
tab.table_name = combo_T_Names.SelectedItem.ToString();
List <Columns> col_list = new List <Columns>();
for (int i = 0; i < dataGridView1.RowCount - 1; i++)
{
Columns temp_col = new Columns();
temp_col.name = dataGridView1.Rows[i].Cells[0].Value.ToString();
temp_col.type = dataGridView1.Rows[i].Cells[1].Value.ToString();
if (dataGridView1.Rows[i].Cells[2].Value != null)
{
tab.Primary_keys.Add(temp_col.name);
}
col_list.Add(temp_col);
}
tab.Table_colums = col_list;
int index = 0;
for (int i = 0; i < table_list.Count; i++)
{
if (table_list.ElementAt(i).table_name == combo_T_Names.SelectedItem.ToString())
{
index = i;
break;
}
}
// copy constrains and data to temp
for (int i = 0; i < table_list[index].Table_colums.Count; i++)
{
tab.Table_colums[i].constrains = table_list[index].Table_colums[i].constrains;
}
for (int i = 0; i < table_list[index].Table_colums.Count; i++)
{
tab.Table_colums[i].data = table_list[index].Table_colums[i].data;
}
table_list[index] = tab;
Save(table_list);
string T_name = combo_T_Names.Text;
FileStream f = new FileStream("table_name.txt", FileMode.OpenOrCreate);
StreamWriter wr = new StreamWriter(f);
wr.WriteLine(T_name);
wr.Close();
f.Close();
combo_T_Names.Text = "";
combo_T_Names.Items.Clear();
DataTable dd = new DataTable();
dataGridView1.DataSource = dd;
if (Upda_Constrain.instance.Visible == false)
{
Upda_Constrain.instance.Visible = true;
}
if (!panel1.Controls.Contains(Upda_Constrain.instance))
{
panel1.Controls.Add(Upda_Constrain.instance);
Upda_Constrain.instance.Dock = DockStyle.Fill;
Upda_Constrain.instance.BringToFront();
}
else
{
Upda_Constrain.instance.BringToFront();
}
}
}
