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;
}
