Inheritance: System.Web.UI.Page
Ejemplo n.º 1
0
 /// <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(WorkOrderRouting mock)
 {
     //Code your changes to the data object here.
     mock.ActualEndDate     = mock.ActualStartDate.Value.AddDays(1);
     mock.ScheduledEndDate  = mock.ScheduledStartDate.AddDays(1);
     mock.ActualResourceHrs = TestUtility.Instance.RandomNumber(0, 99999);
 }
Ejemplo n.º 2
0
 public bool WorkOrderRoutingUpdate(WorkOrderRouting workorderrouting)
 {
     return(Execute <bool>(dal =>
     {
         WorkOrderRouting workorderroutingUpdate = dal.WorkOrderRouting.Where(x => x.WorkOrderID == workorderrouting.WorkOrderID).FirstOrDefault();
         if (workorderroutingUpdate != null)
         {
             workorderroutingUpdate.WorkOrderID = workorderrouting.WorkOrderID;
             workorderroutingUpdate.ProductID = workorderrouting.ProductID;
             workorderroutingUpdate.OperationSequence = workorderrouting.OperationSequence;
             workorderroutingUpdate.LocationID = workorderrouting.LocationID;
             workorderroutingUpdate.ScheduledStartDate = workorderrouting.ScheduledStartDate;
             workorderroutingUpdate.ScheduledEndDate = workorderrouting.ScheduledEndDate;
             workorderroutingUpdate.ActualStartDate = workorderrouting.ActualStartDate;
             workorderroutingUpdate.ActualEndDate = workorderrouting.ActualEndDate;
             workorderroutingUpdate.ActualResourceHrs = workorderrouting.ActualResourceHrs;
             workorderroutingUpdate.PlannedCost = workorderrouting.PlannedCost;
             workorderroutingUpdate.ActualCost = workorderrouting.ActualCost;
             workorderroutingUpdate.ModifiedDate = workorderrouting.ModifiedDate;
             dal.SubmitChanges();
             return true;
         }
         return false;
     }));
 }
Ejemplo n.º 3
0
        /// <summary>
        /// Deep load all WorkOrderRouting children.
        /// </summary>
        private void Step_03_DeepLoad_Generated()
        {
            using (TransactionManager tm = CreateTransaction())
            {
                int count = -1;
                mock           = CreateMockInstance(tm);
                mockCollection = DataRepository.WorkOrderRoutingProvider.GetPaged(tm, 0, 10, out count);

                DataRepository.WorkOrderRoutingProvider.DeepLoading += new EntityProviderBaseCore <WorkOrderRouting, WorkOrderRoutingKey> .DeepLoadingEventHandler(
                    delegate(object sender, DeepSessionEventArgs e)
                {
                    if (e.DeepSession.Count > 3)
                    {
                        e.Cancel = true;
                    }
                }
                    );

                if (mockCollection.Count > 0)
                {
                    DataRepository.WorkOrderRoutingProvider.DeepLoad(tm, mockCollection[0]);
                    System.Console.WriteLine("WorkOrderRouting instance correctly deep loaded at 1 level.");

                    mockCollection.Add(mock);
                    // DataRepository.WorkOrderRoutingProvider.DeepSave(tm, mockCollection);
                }

                //normally one would commit here
                //tm.Commit();
                //IDisposable will Rollback Transaction since it's left uncommitted
            }
        }
