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