/// Function Header*******************************************************
/// Function Name: GetTLWFormulaForIndividualReport
/// Function Type: Function
/// Functionality: used to get the details by userid
/// Input:
/// Output:
/// Return Value:
/// Note:
/// *********************************************************************
public List<Entity.PersonalSummaryInfo> GetTLWFormulaForIndividualReport(Entity.PersonalSummaryInfo oPersonalSummaryInfo)
{
using (TLWDALDataContext _db = new TLWDALDataContext())
{
return (from _ps in _db.ms_GetTLWFormulaForIndividualReport(oPersonalSummaryInfo.StrGender,
oPersonalSummaryInfo.DecWaist,
oPersonalSummaryInfo.DecBMI,
oPersonalSummaryInfo.DecBodyFATPercentage,
oPersonalSummaryInfo.DecWaistToHeight,
oPersonalSummaryInfo.DecWaistToHip,
oPersonalSummaryInfo.DecWeight)
select new Entity.PersonalSummaryInfo
{
StrRatioType = _ps.strRatioType,
StrRatioCode = _ps.strRatioCode,
DecFrom = _ps.decFrom ?? 0,
DecTo = _ps.decTo ?? 0,
StrLevelofRisk = _ps.strLevelofRisk ?? "",
DtModifiedOn = _ps.dtModifiedOn ?? DateTime.Now
}).ToList();
}
}