public void AssignProjectToEmployee(EmployeeProjectViewModel empPro)
{
foreach (var x in empPro.ProjectID)
{
var getEmployeeProject = (from empPrj in _db.EmployeeProject
//join client in _db.Clients on clientproject.ClientID equals client.ClientID
//join project in _db.Projects on clientproject.ProjectID equals project.ProjectID
where empPrj.EmployeeID == empPro.EmployeeID && empPrj.ProjectID == x
select empPrj).Any();
var workingEmployee = (from emp in _db.Employees
where emp.EmployeeId == empPro.EmployeeID
where emp.IsWorking == true
select emp).Any();
if (getEmployeeProject == false)
{
if (workingEmployee == true)
{
var projectAssign = new EmployeeProject
{
EmployeeID = empPro.EmployeeID,
ProjectID = x
};
_db.EmployeeProject.Add(projectAssign);
}
}
_db.SaveChanges();
}
}
public async Task <IActionResult> GetProjectsByEmployeeId(int id)
{
var empProjectAssignmentList = (await _employeeProjectAssignmentRepository.GetAll()).Where(x => x.EmployeeId == id);
List <Project> projList = new List <Project>();
//int empCode = (await _employeeRepository.Get(id)).EmployeeCode;
foreach (EmployeeProjectAssignment item in empProjectAssignmentList)
{
Project projFull = await this.GetFullProjectDetails(await _projectRepository.Get(item.ProjectId));
projList.Add(projFull);
}
List <EmployeeProjectViewModel> empProjViewModels = new List <EmployeeProjectViewModel>();
foreach (Project item in projList)
{
int projId = item.ProjectId;
string projName = item.ProjectName;
int manId = item.ProjectManagerId;
DateTime sDate = item.StartDate;
DateTime eDate = item.EndDate;
bool isClosed = item.IsClosed;
EmployeeNameViewModel empNameViewModel = new EmployeeNameViewModel(await _employeeRepository.Get(manId));
EmployeeProjectViewModel empProjViewModel = new EmployeeProjectViewModel(projId,
projName, empNameViewModel, sDate, eDate, isClosed);
empProjViewModels.Add(empProjViewModel);
}
return(Ok(empProjViewModels));
}
public ActionResult SaveProfileDetails(EmployeeProjectViewModel employeeProject)
{
try
{
SqlCommand command = new SqlCommand(DBConstants.Save_Employee, connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@employee_id", Session["employeeID"]);
command.Parameters.AddWithValue("@employee_mail_id", employeeProject.Employees.Email_ID);
command.Parameters.AddWithValue("@employee_name", employeeProject.Employees.Name);
command.Parameters.AddWithValue("@contact_number", employeeProject.Employees.Contact_Number);
command.Parameters.AddWithValue("@project_name", employeeProject.Project.Project_Name);
command.Parameters.AddWithValue("@department_name", employeeProject.Project.Department_Name);
command.Parameters.AddWithValue("@location", employeeProject.Project.Location);
command.Parameters.AddWithValue("@workstation_number", employeeProject.Project.Workstation_Number);
command.Parameters.AddWithValue("@extention_number", employeeProject.Project.Extension_Number);
connection.Open();
command.ExecuteNonQuery();
Index();
return(View("Index"));
}
catch (Exception e)
{
throw e;
}
finally
{
connection.Close();
}
}
public EmployeeProject Add(EmployeeProjectViewModel vm)
{
var entity = _mapper.Map <EmployeeProjectViewModel, EmployeeProject>(vm);
_iemployeeProjectRepository.Add(entity);
SaveChanges();
return(entity);
}
public IActionResult Create(int id)
{
//retrieving projects of sub company associated with employee
EmployeeProjectViewModel employeeProjectViewModel = new EmployeeProjectViewModel();
employeeProjectViewModel.Projects = _IEmployeeProject.GetProjects(id);
employeeProjectViewModel.Id = id;
return(View(employeeProjectViewModel));
}
public IActionResult AssignProjectToEmployee([FromBody] EmployeeProjectViewModel employee)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_employee.AssignProjectToEmployee(employee);
return(Ok());
}
//public string Index()
//{
// return "hello from mvc index";
//}
//public JsonResult About()
//{
// return Json("{id:2;name:hello}");
//}
public ViewResult AboutUs()
{
Employee emp = empRepositories.GetEmployee(2);
//ViewBag.projectname = "BookHive";
EmployeeProjectViewModel ep = new EmployeeProjectViewModel();
ep.employee = emp;
ep.projectname = "BookHive";
return(View(ep));
}
public bool UpdateEmployeeProjects(EmployeeProjectViewModel employeeProjectViewModel)
{
try
{
Employee emp = _mgmtContext.Employee.Where(e => e._EmpId == employeeProjectViewModel.Id).Include(e => e.EmployeeProjects).ThenInclude(e => e.Project).ToList()[0];
// if employee project is empty then add the selected project in EmployeePoject table
if (emp.EmployeeProjects.Count() == 0)
{
foreach (var pjt in employeeProjectViewModel.Projects)
{
if (pjt.isProjectSelected)
{
_mgmtContext.AddRange(new EmployeeProject {
employee = emp, Project = _mgmtContext.Project.FirstOrDefault(p => p._PjtId == pjt._PjtId)
});
}
}
}
else// when employee projects are in EmployeeProject table
{
foreach (var pjt in employeeProjectViewModel.Projects)
{
var empPjt = emp.EmployeeProjects.FirstOrDefault(ep => ep._PjtId == pjt._PjtId);
if (pjt.isProjectSelected && empPjt == null)
{
//project is selected and is not in the table so adding it to the database table
emp.EmployeeProjects.Add(
new EmployeeProject {
employee = emp, _PjtId = pjt._PjtId, Project = _mgmtContext.Project.FirstOrDefault(p => p._PjtId == pjt._PjtId)
}
);
}
else if (!pjt.isProjectSelected && empPjt != null)
{
// project is not selected but it is in the database table so,removing it
emp.EmployeeProjects.Remove(empPjt);
}
else if (pjt.isProjectSelected && empPjt != null)
{
//here do nothing as employee project is already in database table
}
}
}
_mgmtContext.SaveChanges();
return(true);
}
catch (Exception ex)
{
Debug.WriteLine("Message " + ex.Message);
return(false);
}
}
public IActionResult Create([Bind("Id,Emp_Name,Projects")] EmployeeProjectViewModel employeeProjectViewModel)
{
if (_IEmployeeProject.UpdateEmployeeProjects(employeeProjectViewModel))
{
return(RedirectToAction("Index", "Employee"));
}
else
{
ViewBag.Message = "Unable to associate project with employee";
}
ViewBag.Message = "Unable to associate project with employee";
return(View(employeeProjectViewModel));
}
public async Task <IActionResult> EmployeesInProject(int?ProjectID)
{
if (ProjectID == null)
{
return(NotFound());
}
var employeeProjectViewModel = new EmployeeProjectViewModel
{
Project = await _context.Project.FindAsync(ProjectID),
EmployeesInProject = await _context.EmployeeProject.Where(e => e.ProjectID == ProjectID).ToListAsync()
};
return(View(employeeProjectViewModel));
}
//***************************************************************************
// Example for View Model
public ViewResult AboutEmployee()
{
Employee emp = employeeRepository.GetEmployee(2);
/*
* ViewBag.projectName = "BookHive";
* return View(emp);
*/
EmployeeProjectViewModel ep = new EmployeeProjectViewModel();
ep.employee = emp;
ep.projectName = "BookHive";
return(View(ep));
}
public void AssignProjectToEmployee(EmployeeProjectViewModel empPro)
{
try
{
using (IDbConnection db = new SqlConnection(_connectionString))
{
var parameter = new DynamicParameters();
parameter.Add("@EmployeeID", empPro.EmployeeID);
parameter.Add("@ProjectID", empPro.ProjectID);
db.Execute("AssignProjectToEmployee", parameter, commandType: CommandType.StoredProcedure);
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Index()
{
EmployeeProjectViewModel employeeProjectViewModel = new EmployeeProjectViewModel();
employeeProjectViewModel.Employees.Email_ID = Convert.ToString(Session["username"]);
DataSet ds = IncidentCategories.GetEmployeeDetails(Convert.ToInt32(Session["employeeID"]));
foreach (DataRow dataRow in ds.Tables[0].Rows)
{
employeeProjectViewModel.Employees.Employee_ID = Convert.ToInt32(dataRow["employee_id"]);
employeeProjectViewModel.Employees.Name = Convert.ToString(dataRow["employee_name"]);
employeeProjectViewModel.Employees.Contact_Number = Convert.ToString(dataRow["contact_number"]);
employeeProjectViewModel.Project.Project_Name = Convert.ToString(dataRow["project_name"]);
employeeProjectViewModel.Project.Workstation_Number = Convert.ToString(dataRow["workstation_number"]);
employeeProjectViewModel.Project.Extension_Number = Convert.ToString(dataRow["extension_number"]);
employeeProjectViewModel.Project.Department_Name = Convert.ToString(dataRow["department_name"]);
employeeProjectViewModel.Project.Location = Convert.ToString(dataRow["employee_location"]);
}
return(View(employeeProjectViewModel));
}
public async Task <ActionResult <IEnumerable <Project> > > GetOpenProjects()
{
List <Project> projList = new List <Project>();
foreach (Project item in await _projectRepository.GetAll())
{
await this.GetFullProjectDetails(item);
projList.Add(item);
}
List <EmployeeProjectViewModel> empProjViewModels = new List <EmployeeProjectViewModel>();
foreach (Project item in projList)
{
if (item.IsClosed == false)
{
int projId = item.ProjectId;
string projName = item.ProjectName;
int manId = item.ProjectManagerId;
DateTime sDate = item.StartDate;
DateTime eDate = item.EndDate;
bool isClosed = item.IsClosed;
EmployeeNameViewModel empNameViewModel = new EmployeeNameViewModel(await _employeeRepository.Get(manId));
EmployeeProjectViewModel empProjViewModel = new EmployeeProjectViewModel(projId,
projName, empNameViewModel, sDate, eDate, isClosed);
empProjViewModels.Add(empProjViewModel);
}
}
return(Ok(empProjViewModels));
}
