private void btnSearch_Click(object sender, EventArgs e)
{
var userEntity = new UserEntity();
var queryConditions = new QueryConditionsBuilder();
if (txtTextToSearch.Text != "")
{
queryConditions.AddQueryCondition("name", EConditionTypes.Like, new object[] { "%" + txtTextToSearch.Text + "%" });
}
if (!rbAll.Checked)
{
queryConditions.AddQueryCondition("active", EConditionTypes.Equals, new object[] { rbOnlyActives.Checked ? 1 : 0 });
}
if ((cmbTypeFilter.SelectedIndex != -1) && (txtFilterValue.Text != ""))
{
EConditionTypes conditionType;
if ((string)cmbTypeFilter.SelectedItem == ">")
{
conditionType = EConditionTypes.MoreThan;
}
else if ((string)cmbTypeFilter.SelectedItem == ">=")
{
conditionType = EConditionTypes.MoreThanOrEquals;
}
else if ((string)cmbTypeFilter.SelectedItem == "=")
{
conditionType = EConditionTypes.Equals;
}
else if ((string)cmbTypeFilter.SelectedItem == "!=")
{
conditionType = EConditionTypes.Not;
}
else if ((string)cmbTypeFilter.SelectedItem == "<")
{
conditionType = EConditionTypes.LessThan;
}
else if ((string)cmbTypeFilter.SelectedItem == ">=")
{
conditionType = EConditionTypes.LessThanOrEquals;
}
else
{
conditionType = EConditionTypes.Equals;
}
queryConditions.AddQueryCondition("userId", conditionType, new object[] { txtFilterValue.Text });
}
dgvRegisters.DataSource = ConvORMHelper.ConvertListToDataTable(userEntity.Find(queryConditions));
dgvRegisters.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
public Entity Insert()
{
var commandBuilder = new CommandFactory(_modelEntity, EConnectionDriverTypes.ecdtMySql);
if (_connection.ConnectionDriver()
.ExecuteCommand(commandBuilder.GetSqlInsert(out var parametersValues), parametersValues) > 0)
{
var lastInsertedId = _connection.ConnectionDriver().GetLastInsertedId();
var conditionsBuilder = new QueryConditionsBuilder();
foreach (var column in _modelEntity.GetPrimaryFields())
{
conditionsBuilder.AddQueryCondition(column.ColumnName, EConditionTypes.Equals,
new object[] { lastInsertedId });
}
return(_connection.ConnectionDriver().ExecuteScalarQuery(commandBuilder.GetSqlSelect(conditionsBuilder),
_modelEntity.EntityType));
}
