public long Add(CommandRouteOnRequest commandRouteItem)
{
commandRouteItem.DateAdded = DateTime.Now;
if (commandRouteItem.Id == 0) //To allow for migration
{
long nextId = _counterHelper.GetNextId(_commandRouteOnRequestCollectionName);
commandRouteItem.Id = nextId;
}
_CommandRouteOnRequestCollection.Save(commandRouteItem);
return commandRouteItem.Id;
}
public CommandRouteOnRequestDTO()
{
CommandRouteCentres = new List<CommandRouteOnRequestCostcentre>();
RouteOnRequest = new CommandRouteOnRequest();
}
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("==================================================================");
}
