void Search() { MyEmployees.Clear(); foreach (var employee in employees .Where(e => e.FirstName.ToLower().Contains(Filter.ToLower()) || e.LastName.ToLower().Contains(Filter.ToLower())) .OrderBy(e => e.FirstName) .ThenBy(e => e.LastName)) { if (employee.EmployeeId != me.EmployeeId) { MyEmployees.Add(new EmployeeItemViewModel { Address = employee.Address, Document = employee.Document, DocumentTypeId = employee.DocumentTypeId, Email = employee.Email, EmployeeCode = employee.EmployeeCode, EmployeeId = employee.EmployeeId, FirstName = employee.FirstName, LastName = employee.LastName, LoginTypeId = employee.LoginTypeId, Phone = employee.Phone, Picture = employee.Picture, }); } } }
public void addEmployee(MyEmployees emp) { string addCommand = string.Format("Insert into MyEmployees (firstName, lastName, streetAddress, city, state, zipcode, phoneNumber, emailAddress)" + "Values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", emp.firstName, emp.lastName, emp.streetAddress, emp.city, emp.state, emp.zipCode, emp.phoneNumber, emp.emailAddress); string connString = "Data Source=DESKTOP-OB29V6P;Initial Catalog=Employees.EmployeesDB;Integrated Security=True"; SqlConnection conn = new SqlConnection(connString); SqlCommand addEmp = new SqlCommand(addCommand, conn); SqlDataReader myReader; try { conn.Open(); myReader = addEmp.ExecuteReader(); while (myReader.Read()) { ; } } catch (Exception ex) { MessageBox.Show(ex.Message, "SQL Error"); } conn.Close(); }
void ReloadEmployees() { MyEmployees.Clear(); foreach (var employee in employees .OrderBy(e => e.FirstName) .ThenBy(e => e.LastName)) { if (employee.EmployeeId != me.EmployeeId) { MyEmployees.Add(new EmployeeItemViewModel { Address = employee.Address, Document = employee.Document, DocumentTypeId = employee.DocumentTypeId, Email = employee.Email, EmployeeCode = employee.EmployeeCode, EmployeeId = employee.EmployeeId, FirstName = employee.FirstName, LastName = employee.LastName, LoginTypeId = employee.LoginTypeId, Phone = employee.Phone, Picture = employee.Picture, }); } } }
public bool checkEmpInfo(MyEmployees emp) { if (emp.firstName == null || emp.lastName == null || emp.streetAddress == null || emp.city == null || emp.state == null || emp.zipCode == null || emp.phoneNumber == null || emp.phoneNumber == null || emp.emailAddress == null) { isValid = false; } else { isValid = true; } return(isValid); }