/// <summary> /// Deep load all ProductCostHistory children. /// </summary> private void Step_03_DeepLoad_Generated() { using (TransactionManager tm = CreateTransaction()) { int count = -1; mock = CreateMockInstance(tm); mockCollection = DataRepository.ProductCostHistoryProvider.GetPaged(tm, 0, 10, out count); DataRepository.ProductCostHistoryProvider.DeepLoading += new EntityProviderBaseCore <ProductCostHistory, ProductCostHistoryKey> .DeepLoadingEventHandler( delegate(object sender, DeepSessionEventArgs e) { if (e.DeepSession.Count > 3) { e.Cancel = true; } } ); if (mockCollection.Count > 0) { DataRepository.ProductCostHistoryProvider.DeepLoad(tm, mockCollection[0]); System.Console.WriteLine("ProductCostHistory instance correctly deep loaded at 1 level."); mockCollection.Add(mock); // DataRepository.ProductCostHistoryProvider.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 ProductCostHistory mock = CreateMockInstance(tm); bool result = DataRepository.ProductCostHistoryProvider.Insert(tm, mock); Assert.IsTrue(result, "Could Not Test FindByQuery, Insert Failed"); ProductCostHistoryQuery query = new ProductCostHistoryQuery(); query.AppendEquals(ProductCostHistoryColumn.ProductId, mock.ProductId.ToString()); query.AppendEquals(ProductCostHistoryColumn.StartDate, mock.StartDate.ToString()); if (mock.EndDate != null) { query.AppendEquals(ProductCostHistoryColumn.EndDate, mock.EndDate.ToString()); } query.AppendEquals(ProductCostHistoryColumn.StandardCost, mock.StandardCost.ToString()); query.AppendEquals(ProductCostHistoryColumn.ModifiedDate, mock.ModifiedDate.ToString()); TList <ProductCostHistory> results = DataRepository.ProductCostHistoryProvider.Find(tm, query); Assert.IsTrue(results.Count == 1, "Find is not working correctly. Failed to find the mock instance"); } }
public ProductCostHistoryCollection GetAllProductCostHistorysDynamicCollection(string whereExpression, string orderBy) { IDBManager dbm = new DBManager(); ProductCostHistoryCollection cols = new ProductCostHistoryCollection(); try { dbm.CreateParameters(2); dbm.AddParameters(0, "@WhereCondition", whereExpression); dbm.AddParameters(1, "@OrderByExpression", orderBy); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectProductInventoriesDynamic"); while (reader.Read()) { ProductCostHistory productCostHistory = new ProductCostHistory(); productCostHistory.ProductID = Int32.Parse(reader["ProductID"].ToString()); productCostHistory.StartDate = DateTime.Parse(reader["StartDate"].ToString()); productCostHistory.EndDate = DateTime.Parse(reader["EndDate"].ToString()); productCostHistory.StandardCost = Decimal.Parse(reader["StandardCost"].ToString()); productCostHistory.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(productCostHistory); } } catch (Exception ex) { log.Write(ex.Message, "GetAllProductCostHistorysDynamicCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public int AddProductCostHistory(ProductCostHistory productCostHistory) { IDBManager dbm = new DBManager(); try { dbm.CreateParameters(6); dbm.AddParameters(0, "@ProductID", productCostHistory.ProductID); dbm.AddParameters(1, "@StartDate", productCostHistory.StartDate); dbm.AddParameters(2, "@EndDate", productCostHistory.EndDate); dbm.AddParameters(3, "@StandardCost", productCostHistory.StandardCost); dbm.AddParameters(4, "@ModifiedDate", DateTime.Now); dbm.AddParameters(5, "@ID", productCostHistory.ID); dbm.Parameters[5].Direction = ParameterDirection.Output; dbm.ExecuteNonQuery(CommandType.StoredProcedure, "InsertProductCostHistory"); productCostHistory.ID = Int32.Parse(dbm.Parameters[5].Value.ToString()); } catch (Exception ex) { log.Write(ex.Message, "AddProductCostHistory"); throw (ex); } finally { dbm.Dispose(); } return(productCostHistory.ID); }
public ProductCostHistory GetProductCostHistory(int productID) { IDBManager dbm = new DBManager(); ProductCostHistory productCostHistory = new ProductCostHistory(); try { dbm.CreateParameters(1); dbm.AddParameters(0, "@ProductID", productID); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectProductCostHistory"); while (reader.Read()) { productCostHistory.ID = Int32.Parse(reader["ID"].ToString()); productCostHistory.ProductID = Int32.Parse(reader["ProductID"].ToString()); productCostHistory.StartDate = DateTime.Parse(reader["StartDate"].ToString()); productCostHistory.EndDate = DateTime.Parse(reader["EndDate"].ToString()); productCostHistory.StandardCost = Decimal.Parse(reader["StandardCost"].ToString()); productCostHistory.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); } } catch (Exception ex) { log.Write(ex.Message, "GetProductCostHistory"); throw (ex); } finally { dbm.Dispose(); } return(productCostHistory); }
public bool UpdateProductCostHistory(ProductCostHistory productCostHistory) { IDBManager dbm = new DBManager(); try { dbm.CreateParameters(5); dbm.AddParameters(0, "@ProductID", productCostHistory.ProductID); dbm.AddParameters(1, "@StartDate", productCostHistory.StartDate); dbm.AddParameters(2, "@EndDate", productCostHistory.EndDate); dbm.AddParameters(3, "@StandardCost", productCostHistory.StandardCost); dbm.AddParameters(4, "@ModifiedDate", DateTime.Now); dbm.ExecuteNonQuery(CommandType.StoredProcedure, "UpdateProductCostHistory"); } catch (Exception ex) { log.Write(ex.Message, "UpdateProductCostHistory"); throw (ex); } finally { dbm.Dispose(); } return(true); }
public ProductCostHistoryCollection GetAllProductCostHistorysCollection() { IDBManager dbm = new DBManager(); ProductCostHistoryCollection cols = new ProductCostHistoryCollection(); try { IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectProductCostHistoriesAll"); while (reader.Read()) { ProductCostHistory productCostHistory = new ProductCostHistory(); productCostHistory.ID = Int32.Parse(reader["ID"].ToString()); productCostHistory.ProductID = Int32.Parse(reader["ProductID"].ToString()); productCostHistory.StartDate = DateTime.Parse(reader["StartDate"].ToString()); productCostHistory.EndDate = DateTime.Parse(reader["EndDate"].ToString()); productCostHistory.StandardCost = Decimal.Parse(reader["StandardCost"].ToString()); productCostHistory.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(productCostHistory); } } catch (Exception ex) { log.Write(ex.Message, "GetAllProductCostHistorysCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
///<summary> /// Update the Typed ProductCostHistory Entity with modified mock values. ///</summary> static public void UpdateMockInstance(TransactionManager tm, ProductCostHistory mock) { ProductCostHistoryTest.UpdateMockInstance_Generated(tm, mock); // make any alterations necessary // (i.e. for DB check constraints, special test cases, etc.) SetSpecialTestData(mock); }
/// <summary> /// Test methods exposed by the EntityHelper class. /// </summary> private void Step_20_TestEntityHelper_Generated() { using (TransactionManager tm = CreateTransaction()) { mock = CreateMockInstance(tm); ProductCostHistory entity = mock.Copy() as ProductCostHistory; entity = (ProductCostHistory)mock.Clone(); Assert.IsTrue(ProductCostHistory.ValueEquals(entity, mock), "Clone is not working"); } }
public ActionResult Edit([Bind(Include = "ProductID,StartDate,EndDate,StandardCost,ModifiedDate,isDeleted")] ProductCostHistory productCostHistory) { if (ModelState.IsValid) { db.Entry(productCostHistory).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ProductID = new SelectList(db.Products, "ProductID", "Name", productCostHistory.ProductID); return(View(productCostHistory)); }
/// <summary> /// Check the foreign key dal methods. /// </summary> private void Step_10_FK_Generated() { using (TransactionManager tm = CreateTransaction()) { ProductCostHistory entity = CreateMockInstance(tm); bool result = DataRepository.ProductCostHistoryProvider.Insert(tm, entity); Assert.IsTrue(result, "Could Not Test FK, Insert Failed"); TList <ProductCostHistory> t0 = DataRepository.ProductCostHistoryProvider.GetByProductId(tm, entity.ProductId, 0, 10); } }
///<summary> /// Update the Typed ProductCostHistory Entity with modified mock values. ///</summary> static public void UpdateMockInstance_Generated(TransactionManager tm, ProductCostHistory mock) { mock.EndDate = TestUtility.Instance.RandomDateTime(); mock.StandardCost = TestUtility.Instance.RandomShort(); mock.ModifiedDate = TestUtility.Instance.RandomDateTime(); //OneToOneRelationship Product mockProductByProductId = ProductTest.CreateMockInstance(tm); DataRepository.ProductProvider.Insert(tm, mockProductByProductId); mock.ProductId = mockProductByProductId.ProductId; }
///<summary> /// Returns a Typed ProductCostHistory Entity with mock values. ///</summary> static public ProductCostHistory CreateMockInstance(TransactionManager tm) { // get the default mock instance ProductCostHistory mock = ProductCostHistoryTest.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); }
// PUT api/awbuildversion/5 public void Put(ProductCostHistory 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.ProductCostHistoryDelete(value); if (GetActionType.Value.ToList()[0].Equals("UPDATE")) adventureWorks_BC.ProductCostHistoryUpdate(value); } }
public virtual ProductCostHistory MapBOToEF( BOProductCostHistory bo) { ProductCostHistory efProductCostHistory = new ProductCostHistory(); efProductCostHistory.SetProperties( bo.EndDate, bo.ModifiedDate, bo.ProductID, bo.StandardCost, bo.StartDate); return(efProductCostHistory); }
public virtual BOProductCostHistory MapEFToBO( ProductCostHistory ef) { var bo = new BOProductCostHistory(); bo.SetProperties( ef.ProductID, ef.EndDate, ef.ModifiedDate, ef.StandardCost, ef.StartDate); return(bo); }
/// <summary> /// Serialize the mock ProductCostHistory 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_ProductCostHistory.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."); } }
/// <summary> /// Check the indexes dal methods. /// </summary> private void Step_11_IX_Generated() { using (TransactionManager tm = CreateTransaction()) { ProductCostHistory entity = CreateMockInstance(tm); bool result = DataRepository.ProductCostHistoryProvider.Insert(tm, entity); Assert.IsTrue(result, "Could Not Test IX, Insert Failed"); ProductCostHistory t0 = DataRepository.ProductCostHistoryProvider.GetByProductIdStartDate(tm, entity.ProductId, entity.StartDate); } }
public void MapEFToBOList() { var mapper = new DALProductCostHistoryMapper(); ProductCostHistory entity = new ProductCostHistory(); entity.SetProperties(DateTime.Parse("1/1/1987 12:00:00 AM"), DateTime.Parse("1/1/1987 12:00:00 AM"), 1, 1m, DateTime.Parse("1/1/1987 12:00:00 AM")); List <BOProductCostHistory> response = mapper.MapEFToBO(new List <ProductCostHistory>() { entity }); response.Count.Should().Be(1); }
// GET: ProductCostHistories/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ProductCostHistory productCostHistory = db.ProductCostHistories.Find(id); if (productCostHistory == null) { return(HttpNotFound()); } return(View(productCostHistory)); }
public bool ProductCostHistoryDelete(ProductCostHistory productcosthistory) { return(Execute <bool>(dal => { ProductCostHistory productcosthistoryDelete = dal.ProductCostHistory.Where(x => x.ProductID == productcosthistory.ProductID).FirstOrDefault(); if (productcosthistoryDelete != null) { dal.ProductCostHistory.DeleteOnSubmit(productcosthistoryDelete); dal.SubmitChanges(); return true; } return false; })); }
/// <summary> /// Inserts a mock ProductCostHistory entity into the database. /// </summary> private void Step_01_Insert_Generated() { using (TransactionManager tm = CreateTransaction()) { mock = CreateMockInstance(tm); Assert.IsTrue(DataRepository.ProductCostHistoryProvider.Insert(tm, mock), "Insert failed"); System.Console.WriteLine("DataRepository.ProductCostHistoryProvider.Insert(mock):"); System.Console.WriteLine(mock); //normally one would commit here //tm.Commit(); //IDisposable will Rollback Transaction since it's left uncommitted } }
public void MapBOToEF() { var mapper = new DALProductCostHistoryMapper(); var bo = new BOProductCostHistory(); bo.SetProperties(1, DateTime.Parse("1/1/1987 12:00:00 AM"), DateTime.Parse("1/1/1987 12:00:00 AM"), 1m, DateTime.Parse("1/1/1987 12:00:00 AM")); ProductCostHistory response = mapper.MapBOToEF(bo); response.EndDate.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM")); response.ModifiedDate.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM")); response.ProductID.Should().Be(1); response.StandardCost.Should().Be(1m); response.StartDate.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM")); }
public void MapEFToBO() { var mapper = new DALProductCostHistoryMapper(); ProductCostHistory entity = new ProductCostHistory(); entity.SetProperties(DateTime.Parse("1/1/1987 12:00:00 AM"), DateTime.Parse("1/1/1987 12:00:00 AM"), 1, 1m, DateTime.Parse("1/1/1987 12:00:00 AM")); BOProductCostHistory response = mapper.MapEFToBO(entity); response.EndDate.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM")); response.ModifiedDate.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM")); response.ProductID.Should().Be(1); response.StandardCost.Should().Be(1m); response.StartDate.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM")); }
// GET: ProductCostHistories/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ProductCostHistory productCostHistory = db.ProductCostHistories.Find(id); if (productCostHistory == null) { return(HttpNotFound()); } ViewBag.ProductID = new SelectList(db.Products, "ProductID", "Name", productCostHistory.ProductID); return(View(productCostHistory)); }
// PUT api/awbuildversion/5 public void Put(ProductCostHistory 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.ProductCostHistoryDelete(value); } if (GetActionType.Value.ToList()[0].Equals("UPDATE")) { adventureWorks_BC.ProductCostHistoryUpdate(value); } } }
/// <summary> /// Serialize a ProductCostHistory 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_ProductCostHistoryCollection.xml"); mock = CreateMockInstance(tm); TList <ProductCostHistory> mockCollection = new TList <ProductCostHistory>(); mockCollection.Add(mock); EntityHelper.SerializeXml(mockCollection, fileName); Assert.IsTrue(System.IO.File.Exists(fileName), "Serialized mock collection not found"); System.Console.WriteLine("TList<ProductCostHistory> correctly serialized to a temporary file."); } }
public async void Get() { var mock = new ServiceMockFacade <IProductCostHistoryRepository>(); var record = new ProductCostHistory(); mock.RepositoryMock.Setup(x => x.Get(It.IsAny <int>())).Returns(Task.FromResult(record)); var service = new ProductCostHistoryService(mock.LoggerMock.Object, mock.RepositoryMock.Object, mock.ModelValidatorMockFactory.ProductCostHistoryModelValidatorMock.Object, mock.BOLMapperMockFactory.BOLProductCostHistoryMapperMock, mock.DALMapperMockFactory.DALProductCostHistoryMapperMock); ApiProductCostHistoryResponseModel response = await service.Get(default(int)); response.Should().NotBeNull(); mock.RepositoryMock.Verify(x => x.Get(It.IsAny <int>())); }
public bool ProductCostHistoryUpdate(ProductCostHistory productcosthistory) { return(Execute <bool>(dal => { ProductCostHistory productcosthistoryUpdate = dal.ProductCostHistory.Where(x => x.ProductID == productcosthistory.ProductID).FirstOrDefault(); if (productcosthistoryUpdate != null) { productcosthistoryUpdate.ProductID = productcosthistory.ProductID; productcosthistoryUpdate.StartDate = productcosthistory.StartDate; productcosthistoryUpdate.EndDate = productcosthistory.EndDate; productcosthistoryUpdate.StandardCost = productcosthistory.StandardCost; productcosthistoryUpdate.ModifiedDate = productcosthistory.ModifiedDate; dal.SubmitChanges(); return true; } return false; })); }
public ActionResult DeleteConfirmed(int id) { var res = (from c in db.ProductCostHistories where c.ProductID == id select c).FirstOrDefault(); if (res != null) { res.isDeleted = true; db.SaveChanges(); ViewBag.Message = string.Format("Congrats! Delete success"); } ProductCostHistory productCategory = db.ProductCostHistories.Find(id); return(View(productCategory)); }
///<summary> /// Returns a Typed ProductCostHistory Entity with mock values. ///</summary> static public ProductCostHistory CreateMockInstance_Generated(TransactionManager tm) { ProductCostHistory mock = new ProductCostHistory(); mock.StartDate = TestUtility.Instance.RandomDateTime(); mock.EndDate = TestUtility.Instance.RandomDateTime(); mock.StandardCost = TestUtility.Instance.RandomShort(); mock.ModifiedDate = TestUtility.Instance.RandomDateTime(); //OneToOneRelationship Product mockProductByProductId = ProductTest.CreateMockInstance(tm); DataRepository.ProductProvider.Insert(tm, mockProductByProductId); mock.ProductId = mockProductByProductId.ProductId; // create a temporary collection and add the item to it TList <ProductCostHistory> tempMockCollection = new TList <ProductCostHistory>(); tempMockCollection.Add(mock); tempMockCollection.Remove(mock); return((ProductCostHistory)mock); }
/// <summary> /// There are no comments for ProductCostHistory in the schema. /// </summary> public void AddToProductCostHistory(ProductCostHistory productCostHistory) { base.AddObject("ProductCostHistory", productCostHistory); }
/// <summary> /// Create a new ProductCostHistory object. /// </summary> /// <param name="productID">Initial value of ProductID.</param> /// <param name="startDate">Initial value of StartDate.</param> /// <param name="standardCost">Initial value of StandardCost.</param> /// <param name="modifiedDate">Initial value of ModifiedDate.</param> public static ProductCostHistory CreateProductCostHistory(int productID, global::System.DateTime startDate, decimal standardCost, global::System.DateTime modifiedDate) { ProductCostHistory productCostHistory = new ProductCostHistory(); productCostHistory.ProductID = productID; productCostHistory.StartDate = startDate; productCostHistory.StandardCost = standardCost; productCostHistory.ModifiedDate = modifiedDate; return productCostHistory; }
// POST api/awbuildversion public void Post(ProductCostHistory value) { adventureWorks_BC.ProductCostHistoryAdd(value); }