private async Task <bool> EmployeeExists(ViewModels.Employee employee)
{
var existingEmployee = await context.vEmployee.FirstOrDefaultAsync(ve => ve.FirstName == employee.FirstName &&
ve.LastName == employee.LastName &&
ve.PhoneNumber == employee.PhoneNumber &&
ve.AddressLine1 == employee.Address &&
ve.PostalCode == employee.PostalCode &&
ve.City == employee.City);
return(existingEmployee != null);
}
public async Task UpdateEmployee(ViewModels.Employee employee)
{
if (employee == null || employee.Id == 0)
{
return;
}
var person = await context.Person.SingleOrDefaultAsync(p => p.BusinessEntityID == employee.Id);
if (person == null)
{
return;
}
// First and Last name
person.FirstName = employee.FirstName;
person.LastName = employee.LastName;
// Phone
var oldPhone = person.PersonPhone.FirstOrDefault();
if (oldPhone != null)
{
// PersonPhone Primary Key = BusinessEntityID + PhoneNumber + PhoneNumberTypeID
// so PhoneNumber can't be modified then it's removed and added again
person.PersonPhone.Remove(oldPhone);
var newPhone = new PersonPhone
{
BusinessEntityID = oldPhone.BusinessEntityID,
Person = oldPhone.Person,
PhoneNumberType = oldPhone.PhoneNumberType,
PhoneNumberTypeID = oldPhone.PhoneNumberTypeID,
PhoneNumber = employee.PhoneNumber,
ModifiedDate = DateTime.Now
};
person.PersonPhone.Add(newPhone);
}
// Address
var address = person.BusinessEntity.BusinessEntityAddress.FirstOrDefault()?.Address;
if (address != null)
{
address.AddressLine1 = employee.Address;
address.City = employee.City;
address.PostalCode = employee.PostalCode;
}
await context.SaveChangesAsync();
}
public async Task CreateEmployee(ViewModels.Employee employee)
{
// Check if employee exists in the db
if (await EmployeeExists(employee))
{
throw new InvalidOperationException("This employee already exists.");
}
// Create a person entity with all needed relations
var person = new Person
{
BusinessEntity = new BusinessEntity
{
rowguid = Guid.NewGuid(),
ModifiedDate = DateTime.Now,
BusinessEntityAddress = new List <BusinessEntityAddress>
{
new BusinessEntityAddress
{
Address = new Address
{
AddressLine1 = employee.Address,
AddressLine2 = Guid.NewGuid().ToString(), // to avoid bug with 2 different employees having the same address
City = employee.City,
PostalCode = employee.PostalCode,
rowguid = Guid.NewGuid(),
ModifiedDate = DateTime.Now,
StateProvince = await context.StateProvince.FirstOrDefaultAsync()
},
AddressType = await context.AddressType.FirstOrDefaultAsync(at => at.Name == "Home"),
ModifiedDate = DateTime.Now,
rowguid = Guid.NewGuid()
}
}
},
FirstName = employee.FirstName,
LastName = employee.LastName,
PersonType = "EM",
NameStyle = false,
EmailPromotion = 0,
rowguid = Guid.NewGuid(),
ModifiedDate = DateTime.Now,
PersonPhone = new List <PersonPhone> {
new PersonPhone
{
PhoneNumberType = await context.PhoneNumberType.FirstOrDefaultAsync(pnt => pnt.Name == "Cell"),
ModifiedDate = DateTime.Now,
PhoneNumber = employee.PhoneNumber
}
}
};
// Create new employee with random properties
var random = new Random();
var newEmployee = new Employee
{
Person = person,
NationalIDNumber = random.Next().ToString(),
LoginID = $"adventure-works/{employee.FirstName.ToLower() + random.Next().ToString()}",
JobTitle = "Intern",
BirthDate = new DateTime(random.Next(1970, 2000), random.Next(1, 12), random.Next(1, 28)),
MaritalStatus = "S",
Gender = random.Next(0, 1) == 1 ? "M" : "F",
HireDate = DateTime.Now - TimeSpan.FromDays(1),
SalariedFlag = false,
VacationHours = 25,
SickLeaveHours = 0,
CurrentFlag = true,
rowguid = Guid.NewGuid(),
ModifiedDate = DateTime.Now
};
context.Employee.Add(newEmployee);
await context.SaveChangesAsync();
}
