public bool TryDeleteSector(int sectorID)
{
try
{
using (var conn = new CompanyManagementEntities())
{
var sectorToRemove = conn.tblSectors.FirstOrDefault(x => x.SectorID == sectorID);
if (sectorToRemove != null)
{
if (conn.tblEmployees.Any(x => x.SectorID == sectorID))
{
ChangeEmployeesSectorToDefault(sectorID);
conn.tblSectors.Remove(sectorToRemove);
conn.SaveChanges();
return(true);
}
else
{
conn.tblSectors.Remove(sectorToRemove);
conn.SaveChanges();
return(true);
}
}
return(false);
}
}
catch (Exception)
{
return(false);
}
}
public bool Update(Company company)
{
if (company == null)
{
throw new ArgumentNullException("company");
}
if (!CompanyExists(company.CompanyID))
{
return(false);
}
try
{
db.Entry(company).State = EntityState.Modified;
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CompanyExists(company.CompanyID))
{
return(false);
}
else
{
throw;
}
}
return(true);
}
public void DeleteProject(int id)
{
var projectToRemove = dao.Projects.FirstOrDefault(p => p.project_id == id);
if (projectToRemove == null)
{
return;
}
dao.Projects.Remove(projectToRemove);
dao.SaveChanges();
}
public bool TryUpdateUserData(int userDataID, tblUserData userData)
{
try
{
using (var conn = new CompanyManagementEntities())
{
var userDataToUpdate = conn.tblUserDatas.FirstOrDefault(x => x.UserDataID == userDataID);
if (userDataToUpdate != null)
{
userDataToUpdate.Username = userData.Username;
userDataToUpdate.GivenName = userData.GivenName;
userDataToUpdate.MaritalStatus = userData.MaritalStatus;
userDataToUpdate.PersonalNo = userData.PersonalNo;
userDataToUpdate.PlaceOfResidence = userData.PlaceOfResidence;
userDataToUpdate.Sex = userData.Sex;
userDataToUpdate.Surname = userData.Surname;
conn.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception)
{
return(false);
}
}
public bool TryUpdateManager(int managerID, tblManager manager)
{
try
{
using (var conn = new CompanyManagementEntities())
{
var managerToUpdate = conn.tblManagers.FirstOrDefault(x => x.ManagerID == managerID);
if (managerToUpdate != null)
{
managerToUpdate.LevelOfResponsibility = manager.LevelOfResponsibility;
managerToUpdate.OfficeNumber = manager.OfficeNumber;
managerToUpdate.PasswordHint = manager.PasswordHint;
managerToUpdate.ProjectsCount = manager.ProjectsCount;
managerToUpdate.Salary = manager.Salary;
conn.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception)
{
return(false);
}
}
public bool TryUpdateEmployee(int employeeID, tblEmployee employee)
{
try
{
using (var conn = new CompanyManagementEntities())
{
var employeeToUpdate = conn.tblEmployees.FirstOrDefault(x => x.EmployeeID == employeeID);
if (employeeToUpdate != null)
{
employeeToUpdate.Position = employee.Position;
employeeToUpdate.ProfessionalQualificationsLevel = employee.ProfessionalQualificationsLevel;
employeeToUpdate.Salary = employee.Salary;
employeeToUpdate.SectorID = employee.SectorID;
employeeToUpdate.YearsOfService = employee.YearsOfService;
conn.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception)
{
return(false);
}
}
public bool TryAddNewUserData(tblUserData userData)
{
try
{
using (var conn = new CompanyManagementEntities())
{
conn.tblUserDatas.Add(userData);
conn.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public bool TryAddNewManager(tblManager manager)
{
try
{
using (var conn = new CompanyManagementEntities())
{
conn.tblManagers.Add(manager);
conn.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public bool TryAddNewEmployee(tblEmployee employee)
{
try
{
using (var conn = new CompanyManagementEntities())
{
conn.tblEmployees.Add(employee);
conn.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public bool TryAddNewAdministrator(tblAdministrator administrator)
{
try
{
using (var conn = new CompanyManagementEntities())
{
conn.tblAdministrators.Add(administrator);
conn.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
private bool ChangeEmployeesSectorToDefault(int sectorID)
{
try
{
using (var conn = new CompanyManagementEntities())
{
var employees = conn.tblEmployees.Where(x => x.SectorID == sectorID).ToList();
int id = GetIdofDefaultSector();
foreach (var item in employees)
{
item.SectorID = id;
}
conn.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public bool TryDeleteEmployee(int employeeID)
{
try
{
using (var conn = new CompanyManagementEntities())
{
var employeeToRemove = conn.tblEmployees.FirstOrDefault(x => x.EmployeeID == employeeID);
if (employeeToRemove != null)
{
var userDataToRemove = conn.tblUserDatas.FirstOrDefault(x => x.UserDataID == employeeToRemove.UserDataID);
conn.tblEmployees.Remove(employeeToRemove);
conn.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception)
{
return(false);
}
}
public bool TryDeleteAdministrator(int administratorID)
{
try
{
using (var conn = new CompanyManagementEntities())
{
var adminToRemove = conn.tblAdministrators.FirstOrDefault(x => x.AdministratorID == administratorID);
if (adminToRemove != null)
{
var userDataToRemove = conn.tblUserDatas.FirstOrDefault(x => x.UserDataID == adminToRemove.UserDataID);
conn.tblAdministrators.Remove(adminToRemove);
conn.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception)
{
return(false);
}
}
public bool TryUpdateAdministrator(int administratorID, tblAdministrator administrator)
{
try
{
using (var conn = new CompanyManagementEntities())
{
var adminToUpdate = conn.tblAdministrators.FirstOrDefault(x => x.AdministratorID == administratorID);
if (adminToUpdate != null)
{
adminToUpdate.AdministratorTeam = administrator.AdministratorTeam;
adminToUpdate.ExpirationAccountDate = administrator.ExpirationAccountDate;
conn.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception)
{
return(false);
}
}
public bool TryDeleteManager(int managerID)
{
try
{
using (var conn = new CompanyManagementEntities())
{
var managerToDelete = conn.tblManagers.FirstOrDefault(x => x.ManagerID == managerID);
if (managerToDelete != null)
{
var userDataToRemove = conn.tblUserDatas.FirstOrDefault(x => x.UserDataID == managerToDelete.UserDataID);
conn.tblManagers.Remove(managerToDelete);
conn.tblUserDatas.Remove(userDataToRemove);
conn.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception)
{
return(false);
}
}
private int GetIdofDefaultSector()
{
try
{
using (var conn = new CompanyManagementEntities())
{
var sector = conn.tblSectors.FirstOrDefault(x => x.SectorName == "Default");
if (sector != null)
{
return(sector.SectorID);
}
conn.tblSectors.Add(new tblSector()
{
SectorName = "Default"
});
conn.SaveChanges();
return(1);
}
}
catch (Exception)
{
return(0);
}
}