private void LoadData()
{
this.Title = "Loading data . . . . . . . . . . . .";
Sr25DataSetTableAdapters.ndataTableAdapter nda = new Sr25DataSetTableAdapters.ndataTableAdapter();
nda.Fill(ds.ndata);
nda.Dispose();
}
private void Loadndata()
{
if (ds.ndata.Rows.Count == 0)
{
SR25Ce.Sr25DataSetTableAdapters.ndataTableAdapter da = new Sr25DataSetTableAdapters.ndataTableAdapter();
da.Fill(ds.ndata);
da.Dispose();
}
}
private void FoodValueData()
{
//lazy loading must beware this data is not loaded at start of the program.
if (ds.ndata.Rows.Count == 0)
{
SR25Ce.Sr25DataSetTableAdapters.ndataTableAdapter da = new Sr25DataSetTableAdapters.ndataTableAdapter();
da.Fill(ds.ndata);
da.Dispose();
}
}
private void AddFoodRow(Sr25DataSet.FOOD_DESRow fr)
{
if (foo.ndata.Rows.Count == 0)
{
//Title = string.Format("lazy loader busy .. Loading data before .. {0}", fr.NDB_No);
Sr25DataSetTableAdapters.ndataTableAdapter ddda = new Sr25DataSetTableAdapters.ndataTableAdapter();
ddda.Fill(foo.ndata);
ddda.Dispose();
}
var nuts4foo = foo.ndata.Where(f => f.NDB_No == fr.NDB_No).ToDictionary(nno => nno.Nutr_No);
DataRow dr = TheResTab.NewRow();
float v = 0F;
dr[0] = fr.Desc;
for (int i = 1; i < TheResTab.Columns.Count; i++)
{
short _nut_no = short.Parse(TheResTab.Columns[i].Caption);
//Title = DateTime.Now.ToLongTimeString();
try
{
var _nut_val = nuts4foo[_nut_no];
dr[i] = _nut_val.Nutr_Val;
}
catch (KeyNotFoundException eee)
{
dr[i] = v;
}
}
TheResTab.Rows.Add(dr);
}
/// <summary>
/// Make The DataTable for The results Datagrid.
/// </summary>
private void MakeResTab()
{
//TheResTab.Columns.Clear();
if (foo.NUT_DEF.Rows.Count <= 0)
{
Sr25DataSetTableAdapters.ndataTableAdapter ddda = new Sr25DataSetTableAdapters.ndataTableAdapter();
ddda.Fill(foo.ndata);
ddda.Dispose();
}
DataColumn ndc = new DataColumn("Food List", typeof(string));
ndc.Caption = "000";
TheResTab.Columns.Add(ndc);// Food column Header.......
foreach (Sr25DataSet.NUT_DEFRow nd in foo.NUT_DEF)
{
//if (nd.IsSelected != null && )
//{
//colname = string.Format("{0}-({1}).",nd.NutrDesc,nd.Units);
ndc = new DataColumn(nd.Nutr_No.ToString(), typeof(float));
ndc.Caption = nd.Nutr_No.ToString(); // save the nutr_no key!!
TheResTab.Columns.Add(ndc);
//}
}
}
private void Loadndata()
{
Sr25DataSetTableAdapters.ndataTableAdapter nddd = new Sr25DataSetTableAdapters.ndataTableAdapter();
nddd.Fill(foo.ndata);
}
