public List <TechnologyMaster> GetAllTechnologiesForEmployee(int employeeID)
{
/* try
* {
* CompanyDBDataContext dc = new CompanyDBDataContext();
* var techList = (from employeeTask in dc.EmployeeTaskMaps
* join techTask in dc.TechTaskMaps on employeeTask.TaskID equals techTask.TaskID
* where employeeTask.EmployeeID == employeeID
* select new { Technology = techTask.TechnologyMaster, Task = techTask.Task, Employee = employeeTask.Employee }).ToList();
* return techList.Select(tuple => (tuple.Technology, tuple.Employee)).ToList();
* }
* catch (Exception ex)
* {
* throw ex;
* }*/
try
{
if (ValidationHelper.IfEmployeeExist(employeeID))
{
CompanyDBDataContext dc = new CompanyDBDataContext();
var techList = (from employeeTask in dc.EmployeeProjects join techTask in dc.TechProjectMaps on employeeTask.ProjectID equals techTask.ProjectID where employeeTask.EmployeeID == employeeID select techTask.TechnologyMaster).ToList();
return(techList);
}
else
{
throw new Exception(QueryResource.EmployeeNotFound);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteTask(int taskID)
{
try
{
if (ValidationHelper.IfTaskExist(taskID))
{
CompanyDBDataContext dc = new CompanyDBDataContext();
List <ProjectTaskMap> taskProjectList = (from taskProject in dc.ProjectTaskMaps where taskProject.TaskID == taskID select taskProject).ToList();
List <EmployeeTaskMap> employeeTaskList = (from empTask in dc.EmployeeTaskMaps where empTask.TaskID == taskID select empTask).ToList();
Task taskToDelete = (from task in dc.Tasks where task.TaskID == taskID select task).First();
dc.ProjectTaskMaps.DeleteAllOnSubmit(taskProjectList);
dc.EmployeeTaskMaps.DeleteAllOnSubmit(employeeTaskList);
dc.Tasks.DeleteOnSubmit(taskToDelete);
dc.SubmitChanges();
Console.WriteLine("Task Deleted Sucessfully");;
}
else
{
throw new Exception(QueryResource.TaskNotExist);
}
}
catch (Exception ex)
{
throw ex;
}
}
public int GetAllTechnologyForTask(int taskID)
{
CompanyDBDataContext dc = new CompanyDBDataContext();
List <int> techTask = (from task in dc.TechTaskMaps where task.TaskID == taskID select task.TechID).ToList();
return(techTask.Count);
}
public static bool IfEmployeeExist(int employeeID)
{
CompanyDBDataContext dc = new CompanyDBDataContext();
bool employeeExistance = (from emp in dc.Employees where emp.EmployeeID == employeeID select emp).Any();
return(employeeExistance);
}
public int GetStatusOfProject(int projectID)
{
CompanyDBDataContext dc = new CompanyDBDataContext();
int projectStatus = (from project in dc.Projects where project.ProjectID == projectID select project.StatusID).First();
return(projectStatus);
}
public static bool IfProjectExist(int projectID)
{
CompanyDBDataContext dc = new CompanyDBDataContext();
bool projectExistance = (from project in dc.Projects where project.ProjectID == projectID select project).Any();
return(projectExistance);
}
public static bool IfTechnologyExist(int technologyID)
{
CompanyDBDataContext dc = new CompanyDBDataContext();
bool technologyExistance = (from tech in dc.TechnologyMasters where tech.TechID == technologyID select true).Any();
return(technologyExistance);
}
public static bool IfTaskExist(int taskID)
{
CompanyDBDataContext dc = new CompanyDBDataContext();
bool taskExistance = (from task in dc.Tasks where task.TaskID == taskID select true).Any();
return(taskExistance);
}
public int GetStatusOfTask(int taskID)
{
CompanyDBDataContext dc = new CompanyDBDataContext();
int taskStatus = (from task in dc.Tasks where task.TaskID == taskID select task.StatusID).First();
return(taskStatus);
}
public void DeleteProject(int projectID)
{
try
{
if (ValidationHelper.IfProjectExist(projectID))
{
CompanyDBDataContext dc = new CompanyDBDataContext();
List <ProjectTaskMap> taskProjectList = (from taskProject in dc.ProjectTaskMaps where taskProject.ProjectID == projectID select taskProject).ToList();
List <EmployeeProject> employeeProjectList = (from empProject in dc.EmployeeProjects where empProject.ProjectID == projectID select empProject).ToList();
Project projectToDelete = (from project in dc.Projects where project.ProjectID == projectID select project).First();
dc.ProjectTaskMaps.DeleteAllOnSubmit(taskProjectList);
dc.EmployeeProjects.DeleteAllOnSubmit(employeeProjectList);
dc.Projects.DeleteOnSubmit(projectToDelete);
dc.SubmitChanges();
Console.WriteLine("Project Deleted Sucessfully");
}
else
{
throw new Exception(QueryResource.ProjectIDNotFound);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteEmployeeFromSystem(int employeeID)
{
try
{
if (ValidationHelper.IfEmployeeExist(employeeID))
{
CompanyDBDataContext dc = new CompanyDBDataContext();
List <EmployeeProject> employeeProjectList = (from empProject in dc.EmployeeProjects where empProject.EmployeeID == employeeID select empProject).ToList();
List <EmployeeTaskMap> employeeTaskList = (from employeeTask in dc.EmployeeTaskMaps where employeeTask.EmployeeID == employeeID select employeeTask).ToList();
Employee employeeToDelete = (from employee in dc.Employees where employee.EmployeeID == employeeID select employee).First();
dc.EmployeeTaskMaps.DeleteAllOnSubmit(employeeTaskList);
dc.EmployeeProjects.DeleteAllOnSubmit(employeeProjectList);
dc.Employees.DeleteOnSubmit(employeeToDelete);
dc.SubmitChanges();
Console.WriteLine("Employee Deleted Sucessfully");
}
else
{
throw new Exception(QueryResource.EmployeeNotFound);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteTechnology(int technology)
{
try
{
if (ValidationHelper.IfTechnologyExist(technology))
{
CompanyDBDataContext dc = new CompanyDBDataContext();
List <TechProjectMap> techProjectList = (from techProject in dc.TechProjectMaps where techProject.TechID == technology select techProject).ToList();
List <TechTaskMap> techTaskList = (from techTask in dc.TechTaskMaps where techTask.TechID == technology select techTask).ToList();
TechnologyMaster technologyToDelete = (from tech in dc.TechnologyMasters where tech.TechID == technology select tech).First();
dc.TechTaskMaps.DeleteAllOnSubmit(techTaskList);
dc.TechProjectMaps.DeleteAllOnSubmit(techProjectList);
dc.TechnologyMasters.DeleteOnSubmit(technologyToDelete);
dc.SubmitChanges();
Console.WriteLine("Technology Deleted Sucessfully");;
}
else
{
throw new Exception(QueryResource.TechnologyNotexist);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void AssignTechnologyToTask(int technologyID, int taskID)
{
try
{
CompanyDBDataContext dc = new CompanyDBDataContext();
bool taskPresent = ValidationHelper.IfTaskExist(taskID);
bool techPresent = ValidationHelper.IfTechnologyExist(technologyID);
if (taskPresent && techPresent)
{
TechTaskMap tech = new TechTaskMap();
tech.TaskID = taskID;
tech.TechID = technologyID;
dc.TechTaskMaps.InsertOnSubmit(tech);
dc.SubmitChanges();
}
else if (!taskPresent || !techPresent)
{
if (taskPresent)
{
throw new Exception(QueryResource.TechnologyNotexist);
}
else if (techPresent)
{
throw new Exception(QueryResource.TaskNotExist);
}
else
{
throw new Exception(QueryResource.TechAndTaskNotExit);
}
}
}
catch (Exception ex) { throw ex; }
}
public void CreateTaskInProject(Task task, int projectID)
{
try
{
bool taskPresent = ValidationHelper.IfTaskExist(task.TaskID);
bool projectPresent = ValidationHelper.IfProjectExist(projectID);
if (projectPresent && taskPresent)
{
CompanyDBDataContext dc = new CompanyDBDataContext();
ProjectTaskMap projectTask = new ProjectTaskMap();
projectTask.TaskID = task.TaskID;
projectTask.ProjectID = projectID;
dc.ProjectTaskMaps.InsertOnSubmit(projectTask);
dc.SubmitChanges();
}
else if (!taskPresent || !projectPresent)
{
if (taskPresent)
{
throw new Exception(QueryResource.TechnologyNotexist);
}
else if (projectPresent)
{
throw new Exception(QueryResource.TaskNotExist);
}
else
{
throw new Exception(QueryResource.TechAndTaskNotExit);
}
}
}
catch (Exception ex) { throw ex; }
}
public void AssignEmployeeToProject(int employeeID, int projectID)
{
try
{
if (ValidationHelper.IfProjectExist(projectID))
{
CompanyDBDataContext dc = new CompanyDBDataContext();
var project = (from emp in dc.EmployeeProjects
where emp.ProjectID == projectID
select emp).First();
if (ValidationHelper.IfEmployeeExist(employeeID))
{
project.EmployeeID = employeeID;
dc.SubmitChanges();
}
else
{
throw new Exception(QueryResource.EmployeeNotFound);
}
}
else
{
throw new Exception(QueryResource.ProjectIDNotFound);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool IsWorker(int employeeID)
{
CompanyDBDataContext dc = new CompanyDBDataContext();
bool worker = (from emp in dc.EmployeeProjects where emp.EmployeeID == employeeID && emp.RoleID == (int)RoleEnum.Worker select emp).Any();
return(worker);
}
public void AddTechTaskMap(TechTaskMap techTask)
{
CompanyDBDataContext dc = new CompanyDBDataContext();
string dataValidate = ValidationHelper.CheckCompulsoryTechtaskColumn(techTask);
if (dataValidate != QueryResource.AllFieldsPresent)
{
throw new Exception(dataValidate);
}
dc.TechTaskMaps.InsertOnSubmit(techTask);
dc.SubmitChanges();
}
public void UpdateStatusOfProject(int projectID, int statusID)
{
CompanyDBDataContext dc = new CompanyDBDataContext();
Project updateStatus = (from project in dc.Projects where project.ProjectID == projectID select project).First();
updateStatus.StatusID = statusID;
try
{
dc.SubmitChanges();
}catch (Exception ex)
{
throw ex;
}
}
public List <TechnologyMaster> GetAllTechologies()
{
try
{
CompanyDBDataContext dc = new CompanyDBDataContext();
List <TechnologyMaster> techList = (from tech in dc.TechnologyMasters
select tech).ToList();
return(techList);
}
catch (Exception ex)
{
throw ex;
}
}
public void AddProject(Project project)
{
CompanyDBDataContext dc = new CompanyDBDataContext();
string dataValidate = ValidationHelper.CheckCompulsoryProjectColumn(project);
if (dataValidate != QueryResource.AllFieldsPresent)
{
throw new Exception(dataValidate);
}
else
{
dc.Projects.InsertOnSubmit(project);
dc.SubmitChanges();
}
}
public void AddEmployeeTaskMap(EmployeeTaskMap employeeTask)
{
CompanyDBDataContext dc = new CompanyDBDataContext();
string dataValidate = ValidationHelper.CheckCompulsoryEmployeeTaskColumn(employeeTask);
if (dataValidate != QueryResource.AllFieldsPresent)
{
throw new Exception(dataValidate);
}
else
{
dc.EmployeeTaskMaps.InsertOnSubmit(employeeTask);
dc.SubmitChanges();
}
}
public void AddCompany(Company company)
{
CompanyDBDataContext dc = new CompanyDBDataContext();
string dataValidate = ValidationHelper.CheckCompulsoryCompanyColumn(company);
if (dataValidate != QueryResource.AllFieldsPresent)
{
throw new Exception(dataValidate);
}
else
{
dc.Companies.InsertOnSubmit(company);
dc.SubmitChanges();
}
}
public List <Project> GetAllProjects()
{
try
{
CompanyDBDataContext dc = new CompanyDBDataContext();
List <Project> projectList = (from project in dc.Projects
select project).ToList();
return(projectList);
//Is This also Correct ...return dc.projects.tolist();
}
catch (Exception ex)
{
throw ex;
}
}
public void AddTechnology(TechnologyMaster technology)
{
CompanyDBDataContext dc = new CompanyDBDataContext();
string dataValidate = ValidationHelper.CheckCompulsoryTechnologyColumn(technology);
if (dataValidate != QueryResource.AllFieldsPresent)
{
throw new Exception(dataValidate);
}
else
{
dc.TechnologyMasters.InsertOnSubmit(technology);
dc.SubmitChanges();
}
}
public void AddDepartment(DepartmentMaster department)
{
CompanyDBDataContext dc = new CompanyDBDataContext();
string dataValidate = ValidationHelper.CheckCompulsoryDepartmentColumn(department);
if (dataValidate != QueryResource.AllFieldsPresent)
{
throw new Exception(dataValidate);
}
else
{
dc.DepartmentMasters.InsertOnSubmit(department);
dc.SubmitChanges();
}
}
public List <Project> GetAllDelayedProjects()
{
try
{
CompanyDBDataContext dc = new CompanyDBDataContext();
List <Project> delayedProjects = (from project in dc.Projects
where project.StatusID == (int)StatusEnum.Delayed
select project).ToList();
return(delayedProjects);
}
catch (Exception ex)
{
throw ex;
}
}
public void AddEmployee(Employee employee)
{
CompanyDBDataContext dc = new CompanyDBDataContext();
string dataValidate = ValidationHelper.CheckCompulsoryEmployeeColumn(employee);
if (dataValidate != QueryResource.AllFieldsPresent)
{
throw new Exception(dataValidate);
}
else
{
dc.Employees.InsertOnSubmit(employee);
dc.SubmitChanges();
Console.WriteLine("Employee Added");
}
}
public void AddStatus(StatusMaster status)
{
CompanyDBDataContext dc = new CompanyDBDataContext();
string dataValidate = ValidationHelper.CheckCompulsoryStatusColumn(status);
if (dataValidate != QueryResource.AllFieldsPresent)
{
throw new Exception(dataValidate);
}
else
{
dc.StatusMasters.InsertOnSubmit(status);
dc.SubmitChanges();
}
}
public List <Task> GetAllDelayedTasksForEmployee(int employeeID)
{
try
{
if (ValidationHelper.IfEmployeeExist(employeeID))
{
CompanyDBDataContext dc = new CompanyDBDataContext();
List <Task> delayedTaskList = (from emp in dc.EmployeeTaskMaps where emp.EmployeeID == employeeID && emp.Task.StatusID == (int)StatusEnum.Delayed select emp.Task).ToList();
return(delayedTaskList);
}
else
{
throw new Exception(QueryResource.EmployeeNotFound);
}
}
catch (Exception ex) { throw ex; }
}
public List <TechTaskMap> GetAllTechnologyTasksForEmployee(int technologyID, int employeeID)
{
/* try
* {
* CompanyDBDataContext dc = new CompanyDBDataContext();
* var techTaskList = (from employeeTask in dc.EmployeeTaskMaps
* join techTask in dc.TechTaskMaps on employeeTask.TaskID equals techTask.TaskID
* where employeeTask.EmployeeID == employeeID && techTask.TechID == technologyID
* select new { Technology = techTask.TechnologyMaster, Task = techTask.Task, Employee = employeeTask.Employee }).ToList();
* return techTaskList.Select(tuple => (tuple.Technology, tuple.Task, tuple.Employee)).ToList();
* }
* catch (Exception ex)
* {
* throw ex;
* }*/
try
{
var techPresent = ValidationHelper.IfTechnologyExist(technologyID);
var empPresent = ValidationHelper.IfEmployeeExist(employeeID);
if (techPresent && empPresent)
{
CompanyDBDataContext dc = new CompanyDBDataContext();
var result = (from techTask in dc.TechTaskMaps join employeeTask in dc.EmployeeTaskMaps on techTask.TaskID equals employeeTask.TaskID where techTask.TechID == technologyID && employeeTask.EmployeeID == employeeID select techTask).ToList();
return(result);
}
else if (!techPresent || !empPresent)
{
if (techPresent)
{
throw new Exception(QueryResource.EmployeeNotFound);
}
else
{
throw new Exception(QueryResource.TechnologyNotexist);
}
}
else
{
throw new Exception(QueryResource.EmployeeNotFound + QueryResource.TechnologyNotexist);
}
}
catch (Exception ex)
{
throw ex;
}
}
