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