public SaleCustomerController() { string connectionString = "Server=tcp:lasmargaritas.database.windows.net,1433;Initial Catalog=LasMargaritasDBDev;Persist Security Info=False;User ID=LasMargaritasDbUser;Password=LasMargaritasPassw0rd!;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"; if (ConfigurationManager.ConnectionStrings["LasMargaritasDb"] != null) { connectionString = ConfigurationManager.ConnectionStrings["LasMargaritasDb"].ConnectionString; } saleCustomerBL = new SaleCustomerBL(connectionString); }
private static void MigrateSaleCustomers() { List <string> exceptions = new List <string>(); List <SaleCustomer> customers = SaleCustomerOld.GetSaleCustomer(); SaleCustomerBL customerBL = new SaleCustomerBL(connectionString); foreach (SaleCustomer customer in customers) { try { customerBL.InsertSaleCustomer(customer); } catch (Exception ex) { exceptions.Add(customer.Name + ". Error " + ex.Message); } } foreach (string ex in exceptions) { Console.WriteLine(ex); } Console.ReadLine(); }