//method for adding a new employee to the database
public bool CreateNewEmployee(string firstName, string lastName, string email, string phoneNumber, decimal salary, int departmentId)
{
try
{
CompanyRecordsContext context = new CompanyRecordsContext();
Employee employee = new Employee()
{
FirstName = firstName,
LastName = lastName,
Email = email,
PhoneNumber = phoneNumber,
Salary = salary,
DepartmentId = departmentId
};
context.Employees.Add(employee);
context.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
//method for deleting an existing department
public bool DeleteDepartment(string departmentName)
{
try
{
CompanyRecordsContext context = new CompanyRecordsContext();
var department = context.Departments.Where(d => d.DepartmentName == departmentName)
.ToArray()[0];
context.Departments.Remove(department);
context.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
//method for deleting an existing employee
public bool DeleteEmployee(string firstname, string email)
{
try
{
CompanyRecordsContext context = new CompanyRecordsContext();
var emp = context.Employees.Where(e => e.FirstName == firstname && e.Email == email)
.ToArray()[0];
context.Employees.Remove(emp);
context.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
//method for adding a new department to the database
public bool CreateNewDepartment(string departmentName)
{
try
{
CompanyRecordsContext context = new CompanyRecordsContext();
var department = new Department()
{
DepartmentName = departmentName
};
context.Departments.Add(department);
context.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
//method for editing an existing employee
public bool UpdateEmployee(string firstname, string lastname, string email, string phoneNumber, decimal salary, int departmentId)
{
try
{
CompanyRecordsContext context = new CompanyRecordsContext();
var emp = context.Employees.Where(e => e.Email == email)
.ToArray()[0];
if (firstname != "")
{
emp.FirstName = firstname;
}
if (lastname != "")
{
emp.LastName = lastname;
}
if (phoneNumber != "")
{
emp.PhoneNumber = phoneNumber;
}
if (salary != 0)
{
emp.Salary = salary;
}
if (departmentId != 0)
{
emp.DepartmentId = departmentId;
}
context.SaveChanges();
return(true);
}
catch
{
return(false);
}
}