public void AddRecipient(string address)
{
string error;
if (!MSExchangeProvider.CheckEmailAddress(address, out error))
{
MetroMessageBox.Show(error, "Invalid Email Address", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
OrderEmailRecipient recipient = new OrderEmailRecipient();
recipient.Address = address;
recipient.Order = Order;
_db.OrderEmailRecipients.Add(recipient);
_db.SaveChanges();
Recipients.Add(recipient);
InputAddress = string.Empty;
}
private void ApplyMigrations()
{
using (DBArchive db = new DBArchive())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
var db_version = db.Database.SqlQuery <int>("PRAGMA user_version").First();
foreach (var f in Directory.GetFiles("UpgradeScripts/", "*.sql").OrderBy(f => Int32.Parse(Regex.Match(f, @"\d+").Value)))
{
if (!int.TryParse(Path.GetFileName(f).Split('_').First(), out int scriptVersion))
{
continue;
}
if (db_version >= scriptVersion)
{
continue;
}
db.Database.ExecuteSqlCommand(File.ReadAllText(f));
db.SaveChanges();
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
MetroMessageBox.Show($"Error upgrading the database.\nException: {ex.Message}", "Fatal Error", MessageBoxButton.OK, MessageBoxImage.Error);
Environment.Exit(2);
}
}
}
}
private bool CompileEATable()
{
bool result = false;
if (stopImport)
{
return(result);
}
StatusChanged("Importing Expense Account files...");
try
{
IEnumerable <DataRow> expenses = dtExpenseReview.Rows.Cast <DataRow>();
foreach (FileInfo file in new DirectoryInfo(_sourceEAPath).GetFiles("*.pdf", SearchOption.AllDirectories))
{
if (stopImport)
{
break;
}
ExpenseAccountEVM ea = null;
try
{
ea = FDLManager.ImportEAFromFile(file.FullName, false, false, true);
if (ea != null)
{
File.Copy(file.FullName, Path.Combine(ApplicationSettings.Directories.ExpenseAccount, file.Name), true);
using (DBArchive db = new DBArchive())
{
// we must override recived EA with the same of current dbcontext istance
ExpenseAccount currentEA = db.ExpenseAccounts.SingleOrDefault(e => e.Id == ea.Id);
if (currentEA != null)
{
FDL fdl = db.FDLs.SingleOrDefault(f => f.Id == currentEA.FDL);
if (fdl != null)
{
currentEA.Status = fdl.Status;
}
else
{
currentEA.Status = (long)EFDLStatus.Accepted;
}
var expense = expenses.SingleOrDefault(e => !string.IsNullOrEmpty(e.Field <string>("Dbf_Foglio")) && FormatFDL(e.Field <string>("Dbf_Foglio")) == fdl.Id);
currentEA.IsRefunded = expense != null && expense.Field <bool>("Dbf_Restituito");
if (currentEA.Status != (long)EFDLStatus.New)
{
currentEA.IsReadOnly = true;
}
db.ExpenseAccounts.AddOrUpdate(currentEA);
db.SaveChanges();
Message($"Expense Account {currentEA.FDL} OK");
}
else
{
Error("Missing EA on database. Should never happen.");
}
}
}
else
{
Error($"Failed to import EA from file: {file.FullName}");
}
}
catch (Exception ex)
{
Error($"Failed importing EA {ea?.FDL}. {ex}", ex);
}
}
result = true;
}
catch (Exception ex)
{
Error($"Failed importing expense accounts. {ex}", ex);
}
return(result);
}
private bool CompileFdlTable()
{
bool result = false;
if (stopImport)
{
return(result);
}
StatusChanged("Importing PDF files...");
try
{
IEnumerable <DataRow> sentFiles = dtSentFiles.Rows.Cast <DataRow>();
foreach (FileInfo file in new DirectoryInfo(_sourceFdlPath).GetFiles("*.pdf", SearchOption.AllDirectories))
{
if (stopImport)
{
break;
}
FDLEVM fdl = null;
try
{
fdl = FDLManager.ImportFDLFromFile(file.FullName, false, false, false, true, true);
// try with XFA format
if (fdl == null)
{
fdl = FDLManager.ImportFDLFromFile(file.FullName, true, false, false, true, true);
}
if (fdl != null)
{
File.Copy(file.FullName, Path.Combine(ApplicationSettings.Directories.FDL, file.Name), true);
DataRow sent = sentFiles.Where(f => !string.IsNullOrEmpty(f.Field <string>("Dbf_Foglio")) && FormatFDL(f.Field <string>("Dbf_Foglio")) == fdl.Id && (f.Field <int>("dbf_TipoInvio") == 2 || f.Field <int>("dbf_TipoInvio") == 4)).Select(f => f)
.OrderBy(x => x.Field <int>("Dbf_NumeroInviiPrima") == 0)
.ThenBy(x => string.IsNullOrEmpty(x.Field <string>("Dbf_Impianto")))
.ThenBy(x => string.IsNullOrEmpty(x.Field <string>("Dbf_Commessa")))
.FirstOrDefault();
if (sent != null)
{
using (DBArchive db = new DBArchive())
{
// we must override recived fdl with the same of current dbcontext istance
FDL currentFdl = db.FDLs.SingleOrDefault(f => f.Id == fdl.Id);
if (currentFdl != null)
{
if (sent.Field <int>("Dbf_NumeroInviiPrima") == 0)
{
currentFdl.Status = (long)EFDLStatus.Waiting;
}
else if (sent.Field <string>("Dbf_Impianto") != string.Empty && sent.Field <string>("Dbf_Commessa") != string.Empty)
{
currentFdl.Status = (long)EFDLStatus.Accepted;
}
else
{
currentFdl.Status = (long)EFDLStatus.Cancelled;
}
if (currentFdl.Status != (long)EFDLStatus.New)
{
currentFdl.IsReadOnly = true;
}
db.FDLs.AddOrUpdate(currentFdl);
db.SaveChanges();
Message($"FDL {currentFdl.Id} OK");
}
else
{
Error("Missing FDL on database. Should never happen.");
}
}
}
else
{
Error("Missing FDL sent status!");
}
}
else
{
Error($"Failed to import FDL from file: {file.FullName}");
}
}
catch (Exception ex)
{
Error($"Failed importing FDL {fdl?.Id}. {ex}", ex);
}
}
result = true;
}
catch (Exception ex)
{
Error($"Failed importing FDLs. {ex}", ex);
}
return(result);
}
private bool CompileHourTable()
{
bool result = false;
if (stopImport)
{
return(result);
}
StatusChanged("Importing Hours...");
try
{
using (DBArchive db = new DBArchive())
{
//Get enumerable rows fron datatable
IEnumerable <DataRow> collection = dtHours.Rows.Cast <DataRow>();
foreach (DataRow r in collection)
{
if (stopImport)
{
break;
}
DayEVM d = new DayEVM();
try
{
d.Timestamp = r.Field <DateTime>("Dbf_Data").ToUnixTimestamp();
d.Type = r.Field <byte>("dbf_Tipo_Giorno");
if (d.Type != 3 && d.Type != 6)
{
d.Type = 0;
}
else if (d.Type == 3)
{
d.Type = 1;
}
else if (d.Type == 6)
{
d.Type = 2;
}
d.Save(db);
//t = new Timesheet();
long timestamp = r.Field <DateTime>("Dbf_Data").ToUnixTimestamp();
//Add office hours
if (
r.Field <Int16>("Dbf_Uff_Inizio_AM") != 0 |
r.Field <Int16>("Dbf_Uff_Fine_AM") != 0 |
r.Field <Int16>("Dbf_Uff_Inizio_PM") != 0 |
r.Field <Int16>("Dbf_Uff_Fine_PM") != 0)
{
TimesheetEVM office = new TimesheetEVM();
office.Timestamp = timestamp;
office.TravelStartTimeAM = null;
office.WorkStartTimeAM = r.Field <Int16>("Dbf_Uff_Inizio_AM") > 0 ? (long?)TimeSpan.FromMinutes(r.Field <Int16>("Dbf_Uff_Inizio_AM")).TotalSeconds : null;
office.WorkEndTimeAM = r.Field <Int16>("Dbf_Uff_Fine_AM") > 0 ? (long?)TimeSpan.FromMinutes(r.Field <Int16>("Dbf_Uff_Fine_AM")).TotalSeconds : null;
office.TravelEndTimeAM = null;
office.TravelStartTimePM = null;
office.WorkStartTimePM = r.Field <Int16>("Dbf_Uff_Inizio_PM") > 0 ? (long?)TimeSpan.FromMinutes(r.Field <Int16>("Dbf_Uff_Inizio_PM")).TotalSeconds : null;
office.WorkEndTimePM = r.Field <Int16>("Dbf_Uff_Fine_PM") > 0 ? (long?)TimeSpan.FromMinutes(r.Field <Int16>("Dbf_Uff_Fine_PM")).TotalSeconds : null;
office.TravelEndTimePM = null;
if (db.Timesheets.Where(x => x.Timestamp == office.Timestamp && office.FDL == string.Empty).Count() == 0)
{
office.Save(db);
}
}
// Factory association
short? factoryId = r.Field <short?>("Dbf_Impianto");
string fdlId = FormatFDL(r.Field <string>("Dbf_Foglio"));
if (factoryId.HasValue && _factories.ContainsKey(factoryId.Value) && !string.IsNullOrEmpty(fdlId))
{
FDL fdl = db.FDLs.SingleOrDefault(f => f.Id == fdlId);
if (fdl != null)
{
if (!fdl.Factory.HasValue)
{
fdl.Factory = _factories[factoryId.Value];
db.FDLs.AddOrUpdate(fdl);
db.SaveChanges();
}
}
else
{
Warning($"The FDL {fdlId} is missing on database. Impossible to assign the factory to the current timesheet. Day: {d.Date.ToShortDateString()}");
}
}
short? factory2Id = r.Field <short?>("Dbf_SecondoImpianto");
string fdl2Id = FormatFDL(r.Field <string>("Dbf_SecondoFoglio"));
if (factory2Id.HasValue && _factories.ContainsKey(factory2Id.Value) && !string.IsNullOrEmpty(fdl2Id))
{
FDL fdl = db.FDLs.SingleOrDefault(f => f.Id == fdl2Id);
if (fdl != null && !fdl.Factory.HasValue)
{
fdl.Factory = _factories[factory2Id.Value];
db.FDLs.AddOrUpdate(fdl);
db.SaveChanges();
}
else
{
Warning($"The second FDL {fdlId} is missing on database. Impossible to assign the factory to the current timesheet. Day: {d.Date.ToShortDateString()}");
}
}
Message($"Day {d.Date.ToShortDateString()} OK");
}
catch (Exception ex)
{
Error($"Failed to import the Timesheet {d.Date.ToShortDateString()}. {ex}", ex);
}
}
db.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
Error($"Failed importing the timesheets. {ex}", ex);
}
return(result);
}
private bool CompileCarRents()
{
bool result = false;
IDictionary <string, long> _cars = new Dictionary <string, long>();
if (stopImport)
{
return(result);
}
StatusChanged("Importing Car Rents...");
try
{
using (DBArchive db = new DBArchive())
{
//Get enumerable rows fron datatable
IEnumerable <DataRow> collection = dtCars.Rows.Cast <DataRow>();
var cars = collection.GroupBy(c => c.Field <string>("dbf_Targa")).Select(c => c.First());
// Import Cars
foreach (DataRow r in cars)
{
if (stopImport)
{
break;
}
Car car = new Car();
try
{
car.LicensePlate = r.Field <string>("dbf_Targa").Trim();
car.Brand = r.Field <string>("dbf_Marca").Trim();
car.Model = r.Field <string>("dbf_Modello").Trim();
car.CarRentalCompany = r.Field <short>("dbf_Nolo");
db.Cars.AddOrUpdate(x => x.LicensePlate, car);
db.SaveChanges();
_cars.Add(r.Field <string>("dbf_Targa"), car.Id);
Message($"Car {car.LicensePlate} | {car.Brand} {car.Model} OK");
}
catch (Exception ex)
{
Error($"Failed to import the car {car.LicensePlate}. {ex}", ex);
}
}
// Import Rents
foreach (DataRow r in collection)
{
if (stopImport)
{
break;
}
string licensePlate = r.Field <string>("dbf_Targa");
if (_cars.ContainsKey(licensePlate))
{
CarRentalHistory his = new CarRentalHistory();
try
{
his.Car = _cars[licensePlate];
his.StartKm = r.Field <int>("dbf_KmInizio");
his.EndKm = r.Field <int>("dbf_KmFine");
his.StartLocation = r.Field <string>("dbf_LuogoPrel").Trim();
his.EndLocation = r.Field <string>("dbf_LuogoDepo").Trim();
his.StartDate = (r.Field <DateTime>("dbf_DataPrel") + r.Field <DateTime>("dbf_OraPrel").TimeOfDay).ToUnixTimestamp();
his.EndDate = (r.Field <DateTime>("dbf_DataDepo") + r.Field <DateTime>("dbf_OraDepo").TimeOfDay).ToUnixTimestamp();
his.StartFuelLevel = r.Field <short>("dbf_SerbPrel");
his.EndFuelLevel = r.Field <short>("dbf_SerbRicon");
his.Notes = r.Field <string>("dbf_Note").Trim();
db.CarRentalHistories.AddOrUpdate(x => x.StartDate, his);
Message($"Rent {DateTime.Now.FromUnixTimestamp(his.StartDate).ToShortDateString()} Car {licensePlate} OK");
}
catch (Exception ex)
{
Error($"Failed to import the rent in date {DateTime.Now.FromUnixTimestamp(his.StartDate).ToShortDateString()}, Car {licensePlate}. {ex}", ex);
}
}
}
db.SaveChanges();
}
}
catch (Exception ex)
{
Error($"Failed importing car rents. {ex}", ex);
}
return(result);
}
private bool ImportEAFiles()
{
bool result = false;
if (stopImport)
{
return(result);
}
StatusChanged("Importing Expense Account files...");
try
{
foreach (FileInfo file in new DirectoryInfo(FDLFolder).GetFiles("*.pdf", SearchOption.AllDirectories))
{
if (stopImport)
{
break;
}
if (FDLManager.GetFileType(file.Name) != EFileType.ExpenseAccount)
{
continue;
}
ExpenseAccountEVM ea = null;
try
{
ea = FDLManager.ImportEAFromFile(file.FullName, false, false, true);
if (ea != null)
{
File.Copy(file.FullName, Path.Combine(ApplicationSettings.Directories.ExpenseAccount, file.Name), true);
using (DBArchive db = new DBArchive())
{
// we must override recived EA with the same of current dbcontext istance
ExpenseAccount currentEA = db.ExpenseAccounts.SingleOrDefault(e => e.Id == ea.Id);
if (currentEA != null)
{
currentEA.Status = currentEA.FDL1.Status;
if (currentEA.Status == (long)EFDLStatus.Accepted)
{
currentEA.IsRefunded = true;
}
db.ExpenseAccounts.AddOrUpdate(currentEA);
db.SaveChanges();
}
else
{
Error("Missing EA on database. Should never happen.");
}
}
Message($"Expense Account {ea.FDL} OK");
}
else
{
Error($"Failed to import EA from file: {file.FullName}");
}
}
catch (Exception ex)
{
Error($"Failed importing EA {ea?.FDL}. {ex}", ex);
}
}
result = true;
}
catch (Exception ex)
{
Error($"Failed importing expense accounts. {ex}", ex);
}
return(result);
}
private bool ImportFDLFiles()
{
bool result = false;
if (stopImport)
{
return(result);
}
StatusChanged("Importing FDL files...");
try
{
foreach (FileInfo file in new DirectoryInfo(FDLFolder).GetFiles("*.pdf", SearchOption.AllDirectories))
{
if (stopImport)
{
break;
}
if (FDLManager.GetFileType(file.Name) != EFileType.FDL)
{
continue;
}
FDLEVM fdl = null;
try
{
fdl = FDLManager.ImportFDLFromFile(file.FullName, false, false, false, false, true);
// try with XFA format
if (fdl == null)
{
fdl = FDLManager.ImportFDLFromFile(file.FullName, true, false, false, false, false);
}
if (fdl != null)
{
File.Copy(file.FullName, Path.Combine(ApplicationSettings.Directories.FDL, file.Name), true);
using (DBArchive db = new DBArchive())
{
// we must override recived fdl with the same of current dbcontext istance
FDL currentFdl = db.FDLs.SingleOrDefault(f => f.Id == fdl.Id);
if (currentFdl != null)
{
if (currentFdl.WeekNr < DateTime.Now.WeekNr())
{
currentFdl.Status = (long)EFDLStatus.Accepted;
db.FDLs.AddOrUpdate(currentFdl);
db.SaveChanges();
}
}
else
{
Error("Missing FDL on database. Should never happen.");
}
}
Message($"FDL {fdl.Id} OK");
}
else
{
Error($"Failed to import FDL from file: {file.FullName}");
}
}
catch (Exception ex)
{
Error($"Failed importing FDL {fdl?.Id}. {ex}", ex);
}
}
result = true;
}
catch (Exception ex)
{
Error($"Failed importing FDLs. {ex}", ex);
}
return(result);
}
private bool CompileFactoriesTable()
{
bool result = false;
if (stopImport)
return result;
StatusChanged("Importing Factories...");
try
{
using (DBArchive db = new DBArchive())
{
//Get enumerable rows fron datatable
IEnumerable<DataRow> collection = dtPlants.Rows.Cast<DataRow>();
foreach (DataRow r in collection)
{
if (stopImport)
break;
string FactoryName = r.Field<string>("dbf_Stabilimento");
FactoryEVM factory = db.Factories.Where(f => f.Name == FactoryName).ToList().Select(f => new FactoryEVM(f)).FirstOrDefault();
if (factory == null)
factory = new FactoryEVM();
try
{
factory.Name = FactoryName;
factory.CompanyName = r.Field<string>("dbf_RagioneSociale");
factory.Address = r.Field<string>("dbf_Indirizzo");
//factory.IsForfait = r.Field<bool>("dbf_Forfettario"); DEPRECATED
long transferType = r.Field<byte>("dbf_Tipo_Trasf");
factory.TransferType = transferType != 4 ? transferType : 0;
factory.Save(db);
_factories.Add(r.Field<int>("dbf_Index"), factory.Id);
Message($"Factory {factory.Name} OK");
}
catch (Exception ex)
{
Error($"Failed to import factory {factory.Name}. {ex}", ex);
}
}
db.SaveChanges();
result = true;
}
}
catch (Exception ex)
{
result = false;
Error($"Failed importing factories. {ex}", ex);
}
return result;
}