private void button1_Click(object sender, EventArgs e) { GlobalVar gl = new GlobalVar(); Medicine_Data data = new Medicine_Data(); MedicineContext context = new MedicineContext(); if (comboBox1.Text != "") { if (gl.CheckDistinct_ValueGrid(dataGridView1, comboBox1.Text)) { int _ser_id = Convert.ToInt32(context.Services.Where(c => c.service_name == comboBox1.Text).Select(c => c.service_id).FirstOrDefault()); data.CreateONE_Attendances_Record(GlobalVar.selected_reception_ID, _ser_id); dataGridView1.Rows.Clear(); foreach (var r in context.Attendances.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _ser_name = context.Services.Where(c => c.service_id == r.service_id).Select(c => c.service_name).FirstOrDefault().ToString(); string _ser_price = context.Services.Where(c => c.service_id == r.service_id).Select(c => c.service_price).FirstOrDefault().ToString(); dataGridView1.Rows.Add(r.service_id, _ser_name, _ser_price); } gl.SetContextMenu_Collumns(dataGridView1, id_context); } } }