Ejemplo n.º 4
0
        ///<summary>
        ///  Returns a Typed WorkOrderRouting Entity with mock values.
        ///</summary>
        static public WorkOrderRouting CreateMockInstance_Generated(TransactionManager tm)
        {
            WorkOrderRouting mock = new WorkOrderRouting();

            mock.ProductId          = TestUtility.Instance.RandomNumber();
            mock.OperationSequence  = TestUtility.Instance.RandomShort();
            mock.ScheduledStartDate = TestUtility.Instance.RandomDateTime();
            mock.ScheduledEndDate   = TestUtility.Instance.RandomDateTime();
            mock.ActualStartDate    = TestUtility.Instance.RandomDateTime();
            mock.ActualEndDate      = TestUtility.Instance.RandomDateTime();
            mock.ActualResourceHrs  = (decimal)TestUtility.Instance.RandomShort();
            mock.PlannedCost        = TestUtility.Instance.RandomShort();
            mock.ActualCost         = TestUtility.Instance.RandomShort();
            mock.ModifiedDate       = TestUtility.Instance.RandomDateTime();

            //OneToOneRelationship
            Location mockLocationByLocationId = LocationTest.CreateMockInstance(tm);

            DataRepository.LocationProvider.Insert(tm, mockLocationByLocationId);
            mock.LocationId = mockLocationByLocationId.LocationId;
            //OneToOneRelationship
            WorkOrder mockWorkOrderByWorkOrderId = WorkOrderTest.CreateMockInstance(tm);

            DataRepository.WorkOrderProvider.Insert(tm, mockWorkOrderByWorkOrderId);
            mock.WorkOrderId = mockWorkOrderByWorkOrderId.WorkOrderId;

            // create a temporary collection and add the item to it
            TList <WorkOrderRouting> tempMockCollection = new TList <WorkOrderRouting>();

            tempMockCollection.Add(mock);
            tempMockCollection.Remove(mock);


            return((WorkOrderRouting)mock);
        }
Ejemplo n.º 5
0
        ///<summary>
        ///  Update the Typed WorkOrderRouting Entity with modified mock values.
        ///</summary>
        static public void UpdateMockInstance(TransactionManager tm, WorkOrderRouting mock)
        {
            WorkOrderRoutingTest.UpdateMockInstance_Generated(tm, mock);

            // make any alterations necessary
            // (i.e. for DB check constraints, special test cases, etc.)
            SetSpecialTestData(mock);
        }
Ejemplo n.º 6
0
        /// <summary>
        /// Test methods exposed by the EntityHelper class.
        /// </summary>
        private void Step_20_TestEntityHelper_Generated()
        {
            using (TransactionManager tm = CreateTransaction())
            {
                mock = CreateMockInstance(tm);

                WorkOrderRouting entity = mock.Copy() as WorkOrderRouting;
                entity = (WorkOrderRouting)mock.Clone();
                Assert.IsTrue(WorkOrderRouting.ValueEquals(entity, mock), "Clone is not working");
            }
        }
        // PUT api/awbuildversion/5
        public void Put(WorkOrderRouting 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.WorkOrderRoutingDelete(value);
                if (GetActionType.Value.ToList()[0].Equals("UPDATE"))
                    adventureWorks_BC.WorkOrderRoutingUpdate(value);
            }
        }
Ejemplo n.º 8
0
        ///<summary>
        ///  Returns a Typed WorkOrderRouting Entity with mock values.
        ///</summary>
        static public WorkOrderRouting CreateMockInstance(TransactionManager tm)
        {
            // get the default mock instance
            WorkOrderRouting mock = WorkOrderRoutingTest.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);
        }
Ejemplo n.º 9
0
        /// <summary>
        /// Check the foreign key dal methods.
        /// </summary>
        private void Step_10_FK_Generated()
        {
            using (TransactionManager tm = CreateTransaction())
            {
                WorkOrderRouting entity = CreateMockInstance(tm);
                bool             result = DataRepository.WorkOrderRoutingProvider.Insert(tm, entity);

                Assert.IsTrue(result, "Could Not Test FK, Insert Failed");

                TList <WorkOrderRouting> t0 = DataRepository.WorkOrderRoutingProvider.GetByLocationId(tm, entity.LocationId, 0, 10);
                TList <WorkOrderRouting> t1 = DataRepository.WorkOrderRoutingProvider.GetByWorkOrderId(tm, entity.WorkOrderId, 0, 10);
            }
        }
Ejemplo n.º 10
0
        /// <summary>
        /// Serialize the mock WorkOrderRouting 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_WorkOrderRouting.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.");
            }
        }
