public List <RequestLogVm> ListRequestLog()
{
using (var db = new LMISEntities())
{
return(db.RequestLogs
.AsNoTracking()
.Select(r => new
{
RequestLog = r,
db.Admins.FirstOrDefault(a => a.AdminId == r.AdminID).AdminName,
PortalUserName = SqlUdf.PortalUserName(r.PortalUserID, 1),
RequestTypeDesc = SqlUdf.SubCodeName(r.RequestType, 1),
Title = SqlUdf.RequestTitle(r.RequestType, r.RequestID, 1),
DeleteDate = SqlUdf.RequestDeleteDate(r.RequestType, r.RequestID)
})
.ToList()
.Select(r => new RequestLogVm
{
Id = (long)r.RequestLog.ID,
Admin = new CodeSet
{
id = r.RequestLog.AdminID,
desc = r.AdminName
},
PortalUserId = (long)r.RequestLog.PortalUserID,
PortalUserName = r.PortalUserName,
RequestType = new CodeSet
{
id = r.RequestLog.RequestType,
desc = r.RequestTypeDesc
},
RequestId = (long)r.RequestLog.RequestID,
Title = r.Title,
PostDate = r.RequestLog.PostDate,
UpdateDate = r.RequestLog.UpdateDate,
DeleteDate = r.DeleteDate,
Approval = (Approval)r.RequestLog.Is_Approved
})
.ToList());
}
}