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