/// 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(); } }