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