Ejemplo n.º 11
0
        /// <summary>
        /// Check the indexes dal methods.
        /// </summary>
        private void Step_11_IX_Generated()
        {
            using (TransactionManager tm = CreateTransaction())
            {
                WorkOrderRouting entity = CreateMockInstance(tm);
                bool             result = DataRepository.WorkOrderRoutingProvider.Insert(tm, entity);

                Assert.IsTrue(result, "Could Not Test IX, Insert Failed");


                TList <WorkOrderRouting> t0 = DataRepository.WorkOrderRoutingProvider.GetByProductId(tm, entity.ProductId);
                WorkOrderRouting         t1 = DataRepository.WorkOrderRoutingProvider.GetByWorkOrderIdProductIdOperationSequence(tm, entity.WorkOrderId, entity.ProductId, entity.OperationSequence);
            }
        }
        public void MapEFToBOList()
        {
            var mapper = new DALWorkOrderRoutingMapper();
            WorkOrderRouting entity = new WorkOrderRouting();

            entity.SetProperties(1m, DateTime.Parse("1/1/1987 12:00:00 AM"), 1, DateTime.Parse("1/1/1987 12:00:00 AM"), 1, DateTime.Parse("1/1/1987 12:00:00 AM"), 1, 1m, 1, DateTime.Parse("1/1/1987 12:00:00 AM"), DateTime.Parse("1/1/1987 12:00:00 AM"), 1);

            List <BOWorkOrderRouting> response = mapper.MapEFToBO(new List <WorkOrderRouting>()
            {
                entity
            });

            response.Count.Should().Be(1);
        }
Ejemplo n.º 13
0
 public bool WorkOrderRoutingDelete(WorkOrderRouting workorderrouting)
 {
     return(Execute <bool>(dal =>
     {
         WorkOrderRouting workorderroutingDelete = dal.WorkOrderRouting.Where(x => x.WorkOrderID == workorderrouting.WorkOrderID).FirstOrDefault();
         if (workorderroutingDelete != null)
         {
             dal.WorkOrderRouting.DeleteOnSubmit(workorderroutingDelete);
             dal.SubmitChanges();
             return true;
         }
         return false;
     }));
 }
		/// <summary>
		/// Inserts a mock WorkOrderRouting entity into the database.
		/// </summary>
		private void Step_01_Insert_Generated()
		{
			using (TransactionManager tm = CreateTransaction())
			{
				mock = CreateMockInstance(tm);
				Assert.IsTrue(DataRepository.WorkOrderRoutingProvider.Insert(tm, mock), "Insert failed");
										
				System.Console.WriteLine("DataRepository.WorkOrderRoutingProvider.Insert(mock):");			
				System.Console.WriteLine(mock);			
				
				//normally one would commit here
				//tm.Commit();
				//IDisposable will Rollback Transaction since it's left uncommitted
			}
		}
Ejemplo n.º 15
0
        /// <summary>
        /// Inserts a mock WorkOrderRouting entity into the database.
        /// </summary>
        private void Step_01_Insert_Generated()
        {
            using (TransactionManager tm = CreateTransaction())
            {
                mock = CreateMockInstance(tm);
                Assert.IsTrue(DataRepository.WorkOrderRoutingProvider.Insert(tm, mock), "Insert failed");

                System.Console.WriteLine("DataRepository.WorkOrderRoutingProvider.Insert(mock):");
                System.Console.WriteLine(mock);

                //normally one would commit here
                //tm.Commit();
                //IDisposable will Rollback Transaction since it's left uncommitted
            }
        }
Ejemplo n.º 16
0
        /// <summary>
        /// Serialize a WorkOrderRouting 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_WorkOrderRoutingCollection.xml");

                mock = CreateMockInstance(tm);
                TList <WorkOrderRouting> mockCollection = new TList <WorkOrderRouting>();
                mockCollection.Add(mock);

                EntityHelper.SerializeXml(mockCollection, fileName);

                Assert.IsTrue(System.IO.File.Exists(fileName), "Serialized mock collection not found");
                System.Console.WriteLine("TList<WorkOrderRouting> correctly serialized to a temporary file.");
            }
        }
