//Manager
//Get all projects in a list with project id,name and description
public List <ReleaseManagementModel> GetAllAssignedModules(string userName)
{
DataSet dsGetprojectId = dal.GetProjectId(userName);
List <ReleaseManagementModel> projects = new List <ReleaseManagementModel>();
ReleaseManagementModel project;
foreach (DataRow row in dsGetprojectId.Tables[0].Rows)
{
project = new ReleaseManagementModel();
project.ProjectId = row[0].ToString();
project.ProjectName = row[1].ToString();
projects.Add(project);
}
DataSet dsGetAllAssignedModules;
ReleaseManagementModel modules;
List <ReleaseManagementModel> assignedModules = new List <ReleaseManagementModel>();
for (int i = 0; i < projects.Count; i++)
{
dsGetAllAssignedModules = dal.GetAllAssignedModules(projects[i].ProjectId);
foreach (DataRow row in dsGetAllAssignedModules.Tables[0].Rows)
{
modules = new ReleaseManagementModel();
modules.ProjectName = row[0].ToString();
modules.ModuleName = row[1].ToString();
modules.ModuleStatus = row[2].ToString();
modules.ModuleId = row[3].ToString();
assignedModules.Add(modules);
}
}
DataSet dsGetAllDeveloperName = dal.GetAllDeveloperName();
DataSet dsGetAllTesterName = dal.GetAllTesterName();
List <ReleaseManagementModel> developerList = new List <ReleaseManagementModel>();
ReleaseManagementModel developer;
foreach (DataRow row in dsGetAllDeveloperName.Tables[0].Rows)
{
developer = new ReleaseManagementModel();
developer.DeveloperName = row[0].ToString();
developer.ModuleId = row[1].ToString();
developerList.Add(developer);
}
List <ReleaseManagementModel> testerList = new List <ReleaseManagementModel>();
ReleaseManagementModel tester;
foreach (DataRow row in dsGetAllTesterName.Tables[0].Rows)
{
tester = new ReleaseManagementModel();
tester.TesterName = row[0].ToString();
tester.ModuleId = row[1].ToString();
testerList.Add(tester);
}
for (int i = 0; i < developerList.Count; i++)
{
for (int j = 0; j < assignedModules.Count; j++)
{
if (developerList[i].ModuleId == assignedModules[j].ModuleId)
{
assignedModules[j].DeveloperName = developerList[i].DeveloperName;
}
}
}
for (int i = 0; i < testerList.Count; i++)
{
for (int j = 0; j < assignedModules.Count; j++)
{
if (testerList[i].ModuleId == assignedModules[j].ModuleId)
{
assignedModules[j].TesterName = testerList[i].TesterName;
}
}
}
return(assignedModules);
}