private void OpenMemberForm(String state) { String golfId = (string)members_dataGridView.SelectedRows[0].Cells[0].Value; NpgsqlCommand command = new NpgsqlCommand("SELECT * FROM \"Medlem\" WHERE \"Golf-ID\" = '" + golfId + "';", MainWindow.dbConnection); NpgsqlDataReader ndr = command.ExecuteReader(); ndr.Read(); Member m = new Member(); m.GolfId = (string)ndr["Golf-ID"]; m.FirstName = (string)ndr["Förnamn"]; m.LastName = (string)ndr["Efternamn"]; m.Adress = (string)ndr["Adress"]; m.Zipcode = (string)ndr["Postnr"]; m.City = (string)ndr["Stad"]; m.Phone = (string)ndr["Telefonnummer"]; m.Email = (string)ndr["Epost"]; int status_id = (int)ndr["Status_id"]; m.Membership = status_id.ToString(); int betalatår = (int)ndr["BetalatÅr"]; m.Paid = betalatår.ToString(); double handi = (double)ndr["Handicap"]; m.Handicap = handi.ToString(); ndr.Close(); var mf = new MemberForm(ref m, state); mf.ShowDialog(); MainWindow.UpdateMember(m); SetDataTable(MainWindow.GetMemberTable()); }
private void OpenMemberForm(String state) { String golfId = (string)members_dataGridView.SelectedRows[0].Cells[0].Value; NpgsqlCommand command = new NpgsqlCommand("SELECT * FROM \"Medlem\" WHERE \"Golf-ID\" = '" + golfId + "';", MainWindow.dbConnection); NpgsqlDataReader ndr = command.ExecuteReader(); ndr.Read(); Member m = new Member(); m.GolfId = (string)ndr["Golf-ID"]; m.FirstName = (string)ndr["Förnamn"]; m.LastName = (string)ndr["Efternamn"]; m.Adress = (string)ndr["Adress"]; m.Zipcode = (string)ndr["Postnr"]; m.City = (string)ndr["Stad"]; m.Phone = (string)ndr["Telefonnummer"]; m.Email = (string)ndr["Epost"]; int status_id = (int)ndr["Status_id"]; m.Membership = status_id.ToString(); int betalatår = (int)ndr["BetalatÅr"]; m.Paid = betalatår.ToString(); double handi = (double)ndr["Handicap"]; m.Handicap = handi.ToString(); ndr.Close(); var mf = new MemberForm(ref m, state); mf.ShowDialog(); MainWindow.UpdateMember(m); SetDataTable(MainWindow.GetMemberTable()); }
private void nyMedlemToolStripMenuItem_Click(object sender, EventArgs e) { Member m = new Member(); var mf = new MemberForm(ref m, "NEW"); mf.ShowDialog(); if (!m.IsEmpty) { InsertMember(m); } }
private void new_toolStripButton_Click(object sender, EventArgs e) { Member m = new Member(); var mf = new MemberForm(ref m, "NEW"); mf.ShowDialog(); if (!m.IsEmpty) { MainWindow.InsertMember(m); } SetDataTable(MainWindow.GetMemberTable()); }
private void new_toolStripButton_Click(object sender, EventArgs e) { Member m = new Member(); var mf = new MemberForm(ref m, "NEW"); mf.ShowDialog(); if (!m.IsEmpty) { MainWindow.InsertMember(m); } SetDataTable(MainWindow.GetMemberTable()); }
private void nyMedlemToolStripMenuItem_Click(object sender, EventArgs e) { Member m = new Member(); var mf = new MemberForm(ref m, "NEW"); mf.ShowDialog(); if (!m.IsEmpty) { InsertMember(m); } }