Ejemplo n.º 17
0
        // PUT api/awbuildversion/5
        public void Put(WorkOrderRouting 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.WorkOrderRoutingDelete(value);
                }
                if (GetActionType.Value.ToList()[0].Equals("UPDATE"))
                {
                    adventureWorks_BC.WorkOrderRoutingUpdate(value);
                }
            }
        }
Ejemplo n.º 18
0
        public async void Get()
        {
            var mock   = new ServiceMockFacade <IWorkOrderRoutingRepository>();
            var record = new WorkOrderRouting();

            mock.RepositoryMock.Setup(x => x.Get(It.IsAny <int>())).Returns(Task.FromResult(record));
            var service = new WorkOrderRoutingService(mock.LoggerMock.Object,
                                                      mock.RepositoryMock.Object,
                                                      mock.ModelValidatorMockFactory.WorkOrderRoutingModelValidatorMock.Object,
                                                      mock.BOLMapperMockFactory.BOLWorkOrderRoutingMapperMock,
                                                      mock.DALMapperMockFactory.DALWorkOrderRoutingMapperMock);

            ApiWorkOrderRoutingResponseModel response = await service.Get(default(int));

            response.Should().NotBeNull();
            mock.RepositoryMock.Verify(x => x.Get(It.IsAny <int>()));
        }
Ejemplo n.º 19
0
        /// <summary>
        /// Test Find using the Query class
        /// </summary>
        private void Step_30_TestFindByQuery_Generated()
        {
            using (TransactionManager tm = CreateTransaction())
            {
                //Insert Mock Instance
                WorkOrderRouting mock   = CreateMockInstance(tm);
                bool             result = DataRepository.WorkOrderRoutingProvider.Insert(tm, mock);

                Assert.IsTrue(result, "Could Not Test FindByQuery, Insert Failed");

                WorkOrderRoutingQuery query = new WorkOrderRoutingQuery();

                query.AppendEquals(WorkOrderRoutingColumn.WorkOrderId, mock.WorkOrderId.ToString());
                query.AppendEquals(WorkOrderRoutingColumn.ProductId, mock.ProductId.ToString());
                query.AppendEquals(WorkOrderRoutingColumn.OperationSequence, mock.OperationSequence.ToString());
                query.AppendEquals(WorkOrderRoutingColumn.LocationId, mock.LocationId.ToString());
                query.AppendEquals(WorkOrderRoutingColumn.ScheduledStartDate, mock.ScheduledStartDate.ToString());
                query.AppendEquals(WorkOrderRoutingColumn.ScheduledEndDate, mock.ScheduledEndDate.ToString());
                if (mock.ActualStartDate != null)
                {
                    query.AppendEquals(WorkOrderRoutingColumn.ActualStartDate, mock.ActualStartDate.ToString());
                }
                if (mock.ActualEndDate != null)
                {
                    query.AppendEquals(WorkOrderRoutingColumn.ActualEndDate, mock.ActualEndDate.ToString());
                }
                if (mock.ActualResourceHrs != null)
                {
                    query.AppendEquals(WorkOrderRoutingColumn.ActualResourceHrs, mock.ActualResourceHrs.ToString());
                }
                query.AppendEquals(WorkOrderRoutingColumn.PlannedCost, mock.PlannedCost.ToString());
                if (mock.ActualCost != null)
                {
                    query.AppendEquals(WorkOrderRoutingColumn.ActualCost, mock.ActualCost.ToString());
                }
                query.AppendEquals(WorkOrderRoutingColumn.ModifiedDate, mock.ModifiedDate.ToString());

                TList <WorkOrderRouting> results = DataRepository.WorkOrderRoutingProvider.Find(tm, query);

                Assert.IsTrue(results.Count == 1, "Find is not working correctly.  Failed to find the mock instance");
            }
        }
        public virtual BOWorkOrderRouting MapEFToBO(
            WorkOrderRouting ef)
        {
            var bo = new BOWorkOrderRouting();

            bo.SetProperties(
                ef.WorkOrderID,
                ef.ActualCost,
                ef.ActualEndDate,
                ef.ActualResourceHr,
                ef.ActualStartDate,
                ef.LocationID,
                ef.ModifiedDate,
                ef.OperationSequence,
                ef.PlannedCost,
                ef.ProductID,
                ef.ScheduledEndDate,
                ef.ScheduledStartDate);
            return(bo);
        }
        public virtual WorkOrderRouting MapBOToEF(
            BOWorkOrderRouting bo)
        {
            WorkOrderRouting efWorkOrderRouting = new WorkOrderRouting();

            efWorkOrderRouting.SetProperties(
                bo.ActualCost,
                bo.ActualEndDate,
                bo.ActualResourceHr,
                bo.ActualStartDate,
                bo.LocationID,
                bo.ModifiedDate,
                bo.OperationSequence,
                bo.PlannedCost,
                bo.ProductID,
                bo.ScheduledEndDate,
                bo.ScheduledStartDate,
                bo.WorkOrderID);
            return(efWorkOrderRouting);
        }
        public void MapEFToBO()
        {
            var mapper = new DALWorkOrderRoutingMapper();
            WorkOrderRouting entity = new WorkOrderRouting();

            entity.SetProperties(1m, DateTime.Parse("1/1/1987 12:00:00 AM"), 1, DateTime.Parse("1/1/1987 12:00:00 AM"), 1, DateTime.Parse("1/1/1987 12:00:00 AM"), 1, 1m, 1, DateTime.Parse("1/1/1987 12:00:00 AM"), DateTime.Parse("1/1/1987 12:00:00 AM"), 1);

            BOWorkOrderRouting response = mapper.MapEFToBO(entity);

            response.ActualCost.Should().Be(1m);
            response.ActualEndDate.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM"));
            response.ActualResourceHr.Should().Be(1);
            response.ActualStartDate.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM"));
            response.LocationID.Should().Be(1);
            response.ModifiedDate.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM"));
            response.OperationSequence.Should().Be(1);
            response.PlannedCost.Should().Be(1m);
            response.ProductID.Should().Be(1);
            response.ScheduledEndDate.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM"));
            response.ScheduledStartDate.Should().Be(DateTime.Parse("1/1/1987 12:00:00 AM"));
            response.WorkOrderID.Should().Be(1);
        }
