public static bool OpenReadExcelFile()
{
if (_fileInfo == null)
{
return(false);
}
using (FileStream fs = _fileInfo.OpenRead())
{
string ext = _fileInfo.Extension;
// для 2003 xls - Binary; 2007 xlsx - Xml
using (var xreader = ext == ".xls" ?
ExcelReaderFactory.CreateBinaryReader(fs) :
ExcelReaderFactory.CreateOpenXmlReader(fs))
{
_dset = null;
try
{
_dset = xreader.AsDataSet();
}
catch (Exception ex)
{
Inspection.CurrentException = ex;
Inspection.NotifyError(log, "Error processing xls-file");
return(false);
}
}
return(true);
}
}
private static void TransferEmployeeExecuted(object sender, ExecutedRoutedEventArgs e)
{
bool canTransfer = IsTransferPossible();
if (canTransfer)
{
CurrentEmployee.SetTransfer();
ActivateView("PageEmployeeDetails");
e.Handled = true;
}
else
{
var empl = CurrentEmployee;
Inspection.NotifyError(log, $"Transfer is not possible, probation period for '{empl}' is not over");
}
}
async private static void UpdateEmployeeExecuted(object sender, ExecutedRoutedEventArgs e)
{
Employee empl = CurrentEmployee.ApplyChanges();
if (empl.Id != 0)
{
bool isDone = await Data.UpdateEmployee(empl);
if (isDone)
{
CurrentEmployee.Wrap(empl);
CurrentEmployee.SetEdit();
Inspection.NotifySuccess(log, $"Employee {empl} Updated!");
}
else
{
Inspection.NotifyError(log, "Сan't update!");
}
}
e.Handled = true;
}
async private static void SaveEmployeeExecuted(object sender, ExecutedRoutedEventArgs e)
{
if (CurrentEmployee.Skill.Level > 2)
{
Inspection.NotifyError(log, "A new employee can not be assigned a level above 2!");
return;
}
Employee empl = CurrentEmployee.ApplyChanges();
if (empl.Id == 0)
{
if (IsDepartmentAlreadyFull(empl))
{
MessageBoxResult res =
MessageBox.Show("The Department is already full \r\n"
+ "Please, confirm the appointment of the employee as a Director",
"Warning",
MessageBoxButton.YesNo,
MessageBoxImage.Warning);
if (res == MessageBoxResult.No)
{
return;
}
}
bool isDone = await Data.AddEmployeeAsync(empl);
if (isDone)
{
CurrentEmployee.Wrap(empl);
CurrentEmployee.SetEdit();
Inspection.NotifySuccess(log, $"Employee {empl} Saved!");
}
else
{
Inspection.NotifyError(log, "Can't save!");
}
}
e.Handled = true;
}
