Example #1
0
        /// <summary>
        /// Get the next free serial numbers for this device class from the d/b. Also check there are no devices with these serials in the d/b
        /// </summary>
        private void ButtonGetSerialNumbersClick()
        {
            Device device;

            buttonGo.Enabled = false;

            foreach (TestItem testItem in Globals.TestList.TestItems)
                testItem.Status = !testItem.Enabled ? EnumTestStatus.Disabled : EnumTestStatus.NotStarted;
            dataGridView1.Columns["Execute"].Visible = checkBoxLocalTest.Checked;
            dataGridView1.Refresh();

            //
            // Note: AJL: Need to think about whether somebody else could get the ID we are working with?
            //
            try
            {
                // Check customer serial is within range
                var serial = long.Parse(textBoxEndUserSerial.Text);
                bool ok;
                if (Globals.DeviceClass.MaxCustomerSerial != null)
                    ok = serial >= long.Parse(Globals.DeviceClass.MinCustomerSerial) ||
                         serial <= long.Parse(Globals.DeviceClass.MaxCustomerSerial);
                else
                    ok = serial >= long.Parse(Globals.DeviceClass.MinCustomerSerial);

                if (!ok)
                {
                    MessageBoxEx.Show("The serial number is outside the allowed range (" +
                                    Globals.DeviceClass.MinCustomerSerial + "-"
                                    + ((Globals.DeviceClass.MaxCustomerSerial != null) ? (Globals.DeviceClass.MaxCustomerSerial) : "\u221E")
                                    + ")");
                    return;
                }

                using (var transaction = Session.BeginTransaction())
                {
                    try
                    {
                        // Check if customer serial is in d/b
                        ICriteria criteria = Session.CreateCriteria(typeof (Device));
                        criteria.Add(
                            Restrictions.Eq("CustomerSerialNumber", textBoxEndUserSerial.Text)
                            );
                        var results = criteria.List<Device>();
                        if (results.Count > 1)
                        {
                            // Shouldn't happen
                            MessageBoxEx.Show(
                                "There are " + results.Count +
                                " devices in the database with this serial number. Please contact board vendor");
                            Logger.Warn("There are " + results.Count +
                                         " devices in the database with the entered serial number (" +
                                         textBoxEndUserSerial.Text + ")");
                            transaction.Rollback();
                            return;
                        }
                        if (results.Count == 1)
                        {
                            // There have been tests for this customer serial number.
                            // Check if any of those tests have been successful 
                            int tests = 0;
                            int testSuccesses = 0;
                            foreach (var d in results)
                            {
                                foreach (var tlr in d.TestListResults)
                                {
                                    if (tlr.Result)
                                        testSuccesses++;
                                    tests++;
                                }
                            }
                            if (testSuccesses > 0)
                            {
                                DialogResult dr = MessageBoxEx.Show(
                                    "This customer serial number has already tested successfully " + testSuccesses + "/" +
                                    tests +
                                    " time(s). Please confirm you are retesting.", "Retesting?", MessageBoxButtons.YesNo,
                                    MessageBoxIcon.Question);
                                if (dr != DialogResult.Yes)
                                {
                                    transaction.Rollback();
                                    return;
                                }
                            }

                            if (tests > 0)
                            {
                                DialogResult dr = MessageBoxEx.Show(
                                    "This serial number has failed testing " + tests +
                                    " time(s). Please confirm you are retesting.", "Retesting?", MessageBoxButtons.YesNo,
                                    MessageBoxIcon.Question);
                                if (dr != DialogResult.Yes)
                                {
                                    transaction.Rollback();
                                    return;
                                }
                            }
                            device = results[0];

                            // Set existing board vendor serial
                            textBoxProducerSerial.Text = device.ProducerSerialNumber;
                        }
                        else
                        {
                            // Ensure device class is refreshed
                            Session.Refresh(Globals.DeviceClass);

                            // Set new board vendor serial number
                            var lastProducerSerial = Globals.DeviceClass.LastProducerSerial;

                            // TBD: Check this doesn't exist?

                            int lvs;

                            if (lastProducerSerial == null)
                            {
                                lastProducerSerial = Globals.DeviceClass.MinProducerSerial;
                                lvs = int.Parse(lastProducerSerial);
                            }
                            else
                            {
                                lvs = int.Parse(lastProducerSerial);
                                lvs = lvs + 1;
                            }

                            if (Globals.DeviceClass.MaxProducerSerial != null)
                            {
                                if (lvs > int.Parse(Globals.DeviceClass.MaxProducerSerial))
                                {
                                    MessageBoxEx.Show(
                                        "Problem - there are no free producer serial numbers. Contact board board vendor");
                                    transaction.Rollback();
                                    return;
                                }
                            }
                            textBoxProducerSerial.Text = lvs.ToString();

                            // Update last serials
                            Globals.DeviceClass.LastCustomerSerial = textBoxEndUserSerial.Text;
                            Globals.DeviceClass.LastProducerSerial = textBoxProducerSerial.Text;
                            Session.SaveOrUpdate(Globals.DeviceClass);

                            // Create new device
                            device = new Device
                                         {
                                             CreationDate = DateTime.Now,
                                             DeviceClass = Globals.DeviceClass,
                                             CustomerSerialNumber = textBoxEndUserSerial.Text,
                                             ProducerSerialNumber = textBoxProducerSerial.Text,
                                             Creator = Globals.LoggedInUser,
                                         };
                        }

                        // Whatever we just did, make sure last test date/person are correct
                        device.LastTestDate = DateTime.Now;
                        device.LastTester = Globals.LoggedInUser;

                        // - Store it to d/b
                        Session.SaveOrUpdate(device);

                        if (Globals.Device != null)
                        {
                            //                        Debug.Assert(Globals.Device.Equals(device), "Problem as devices different?");
                            Session.Evict(Globals.Device);
                        }
                        // Store new device
                        Globals.Device = device;

                        // All done
                        transaction.Commit();
                    }
                    catch (Exception ex)
                    {
                        Logger.Warn("Exception dealing with serial numbers: " + ex.Message);
                        transaction.Rollback();
                        return;
                    }
                }

                // Update Globals
                Globals.ProducerSerialNumber = textBoxProducerSerial.Text;
                Globals.CustomerSerialNumber = textBoxEndUserSerial.Text;

                // Update UI
                pictureBoxSerials.Image = imageList1.Images["tick"];
                pictureBoxRunTest.Image = imageList1.Images["tick"];
                buttonGo.Enabled = true;
                buttonGo.Select();
            }
            catch (Exception e)
            {
                Logger.Warn("Exception getting/dealing with serial numbers: " + e.Message);
            }
        }