Ejemplo n.º 23
0
        ///<summary>
        ///  Update the Typed WorkOrderRouting Entity with modified mock values.
        ///</summary>
        static public void UpdateMockInstance_Generated(TransactionManager tm, WorkOrderRouting mock)
        {
            mock.ScheduledStartDate = TestUtility.Instance.RandomDateTime();
            mock.ScheduledEndDate   = TestUtility.Instance.RandomDateTime();
            mock.ActualStartDate    = TestUtility.Instance.RandomDateTime();
            mock.ActualEndDate      = TestUtility.Instance.RandomDateTime();
            mock.ActualResourceHrs  = (decimal)TestUtility.Instance.RandomShort();
            mock.PlannedCost        = TestUtility.Instance.RandomShort();
            mock.ActualCost         = TestUtility.Instance.RandomShort();
            mock.ModifiedDate       = TestUtility.Instance.RandomDateTime();

            //OneToOneRelationship
            Location mockLocationByLocationId = LocationTest.CreateMockInstance(tm);

            DataRepository.LocationProvider.Insert(tm, mockLocationByLocationId);
            mock.LocationId = mockLocationByLocationId.LocationId;

            //OneToOneRelationship
            WorkOrder mockWorkOrderByWorkOrderId = WorkOrderTest.CreateMockInstance(tm);

            DataRepository.WorkOrderProvider.Insert(tm, mockWorkOrderByWorkOrderId);
            mock.WorkOrderId = mockWorkOrderByWorkOrderId.WorkOrderId;
        }
		/// <summary>
		/// Deep load all WorkOrderRouting children.
		/// </summary>
		private void Step_03_DeepLoad_Generated()
		{
			using (TransactionManager tm = CreateTransaction())
			{
				int count = -1;
				mock =  CreateMockInstance(tm);
				mockCollection = DataRepository.WorkOrderRoutingProvider.GetPaged(tm, 0, 10, out count);
			
				DataRepository.WorkOrderRoutingProvider.DeepLoading += new EntityProviderBaseCore<WorkOrderRouting, WorkOrderRoutingKey>.DeepLoadingEventHandler(
						delegate(object sender, DeepSessionEventArgs e)
						{
							if (e.DeepSession.Count > 3)
								e.Cancel = true;
						}
					);

				if (mockCollection.Count > 0)
				{
					
					DataRepository.WorkOrderRoutingProvider.DeepLoad(tm, mockCollection[0]);
					System.Console.WriteLine("WorkOrderRouting instance correctly deep loaded at 1 level.");
									
					mockCollection.Add(mock);
					// DataRepository.WorkOrderRoutingProvider.DeepSave(tm, mockCollection);
				}
				
				//normally one would commit here
				//tm.Commit();
				//IDisposable will Rollback Transaction since it's left uncommitted
			}
		}
