/*public List<Crop> getCrops() * { * List<Crop> crops = new List<Crop>(); * * if (con.OpenConnection()) * { * DbDataReader dr = con.Select("SELECT "); * } * return crops; * }*/ public int addEmployee(String txtFirstname, String txtSurname, String txtPostcode, String txtPhone, String txtEmail, String txtUsername, String txtPassword, String accessPrivilage) { DateTime createdToday = DateTime.Now.Date; string Date = createdToday.ToString(); int retv = 0; if (con.OpenConnection()) { String sql = "INSERT INTO Employees (firstName, lastName, postCode, contactNumber, emailAddress, userName, password, accessPrivilage) VALUES ('" + txtFirstname + "','" + txtSurname + "','" + txtPostcode + "','" + txtPhone + "','" + txtEmail + "','" + txtUsername + "','" + txtPassword + "','" + accessPrivilage + "')"; sql = "INSERT INTO Employees (firstName, lastName, postCode, contactNumber, emailAddress, userName, password, accessPrivilage) VALUES ('" + txtFirstname + "','" + txtSurname + "','" + txtPostcode + "','" + txtPhone + "','" + txtEmail + "','" + txtUsername + "','" + txtPassword + "',)"; int reader = con.Insert(sql); if (reader == 1) { retv = 1; } else { retv = 2; } con.CloseConnection(); } return(retv); }