///<summary>
/// Returns a Typed SalesOrderHeaderSalesReason Entity with mock values.
///</summary>
static public SalesOrderHeaderSalesReason CreateMockInstance_Generated(TransactionManager tm)
{
SalesOrderHeaderSalesReason mock = new SalesOrderHeaderSalesReason();
mock.ModifiedDate = TestUtility.Instance.RandomDateTime();
//OneToOneRelationship
SalesOrderHeader mockSalesOrderHeaderBySalesOrderId = SalesOrderHeaderTest.CreateMockInstance(tm);
DataRepository.SalesOrderHeaderProvider.Insert(tm, mockSalesOrderHeaderBySalesOrderId);
mock.SalesOrderId = mockSalesOrderHeaderBySalesOrderId.SalesOrderId;
//OneToOneRelationship
SalesReason mockSalesReasonBySalesReasonId = SalesReasonTest.CreateMockInstance(tm);
DataRepository.SalesReasonProvider.Insert(tm, mockSalesReasonBySalesReasonId);
mock.SalesReasonId = mockSalesReasonBySalesReasonId.SalesReasonId;
// create a temporary collection and add the item to it
TList <SalesOrderHeaderSalesReason> tempMockCollection = new TList <SalesOrderHeaderSalesReason>();
tempMockCollection.Add(mock);
tempMockCollection.Remove(mock);
return((SalesOrderHeaderSalesReason)mock);
}
/// <summary>
/// Deep load all SalesReason children.
/// </summary>
private void Step_03_DeepLoad_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
int count = -1;
mock = CreateMockInstance(tm);
mockCollection = DataRepository.SalesReasonProvider.GetPaged(tm, 0, 10, out count);
DataRepository.SalesReasonProvider.DeepLoading += new EntityProviderBaseCore <SalesReason, SalesReasonKey> .DeepLoadingEventHandler(
delegate(object sender, DeepSessionEventArgs e)
{
if (e.DeepSession.Count > 3)
{
e.Cancel = true;
}
}
);
if (mockCollection.Count > 0)
{
DataRepository.SalesReasonProvider.DeepLoad(tm, mockCollection[0]);
System.Console.WriteLine("SalesReason instance correctly deep loaded at 1 level.");
mockCollection.Add(mock);
// DataRepository.SalesReasonProvider.DeepSave(tm, mockCollection);
}
//normally one would commit here
//tm.Commit();
//IDisposable will Rollback Transaction since it's left uncommitted
}
}
///<summary>
/// Update the Typed SalesReason Entity with modified mock values.
///</summary>
static public void UpdateMockInstance(TransactionManager tm, SalesReason mock)
{
SalesReasonTest.UpdateMockInstance_Generated(tm, mock);
// make any alterations necessary
// (i.e. for DB check constraints, special test cases, etc.)
SetSpecialTestData(mock);
}
/// <summary>
/// Check the foreign key dal methods.
/// </summary>
private void Step_10_FK_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
SalesReason entity = CreateMockInstance(tm);
bool result = DataRepository.SalesReasonProvider.Insert(tm, entity);
Assert.IsTrue(result, "Could Not Test FK, Insert Failed");
}
}
public SalesReasonBuilder WithTestValues()
{
salesReason = new SalesReason
{
Name = "Price",
ReasonType = "Other"
};
return(this);
}
/// <summary>
/// Test methods exposed by the EntityHelper class.
/// </summary>
private void Step_20_TestEntityHelper_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
mock = CreateMockInstance(tm);
SalesReason entity = mock.Copy() as SalesReason;
entity = (SalesReason)mock.Clone();
Assert.IsTrue(SalesReason.ValueEquals(entity, mock), "Clone is not working");
}
}
public virtual BOSalesReason MapEFToBO(
SalesReason ef)
{
var bo = new BOSalesReason();
bo.SetProperties(
ef.SalesReasonID,
ef.ModifiedDate,
ef.Name,
ef.ReasonType);
return(bo);
}
///<summary>
/// Returns a Typed SalesReason Entity with mock values.
///</summary>
static public SalesReason CreateMockInstance(TransactionManager tm)
{
// get the default mock instance
SalesReason mock = SalesReasonTest.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);
}
public virtual SalesReason MapBOToEF(
BOSalesReason bo)
{
SalesReason efSalesReason = new SalesReason();
efSalesReason.SetProperties(
bo.ModifiedDate,
bo.Name,
bo.ReasonType,
bo.SalesReasonID);
return(efSalesReason);
}
/// <summary>
/// Serialize the mock SalesReason 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_SalesReason.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.");
}
}
//Commit Button Actions
protected void CommitButton_Click(object sender, EventArgs e)
{
saleName = NameTextbox.Text;
reasonType = SaleReasonTextbox.Text;
//Validation
if (NameTextbox.Text == "" | NameTextbox.Text == " " | NameTextbox.Text == null)
{
MessageBox.Show("Please enter sale name!");
return;
}
if (SaleReasonTextbox.Text == "" | SaleReasonTextbox.Text == " " | NameTextbox.Text == null)
{
MessageBox.Show("Please enter a sale reason!");
return;
}
//Check to see if a certain name exists in the DB
SqlCommand command;
sc.Open();
command = new SqlCommand("SELECT COUNT(*) FROM [AdventureWorks2014].[Sales].[SalesReason] WHERE [Name] = @Name", sc);
command.Parameters.AddWithValue("@Name", HttpUtility.HtmlEncode(NameTextbox.Text));
int ReasonExist = (int)command.ExecuteScalar();
sc.Close();
if (ReasonExist > 0)
{
MessageBox.Show("This reason already exists");
}
else
{
SalesReason salesReason = new SalesReason(SalesReasonID, saleName, reasonType);
//Open database connection
sc.Open();
System.Data.SqlClient.SqlCommand insert = new System.Data.SqlClient.SqlCommand();
insert.Connection = sc;
insert.CommandText = "INSERT INTO SALES.SALESREASON VALUES (@Name,@ReasonType,@ModifiedDate); SELECT SCOPE_IDENTITY()";
insert.Parameters.Add(new SqlParameter("@Name", salesReason.getSaleName()));
insert.Parameters.Add(new SqlParameter("@ReasonType", salesReason.getReasonType()));
insert.Parameters.Add(new SqlParameter("@ModifiedDate", salesReason.getModifiedDate()));
insert.ExecuteNonQuery();
//Closes Connection
sc.Close();
UpdatedLabel.Text = "Modified Date: " + salesReason.getModifiedDate();
}
}
public void MapBOToEF()
{
var mapper = new DALSalesReasonMapper();
var bo = new BOSalesReason();
bo.SetProperties(1, DateTime.Parse("1/1/1987 12:00:00 AM"), "A", "A");
SalesReason response = mapper.MapBOToEF(bo);
response.ModifiedDate.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM"));
response.Name.Should().Be("A");
response.ReasonType.Should().Be("A");
response.SalesReasonID.Should().Be(1);
}
public void MapEFToBO()
{
var mapper = new DALSalesReasonMapper();
SalesReason entity = new SalesReason();
entity.SetProperties(DateTime.Parse("1/1/1987 12:00:00 AM"), "A", "A", 1);
BOSalesReason response = mapper.MapEFToBO(entity);
response.ModifiedDate.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM"));
response.Name.Should().Be("A");
response.ReasonType.Should().Be("A");
response.SalesReasonID.Should().Be(1);
}
public bool SalesReasonDelete(SalesReason salesreason)
{
return(Execute <bool>(dal =>
{
SalesReason salesreasonDelete = dal.SalesReason.Where(x => x.SalesReasonID == salesreason.SalesReasonID).FirstOrDefault();
if (salesreasonDelete != null)
{
dal.SalesReason.DeleteOnSubmit(salesreasonDelete);
dal.SubmitChanges();
return true;
}
return false;
}));
}
public void MapEFToBOList()
{
var mapper = new DALSalesReasonMapper();
SalesReason entity = new SalesReason();
entity.SetProperties(DateTime.Parse("1/1/1987 12:00:00 AM"), "A", "A", 1);
List <BOSalesReason> response = mapper.MapEFToBO(new List <SalesReason>()
{
entity
});
response.Count.Should().Be(1);
}
/// <summary>
/// Inserts a mock SalesReason entity into the database.
/// </summary>
private void Step_01_Insert_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
mock = CreateMockInstance(tm);
Assert.IsTrue(DataRepository.SalesReasonProvider.Insert(tm, mock), "Insert failed");
System.Console.WriteLine("DataRepository.SalesReasonProvider.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(SalesReason 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.SalesReasonDelete(value);
}
if (GetActionType.Value.ToList()[0].Equals("UPDATE"))
{
adventureWorks_BC.SalesReasonUpdate(value);
}
}
}
/// <summary>
/// Serialize a SalesReason collection into a temporary file.
/// </summary>
private void Step_08_SerializeCollection_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
string fileName = System.IO.Path.Combine(System.IO.Path.GetTempPath(), "temp_SalesReasonCollection.xml");
mock = CreateMockInstance(tm);
TList <SalesReason> mockCollection = new TList <SalesReason>();
mockCollection.Add(mock);
EntityHelper.SerializeXml(mockCollection, fileName);
Assert.IsTrue(System.IO.File.Exists(fileName), "Serialized mock collection not found");
System.Console.WriteLine("TList<SalesReason> correctly serialized to a temporary file.");
}
}
///<summary>
/// Update the Typed SalesOrderHeaderSalesReason Entity with modified mock values.
///</summary>
static public void UpdateMockInstance_Generated(TransactionManager tm, SalesOrderHeaderSalesReason mock)
{
mock.ModifiedDate = TestUtility.Instance.RandomDateTime();
//OneToOneRelationship
SalesOrderHeader mockSalesOrderHeaderBySalesOrderId = SalesOrderHeaderTest.CreateMockInstance(tm);
DataRepository.SalesOrderHeaderProvider.Insert(tm, mockSalesOrderHeaderBySalesOrderId);
mock.SalesOrderId = mockSalesOrderHeaderBySalesOrderId.SalesOrderId;
//OneToOneRelationship
SalesReason mockSalesReasonBySalesReasonId = SalesReasonTest.CreateMockInstance(tm);
DataRepository.SalesReasonProvider.Insert(tm, mockSalesReasonBySalesReasonId);
mock.SalesReasonId = mockSalesReasonBySalesReasonId.SalesReasonId;
}
public async void Get()
{
var mock = new ServiceMockFacade <ISalesReasonRepository>();
var record = new SalesReason();
mock.RepositoryMock.Setup(x => x.Get(It.IsAny <int>())).Returns(Task.FromResult(record));
var service = new SalesReasonService(mock.LoggerMock.Object,
mock.RepositoryMock.Object,
mock.ModelValidatorMockFactory.SalesReasonModelValidatorMock.Object,
mock.BOLMapperMockFactory.BOLSalesReasonMapperMock,
mock.DALMapperMockFactory.DALSalesReasonMapperMock);
ApiSalesReasonResponseModel response = await service.Get(default(int));
response.Should().NotBeNull();
mock.RepositoryMock.Verify(x => x.Get(It.IsAny <int>()));
}
public bool SalesReasonUpdate(SalesReason salesreason)
{
return(Execute <bool>(dal =>
{
SalesReason salesreasonUpdate = dal.SalesReason.Where(x => x.SalesReasonID == salesreason.SalesReasonID).FirstOrDefault();
if (salesreasonUpdate != null)
{
salesreasonUpdate.SalesReasonID = salesreason.SalesReasonID;
salesreasonUpdate.Name = salesreason.Name;
salesreasonUpdate.ReasonType = salesreason.ReasonType;
salesreasonUpdate.ModifiedDate = salesreason.ModifiedDate;
dal.SubmitChanges();
return true;
}
return false;
}));
}
///<summary>
/// Returns a Typed SalesReason Entity with mock values.
///</summary>
static public SalesReason CreateMockInstance_Generated(TransactionManager tm)
{
SalesReason mock = new SalesReason();
mock.Name = TestUtility.Instance.RandomString(24, false);;
mock.ReasonType = TestUtility.Instance.RandomString(24, false);;
mock.ModifiedDate = TestUtility.Instance.RandomDateTime();
// create a temporary collection and add the item to it
TList <SalesReason> tempMockCollection = new TList <SalesReason>();
tempMockCollection.Add(mock);
tempMockCollection.Remove(mock);
return((SalesReason)mock);
}
/// <summary>
/// Test Find using the Query class
/// </summary>
private void Step_30_TestFindByQuery_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
//Insert Mock Instance
SalesReason mock = CreateMockInstance(tm);
bool result = DataRepository.SalesReasonProvider.Insert(tm, mock);
Assert.IsTrue(result, "Could Not Test FindByQuery, Insert Failed");
SalesReasonQuery query = new SalesReasonQuery();
query.AppendEquals(SalesReasonColumn.SalesReasonId, mock.SalesReasonId.ToString());
query.AppendEquals(SalesReasonColumn.Name, mock.Name.ToString());
query.AppendEquals(SalesReasonColumn.ReasonType, mock.ReasonType.ToString());
query.AppendEquals(SalesReasonColumn.ModifiedDate, mock.ModifiedDate.ToString());
TList <SalesReason> results = DataRepository.SalesReasonProvider.Find(tm, query);
Assert.IsTrue(results.Count == 1, "Find is not working correctly. Failed to find the mock instance");
}
}
/// <summary>
/// Create a new SalesReason object.
/// </summary>
/// <param name="salesReasonID">Initial value of SalesReasonID.</param>
/// <param name="name">Initial value of Name.</param>
/// <param name="reasonType">Initial value of ReasonType.</param>
/// <param name="modifiedDate">Initial value of ModifiedDate.</param>
public static SalesReason CreateSalesReason(int salesReasonID, string name, string reasonType, global::System.DateTime modifiedDate)
{
SalesReason salesReason = new SalesReason();
salesReason.SalesReasonID = salesReasonID;
salesReason.Name = name;
salesReason.ReasonType = reasonType;
salesReason.ModifiedDate = modifiedDate;
return salesReason;
}
/// <summary>
/// Deep Loads the <see cref="IEntity"/> object with criteria based of the child
/// property collections only N Levels Deep based on the <see cref="DeepLoadType"/>.
/// </summary>
/// <remarks>
/// Use this method with caution as it is possible to DeepLoad with Recursion and traverse an entire object graph.
/// </remarks>
/// <param name="transactionManager"><see cref="TransactionManager"/> object</param>
/// <param name="entity">The <see cref="Nettiers.AdventureWorks.Entities.SalesOrderHeaderSalesReason"/> object to load.</param>
/// <param name="deep">Boolean. A flag that indicates whether to recursively save all Property Collection that are descendants of this instance. If True, saves the complete object graph below this object. If False, saves this object only. </param>
/// <param name="deepLoadType">DeepLoadType Enumeration to Include/Exclude object property collections from Load.</param>
/// <param name="childTypes">Nettiers.AdventureWorks.Entities.SalesOrderHeaderSalesReason Property Collection Type Array To Include or Exclude from Load</param>
/// <param name="innerList">A collection of child types for easy access.</param>
/// <exception cref="ArgumentNullException">entity or childTypes is null.</exception>
/// <exception cref="ArgumentException">deepLoadType has invalid value.</exception>
public override void DeepLoad(TransactionManager transactionManager, Nettiers.AdventureWorks.Entities.SalesOrderHeaderSalesReason entity, bool deep, DeepLoadType deepLoadType, System.Type[] childTypes, DeepSession innerList)
{
if (entity == null)
{
return;
}
#region SalesOrderIdSource
if (CanDeepLoad(entity, "SalesOrderHeader|SalesOrderIdSource", deepLoadType, innerList) &&
entity.SalesOrderIdSource == null)
{
object[] pkItems = new object[1];
pkItems[0] = entity.SalesOrderId;
SalesOrderHeader tmpEntity = EntityManager.LocateEntity <SalesOrderHeader>(EntityLocator.ConstructKeyFromPkItems(typeof(SalesOrderHeader), pkItems), DataRepository.Provider.EnableEntityTracking);
if (tmpEntity != null)
{
entity.SalesOrderIdSource = tmpEntity;
}
else
{
entity.SalesOrderIdSource = DataRepository.SalesOrderHeaderProvider.GetBySalesOrderId(transactionManager, entity.SalesOrderId);
}
#if NETTIERS_DEBUG
System.Diagnostics.Debug.WriteLine("- property 'SalesOrderIdSource' loaded. key " + entity.EntityTrackingKey);
#endif
if (deep && entity.SalesOrderIdSource != null)
{
innerList.SkipChildren = true;
DataRepository.SalesOrderHeaderProvider.DeepLoad(transactionManager, entity.SalesOrderIdSource, deep, deepLoadType, childTypes, innerList);
innerList.SkipChildren = false;
}
}
#endregion SalesOrderIdSource
#region SalesReasonIdSource
if (CanDeepLoad(entity, "SalesReason|SalesReasonIdSource", deepLoadType, innerList) &&
entity.SalesReasonIdSource == null)
{
object[] pkItems = new object[1];
pkItems[0] = entity.SalesReasonId;
SalesReason tmpEntity = EntityManager.LocateEntity <SalesReason>(EntityLocator.ConstructKeyFromPkItems(typeof(SalesReason), pkItems), DataRepository.Provider.EnableEntityTracking);
if (tmpEntity != null)
{
entity.SalesReasonIdSource = tmpEntity;
}
else
{
entity.SalesReasonIdSource = DataRepository.SalesReasonProvider.GetBySalesReasonId(transactionManager, entity.SalesReasonId);
}
#if NETTIERS_DEBUG
System.Diagnostics.Debug.WriteLine("- property 'SalesReasonIdSource' loaded. key " + entity.EntityTrackingKey);
#endif
if (deep && entity.SalesReasonIdSource != null)
{
innerList.SkipChildren = true;
DataRepository.SalesReasonProvider.DeepLoad(transactionManager, entity.SalesReasonIdSource, deep, deepLoadType, childTypes, innerList);
innerList.SkipChildren = false;
}
}
#endregion SalesReasonIdSource
//used to hold DeepLoad method delegates and fire after all the local children have been loaded.
Dictionary <string, KeyValuePair <Delegate, object> > deepHandles = new Dictionary <string, KeyValuePair <Delegate, object> >();
//Fire all DeepLoad Items
foreach (KeyValuePair <Delegate, object> pair in deepHandles.Values)
{
pair.Key.DynamicInvoke((object[])pair.Value);
}
deepHandles = null;
}
/// <summary>
/// Make any alterations necessary (i.e. for DB check constraints, special test cases, etc.)
/// </summary>
/// <param name="mock">Object to be modified</param>
static private void SetSpecialTestData(SalesReason mock)
{
//Code your changes to the data object here.
}
/// <summary>
/// There are no comments for SalesReason in the schema.
/// </summary>
public void AddToSalesReason(SalesReason salesReason)
{
base.AddObject("SalesReason", salesReason);
}
// POST api/awbuildversion
public void Post(SalesReason value)
{
adventureWorks_BC.SalesReasonAdd(value);
}
///<summary>
/// Update the Typed SalesReason Entity with modified mock values.
///</summary>
static public void UpdateMockInstance_Generated(TransactionManager tm, SalesReason mock)
{
mock.Name = TestUtility.Instance.RandomString(24, false);;
mock.ReasonType = TestUtility.Instance.RandomString(24, false);;
mock.ModifiedDate = TestUtility.Instance.RandomDateTime();
}
