/// <summary>
/// Get one register using only ID as key.
/// </summary>
/// <returns></returns>
public virtual TagInfo GetValueByID(int TagID)
{
//ToDo: set multiple PK filter
motor.ClearCommandParameters();
motor.CommandText = GetSelectCommand() + GetWherePrimaryKey();
List <DbParameter> paramList = new List <DbParameter>();
DbParameter paramTagID = motor.Command.CreateParameter();
paramTagID.ParameterName = "@param_TagID";
paramTagID.Value = TagID;
paramList.Add(paramTagID);
motor.AddCommandParameters(paramList);
TagInfo InfoValue = new TagInfo();
DbDataReader dbReader = motor.ExecuteReader();
ClassFiller classFiller = new ClassFiller(typeof(TagInfo), dbReader);
using (dbReader)
{
if (dbReader.Read())
{
InfoValue = new TagInfo();
classFiller.Fill(InfoValue);
}
else
{
return(null);
}
}
return(InfoValue);
}
/// <summary>
/// Performs one "select * from MyTable where [InformedProperties]". MinValues and nulls are skipped from filter.
/// </summary>
/// <param name="filter">EmployeeTerritoriesInfo</param>
/// <returns>List of found records.</returns>
public virtual List <EmployeeTerritoriesInfo> GetSome(EmployeeTerritoriesInfo filter)
{
List <EmployeeTerritoriesInfo> AllInfoList = new List <EmployeeTerritoriesInfo>();
string filterWhere = string.Empty;
List <DbParameter> paramList = null;
GenerateWhere(filter, out filterWhere, out paramList);
motor.ClearCommandParameters();
motor.AddCommandParameters(paramList);
motor.CommandText = GetSelectCommand() + " " + filterWhere;
DbDataReader dbReader = motor.ExecuteReader();
ClassFiller classFiller = new ClassFiller(typeof(EmployeeTerritoriesInfo), dbReader);
using (dbReader)
{
while (dbReader.Read())
{
EmployeeTerritoriesInfo EmployeeTerritoriesInfo = new EmployeeTerritoriesInfo();
///Warning: performance issues with this automation. See method description for details.
classFiller.Fill(EmployeeTerritoriesInfo);
AllInfoList.Add(EmployeeTerritoriesInfo);
}
}
return(AllInfoList);
}
/// <summary>
/// Use parameters to apply simple filters
/// </summary>
/// <param name="filterExpression"></param>
/// <returns></returns>
public virtual List <EmployeeTerritoriesInfo> GetAll(List <DataFilterExpressionDB> filterExpression)
{
List <EmployeeTerritoriesInfo> AllInfoList = new List <EmployeeTerritoriesInfo>();
motor.ClearCommandParameters();
motor.CommandText = GetSelectCommand() + " where 1=1 ";
List <DbParameter> paramList = new List <DbParameter>();
string where = "";
foreach (DataFilterExpressionDB filter in filterExpression)
{
DbParameter param = motor.Command.CreateParameter();
param.ParameterName = "@param_" + filter.FieldName;
param.Value = filter.Filter;
param.DbType = HelperDBType.GetDBType(typeof(EmployeeTerritoriesInfo), filter.FieldName);
if (filter.FilterType == DataFilterExpressionDB._FilterType.Equal)
{
param.Value = filter.Filter;
where += string.Format(" and EmployeeTerritories.{0} = {1}", filter.FieldName, param.ParameterName);
}
else
{
param.Value = "%" + filter.Filter + "%";
where += string.Format(" and EmployeeTerritories.{0} like {1}", filter.FieldName, param.ParameterName);
}
paramList.Add(param);
}
motor.CommandText += where;
motor.AddCommandParameters(paramList);
DbDataReader dbReader = motor.ExecuteReader();
ClassFiller classFiller = new ClassFiller(typeof(EmployeeTerritoriesInfo), dbReader);
using (dbReader)
{
while (dbReader.Read())
{
EmployeeTerritoriesInfo classInfo = new EmployeeTerritoriesInfo();
classFiller.Fill(classInfo);
AllInfoList.Add(classInfo);
}
}
return(AllInfoList);
}
/// <summary>
/// Performs one "Select * from MyTable". Use wisely.
/// </summary>
/// <returns>List of found records.</returns>
public virtual List <CustomerDemographicsInfo> GetAll()
{
List <CustomerDemographicsInfo> AllInfoList = new List <CustomerDemographicsInfo>();
motor.CommandText = GetSelectCommand();
DbDataReader dbReader = motor.ExecuteReader();
ClassFiller classFiller = new ClassFiller(typeof(CustomerDemographicsInfo), dbReader);
using (dbReader)
{
while (dbReader.Read())
{
CustomerDemographicsInfo classInfo = new CustomerDemographicsInfo();
classFiller.Fill(classInfo);
AllInfoList.Add(classInfo);
}
}
return(AllInfoList);
}
/// <summary>
/// Same as get all but filter the result set
/// </summary>
/// <param name="numberOfRowsToSkip">Skip first X rows</param>
/// <param name="numberOfRows">Like "TOP" in sql server</param>
/// <returns></returns>
public List <EmployeeTerritoriesInfo> GetAll(int numberOfRowsToSkip, int numberOfRows)
{
List <EmployeeTerritoriesInfo> AllInfoList = new List <EmployeeTerritoriesInfo>();
motor.CommandText = base.GetFilteredRowNumAndSkipQuery("AttributeLists", "id", numberOfRowsToSkip, numberOfRows);
DbDataReader dbReader = motor.ExecuteReader();
ClassFiller classFiller = new ClassFiller(typeof(EmployeeTerritoriesInfo), dbReader);
using (dbReader)
{
while (dbReader.Read())
{
EmployeeTerritoriesInfo classInfo = new EmployeeTerritoriesInfo();
classFiller.Fill(classInfo);
AllInfoList.Add(classInfo);
}
}
return(AllInfoList);
}
/// <summary>
/// Performs one "Select * from MyTable". Use wisely.
/// </summary>
/// <returns>List of found records.</returns>
public virtual List <EmployeeTerritoriesInfo> GetAll()
{
List <EmployeeTerritoriesInfo> AllInfoList = new List <EmployeeTerritoriesInfo>();
motor.CommandText = GetSelectCommand();
DbDataReader dbReader = motor.ExecuteReader();
ClassFiller classFiller = new ClassFiller(typeof(EmployeeTerritoriesInfo), dbReader);
using (dbReader)
{
while (dbReader.Read())
{
EmployeeTerritoriesInfo classInfo = new EmployeeTerritoriesInfo();
classFiller.Fill(classInfo);
AllInfoList.Add(classInfo);
}
}
return(AllInfoList);
}
private void A_string_property_difference(MappingTester<OutputClass> obj)
{
var source = new ClassFiller<InputClass>().Source;
_context.Expected = new OutputClass
{
BooleanProperty = source.BooleanProperty,
IntegerProperty = source.IntegerProperty,
StringProperty = source.StringProperty,
DecimalProperty = source.DecimalProperty,
DateTimeProperty = source.DateTimeProperty
};
_context.Destination = new OutputClass
{
BooleanProperty = _context.Expected.BooleanProperty,
StringProperty = _context.Expected.StringProperty.ToUpper(),
DecimalProperty = _context.Expected.DecimalProperty,
DateTimeProperty = _context.Expected.DateTimeProperty,
IntegerProperty = _context.Expected.IntegerProperty
};
_expectedDifferenceMessage = "StringProperty";
}
private void Get_the_originally_generated_object(ClassFiller<InputClass> obj)
{
ReferenceEquals(_source, _classFiller.Source).ShouldBeTrue();
}
private static void Source_passed_as_object_type(SimpleMapper obj, ObjectSourceContext context)
{
var source = new ClassFiller<InputClass>().Source;
context.Source = source;
context.Expected = new OutputClass
{
BooleanProperty = source.BooleanProperty,
IntegerProperty = source.IntegerProperty,
StringProperty = source.StringProperty,
DecimalProperty = source.DecimalProperty,
DateTimeProperty = source.DateTimeProperty,
DateTimeToNullable = source.DateTimeToNullable
};
context.Destination = new OutputClass();
}
private void Initialize_boolean_properties_with_non_default_values(ClassFiller<InputClass> obj)
{
_source.BooleanProperty.ShouldNotBeEqualTo(default(bool));
}
private static void NHibernate_dynamic_proxy_as_destination(SimpleMapper obj, DynamicDestinationContext context)
{
var source = new ClassFiller<InputClass>().Source;
context.Source = source;
context.Expected = new OutputClass
{
BooleanProperty = source.BooleanProperty,
IntegerProperty = source.IntegerProperty,
StringProperty = source.StringProperty,
DecimalProperty = source.DecimalProperty,
DateTimeProperty = source.DateTimeProperty,
DateTimeToNullable = source.DateTimeToNullable
};
// ReSharper disable once RedundantCast
context.Destination = new DynamicOutputClass();
}
private static void Source_initialized(SourceContext context)
{
var source = new ClassFiller<InputClass>().Source;
context.Source = source;
context.Expected = new OutputClass
{
BooleanProperty = source.BooleanProperty,
IntegerProperty = source.IntegerProperty,
StringProperty = source.StringProperty,
DecimalProperty = 0,
DateTimeProperty = source.DateTimeProperty,
DateTimeToNullable = source.DateTimeToNullable
};
context.Destination = new OutputClass();
}
public void BeforeEachTest()
{
_classFiller = new ClassFiller<InputClass>();
_source = _classFiller.Source;
}
private void The_desired_object_is_created(ClassFiller<InputClass> obj)
{
_source = obj.Source;
}
private void Not_return_a_null_object(ClassFiller<InputClass> obj)
{
_source.ShouldNotBeNull();
}
private void Initialize_string_properties_with_non_default_values(ClassFiller<InputClass> obj)
{
_source.StringProperty.ShouldNotBeEqualTo(default(string));
_source.StringProperty.ShouldNotBeEqualTo("");
}
private void Initialize_integer_properties_with_non_default_values(ClassFiller<InputClass> obj)
{
_source.IntegerProperty.ShouldNotBeEqualTo(default(int));
}
