/// <summary>
/// Manual mapping function for vims_EarningsDiff
/// </summary>
/// <param name="manager"></param>
/// <param name="sourceDatabase"></param>
/// <param name="destinationDatabase"></param>
public override void Map(MappingManager manager, SourceDatabase sourceDatabase, DestinationDatabase destinationDatabase)
{
//
// Try to get source database name and destination database name
DbContext sourceDbContext = sourceDatabase.GetDbContext();
DbContext destDbContext = destinationDatabase.GetDbContext();
string sourceDatabaseName = sourceDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string destDatabaseName = destDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string tableName = "vims_EarningsDiff";
//
// Generate SQL script
string sqlQuery = @"INSERT INTO {DESTINATION_DATABASE_NAME}.dbo.vims_EarningsDiff(Pol_tran_id, BrRep_EarningWithAdj, Paid, Payable, Liability, Adjustment, BrRep_EarningWithoutAdj, pol_insured, gentrans_name, gencob_Name, short_payment_broker_rep_poriton)" + Environment.NewLine +
"SELECT Pol_tran_id, BrRep_EarningWithAdj, Paid, Payable, Liability, Adjustment, BrRep_EarningWithoutAdj, pol_insured, gentrans_name, gencob_Name, short_payment_broker_rep_poriton FROM {SOURCE_DATABASE_NAME}.dbo.vims_EarningsDiff" + Environment.NewLine;
sqlQuery = sqlQuery.Replace("{SOURCE_DATABASE_NAME}", sourceDatabaseName)
.Replace("{DESTINATION_DATABASE_NAME}", destDatabaseName);
//
// Exec SQL script or write to file
if (manager.IsGeneratedScript)
{
sqlQuery = "USE [" + destDatabaseName + "]" + Environment.NewLine +
"GO" + Environment.NewLine +
sqlQuery;
manager.WriteSQLScript(tableName, sqlQuery, false);
}
else
{
try
{
destDbContext.Database.ExecuteSqlCommand(sqlQuery);
}
catch (Exception excExecScript)
{
LogService.Log.Error("Can not run migration script for " + tableName, excExecScript);
}
}
}
/// <summary>
/// Manual mapping function for view_DofiReport_Table2
/// </summary>
/// <param name="manager"></param>
/// <param name="sourceDatabase"></param>
/// <param name="destinationDatabase"></param>
public override void Map(MappingManager manager, SourceDatabase sourceDatabase, DestinationDatabase destinationDatabase)
{
//
// Try to get source database name and destination database name
DbContext sourceDbContext = sourceDatabase.GetDbContext();
DbContext destDbContext = destinationDatabase.GetDbContext();
string sourceDatabaseName = sourceDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string destDatabaseName = destDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string tableName = "view_DofiReport_Table2";
//
// Generate SQL script
string sqlQuery = @"INSERT INTO {DESTINATION_DATABASE_NAME}.dbo.view_DofiReport_Table2(spid, gentrans_name, genins_parent_id, pol_tran_id, pol_posted_when, pol_date_effective, apracob_name, merged_base_premium, ent_name, limex_name, uficoco_code, extyp_name, merged_insurer_id, hvi_value)" + Environment.NewLine +
"SELECT spid, gentrans_name, genins_parent_id, pol_tran_id, pol_posted_when, pol_date_effective, apracob_name, merged_base_premium, ent_name, limex_name, uficoco_code, extyp_name, merged_insurer_id, hvi_value FROM {SOURCE_DATABASE_NAME}.dbo.view_DofiReport_Table2" + Environment.NewLine;
sqlQuery = sqlQuery.Replace("{SOURCE_DATABASE_NAME}", sourceDatabaseName)
.Replace("{DESTINATION_DATABASE_NAME}", destDatabaseName);
//
// Exec SQL script or write to file
if (manager.IsGeneratedScript)
{
sqlQuery = "USE [" + destDatabaseName + "]" + Environment.NewLine +
"GO" + Environment.NewLine +
sqlQuery;
manager.WriteSQLScript(tableName, sqlQuery, false);
}
else
{
try
{
destDbContext.Database.ExecuteSqlCommand(sqlQuery);
}
catch (Exception excExecScript)
{
LogService.Log.Error("Can not run migration script for " + tableName, excExecScript);
}
}
}
/// <summary>
/// Manual mapping function for period_renewals_particulars_t
/// </summary>
/// <param name="manager"></param>
/// <param name="sourceDatabase"></param>
/// <param name="destinationDatabase"></param>
public override void Map(MappingManager manager, SourceDatabase sourceDatabase, DestinationDatabase destinationDatabase)
{
//
// Try to get source database name and destination database name
DbContext sourceDbContext = sourceDatabase.GetDbContext();
DbContext destDbContext = destinationDatabase.GetDbContext();
string sourceDatabaseName = sourceDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string destDatabaseName = destDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string tableName = "period_renewals_particulars_t";
//
// Generate SQL script
string sqlQuery = @"INSERT INTO {DESTINATION_DATABASE_NAME}.dbo.period_renewals_particulars_t(prp_pol_parent_id, prp_pol_particulars, prp_pol_id, prp_pol_sum_insured, prp_spid)" + Environment.NewLine +
"SELECT prp_pol_parent_id, prp_pol_particulars, prp_pol_id, prp_pol_sum_insured, prp_spid FROM {SOURCE_DATABASE_NAME}.dbo.period_renewals_particulars_t" + Environment.NewLine;
sqlQuery = sqlQuery.Replace("{SOURCE_DATABASE_NAME}", sourceDatabaseName)
.Replace("{DESTINATION_DATABASE_NAME}", destDatabaseName);
//
// Exec SQL script or write to file
if (manager.IsGeneratedScript)
{
sqlQuery = "USE [" + destDatabaseName + "]" + Environment.NewLine +
"GO" + Environment.NewLine +
sqlQuery;
manager.WriteSQLScript(tableName, sqlQuery, false);
}
else
{
try
{
destDbContext.Database.ExecuteSqlCommand(sqlQuery);
}
catch (Exception excExecScript)
{
LogService.Log.Error("Can not run migration script for " + tableName, excExecScript);
}
}
}
/// <summary>
/// Manual mapping function for vims_unallocated_csh_credits
/// </summary>
/// <param name="manager"></param>
/// <param name="sourceDatabase"></param>
/// <param name="destinationDatabase"></param>
public override void Map(MappingManager manager, SourceDatabase sourceDatabase, DestinationDatabase destinationDatabase)
{
//
// Try to get source database name and destination database name
DbContext sourceDbContext = sourceDatabase.GetDbContext();
DbContext destDbContext = destinationDatabase.GetDbContext();
string sourceDatabaseName = sourceDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string destDatabaseName = destDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string tableName = "vims_unallocated_csh_credits";
//
// Generate SQL script
string sqlQuery = @"INSERT INTO {DESTINATION_DATABASE_NAME}.dbo.vims_unallocated_csh_credits(ent_id, insured_name, prof_sales_team, prof_service_team, insurer, sub_agent, bal_tran_id, tran_time, tran_type, particulars, bal_amount, sertea_name, saltea_name, insurer_name, sub_agent_name, spid)" + Environment.NewLine +
"SELECT ent_id, insured_name, prof_sales_team, prof_service_team, insurer, sub_agent, bal_tran_id, tran_time, tran_type, particulars, bal_amount, sertea_name, saltea_name, insurer_name, sub_agent_name, spid FROM {SOURCE_DATABASE_NAME}.dbo.vims_unallocated_csh_credits" + Environment.NewLine;
sqlQuery = sqlQuery.Replace("{SOURCE_DATABASE_NAME}", sourceDatabaseName)
.Replace("{DESTINATION_DATABASE_NAME}", destDatabaseName);
//
// Exec SQL script or write to file
if (manager.IsGeneratedScript)
{
sqlQuery = "USE [" + destDatabaseName + "]" + Environment.NewLine +
"GO" + Environment.NewLine +
sqlQuery;
manager.WriteSQLScript(tableName, sqlQuery, false);
}
else
{
try
{
destDbContext.Database.ExecuteSqlCommand(sqlQuery);
}
catch (Exception excExecScript)
{
LogService.Log.Error("Can not run migration script for " + tableName, excExecScript);
}
}
}
/// <summary>
/// Manual mapping function for view_DofiReport_Table1
/// </summary>
/// <param name="manager"></param>
/// <param name="sourceDatabase"></param>
/// <param name="destinationDatabase"></param>
public override void Map(MappingManager manager, SourceDatabase sourceDatabase, DestinationDatabase destinationDatabase)
{
//
// Try to get source database name and destination database name
DbContext sourceDbContext = sourceDatabase.GetDbContext();
DbContext destDbContext = destinationDatabase.GetDbContext();
string sourceDatabaseName = sourceDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string destDatabaseName = destDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string tableName = "view_DofiReport_Table1";
//
// Generate SQL script
string sqlQuery = @"INSERT INTO {DESTINATION_DATABASE_NAME}.dbo.view_DofiReport_Table1(spid, apra_authorised_during_reporting_period, apra_authorised_after_reporting_period, apra_authorised_before_reporting_period, lloyd_during_reporting_period, lloyd_after_reporting_period, lloyd_before_reporting_period, ufi_during_reporting_period, ufi_after_reporting_period, ufi_before_reporting_period, broker_during_reporting_period, broker_after_reporting_period, broker_before_reporting_period)" + Environment.NewLine +
"SELECT spid, apra_authorised_during_reporting_period, apra_authorised_after_reporting_period, apra_authorised_before_reporting_period, lloyd_during_reporting_period, lloyd_after_reporting_period, lloyd_before_reporting_period, ufi_during_reporting_period, ufi_after_reporting_period, ufi_before_reporting_period, broker_during_reporting_period, broker_after_reporting_period, broker_before_reporting_period FROM {SOURCE_DATABASE_NAME}.dbo.view_DofiReport_Table1" + Environment.NewLine;
sqlQuery = sqlQuery.Replace("{SOURCE_DATABASE_NAME}", sourceDatabaseName)
.Replace("{DESTINATION_DATABASE_NAME}", destDatabaseName);
//
// Exec SQL script or write to file
if (manager.IsGeneratedScript)
{
sqlQuery = "USE [" + destDatabaseName + "]" + Environment.NewLine +
"GO" + Environment.NewLine +
sqlQuery;
manager.WriteSQLScript(tableName, sqlQuery, false);
}
else
{
try
{
destDbContext.Database.ExecuteSqlCommand(sqlQuery);
}
catch (Exception excExecScript)
{
LogService.Log.Error("Can not run migration script for " + tableName, excExecScript);
}
}
}
/// <summary>
/// Manual mapping function for view_inspay
/// </summary>
/// <param name="manager"></param>
/// <param name="sourceDatabase"></param>
/// <param name="destinationDatabase"></param>
public override void Map(MappingManager manager, SourceDatabase sourceDatabase, DestinationDatabase destinationDatabase)
{
//
// Try to get source database name and destination database name
DbContext sourceDbContext = sourceDatabase.GetDbContext();
DbContext destDbContext = destinationDatabase.GetDbContext();
string sourceDatabaseName = sourceDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string destDatabaseName = destDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string tableName = "view_inspay";
//
// Exec sql script to insert data
string sqlQuery = @"INSERT INTO {DESTINATION_DATABASE_NAME}.dbo.view_inspay(pol_id, pol_parent_id, pol_tran_id, pol_transaction_type, pol_policy_number, pol_date_from, pol_date_effective, pol_date_to, pol_date_due, pol_debtor, pay_insurer_id, pol_sub_agent, pol_total_gross_premium, pol_total_net_premium, pay_gross_premium, pay_commission, pay_net_premium, pay_debtor_bal, pay_debtor_adj, pay_insurer_bal, pay_insurer_adj, pay_payable, spid)" + Environment.NewLine +
"SELECT pol_id, pol_parent_id, pol_tran_id, pol_transaction_type, pol_policy_number, pol_date_from, pol_date_effective, pol_date_to, pol_date_due, pol_debtor, pay_insurer_id, pol_sub_agent, pol_total_gross_premium, pol_total_net_premium, pay_gross_premium, pay_commission, pay_net_premium, pay_debtor_bal, pay_debtor_adj, pay_insurer_bal, pay_insurer_adj, pay_payable, spid FROM {SOURCE_DATABASE_NAME}.dbo.view_inspay" + Environment.NewLine;
sqlQuery = sqlQuery.Replace("{SOURCE_DATABASE_NAME}", sourceDatabaseName)
.Replace("{DESTINATION_DATABASE_NAME}", destDatabaseName);
//
// Exec SQL script or write to file
if (manager.IsGeneratedScript)
{
sqlQuery = "USE [" + destDatabaseName + "]" + Environment.NewLine +
"GO" + Environment.NewLine +
sqlQuery;
manager.WriteSQLScript(tableName, sqlQuery, false);
}
else
{
try
{
destDbContext.Database.ExecuteSqlCommand(sqlQuery);
}
catch (Exception excExecScript)
{
LogService.Log.Error("Can not run migration script for " + tableName, excExecScript);
}
}
}
/// <summary>
/// Manual mapping function for view_earnings
/// </summary>
/// <param name="manager"></param>
/// <param name="sourceDatabase"></param>
/// <param name="destinationDatabase"></param>
public override void Map(MappingManager manager, SourceDatabase sourceDatabase, DestinationDatabase destinationDatabase)
{
//
// Try to get source database name and destination database name
DbContext sourceDbContext = sourceDatabase.GetDbContext();
DbContext destDbContext = destinationDatabase.GetDbContext();
string sourceDatabaseName = sourceDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string destDatabaseName = destDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string tableName = "view_earnings";
//
// Generate SQL script
string sqlQuery = @"INSERT INTO {DESTINATION_DATABASE_NAME}.dbo.view_earnings(ent_id, ent_name, genins_name, pol_parent_id, pol_id, pol_tran_id, pol_total_gross_premium, pol_total_net_premium, adj, acr, debtor_bal, earn_broker_comm, earn_sa_comm, earn_broker_fee, earn_sa_fee, earn_total, spid, earn_gst, broker_comm, broker_fee, total_earn, comm_earned, fees_earned, fees_gst, comm_gst, total_earn_gst, total_earn_net_gst, gst_rate, bal, bal2, sa_payable, pol_amount_remitted_sub, sa_gst, pol_fee_gst, pol_comm_gst, debtor_paid, paid_date, br_comm_adjustment)" + Environment.NewLine +
"SELECT ent_id, ent_name, genins_name, pol_parent_id, pol_id, pol_tran_id, pol_total_gross_premium, pol_total_net_premium, adj, acr, debtor_bal, earn_broker_comm, earn_sa_comm, earn_broker_fee, earn_sa_fee, earn_total, spid, earn_gst, broker_comm, broker_fee, total_earn, comm_earned, fees_earned, fees_gst, comm_gst, total_earn_gst, total_earn_net_gst, gst_rate, bal, bal2, sa_payable, pol_amount_remitted_sub, sa_gst, pol_fee_gst, pol_comm_gst, debtor_paid, paid_date, br_comm_adjustment FROM {SOURCE_DATABASE_NAME}.dbo.view_earnings" + Environment.NewLine;
sqlQuery = sqlQuery.Replace("{SOURCE_DATABASE_NAME}", sourceDatabaseName)
.Replace("{DESTINATION_DATABASE_NAME}", destDatabaseName);
//
// Exec SQL script or write to file
if (manager.IsGeneratedScript)
{
sqlQuery = "USE [" + destDatabaseName + "]" + Environment.NewLine +
"GO" + Environment.NewLine +
sqlQuery;
manager.WriteSQLScript(tableName, sqlQuery, false);
}
else
{
try
{
destDbContext.Database.ExecuteSqlCommand(sqlQuery);
}
catch (Exception excExecScript)
{
LogService.Log.Error("Can not run migration script for " + tableName, excExecScript);
}
}
}
/// <summary>
/// Main mapping function
/// </summary>
/// <param name="manager"></param>
/// <param name="sourceDatabase"></param>
/// <param name="destinationDatabase"></param>
public override void Map(MappingManager manager, SourceDatabase sourceDatabase, DestinationDatabase destinationDatabase)
{
//
// Try to get source database name and destination database name
DbContext sourceDbContext = sourceDatabase.GetDbContext();
DbContext destDbContext = destinationDatabase.GetDbContext();
string sourceDatabaseName = sourceDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string destDatabaseName = destDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string tableName = "renewal_retention_report";
//
// Generate SQL script
string sqlQuery = @"INSERT INTO {DESTINATION_DATABASE_NAME}.dbo.renewal_retention_report(PolID, TranID, Client, SalesTeam, ServiceTeam, Branch, COB, InsurerName, BrokerName, TransactionType, Paid, PartPaid, UnPaid, Lapsed, UnInvited, saltea_id, sertea_id, gencob_id, ent_id, pol_insurer, br_id, tratyp_id, bra_name, genins_id, genins_name, Rentention, Spid, Premium, Earnings, DueDate)" + Environment.NewLine +
"SELECT PolID, TranID, Client, SalesTeam, ServiceTeam, Branch, COB, InsurerName, BrokerName, TransactionType, Paid, PartPaid, UnPaid, Lapsed, UnInvited, saltea_id, sertea_id, gencob_id, ent_id, pol_insurer, br_id, tratyp_id, bra_name, genins_id, genins_name, Rentention, Spid, Premium, Earnings, DueDate FROM {SOURCE_DATABASE_NAME}.dbo.renewal_retention_report" + Environment.NewLine;
sqlQuery = sqlQuery.Replace("{SOURCE_DATABASE_NAME}", sourceDatabaseName)
.Replace("{DESTINATION_DATABASE_NAME}", destDatabaseName);
//
// Exec SQL script or write to file
if (manager.IsGeneratedScript)
{
sqlQuery = "USE [" + destDatabaseName + "]" + Environment.NewLine +
"GO" + Environment.NewLine +
sqlQuery;
manager.WriteSQLScript(tableName, sqlQuery, false);
}
else
{
try
{
destDbContext.Database.ExecuteSqlCommand(sqlQuery);
}
catch (Exception excExecScript)
{
LogService.Log.Error("Can not run migration script for " + tableName, excExecScript);
}
}
}
/// <summary>
/// Manual mapping function for ageing_debtors_v
/// </summary>
/// <param name="manager"></param>
/// <param name="sourceDatabase"></param>
/// <param name="destinationDatabase"></param>
public override void Map(MappingManager manager, SourceDatabase sourceDatabase, DestinationDatabase destinationDatabase)
{
//
// Try to get source database name and destination database name
DbContext sourceDbContext = sourceDatabase.GetDbContext();
DbContext destDbContext = destinationDatabase.GetDbContext();
string sourceDatabaseName = sourceDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string destDatabaseName = destDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string tableName = "ageing_debtors_v";
//
// Generate SQL script
string sqlQuery = @"INSERT INTO {DESTINATION_DATABASE_NAME}.dbo.ageing_debtors_v(bal_entity_id, genins_id, genins_name, genins_class_of_business, gencob_name, bal_tran_id, gentrans_name, pol_insurer, insurer_name, pol_policy_number, tran_type, tran_time, pol_date_effective, gross, balamount, days_between, ent_name, Saltea_ID, saltea_name, Sertea_ID, sertea_name, sa_id, sa_name, last_payment, RCPT_AMOUNT, SPID, debtor_fund_status, BRComm)" + Environment.NewLine +
"SELECT bal_entity_id, genins_id, genins_name, genins_class_of_business, gencob_name, bal_tran_id, gentrans_name, pol_insurer, insurer_name, pol_policy_number, tran_type, tran_time, pol_date_effective, gross, balamount, days_between, ent_name, Saltea_ID, saltea_name, Sertea_ID, sertea_name, sa_id, sa_name, last_payment, RCPT_AMOUNT, SPID, debtor_fund_status, BRComm FROM {SOURCE_DATABASE_NAME}.dbo.ageing_debtors_v" + Environment.NewLine;
sqlQuery = sqlQuery.Replace("{SOURCE_DATABASE_NAME}", sourceDatabaseName)
.Replace("{DESTINATION_DATABASE_NAME}", destDatabaseName);
//
// Exec SQL script or write to file
if (manager.IsGeneratedScript)
{
sqlQuery = "USE [" + destDatabaseName + "]" + Environment.NewLine +
"GO" + Environment.NewLine +
sqlQuery;
manager.WriteSQLScript(tableName, sqlQuery, false);
}
else
{
try
{
destDbContext.Database.ExecuteSqlCommand(sqlQuery);
}
catch (Exception excExecScript)
{
LogService.Log.Error("Can not run migration script for " + tableName, excExecScript);
}
}
}
/// <summary>
/// Main mapping function
/// </summary>
/// <param name="manager"></param>
/// <param name="sourceDatabase"></param>
/// <param name="destinationDatabase"></param>
public override void Map(MappingManager manager, SourceDatabase sourceDatabase, DestinationDatabase destinationDatabase)
{
//
// Try to get source database name and destination database name
DbContext sourceDbContext = sourceDatabase.GetDbContext();
DbContext destDbContext = destinationDatabase.GetDbContext();
string sourceDatabaseName = sourceDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string destDatabaseName = destDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string tableName = "tmpPortfolioAnalysis";
//
// Exec sql script to insert data
string sqlQuery = @"INSERT INTO {DESTINATION_DATABASE_NAME}.dbo.tmpPortfolioAnalysis(GrpId, GrpName, SortName, Clientcount, TotalPolicies, Totalclients, Premiums, leviduties, Othercharges, bfees, comm, InvoiceTotal, spid, pol_sub_agent_fee_pay_net_gst, pol_sub_agent_comm_pay_net_gst, ccfees)" + Environment.NewLine +
"SELECT GrpId, GrpName, SortName, Clientcount, TotalPolicies, Totalclients, Premiums, leviduties, Othercharges, bfees, comm, InvoiceTotal, spid, pol_sub_agent_fee_pay_net_gst, pol_sub_agent_comm_pay_net_gst, ccfees FROM {SOURCE_DATABASE_NAME}.dbo.tmpPortfolioAnalysis" + Environment.NewLine;
sqlQuery = sqlQuery.Replace("{SOURCE_DATABASE_NAME}", sourceDatabaseName)
.Replace("{DESTINATION_DATABASE_NAME}", destDatabaseName);
//
// Exec SQL script or write to file
if (manager.IsGeneratedScript)
{
sqlQuery = "USE [" + destDatabaseName + "]" + Environment.NewLine +
"GO" + Environment.NewLine +
sqlQuery;
manager.WriteSQLScript(tableName, sqlQuery, false);
}
else
{
try
{
destDbContext.Database.ExecuteSqlCommand(sqlQuery);
}
catch (Exception excExecScript)
{
LogService.Log.Error("Can not run migration script for " + tableName, excExecScript);
}
}
}
/// <summary>
/// Main mapping function
/// </summary>
/// <param name="manager"></param>
/// <param name="sourceDatabase"></param>
/// <param name="destinationDatabase"></param>
public override void Map(MappingManager manager, SourceDatabase sourceDatabase, DestinationDatabase destinationDatabase)
{
//
// Try to get source database name and destination database name
DbContext sourceDbContext = sourceDatabase.GetDbContext();
DbContext destDbContext = destinationDatabase.GetDbContext();
string sourceDatabaseName = sourceDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string destDatabaseName = destDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string tableName = "PaidInvoices";
//
// Exec sql script to insert data
string sqlQuery = @"INSERT INTO {DESTINATION_DATABASE_NAME}.dbo.PaidInvoices(tritm_tran_id, tritm_amount, Paid, Remaining, tritm_inc_id, DatePaid, spid)" + Environment.NewLine +
"SELECT tritm_tran_id, tritm_amount, Paid, Remaining, tritm_inc_id, DatePaid, spid FROM {SOURCE_DATABASE_NAME}.dbo.PaidInvoices" + Environment.NewLine;
sqlQuery = sqlQuery.Replace("{SOURCE_DATABASE_NAME}", sourceDatabaseName)
.Replace("{DESTINATION_DATABASE_NAME}", destDatabaseName);
//
// Exec SQL script or write to file
if (manager.IsGeneratedScript)
{
sqlQuery = "USE [" + destDatabaseName + "]" + Environment.NewLine +
"GO" + Environment.NewLine +
sqlQuery;
manager.WriteSQLScript(tableName, sqlQuery, false);
}
else
{
try
{
destDbContext.Database.ExecuteSqlCommand(sqlQuery);
}
catch (Exception excExecScript)
{
LogService.Log.Error("Can not run migration script for " + tableName, excExecScript);
}
}
}
/// <summary>
/// Main mapping function
/// </summary>
/// <param name="manager"></param>
/// <param name="sourceDatabase"></param>
/// <param name="destinationDatabase"></param>
public override void Map(MappingManager manager, SourceDatabase sourceDatabase, DestinationDatabase destinationDatabase)
{
//
// Try to get source database name and destination database name
DbContext sourceDbContext = sourceDatabase.GetDbContext();
DbContext destDbContext = destinationDatabase.GetDbContext();
string sourceDatabaseName = sourceDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string destDatabaseName = destDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string tableName = "IBA";
//
// Exec sql script to insert data
string sqlQuery = @"INSERT INTO {DESTINATION_DATABASE_NAME}.dbo.IBA(Fromdate, Todate, adp77, adp78, adp79, adp80, adp81, adp82, adp83, adp84, adp85, adp86, adp87A, adp87B, adp87C, adp87, adp88, adp89, adp90, adp91, adp92, adp93, adp94, adp95, adp100, adp101, adp102, adp103, adp104, adp105, TotalSelfDrawings, TotalGSTDrawings, TotalBrokerRepEarnings, Earnings, GSTonEarnings, DrawnToBrokerRep, DrawnToGST, DrawnToSelf, Adjustments, adp106A, adp106b, adp106c, adp106, adp107, adp108, CashClosingBalance, Asic26DiffAmount, Asic27DiffAmount, spid)" + Environment.NewLine +
"SELECT Fromdate, Todate, adp77, adp78, adp79, adp80, adp81, adp82, adp83, adp84, adp85, adp86, adp87A, adp87B, adp87C, adp87, adp88, adp89, adp90, adp91, adp92, adp93, adp94, adp95, adp100, adp101, adp102, adp103, adp104, adp105, TotalSelfDrawings, TotalGSTDrawings, TotalBrokerRepEarnings, Earnings, GSTonEarnings, DrawnToBrokerRep, DrawnToGST, DrawnToSelf, Adjustments, adp106A, adp106b, adp106c, adp106, adp107, adp108, CashClosingBalance, Asic26DiffAmount, Asic27DiffAmount, spid FROM {SOURCE_DATABASE_NAME}.dbo.IBA" + Environment.NewLine;
sqlQuery = sqlQuery.Replace("{SOURCE_DATABASE_NAME}", sourceDatabaseName)
.Replace("{DESTINATION_DATABASE_NAME}", destDatabaseName);
//
// Exec SQL script or write to file
if (manager.IsGeneratedScript)
{
sqlQuery = "USE [" + destDatabaseName + "]" + Environment.NewLine +
"GO" + Environment.NewLine +
sqlQuery;
manager.WriteSQLScript(tableName, sqlQuery, false);
}
else
{
try
{
destDbContext.Database.ExecuteSqlCommand(sqlQuery);
}
catch (Exception excExecScript)
{
LogService.Log.Error("Can not run migration script for " + tableName, excExecScript);
}
}
}
/// <summary>
/// Main mapping function
/// </summary>
/// <param name="manager"></param>
/// <param name="sourceDatabase"></param>
/// <param name="destinationDatabase"></param>
public override void Map(MappingManager manager, SourceDatabase sourceDatabase, DestinationDatabase destinationDatabase)
{
//
// Try to get source database name and destination database name
DbContext sourceDbContext = sourceDatabase.GetDbContext();
DbContext destDbContext = destinationDatabase.GetDbContext();
string sourceDatabaseName = sourceDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string destDatabaseName = destDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string tableName = "statements";
//
// Generate SQL script
string sqlQuery = @"INSERT INTO {DESTINATION_DATABASE_NAME}.dbo.statements(gltr_glsl_id, glsl_entity_id, glsl_name, gltr_id, gltr_date, glmv_date, glmv_id, glmv_glrs_set, glmv_record_ref_id, origamount, gltr_amount, debit, credit, balance, unalloccash, netbalance, pol_id, pol_id1, pol_tran_id, pol_tran_id1, tran_id, Pol_policy_number, genins_name, genins_class_of_business, gencob_name, paymethod, client, sortid, spid, salesteam, BRComm, NetDue, BRClient, StatementInsurer, PaymentType, InvoiceComments)" + Environment.NewLine +
"SELECT gltr_glsl_id, glsl_entity_id, glsl_name, gltr_id, gltr_date, glmv_date, glmv_id, glmv_glrs_set, glmv_record_ref_id, origamount, gltr_amount, debit, credit, balance, unalloccash, netbalance, pol_id, pol_id1, pol_tran_id, pol_tran_id1, tran_id, Pol_policy_number, genins_name, genins_class_of_business, gencob_name, paymethod, client, sortid, spid, salesteam, BRComm, NetDue, BRClient, StatementInsurer, PaymentType, InvoiceComments FROM {SOURCE_DATABASE_NAME}.dbo.statements" + Environment.NewLine;
sqlQuery = sqlQuery.Replace("{SOURCE_DATABASE_NAME}", sourceDatabaseName)
.Replace("{DESTINATION_DATABASE_NAME}", destDatabaseName);
//
// Exec SQL script or write to file
if (manager.IsGeneratedScript)
{
sqlQuery = "USE [" + destDatabaseName + "]" + Environment.NewLine +
"GO" + Environment.NewLine +
sqlQuery;
manager.WriteSQLScript(tableName, sqlQuery, false);
}
else
{
try
{
destDbContext.Database.ExecuteSqlCommand(sqlQuery);
}
catch (Exception excExecScript)
{
LogService.Log.Error("Can not run migration script for " + tableName, excExecScript);
}
}
}
/// <summary>
/// Manual mapping function for glsl_Transactions
/// </summary>
/// <param name="manager"></param>
/// <param name="sourceDatabase"></param>
/// <param name="destinationDatabase"></param>
public override void Map(MappingManager manager, SourceDatabase sourceDatabase, DestinationDatabase destinationDatabase)
{
//
// Try to get source database name and destination database name
DbContext sourceDbContext = sourceDatabase.GetDbContext();
DbContext destDbContext = destinationDatabase.GetDbContext();
string sourceDatabaseName = sourceDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string destDatabaseName = destDbContext.Database.SqlQuery <string>(@"SELECT DB_NAME() AS [Current Database]").FirstOrDefault();
string tableName = "glsl_Transactions";
//
// Exec sql script to insert data
string sqlQuery = @"INSERT INTO {DESTINATION_DATABASE_NAME}.dbo.glsl_Transactions(Glsl_id, Glac_Balance, TranDate, TranNumber, TranType, InvNumber, Particulars, TranAmount, Spid, Glsl_balance)" + Environment.NewLine +
"SELECT Glsl_id, Glac_Balance, TranDate, TranNumber, TranType, InvNumber, Particulars, TranAmount, Spid, Glsl_balance FROM {SOURCE_DATABASE_NAME}.dbo.glsl_Transactions" + Environment.NewLine;
sqlQuery = sqlQuery.Replace("{SOURCE_DATABASE_NAME}", sourceDatabaseName)
.Replace("{DESTINATION_DATABASE_NAME}", destDatabaseName);
//
// Exec SQL script or write to file
if (manager.IsGeneratedScript)
{
sqlQuery = "USE [" + destDatabaseName + "]" + Environment.NewLine +
"GO" + Environment.NewLine +
sqlQuery;
manager.WriteSQLScript(tableName, sqlQuery, false);
}
else
{
try
{
destDbContext.Database.ExecuteSqlCommand(sqlQuery);
}
catch (Exception excExecScript)
{
LogService.Log.Error("Can not run migration script for " + tableName, excExecScript);
}
}
}