private void cmdSearch_Click(object sender, EventArgs e) { dgvExpense.Rows.Clear(); TravelAgencyEntities t = new TravelAgencyEntities(); var query = from V in t.Vendors where V.Name.Contains(txtName.Text) && (V.Phone == null || V.Phone.Contains(txtPhone.Text)) && (V.Email == null || V.Email.Contains(txtEmail.Text)) select V; foreach (var vendor in query) { DataGridViewRow row = new DataGridViewRow(); DataGridViewTextBoxCell ID = new DataGridViewTextBoxCell(); ID.Value = vendor.VendorID.ToString(); row.Cells.Add(ID); DataGridViewTextBoxCell Name = new DataGridViewTextBoxCell(); Name.Value = vendor.Name; row.Cells.Add(Name); DataGridViewTextBoxCell CellPhone = new DataGridViewTextBoxCell(); CellPhone.Value = vendor.Phone; row.Cells.Add(CellPhone); DataGridViewTextBoxCell Email = new DataGridViewTextBoxCell(); Email.Value = vendor.Email; row.Cells.Add(Email); row.Tag = vendor; dgvExpense.Rows.Add(row); } }
private void cmdSave_Click(object sender, EventArgs e) { TravelAgencyEntities t = new TravelAgencyEntities(); //Client c = new Client(); // t.AddToClients(Client.CreateClient(1, "sami", "*****@*****.**", "Sami", "Ahmed")); //t.SaveChanges(); }
public void LoadGroups() { dgvGroups.Rows.Clear(); TravelAgencyEntities t = new TravelAgencyEntities(); var query = from clientGrp in t.ClientGroups select clientGrp; foreach (var clientGrp in query) { DataGridViewRow row = new DataGridViewRow(); DataGridViewTextBoxCell Name = new DataGridViewTextBoxCell(); Name.Value = clientGrp.Name; row.Cells.Add(Name); DataGridViewTextBoxCell Desc = new DataGridViewTextBoxCell(); Desc.Value = clientGrp.Description; row.Cells.Add(Desc); row.Tag = clientGrp; dgvGroups.Rows.Add(row); } }
private void cmdSave_Click(object sender, EventArgs e) { TravelAgencyEntities t = new TravelAgencyEntities(); }