Ejemplo n.º 25
0
        public static string NewSRMARequest(string phoneNumber, string locationId)
        {
            //using (SqlConnection conn = new SqlConnection("Data Source=AIP-SQLAIPL;Initial Catalog=Aipl;User ID=ambiflux;Password=ambiflux"))
            //{
            //conn.Open();

            //1- on regarde s'il existe un contact avec le numéro de tél
            DataClasses1DataContext ctx = new DataClasses1DataContext("Data Source=AIP-SQLAIPL;Initial Catalog=Aipl;User ID=ambiflux;Password=ambiflux");

            // DataClassesDataContext ctx = new DataClassesDataContext("Data Source=AIP-SQLAIPL;Initial Catalog=Aipl;User ID=ambiflux;Password=ambiflux");

            var contact = (from c in ctx.Contact where c.Phone == phoneNumber select c).SingleOrDefault();

            if (contact != null)
            //on recherche le customer correspondant
            {
                var customer = (from c in ctx.Customer where c.Contact == contact select c).SingleOrDefault();
                //normalement on passe par là!
                if (customer != null)
                {
                    //Création d'un nouvel orderHeader
                    OrderHeader o = new OrderHeader();
                    o.Customer = customer;

                    var loc = (from l in ctx.Location where l.LocationID == System.Convert.ToInt32(locationId) select l).SingleOrDefault();
                    o.Location = loc;
                    //o.DeliveryLocationID = System.Convert.ToInt32(locationId);
                    o.OrderType     = 'C';
                    o.Comment       = "Demande effectuee par tél";
                    o.OrderStatusID = 1;

                    ctx.OrderHeader.InsertOnSubmit(o);
                    //ctx.SubmitChanges();

                    WorkOrder wo = new WorkOrder();
                    wo.OrderHeader       = o;
                    wo.Type              = "CAL";
                    wo.WorkOrderStatusID = 1;

                    wo.OrderHeader = o;

                    ctx.WorkOrder.InsertOnSubmit(wo);
                    //ctx.SubmitChanges();


                    WorkOrderRouting wor = new WorkOrderRouting();
                    wor.Location          = loc;
                    wor.Type              = 'T';
                    wor.OperationSequence = 10;

                    wor.WorkOrder = wo;

                    ctx.WorkOrderRouting.InsertOnSubmit(wor);

                    ctx.SubmitChanges();

                    return("ok");
                }
            }



            /* return (from w in ctx.V_Order
             *       where w.OrderID == System.Convert.ToInt32(orderHeaderId)
             *       select new OrderHeaderRecord
             *       {
             *           OrderId = w.OrderID,
             *           OrderNo = w.OrderNo,
             *           ObjetDemandeExpress = w.ObjetDemandeExpress,
             *           CustomerFirstName = w.CustomerFirstName,
             *           CustomerLastName = w.CustomerLastName,
             *           OrderDate = w.OrderDate.ToString()
             *       }).SingleOrDefault();
             */


            /*
             *
             *  SqlCommand cmd = new SqlCommand("insert into Workorder(Type) values(@Type)", conn);
             *
             *  cmd.Parameters.AddWithValue("@Type", 'T');
             *  int result = cmd.ExecuteNonQuery();
             *  string Message;
             *  if (result == 1)
             *  {
             *      Message = " Details inserted successfully";
             *  }
             *  else
             *  {
             *      Message = " Details not inserted successfully";
             *  }
             *
             *  //conn.Close();
             *
             *  return Message;
             *
             * //}*/
            return("Pas OK");
        }
