private void GenerationExcelButton_Click(object sender, RoutedEventArgs e)
{
RfidContext db = new RfidContext();
string path;
if (string.IsNullOrEmpty(Singelton.ExcelSetting.Path))
{
MessageBox.Show(Application.Current.Resources["msb_floderNotSelected"].ToString(), "Error", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
else
{
path = Singelton.ExcelSetting.Path + System.IO.Path.DirectorySeparatorChar +
DateTime.Now.ToString("yyyy_MM_dd_HH_mm_ss") + ".xlsx";
}
List <TimeTableItem> TimeTable = null;
List <UserTableItem> UserTable = UserTableItem.GenerateList(_gridBasicInformation);
if (_gridBasicInformation.SelectedIndex != -1)
{
TimeTable = TimeTableItem.GenerateList(_gridMonthlyReport);
}
List <DepartmentTableItem> DepartmentTable = DepartmentTableItem.GenerateList(_gridDepartamentReport);
CreateExcelFileHelper.CreateExcelDocument(UserTable, TimeTable, DepartmentTable, path);
}
private void SaveBtn_Click(object sender, RoutedEventArgs e)
{
List <StatisticItem> StatisticItems = StisticFormatHelper
.StatisticItemFactory(_rep.Observes);
SaveFileDialog dialog = new SaveFileDialog();
dialog.InitialDirectory = App.Setting.PathToFolderFiles + @"\Config";
dialog.Filter = "Файл Excel|*.xlsx";
dialog.Title = "Сохранить таблицу Excel";
if (dialog.ShowDialog() == DialogResult.OK)
{
CreateExcelFileHelper.CreateExcelDocument(StatisticItems, dialog.FileName);
}
}
