private void btnKeysAdd_Click(object sender, EventArgs e)
{
NewTableController controller = new NewTableController();
try
{
controller.CheckThoseDamnAtributesToPrimaryKeys(cmbColumnAtribut.SelectedItem.ToString(), dirPath1);
for (int i = 0; i < dgvStupci.RowCount - 1; i++)
{
if (dgvStupci.Rows[i].Cells[0].Value.ToString() == cmbColumnAtribut.SelectedItem.ToString())
{
dgvStupci.Rows[i].Cells[4].Value = true;
dgvStupci.Rows[i].Cells[3].Value = true;
dgvStupci.Refresh();
dgvKeys.Rows.Add(1);
dgvKeys.Rows[rowIndex].Cells[0].Value = cmbColumnAtribut.SelectedItem.ToString();
dgvKeys.Rows[rowIndex].Cells[1].Value = dgvStupci.Rows[i].Cells[1].Value;
dgvKeys.Rows[rowIndex].Cells[2].Value = chcboxKeysPrimary.Checked;
rowIndex++;
}
}
cmbColumnAtribut.DataSource = controller.ListOfTableAtributesForPrimaryKey(dirPath1);
}
catch { }
}
static void Main()
{
NewTableController dat = new NewTableController();
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new formERADijagram());
}
public void btnSaveProjectName_Click(object sender, EventArgs e)
{
NewTableController controller = new NewTableController();
LoadProjects loadProjects = new LoadProjects();
bool exists = false;
foreach (var project in loadProjects.ProjectList())
{
if (project == projectName1 && rename1)
{
string folderName = loadProjects.CreateProjectDirectory();
string pathString = System.IO.Path.Combine(folderName, projectName1.Replace(" ", "_"));
string pathString1 = System.IO.Path.Combine(folderName, txtProjectName.Text.Replace(" ", "_"));
if (!loadProjects.ProjectList().Contains(txtProjectName.Text.Replace(" ", "_")))
{
if (controller.CheckTextInput(txtProjectName.Text.Replace(" ", "_")))
{
System.IO.Directory.Move(pathString, pathString1);
f1.oldName = projectName1.Replace(" ", "_");
f1.newProject = txtProjectName.Text.Replace(" ", "_");
f1.projectIsRenamed = true;
this.Hide();
}
else
{
MessageBox.Show("Invalid input!");
}
}
}
else if (project == txtProjectName.Text.Replace(" ", "_"))
{
exists = true;
}
}
if (!exists)
{
if (controller.CheckTextInput(txtProjectName.Text))
{
string folderName = loadProjects.CreateProjectDirectory();
string pathString = System.IO.Path.Combine(folderName, txtProjectName.Text.Replace(" ", "_"));
System.IO.Directory.CreateDirectory(pathString);
f1.newProject = txtProjectName.Text.Replace(" ", "_");
this.Hide();
}
else if (!rename1)
{
txtProjectName.Text = "";
MessageBox.Show("Invalid input");
}
}
else
{
MessageBox.Show("Project already exists!");
}
}
private void btnNewColumnRemove_Click(object sender, EventArgs e)
{
NewTableController controller = new NewTableController();
try
{
int lineToDelete = dgvStupci.CurrentCell.RowIndex;
string atributName = dgvStupci.Rows[lineToDelete].Cells[0].Value.ToString();
dgvStupci.Rows.RemoveAt(lineToDelete);
controller.DelteRowFromTable(lineToDelete, dirPath1);
brojAtributa--;
cmbColumnAtribut.DataSource = controller.ListOfTableAtributesForPrimaryKey(dirPath1);
cmbCurrentTableAtributes.DataSource = controller.ListOfAtributesInCurrentTable(dirPath1);
try
{
int rowIndex1 = -1;
int newRowIndex = -1;
foreach (DataGridViewRow row in dgvForeignKeys.Rows)
{
if (row.Cells[1].Value != null)
{
if (row.Cells[1].Value.ToString().Equals(atributName))
{
rowIndex1 = row.Index;
dgvForeignKeys.Rows.RemoveAt(rowIndex1);
rowIndexForFK--;
break;
}
}
}
foreach (DataGridViewRow row in dgvKeys.Rows)
{
if (row.Cells[0].Value != null)
{
if (row.Cells[0].Value.ToString().Equals(atributName))
{
newRowIndex = row.Index;
dgvKeys.Rows.RemoveAt(newRowIndex);
rowIndex--;
break;
}
}
}
}
catch
{
}
}
catch (Exception f)
{
MessageBox.Show("Please select valid row");
}
}
private void btnOdustani_Click(object sender, EventArgs e)
{
NewTableController controller = new NewTableController();
LoadProjects loadProjects = new LoadProjects();
if (brojAtributa < 1 || !controller.CheckPrimaryKey(dirPath1))
{
controller.DeleteTable(dirPath1);
loadProjects.DeleteTableDependece(projectName1, tableName1 + ".dat");
}
this.Close();
}
private void btnSaveTableName_Click(object sender, EventArgs e)
{
NewTableController controller = new NewTableController();
LoadProjects loadProjects = new LoadProjects();
bool exists = false;
foreach (var table in loadProjects.LoadTables(projectName))
{
if ((table) == (tableName1 + ".dat") && rename1)
{
string projectPath = loadProjects.CreateProjectDirectory() + "\\" + projectName + "\\" + tableName1.Replace(" ", "_") + ".dat";
string projectPath1 = loadProjects.CreateProjectDirectory() + "\\" + projectName + "\\" + txtTableName.Text.Replace(" ", "_") + ".dat";
string projectPathForChangeFK = loadProjects.CreateProjectDirectory() + "\\" + projectName;
controller.ChangeFKNameInDatAfterRenaming(tableName1.Replace(" ", "_"), txtTableName.Text.Replace(" ", "_"), projectName, projectPathForChangeFK);
if (!loadProjects.LoadTables(projectName).Contains(txtTableName.Text + ".dat"))
{
if (controller.CheckTextInput(txtTableName.Text.Replace(" ", "_")))
{
System.IO.File.Move(projectPath, projectPath1);
this.Close();
}
else
{
MessageBox.Show("Invalid input");
}
}
}
if (table == txtTableName.Text + ".dat")
{
MessageBox.Show("Table already exists!");
exists = true;
}
}
if (controller.CheckTextInput(txtTableName.Text) && !rename1 && !exists)
{
string projectPath = loadProjects.CreateProjectDirectory() + "\\" + projectName + "\\" + txtTableName.Text.Replace(" ", "_") + ".dat";
FileStream fs = File.Create(projectPath);
fs.Close();
formNovaTablica frmNewTable = new formNovaTablica(txtTableName.Text, projectPath, projectName);
frmNewTable.Show();
this.Close();
}
else if (!controller.CheckTextInput(txtTableName.Text) && !rename1)
{
MessageBox.Show("Invalid input!");
}
}
private void cmbFKTableName_SelectionChangeCommitted(object sender, EventArgs e)
{
NewTableController controller = new NewTableController();
string dirPathForSelectedTable = dirPath1.Substring(0, dirPath1.LastIndexOf("\\")) + "\\" + cmbFKTableName.SelectedItem.ToString() + ".dat";
//Treba ocistit cmb ako nema atributa u tom
if (controller.ListOfPrimaryKeysForSpecificTable(dirPathForSelectedTable).Count != 0)
{
cmbSelectedTablePK.DataSource = controller.ListOfPrimaryKeysForSpecificTable(dirPathForSelectedTable);
}
else
{
cmbSelectedTablePK.DataSource = null;
}
}
private void btnDeleteForeignKey_Click(object sender, EventArgs e)
{
NewTableController controller = new NewTableController();
try
{
int lineNumber = dgvForeignKeys.CurrentCell.RowIndex;
string atributName = dgvForeignKeys.Rows[lineNumber].Cells[1].Value.ToString();
controller.DeleteForeignKey(dirPath1, atributName);
dgvForeignKeys.Rows.RemoveAt(lineNumber);
rowIndexForFK--;
}
catch (Exception f)
{
MessageBox.Show("Please select valid row");
}
}
private void v_Click(object sender, EventArgs e)
{
NewTableController controller = new NewTableController();
if (cmbFKTableName.SelectedIndex > -1 && cmbCurrentTableAtributes.SelectedIndex > -1 && cmbSelectedTablePK.SelectedIndex > -1)
{
dgvForeignKeys.Rows.Add(1);
dgvForeignKeys.Rows[rowIndexForFK].Cells[0].Value = cmbFKTableName.SelectedItem;
dgvForeignKeys.Rows[rowIndexForFK].Cells[1].Value = cmbCurrentTableAtributes.SelectedItem;
dgvForeignKeys.Rows[rowIndexForFK].Cells[2].Value = cmbSelectedTablePK.SelectedItem;
rowIndexForFK++;
controller.InsertFKIntoFile(dirPath1, cmbCurrentTableAtributes.SelectedItem.ToString(), cmbFKTableName.SelectedItem.ToString(), cmbSelectedTablePK.SelectedItem.ToString());
}
else
{
MessageBox.Show("Plase selecet all required elements!");
}
}
private void btnSpremi_Click(object sender, EventArgs e)
{
NewTableController controller = new NewTableController();
LoadProjects loadProjects = new LoadProjects();
if (brojAtributa < 1)
{
controller.DeleteTable(dirPath1);
loadProjects.DeleteTableDependece(projectName1, tableName1 + ".dat");
this.Close();
}
else
{
if (!controller.CheckPrimaryKey(dirPath1))
{
MessageBox.Show("There is no primary key");
}
else
{
this.Close();
}
}
}
private void btnUnosStupca_Click(object sender, EventArgs e)
{
NewTableController kontroler = new NewTableController();
DataTypes dataTypes = new DataTypes();
if (kontroler.CheckForSameAtributes(dirPath1, txtName.Text))
{
if (kontroler.CheckTextInput(txtName.Text) && kontroler.CheckDataType(txtType.Text))
{
if (chcBoxNotNull.Checked == false && chcoxPrimaryKey.Checked == true)
{
MessageBox.Show("Primary key can not be null!");
}
else if ((kontroler.CheckPrimaryKey(dirPath1) && chcoxPrimaryKey.Checked == true))
{
MessageBox.Show("Primary key already exists!");
}
else if (kontroler.CheckPrimaryKeyType(txtType.Text) && chcoxPrimaryKey.Checked == true)
{
MessageBox.Show("Primary key is wrong type!");
}
else
{
dgvStupci.Rows.Add(1);
dgvStupci.Rows[brojAtributa].Cells[0].Value = kontroler.ProvjeraImena(txtName.Text);
dgvStupci.Rows[brojAtributa].Cells[1].Value = txtType.Text;
dgvStupci.Rows[brojAtributa].Cells[2].Value = chcboxAutoInc.Checked;
dgvStupci.Rows[brojAtributa].Cells[3].Value = chcBoxNotNull.Checked;
dgvStupci.Rows[brojAtributa].Cells[4].Value = chcoxPrimaryKey.Checked;
brojAtributa++;
string foreingName = string.Empty;
foreingName += txtForeignName.Text;
kontroler.InsertDataIntoTextFile(dirPath1, dgvStupci.NewRowIndex, kontroler.ProvjeraImena(txtName.Text), txtType.Text, chcBoxNotNull.Checked, chcboxAutoInc.Checked, chcboxUnique.Checked, chcoxPrimaryKey.Checked, foreingName);
cmbColumnAtribut.DataSource = kontroler.ListOfTableAtributesForPrimaryKey(dirPath1);
cmbCurrentTableAtributes.DataSource = kontroler.ListOfAtributesInCurrentTable(dirPath1);
if (chcoxPrimaryKey.Checked)
{
dgvKeys.Rows.Add(1);
dgvKeys.Rows[rowIndex].Cells[0].Value = kontroler.ProvjeraImena(txtName.Text);
dgvKeys.Rows[rowIndex].Cells[1].Value = txtType.Text;
dgvKeys.Rows[rowIndex].Cells[2].Value = true;
rowIndex++;
}
}
}
else
{
MessageBox.Show("Wrong input");
}
}
else
{
MessageBox.Show("Attribute already exists");
}
//Reset fields
txtName.Clear();
txtType.Clear();
chcboxAutoInc.Checked = false;
chcoxPrimaryKey.Checked = false;
chcBoxNotNull.Checked = false;
chcboxUnique.Checked = false;
}
private void formNovaTablica_Load(object sender, EventArgs e)
{
brojAtributa = 0;
rowIndex = 0;
rowIndexForFK = 0;
txtTableName.Text = tableName1.Replace(" ", "_");
txtKeyNameTable.Text = tableName1.Replace(" ", "_");
NewTableController controller = new NewTableController();
LoadProjects loadProjects = new LoadProjects();
if (reload1)
{
foreach (var item in loadProjects.OpenSpecificTable(dirPath1))
{
string[] parts = item.Split(',');
dgvStupci.Rows.Add(1);
dgvStupci.Rows[brojAtributa].Cells[0].Value = parts[0].ToString();
dgvStupci.Rows[brojAtributa].Cells[1].Value = parts[1].ToString();
if (parts[3].ToString() == "True")
{
dgvStupci.Rows[brojAtributa].Cells[2].Value = true;
}
else
{
dgvStupci.Rows[brojAtributa].Cells[2].Value = false;
}
if (parts[2].ToString() == "True")
{
dgvStupci.Rows[brojAtributa].Cells[3].Value = true;
}
else
{
dgvStupci.Rows[brojAtributa].Cells[3].Value = false;
}
if (parts[4].ToString() == "True")
{
dgvKeys.Rows.Add(1);
dgvStupci.Rows[brojAtributa].Cells[4].Value = true;
dgvKeys.Rows[rowIndex].Cells[0].Value = parts[0].ToString();
dgvKeys.Rows[rowIndex].Cells[1].Value = parts[1].ToString();
dgvKeys.Rows[rowIndex].Cells[2].Value = true;
rowIndex++;
}
else
{
dgvStupci.Rows[brojAtributa].Cells[4].Value = false;
}
if (parts[5].ToString() != "")
{
string[] line = parts[5].Split(':');
dgvForeignKeys.Rows.Add(1);
dgvForeignKeys.Rows[rowIndexForFK].Cells[0].Value = line[0].Substring(line[0].IndexOf("[") + 1, line[0].Length - 1);
dgvForeignKeys.Rows[rowIndexForFK].Cells[1].Value = parts[0];
dgvForeignKeys.Rows[rowIndexForFK].Cells[2].Value = line[1].Substring(0, line[1].IndexOf("]"));
rowIndexForFK++;
}
brojAtributa++;
}
}
cmbFKTableName.DataSource = loadProjects.LoadTablesWithoutExtension(projectName1);
cmbColumnAtribut.DataSource = controller.ListOfTableAtributesForPrimaryKey(dirPath1);
cmbCurrentTableAtributes.DataSource = controller.ListOfAtributesInCurrentTable(dirPath1);
}
