private void button1_Click(object sender, EventArgs e) { employee empp = new employee(); department dep = new department(); using (empDBContext emp2 = new empDBContext()) { dep.Name = comboBox1.SelectedItem.ToString(); dep = emp2.departments.Where(data => data.Name == dep.Name).SingleOrDefault(); empp.FirstName = textBox1.Text.ToString(); empp.LastName = textBox2.Text.ToString(); empp.Gender = textBox3.Text.ToString(); empp.Salary = Int32.Parse(textBox4.Text); empp.Department = dep; emp2.employees.Add(empp); int count = emp2.SaveChanges(); if (count > 0) { MessageBox.Show("Add successfully added to db"); } else { MessageBox.Show("Data not edited to db"); } textBox1.Text = ""; textBox2.Text = ""; textBox3.Text = ""; textBox4.Text = ""; dataGridView1.DataSource = repo.getGridData(); } }
public object getGridData() { using (empDBContext emp = new empDBContext()) { return((from employee in emp.employees join department in emp.departments on employee.Department.Id equals department.Id select new { firstname = employee.FirstName, lastname = employee.LastName, name = department.Name }).ToList()); } }
private void Form1_Load(object sender, EventArgs e) { department dp = new department(); using (empDBContext emp = new empDBContext()) { //dp.Name = "hr"; //dp.Location = "kota"; //emp.departments.Add(dp); //emp.SaveChanges(); List <department> d = emp.departments.ToList(); foreach (department x in d) { comboBox1.Items.Add(x.Name); } dataGridView1.DataSource = repo.getGridData(); } }