public List <MemberWithShoping> GetShopingList(string date) { connection = new SqlConnection(connectionString); connection.Open(); query = "SELECT Shoping.ShopingId,Shoping.Cost, CONVERT(date, Shoping.Date) as Date , Shoping.MemberId,Members.Name FROM Shoping join Members on Members.MemberId=Shoping.MemberId where MONTH(date)='" + date + "' order by Shoping.Date"; command = new SqlCommand(query, connection); reader = command.ExecuteReader(); List <MemberWithShoping> shopingList = new List <MemberWithShoping>(); while (reader.Read()) { MemberWithShoping memberWithShoping = new MemberWithShoping(); memberWithShoping.ShopingId = (int)reader["ShopingId"]; memberWithShoping.Cost = (int)reader["Cost"]; memberWithShoping.Date = (DateTime)reader["Date"]; memberWithShoping.MemberId = (int)reader["MemberId"]; memberWithShoping.MemberName = (string)reader["Name"]; shopingList.Add(memberWithShoping); } reader.Close(); connection.Close(); return(shopingList); }
private void shopingListView_MouseDoubleClick(object sender, MouseEventArgs e) { ListViewItem shopingListSelected = shopingListView.SelectedItems[0]; MemberWithShoping memberWithShoping = (MemberWithShoping)shopingListSelected.Tag; nameComboBox.Text = memberWithShoping.MemberName; shopingDateTimePicker.Text = memberWithShoping.Date.ToString(); costTextBox.Text = memberWithShoping.Cost.ToString(); saveButton.Text = "Update"; removeButton.Enabled = true; }