public void TestInsert()
{
var students = StudentHelper.CreateSample(10).ToArray();
using (var sqlConnection = DatabaseHelper.OpenSqlConnection(DatabaseName))
{
var sqlUpserter = new SqlUpserter<Student>(StudentMapper, TableName, students);
sqlUpserter.Execute(sqlConnection);
var selectText = "SELECT " + string.Join(",", StudentMapper.Columns.Select(column => column.Name)) +
" FROM " + TableName;
var reader = new SqlCommand(selectText, sqlConnection).ExecuteReader();
var row = 0;
while (reader.Read())
{
var student = students[row];
for (var column = 0; column < reader.FieldCount; column++)
{
var expected = StudentMapper.GetValueAt(column, student);
var actual = reader.GetValue(column);
Assert.AreEqual(expected, actual);
}
row++;
}
}
}
public DateTime GetDateModifiedUtc(int id, string filename)
{
//this.FireAuthorizeEvent(id);
SqlConnection connectionObj = this.GetConnectionObj();
connectionObj.Open();
DateTime result;
using (connectionObj)
{
SqlDataReader sqlDataReader = new SqlCommand(this.modifiedDateQuery, connectionObj)
{
Parameters =
{
CreateParameter("id", id, SqlDbType.Int),
CreateParameter("name", filename, SqlDbType.NVarChar)
}
}.ExecuteReader();
using (sqlDataReader)
{
if (!sqlDataReader.Read())
{
result = DateTime.MinValue;
return result;
}
for (var i = 0; i < sqlDataReader.FieldCount; i++)
{
if (!sqlDataReader.IsDBNull(i) && sqlDataReader.GetValue(i) is DateTime)
{
result = (DateTime)sqlDataReader.GetValue(i);
return result;
}
}
}
}
return DateTime.MinValue;
}
public void TestUpdate()
{
var students = StudentHelper.CreateSample(10).ToArray();
using (var sqlConnection = DatabaseHelper.OpenSqlConnection(DatabaseName))
{
var sqlUpserter1 = new SqlUpserter<Student>(StudentMapper, TableName, students);
sqlUpserter1.Execute(sqlConnection);
var expectedChanges = 0;
foreach (var student in students)
{
if (student.Id%2 == 0)
{
student.FirstName = student.FirstName + "_Changed";
expectedChanges++;
}
}
var sqlUpserter2 = new SqlUpserter<Student>(StudentMapper, TableName, students);
sqlUpserter2.Execute(sqlConnection);
var selectText = "SELECT " + string.Join(",", StudentMapper.Columns.Select(column => column.Name)) +
" FROM " + TableName;
var reader = new SqlCommand(selectText, sqlConnection).ExecuteReader();
var row = 0;
var currentChanges = 0;
while (reader.Read())
{
var student = students[row];
for (var column = 0; column < reader.FieldCount; column++)
{
var expected = StudentMapper.GetValueAt(column, student);
var actual = reader.GetValue(column);
if (actual.ToString().EndsWith("_Changed"))
{
currentChanges++;
}
Assert.AreEqual(expected, actual);
}
row++;
}
Assert.AreEqual(expectedChanges, currentChanges);
}
}
public virtual object[] getDataAry(string argString)
{
this.rState = 0;
string cmdText = argString;
object[] objArray = null;
try
{
SqlConnection connection = new SqlConnection(this.connStr);
connection.Open();
SqlDataReader reader = new SqlCommand(cmdText, connection).ExecuteReader();
int fieldCount = reader.FieldCount;
object[,] objArray2 = null;
while (reader.Read())
{
objArray2 = new object[fieldCount, 2];
for (int i = 0; i < fieldCount; i++)
{
objArray2[i, 0] = reader.GetName(i);
objArray2[i, 1] = reader.GetValue(i);
}
objArray = cls.mergeAry(objArray, objArray2);
}
reader.Close();
connection.Close();
}
catch (Exception exception)
{
this.rState = 1;
objArray = null;
this.eMessage = exception.Message;
}
return objArray;
}
private void cbOrder_SelectedIndexChanged(object sender, EventArgs e)
{
using (SqlConnection connection = new SqlConnection(MainForm.STRCONN))
{
connection.Open();
OrderBy orderBy = (OrderBy)cbOrderBy.SelectedItem;
string q = String.Format("SELECT Country,League,Season{0} FROM dbo.Leagues ORDER BY {1} {2}",
orderBy.SelectCol == "" ? "" : "," + orderBy.SelectCol, orderBy.OrderCol, cbOrderDir.SelectedItem);
LeaguesKey lKey;
lbLeagues.Items.Clear();
using (SqlDataReader reader = new SqlCommand(q, connection).ExecuteReader())
{
while (reader.Read())
{
lKey = new LeaguesKey();
lKey.Country = reader.GetString(0);
lKey.League = reader.GetString(1);
lKey.Season = reader.GetString(2);
if (reader.FieldCount >= 4) lKey.ExtraCol = reader.GetValue(3);
lbLeagues.Items.Add(lKey);
}
}
}
}