How to retrieve value of Property in a model using Stored Proc

Hello Basit,

To retrieve the value of a property in a model using this Stored Proc, you can do following. 

int timeCardID = ;
int invoiceSourceTypeID = ;

DateTime lastModifiedDate = this.Database.SqlQuery("EXEC [dbo].[spGetTimecardLastModifiedDate] @TimeCardID, @InvoiceSourceTypeID", new SqlParameter("@TimeCardID", timeCardID), new SqlParameter("@InvoiceSourceTypeID", invoiceSourceTypeID)).FirstOrDefault();

select (new TimeSheetDetailViewModel
{
    TimeCardID = timecard.TimeCardID,
    TimeSheetStatusTypeID = timecard.StatusID ?? 0,
    TimeSheetStatusTypeName = BC.TimeSheetStatusTypeName,
    SubmittedDate = timecard.SubmittedDate,
    HourWorks = timecard.MinutesWorked,
    ContactID = timecard.ContactID,
    FirstName = contact.FirstName.Trim(),
    MiddleName = contact.MiddleName,
    LastName = contact.LastName,
    EmployeeNumber = contact.EmployeeNumber,
    WeekStartDate = timecard.WeekStartDate,
    WeekEndDate = DbFunctions.AddDays(timecard.WeekStartDate, 6),
    ApprovedBy = timecard.ApprovedBy,
    ApprovedDate = timecard.ApprovedDate,
    CATStaffApprovedBy = timecard.CATStaffApprovedBy,
    CATStaffApprovedDate = timecard.CATStaffApprovedDate,
    RejectionComment = contextTimesheet.TCRejectionHistories.OrderByDescending(t => t.RejectionHistoryID).FirstOrDefault(t => t.TimeCardId == timecard.TimeCardID).Comment ?? string.Empty,
    PayTypeID = timecard.PayTypeId ?? 0,
    PayTypeName = BC.PayTypeName,
    DiemTypeID = BC.DiemTypeID ?? 0,
    DiemTypeName = BC.DiemTypeName ?? "",
    ContactAssignmentID = CA.ContactAssignmentID,
    LastModifiedDate = lastModifiedDate
})).Distinct().ToList();

Thanks

Naimish Makwana