private void filteredDataInDataGridView(int memberId)
{
aMemberInformationBll = new MemberInformationBLL();
List<MemberInformation> aList = aMemberInformationBll.getAllMemberInformation();
List<MemberInformation> newList = new List<MemberInformation>();
foreach (var memberInformation in aList)
{
if (memberInformation.memberId == memberId)
{
newList.Add(memberInformation);
}
}
memberInformationDataGridView.AutoGenerateColumns = false;
memberInformationDataGridView.DataSource = newList;
memberInformationDataGridView.Columns[1].DataPropertyName = "memberId";
memberInformationDataGridView.Columns[2].DataPropertyName = "borderName";
memberInformationDataGridView.Columns[3].DataPropertyName = "roomNo";
memberInformationDataGridView.Columns[4].DataPropertyName = "noOfMeals";
memberInformationDataGridView.Columns[5].DataPropertyName = "balance";
//Autogeneration of the id column starts here
int i = 1;
foreach (DataGridViewRow row in memberInformationDataGridView.Rows)
{
row.Cells["SNO"].Value = i;
i++;
}
//autogeneration code ends here
}
private void BorderMealInfoUI_Load(object sender, System.EventArgs e)
{
aMemberInformationBll = new MemberInformationBLL();
showDataInDataGridView();
totalBazarCostLabel.Text = aMemberInformationBll.totalBazarCost().ToString();
totalNoOfMealsLabel.Text = aMemberInformationBll.totalNoOfMeals.ToString();
perMealCostLabel.Text = aMemberInformationBll.perMealCost.ToString();
}
private void showDataInDataGridView()
{
aMemberInformationBll = new MemberInformationBLL();
memberInformationDataGridView.AutoGenerateColumns = false;
List<MemberInformation> aList = aMemberInformationBll.getAllMemberInformation();
memberInformationDataGridView.DataSource = aList;
memberInformationDataGridView.Columns[1].DataPropertyName = "memberId";
memberInformationDataGridView.Columns[2].DataPropertyName = "borderName";
memberInformationDataGridView.Columns[3].DataPropertyName = "roomNo";
memberInformationDataGridView.Columns[4].DataPropertyName = "noOfMeals";
memberInformationDataGridView.Columns[5].DataPropertyName = "balance";
memberInformationDataGridView.Columns[6].DataPropertyName = "individualMealCost";
memberInformationDataGridView.Columns[7].DataPropertyName = "amountToBeGiven";
memberInformationDataGridView.Columns[8].DataPropertyName = "amountToBePaid";
//Autogeneration of the id column starts here
int i = 1;
foreach (DataGridViewRow row in memberInformationDataGridView.Rows)
{
row.Cells["SNO"].Value = i;
i++;
}
//autogeneration code ends here
}