private void btnStartTest_Click(object sender, EventArgs e)
        {
            using (KYLIEEntities ctx = new KYLIEEntities())
            {
                SCAN_ScanType st = new SCAN_ScanType();
                st.Barcode  = "DISP2222";
                st.ScanDate = DateTime.Now;
                st.ScanType = 2;



                // Check exists, or add new

                SCAN_AssemblyScans sa = ctx.SCAN_AssemblyScans.FirstOrDefault(f => f.UniqueIdentifier == 1);

                st.SCAN_AssemblyScans.Add(sa);

                //st.SCAN_AssemblyScans.Add(new SCAN_AssemblyScans() { Barcode = "A145-1", EntityID = 145, UniqueIdentifier = 1 });
                //st.SCAN_AssemblyScans.Add(new SCAN_AssemblyScans() { Barcode = "A144-2", EntityID = 144, UniqueIdentifier = 2 });
                //st.SCAN_AssemblyScans.Add(new SCAN_AssemblyScans() { Barcode = "A143-3", EntityID = 143, UniqueIdentifier = 3 });

                //SCAN_ScanType newScan =
                //newScan.SCAN_AssemblyScans.Add(sa);

                ctx.SCAN_ScanType.Add(st);

                ctx.SaveChanges();
            }
        }
Example #2
0
        private void UpdateStockStatus()
        {
            BarcodeForm.GetInstance().lbStockStatus.Items.Clear();
            BarcodeForm.GetInstance().lbStockStatus.Items.Add(string.Format("Stock Status: {0} on {1}.", DateTime.Now.ToLongTimeString(), DateTime.Now.ToLongDateString()));

            using (KYLIEEntities ctx = new KYLIEEntities())
            {
                int dispatchTypeID    = (int)Convert.ChangeType(BarcodeProcessType.DISPATCH, BarcodeProcessType.DISPATCH.GetTypeCode());
                int galvanisingTypeID = (int)Convert.ChangeType(BarcodeProcessType.GALVANISING, BarcodeProcessType.GALVANISING.GetTypeCode());

                Dictionary <int, int> entityGalvanisingIDs = new Dictionary <int, int>();
                Dictionary <int, int> entityDispatchIDs    = new Dictionary <int, int>();

                // ##########  GALAVANISING #######################

                var galavanisingEntityIDsScanned = (from st in ctx.SCAN_ScanType
                                                    where st.ScanType == galvanisingTypeID
                                                    select st.SCAN_AssemblyScans).ToList();

                foreach (var sList in galavanisingEntityIDsScanned)
                {
                    foreach (var s in sList)
                    {
                        // Must be first time round, so add the first Assembly EntityID
                        if (entityGalvanisingIDs.Count == 0)
                        {
                            entityGalvanisingIDs.Add(s.EntityID, 1);
                        }
                        else
                        {
                            foreach (var a in entityGalvanisingIDs)
                            {
                                if (entityGalvanisingIDs.ContainsKey(s.EntityID))
                                {
                                    entityGalvanisingIDs[s.EntityID] = entityGalvanisingIDs[s.EntityID] + 1;
                                    break;
                                }
                                else
                                {
                                    entityGalvanisingIDs.Add(s.EntityID, 1);
                                    break;
                                }
                            }
                        }
                    }
                }

                List <int> distinctScannedGalvanisingEntityIDs = entityGalvanisingIDs.Keys.ToList();
                var        descriptionAssemblyGalvanising      = ctx.Assemblies.Where(f => distinctScannedGalvanisingEntityIDs.Contains(f.SubComponents_PK)).Select(f => new { id = f.SubComponents_PK, desc = f.SubComponentDescription }).ToList();

                // ###### DISPATCH ##############################

                var dispatchEntityIDsScanned = (from st in ctx.SCAN_ScanType
                                                where st.ScanType == dispatchTypeID
                                                select st.SCAN_AssemblyScans).ToList();

                foreach (var sList in dispatchEntityIDsScanned)
                {
                    foreach (var s in sList)
                    {
                        // Must be first time round, so add the first Assembly EntityID
                        if (entityDispatchIDs.Count == 0)
                        {
                            entityDispatchIDs.Add(s.EntityID, 1);
                        }
                        else
                        {
                            foreach (var a in entityDispatchIDs)
                            {
                                if (entityDispatchIDs.ContainsKey(s.EntityID))
                                {
                                    entityDispatchIDs[s.EntityID] = entityDispatchIDs[s.EntityID] + 1;
                                    break;
                                }
                                else
                                {
                                    entityDispatchIDs.Add(s.EntityID, 1);
                                    break;
                                }
                            }
                        }
                    }
                }



                List <int> distinctScannedDispatchEntityIDs = entityDispatchIDs.Keys.ToList();
                var        descriptionAssemblyDispatch      = ctx.Assemblies.Where(f => distinctScannedDispatchEntityIDs.Contains(f.SubComponents_PK)).Select(f => new { id = f.SubComponents_PK, desc = f.SubComponentDescription }).ToList();



                // ####### DISPLAY #############################

                BarcodeForm.GetInstance().lbStockStatus.Items.Add("");
                BarcodeForm.GetInstance().lbStockStatus.Items.Add("Scanned back from galvanising");
                BarcodeForm.GetInstance().lbStockStatus.Items.Add("");


                foreach (var d in descriptionAssemblyGalvanising)
                {
                    int    cnt      = 0;
                    string assyDesc = "";
                    if (d.desc == null)
                    {
                        assyDesc = "Can't find the assembly!!!!";
                    }
                    else
                    {
                        assyDesc = string.Format("\t{0} {1}", d.desc, entityGalvanisingIDs.TryGetValue(d.id, out cnt) ? cnt : 0);
                    }
                    BarcodeForm.GetInstance().lbStockStatus.Items.Add(assyDesc);
                }

                BarcodeForm.GetInstance().lbStockStatus.Items.Add("");
                BarcodeForm.GetInstance().lbStockStatus.Items.Add("Scanned as dispatched");
                BarcodeForm.GetInstance().lbStockStatus.Items.Add("");


                foreach (var d in descriptionAssemblyDispatch)
                {
                    int    cnt      = 0;
                    string assyDesc = "";
                    if (d == null)
                    {
                        assyDesc = "Can't find the assembly!!!!";
                    }
                    else
                    {
                        assyDesc = string.Format("\t{0} {1}", d.desc, entityDispatchIDs.TryGetValue(d.id, out cnt) ? cnt : 0);
                    }
                    BarcodeForm.GetInstance().lbStockStatus.Items.Add(assyDesc);
                }

                BarcodeForm.GetInstance().lbStockStatus.Items.Add("");
                BarcodeForm.GetInstance().lbStockStatus.Items.Add("Stock level");
                BarcodeForm.GetInstance().lbStockStatus.Items.Add("");

                foreach (var d in descriptionAssemblyGalvanising)
                {
                    int    cntGalv  = 0;
                    int    cntDisp  = 0;
                    string assyDesc = "";
                    if (d.desc == null)
                    {
                        assyDesc = "Can't find the assembly!!!!";
                    }
                    else
                    {
                        int backFromGalv   = entityGalvanisingIDs.TryGetValue(d.id, out cntGalv) ? cntGalv : 0;
                        int sentToDispatch = entityDispatchIDs.TryGetValue(d.id, out cntDisp) ? cntDisp : 0;

                        assyDesc = string.Format("\t{0} {1}", d.desc, (backFromGalv - sentToDispatch));
                    }
                    BarcodeForm.GetInstance().lbStockStatus.Items.Add(assyDesc);
                }
            }
        }
