public DbHelper(ConnectionBuilder builder) { _connBuilder = builder; _connString = _connBuilder.GetConnectionString(); }
public static ConnectionBuilder GetDefaultConnection(ProjectName projectName, bool getAlternate = false) { var defaultServerName = "ZM-VLUS56"; var defaultSqlExpress = string.Empty; if (getAlternate) { //defaultServerName = "D-5932S32"; //defaultSqlExpress = "SQL2014DEV"; defaultServerName = "D-9W48GC2"; defaultSqlExpress = "SQL2014"; } //a dirty catch to avoid messing with the server. Feel free to remove if (Environment.MachineName == "D-9W48GC2" || Environment.MachineName == "D-5932S32" || Environment.MachineName == "SUPER-LAP") { var res = MessageBox.Show("Use your Local Computer rather than the server MK ???????????", "WAIT!!!!!!!!!!!", MessageBoxButton.YesNoCancel); if (res == MessageBoxResult.Yes) { // getAlternate = true; //SUPER-LAP\SQL2014 //D-9W48GC2\SQL2014 if (Environment.MachineName == "D-9W48GC2") { defaultServerName = "D-9W48GC2"; defaultSqlExpress = "SQL2014"; } else if (Environment.MachineName == "D-5932S32") { defaultServerName = "D-5932S32"; defaultSqlExpress = "SQL2014DEV"; } else { defaultServerName = "SUPER-LAP"; defaultSqlExpress = "SQL2014"; } } else if (res == MessageBoxResult.Cancel) { return(null); } else if (res == MessageBoxResult.No) { //leave as is } } ConnectionBuilder connBuilder = null; switch (projectName) { case ProjectName.DOD: { connBuilder = new ConnectionBuilder() { DatabaseName = "JhpiegoDb_DOD", InstanceName = defaultSqlExpress, ServerName = defaultServerName }; break; } case ProjectName.IHP_VMMC: { connBuilder = new ConnectionBuilder() { DatabaseName = "JhpiegoDb_IhpVmmc", InstanceName = defaultSqlExpress, ServerName = defaultServerName }; break; } case ProjectName.IHP_Capacity_Building_and_Training: { connBuilder = new ConnectionBuilder() { DatabaseName = "JhpiegoDb_IhpTraining", InstanceName = defaultSqlExpress, ServerName = defaultServerName }; break; } case ProjectName.General: { connBuilder = new ConnectionBuilder() { DatabaseName = "JhpiegoDb_General", InstanceName = defaultSqlExpress, ServerName = defaultServerName }; break; } } return(connBuilder); }
internal void OverwriteDefaultConnection(ConnectionBuilder connBuilder) { ConnBuilder = connBuilder; }