public void ForceStart() { if (PV.IsMine) { PlayerNameTag[] PlayerList = FindObjectsOfType <PlayerNameTag>(); foreach (PlayerNameTag PNT in PlayerList) { PNT.SetLocalPlayer(gameObject.transform); } Started = true; } }
private void AddBTN_Click(object sender, EventArgs e) { using (SqlConnection Connection = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\mainDatabase.mdf;Integrated Security=True;Connect Timeout=30")) { if (FNameT.Text == String.Empty || UNameT.Text == String.Empty || EmailT.Text == String.Empty || PNT.Text == String.Empty || AdT.Text == String.Empty) { MessageBox.Show("Error, values missing", "Value Error", MessageBoxButtons.OK, MessageBoxIcon.Error); //checks if values are present } else { try { Connection.Open(); SqlCommand cmd = new SqlCommand(@"INSERT INTO Staff ([firstname], [lastname], [address], [phoneNumber], [emailAddress], [username], [password], [preferWork] ) VALUES (@firstname, @lastname, @address, @phoneNumber, @emailAddress, @username, @password, @preferWork);", Connection); cmd.Parameters.AddWithValue("@firstname", FNameT.Text); cmd.Parameters.AddWithValue("@lastname", LNameT.Text); cmd.Parameters.AddWithValue("@username", UNameT.Text); cmd.Parameters.AddWithValue("@password", PWordT.Text); //section uses SQL to add to DB cmd.Parameters.AddWithValue("@emailAddress", EmailT.Text); cmd.Parameters.AddWithValue("@phoneNumber", PNT.Text); cmd.Parameters.AddWithValue("@address", AdT.Text); cmd.Parameters.AddWithValue("@preferRole", PRoleT.Text); int i = cmd.ExecuteNonQuery(); Connection.Close(); if (i == 1) { MessageBox.Show("Employee has been added"); FNameT.Clear(); UNameT.Clear(); EmailT.Clear(); //clears txtboxes after successful addition PNT.Clear(); AdT.Clear(); UNameT.Clear(); PWordT.Clear(); PRoleT.Clear(); } else { MessageBox.Show("Employee couldn't be added"); } } catch (Exception ex) { MessageBox.Show("Unexpected error:" + ex.Message); } } } }
private PNT Map(Point coordinate) { var map = new PNT { A = PNTA.Item2, //Other C = new decimal(coordinate.Y), D = new decimal(coordinate.X) }; if (coordinate.Z != 0) { map.E = (long)Math.Round(coordinate.Z.GetValueOrDefault(), 0); } return(map); }
public void Setup() { _pnt = new PNT(); _output = new StringBuilder(); _xmlBuilder = XmlWriter.Create(_output); }