public static object SetPlaceholderIfNull(object value, NullValueRepresentation nullValueRepresentation)
{
if (value == null)
{
switch (nullValueRepresentation)
{
case NullValueRepresentation.EmptyString:
value = "";
break;
case NullValueRepresentation.NullPlaceHolder:
value = Constants.NullValuePlaceholder;
break;
case NullValueRepresentation.IntZero:
value = 0;
break;
case NullValueRepresentation.DoubleZero:
value = 0D;
break;
}
}
return(value);
}
public static object GetNullIfPlaceholder(object value, NullValueRepresentation nullValueRepresentation)
{
switch (nullValueRepresentation)
{
case NullValueRepresentation.DoubleZero:
try
{
double d = Convert.ToDouble(value);
if (d == 0D)
{
value = null;
}
}
catch
{
}
break;
case NullValueRepresentation.IntZero:
try
{
int v = Convert.ToInt32(value);
if (v == 0)
{
value = null;
}
}
catch
{
}
break;
case NullValueRepresentation.EmptyString:
if (value is string s)
{
if (string.IsNullOrEmpty(s))
{
value = null;
}
}
break;
case NullValueRepresentation.NullPlaceHolder:
if (value is string s2)
{
if (s2 == Constants.NullValuePlaceholder)
{
value = null;
}
}
break;
}
return(value);
}
public static object GetNullRepresentation(NullValueRepresentation nullValueRepresentation)
{
switch (nullValueRepresentation)
{
case NullValueRepresentation.DoubleZero:
return(0D);
case NullValueRepresentation.IntZero:
return(0);
case NullValueRepresentation.EmptyString:
return(string.Empty);
case NullValueRepresentation.NullPlaceHolder:
return(Constants.NullValuePlaceholder);
default:
case NullValueRepresentation.Null:
return(null);
}
}
