public List <MemberWithMeal> GetMeal(int memberId, string date)
{
connection = new SqlConnection(connectionString);
connection.Open();
query = "select Meal.Date,Meal.MemberId,Meal.TotalMeal,Members.Name from Meal join Members on Meal.MemberId=Members.MemberId AND Meal.MemberId='" + memberId + "' AND MONTH(Meal.date)='" + date + "'";
command = new SqlCommand(query, connection);
reader = command.ExecuteReader();
List <MemberWithMeal> meals = new List <MemberWithMeal>();
while (reader.Read())
{
MemberWithMeal aMember = new MemberWithMeal();
aMember.MemberId = (int)reader["MemberId"];
aMember.MemberName = reader["Name"].ToString();
aMember.TotalMeal = Convert.ToDouble(reader["TotalMeal"]);
aMember.Date = (DateTime)reader["Date"];
meals.Add(aMember);
}
reader.Close();
connection.Close();
return(meals);
}
private void mealListView_MouseDoubleClick(object sender, MouseEventArgs e)
{
ListViewItem mealListSelected = mealListView.SelectedItems[0];
MemberWithMeal memberWithMeal = (MemberWithMeal)mealListSelected.Tag;
nameComboBox.Text = memberWithMeal.MemberName;
mealDateTimePicker.Text = memberWithMeal.Date.ToString();
totalMealTextBox.Text = memberWithMeal.TotalMeal.ToString();
hiddenIdLabel.Text = memberWithMeal.MemberId.ToString();
saveButton.Text = "Update";
removeButton.Enabled = true;
}
