/// <summary>
/// Deprecated Method for adding a new object to the Employees EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToEmployees(Employee employee)
{
base.AddObject("Employees", employee);
}
/// <summary>
/// Create a new Employee object.
/// </summary>
/// <param name="id">Initial value of the Id property.</param>
/// <param name="firstName">Initial value of the FirstName property.</param>
/// <param name="lastName">Initial value of the LastName property.</param>
public static Employee CreateEmployee(global::System.Int32 id, global::System.String firstName, global::System.String lastName)
{
Employee employee = new Employee();
employee.Id = id;
employee.FirstName = firstName;
employee.LastName = lastName;
return employee;
}
/// <summary>
/// return the employee details from sql
/// </summary>
/// <param name="syncObjects"></param>
/// <returns></returns>
internal Syncdto GetDatafromDBEmployee(Syncdto syncObjects)
{
List<Employee> empList = new List<Employee>();
using (SqlConnection sqlConnection = new SqlConnection(syncObjects.ConnectionString))
{
string oString = "Select * from Employee";
SqlCommand oCmd = new SqlCommand(oString, sqlConnection);
sqlConnection.Open();
using (SqlDataReader oReader = oCmd.ExecuteReader())
{
while (oReader.Read())
{
Employee qboEmp = new Employee();
qboEmp.GivenName = oReader["GivenName"].ToString();
qboEmp.FamilyName = oReader["FamilyName"].ToString();
qboEmp.PrimaryPhone = new TelephoneNumber { FreeFormNumber = oReader["PrimaryPhone"].ToString() };
qboEmp.PrimaryEmailAddr = new EmailAddress { Address = oReader["PrimaryEmailAddr"].ToString() };
empList.Add(qboEmp);
}
sqlConnection.Close();
}
}
syncObjects.EmployeeList = empList;
return syncObjects;
}