Exemplo n.º 1
0
        public void TestSaevSession()
        {
            using (Entities entities = new Entities())
            {
                try
                {
                    entities.Database.ExecuteSqlCommand("DELETE FROM sessions");
                }
                catch (Exception ex)
                { }

                try
                {
                    entities.Database.ExecuteSqlCommand("DELETE FROM technicians");
                }
                catch (Exception ex)
                { }
                entities.SaveChanges();
            }

            DataManager.Instance.AddTechnician("dan");

            using (Entities entities = new Entities())
            {
                Assert.AreEqual(1, entities.technicians.Count());
            }

            technician technicianDan;
            using (Entities entities = new Entities())
            {
                technicianDan = entities.technicians.FirstOrDefault(t => t.technician_name == "dan");
                Assert.IsNotNull(technicianDan);
            }

            session newSession = new session { technician = technicianDan, session_time_stamp = DateTime.Now };

            using (Entities entities = new Entities())
            {
                entities.sessions.Attach(newSession);
                newSession = entities.sessions.Add(newSession);
                Assert.IsTrue(entities.SaveChanges() > 0);
                Assert.IsNotNull(newSession);
            }
        }
Exemplo n.º 2
0
        public session SetCurrentRunComplete(session currentSession)
        {
            try
            {
                using (Entities entities = new Entities())
                {
                    entities.sessions.Attach(currentSession);
                    entities.runs.Attach(currentSession.runs.Last());
                    currentSession.runs.Last().run_complete_timestamp = DateTime.Now; // Update on every save
                    currentSession.runs.Last().run_complete = 1;

                    entities.SaveChanges();
                    return currentSession;
                }
            }
            catch (Exception ex)
            {
                _log.Error(ex);
                throw;
            }
        }
Exemplo n.º 3
0
 public bool SaveSession(session currentSession)
 {
     try
     {
         using (Entities entities = new Entities())
         {
             entities.sessions.Attach(currentSession);
             return entities.SaveChanges() > 0;
         }
     }
     catch (Exception ex)
     {
         _log.Error(ex);
         throw;
     }
 }
Exemplo n.º 4
0
        public session SaveResponses(session currentSession)
        {
            try
            {
                using (Entities entities = new Entities())
                {
                    entities.sessions.Attach(currentSession);
                    entities.runs.Attach(currentSession.runs.Last());

                    currentSession.runs.Last().run_complete_timestamp = DateTime.Now; // Update on every save
                    foreach (var responseItem in currentSession.runs.Last().responses)
                    {
                        entities.responses.Attach(responseItem);
                        entities.Entry(responseItem).State = EntityState.Modified;
                    }

                    entities.SaveChanges();
                    return currentSession;
                }
            }
            catch (Exception ex)
            {
                _log.Error(ex);
                throw;
            }
        }
Exemplo n.º 5
0
 public session AddSession(session currentSession)
 {
     try
     {
         using (Entities entities = new Entities())
         {
             // Attach first so that the child objects (technician in this case) is bound to the new data context
             entities.sessions.Attach(currentSession);
             entities.sessions.Add(currentSession);
             entities.SaveChanges();
             return currentSession;
         }
     }
     catch (Exception ex)
     {
         _log.Error(ex);
         throw;
     }
 }
Exemplo n.º 6
0
        public session AddRun(session currentSession, run currentRun, bool isNewPCB)
        {
            try
            {
                using (Entities entities = new Entities())
                {
                    entities.sessions.Attach(currentSession);

                    currentRun.run_complete_timestamp = currentRun.run_start_timestamp = DateTime.Now;
                    currentRun.session = currentSession;

                    currentSession.runs.Add(currentRun);
                    entities.runs.Add(currentRun);

                    foreach (var responseItem in currentRun.responses)
                    {
                        entities.responses.Add(responseItem);
                    }

                    if (isNewPCB)
                    {
                        entities.pcb_unit.Add(currentRun.pcb_unit);
                    }
                    else
                    {
                        //entities.Entry(pcbUnit).State = EntityState.Unchanged;
                        entities.pcb_unit.Attach(currentRun.pcb_unit);
                    }

                    entities.SaveChanges();
                    return entities.sessions.First(s => s.session_id == currentSession.session_id);

                }
            }
            catch (Exception ex)
            {
                _log.Error(ex);
                throw;
            }
        }
        public void InitialiaseTestRun(string manufactureSerial)
        {
            var currentTestRun = new run();

            var testUnit = DataManager.Instance.GetTestUnit(manufactureSerial);
            if (testUnit != null)
            {
                IsRetest = true;
                // Check if this pcb unit is being tracked in the current DbContext
                pcb_unit localReference = null;
                foreach (var run in _currentSession.runs)
                {
                    if (testUnit.pcb_unit_id == run.pcb_unit.pcb_unit_id)
                        localReference = run.pcb_unit;
                }

                if (localReference != null)
                    currentTestRun.pcb_unit = localReference;
                else
                    currentTestRun.pcb_unit = testUnit;
            }
            else
            {
                IsRetest = false;
                currentTestRun.pcb_unit = new pcb_unit();
                currentTestRun.pcb_unit.pcb_unit_serial_sticker_manufacture = manufactureSerial;
                currentTestRun.pcb_unit.pcb_unit_serial_number = "TEST";
            }

            CreateNewTestRunResponses(currentTestRun);

            _currentSession = DataManager.Instance.AddRun(_currentSession, currentTestRun, !IsRetest);
        }
        public void StartTestSession(string technicianName)
        {
            var technicain = DataManager.Instance.GetTechnician(technicianName);
            _currentSession = new session();
            _currentSession.technician = technicain;
            _currentSession.session_time_stamp = DateTime.Now;

            _currentSession = DataManager.Instance.AddSession(_currentSession);
        }