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; }