protected T FillToObject <T>()
{
try
{
if (typeof(T).FullName.StartsWith("System."))
{
var tmpResult = CurrentCommand.ExecuteScalar();
if (tmpResult == null || Convert.IsDBNull(tmpResult))
{
return(default(T));
}
return((T)Convert.ChangeType(tmpResult, typeof(T)));
}
IDataReader dataReader = CurrentCommand.ExecuteReader();
var result = CBO.Instance.FillObject <T>(dataReader);
if (!dataReader.IsClosed)
{
dataReader.Close();
}
dataReader.Dispose();
return(result);
}
catch (Exception ex)
{
throw new ManagedException(ex.Message, false);
}
}
protected List <T> FillToListTest <T>()
{
DateTime start = DateTime.Now;
IDataReader dataReader = CurrentCommand.ExecuteReader();
DateTime end1 = DateTime.Now;
Debug.Print(String.Format("Elapsed: {0} miliseconds.", (end1 - start).TotalMilliseconds));
List <T> result = CBO.Instance.FillCollection <T>(dataReader);
DateTime end2 = DateTime.Now;
Debug.Print(String.Format("Elapsed: {0} miliseconds.", (end2 - start).TotalMilliseconds));
if (!dataReader.IsClosed)
{
dataReader.Close();
}
dataReader.Dispose();
return(result);
}
protected void FillToCsv(ref string tableName)
{
try
{
IDataReader dataReader = CurrentCommand.ExecuteReader();
CBO.Instance.FillToCsv(dataReader, String.IsNullOrEmpty(tableName), ref tableName);
if (!dataReader.IsClosed)
{
dataReader.Close();
}
dataReader.Dispose();
}
catch (Exception ex)
{
throw new ManagedException(ex.Message, false);
}
}
protected List <T> FillToList <T>()
{
try
{
IDataReader dataReader = CurrentCommand.ExecuteReader();
List <T> result = CBO.Instance.FillCollection <T>(dataReader);
if (!dataReader.IsClosed)
{
dataReader.Close();
}
dataReader.Dispose();
return(result);
}
catch (Exception ex)
{
throw new ManagedException(ex.Message, false);
}
}
