コード例 #1
0
        public IActionResult Details(int id)
        {
            var group        = groupMeetingService.GetGroupMeetingById(id);
            var detailResult = new GroupMeetingView()
            {
                Id           = group.Id,
                Description  = group.Description,
                TeamLeadName = group.TeamLeadName,
                MeetingDate  = group.GroupMeetingDate,
                LeadName     = group.GroupMeetingLeadName,
                ProjectName  = group.ProjectName
            };

            return(View(detailResult));
        }
コード例 #2
0
        public GroupMeetingView GetGroupMeetingById(int?id)
        {
            GroupMeetingView groupMeeting = new GroupMeetingView();

            if (id == null)
            {
                return(groupMeeting);
            }
            using (IDbConnection con = new SqlConnection(strConnectionString))
            {
                if (con.State == ConnectionState.Closed)
                {
                    con.Open();
                }
                DynamicParameters parameter = new DynamicParameters();
                parameter.Add("@Id", id);
                groupMeeting = con.Query <GroupMeetingView>("GetGroupMeetingByID", parameter, commandType: CommandType.StoredProcedure).FirstOrDefault();
            }
            return(groupMeeting);
        }