public MemberForm(ref Member m, String state) { this.m = m; InitializeComponent(); Init(); SetState(state); }
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 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); } }
public static void UpdateMember(Member m) { String sql = "UPDATE \"Medlem\" SET (\"Golf-ID\",\"Förnamn\",\"Efternamn\",\"Adress\",\"Postnr\",\"Stad\",\"Telefonnummer\",\"Epost\",\"Status_id\",\"BetalatÅr\",\"Handicap\") = ('" + m.GolfId + "','" + m.FirstName + "','" + m.LastName + "','" + m.Adress + "','" + m.Zipcode + "','" + m.City + "','" + m.Phone + "','" + m.Email + "'," + m.Membership + ",'" + m.Paid + "'," + m.Handicap + ") WHERE \"Golf-ID\" = '" + m.GolfId + "';"; NpgsqlCommand Command = new NpgsqlCommand(sql, MainWindow.dbConnection); NpgsqlDataReader result = Command.ExecuteReader(); }