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();
}
}
