C# (CSharp) ProjectManagementTool Join_User_Project_UserUnderProject 예제들

예제 #1

파일: Reports.aspx.cs 프로젝트: sapgreengem/ProjectManagementTool

 protected void Button2_Click(object sender, EventArgs e)
 {
     using (PMTDBContext context = new PMTDBContext())
     {
         IEnumerable <UsersUnderProject>           usersUnderProject = context.UsersUnderProjects.ToList();
         List <Join_User_Project_UserUnderProject> joinData          = new List <Join_User_Project_UserUnderProject>();
         foreach (var item in usersUnderProject)
         {
             Join_User_Project_UserUnderProject addData = new Join_User_Project_UserUnderProject()
             {
                 //AssignedID = item.AssignedID,
                 ProjectName     = item.Project.ProjectName,
                 UserName        = item.User.UserName,
                 DesignationName = item.User.Designation.DesignationName
             };
             joinData.Add(addData);
         }
         GridView1.DataSource = joinData.OrderBy(a => a.ProjectName).ToList();
         GridView1.DataBind();
     }
 }

예제 #2

 private void loadData()
 {
     using (PMTDBContext context = new PMTDBContext())
     {
         IEnumerable <UsersUnderProject>           usersUnderProject = context.UsersUnderProjects.ToList();
         List <Join_User_Project_UserUnderProject> joinData          = new List <Join_User_Project_UserUnderProject>();
         foreach (var item in usersUnderProject)
         {
             Join_User_Project_UserUnderProject addData = new Join_User_Project_UserUnderProject()
             {
                 //AssignedID = item.AssignedID,
                 ProjectName     = item.Project.ProjectName,
                 UserName        = item.User.UserName,
                 DesignationName = item.User.Designation.DesignationName
             };
             joinData.Add(addData);
         }
         GridView1.DataSource = joinData.ToList();
         GridView1.DataBind();
     }
 }