private void DoMessageCallback(string message, string prefix = null)
{
if (message == null)
{
return;
}
if (MessageCallback != null)
{
MessageCallback(prefix + SqlClientHelpers.SqlErrorTextCleaner(message));
}
else
{
throw (new Exception(message));
}
}
public DataSet ExecuteDataSet(object label) //actually any object with a .Text propertyName will suffice :)
{
ReflectionHelpers.PropertySetter(label, "Success", true);
try
{
return(ExecuteDataSet().DataSet);
}
catch (Exception ex) {
ReflectionHelpers.PropertySetter(label, "Success", false);
//if the caller has provided a way to display the error then do so
if (ReflectionHelpers.PropertySetter(label, "Text", SqlClientHelpers.SqlErrorTextCleaner(ex.Message)))
{
return(null);
}
//otherwise rethrow so that we can see the buggy that caused the exception and fix it
throw;
}
}
public bool ExecuteNonQuery(object label, bool displaySuccess)
{
try
{
ExecuteNonQuery();
if (displaySuccess)
{
ReflectionHelpers.PropertySetter(label, "Text", "Saved Successfully");
}
return(true);
}
catch (Exception ex)
{
if (!ReflectionHelpers.PropertySetter(label, "Text", SqlClientHelpers.SqlErrorTextCleaner(ex.Message)))
{
throw;
}
return(false);
}
}
public bool ExecuteNonQuery(ExecuteMessageCallback callback, String ExecuteMessagePrefix, bool DisplaySuccess)
{
try
{
ExecuteNonQuery();
if (DisplaySuccess && callback != null)
{
callback(ExecuteMessagePrefix + "Saved Successfully");
}
return(true);
}
catch (Exception ex)
{
if (callback != null)
{
callback(ExecuteMessagePrefix + SqlClientHelpers.SqlErrorTextCleaner(ex.Message));
}
return(false);
}
}
