private void LoadMainGridList()
{
try
{
var criteria = txtSearch.Text;
var date = dtSearchDate.Value;
IEnumerable <ExpenseListModel> models;
if (radioByDate.Checked)
{
models = mainLogic.GetAllBy("date", date, criteria);
}
else
{
models = mainLogic.GetAllBy("month", date, criteria);
}
gridList.Rows.Clear();
int count = 0;
foreach (var item in models)
{
count++;
gridList.Rows.Add(new string[] { item.ID.ToString(), count.ToString(),
item.Date.ToShortDateString(),
item.Particular,
item.ExpenseTypeDescription,
item.UnitPrice.ToString(),
item.Quantity.ToString(),
item.Total.ToString() });
}
// use 0 id to avoid null exception while click edit button
//Adds space
gridList.Rows.Add(new string[] { "0" });
gridList.Rows.Add(new string[] { "0", "",
"Summaries",
"Description",
"Total", });
var summaryModels = mainLogic.GetAllSummary(date);
int summaryCount = 0;
foreach (var item in summaryModels)
{
summaryCount++;
gridList.Rows.Add(new string[] { "0", "",
"",
item.ExpenseTypeDescription,
item.Total.ToString(), });
}
}
catch (Exception)
{
throw;
}
}
