public HomeView()
{
InitializeComponent();
WhichDatabase();
RowNumbers rows = new RowNumbers(0, 500);
Application.Current.Resources["RowNumbers"] = rows;
}
protected override void Execute(CodeActivityContext context)
{
base.LoadVariables(context);
this.intRowNumber = RowNumbers.Get(context);
this.DoRowHide();
}
/// <summary>
/// fill a list of our custom varible for us to display to the user
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <returns>Returns the data to populate the table</returns>
private List <Json311> GetData(RowNumbers rows)
{
SqlConnect getConnection = new SqlConnect();
List <Json311> displayData;
Json311 retrieve = new Json311();
rows.total = getConnection.GetRows();
displayData = retrieve.GetFullDataset(rows.Curr_min, rows.rowsRemaining);
return(displayData);
}
public void SetDataContext()
{
RowNumbers rows = (RowNumbers)Application.Current.Resources["RowNumbers"];
List <Json311> data = this.GetData(rows);
DBDataBinding.ItemsSource = data;
Total.Text = rows.total.ToString();
Rows_min.Text = rows.Curr_min.ToString();
Rows_max.Text = rows.Curr_max.ToString();
Application.Current.Resources["RowNumbers"] = rows;
}
/// <summary>
/// gets the next set of records for the user to look through
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Next_click(object sender, RoutedEventArgs e)
{
RowNumbers rows = Application.Current.Resources["RowNumbers"] as RowNumbers;
bool update = rows.UpdateValuesUp();
if (update == true)
{
SetDataContext();
GC.Collect();
this.NavigationService.Refresh();
}
Application.Current.Resources["RowNumbers"] = rows;
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Display_dates(object sender, RoutedEventArgs e)
{
DateTime? start = Start.SelectedDate;
DateTime? end = Start.SelectedDate;
RowNumbers rows = Application.Current.Resources["RowNumbers"] as RowNumbers;
SqlConnect dbconnect = new SqlConnect();
Json311 get_data = new Json311();
List <Json311> show_data = new List <Json311>();
if (!start.HasValue)
{
MessageBox.Show("Select a date on the left");
}
else if (start.HasValue && !end.HasValue)
{
DateTime new_start = (DateTime)start;
int year = new_start.Year;
int month = new_start.Month;
int date = new_start.Day;
DateTime date1 = new DateTime(year, month, date, 0, 0, 0);
DateTime date2 = new DateTime(year, month, date, 23, 59, 59);
int num_rows = dbconnect.GetRows(date1, date2);
if (num_rows == 0)
{
MessageBox.Show("There are no values for the selected dates");
}
else
{
rows.filter_min = 0;
if (num_rows > 500)
{
rows.filter_max = 500;
}
else
{
rows.filter_max = num_rows;
}
rows.filter_total = num_rows;
rows.is_filter = true;
show_data = get_data.GetDateFilteredList(0, 0, date1, date2);
DBDataBinding.ItemsSource = show_data;
this.NavigationService.Refresh();
}
}
Application.Current.Resources["RowNumbers"] = rows;
}
