public bool AddEmployee(Employee employee)
{
try
{
EmployeeDbcontext.Employees.Add(employee);
EmployeeDbcontext.SaveChanges();
return(true);
}
catch (System.Data.Entity.Infrastructure.DbUpdateException ex)
{
logger.Error($"Something bad happened in employee site {ex}!");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine(ex);
Console.ForegroundColor = ConsoleColor.White;
return(false);
}
}
public bool AddNewProject(string TeamName, string NewProjectName)
{
try //To check if new entry exists already
{
Project Proj = (from team in EmployeeDbcontext.Teams.Include("Project")
from project in team.Project
where team.TeamName == TeamName && project.ProjectName == NewProjectName
select project).AsEnumerable().FirstOrDefault();
Proj.ProjectStatus = 1;
EmployeeDbcontext.SaveChanges();
return(true);
}
catch (NullReferenceException) // To add the new entry
{
Team Team = (from team in EmployeeDbcontext.Teams
where team.TeamName == TeamName
select team).AsEnumerable().FirstOrDefault();
Team.TeamStatus = 1;
var Project = new Project()
{
TeamID = Team.TeamID, ProjectID = Guid.NewGuid(), ProjectName = NewProjectName, ProjectStatus = 1
};
EmployeeDbcontext.Projects.Add(Project);
EmployeeDbcontext.SaveChanges();
return(true);
}
catch (Exception ex)
{
logger.Error($"Something bad happened in query site {ex}!");
return(false);
}
}
