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("=================================================================="); }