public bool DeleteEmployee(int empID) { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@empId", empID) }; return(DataAccessSQL.ExecuteNonQuery("DeleteEmployee", CommandType.StoredProcedure, parameter)); }
public bool AddNewEmployee(Employee employee) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@LastName", employee.LastName), new SqlParameter("@FirstName", employee.FirstName), new SqlParameter("Title", employee.Title), new SqlParameter("@Address", employee.Address), new SqlParameter("@City", employee.City), new SqlParameter("@Region", employee.Region), new SqlParameter("@PostalCode", employee.PostalCode), new SqlParameter("@Country", employee.Country), new SqlParameter("@Extension", employee.Extension) }; return(DataAccessSQL.ExecuteNonQuery("AddNewEmployee", CommandType.StoredProcedure, parameters)); }