private void ViewMemberMenu_Click(object sender, EventArgs e) { Connection.Close(); Boolean flag = false; string query1 = "Select ID from member;"; Connection.Open(); Command1 = new SqlCommand(query1, Connection); SqlDataReader result1 = Command1.ExecuteReader(); while (result1.Read()) { string id = result1["ID"].ToString(); flag = true; } if (!flag) { var w = new Form() { Size = new Size(0, 0) }; Task.Delay(TimeSpan.FromSeconds(1)) .ContinueWith((t) => w.Close(), TaskScheduler.FromCurrentSynchronizationContext()); MessageBox.Show(w, "No member available"); } if (flag) { ViewUsers c = new ViewUsers(); if (!Window.Controls.Contains(c)) { Window.Controls.Add(c); c.Dock = DockStyle.Fill; c.BringToFront(); } else { c.BringToFront(); } } Connection.Close(); }
private void NewMemberSaveButton_Click(object sender, EventArgs e) { ArrayList User = new ArrayList(); string Username = UserNameTextBox.Text; string Userid = UserIDTextBox.Text; string UseremailAddress = UserEmailTextBox.Text; string UsercarID = VehicleIDTextBox.Text; string UserVehicleName = VehicleNameTextBox.Text; string UserVehicleModel = VehicleModelTextBox.Text; string UserVehicleColour = VehicleColorTextBox.Text; string UserGender = ""; Boolean flag = false; if (MaleUser.Checked) { UserGender = "Male"; } if (FemaleUser.Checked) { UserGender = "Female"; } Boolean empty = string.IsNullOrEmpty(Username) || string.IsNullOrEmpty(Userid) || string.IsNullOrEmpty(UseremailAddress) || string.IsNullOrEmpty(UsercarID) || string.IsNullOrEmpty(UserVehicleName) || string.IsNullOrEmpty(UserVehicleModel) || string.IsNullOrEmpty(UserVehicleColour) || string.IsNullOrEmpty(UserGender); string query = "select ID from member where ID= '" + Userid + "';"; Connection.Open(); Command = new SqlCommand(query, Connection); SqlDataReader result = Command.ExecuteReader(); while (result.Read()) { string id = result["ID"].ToString(); flag = true; } Connection.Close(); if (empty) { var w = new Form() { Size = new Size(0, 0) }; Task.Delay(TimeSpan.FromSeconds(1)) .ContinueWith((t) => w.Close(), TaskScheduler.FromCurrentSynchronizationContext()); MessageBox.Show(w, "Please fill all the fields"); } else if (flag) { var w = new Form() { Size = new Size(0, 0) }; Task.Delay(TimeSpan.FromSeconds(1)) .ContinueWith((t) => w.Close(), TaskScheduler.FromCurrentSynchronizationContext()); MessageBox.Show(w, "ID already exist"); } else { User.Add(Username); User.Add(Userid); User.Add(UseremailAddress); User.Add(UserGender); User.Add(UsercarID); User.Add(UserVehicleName); User.Add(UserVehicleModel); User.Add(UserVehicleColour); database.InsertNewUser(User); var w = new Form() { Size = new Size(0, 0) }; Task.Delay(TimeSpan.FromSeconds(1)) .ContinueWith((t) => w.Close(), TaskScheduler.FromCurrentSynchronizationContext()); MessageBox.Show("User Added successfully"); ViewUsers vu = new ViewUsers(); vu.LoadData(); } }