public ViewLicenses()
{
InitializeComponent();
LicenserContext db = new LicenserContext();
dataGrid.ItemsSource = db.Licenses.ToList();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (txtCompanyName.Text.Length <= 0)
{
var result = System.Windows.MessageBox.Show("Please enter a company name.", "Company Name Required", MessageBoxButton.OK);
return;
}
if (txtTotalLicenseCount.Text.Length <= 0 || txtTotalLicenseCount.Value <= 0)
{
var result = System.Windows.MessageBox.Show("Please enter a license count greater than zero.", "License Count Required", MessageBoxButton.OK);
return;
}
if (cbTypeOfLicense.SelectedIndex < 0)
{
var result = System.Windows.MessageBox.Show("Please select a license type.", "License Type Required", MessageBoxButton.OK);
return;
}
if (dateLicenseIssueDate.SelectedDate == null)
{
var result = System.Windows.MessageBox.Show("Please select a valid issue date.", "License Issue Date Required", MessageBoxButton.OK);
return;
}
if (dateLicenseExpirationDate.SelectedDate == null)
{
var result = System.Windows.MessageBox.Show("Please selected a valid expiration date.", "License Expiration Date Required", MessageBoxButton.OK);
return;
}
if (dateLicenseIssueDate.SelectedDate >= dateLicenseExpirationDate.SelectedDate)
{
var result = System.Windows.MessageBox.Show("Expiration date must occur after issue date.", "Invalid Date Selections", MessageBoxButton.OK);
return;
}
//prep our encrtyped string
SimpleAES encryptText = new SimpleAES("V&WWJ3d39brdR5yUh5(JQGHbi:FB@$^@", "W4aRWS!D$kgD8Xz@");
LicenserContext db = new LicenserContext();
License newLicense = new License
{
CompanyName = txtCompanyName.Text,
TotalLicenseCount = Convert.ToInt32(txtTotalLicenseCount.Text),
TypeOfLicense = ((ComboBoxItem)cbTypeOfLicense.SelectedItem).Content.ToString(),
LicenseIssueDate = (DateTime)dateLicenseIssueDate.SelectedDate,
LicenseExpirationDate = (DateTime)dateLicenseExpirationDate.SelectedDate,
LicenseEncodedString = encryptText.EncryptToString(txtCompanyName.Text + ";" + txtTotalLicenseCount.Text + ";" +
((ComboBoxItem)cbTypeOfLicense.SelectedItem).Content.ToString() + ";" + dateLicenseIssueDate.SelectedDate.ToString() + ";" +
dateLicenseExpirationDate.SelectedDate.ToString())
};
db.Licenses.Add(newLicense);
db.SaveChanges();
ContentControl contentArea = (ContentControl)this.Parent;
contentArea.Content = new ViewLicenses();
}
private void ExportLicenseMenuItem_Click(object sender, RoutedEventArgs e)
{
LicenserContext db = new LicenserContext();
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "Excel Files (*.xlsx)|*.xlsx";
saveFileDialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
if (saveFileDialog.ShowDialog() == true)
{
var newFile = new FileInfo(saveFileDialog.FileName);
using (ExcelPackage package = new ExcelPackage(newFile))
{
ExcelWorksheet ws = package.Workbook.Worksheets.Add("Licenses");
ws.Cells["A1"].LoadFromCollection <License>(db.Licenses.AsEnumerable <License>(), true, OfficeOpenXml.Table.TableStyles.Light8);
package.Save();
}
}
}