private void SetVarValue(string DatabaseName, string VarName, string VarValue) {
try {
MMData d = new MMData();
d.ExecuteStoredProc(DatabaseName, "exec dbo.sp_SetDBVars @VarName, @VarValue",
new StProcParam[] {
new StProcParam("@VarName", DbType.String, VarName),
new StProcParam("@VarValue", DbType.String, VarValue)
}
);
} catch (Exception e) {
throw e;
}
}
public static Exception toTraceException(this Exception e, User UserX, string sLocation)
{
try {
MMData d = new MMData();
string sDetails = e.toWalkExcTreePath();
d.ExecuteStoredProc("PD", "insert into dbo.TraceException (TE_U_ID, TE_Location, TE_Details) values (@aU_ID, @aLoc, @aDetails) ", new StProcParam[] {
new StProcParam("@aU_ID", System.Data.DbType.Int32, UserX.UserID),
new StProcParam("@aLoc", System.Data.DbType.String, sLocation),
new StProcParam("@aDetails", System.Data.DbType.String, sDetails)
});
} catch (Exception xx) {
// if db is out then lets not add another to pile on log.
}
return(e);
}