Example #2
0
        /// <summary>
        /// Store test results to local XML file
        /// </summary>
        /// <param name="device"></param>
        private static void PersistResultsXML(Device device)
        {
            var strDoc = new StringBuilder();
            
            strDoc.Append("<?xml version=\"1.0\" encoding=\"utf-8\" ?>\r\n\r\n");

            strDoc.Append("<device>\r\n");
            strDoc.Append("  <creationdate>" + device.CreationDate + "</creationdate>\r\n"); 
            strDoc.Append("  <creator>" + XmlTextEncoder.Encode(device.Creator.Forename + " " + device.Creator.Surname) + "</creator>\r\n");
            strDoc.Append("  <customerserialnumber>" + XmlTextEncoder.Encode(device.CustomerSerialNumber) + "</customerserialnumber>\r\n");
            strDoc.Append("  <deviceclass>" + XmlTextEncoder.Encode(device.DeviceClass.Name) + "</deviceclass>\r\n");
            strDoc.Append("  <lasttestdate>" + XmlTextEncoder.Encode(device.LastTestDate.ToString()) + "</lasttestdate>\r\n");
            strDoc.Append("  <lasttester>" + XmlTextEncoder.Encode(device.LastTester.Forename + " " + device.LastTester.Surname) + "</lasttester>\r\n");
            strDoc.Append("  <producerserialnumber>" + XmlTextEncoder.Encode(device.ProducerSerialNumber) + "</producerserialnumber>\r\n");

            strDoc.Append("  <testlistresults>\r\n");

            var tl = device.TestListResults[device.TestListResults.Count - 1];

            //foreach (var tl in device.TestListResults)
            {
                strDoc.Append("    <testlistresult>\r\n");
                strDoc.Append("      <creationdate>" + XmlTextEncoder.Encode(tl.CreationDate.ToString()) + "</creationdate>\r\n");
                strDoc.Append("      <result>" + XmlTextEncoder.Encode(tl.Result.ToString()) + "</result>\r\n");
                strDoc.Append("      <testlist>" + XmlTextEncoder.Encode(tl.TestList.Name) + "</testlist>\r\n");
                strDoc.Append("      <testlocation>" + XmlTextEncoder.Encode(tl.TestLocation.Name) + "</testlocation>\r\n");
                strDoc.Append("      <tester>" + XmlTextEncoder.Encode(tl.Employee.Forename + " " + tl.Employee.Surname) + "</tester>\r\n");
                strDoc.Append("      <company>" + XmlTextEncoder.Encode(tl.Employee.Company.Name) + "</company>\r\n");

                strDoc.Append("      <testitemresults>\r\n");
                foreach (var ti in tl.TestItemResults)
                {
                    strDoc.Append("        <testitemresult>\r\n");
                    strDoc.Append("          <creationdate>" + XmlTextEncoder.Encode(ti.CreationDate.ToString()) + "</creationdate>\r\n");
                    strDoc.Append("          <name>" + XmlTextEncoder.Encode(ti.TestItem.Name) + "</name>\r\n");
                    strDoc.Append("          <result>" + XmlTextEncoder.Encode(ti.Result.ToString()) + "</result>\r\n");
                    strDoc.Append("          <notes>" + XmlTextEncoder.Encode(ti.Notes) + "</notes>\r\n");
                    strDoc.Append("        </testitemresult>\r\n");
                }
                strDoc.Append("      </testitemresults>\r\n");
                strDoc.Append("    </testlistresult>\r\n");
            }

            strDoc.Append("  </testlistresults>\r\n");

            strDoc.Append("</device>\r\n");

            using (var fs = new FileStream(Globals.LocalResultFile, FileMode.OpenOrCreate))
            {
                var writer = new StreamWriter(fs);

                writer.Write(strDoc.ToString());

                writer.Close();
            }
        }