private void loanSchemeLoad(object sender, EventArgs e)
{
DatabaseAccessor databaseAccessor = new DatabaseAccessor();
var data = databaseAccessor.GetLoanSchema();
if (data.Count == 0)
{
MessageBox.Show("Please update the dbconfig file\nFormat: DSN=Enter your dsn", "Databse Error");
System.Diagnostics.Process.Start(@databaseAccessor.initialiseDb('w', ""));
System.Windows.Application.Current.Shutdown();
}
foreach (var scheme in data)
{
loanSchemeInput.Items.Add(scheme.Key);
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (loanSchemeInput.SelectedValue != null && toDateInput.SelectedDate != null && fromDateInput.SelectedDate != null)
{
loanScheme = loanSchemeInput.SelectedValue.ToString();
//.Split(' ')[0].Trim();
var toDate = toDateInput.SelectedDate ?? DateTime.Now;
var fromDate = fromDateInput.SelectedDate ?? DateTime.Now;
DatabaseAccessor databaseAccessor = new DatabaseAccessor();
var data = databaseAccessor.GetLoanSchema();
string category = "";
System.Diagnostics.Debug.WriteLine(data.TryGetValue(loanScheme, out category));
table = databaseAccessor.GetSmsTable(loanScheme.Split(' ')[0].Trim(), toDate.Date, fromDate.Date, category);
if (table.Count == 0)
{
smsTableOutput.ItemsSource = null;
smsTableOutput.Visibility = Visibility.Hidden;
smsButton.IsEnabled = false;
smsButton.Visibility = Visibility.Hidden;
MessageBox.Show("No users found in this list", "Info");
}
else
{
smsTableOutput.Visibility = Visibility.Visible;
smsTableOutput.ItemsSource = table;
smsButton.IsEnabled = true;
smsButton.Visibility = Visibility.Visible;
}
}
else
{
MessageBox.Show("One or more fields is empty", "Error");
}
}
