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("=================================================================="); }
public void AddRoutingCentre(CommandRouteOnRequestCostcentre commandRouteOnRequestCostcentre) { //commandRouteOnRequestCostcentre.IsValid = true; commandRouteOnRequestCostcentre.DateAdded = DateTime.Now; _CommandRouteOnRequestCostcentreCollection.Save(commandRouteOnRequestCostcentre); }