public BaseSqlRepository()
{
Database = new SimpleDataAccess("<Your_App_Connection_String_Name>");
// if for somereason you need to roll your own Sql connection provider
// Database = new SimpleDataAccess(new SimpleSqlConnectionProvider("<Your_App_Connection_String_Name>"));
}
public void TestReadDataTable()
{
var dal = new SimpleDataAccess("Simple");
var dt = dal.ReadSql(@"SELECT * FROM State", null);
Assert.IsNotNull(dt);
Assert.IsTrue(dt.Rows.Count > 0);
}
public void Save_ValidOrder_TheOrderIsPersisted()
{
Order order = new Order { Id = 1, ItemTotal = 100, Total = 110 };
var dataAccess = new SimpleDataAccess();
OrderServices orderProcessor = new OrderServices(dataAccess);
orderProcessor.Save(order);
Assert.AreEqual(order, dataAccess.OrderSaved);
}
public void TestReadDataTableAsync()
{
var dal = new SimpleDataAccess("Simple");
var task = dal.ReadSqlAsync(@"SELECT * FROM STATE", null);
task.Wait();
Assert.IsTrue( task.Result.Rows.Count > 0);
}
public void CalculateTotal_WithCoupon_ReturnLineItemWithDiscount()
{
Order order = new Order { Coupon = "christmas", ItemTotal = 100 };
var dataAccess = new SimpleDataAccess();
dataAccess.CouponPercentage = 10;
OrderServices orderServices = new OrderServices(dataAccess);
var total = orderServices.CalculateTotal(order);
Assert.AreEqual(90, total);
}
public void TestReadDataAccessorAsync()
{
var dal = new SimpleDataAccess("Simple");
var mapper = MapBuilder<State>.BuildAllProperties();
var records = dal.ReadAsync(mapper, @"SELECT * FROM STATE", CommandType.Text, null).Result.ToList();
Assert.IsTrue(records.Any());
Assert.IsTrue(records.Any(x => x.Code.Equals("NC")));
}
public void TestReadDataAccessorAsync()
{
var dal = new SimpleDataAccess("Simple");
var mapper = MapBuilder <State> .BuildAllProperties();
var records = dal.ReadAsync(mapper, @"SELECT * FROM STATE", CommandType.Text, null).Result.ToList();
Assert.IsTrue(records.Any());
Assert.IsTrue(records.Any(x => x.Code.Equals("NC")));
}
public void CalculateTotal_WithCoupon_ReturnLineItemWithDiscount()
{
Order order = new Order {
Coupon = "christmas", ItemTotal = 100
};
var dataAccess = new SimpleDataAccess();
dataAccess.CouponPercentage = 10;
OrderServices orderServices = new OrderServices(dataAccess);
var total = orderServices.CalculateTotal(order);
Assert.AreEqual(90, total);
}
public void TestReadDataAccessorWithParam()
{
var dal = new SimpleDataAccess("Simple");
var mapper = MapBuilder<State>.BuildAllProperties();
var records = dal.Read<State>(mapper, @"SELECT * FROM STATE WHERE Code = @Code", CommandType.Text, new []
{
dal.GetDbParameter("@Code", "NC")
}).ToArray();
Assert.IsTrue(records.Any());
Assert.IsTrue(records.All(x => x.Code.Equals("NC")));
}
public void TestReadDataAccessorWithParam()
{
var dal = new SimpleDataAccess("Simple");
var mapper = MapBuilder <State> .BuildAllProperties();
var records = dal.Read <State>(mapper, @"SELECT * FROM STATE WHERE Code = @Code", CommandType.Text, new []
{
dal.GetDbParameter("@Code", "NC")
}).ToArray();
Assert.IsTrue(records.Any());
Assert.IsTrue(records.All(x => x.Code.Equals("NC")));
}
public int GetRowCount(string table, params WhereClause[] whereClauses)
{
var sql = new SelectQueryBuilder();
sql.SelectColumn("*");
sql.SelectFromTable(table);
whereClauses.ForEach(w => sql.AddWhere(w));
DataTable executeDataTable
= SimpleDataAccess.ExecuteDataTable(cmd => {
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql.BuildQuery();
},
Connection);
return(executeDataTable.Rows.Count);
}
/// <summary>
/// Create the table for the <paramref name="generator"/> supplied.
/// </summary>
/// <remarks>
/// This method is only relevant for generator's that are backed by a table
/// </remarks>
public static void CreateTableFor <T>(INHibernateIdGenerator <T> generator,
IDbConnection openConnection,
Dialect dialect)
{
Check.Require(() => {
Demand.The.Param(() => generator).IsNotNull();
Demand.The.Param(() => openConnection).IsNotNull().IsOpen();
});
TableGenerator gen = CastToTableGenerator(generator);
if (gen == null)
{
throw new ArgumentException("Generator does not support a backing store", "generator");
}
var dropTableSql = gen.SqlDropString(dialect).Join("\n");
SimpleDataAccess.ExecuteSql(dropTableSql, openConnection);
var createIdTableSql = gen.SqlCreateStrings(dialect).Join("\n");
SimpleDataAccess.ExecuteSql(createIdTableSql, openConnection);
}
/// <summary>
/// Default constructor (duh)
/// </summary>
public ValuesController()
{
var connectionString = Environment.GetEnvironmentVariable("DB_CONNECTION_STRING");
_dataAccess = new SimpleDataAccess(connectionString);
}