Example #3
0
        private void LookupBarcode(string barcode)
        {
            string prefix = barcode.Substring(0, 1);

            char[] delimiterChars = { '-', ',', '.', ':', '\t' };

            string[] splitBarcode = barcode.Split(delimiterChars);
            int      EntityID     = Int32.Parse(splitBarcode[0].Substring(1, splitBarcode[0].Length - 1));
            int      id           = EntityID;

            string description = string.Empty;

            using (KYLIEEntities ctx = new KYLIEEntities())
            {
                switch (prefix)
                {
                case "A":
                    description = ctx.Assemblies.Where(f => f.SubComponents_PK == id).Select(f => f.SubComponentDescription).FirstOrDefault();
                    if (description == null)
                    {
                        description = string.Format("Cannot locate the assembly {0}", id);
                    }
                    break;

                case "G":
                    var galv = ctx.GalvDeliveries.Where(f => f.GalvDelID == id).FirstOrDefault();
                    if (galv != null)
                    {
                        description = string.Format("{0}", galv.GalvDestination);
                    }
                    else
                    {
                        description = string.Format("Cannot locate galvenisng note {}", id);
                    }

                    break;

                case "D":
                    var disp = ctx.Dispatches.Where(f => f.HutchDispRefID == id).FirstOrDefault();
                    if (disp != null)
                    {
                        var contract = ctx.Contracts.Where(f => f.Contract_PK == disp.ContractID).FirstOrDefault();
                        description = string.Format("{0}, {1}, {2}, {3}, {4}, {5}, {6}", contract.ContractName,
                                                    disp.Addr1,
                                                    disp.Addr2,
                                                    disp.Addr3,
                                                    disp.Town,
                                                    disp.County,
                                                    disp.PostCode);
                    }
                    else
                    {
                        description = string.Format("Cannot locate the dispatch note {0}!", id);
                    }
                    break;

                default:
                    break;
                }
            }


            this.SetText(description);
        }
