public EmployeeRecord GetEmployeeById(string resourceId)
        {
            EmployeeRecord emp = new EmployeeRecord();

            using (SqlConnection conn = new SqlConnection("Data Source=AIP-SQLAIPL;Initial Catalog=Aipl;User ID=ambiflux;Password=ambiflux"))
            {
                conn.Open();

                string cmdStr = String.Format("Select firstname,lastname from vEmployee where ResourceId=" + resourceId);
                SqlCommand cmd = new SqlCommand(cmdStr, conn);
                SqlDataReader rd = cmd.ExecuteReader();

                if (rd.HasRows)
                {
                    rd.Read();
                    emp.firstname = rd.GetString(0);
                    emp.lastname = rd.GetString(1);

                }
                conn.Close();
                return emp;
            }
        }
        //test
        public EmployeeRecord GetEmployee()
        {
            EmployeeRecord emp = new EmployeeRecord();

            DataClassesDataContext ctx = new DataClassesDataContext("Data Source=AIP-SQLAIPL;Initial Catalog=Aipl;User ID=ambiflux;Password=ambiflux");

            return (from e in ctx.vEmployee
                    where e.ResourceID == 3
                    select new EmployeeRecord
                    {
                        firstname = e.FirstName,
                        lastname = e.LastName

                    }).SingleOrDefault();
        }