private void LoadMilkCollections()
{
DateTime date = dtDateSearch.Value;
string criteria = txtSearch.Text;
IEnumerable <MilkCollectionModel> records;
MilkCollectionSummaryModel summary;
try
{
if (radioByDate.Checked)
{
records = milkCollectionLogic.GetAllRecordsByDate(date, criteria);
}
else
{
records = milkCollectionLogic.GetAllRecordsByMonth(date, criteria);
}
int count = 0;
gridList.Rows.Clear();
foreach (var item in records)
{
count++;
gridList.Rows.Add(new string[] {
item.ID.ToString(),
count.ToString(),
item.ActualDate.ToShortDateString(),
item.MilkClass,
item.FullName,
item.Volume.ToString(),
item.Amount.ToString()
});
}
//Shows summary of the list
if (radioByDate.Checked)
{
summary = milkCollectionLogic.GetMilkProductSummaryDate(date);
}
else
{
summary = milkCollectionLogic.GetMilkProductSummaryMonth(date);
}
gridList.Rows.Add(new string[] { "", "", "", "", "Summary Per Day", "Total Volume", "Total Amount" });
foreach (var item in summary.MilkProductSubTotalModels)
{
var subTotalAmount = item.MilkAmountSubTotal;
var subTotalVolume = item.MilkVolumeSubTotal;
gridList.Rows.Add(new string[] {
"",
"",
"",
"",
item.MilkClass,
subTotalVolume.ToString(),
subTotalAmount.ToString(),
});
}
gridList.Rows.Add(new string[] {
"",
"",
"",
"",
"Total",
summary.MilkVolumeTotal.ToString(),
summary.MilkAmountTotal.ToString(),
});
}
catch (Exception)
{
throw;
}
}
