private void BtnProjectScriptRemove_Click(object sender, EventArgs e) { //get selected row from data grid VMHome.ProjectScript dgvProjectScriptsSelectedRow = DgvProjectScripts_GetSelectedRow(); //make sure the selected item is available if (dgvProjectScriptsSelectedRow == null) { return; } //get selected row's entity from databsae project_script repoProjectScript = _ettCommander.project_script.SingleOrDefault(m => m.id == dgvProjectScriptsSelectedRow.Id); //make sure data is exist in database if (repoProjectScript == null) { MessageBox.Show($"project script '{dgvProjectScriptsSelectedRow.Name}' not found in database"); return; } //delete _ettCommander.project_script.Remove(repoProjectScript); //commit _ettCommander.SaveChanges(); //reload data grid DgvProjectScripts_Populate(); }
private void BtnProjectScriptAdd_Click(object sender, EventArgs e) { //get selected project from listbox VMHome.Project lbxProjectsSelectedItem = LbxProjects_GetSelectedItem(); using (FrProjectScriptCreate frProjectScriptCreate = new FrProjectScriptCreate(lbxProjectsSelectedItem)) { //open dialog and get its closed result DialogResult result = frProjectScriptCreate.ShowDialog(); // make sure user is submitting form if (result != DialogResult.OK) { return; } //get selected projcet's entity from database project tbuProject = _ettCommander.projects.SingleOrDefault(m => m.id == lbxProjectsSelectedItem.Id); //make sure data is exist in database if (tbuProject == null) { MessageBox.Show($"project '{lbxProjectsSelectedItem.Name}' not found in database"); return; } //create database model project_script tbiRepoProjectScript = new project_script { name = frProjectScriptCreate.TbxNameValue, script = frProjectScriptCreate.TbxScriptValue, cd = DateTime.Now, }; //update tbuProject.project_script.Add(tbiRepoProjectScript); tbuProject.ud = DateTime.Now; //commit _ettCommander.SaveChanges(); //create file with the script //repopulate project script data grid DgvProjectScripts_Populate(); } }