public void RemoveBusinessUnit() { using (var db = new CompanyDbEntities()) { var businessunit = new BusinessUnit(); Console.WriteLine("Enter name of business unit you want to remove:" + businessunit.BusinessUnitName); businessunit.BusinessUnitName = Console.ReadLine(); var bu = db.BusinessUnits.SingleOrDefault(t => t.BusinessUnitName == businessunit.BusinessUnitName); if (bu != null) { db.BusinessUnits.Remove(db.BusinessUnits.Single(t => t.BusinessUnitName == businessunit.BusinessUnitName)); db.SaveChanges(); Console.WriteLine("Business Unit Removed"); } else { Console.WriteLine("There is no such unit present"); } } }
public void AddBusinessUnit() { using (var db = new CompanyDbEntities()) { var businessunit = new BusinessUnit(); Console.WriteLine("Enter Business Unit Name: " + businessunit.BusinessUnitName); businessunit.BusinessUnitName = Console.ReadLine(); var bu = db.BusinessUnits.SingleOrDefault(t => t.BusinessUnitName == businessunit.BusinessUnitName); if (bu == null) { db.BusinessUnits.Add(businessunit); db.SaveChanges(); Console.WriteLine("Business Unit Added"); } else { Console.WriteLine("There is already such unit present"); } } }
static void Main(string[] args) { int choice = 0; Console.WriteLine("Welcome To Company Management System"); var dbContext = new CompanyDbEntities(); Console.WriteLine("1. Show Business Unit"); Console.WriteLine("2. Allocate Projects"); Console.Write("Enter Your Choice :"); choice = Convert.ToInt32(Console.ReadLine()); do { switch (choice) { case 1: showBusinessUnits(); break; case 2: showProjects(); break; } Console.Write("Enter Your Choice :"); choice = Convert.ToInt32(Console.ReadLine()); } while (choice != 0); void showBusinessUnits() { var businessUnits = new BusinessUnit(); Console.Write("Enter Unit Name to view Employee in this unit : "); businessUnits.BusinessUnitName = Console.ReadLine(); var unit = dbContext.BusinessUnits.Where(t => t.BusinessUnitName == businessUnits.BusinessUnitName).FirstOrDefault(); try { showEmployee(unit.BusinessUnitId); } catch (Exception e) { Console.WriteLine("Department invalid"); } } void showEmployee(int unitid) { // var employee = new Employee(); var employeeList = dbContext.Employees.Where(t => t.BusinessUnitId == unitid); Console.WriteLine("EmpId\tEmpName\tEmp Email Id\tPhone Number\tStatus"); foreach (var emp in employeeList) { Console.WriteLine(emp.EmployeeId + " " + emp.EmployeeName + " " + emp.EmployeeEmailId + " " + emp.EmployeePhoneNumber + " " + emp.EmployeeStatus); } } void showProjects() { var projectList = dbContext.Projects; Console.WriteLine("ProjectId\tProjectName\tProjectDetails "); foreach (var project in projectList) { Console.WriteLine(project.ProjectId + "\t " + project.ProjectName + " " + project.ProjectDetail); } Console.WriteLine("Enter Project Id to assign employees:"); var projectId = Convert.ToInt32(Console.ReadLine()); var employeeList = dbContext.Employees; Console.WriteLine("EmpId\tEmpName\tEmp Email Id\tPhone Number\tStatus"); foreach (var emp in employeeList) { Console.WriteLine(emp.EmployeeId + " " + emp.EmployeeName + " " + emp.EmployeeEmailId + " " + emp.EmployeePhoneNumber + " " + emp.EmployeeStatus); } Console.Write("Enter EmployeeId"); var empId = Convert.ToInt32(Console.ReadLine()); allocateEmployee(projectId, empId); } void allocateEmployee(int projectId, int empId) { var allocateProject = new AllocateProject(); // allocateProject.AllocateProjectId = 1; allocateProject.EmployeeId = 1; allocateProject.ProjectId = 1; Console.Write("Enter Employee Designation for This Project :"); allocateProject.Designation = Console.ReadLine(); using (dbContext) { try { dbContext.AllocateProjects.Add(allocateProject); dbContext.SaveChanges(); Console.WriteLine("Employee Allocated Successfully"); } catch (Exception e) { Console.WriteLine(e); } } } }
static void Main(string[] args) { Console.WriteLine("Welcome to our company employee management system"); var dbEntity = new CompanyDbEntities(); showDepartment(); Console.WriteLine("------------------------------------------------------------"); showProject(); void showDepartment() { Console.WriteLine("Enter the department name for which you want to see the employee list"); var businessUnit = new BusinessUnit(); businessUnit.BusinessUnitName = Console.ReadLine(); var db = new CompanyDbEntities(); var deptList = db.BusinessUnits.Where(t => t.BusinessUnitName == businessUnit.BusinessUnitName).First(); var deptId = deptList.BusinessUnitId; showEmployee(deptId); } void showEmployee(int deptId) { var employee = new Employee(); var dbContext = new CompanyDbEntities(); Console.WriteLine("All the employees of that department"); var employeename = dbContext.Employees.Where(t => t.BusinessUnitId == deptId); foreach (var employees in employeename) { Console.WriteLine(employees.EmployeeId + employees.EmployeeName + employees.Age + employees.Designation + employees.Gender + employees.Designation); } } void showProject() { var project = new Project(); var db1 = new CompanyDbEntities(); var projectList = db1.Projects; Console.WriteLine("Project List is given below"); foreach (var projects in projectList) { Console.WriteLine(projects.ProjectId + projects.ProjectName + projects.ProjectDetail + projects.DeadlineDate); } Console.WriteLine("Enter the ProjectId for which you want to assign employee"); Console.WriteLine("--------------------------------------------------------------"); var projectId = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("--------------------------------------------------------------"); var employee = new Employee(); Console.WriteLine("Choose from the employee id from the below list to assign them to any of the project."); Console.WriteLine("This list contains the employee names who are not on vacation"); var emplist = db1.Employees.Where(t => t.EmployeeStatus == "Active"); foreach (var emp in emplist) { Console.WriteLine(emp.EmployeeId + emp.EmployeeName + emp.Age + emp.Designation + emp.Gender + emp.Designation); } Console.WriteLine("--------------------------------------------------------------"); Console.WriteLine("Enter the employee id"); var empId = Convert.ToInt32(Console.ReadLine()); assignEmployee(projectId, empId); } void assignEmployee(int projectId, int empId) { var assign = new AssignEmployee(); assign.EmployeeId = empId; assign.ProjectId = projectId; Console.WriteLine("Enter the designation you want to give to the employee for the given project"); assign.AssignDesignation = Console.ReadLine(); using (dbEntity) { try { dbEntity.AssignEmployees.Add(assign); dbEntity.SaveChanges(); Console.WriteLine("The employee is successfully added to the project"); } catch (Exception e) { Console.WriteLine(e); } } } }