private void GetHbA1c() { using (QueriesTableAdapters.sp_GetHbA1cTableAdapter ta = new QueriesTableAdapters.sp_GetHbA1cTableAdapter()) { using (Queries.sp_GetHbA1cDataTable dt = new Queries.sp_GetHbA1cDataTable()) { ta.Fill(dt, LoginRow.user_id, DateTime.Now); Session.Remove("HbA1c_Value"); Session.Remove("eAG_Value"); if (dt.Rows.Count > 0) { //HbA1c value returned double HbA1c = dt.FirstOrDefault().HbA1c; double eAG = (HbA1c == 0) ? 0 : Math.Round(28.7 * HbA1c - 46.7, 1, MidpointRounding.AwayFromZero); Session.Add("HbA1c_Value", HbA1c); Session.Add("eAG_Value", eAG); } else { //no HbA1c value returned } } } }
private void GetHbA1c() { using (QueriesTableAdapters.sp_GetHbA1cTableAdapter ta = new QueriesTableAdapters.sp_GetHbA1cTableAdapter()) { using (Queries.sp_GetHbA1cDataTable dt = new Queries.sp_GetHbA1cDataTable()) { ta.Fill(dt, LoginRow.user_id, DateTime.Now); Session.Remove("HbA1c_Value"); Session.Remove("eAG_Value"); if (dt.Rows.Count > 0) { //HbA1c value returned double HbA1c = dt.FirstOrDefault().HbA1c; double eAG = (HbA1c == 0) ? 0 : Math.Round(28.7 * HbA1c - 46.7, 1, MidpointRounding.AwayFromZero); Session.Add("HbA1c_Value", HbA1c); Session.Add("eAG_Value", eAG); } else { //no HbA1c value returned } } } }