public void LoadRow(OleDbDataReader reader)
{
var schema = reader.GetSchemaTable();
foreach (var pi in this.GetType().GetProperties())
{
if (schema.Select("ColumnName='" + pi.Name + "'").Length > 0)
{
var value = reader.GetValue(reader.GetOrdinal(pi.Name));
if (value != null)
pi.SetValue(this, value, null);
}
}
}
protected List<DBItem> GetSubmissionsQueryCallback(OleDbDataReader reader)
{
List<DBItem> returnList = new List<DBItem>();
if (reader.HasRows)
{
while (reader.Read())
{
DBItem item = new DBItem();
item.ID = reader.GetInt32(reader.GetOrdinal("ID"));
item.User = reader.GetString(reader.GetOrdinal("User"));
item.DateTime = reader.GetDateTime(reader.GetOrdinal("DateTime"));
item.Person = reader.GetString(reader.GetOrdinal("Person"));
item.Rating = reader.GetString(reader.GetOrdinal("Rating"));
item.Description = reader.GetString(reader.GetOrdinal("Description"));
item.Votes = reader.GetString(reader.GetOrdinal("Votes"));
returnList.Add(item);
}
}
return returnList;
}
protected List<DBItem> GetVotesQueryCallback(OleDbDataReader reader)
{
List<DBItem> returnList = new List<DBItem> { };
if (reader.HasRows)
{
while (reader.Read())
{
DBItem item = new DBItem();
item.Votes = reader.GetString(reader.GetOrdinal("Votes"));
returnList.Add(item);
}
}
return returnList;
}
//Select by specific column and value
public Angar SelectTask(string tableName, string columnName, string value, string comma)
{
Loader();
string SQL = "SELECT * FROM " + tableName + " WHERE "+columnName+"=" +comma+ value +comma+ ";";
Angar answer;
answer = new Angar();
Reader = Execute(SQL);
while (Reader.Read())
{
Task temp;
temp = new Task();
//DO IT
temp.Body = Reader.GetValue(Reader.GetOrdinal("Body")).ToString();
temp.Header = Reader.GetValue(Reader.GetOrdinal("Header")).ToString();
temp.Worker = Reader.GetValue(Reader.GetOrdinal("Worker")).ToString();
temp.ID = Convert.ToInt64(Reader.GetValue(Reader.GetOrdinal("ID")));
temp.IsDone = (bool)Reader.GetValue(Reader.GetOrdinal("IsDone"));
temp.Date = Convert.ToDateTime(Reader.GetValue(Reader.GetOrdinal("TargetDate")));
answer.Storage.Add(temp);
}
return answer;
}
public Task SelectById(string tableName, long id)
{
string SQL = "SELECT * FROM "+tableName+" WHERE ID="+id.ToString()+" ;";
Reader = Execute(SQL);
Reader.Read();
Task temp;
temp=new Task();
//DO IT
temp.Body = Reader.GetValue(Reader.GetOrdinal("Body")).ToString();
temp.Header = Reader.GetValue(Reader.GetOrdinal("Header")).ToString();
temp.Worker = Reader.GetValue(Reader.GetOrdinal("Worker")).ToString();
temp.ID =Convert.ToInt64( Reader.GetValue(Reader.GetOrdinal("ID")));
temp.IsDone =(bool) Reader.GetValue(Reader.GetOrdinal("IsDone"));
temp.Date =Convert.ToDateTime( Reader.GetValue(Reader.GetOrdinal("TargetDate")));
return temp;
}
public void MinDate()
{
BeginCase("Test Min date.");
exp = null;
string[] dateColumns;
DateTime[] expectedValues;
InitMinDates(out dateColumns, out expectedValues);
try
{
con = new OleDbConnection(ConnectedDataProvider.ConnectionString);
cmd = new OleDbCommand();
cmd.Connection = con;
cmd.CommandText = BuildMinDateTimeSelectSql(dateColumns);
con.Open();
rdr = cmd.ExecuteReader();
Compare(true, rdr.HasRows);
bool b = rdr.Read();
for (int i=0; i<dateColumns.Length && i<expectedValues.Length; i++)
{
int j=-1;
j = rdr.GetOrdinal(dateColumns[i]);
//DateTime result = rdr.GetDateTime(j);
object result = rdr.GetValue(j);
Compare(result, expectedValues[i]);
}
}
catch (Exception ex)
{
exp = ex;
}
finally
{
if (rdr != null && !rdr.IsClosed)
{
rdr.Close();
}
if (con != null && con.State != ConnectionState.Closed)
{
con.Close();
}
EndCase(exp);
}
}
private void Construct(OleDbDataReader oReader, object myobj)
{
PropertyInfo t = null;
object tvalue = new object();
Type myType = myobj.GetType();
ObjectRights objectRights = new ObjectRights();
t = myType.GetProperty("constructing");
t.SetValue(myobj, true, null);
if (oReader.HasRows)
{
List<IntelWebField> tempList;
if (this.selectFieldsList.Count > 0)
{
tempList = this.selectFieldsList;
}
else
{
tempList = this.FieldList;
}
t = myType.GetProperty("isNew");
t.SetValue(myobj, false, null);
foreach (IntelWebField x in tempList)
{
t = myType.GetProperty(x.name);
tvalue = oReader.GetValue(oReader.GetOrdinal(x.name));
if (DBNull.Equals(DBNull.Value, tvalue))
{
tvalue = null;
}
t.SetValue(myobj, tvalue, null);
}
if (_hasPK) { setPK(myobj); }
t = myType.GetProperty("isDirty");
t.SetValue(myobj, false, null);
}
else
{
t = myType.GetProperty("isNew");
t.SetValue(myobj, true, null);
t = myType.GetProperty("isDirty");
t.SetValue(myobj, true, null);
}
PropertyInfo tprop = myType.GetProperty("constructing");
tprop.SetValue(myobj, false, null);
}