Ejemplo n.º 26
0
		/// <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(WorkOrderRouting mock)
        {
            //Code your changes to the data object here.
            mock.ActualEndDate = mock.ActualStartDate.Value.AddDays(1);
            mock.ScheduledEndDate = mock.ScheduledStartDate.AddDays(1);
            mock.ActualResourceHrs = TestUtility.Instance.RandomNumber(0, 99999);

        }
Ejemplo n.º 27
0
        ///<summary>
        ///  Update the Typed WorkOrderRouting Entity with modified mock values.
        ///</summary>
        static public void UpdateMockInstance(TransactionManager tm, WorkOrderRouting mock)
        {
            WorkOrderRoutingTest.UpdateMockInstance_Generated(tm, mock);
            
			// make any alterations necessary 
            // (i.e. for DB check constraints, special test cases, etc.)
			SetSpecialTestData(mock);
        }
		/// <summary>
		/// Serialize the mock WorkOrderRouting 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_WorkOrderRouting.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>
		/// Serialize a WorkOrderRouting 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_WorkOrderRoutingCollection.xml");
				
				mock = CreateMockInstance(tm);
				TList<WorkOrderRouting> mockCollection = new TList<WorkOrderRouting>();
				mockCollection.Add(mock);
			
				EntityHelper.SerializeXml(mockCollection, fileName);
				
				Assert.IsTrue(System.IO.File.Exists(fileName), "Serialized mock collection not found");
				System.Console.WriteLine("TList<WorkOrderRouting> correctly serialized to a temporary file.");					
			}
		}
		///<summary>
		///  Returns a Typed WorkOrderRouting Entity with mock values.
		///</summary>
		static public WorkOrderRouting CreateMockInstance_Generated(TransactionManager tm)
		{		
			WorkOrderRouting mock = new WorkOrderRouting();
						
			mock.ProductId = TestUtility.Instance.RandomNumber();
			mock.OperationSequence = TestUtility.Instance.RandomShort();
			mock.ScheduledStartDate = TestUtility.Instance.RandomDateTime();
			mock.ScheduledEndDate = TestUtility.Instance.RandomDateTime();
			mock.ActualStartDate = TestUtility.Instance.RandomDateTime();
			mock.ActualEndDate = TestUtility.Instance.RandomDateTime();
			mock.ActualResourceHrs = (decimal)TestUtility.Instance.RandomShort();
			mock.PlannedCost = TestUtility.Instance.RandomShort();
			mock.ActualCost = TestUtility.Instance.RandomShort();
			mock.ModifiedDate = TestUtility.Instance.RandomDateTime();
			
			//OneToOneRelationship
			Location mockLocationByLocationId = LocationTest.CreateMockInstance(tm);
			DataRepository.LocationProvider.Insert(tm, mockLocationByLocationId);
			mock.LocationId = mockLocationByLocationId.LocationId;
			//OneToOneRelationship
			WorkOrder mockWorkOrderByWorkOrderId = WorkOrderTest.CreateMockInstance(tm);
			DataRepository.WorkOrderProvider.Insert(tm, mockWorkOrderByWorkOrderId);
			mock.WorkOrderId = mockWorkOrderByWorkOrderId.WorkOrderId;
		
			// create a temporary collection and add the item to it
			TList<WorkOrderRouting> tempMockCollection = new TList<WorkOrderRouting>();
			tempMockCollection.Add(mock);
			tempMockCollection.Remove(mock);
			
		
		   return (WorkOrderRouting)mock;
		}
 /// <summary>
 /// There are no comments for WorkOrderRouting in the schema.
 /// </summary>
 public void AddToWorkOrderRouting(WorkOrderRouting workOrderRouting)
 {
     base.AddObject("WorkOrderRouting", workOrderRouting);
 }
 /// <summary>
 /// Create a new WorkOrderRouting object.
 /// </summary>
 /// <param name="workOrderID">Initial value of WorkOrderID.</param>
 /// <param name="productID">Initial value of ProductID.</param>
 /// <param name="operationSequence">Initial value of OperationSequence.</param>
 /// <param name="scheduledStartDate">Initial value of ScheduledStartDate.</param>
 /// <param name="scheduledEndDate">Initial value of ScheduledEndDate.</param>
 /// <param name="plannedCost">Initial value of PlannedCost.</param>
 /// <param name="modifiedDate">Initial value of ModifiedDate.</param>
 public static WorkOrderRouting CreateWorkOrderRouting(int workOrderID, int productID, short operationSequence, global::System.DateTime scheduledStartDate, global::System.DateTime scheduledEndDate, decimal plannedCost, global::System.DateTime modifiedDate)
 {
     WorkOrderRouting workOrderRouting = new WorkOrderRouting();
     workOrderRouting.WorkOrderID = workOrderID;
     workOrderRouting.ProductID = productID;
     workOrderRouting.OperationSequence = operationSequence;
     workOrderRouting.ScheduledStartDate = scheduledStartDate;
     workOrderRouting.ScheduledEndDate = scheduledEndDate;
     workOrderRouting.PlannedCost = plannedCost;
     workOrderRouting.ModifiedDate = modifiedDate;
     return workOrderRouting;
 }
		/// <summary>
		/// Test methods exposed by the EntityHelper class.
		/// </summary>
		private void Step_20_TestEntityHelper_Generated()
		{
			using (TransactionManager tm = CreateTransaction())
			{
				mock = CreateMockInstance(tm);
				
				WorkOrderRouting entity = mock.Copy() as WorkOrderRouting;
				entity = (WorkOrderRouting)mock.Clone();
				Assert.IsTrue(WorkOrderRouting.ValueEquals(entity, mock), "Clone is not working");
			}
		}
