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();
}