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);
}
