/// <summary>
/// returns true if DBNull Or Empty String or nothing
/// </summary>
/// <param name="oItemValue"></param>
/// <returns></returns>
public static bool IsDBNullOrEmpty(object oItemValue)
{
bool bRet = false;
if (oItemValue == null)
{
return(true);
}
#if NET461
if (System.Convert.IsDBNull(oItemValue))
{
return(true);
}
if (oItemValue.GetType() == typeof(System.DateTime))
{
if (ObjectType.ObjTst(oItemValue, null, false) == 0)
{
bRet = true;
}
return(bRet);
}
#else
DebugOutputHelper.TracedLine("Convert.IsDBNull Supported only NETStandard 2.0+ ");
#endif // NET461
if (String.IsNullOrEmpty(oItemValue.ToString()))
{
bRet = true;
}
return(bRet);
}
public static bool SetIfNotEmpty(ref object LValue, object Value)
{
DebugOutputHelper.TracedLine("not sure that it returns valid ref");
bool bRet = false;
if (!DataHelper.IsDBNullOrEmpty(Value))
{
LValue = Value;
bRet = true;
}
return(bRet);
}
/// <summary>
///
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
/// <remarks>
/// from http://west-wind.com/weblog/posts/361.aspx
/// use TextInfo.ToTitleCase(mText.ToLower());
/// Alternative see From http://aspcode.net/propercase-function-in-c/
/// </remarks>
public static string ToTitleCase(this string input)
{
if (input == null)
{
return(null);
}
input = input.ToLower();
#if !NETSTANDARD1_6
return(Thread.CurrentThread.CurrentCulture.TextInfo.ToTitleCase(input));
#else //(used by identityServer)
DebugOutputHelper.TracedLine("Supported only NETStandard 2.0+ ");
return(input);
#endif // NETSTANDARD1_6
}
// 'TODO there are too many similar function 'review and re-factor them
//'Generic method to set not NULL values, similar to SQL Coalesce
//It is similar to SafeRef class, but also consider DBNull
//USE ToString_EmptyIfNull if convert to String is required
//For VBStrings see StringHelper.Coalesce
public static object Nz(object oItemValue, object oDefault)
{
if (oItemValue == null)
{
return(oDefault);
}
#if NET461
if (Convert.IsDBNull(oItemValue))
{
return(oDefault);
}
#else
DebugOutputHelper.TracedLine("Convert.IsDBNull Supported only NETStandard 2.0+ ");
#endif // NET461
//'TODO add DateTime = Nothing as in IsDBNullOrEmpty
return(oItemValue);
}