Ejemplo n.º 34
0
 // POST api/awbuildversion
 public void Post(WorkOrderRouting value)
 {
     adventureWorks_BC.WorkOrderRoutingAdd(value);
 }
 // POST api/awbuildversion
 public void Post(WorkOrderRouting value)
 {
     adventureWorks_BC.WorkOrderRoutingAdd(value);
 }
		///<summary>
		///  Update the Typed WorkOrderRouting Entity with modified mock values.
		///</summary>
		static public void UpdateMockInstance_Generated(TransactionManager tm, WorkOrderRouting mock)
		{
			mock.ScheduledStartDate = TestUtility.Instance.RandomDateTime();
			mock.ScheduledEndDate = TestUtility.Instance.RandomDateTime();
			mock.ActualStartDate = TestUtility.Instance.RandomDateTime();
			mock.ActualEndDate = TestUtility.Instance.RandomDateTime();
			mock.ActualResourceHrs = (decimal)TestUtility.Instance.RandomShort();
			mock.PlannedCost = TestUtility.Instance.RandomShort();
			mock.ActualCost = TestUtility.Instance.RandomShort();
			mock.ModifiedDate = TestUtility.Instance.RandomDateTime();
			
			//OneToOneRelationship
			Location mockLocationByLocationId = LocationTest.CreateMockInstance(tm);
			DataRepository.LocationProvider.Insert(tm, mockLocationByLocationId);
			mock.LocationId = mockLocationByLocationId.LocationId;
					
			//OneToOneRelationship
			WorkOrder mockWorkOrderByWorkOrderId = WorkOrderTest.CreateMockInstance(tm);
			DataRepository.WorkOrderProvider.Insert(tm, mockWorkOrderByWorkOrderId);
			mock.WorkOrderId = mockWorkOrderByWorkOrderId.WorkOrderId;
					
		}