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