// 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); }
/// <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. }