private async Task <int> MigratePractices()
{
List <Practice> records = sqlDataContext.Practices.ToList();
PracticeRepository repository = new PracticeRepository();
int recCount = 0;
try
{
postgressDataContext = new Agilisium.TalentManager.PostgresModel.TalentManagerDataContext();
// delete all existing records from Postgres Database
postgressDataContext.Practices.RemoveRange(postgressDataContext.Practices);
await postgressDataContext.SaveChangesAsync();
// Migrage SQL Server data into Postgress database
foreach (Practice rec in records)
{
postgressDataContext.Practices.Add(rec);
}
await postgressDataContext.SaveChangesAsync();
//await UpdatePractices();
recCount = records.Count;
}
catch (Exception exp)
{
MessageBox.Show($"Error while migrating PODs. The error is {Environment.NewLine}Main Exception: {exp.Message}{Environment.NewLine}Inner Exception: {exp.InnerException?.Message}");
}
return(recCount);
}
private async Task <int> MigrateSystemSettings()
{
List <SystemSetting> records = sqlDataContext.SystemSettings.ToList();
SystemSettingRepository repository = new SystemSettingRepository();
int recCount = 0;
try
{
// delete all existing records from Postgres Database
postgressDataContext.SystemSettings.RemoveRange(postgressDataContext.SystemSettings);
await postgressDataContext.SaveChangesAsync();
// Migrage SQL Server data into Postgress database
foreach (SystemSetting rec in records)
{
postgressDataContext.SystemSettings.Add(rec);
}
await postgressDataContext.SaveChangesAsync();
//await UpdateSystemSettings();
recCount = records.Count;
}
catch (Exception exp)
{
MessageBox.Show($"Error while migrating System Settings. The error is {Environment.NewLine}Main Exception: {exp.Message}{Environment.NewLine}Inner Exception: {exp.InnerException?.Message}");
}
return(recCount);
}