private void ProjectManagerForm1_Load(object sender, EventArgs e)
{
cmbCustomer.DataSource = _customerBusiness.GetAll();
cmbCustomer.ValueMember = "CustomerId";
cmbCustomer.DisplayMember = "CustomerName";
dgvAllProject.DataSource = _projectBusiness.GetAll();
cmbEmployeeRole.DataSource = _employeeRoleBusiness.GetAll();
cmbEmployeeRole.DisplayMember = "RoleName";
cmbEmployeeRole.ValueMember = "EmployeeRoleId";
}
public List <ProjectModel> GetAll()
{
projectBusiness = new ProjectBusiness();
var result = projectBusiness.GetAll();
return(result);
}
private void ProjectListForm_Load(object sender, EventArgs e)
{
_projectBusiness = new ProjectBusiness();
List <Project> projectList = _projectBusiness.GetAll();
dgvList.DataSource = null;
dgvList.DataSource = projectList;
}
public void FiilDgw()
{
dgwList.DataSource = null;
var source = (
from pro in _projectBusiness.GetAll()
from task in _tasksBusiness.GetAll()
from sta in _stateBusiness.GetAll()
where task.ProjetId == pro.ProjectId && task.StateId == sta.StateId && sta.Status == "Başlanmadı"
select new
{
task.TaskId,
task.TaskName,
pro.ProjectName,
task.StartingDate,
task.FinishDate,
sta.Status,
}).ToList();
dgwList.DataSource = source;
}
private void tbBusinessAnalyst_Click(object sender, EventArgs e)
{
cmbEmployeeName.DisplayMember = "FirstName";
cmbEmployeeName.ValueMember = "EmployeeId";
cmbEmployeeName.DataSource = _employeeBusiness.GetAll();
cmbProjectAssignment.DisplayMember = "ProjectName";
cmbProjectAssignment.ValueMember = "ProjectId";
cmbProjectAssignment.DataSource = _projectBusiness.GetAll();
cmbState.DisplayMember = "Status";
cmbState.ValueMember = "StateId";
cmbState.DataSource = _stateBusiness.GetAll();
cmbProjectName.DisplayMember = "ProjectName";
cmbProjectName.ValueMember = "ProjectId";
cmbProjectName.DataSource = _projectBusiness.GetAll();
cmbTaskAssignment.DisplayMember = "TaskName";
cmbTaskAssignment.ValueMember = "TaskId";
cmbTaskAssignment.DataSource = _taskBusiness.GetAll();
}
public void RefreshDGV()
{
ProjectBusiness projectBuss = new ProjectBusiness(_user);
dgvProject.DataSource = null;
try
{
dgvProject.DataSource = projectBuss.GetAll();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void TaskForm_Load(object sender, EventArgs e)
{
EmployeeBusiness employeeBusiness = new EmployeeBusiness();
ProjectBusiness projeBusiness = new ProjectBusiness();
List <Employee> empList = employeeBusiness.GetAll();
List <Project> projeList = projeBusiness.GetAll();
cmbEmployee.DataSource = null;
cmbEmployee.DataSource = empList;
cmbEmployee.DisplayMember = "FirstName";
cmbEmployee.ValueMember = "ID";
cmbProje.DataSource = null;
cmbProje.DataSource = projeList;
cmbProje.DisplayMember = "Name";
cmbProje.ValueMember = "ID";
}
private void TestingSpecialistForm1_Load(object sender, EventArgs e)
{
var source = (from t in _tasksBusiness.GetAll()
join et in _employeeTaskBusiness.GetAll() on t.TaskId equals et.TaskId into tet
from te in tet.DefaultIfEmpty()
join p in _projectBusiness.GetAll() on t.ProjetId equals p.ProjectId
where t.StateId == 4
select new
{
p.ProjectName,
t.TaskName,
t.StartingDate,
t.FinishDate,
p.ProjectId,
DeveloperID = te == null ? 0 : te.EmployeeId,
}).ToList();
dgwTest.DataSource = source;
}
public void FillDgw()
{
dgwList.DataSource = null;
var source = (from t in _tasksBusiness.GetAll()
join et in _employeeTasksBusiness.GetAll() on t.TaskId equals et.TaskId into tet
from te in tet.DefaultIfEmpty()
join p in _projectBusiness.GetAll() on t.ProjetId equals p.ProjectId
where t.StateId == 3
select new
{
p.ProjectName,
t.TaskId,
t.TaskName,
t.StartingDate,
t.FinishDate,
p.ProjectId,
DeveloperID = te == null ? 0 : te.EmployeeId
}).ToList();
dgwList.DataSource = source;
}