private static void MigrateCommandStatus()
{
cokecommandroutingEntities db = new cokecommandroutingEntities();
System.Console.WriteLine("==================================================================");
System.Console.WriteLine("Start Migrating Command Status");
System.Console.WriteLine("==================================================================");
string connection = ConfigurationSettings.AppSettings["MongoRoutingConnectionString"];
CommandRoutingOnRequestMongoRepository _repo = new CommandRoutingOnRequestMongoRepository(connection);
int count = 0;
foreach (tblRoutingStatu cmd in db.tblRoutingStatus.OrderBy(o => o.tblDistributrCommand.Id))
{
CommandRoutingStatus cmdmongo = new CommandRoutingStatus();
cmdmongo.DateAdded = cmd.tblDistributrCommand.DateCommandInserted;
cmdmongo.CommandRouteOnRequestId = cmd.tblDistributrCommand.Id;
cmdmongo.DateAdded = DateTime.Now;
cmdmongo.Delivered = true;
cmdmongo.DateDelivered = DateTime.Now;
cmdmongo.DestinationCostCentreApplicationId = cmd.DestinationCostCentreApplicationId;
cmdmongo.CommandRouteOnRequestId = cmd.tblDistributrCommand.Id;
cmdmongo.CommandId = cmd.tblDistributrCommand.CommandId;
cmdmongo.Id = Guid.NewGuid();
try
{
_repo.AddStatus(cmdmongo);
count++;
}catch{}
}
System.Console.WriteLine("==================================================================");
System.Console.WriteLine(count + " Migrate Command Status migrated");
System.Console.WriteLine("==================================================================");
}
private static void MigrateCommandCentre()
{
cokecommandroutingEntities db = new cokecommandroutingEntities();
System.Console.WriteLine("==================================================================");
System.Console.WriteLine("Start migrating Migrate Command Centre");
System.Console.WriteLine("==================================================================");
string connection = ConfigurationSettings.AppSettings["MongoRoutingConnectionString"];
CommandRoutingOnRequestMongoRepository _repo = new CommandRoutingOnRequestMongoRepository(connection);
int count = 0;
foreach (tblRoutingCentre cmd in db.tblRoutingCentres.OrderBy(o => o.tblDistributrCommand.Id))
{
CommandRouteOnRequestCostcentre cmdmongo = new CommandRouteOnRequestCostcentre();
cmdmongo.CommandType =cmd.tblDistributrCommand.CommandType;
cmdmongo.DateAdded = cmd.tblDistributrCommand.DateCommandInserted;
cmdmongo.CommandRouteOnRequestId = cmd.tblDistributrCommand.Id;
cmdmongo.CostCentreId = cmd.RoutingCostCentreId;
cmdmongo.IsRetired = cmd.tblDistributrCommand.IsRetired;
cmdmongo.IsValid = cmd.Valid;
cmdmongo.Id = Guid.NewGuid();
_repo.AddRoutingCentre(cmdmongo);
count++;
}
System.Console.WriteLine("==================================================================");
System.Console.WriteLine(count + " Migrate Command Centre migrated");
System.Console.WriteLine("==================================================================");
}
private static void MigrateCommands()
{
cokecommandroutingEntities db = new cokecommandroutingEntities();
System.Console.WriteLine("==================================================================");
System.Console.WriteLine("Start migrating commands");
System.Console.WriteLine("==================================================================");
string connection=ConfigurationSettings.AppSettings["MongoRoutingConnectionString"];
CommandRoutingOnRequestMongoRepository _repo = new CommandRoutingOnRequestMongoRepository(connection);
int count = 0;
foreach(tblDistributrCommand cmd in db.tblDistributrCommands.OrderBy(o=>o.Id))
{
CommandRouteOnRequest cmdmongo = new CommandRouteOnRequest();
cmdmongo.CommandGeneratedByCostCentreApplicationId = cmd.CommandGeneratedByCostCentreApplicationId;
cmdmongo.CommandGeneratedByUserId = cmd.CommandGeneratedByUserId;
cmdmongo.CommandId = cmd.CommandId;
cmdmongo.CommandType = cmd.CommandType;
cmdmongo.DateAdded = cmd.DateCommandInserted;
cmdmongo.DateCommandInserted = cmd.DateCommandInserted;
cmdmongo.DocumentId = cmd.DocumentId;
cmdmongo.DocumentParentId = cmd.DocumentParentId.HasValue?cmd.DocumentParentId.Value:Guid.NewGuid();
cmdmongo.Id = cmd.Id;
cmdmongo.IsRetired = cmd.IsRetired;
cmdmongo.JsonCommand = cmd.JsonCommand;
_repo.Add(cmdmongo);
count++;
}
System.Console.WriteLine("==================================================================");
System.Console.WriteLine(count + " Command migrated");
System.Console.WriteLine("==================================================================");
}