private void Form1_Load(object sender, EventArgs e) { var clipboardobserver = new ClipboardObserver(); clipboardobserver.ClipboardTextChanged += clipboardobserver_ClipboardTextChanged; using(var dbcontext = new CameeContext()) { var projectcodes = dbcontext.Projecten.Select(pd => pd.ProjectCode); cmbProjectcodes.Items.AddRange(projectcodes.ToArray()); } Hide(); }
private void btnSubmit_Click(object sender, EventArgs e) { using(var dbcontext = new CameeContext()) { // var project = new Projecten(); var projectcode = cmbProjectcodes.Text; var project = dbcontext.Projecten.Where(p => p.ProjectCode == cmbProjectcodes.Text).SingleOrDefault(); var projectdata = new ProjectData { Data = txtData.Text, Datum = DateTime.Now, ProjectCode = projectcode }; if (project == null) { project = new Projecten(); project.ProjectCode = projectcode; dbcontext.Projecten.Add(project); } project.ProjectData.Add(projectdata); dbcontext.SaveChanges(); } Hide(); }