public new int ExecuteNonQuery(string sqlCommand, params DbParameter[] parameters)
{
MockSql info = new MockSql(sqlCommand);
if (sqlCommand.StartsWith("CREATE TABLE " + TableName))
{
RequestTablePresent = true;
}
if (sqlCommand.StartsWith("INSERT "))
{
MockSql.AddRow(table, parameters);
}
if (sqlCommand.StartsWith("UPDATE "))
{
table.Rows[0]["Status"] = 1;
}
if (sqlCommand.StartsWith("DELETE FROM "))
{
DataRow row = table.Rows.Find(parameters[0].Value);
if (row != null)
{
table.Rows.Remove(row);
}
}
return(0);
}
public new DbDataReader ExecuteReader(string sqlCommand, params DbParameter[] parameters)
{
MockSql info = new MockSql(sqlCommand);
if (info.Where != null && info.Where.Length > 0)
{
foreach (DbParameter parameter in parameters)
{
if (parameter.DbType == DbType.String)
{
info.Where = info.Where.Replace("= " + parameter.ParameterName, "= '" + parameter.Value.ToString() + "'");
}
else if (parameter.DbType == DbType.Guid)
{
info.Where = info.Where.Replace("= " + parameter.ParameterName, "= '" + parameter.Value.ToString() + "'");
}
else
{
info.Where = info.Where.Replace(">= " + parameter.ParameterName, ">= " + parameter.Value.ToString());
}
}
DataView view = new DataView(table, info.Where, info.OrderBy, DataViewRowState.CurrentRows);
return(view.ToTable().CreateDataReader());
}
else
{
return(table.CreateDataReader());
}
}
public new object ExecuteScalar(string sqlCommand, params DbParameter[] parameters)
{
MockSql info = new MockSql(sqlCommand);
if (sqlCommand.StartsWith("SELECT Count"))
{
if (info.Where != null && info.Where.Length > 0)
{
DataView view = new DataView(table, info.Where, info.OrderBy, DataViewRowState.CurrentRows);
return(view.Count);
}
else
{
return(table.Rows.Count);
}
}
return(0);
}
