Ejemplo n.º 1
0
        /// 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();

            }
        }