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