Example #4
0
        private void FinaliseScannedObject(List <ScanObject> o)
        {
            List <string> assembliesScanned = new List <string>();
            Boolean       canAddAssembly    = false;

            try
            {
                using (KYLIEEntities ctx = new KYLIEEntities())
                {
                    foreach (ScanObject scanObject in o)
                    {
                        // Check it doesn't already exist first, else add new.

                        SCAN_ScanType so = ctx.SCAN_ScanType.FirstOrDefault(f => f.Barcode == scanObject.ScanObjectIdentifier);
                        if (so != null)
                        {
                            MessageBox.Show(string.Format("{0} has already been scanned.", so.Barcode));
                            return;
                        }

                        // Now generate a new ScanType object to insert

                        SCAN_ScanType scanType = new SCAN_ScanType();
                        scanType.ScanDate = DateTime.Now;
                        scanType.Barcode  = scanObject.ScanObjectIdentifier;
                        scanType.ScanType = (int)Convert.ChangeType(scanObject.ScanObjectType, scanObject.ScanObjectType.GetTypeCode());

                        foreach (ScanObjectItem item in scanObject.ScannedObjects)
                        {
                            if (assembliesScanned.Contains(item.ObjectBarcode))
                            {
                                MessageBox.Show(string.Format("{0} has already been scanned - ignoring.", item.ObjectBarcode));
                                canAddAssembly = false;
                            }
                            else
                            {
                                assembliesScanned.Add(item.ObjectBarcode);
                                canAddAssembly = true;
                            }

                            if (canAddAssembly)
                            {
                                // Has the assmebly already been added to SCAN_AssemblyScans?
                                SCAN_AssemblyScans a = ctx.SCAN_AssemblyScans.FirstOrDefault(f => f.Barcode == item.ObjectBarcode);

                                if (a == null)
                                {
                                    a                  = new SCAN_AssemblyScans();
                                    a.Barcode          = item.ObjectBarcode;
                                    a.EntityID         = item.ObjectEntityTypeID;
                                    a.UniqueIdentifier = item.UniqueIdentifier;
                                }
                                scanType.SCAN_AssemblyScans.Add(a);
                            }
                        }

                        ctx.SCAN_ScanType.Add(scanType);

                        ctx.SaveChanges();
                    }
                }
            }

            catch (Exception expn)
            {
                MessageBox.Show(expn.Message);
            }
            finally
            {
                // Should really fire an update stock event here
                UpdateStockStatus();
            }
        }