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