private void LoadNewsletters_button_Click(object sender, RoutedEventArgs e) { DataSet dataset = ShowingsClass.getAllShowingsPastCurrentDate(); foreach (DataRow row in dataset.Tables[0].Rows) { this.Newsletters_txt.Text = this.Newsletters_txt.Text + row["Name"].ToString() + " " + row["Date"].ToString() + "\n"; } }
private void Generate2_button_Click(object sender, RoutedEventArgs e) { DataSet dataSet = ShowingsClass.getAllShowingsPastCurrentDate(); this.Report_txt.ItemsSource = dataSet.Tables[0].DefaultView; this.Report_txt.Columns[0].Visibility = Visibility.Collapsed; this.Report_txt.Columns[1].Visibility = Visibility.Collapsed; this.Report_txt.Columns[6].Visibility = Visibility.Collapsed; }
private void fillDatePicker(DatePicker pDatePicker) { pDatePicker.BlackoutDates.Clear(); pDatePicker.BlackoutDates.AddDatesInPast(); List <DateTime> dateList = new List <DateTime>(); DataSet dataSet = ShowingsClass.getAllShowingsPastCurrentDate(); foreach (DataRow row in dataSet.Tables[0].Rows) { dateList.Add(ShowingsClass.turnSqlLiteDateStringIntoDateTime(row["Date"].ToString())); } dateList.Sort(); if (dateList.Count == 0) { pDatePicker.BlackoutDates.Add(new CalendarDateRange(DateTime.Now, DateTime.Now.AddYears(1))); } else { DateTime startDate = DateTime.Now; for (int i = 0; i < dateList.Count; i++) { if (startDate.Date != dateList[i].Date) { pDatePicker.BlackoutDates.Add(new CalendarDateRange(startDate, dateList[i].AddDays(-1))); } startDate = dateList[i].AddDays(1); } pDatePicker.BlackoutDates.Add(new CalendarDateRange(startDate, startDate.AddMonths(12))); } //pDatePicker.BlackoutDates.Clear(); //pDatePicker.BlackoutDates.AddDatesInPast(); //List<DateTime> dateList = new List<DateTime>(); //DataSet dataSet = ShowingsClass.getAllShowings(); //foreach (DataRow row in dataSet.Tables[0].Rows) //{ // int tempShowingId = int.Parse(row["Showing_Id"].ToString()); // DateTime showingDate = ShowingsClass.turnSqlLiteDateStringIntoDateTime(row["Date"].ToString()); // if (showingDate >= DateTime.Now) // { // dateList.Add(showingDate); // } //} //dateList.Sort(); //if (dateList.Count != 0) //{ // DateTime nextStartDate = DateTime.Now; // bool addDate = true; // int count = 1; // foreach (DateTime showingDateFromList in dateList) // { // nextStartDate = showingDateFromList; // if (count < dateList.Count) // { // //nextStartDate = showingDateFromList; // if (showingDateFromList.AddDays(1).Date == dateList[count].Date) // { // //next date in list is for next day so do nothing // } // else // { // pDatePicker.BlackoutDates.Add(new CalendarDateRange(nextStartDate.AddDays(1), dateList[count].AddDays(-1))); // } // count = count + 1; // } // } // pDatePicker.BlackoutDates.Add(new CalendarDateRange(DateTime.Now, dateList[0].AddDays(-1))); // //pDatePicker.BlackoutDates.Add(new CalendarDateRange(dateList[dateList.Count - 1].AddDays(1), dateList[dateList.Count - 1].AddMonths(12))); // try // { // pDatePicker.BlackoutDates.Add(new CalendarDateRange(dateList[count - 1].AddDays(1), nextStartDate.AddYears(1))); // } // catch (Exception) // { // //pDatePicker.BlackoutDates.Add(new CalendarDateRange(dateList[count - 1].AddDays(1), nextStartDate.AddYears(1))); // pDatePicker.BlackoutDates.Add(new CalendarDateRange(nextStartDate.AddDays(1), nextStartDate.AddYears(1))); // } //} //else //{ // pDatePicker.BlackoutDates.Add(new CalendarDateRange(DateTime.Now, DateTime.Now.AddYears(500))); //} }