public List <FoodCount> FoodChartforReport()
{
FClist fclist = new FClist();
DataTable dt = d.FoodChartforReport();
for (int i = 0; i < dt.Rows.Count; i++)
{
FoodCount fc = new FoodCount()
{
fid = dt.Rows[i][0].ToString(),
fname = dt.Rows[i][1].ToString(),
fcount = (int)dt.Rows[i][2]
};
fclist.AddFC(fc);
}
return(fclist.getFCList());
}
public List <FoodCount> FoodChartDailyforReport()
{
FClist fclist = new FClist();
DataTable dt = d.FoodChartDailyforReport();
List <string> fid = (String.Join(",", dt.AsEnumerable().Select(x => x.Field <string>("fid").ToString()).ToArray())).Split(',').ToList();
List <string> fammResult = (String.Join(",", dt.AsEnumerable().Select(x => x.Field <string>("famm").ToString()).ToArray())).Split(',').ToList();
List <int> famm = fammResult.Select(int.Parse).ToList();
for (int i = 0; i < fid.Count; i++)
{
for (int j = i + 1; j < fid.Count; j++)
{
if (fid[i] == fid[j])
{
famm[i] += famm[j];
fid.RemoveAt(j);
famm.RemoveAt(j);
}
}
}
FoodCount fc = new FoodCount()
{
fid = fid[famm.ToList().IndexOf(famm.Max())],
fname = d.CheckedFood(" or fID= " + fid[famm.ToList().IndexOf(famm.Max())]).Rows[0][0].ToString(),
fcount = famm.Max()
};
fclist.AddFC(fc);
fid.RemoveAt(famm.ToList().IndexOf(famm.Max()));
famm.RemoveAt(famm.ToList().IndexOf(famm.Max()));
FoodCount fc1 = new FoodCount()
{
fid = fid[famm.ToList().IndexOf(famm.Max())],
fname = d.CheckedFood(" or fID= " + fid[famm.ToList().IndexOf(famm.Max())]).Rows[0][0].ToString(),
fcount = famm.Max()
};
fclist.AddFC(fc1);
fid.RemoveAt(famm.ToList().IndexOf(famm.Max()));
famm.RemoveAt(famm.ToList().IndexOf(famm.Max()));
FoodCount fc2 = new FoodCount()
{
fid = fid[famm.ToList().IndexOf(famm.Max())],
fname = d.CheckedFood(" or fID= " + fid[famm.ToList().IndexOf(famm.Max())]).Rows[0][0].ToString(),
fcount = famm.Max()
};
fclist.AddFC(fc2);
fid.RemoveAt(famm.ToList().IndexOf(famm.Max()));
famm.RemoveAt(famm.ToList().IndexOf(famm.Max()));
FoodCount fc3 = new FoodCount()
{
fid = fid[famm.ToList().IndexOf(famm.Max())],
fname = d.CheckedFood(" or fID= " + fid[famm.ToList().IndexOf(famm.Max())]).Rows[0][0].ToString(),
fcount = famm.Max()
};
fclist.AddFC(fc3);
fid.RemoveAt(famm.ToList().IndexOf(famm.Max()));
famm.RemoveAt(famm.ToList().IndexOf(famm.Max()));
return(fclist.getFCList());
}
