public void AddUnit() { using (var dbContext = new BusinessCmpDbEntities()) { var unit = new Unit(); Console.WriteLine("Enter Unit Name: "); unit.UnitName = Console.ReadLine(); var check = dbContext.Units.SingleOrDefault(t => t.UnitName == unit.UnitName); if (check == null) { try { dbContext.Units.Add(unit); dbContext.SaveChanges(); Console.WriteLine("Unit added to the list"); } catch (Exception e) { Console.WriteLine(e); } } else { Console.WriteLine("Unit is already in the list"); } } }
public void AssignProject() { var dbContext = new BusinessCmpDbEntities(); var emp = new EmplpoyeeDetail(); Console.WriteLine("Select Project Id : "); ProjectList(); emp.ProjectId = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Select Employee Id : "); EmployeeList(); emp.EmployeeId = Convert.ToInt32(Console.ReadLine()); var check = dbContext.EmplpoyeeDetails.SingleOrDefault(t => t.EmployeeId == emp.EmployeeId); var c = dbContext.EmplpoyeeDetails.SingleOrDefault(t => t.ProjectId == emp.ProjectId); if (check == null && c == null) { try { dbContext.EmplpoyeeDetails.Add(emp); dbContext.SaveChanges(); Console.WriteLine("Assigned a project to employee !!"); } catch (Exception e) { Console.WriteLine(e); } } else { Console.WriteLine("Project is already assigned to employee"); } }
public void AssignProjectManager() { using (var dbContext = new BusinessCmpDbEntities()) { Console.WriteLine("Select Id : "); var list = dbContext.EmplpoyeeDetails; foreach (var i in list) { Console.WriteLine("Id :" + i.EmployeeDetailId + "\tEmployee Id: " + i.EmployeeId + "\tProject Id: " + i.ProjectId); } var pm = new ProjectManager(); pm.EmployeeDetailId = Convert.ToInt32(Console.ReadLine()); var check = dbContext.ProjectManagers.SingleOrDefault(t => t.EmployeeDetailId == pm.EmployeeDetailId); if (check == null) { try { dbContext.ProjectManagers.Add(pm); dbContext.SaveChanges(); Console.WriteLine("Project manager is assigned to a project !!"); } catch (Exception e) { Console.WriteLine(e); } } else { Console.WriteLine("Manager is already assigned to project"); } } }
static void Main(string[] args) { Program p = new Program(); var dbContext = new BusinessCmpDbEntities(); bool flag = true; int choice; do { Console.WriteLine("1. Admin \n2. Project Manager \n3. Exit"); Console.WriteLine("Enter Your Choice: "); choice = Convert.ToInt32(Console.ReadLine()); switch (choice) { case 1: p.Admin(); break; case 2: p.ProjectManagerFun(); break; case 3: flag = false; break; default: Console.WriteLine("Invalid Choice !!!"); break; } }while (choice != 3); }
public void UnitList() { var dbContext = new BusinessCmpDbEntities(); var uList = dbContext.Units; Console.WriteLine("---------------Unit List---------------"); foreach (var e in uList) { Console.WriteLine("Unit Id: " + e.UnitId + "\tUnit Name : " + e.UnitName); } }
public void ProjectList() { var dbContext = new BusinessCmpDbEntities(); var pList = dbContext.Projects; Console.WriteLine("---------------Project List-------------"); foreach (var e in pList) { Console.WriteLine("Project Id: " + +e.ProjectId + "\tUnit Name : " + e.Unit.UnitName + "\tProject Title: " + e.ProjectTitle); } }
public void EmployeeList() { var dbContext = new BusinessCmpDbEntities(); var employeeList = dbContext.vProjectEmployeeDetails; Console.WriteLine("---------------Employee List---------------"); foreach (var e in employeeList) { Console.WriteLine("Employee Id : " + e.EmployeeId + "\tEmployee Name : " + e.Name + "\tEmployee Address : " + e.Address + "\tContact No : " + e.ContactNo + "\tGender : " + e.Gender + "\tUnit Name" + e.UnitName + "\tProject Title : " + e.ProjectTitle); } }
public void ProjectManagerList() { var dbContext = new BusinessCmpDbEntities(); var list = dbContext.vManagerDetails; Console.WriteLine("---------------Project Manager List---------------"); foreach (var e in list) { Console.WriteLine("Manager Id : " + e.ProjectManagerId + "\tName : " + e.Name + "\tAddress : " + e.Address + "\tContact No : " + e.ContactNo + "\tGender : " + e.Gender + "\tUnit Name" + e.UnitName + "\tProject Title : " + e.ProjectTitle); } var l = new EmplpoyeeDetail(); }
public void AddEmployee() { using (var dbContext = new BusinessCmpDbEntities()) { var employee = new Employee(); Console.WriteLine("Enter Empployee Name: "); employee.Name = Console.ReadLine(); Console.WriteLine("Enter Empployee Address: "); employee.Address = Console.ReadLine(); Console.WriteLine("Enter Empployee Gender: "); employee.Gender = Console.ReadLine(); Console.WriteLine("Enter Empployee Contact no: "); employee.ContactNo = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Enter Unit Id in which Employee belongs : "); UnitList(); employee.UnitId = Convert.ToInt32(Console.ReadLine()); var check = dbContext.Employees.SingleOrDefault(t => t.Name == employee.Name); if (check == null) { try { dbContext.Employees.Add(employee); dbContext.SaveChanges(); Console.WriteLine("Employee added !!"); } catch (Exception e) { Console.WriteLine(e); } } else { Console.WriteLine("Employee is already in the list"); } } }