public static int GetDBInt(string rowKey, DataRow row, string columnName, PropertyExceptionHandler exceptionHandler = null)
{
int retVal = -1;
try { retVal = row[columnName] != DBNull.Value ? Convert.ToInt32(row[columnName]) : -1; } catch (Exception ex) { if (exceptionHandler != null)
{
exceptionHandler.Invoke(rowKey, columnName, ex);
}
}
return(retVal);
}
public static DateTime?GetDBDateTimeNullable(string rowKey, DataRow row, string columnName, PropertyExceptionHandler exceptionHandler = null)
{
DateTime?dt = null;
try { dt = row[columnName] != DBNull.Value ? Convert.ToDateTime(row[columnName]) : (DateTime?)null; } catch (Exception ex) { if (exceptionHandler != null)
{
exceptionHandler.Invoke(rowKey, columnName, ex);
}
}
return(dt);
}
public static decimal GetDBDecimal(string rowKey, DataRow row, string columnName, PropertyExceptionHandler exceptionHandler = null)
{
decimal retVal = 0;
try { retVal = row[columnName] != DBNull.Value ? (!string.IsNullOrEmpty(row[columnName].ToString()) ? Convert.ToDecimal(row[columnName]) : 0) : 0; } catch (Exception ex) { if (exceptionHandler != null)
{
exceptionHandler.Invoke(rowKey, columnName, ex);
}
}
return(retVal);
}
public static string GetDBString(string rowKey, DataRow row, string columnName, PropertyExceptionHandler exceptionHandler = null)
{
string retVal = string.Empty;
try { retVal = row[columnName] != DBNull.Value ? row[columnName].ToString() : string.Empty; } catch (Exception ex) { if (exceptionHandler != null)
{
exceptionHandler.Invoke(rowKey, columnName, ex);
}
}
return(retVal);
}
public static bool GetDBBoolean(string rowKey, DataRow row, string columnName, PropertyExceptionHandler exceptionHandler = null)
{
bool retVal = false;
try { retVal = row[columnName] != DBNull.Value ? Convert.ToBoolean(row[columnName]) : false; } catch (Exception ex) { if (exceptionHandler != null)
{
exceptionHandler.Invoke(rowKey, columnName, ex);
}
}
return(retVal);
}
