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
}
}
}
}
