private void metroAddNewEmployee_Click(object sender, EventArgs e)
{
String Name = EmployeeName.Text;
String Surname = EmployeeSurname.Text;
String Password = EmployeePassword.Text;
String Address1 = EmployeesAddress1.Text;
String Address2 = EmployeesAddress2.Text;
String Position = RestuarantPositions[EmployeePosition.SelectedIndex];
String Number = EmployeePhoneNumber.Text;
int IntNumber = 0;
String AddressFull = Address1 + " " + Address2;
int.TryParse(Number, out IntNumber);
Con.Open();
SqlDataAdapter ada = new SqlDataAdapter("SELECT* FROM Employees", Con);
DataTable dt = new DataTable();
ada.Fill(dt);
int counts = dt.Rows.Count;
int id = counts + 1;
cmd = new SqlCommand(@"INSERT INTO Employees
([employeeID]
,[FirstName]
,[LastName]
,[Password]
,[Position]
,[Address]
,[PhoneNumber])
VALUES('" + id + "','" + Name + "','" + Surname + "','"
+ Password + "','" + Position + "','"
+ AddressFull + "','" + IntNumber + "')", Con);
cmd.ExecuteNonQuery();
Con.Close();
EmployeesForm _emplyForm = new EmployeesForm();
_emplyForm.Show();
this.Dispose();
}
private void metroTileEmployeesmangment_Click(object sender, EventArgs e)
{
EmployeesForm employeeform = new EmployeesForm();
employeeform.Show();
}