// PUT api/awbuildversion/5
public void Put(SalesPersonQuotaHistory 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.SalesPersonQuotaHistoryDelete(value);
if (GetActionType.Value.ToList()[0].Equals("UPDATE"))
adventureWorks_BC.SalesPersonQuotaHistoryUpdate(value);
}
}
/// <summary>
/// Inserts a mock SalesPersonQuotaHistory entity into the database.
/// </summary>
private void Step_01_Insert_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
mock = CreateMockInstance(tm);
Assert.IsTrue(DataRepository.SalesPersonQuotaHistoryProvider.Insert(tm, mock), "Insert failed");
System.Console.WriteLine("DataRepository.SalesPersonQuotaHistoryProvider.Insert(mock):");
System.Console.WriteLine(mock);
//normally one would commit here
//tm.Commit();
//IDisposable will Rollback Transaction since it's left uncommitted
}
}
public void MapEFToBO()
{
var mapper = new DALSalesPersonQuotaHistoryMapper();
SalesPersonQuotaHistory entity = new SalesPersonQuotaHistory();
entity.SetProperties(1, DateTime.Parse("1/1/1987 12:00:00 AM"), DateTime.Parse("1/1/1987 12:00:00 AM"), Guid.Parse("8420cdcf-d595-ef65-66e7-dff9f98764da"), 1m);
BOSalesPersonQuotaHistory response = mapper.MapEFToBO(entity);
response.BusinessEntityID.Should().Be(1);
response.ModifiedDate.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM"));
response.QuotaDate.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM"));
response.Rowguid.Should().Be(Guid.Parse("8420cdcf-d595-ef65-66e7-dff9f98764da"));
response.SalesQuota.Should().Be(1m);
}
// PUT api/awbuildversion/5
public void Put(SalesPersonQuotaHistory 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.SalesPersonQuotaHistoryDelete(value);
}
if (GetActionType.Value.ToList()[0].Equals("UPDATE"))
{
adventureWorks_BC.SalesPersonQuotaHistoryUpdate(value);
}
}
}
/// <summary>
/// Serialize a SalesPersonQuotaHistory 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_SalesPersonQuotaHistoryCollection.xml");
mock = CreateMockInstance(tm);
TList <SalesPersonQuotaHistory> mockCollection = new TList <SalesPersonQuotaHistory>();
mockCollection.Add(mock);
EntityHelper.SerializeXml(mockCollection, fileName);
Assert.IsTrue(System.IO.File.Exists(fileName), "Serialized mock collection not found");
System.Console.WriteLine("TList<SalesPersonQuotaHistory> correctly serialized to a temporary file.");
}
}
public async void Get()
{
var mock = new ServiceMockFacade <ISalesPersonQuotaHistoryRepository>();
var record = new SalesPersonQuotaHistory();
mock.RepositoryMock.Setup(x => x.Get(It.IsAny <int>())).Returns(Task.FromResult(record));
var service = new SalesPersonQuotaHistoryService(mock.LoggerMock.Object,
mock.RepositoryMock.Object,
mock.ModelValidatorMockFactory.SalesPersonQuotaHistoryModelValidatorMock.Object,
mock.BOLMapperMockFactory.BOLSalesPersonQuotaHistoryMapperMock,
mock.DALMapperMockFactory.DALSalesPersonQuotaHistoryMapperMock);
ApiSalesPersonQuotaHistoryResponseModel response = await service.Get(default(int));
response.Should().NotBeNull();
mock.RepositoryMock.Verify(x => x.Get(It.IsAny <int>()));
}
public bool SalesPersonQuotaHistoryUpdate(SalesPersonQuotaHistory salespersonquotahistory)
{
return(Execute <bool>(dal =>
{
SalesPersonQuotaHistory salespersonquotahistoryUpdate = dal.SalesPersonQuotaHistory.Where(x => x.BusinessEntityID == salespersonquotahistory.BusinessEntityID).FirstOrDefault();
if (salespersonquotahistoryUpdate != null)
{
salespersonquotahistoryUpdate.BusinessEntityID = salespersonquotahistory.BusinessEntityID;
salespersonquotahistoryUpdate.QuotaDate = salespersonquotahistory.QuotaDate;
salespersonquotahistoryUpdate.SalesQuota = salespersonquotahistory.SalesQuota;
salespersonquotahistoryUpdate.rowguid = salespersonquotahistory.rowguid;
salespersonquotahistoryUpdate.ModifiedDate = salespersonquotahistory.ModifiedDate;
dal.SubmitChanges();
return true;
}
return false;
}));
}
public bool DeleteSalesPersonQuotaHistory(SalesPersonQuotaHistory SPQH)
{
IDBManager dbm = new DBManager();
try
{
dbm.CreateParameters(1);
dbm.AddParameters(0, "@SalesPersonID", SPQH.SalesPersonID);
dbm.ExecuteNonQuery(CommandType.StoredProcedure, "DeleteSalesPersonQuotaHistory");
}
catch (Exception ex)
{
log.Write(ex.Message, "DeleteSalesPersonQuotaHistory");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(true);
}
///<summary>
/// Returns a Typed SalesPersonQuotaHistory Entity with mock values.
///</summary>
static public SalesPersonQuotaHistory CreateMockInstance_Generated(TransactionManager tm)
{
SalesPersonQuotaHistory mock = new SalesPersonQuotaHistory();
mock.QuotaDate = TestUtility.Instance.RandomDateTime();
mock.SalesQuota = TestUtility.Instance.RandomShort();
mock.ModifiedDate = TestUtility.Instance.RandomDateTime();
//OneToOneRelationship
SalesPerson mockSalesPersonBySalesPersonId = SalesPersonTest.CreateMockInstance(tm);
DataRepository.SalesPersonProvider.Insert(tm, mockSalesPersonBySalesPersonId);
mock.SalesPersonId = mockSalesPersonBySalesPersonId.SalesPersonId;
// create a temporary collection and add the item to it
TList <SalesPersonQuotaHistory> tempMockCollection = new TList <SalesPersonQuotaHistory>();
tempMockCollection.Add(mock);
tempMockCollection.Remove(mock);
return((SalesPersonQuotaHistory)mock);
}
/// <summary>
/// Test Find using the Query class
/// </summary>
private void Step_30_TestFindByQuery_Generated()
{
using (TransactionManager tm = CreateTransaction())
{
//Insert Mock Instance
SalesPersonQuotaHistory mock = CreateMockInstance(tm);
bool result = DataRepository.SalesPersonQuotaHistoryProvider.Insert(tm, mock);
Assert.IsTrue(result, "Could Not Test FindByQuery, Insert Failed");
SalesPersonQuotaHistoryQuery query = new SalesPersonQuotaHistoryQuery();
query.AppendEquals(SalesPersonQuotaHistoryColumn.SalesPersonId, mock.SalesPersonId.ToString());
query.AppendEquals(SalesPersonQuotaHistoryColumn.QuotaDate, mock.QuotaDate.ToString());
query.AppendEquals(SalesPersonQuotaHistoryColumn.SalesQuota, mock.SalesQuota.ToString());
query.AppendEquals(SalesPersonQuotaHistoryColumn.Rowguid, mock.Rowguid.ToString());
query.AppendEquals(SalesPersonQuotaHistoryColumn.ModifiedDate, mock.ModifiedDate.ToString());
TList <SalesPersonQuotaHistory> results = DataRepository.SalesPersonQuotaHistoryProvider.Find(tm, query);
Assert.IsTrue(results.Count == 1, "Find is not working correctly. Failed to find the mock instance");
}
}
public bool AddSalesPersonQuotaHistory(SalesPersonQuotaHistory SPQH)
{
IDBManager dbm = new DBManager();
try
{
dbm.CreateParameters(4);
dbm.AddParameters(0, "@SalesPersonID", SPQH.SalesPersonID);
dbm.AddParameters(1, "@QuotaDate", SPQH.QuotaDate);
dbm.AddParameters(2, "@SalesQuota", SPQH.SalesQuota);
dbm.AddParameters(3, "@ModifiedDate", DateTime.Now);
dbm.ExecuteNonQuery(CommandType.StoredProcedure, "InsertSalesPersonQuotaHistory");
}
catch (Exception ex)
{
log.Write(ex.Message, "InsertSalesPersonQuotaHistory");
throw (ex);
}
finally
{
dbm.Dispose();
}
return(true);
}
// POST api/awbuildversion
public void Post(SalesPersonQuotaHistory value)
{
adventureWorks_BC.SalesPersonQuotaHistoryAdd(value);
}
/// <summary>
/// Create a new SalesPersonQuotaHistory object.
/// </summary>
/// <param name="salesPersonID">Initial value of SalesPersonID.</param>
/// <param name="quotaDate">Initial value of QuotaDate.</param>
/// <param name="salesQuota">Initial value of SalesQuota.</param>
/// <param name="rowguid">Initial value of rowguid.</param>
/// <param name="modifiedDate">Initial value of ModifiedDate.</param>
public static SalesPersonQuotaHistory CreateSalesPersonQuotaHistory(int salesPersonID, global::System.DateTime quotaDate, decimal salesQuota, global::System.Guid rowguid, global::System.DateTime modifiedDate)
{
SalesPersonQuotaHistory salesPersonQuotaHistory = new SalesPersonQuotaHistory();
salesPersonQuotaHistory.SalesPersonID = salesPersonID;
salesPersonQuotaHistory.QuotaDate = quotaDate;
salesPersonQuotaHistory.SalesQuota = salesQuota;
salesPersonQuotaHistory.rowguid = rowguid;
salesPersonQuotaHistory.ModifiedDate = modifiedDate;
return salesPersonQuotaHistory;
}
/// <summary>
/// There are no comments for SalesPersonQuotaHistory in the schema.
/// </summary>
public void AddToSalesPersonQuotaHistory(SalesPersonQuotaHistory salesPersonQuotaHistory)
{
base.AddObject("SalesPersonQuotaHistory", salesPersonQuotaHistory);
}
// POST api/awbuildversion
public void Post(SalesPersonQuotaHistory value)
{
adventureWorks_BC.SalesPersonQuotaHistoryAdd(value);
}
/// <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(SalesPersonQuotaHistory mock)
{
//Code your changes to the data object here.
}
