/// <summary>
/// Deep load all SalesTaxRate children.
/// </summary>
private void Step_03_DeepLoad_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
int count = -1;
mock = CreateMockInstance(tm);
mockCollection = DataRepository.SalesTaxRateProvider.GetPaged(tm, 0, 10, out count);
DataRepository.SalesTaxRateProvider.DeepLoading += new EntityProviderBaseCore <SalesTaxRate, SalesTaxRateKey> .DeepLoadingEventHandler(
delegate(object sender, DeepSessionEventArgs e)
{
if (e.DeepSession.Count > 3)
{
e.Cancel = true;
}
}
);
if (mockCollection.Count > 0)
{
DataRepository.SalesTaxRateProvider.DeepLoad(tm, mockCollection[0]);
System.Console.WriteLine("SalesTaxRate instance correctly deep loaded at 1 level.");
mockCollection.Add(mock);
// DataRepository.SalesTaxRateProvider.DeepSave(tm, mockCollection);
}
//normally one would commit here
//tm.Commit();
//IDisposable will Rollback Transaction since it's left uncommitted
}
}
/// <summary>
/// Test Find using the Query class
/// </summary>
private void Step_30_TestFindByQuery_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
//Insert Mock Instance
SalesTaxRate mock = CreateMockInstance(tm);
bool result = DataRepository.SalesTaxRateProvider.Insert(tm, mock);
Assert.IsTrue(result, "Could Not Test FindByQuery, Insert Failed");
SalesTaxRateQuery query = new SalesTaxRateQuery();
query.AppendEquals(SalesTaxRateColumn.SalesTaxRateId, mock.SalesTaxRateId.ToString());
query.AppendEquals(SalesTaxRateColumn.StateProvinceId, mock.StateProvinceId.ToString());
query.AppendEquals(SalesTaxRateColumn.TaxType, mock.TaxType.ToString());
query.AppendEquals(SalesTaxRateColumn.TaxRate, mock.TaxRate.ToString());
query.AppendEquals(SalesTaxRateColumn.Name, mock.Name.ToString());
query.AppendEquals(SalesTaxRateColumn.Rowguid, mock.Rowguid.ToString());
query.AppendEquals(SalesTaxRateColumn.ModifiedDate, mock.ModifiedDate.ToString());
TList <SalesTaxRate> results = DataRepository.SalesTaxRateProvider.Find(tm, query);
Assert.IsTrue(results.Count == 1, "Find is not working correctly. Failed to find the mock instance");
}
}
public SalesTaxRate GetSalesTaxRate(int SalesTaxRateID)
{
IDBManager dbm = new DBManager();
SalesTaxRate STR = new SalesTaxRate();
try
{
dbm.CreateParameters(1);
dbm.AddParameters(0, "@SalesTaxRateID", SalesTaxRateID);
IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSalesTaxRate");
while (reader.Read())
{
STR.SalesTaxRateID = Int32.Parse(reader["SalesTaxRateID"].ToString());
STR.StateProvinceID = reader["StateProvinceID"].ToString();
STR.TaxType = Byte.Parse(reader["TaxType"].ToString());
STR.TaxRate = Decimal.Parse(reader["TaxRate"].ToString());
STR.Name = reader["Name"].ToString();
STR.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString());
}
}
catch (Exception ex)
{
log.Write(ex.Message, "GetSalesTaxRate");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(STR);
}
public SalesTaxRateCollection GetAllSalesTaxRatesCollection()
{
IDBManager dbm = new DBManager();
SalesTaxRateCollection cols = new SalesTaxRateCollection();
try
{
IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSalesTaxRateAll");
while (reader.Read())
{
SalesTaxRate STR = new SalesTaxRate();
STR.SalesTaxRateID = Int32.Parse(reader["SalesTaxRateID"].ToString());
STR.StateProvinceID = reader["StateProvinceID"].ToString();
STR.TaxType = Byte.Parse(reader["TaxType"].ToString());
STR.TaxRate = Decimal.Parse(reader["TaxRate"].ToString());
STR.Name = reader["Name"].ToString();
STR.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString());
cols.Add(STR);
}
}
catch (Exception ex)
{
log.Write(ex.Message, "GetAllSalesTaxRatesCollection");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(cols);
}
public bool UpdateSalesTaxRate(SalesTaxRate STR)
{
IDBManager dbm = new DBManager();
try
{
dbm.CreateParameters(6);
dbm.AddParameters(0, "@SalesTaxRateID", STR.SalesTaxRateID);
dbm.AddParameters(1, "@StateProvinceID", STR.StateProvinceID);
dbm.AddParameters(2, "@TaxType", STR.TaxType);
dbm.AddParameters(3, "@TaxRate", STR.TaxRate);
dbm.AddParameters(4, "@Name", STR.Name);
dbm.AddParameters(5, "@ModifiedDate", DateTime.Now);
dbm.ExecuteNonQuery(CommandType.StoredProcedure, "UpdateSalesTaxRate");
}
catch (Exception ex)
{
log.Write(ex.Message, "UpdateSalesTaxRate");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(true);
}
public SalesTaxRateCollection GetAllSalesTaxRatesDynamicCollection(string whereExpression, string orderBy)
{
IDBManager dbm = new DBManager();
SalesTaxRateCollection cols = new SalesTaxRateCollection();
try
{
dbm.CreateParameters(2);
dbm.AddParameters(0, "@WhereCondition", whereExpression);
dbm.AddParameters(1, "@OrderByExpression", orderBy);
IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSalesTaxRatesDynamic");
while (reader.Read())
{
SalesTaxRate STR = new SalesTaxRate();
STR.SalesTaxRateID = Int32.Parse(reader["SalesTaxRateID"].ToString());
STR.StateProvinceID = reader["StateProvinceID"].ToString();
STR.TaxType = Byte.Parse(reader["TaxType"].ToString());
STR.TaxRate = Decimal.Parse(reader["TaxRate"].ToString());
STR.Name = reader["Name"].ToString();
STR.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString());
cols.Add(STR);
}
}
catch (Exception ex)
{
log.Write(ex.Message, "GetAllSalesTaxRatesDynamicCollection");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(cols);
}
public int AddSalesTaxRate(SalesTaxRate STR)
{
IDBManager dbm = new DBManager();
try
{
dbm.CreateParameters(6);
dbm.AddParameters(0, "@StateProvinceID", STR.StateProvinceID);
dbm.AddParameters(1, "@TaxType", STR.TaxType);
dbm.AddParameters(2, "@TaxRate", STR.TaxRate);
dbm.AddParameters(3, "@Name", STR.Name);
dbm.AddParameters(4, "@ModifiedDate", DateTime.Now);
dbm.AddParameters(5, "@SalesTaxRateID", STR.SalesTaxRateID);
dbm.Parameters[5].Direction = ParameterDirection.Output;
dbm.ExecuteNonQuery(CommandType.StoredProcedure, "InsertSalesTaxRate");
STR.SalesTaxRateID = Int32.Parse(dbm.Parameters[5].Value.ToString());
}
catch (Exception ex)
{
log.Write(ex.Message, "InsertSalesTaxRate");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(STR.SalesTaxRateID);
}
///<summary>
/// Update the Typed SalesTaxRate Entity with modified mock values.
///</summary>
static public void UpdateMockInstance(TransactionManager tm, SalesTaxRate mock)
{
SalesTaxRateTest.UpdateMockInstance_Generated(tm, mock);
// make any alterations necessary
// (i.e. for DB check constraints, special test cases, etc.)
SetSpecialTestData(mock);
}
public void CreatePriceIncludingTax()
{
var priceExcludingTax = new PriceExcludingTax(1000);
var salesTaxRate = new SalesTaxRate(0.1M);
var priceIncludingTax = priceExcludingTax.Multi(salesTaxRate);
Assert.Equal(1100, priceIncludingTax.Value);
}
/// <summary>
/// Test methods exposed by the EntityHelper class.
/// </summary>
private void Step_20_TestEntityHelper_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
mock = CreateMockInstance(tm);
SalesTaxRate entity = mock.Copy() as SalesTaxRate;
entity = (SalesTaxRate)mock.Clone();
Assert.IsTrue(SalesTaxRate.ValueEquals(entity, mock), "Clone is not working");
}
}
public void CreatePriceIncludingTax()
{
var priceExcludingTax = new PriceExcludingTax(1000);
var salesTaxRate = new SalesTaxRate(0.1M);
var priceIncludingTax = PriceIncludingTax.From(priceExcludingTax, salesTaxRate);
// or var priceIncludingTax = new PriceIncludingTax(priceExcludingTax, salesTaxRate);
Assert.Equal(1100, priceIncludingTax.Value);
}
// PUT api/awbuildversion/5
public void Put(SalesTaxRate value)
{
var GetActionType = Request.Headers.Where(x => x.Key.Equals("ActionType")).FirstOrDefault();
if (GetActionType.Key != null)
{
if (GetActionType.Value.ToList()[0].Equals("DELETE"))
adventureWorks_BC.SalesTaxRateDelete(value);
if (GetActionType.Value.ToList()[0].Equals("UPDATE"))
adventureWorks_BC.SalesTaxRateUpdate(value);
}
}
///<summary>
/// Returns a Typed SalesTaxRate Entity with mock values.
///</summary>
static public SalesTaxRate CreateMockInstance(TransactionManager tm)
{
// get the default mock instance
SalesTaxRate mock = SalesTaxRateTest.CreateMockInstance_Generated(tm);
// make any alterations necessary
// (i.e. for DB check constraints, special test cases, etc.)
SetSpecialTestData(mock);
// return the modified object
return(mock);
}
/// <summary>
/// Check the foreign key dal methods.
/// </summary>
private void Step_10_FK_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
SalesTaxRate entity = CreateMockInstance(tm);
bool result = DataRepository.SalesTaxRateProvider.Insert(tm, entity);
Assert.IsTrue(result, "Could Not Test FK, Insert Failed");
TList <SalesTaxRate> t0 = DataRepository.SalesTaxRateProvider.GetByStateProvinceId(tm, entity.StateProvinceId, 0, 10);
}
}
///<summary>
/// Update the Typed SalesTaxRate Entity with modified mock values.
///</summary>
static public void UpdateMockInstance_Generated(TransactionManager tm, SalesTaxRate mock)
{
mock.TaxType = TestUtility.Instance.RandomByte();
mock.TaxRate = TestUtility.Instance.RandomShort();
mock.Name = TestUtility.Instance.RandomString(24, false);;
mock.ModifiedDate = TestUtility.Instance.RandomDateTime();
//OneToOneRelationship
StateProvince mockStateProvinceByStateProvinceId = StateProvinceTest.CreateMockInstance(tm);
DataRepository.StateProvinceProvider.Insert(tm, mockStateProvinceByStateProvinceId);
mock.StateProvinceId = mockStateProvinceByStateProvinceId.StateProvinceId;
}
private async Task <bool> BeUniqueByStateProvinceIDTaxType(ApiSalesTaxRateRequestModel model, CancellationToken cancellationToken)
{
SalesTaxRate record = await this.salesTaxRateRepository.ByStateProvinceIDTaxType(model.StateProvinceID, model.TaxType);
if (record == null || (this.existingRecordId != default(int) && record.SalesTaxRateID == this.existingRecordId))
{
return(true);
}
else
{
return(false);
}
}
public async Task <ApiSalesTaxRateResponseModel> ByStateProvinceIDTaxType(int stateProvinceID, int taxType)
{
SalesTaxRate record = await this.SalesTaxRateRepository.ByStateProvinceIDTaxType(stateProvinceID, taxType);
if (record == null)
{
return(null);
}
else
{
return(this.BolSalesTaxRateMapper.MapBOToModel(this.DalSalesTaxRateMapper.MapEFToBO(record)));
}
}
public void GetPriceWithTaxIncluded_ProductIsTaxed_ReturnPriceWithTax()
{
// Arrange
var salesTaxRate = new SalesTaxRate();
var basicSalesTaxCalculator = new BasicSalesTaxCalculator(salesTaxRate);
var item = new ShoppingBasketItem(new Product("Other", ProductType.Other), 99.99m, false, basicSalesTaxCalculator);
// Act
var result = basicSalesTaxCalculator.GetPriceWithTaxIncluded(item);
// Assert
Assert.AreEqual(result, 109.99m);
}
public void GetPriceWithTaxIncluded_ProductIsExempt_ReturnPrice()
{
// Arrange
var salesTaxRate = new SalesTaxRate();
var basicSalesTaxCalculator = new BasicSalesTaxCalculator(salesTaxRate);
var item = new ShoppingBasketItem(new Product("Coffee", ProductType.Coffee), 11.50m, false, basicSalesTaxCalculator);
// Act
var result = basicSalesTaxCalculator.GetPriceWithTaxIncluded(item);
// Assert
Assert.AreEqual(result, 11.50m);
}
/// <summary>
/// Serialize the mock SalesTaxRate entity into a temporary file.
/// </summary>
private void Step_06_SerializeEntity_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
mock = CreateMockInstance(tm);
string fileName = System.IO.Path.Combine(System.IO.Path.GetTempPath(), "temp_SalesTaxRate.xml");
EntityHelper.SerializeXml(mock, fileName);
Assert.IsTrue(System.IO.File.Exists(fileName), "Serialized mock not found");
System.Console.WriteLine("mock correctly serialized to a temporary file.");
}
}
public void GetSalesTaxAmount_ProductTypeIsCoffee_ReturnZero()
{
// Arrange
var salesTaxRate = new SalesTaxRate();
var basicSalesTaxCalculator = new BasicSalesTaxCalculator(salesTaxRate);
var item = new ShoppingBasketItem(new Product("Coffee", ProductType.Coffee), 1, false, basicSalesTaxCalculator);
// Act
var result = basicSalesTaxCalculator.GetSalesTaxAmount(item);
// Assert
Assert.AreEqual(result, 0);
}
public void GetSalesTaxAmount_ItemIsImported_ReturnTaxAmt()
{
// Arrange
var salesTaxRate = new SalesTaxRate();
var importDutySalesTaxCalculator = new ImportDutySalesTaxCalculator(salesTaxRate);
var item = new ShoppingBasketItem(new Product("Candy", ProductType.Candy), 1, true, importDutySalesTaxCalculator);
// Act
var result = importDutySalesTaxCalculator.GetSalesTaxAmount(item);
// Assert
Assert.AreNotEqual(result, 0);
}
public void GetPriceWithTaxIncluded_ProductIsImported_ReturnPriceWithTax()
{
// Arrange
var salesTaxRate = new SalesTaxRate();
var importDutySalesTaxCalculator = new ImportDutySalesTaxCalculator(salesTaxRate);
var item = new ShoppingBasketItem(new Product("Coffee", ProductType.Coffee), 11.00m, true, importDutySalesTaxCalculator);
// Act
var result = importDutySalesTaxCalculator.GetPriceWithTaxIncluded(item);
// Assert
Assert.AreEqual(result, 11.55m);
}
public void GetSalesTaxAmount_ProductTypeIsOther_ReturnTaxAmt()
{
// Arrange
var salesTaxRate = new SalesTaxRate();
var basicSalesTaxCalculator = new BasicSalesTaxCalculator(salesTaxRate);
var item = new ShoppingBasketItem(new Product("Other", ProductType.Other), 1, false, basicSalesTaxCalculator);
// Act
var result = basicSalesTaxCalculator.GetSalesTaxAmount(item);
// Assert
Assert.AreNotEqual(result, 0);
}
public bool SalesTaxRateDelete(SalesTaxRate salestaxrate)
{
return(Execute <bool>(dal =>
{
SalesTaxRate salestaxrateDelete = dal.SalesTaxRate.Where(x => x.SalesTaxRateID == salestaxrate.SalesTaxRateID).FirstOrDefault();
if (salestaxrateDelete != null)
{
dal.SalesTaxRate.DeleteOnSubmit(salestaxrateDelete);
dal.SubmitChanges();
return true;
}
return false;
}));
}
public void MapEFToBOList()
{
var mapper = new DALSalesTaxRateMapper();
SalesTaxRate entity = new SalesTaxRate();
entity.SetProperties(DateTime.Parse("1/1/1987 12:00:00 AM"), "A", Guid.Parse("8420cdcf-d595-ef65-66e7-dff9f98764da"), 1, 1, 1m, 1);
List <BOSalesTaxRate> response = mapper.MapEFToBO(new List <SalesTaxRate>()
{
entity
});
response.Count.Should().Be(1);
}
public virtual BOSalesTaxRate MapEFToBO(
SalesTaxRate ef)
{
var bo = new BOSalesTaxRate();
bo.SetProperties(
ef.SalesTaxRateID,
ef.ModifiedDate,
ef.Name,
ef.Rowguid,
ef.StateProvinceID,
ef.TaxRate,
ef.TaxType);
return(bo);
}
public virtual SalesTaxRate MapBOToEF(
BOSalesTaxRate bo)
{
SalesTaxRate efSalesTaxRate = new SalesTaxRate();
efSalesTaxRate.SetProperties(
bo.ModifiedDate,
bo.Name,
bo.Rowguid,
bo.SalesTaxRateID,
bo.StateProvinceID,
bo.TaxRate,
bo.TaxType);
return(efSalesTaxRate);
}
/// <summary>
/// Check the indexes dal methods.
/// </summary>
private void Step_11_IX_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
SalesTaxRate entity = CreateMockInstance(tm);
bool result = DataRepository.SalesTaxRateProvider.Insert(tm, entity);
Assert.IsTrue(result, "Could Not Test IX, Insert Failed");
SalesTaxRate t0 = DataRepository.SalesTaxRateProvider.GetByRowguid(tm, entity.Rowguid);
SalesTaxRate t1 = DataRepository.SalesTaxRateProvider.GetByStateProvinceIdTaxType(tm, entity.StateProvinceId, entity.TaxType);
SalesTaxRate t2 = DataRepository.SalesTaxRateProvider.GetBySalesTaxRateId(tm, entity.SalesTaxRateId);
}
}
/// <summary>
/// Inserts a mock SalesTaxRate entity into the database.
/// </summary>
private void Step_01_Insert_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
mock = CreateMockInstance(tm);
Assert.IsTrue(DataRepository.SalesTaxRateProvider.Insert(tm, mock), "Insert failed");
System.Console.WriteLine("DataRepository.SalesTaxRateProvider.Insert(mock):");
System.Console.WriteLine(mock);
//normally one would commit here
//tm.Commit();
//IDisposable will Rollback Transaction since it's left uncommitted
}
}
// PUT api/awbuildversion/5
public void Put(SalesTaxRate value)
{
var GetActionType = Request.Headers.Where(x => x.Key.Equals("ActionType")).FirstOrDefault();
if (GetActionType.Key != null)
{
if (GetActionType.Value.ToList()[0].Equals("DELETE"))
{
adventureWorks_BC.SalesTaxRateDelete(value);
}
if (GetActionType.Value.ToList()[0].Equals("UPDATE"))
{
adventureWorks_BC.SalesTaxRateUpdate(value);
}
}
}
/// <summary>
/// Create a new SalesTaxRate object.
/// </summary>
/// <param name="salesTaxRateID">Initial value of SalesTaxRateID.</param>
/// <param name="taxType">Initial value of TaxType.</param>
/// <param name="taxRate">Initial value of TaxRate.</param>
/// <param name="name">Initial value of Name.</param>
/// <param name="rowguid">Initial value of rowguid.</param>
/// <param name="modifiedDate">Initial value of ModifiedDate.</param>
public static SalesTaxRate CreateSalesTaxRate(int salesTaxRateID, byte taxType, decimal taxRate, string name, global::System.Guid rowguid, global::System.DateTime modifiedDate)
{
SalesTaxRate salesTaxRate = new SalesTaxRate();
salesTaxRate.SalesTaxRateID = salesTaxRateID;
salesTaxRate.TaxType = taxType;
salesTaxRate.TaxRate = taxRate;
salesTaxRate.Name = name;
salesTaxRate.rowguid = rowguid;
salesTaxRate.ModifiedDate = modifiedDate;
return salesTaxRate;
}
// POST api/awbuildversion
public void Post(SalesTaxRate value)
{
adventureWorks_BC.SalesTaxRateAdd(value);
}
/// <summary>
/// There are no comments for SalesTaxRate in the schema.
/// </summary>
public void AddToSalesTaxRate(SalesTaxRate salesTaxRate)
{
base.AddObject("SalesTaxRate", salesTaxRate);
}
