Example #1
0
        //if (sc.Name == e.TableCellIdentity.SummaryColumn.Name)
        //{
        //    textBox1.Text = e.Style.CellValue.ToString();
        //}



        void gc1_QueryCellStyleInfo(object sender, GridTableCellStyleInfoEventArgs e)
        {
            var db = new TestEntities();

            #region PicturesOn
            if (rb1.Checked == true)
            {
                if (e.Style.TableCellIdentity.Column != null && e.Style.TableCellIdentity.Column.Name == "BaseID" && e.TableCellIdentity.DisplayElement.Kind == Syncfusion.Grouping.DisplayElementKind.Record)
                {
                    picture findpic = db.pictures.Find(e.Style.CellValue.ToString());

                    if (findpic != null)
                    {
                        using (var bmpTemp = new Bitmap(findpic.Path))
                        {
                            image = new Bitmap(bmpTemp);
                            e.Style.CommentTip.CommentImage          = image;
                            e.Style.CommentTip.CommentArrowColor     = Color.Green;
                            e.Style.CommentTip.CommentIndicatorColor = Color.White;
                        }
                    }

                    else
                    {
                        e.Style.CommentTip.CommentImage          = Image.FromFile(@"r:\wippictures\na.jpg");
                        e.Style.CommentTip.CommentArrowColor     = Color.Red;
                        e.Style.CommentTip.CommentIndicatorColor = Color.Black;
                    }
                }
            }

            #endregion

            //    int machinehrs = 0;
            int weldhrs  = 0;
            int buildhrs = 0;

            //if (e.Style.TableCellIdentity.Column != null && e.TableCellIdentity.DisplayElement.Kind == Syncfusion.Grouping.DisplayElementKind.Record)
            //{
            //    //switch (e.Style.TableCellIdentity.Column.Name)
            //    //{
            //    //    case "Machine":
            //    //        machinehrs += Convert.ToInt16(e.Style.CellValue);
            //    //        //   txtMachine.Text = machinehrs.ToString();
            //    //        break;
            //    //}

            //    txtMachine.Text = machinehrs.ToString();
            //}
        }
Example #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            int tagnumber = Convert.ToInt16(txtTag.Text);

            TestEntities db    = new TestEntities();
            tblRedTag    check = db.tblRedTags.Find(tagnumber);

            if (check == null)
            {
                MessageBox.Show("Sorry, that Tag does not exist");
            }
            else
            {
                frmRedTag rtform = new frmRedTag(tagnumber);
                rtform.Show();
            }
        }
Example #3
0
        private void btnComment_Click(object sender, EventArgs e)
        {
            TestEntities db1 = new TestEntities();
            //  CommentEntities db = new CommentEntities();
            comment dbComment = new comment();

            dbComment.baseid    = strJobNumber;
            dbComment.date      = DateTime.Now.Date;
            dbComment.comment1  = txtComment.Text;
            dbComment.commenter = Environment.UserName;

            db1.comments.Add(dbComment);
            try
            {
                db1.SaveChanges();
            }
            catch (DbEntityValidationException ex)
            {
                var errorMessages = ex.EntityValidationErrors
                                    .SelectMany(x => x.ValidationErrors)
                                    .Select(x => x.ErrorMessage);

                var fullErrorMessage = string.Join("; ", errorMessages);

                var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);

                throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
            }

            catch (Exception ex)
            {
                MessageBox.Show("Something went wrong. Call Jacob. Give him this error: " + ex);
            }

            finally
            {
                //   MessageBox.Show("Comment Saved.");
                this.Close();
            }


            //adoEntities db = new adoEntities();

            //JobHour batch = new JobHour();
        }
Example #4
0
        public FolderSet(string content)
        {
            InitializeComponent();
            jobnumber = content;


            using (var db = new TestEntities())
            {
                Folder fFolder = db.Folders.Find(jobnumber.Trim());


                if (fFolder != null)

                {
                    if (fFolder.BuildFolder != null)
                    {
                        dtpBuild.Value = fFolder.BuildFolder.Value;
                    }

                    if (fFolder.PMFolder != null)
                    {
                        dtpPM.Value = fFolder.PMFolder.Value;
                    }

                    if (fFolder.MachineFolder != null)
                    {
                        dtpMachine.Value = fFolder.MachineFolder.Value;
                    }

                    if (fFolder.ProcessingFolder != null)
                    {
                        dtpProcessor.Value = fFolder.ProcessingFolder.Value;
                    }

                    if (fFolder.WeldFolder != null)
                    {
                        dtpWeld.Value = fFolder.WeldFolder.Value;
                    }
                }
            }
        }
Example #5
0
        private void dgvActionItems_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            DialogResult result = MessageBox.Show("Close Action Item?", "Close Action Item?", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

            if (result == DialogResult.Yes)
            {
                TestEntities db1 = new TestEntities();



                db1.SaveChanges();

                PerformRefresh();
            }

            //DateTime shipdate = Convert.ToDateTime(dgvActiveJobs.SelectedRows[0].Cells[6].Value);



            //jobview2 jobview = new jobview2(content, tooltype, shipdate);
            //jobview.Show();
        }
Example #6
0
        private void jobview2_Load(object sender, EventArgs e)
        {
            this.actionItemsTableAdapter.FillBy(this.ds_ActionItems.ActionItems, strJobNumber);

            job_batchesTableAdapter.FillBatchData(jobBatches.Job_batches, strJobNumber);
            commentsTableAdapter.fillComments(dsComments.comments, strJobNumber);

            this.Text = strJobNumber;



            //check for red tag

            //using (var db = new TestEntities())
            //{
            //    tblRedTag rt = db.tblRedTags.Find(strJobNumber);

            //    if (rt != null)
            //    {
            //        pbLight.Visible = true;
            //    }


            //}


            lblJobNumber.Text = strJobNumber;
            lblTooltype.Text  = strToolType;
            lblShipdate.Text  = strShipdate;

            string userName = System.Security.Principal.WindowsIdentity.GetCurrent().Name;

            if (userName == "VISIONEERING\\zhallett")
            {
                btnGuys.Visible = true;
            }

            if (userName == "VISIONEERING\\jrotary")
            {
                btnGuys.Visible = true;
            }

            if (userName == "VISIONEERING\\bhallett")
            {
                btnGuys.Visible = true;
            }

            if (userName == "VISIONEERING\\ashinsky")
            {
                btnGuys.Visible = true;
            }

            if (userName == "VISIONEERING\\bdobleske")
            {
                btnGuys.Visible = true;
            }

            if (userName == "VISIONEERING\\smoore")
            {
                btnGuys.Visible = true;
            }

            if (userName == "VISIONEERING\\jfranz")
            {
                btnGuys.Visible = true;
            }

            if (userName == "VISIONEERING\\nhanna")
            {
                btnGuys.Visible = true;
            }

            if (userName == "VISIONEERING\\ANielsen")
            {
                btnGuys.Visible = true;
            }

            if (userName == "VISIONEERING\\cbacon")
            {
                btnGuys.Visible = true;
            }

            if (userName == "VISIONEERING\\dconrad")
            {
                btnGuys.Visible = true;
            }



            DataGridViewCellStyle style = new DataGridViewCellStyle();

            style.BackColor = Color.Orange;
            style.ForeColor = Color.White;



            using (var db = new TestEntities())
            {
                ImportantDate iDate   = db.ImportantDates.Find(strJobNumber);
                picture       findpic = db.pictures.Find(strJobNumber);

                NewestBaseline baseline = db.NewestBaselines.Find(strJobNumber);
                NewestActual   actual   = db.NewestActuals.Find(strJobNumber);

                if (baseline != null)
                {
                    // lblMachineEndBase.Text = Convert.ToString(baseline.machineend);

                    DateTime processingstart  = Convert.ToDateTime(baseline.processingstart).Date;
                    string   processingstart1 = processingstart.ToString("d");
                    lblProcessingStartBase.Text = processingstart1;

                    // lblProcessingStartBase.Text = Convert.ToString(baseline.processingstart);

                    DateTime processingend  = Convert.ToDateTime(baseline.processingend).Date;
                    string   processingend1 = processingend.ToString("d");
                    lblProcessingEndBase.Text = processingend1;

                    DateTime materialstart  = Convert.ToDateTime(baseline.materialstart).Date;
                    string   materialstart1 = materialstart.ToString("d");
                    lblMaterialOrderBase.Text = materialstart1;

                    DateTime materialend  = Convert.ToDateTime(baseline.materialend).Date;
                    string   materialend1 = materialend.ToString("d");
                    lblMaterialReceivedBase.Text = materialend1;

                    DateTime machinestart  = Convert.ToDateTime(baseline.machinestart).Date;
                    string   machinestart1 = machinestart.ToString("d");
                    lblMachineStartBase.Text = machinestart1;

                    DateTime machineend  = Convert.ToDateTime(baseline.machineend).Date;
                    string   machineend1 = machineend.ToString("d");
                    lblMachineEndBase.Text = machineend1;

                    DateTime fabstart  = Convert.ToDateTime(baseline.weldstart).Date;
                    string   fabstart1 = fabstart.ToString("d");
                    lblFabStartBase.Text = fabstart1;

                    DateTime fabend  = Convert.ToDateTime(baseline.weldend).Date;
                    string   fabend1 = fabend.ToString("d");
                    lblFabFinishBase.Text = fabend1;

                    DateTime assemblystart  = Convert.ToDateTime(baseline.assemblystart).Date;
                    string   assemblystart1 = assemblystart.ToString("d");
                    lblAssemblyStartBase.Text = assemblystart1;

                    DateTime assemblyend  = Convert.ToDateTime(baseline.assemblyend).Date;
                    string   assemblyend1 = assemblyend.ToString("d");
                    lblAssemblyFinishBase.Text = assemblyend1;
                }

                if (actual != null)
                {
                    DateTime processingstart  = Convert.ToDateTime(actual.processingstart).Date;
                    string   processingstart1 = processingstart.ToString("d");
                    lblProcessingStartAct.Text = processingstart1;

                    DateTime processingend   = Convert.ToDateTime(actual.processingend).Date;
                    string   processingsend1 = processingend.ToString("d");
                    lblProcessingEndAct.Text = processingsend1;

                    DateTime materialstart  = Convert.ToDateTime(actual.materialstart).Date;
                    string   materialstart1 = materialstart.ToString("d");
                    lblMaterialOrderAct.Text = materialstart1;

                    DateTime materialfinish  = Convert.ToDateTime(actual.materialend).Date;
                    string   materialfinish1 = materialfinish.ToString("d");
                    lblMaterialReceivedAct.Text = materialfinish1;



                    DateTime machinestart  = Convert.ToDateTime(actual.machinestart).Date;
                    string   machinestart1 = machinestart.ToString("d");
                    lblMachineStartAct.Text = machinestart1;

                    DateTime machineend  = Convert.ToDateTime(actual.machineend).Date;
                    string   machineend1 = machineend.ToString("d");
                    lblMachineEndAct.Text = machineend1;

                    DateTime fabstart  = Convert.ToDateTime(actual.weldstart).Date;
                    string   fabstart1 = fabstart.ToString("d");
                    lblFabStartAct.Text = fabstart1;

                    DateTime fabend  = Convert.ToDateTime(actual.weldend).Date;
                    string   fabend1 = fabend.ToString("d");
                    lblFabFinishAct.Text = fabend1;

                    DateTime assemblystart  = Convert.ToDateTime(actual.assemblystart).Date;
                    string   assemblystart1 = assemblystart.ToString("d");
                    lblAssemblyStartAct.Text = assemblystart1;

                    DateTime assemblyfinish  = Convert.ToDateTime(actual.assemblyend).Date;
                    string   assemblyfinish1 = assemblyfinish.ToString("d");
                    lblAssemblyFinishAct.Text = assemblyfinish1;
                }



                if (findpic != null)
                {
                    using (var bmpTemp = new Bitmap(findpic.Path))
                    {
                        image       = new Bitmap(bmpTemp);
                        pbJob.Image = image;
                    }
                    //stream.Read(findpic.Path,0);
                    //image = System.Drawing.Image.FromStream(stream);
                    //image = (Image.FromFile(findpic.Path));
                    //pbJob.Image = image;
                }
                else
                {
                    pbJob.Image = Image.FromFile(@"r:\wippictures\na.jpg");
                }

                //db.SaveChanges();
                //MessageBox.Show("Dates Saved. GREAT JOB!");

                //  dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
                dataGridView1.Columns[1].DefaultCellStyle.WrapMode = DataGridViewTriState.True;
                // dataGridView1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
                dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.DisplayedCells;



                //TestEntities jobteam1 = new TestEntities();
                Team jobteam1 = new Team();
                bool check1   = db.Teams.Any(u => u.JobNumber == strJobNumber);



                if (check1 == true)
                {
                    jobteam1 = db.Teams.Find(strJobNumber);

                    if (jobteam1.ProgramManager != null)
                    {
                        lblPm.Text = "Program Manager: " + jobteam1.ProgramManager;
                    }

                    if (jobteam1.Processor != null)
                    {
                        lblProcessor.Text = "Processor: " + jobteam1.Processor;
                    }

                    if (jobteam1.BuildLeader != null)
                    {
                        lblBuldLeader.Text = "Build Leader: " + jobteam1.BuildLeader;
                    }



                    if (jobteam1.Folder != null)
                    {
                        lblPoDate.Text = "PO Date: " + jobteam1.PODate.Value.ToString("MM-dd-yyyy");
                    }
                }

                //Folder fFolder = db.Folders.Find(strJobNumber.Substring(0,15));



                //      bool check2 = db.Folders.Any(u => u.JobNumber.Substring(0,15) == strJobNumber.Substring(0,15));
            }
        }
Example #7
0
        private void btnUpdatePicture_Click(object sender, EventArgs e)
        {
            ofdPicture.ShowDialog();
            string strPicture = ofdPicture.FileName.ToString();

            pbJob.Image = Image.FromFile(strPicture);
            string jobfilename = strJobNumber.Trim();

            jobfilename = jobfilename.Replace(@"/", "-");
            File.Copy(ofdPicture.FileName, "R:\\wippictures\\" + jobfilename + ".jpg", true);

            using (var db = new TestEntities())
            {
                picture jobPicture = db.pictures.Find(strJobNumber);
                if (jobPicture != null)
                {
                    jobPicture.BaseId = strJobNumber;
                    jobPicture.Path   = "R:\\wippictures\\" + jobfilename + ".jpg";
                    db.SaveChanges();
                    MessageBox.Show("Picture Updated. GREAT JOB!!");
                }
                else
                {
                    picture pic2 = new picture();
                    pic2.BaseId = strJobNumber;
                    pic2.Path   = "R:\\wippictures\\" + jobfilename + ".jpg";
                    db.pictures.Add(pic2);
                    db.SaveChanges();
                    MessageBox.Show("Image Saved. GREAT JOB!!");
                }
            }
            //using (var db = new CommentEntities())
            //{
            //    ImportantDate iDate = db.ImportantDates.Find(strJobNumber);
            //    if (iDate != null)
            //    {
            //        iDate.BaseID = strJobNumber;
            //        iDate.RecvMaterial = dtMaterial;
            //        iDate.StartFab = dtFabrication;
            //        iDate.HeatTreat = dtHeat;
            //        iDate.StartMachining = dtMachining;
            //        iDate.StartAssy = dtAssembly;
            //        iDate.MachComp = dtMachComplete;
            //        iDate.RdyChk = dtCheck;
            //        iDate.RdySrc = dtSrc;
            //        iDate.DesRel = dtDesRel;
            //        db.SaveChanges();
            //        MessageBox.Show("Dates Updates. GREAT JOB!");

            //    }
            //    else
            //    {
            //        ImportantDate iDate2 = new ImportantDate();
            //        iDate2.BaseID = strJobNumber;
            //        iDate2.RecvMaterial = dtMaterial;
            //        iDate2.StartFab = dtFabrication;
            //        iDate2.HeatTreat = dtHeat;
            //        iDate2.StartMachining = dtMachining;
            //        iDate2.StartAssy = dtAssembly;
            //        iDate2.MachComp = dtMachComplete;
            //        iDate2.RdyChk = dtCheck;
            //        iDate2.RdySrc = dtSrc;
            //        iDate2.DesRel = dtDesRel;
            //        db.ImportantDates.Add(iDate2);
            //        db.SaveChanges();
            //        MessageBox.Show("Dates Saved. GREAT JOB!");

            //    }
        }
Example #8
0
        private void JobView4_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'dsComments.comments' table. You can move, or remove it, as needed.
            // this.commentsTableAdapter1.Fill(this.dsComments.comments);
            // TODO: This line of code loads data into the 'ds_Comments.comments' table. You can move, or remove it, as needed.
            // this.commentsTableAdapter.Fill(this.ds_Comments.comments);

            //  commentsTableAdapter.fillComments(dsComments.comments, strJobNumber);
            try
            {
                commentsTableAdapter1.fillComments(this.dsComments.comments, strJobNumber);
                this.gridGroupingControl1.TableDescriptor.VisibleColumns.Remove("id");
                this.gridGroupingControl1.TableDescriptor.VisibleColumns.Remove("baseid");
                this.gridGroupingControl1.Appearance.AlternateRecordFieldCell.BackColor = Color.LightGray;

                this.gridGroupingControl1.TableOptions.ColumnHeaderRowHeight = 20;
                this.gridGroupingControl1.TableOptions.RecordRowHeight       = 40;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }


            using (var db = new TestEntities())
            {
                ImportantDate idate   = db.ImportantDates.Find(strJobNumber);
                picture       findpic = db.pictures.Find(strJobNumber);
                // Margin_Over_time mot = db.Margin_Over_time.Find(strJobNumber);

                // rbcMain

                if (findpic != null)
                {
                    using (var bmpTemp = new Bitmap(findpic.Path))
                    {
                        image = new Bitmap(bmpTemp);
                        //  is3.Images.Add(image);
                        is3.BackgroundImage       = image;
                        is3.BackgroundImageLayout = ImageLayout.Stretch;

                        //   is1.SlideShow = false;
                        //  dscomments
                        //    is1.

                        is3.ImageCollection.ImageSize.Height.Equals(512);
                        is3.ImageCollection.ImageSize.Width.Equals(512);
                    }
                }
                else
                {
                    Image i2 = Image.FromFile(@"r:\wippictures\na.jpg");



                    is3.Images.Add(i2);
                }



                Team jobteam1 = new Team();
                bool check1   = db.Teams.Any(u => u.JobNumber == strJobNumber);


                #region LabelChecks

                string strJob = strJobNumber.Replace("/", "_").Replace(" ", "");
                string path   = "R:\\wipviewer2017\\jobfiles\\" + strJob + "\\riskassessment.xlsx";

                if (File.Exists(path) == true)
                {
                }
                else
                {
                    btnRA.BackColor = Color.Red;
                    btnRA.Enabled   = false;
                }

                path = "R:\\wipviewer2017\\jobfiles\\" + strJob + "\\aqp.xlsx";

                if (File.Exists(path) == true)
                {
                }
                else
                {
                    btnAQP.BackColor = Color.Red;
                    btnAQP.Enabled   = false;
                }

                if (check1 == true)
                {
                    jobteam1 = db.Teams.Find(strJobNumber);

                    if (jobteam1.ProgramManager != null)
                    {
                        lblPm.Text = "Program Manager: " + jobteam1.ProgramManager;
                    }
                    else
                    {
                        lblPm.Text = "PM NOT SET";
                    }

                    if (jobteam1.Processor != null)
                    {
                        lblProcessor.Text = "Processor: " + jobteam1.Processor;
                    }
                    else
                    {
                        lblProcessor.Text = "PROCESSOR NOT SET";
                    }

                    if (jobteam1.BuildLeader != null)
                    {
                        lblBl.Text = "Build Leader: " + jobteam1.BuildLeader;
                    }
                    else
                    {
                        lblBl.Text = "BUILD LEADER NOT SET";
                    }



                    if (jobteam1.PODate != null)
                    {
                        lblPO.Text = "PO Date: " + jobteam1.PODate.Value.ToString("MM-dd-yyyy");
                    }
                    else
                    {
                        lblPO.Text = "PO DATE NOT ENTERED";
                    }

                    #endregion



                    ActiveJob aj1 = db.ActiveJobs.Find(strJobNumber);



                    this.Text = strJobNumber;
                }
            }
        }
Example #9
0
        public void btnSubmit_Click(object sender, EventArgs e)
        {
            TestEntities db      = new TestEntities();
            Folder       fFolder = db.Folders.Find(jobnumber.Substring(0, 15));

            dtPM = dtpPM.Value.Date;



            if (fFolder == null)

            {
                fFolder           = new Folder();
                fFolder.JobNumber = jobnumber.Substring(0, 15);
                if (bPM == true)
                {
                    fFolder.PMFolder = dtpPM.Value.Date;
                }

                if (bProc == true)
                {
                    fFolder.ProcessingFolder = dtpProcessor.Value.Date;
                }

                if (bWeld == true)
                {
                    fFolder.WeldFolder = dtpWeld.Value.Date;
                }

                if (bMach == true)
                {
                    fFolder.MachineFolder = dtpMachine.Value.Date;
                }

                if (bBuild == true)
                {
                    fFolder.BuildFolder = dtpBuild.Value.Date;
                }

                try
                {
                    db.Folders.Add(fFolder);
                    db.SaveChanges();
                }

                catch (DbEntityValidationException f)
                {
                    foreach (var eve in f.EntityValidationErrors)
                    {
                        Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
                                          eve.Entry.Entity.GetType().Name, eve.Entry.State);
                        foreach (var ve in eve.ValidationErrors)
                        {
                            Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
                                              ve.PropertyName, ve.ErrorMessage);
                        }
                    }
                    throw;
                }
            }


            else

            {
                if (bPM == true)
                {
                    fFolder.PMFolder = dtpPM.Value.Date;
                }

                if (bProc == true)
                {
                    fFolder.ProcessingFolder = dtpProcessor.Value.Date;
                }

                if (bWeld == true)
                {
                    fFolder.WeldFolder = dtpWeld.Value.Date;
                }

                if (bMach == true)
                {
                    fFolder.MachineFolder = dtpMachine.Value.Date;
                }

                if (bBuild == true)
                {
                    fFolder.BuildFolder = dtpBuild.Value.Date;
                }

                db.SaveChanges();
            }



            MessageBox.Show("Folder Updated. NICE JOB!");
        }
Example #10
0
        private void button1_Click(object sender, EventArgs e)
        {
            TestEntities db1 = new TestEntities();
            // CommentEntities db = new CommentEntities();

            SupplierMain supp1 = new SupplierMain();

            supp1.Name           = txtSupplierName.Text;
            supp1.Risk           = cmbRisk.Text;
            supp1.VendorID       = txtVendorId.Text;
            supp1.Email          = txtEmail.Text;
            supp1.PrimaryContact = txtPrimaryContact.Text;

            supp1.EvalDate = dtpEval.Value;

            db1.SupplierMains.Add(supp1);


            if (rbDirect.Checked == true)
            {
                SupplierDirect supp2 = new SupplierDirect();
                supp2.Name               = txtSupplierName.Text;
                supp2.FOB                = txtFob.Text;
                supp2.PrimaryCommodity   = cmbPrimary.Text;
                supp2.SecondaryCommodity = cmbSecondary.Text;

                if (rbAsYes.Checked == true)

                {
                    supp2.AS9100Registration = "True";
                    supp2.ASExpiration       = dtpAS.Value;
                    supp2.ASDocument         = "Test";
                }
                else
                {
                    supp2.AS9100Registration = "False";
                }

                if (rbIsoYes.Checked == true)
                {
                    supp2.IsoRegistration = "True";
                    supp2.IsoExpiration   = dtpIso.Value;
                    supp2.IsoDocument     = "Test";
                }
                else
                {
                    supp2.IsoRegistration = "False";
                }

                if (rbOtherYes.Checked == true)
                {
                    supp2.OtherRegistration = "True";
                    supp2.OtherExpiration   = dtpOther.Value;
                    supp2.OtherDocument     = "Test";
                }
                else
                {
                    supp2.OtherRegistration = "False";
                }

                if (rbItarYes.Checked == true)
                {
                    supp2.ItarApproved   = "True";
                    supp2.ItarExpiration = dtpItar.Value;
                    supp2.ItarDocument   = "Test";
                }
                else
                {
                    supp2.ItarApproved = "False";
                }

                if (rbDpdYes.Checked == true)
                {
                    supp2.DPDApproval = "True";
                }
                else
                {
                    supp2.DPDApproval = "False";
                }

                if (rbSpecialYes.Checked == true)
                {
                    supp2.SpecialProcesses     = "True";
                    supp2.SpecialProcessDetail = txtSpecialDetail.Text;
                }

                string path = "r:\\wipviewer2017\\suppliers\\" + txtSupplierName.Text;
                System.IO.Directory.CreateDirectory(path);

                if (bIso == true)
                {
                    System.IO.File.Copy(strFile1, path + "\\Iso.pdf");
                    supp2.IsoDocument = path + "\\Iso.pdf";
                }
                else
                {
                    MessageBox.Show("F**k Me. No Iso File.");
                    supp2.IsoDocument = "None";
                }

                if (bAs == true)
                {
                    System.IO.File.Copy(strFile2, path + "\\AS9100.pdf");
                    supp2.ASDocument = path + "\\AS9100.pdf";
                }
                else
                {
                    MessageBox.Show("No As");
                    supp2.ASDocument = "None";
                }

                if (bOther == true)
                {
                    System.IO.File.Copy(strFile3, path + "\\Other.pdf");
                    supp2.OtherDocument = path + "\\Other.pdf";
                }
                else
                {
                    MessageBox.Show("No Other");
                    supp2.OtherDocument = "None";
                }

                if (bItar == true)
                {
                    System.IO.File.Copy(strFile4, path + "\\Itar.pdf");
                    supp2.ItarDocument = path + "\\Itar.pdf";
                }
                else
                {
                    MessageBox.Show("No Itar");
                    supp2.ItarDocument = "None";
                }


                db1.SupplierDirects.Add(supp2);
            }



            db1.SaveChanges();
            MessageBox.Show("Supplier Added. F**k Yea!");
        }
Example #11
0
        private void btnSubmit_Click(object sender, EventArgs e)
        {
            int    strTag         = Convert.ToInt16(txtTag.Text);
            string strJob         = txtJob.Text;
            string strTool        = txtTool.Text;
            string strInitiator   = cmbInitiator.Text;
            string strDept        = cmbDept.Text;
            string strSpec        = txtSpec.Text;
            string strCondition   = txtCondition.Text;
            string strDefect      = cmbDefect.Text;
            string strCause       = cmbCause.Text;
            string strDisposition = cmbDisposition.Text;
            //  string strDisposition = cmbDisposition.Text;

            bool bCar = chkCar.Checked;

            int strRework = 0;

            if (txtRework == null)
            {
                strRework = 0;
            }
            else
            {
                //  strRework = Convert.ToInt16(txtRework.Text);
                strRework = 0;
            }


            int    strInstance     = Convert.ToInt16(txtInstance.Text);
            int    strScrap        = Convert.ToInt16(txtScrap.Text);
            string strVendor       = txtVendor.Text;
            string strInstructions = txtInstructions.Text;
            string strComments     = txtComments.Text;



            DateTime dtInspection   = dtpInspection.Value.Date;
            DateTime dtReinspection = dtpReinspection.Value.Date;

            var db = new TestEntities();

            tblRedTag rt    = db.tblRedTags.Find(strTag);
            Job       check = db.Jobs.Find(strJob);

            if (rt != null)
            {
                DialogResult dialogResult = MessageBox.Show("This Tag ID Already Exists. Update?", "Tag Exists!", MessageBoxButtons.YesNo);

                if (dialogResult == DialogResult.Yes)
                {
                    if (check != null)
                    {
                        rt.ID           = strTag;
                        rt.JOB          = strJob;
                        rt.Detail       = strTool;
                        rt.Initiator    = strInitiator;
                        rt.Dept         = strDept;
                        rt.Spec         = strSpec;
                        rt.Condition    = strCondition;
                        rt.Date         = dtInspection;
                        rt.Defect       = strDefect;
                        rt.Cause        = strCause;
                        rt.Instructions = strInstructions;
                        rt.Comment      = strComments;
                        rt.Reinspection = dtReinspection;
                        rt.Cost         = strRework;
                        rt.InstanceCost = strInstance;
                        rt.ScrapCost    = strScrap;
                        rt.VendorPO     = strVendor;


                        try
                        {
                            //   db.tblRedTags(rt)
                            db.SaveChanges();
                            bool bEmail  = true;
                            Team jobTeam = db.Teams.Find(strJob);

                            if (jobTeam != null)
                            {
                                bEmail = true;
                                string strSubject = "Red Tag # " + strTag + " Updated";
                                string strBody    = "A red tag has been updated. <br> You are receiving this email because you are part of the job team. <br><br><b>THIS IS A TEST OF THE WIPVIEWER RED TAG EMAIL SYSTEM.</b> <br><br>";
                                strBody += "<br>Here is some information about the Tag: <br>Tag Number: " + strTag + "<br>Job Number: " + strJob + "<br>Tool #: " + strTool + "<br>Initiator: " + strInitiator + "<br>Department #: " + strDept;


                                Microsoft.Office.Interop.Outlook.Application oApp = new Microsoft.Office.Interop.Outlook.Application();

                                MailItem eMail = (MailItem)oApp.CreateItem(OlItemType.olMailItem);


                                Recipients oRecips = (Recipients)eMail.Recipients;
                                eMail.Subject    = strSubject;
                                eMail.Body       = strBody;
                                eMail.Importance = OlImportance.olImportanceLow;

                                eMail.BodyFormat = OlBodyFormat.olFormatHTML;



                                if (jobTeam.ProgramManager != null)
                                {
                                    Recipient oRecip = (Recipient)oRecips.Add("*****@*****.**");
                                }


                                if (jobTeam.Processor != null)
                                {
                                    //eMail.To = "*****@*****.**";

                                    Recipient oRecip = (Recipient)oRecips.Add("*****@*****.**");
                                }


                                if (jobTeam.BuildLeader != null)
                                {
                                    Recipient oRecip = (Recipient)oRecips.Add("*****@*****.**");
                                }

                                eMail.HTMLBody = strBody;


                                eMail.Send();
                            }

                            else
                            {
                                bEmail = false;
                            }


                            if (bEmail == true)
                            {
                                MessageBox.Show("Success. Email Sent");
                            }

                            else
                            {
                                MessageBox.Show("Red Tag created, but no Team for job present. No Email sent.");
                            }
                        }

                        catch (System.Exception ex)
                        { }
                    }

                    else
                    {
                        MessageBox.Show("That Job Does not exist. You may have your formatting wrong. In WipViewer, Jobs are always formatted 'XXXX9999 / 9'. If you have any questions, please contact Jacob Rotary");
                    }
                }
                else
                {
                }
            }

            else
            {
                if (check != null)
                {
                    tblRedTag rt2 = new tblRedTag();


                    rt2.ID           = strTag;
                    rt2.JOB          = strJob;
                    rt2.Detail       = strTool;
                    rt2.Initiator    = strInitiator;
                    rt2.Dept         = strDept;
                    rt2.Spec         = strSpec;
                    rt2.Condition    = strCondition;
                    rt2.Date         = dtInspection;
                    rt2.Defect       = strDefect;
                    rt2.Cause        = strCause;
                    rt2.Instructions = strInstructions;
                    rt2.Comment      = strComments;
                    rt2.Reinspection = dtReinspection;
                    rt2.Cost         = strRework;
                    rt2.InstanceCost = strInstance;
                    rt2.ScrapCost    = strScrap;
                    rt2.VendorPO     = strVendor;
                    rt2.Disposition  = strDisposition;
                    rt2.CAR          = Convert.ToString(bCar);



                    try
                    {
                        db.tblRedTags.Add(rt2);
                        db.SaveChanges();
                        bool bEmail  = true;
                        Team jobTeam = db.Teams.Find(strJob);

                        if (jobTeam != null)
                        {
                            bEmail = true;
                            string strSubject = "New Red Tag created for " + strJob + " IGNORE THIS - ITS A TEST EMAIL";
                            string strBody    = "A new red tag has been created. <br> You are receiving this email because you are part of the job team. <br><br><b>THIS IS A TEST OF THE WIPVIEWER RED TAG EMAIL SYSTEM.</b> <br><br>";
                            strBody += "<br>Here is some information about the Tag: <br>Tag Number: " + strTag + "<br>Job Number: " + strJob + "<br>Tool #: " + strTool + "<br>Initiator: " + strInitiator + "<br>Department #: " + strDept;


                            Microsoft.Office.Interop.Outlook.Application oApp = new Microsoft.Office.Interop.Outlook.Application();

                            MailItem eMail = (MailItem)oApp.CreateItem(OlItemType.olMailItem);


                            Recipients oRecips = (Recipients)eMail.Recipients;
                            eMail.Subject    = strSubject;
                            eMail.Body       = strBody;
                            eMail.Importance = OlImportance.olImportanceLow;

                            eMail.BodyFormat = OlBodyFormat.olFormatHTML;



                            if (jobTeam.ProgramManager != null)
                            {
                                Recipient oRecip = (Recipient)oRecips.Add("*****@*****.**");
                            }


                            if (jobTeam.Processor != null)
                            {
                                //eMail.To = "*****@*****.**";

                                Recipient oRecip = (Recipient)oRecips.Add("*****@*****.**");
                            }


                            if (jobTeam.BuildLeader != null)
                            {
                                Recipient oRecip = (Recipient)oRecips.Add("*****@*****.**");
                            }

                            eMail.HTMLBody = strBody;


                            eMail.Send();
                        }

                        else
                        {
                            bEmail = false;
                        }


                        if (bEmail == true)
                        {
                            MessageBox.Show("Success. Email Sent");
                        }

                        else
                        {
                            MessageBox.Show("Red Tag created, but no Team for job present. No Email sent.");
                        }
                    }

                    //catch (System.Exception ex)
                    // { }

                    catch (DbEntityValidationException dbEx)
                    {
                        foreach (var validationErrors in dbEx.EntityValidationErrors)
                        {
                            foreach (var validationError in validationErrors.ValidationErrors)
                            {
                                Trace.TraceInformation("Property: {0} Error: {1}",
                                                       validationError.PropertyName,
                                                       validationError.ErrorMessage);
                            }
                        }
                    }
                }

                else
                {
                    MessageBox.Show("That Job Does not exist. You may have your formatting wrong. In WipView, Jobs are always formatted 'XXXX9999 / 9'. If you have any questions, please contact Jacob Rotary");
                }
            }
        }
Example #12
0
        private void testjobview_Load(object sender, EventArgs e)
        {
            using (var db = new TestEntities())
            {
                ImportantDate idate   = db.ImportantDates.Find(strJobNumber);
                picture       findpic = db.pictures.Find(strJobNumber);
                // Margin_Over_time mot = db.Margin_Over_time.Find(strJobNumber);

                // rbcMain

                if (findpic != null)
                {
                    using (var bmpTemp = new Bitmap(findpic.Path))
                    {
                        image = new Bitmap(bmpTemp);
                        //  is3.Images.Add(image);
                        is3.BackgroundImage       = image;
                        is3.BackgroundImageLayout = ImageLayout.Stretch;

                        //   is1.SlideShow = false;
                        //  dscomments
                        //    is1.

                        is3.ImageCollection.ImageSize.Height.Equals(512);
                        is3.ImageCollection.ImageSize.Width.Equals(512);
                    }
                }
                else
                {
                    Image i2 = Image.FromFile(@"r:\wippictures\na.jpg");



                    is3.Images.Add(i2);
                }



                Team jobteam1 = new Team();
                bool check1   = db.Teams.Any(u => u.JobNumber == strJobNumber);


                #region LabelChecks

                string strJob = strJobNumber.Replace("/", "_").Replace(" ", "");
                string path   = "R:\\wipviewer2017\\jobfiles\\" + strJob + "\\riskassessment.xlsx";

                if (File.Exists(path) == true)
                {
                }
                else
                {
                    btnRA.BackColor = Color.Red;
                    btnRA.Enabled   = false;
                }

                path = "R:\\wipviewer2017\\jobfiles\\" + strJob + "\\aqp.xlsx";

                if (File.Exists(path) == true)
                {
                }
                else
                {
                    btnAQP.BackColor = Color.Red;
                    btnAQP.Enabled   = false;
                }

                if (check1 == true)
                {
                    jobteam1 = db.Teams.Find(strJobNumber);

                    if (jobteam1.ProgramManager != null)
                    {
                        lblPm.Text = "Program Manager: " + jobteam1.ProgramManager;
                    }
                    else
                    {
                        lblPm.Text = "PM NOT SET";
                    }

                    if (jobteam1.Processor != null)
                    {
                        lblProcessor.Text = "Processor: " + jobteam1.Processor;
                    }
                    else
                    {
                        lblProcessor.Text = "PROCESSOR NOT SET";
                    }

                    if (jobteam1.BuildLeader != null)
                    {
                        lblBl.Text = "Build Leader: " + jobteam1.BuildLeader;
                    }
                    else
                    {
                        lblBl.Text = "BUILD LEADER NOT SET";
                    }



                    if (jobteam1.PODate != null)
                    {
                        lblPO.Text = "PO Date: " + jobteam1.PODate.Value.ToString("MM-dd-yyyy");
                    }
                    else
                    {
                        lblPO.Text = "PO DATE NOT ENTERED";
                    }

                    #endregion



                    ActiveJob aj1 = db.ActiveJobs.Find(strJobNumber);
                    #region agechecks


                    if (aj1.age1 <= 30)
                    {
                        DateTime testdate  = Convert.ToDateTime(db.Margin_Over_time.Where(cc4 => cc4.BaseID == strJobNumber).Select(cc4 => cc4.BatchDate).Min());
                        DateTime testdate2 = Convert.ToDateTime(db.Margin_Over_time.Where(cc4 => cc4.BaseID == strJobNumber).Select(cc4 => cc4.BatchDate).Max());
                        cc1.PrimaryXAxis.DateTimeRange = new Syncfusion.Windows.Forms.Chart.ChartDateTimeRange(testdate, testdate2, 5, Syncfusion.Windows.Forms.Chart.ChartDateTimeIntervalType.Days);
                    }

                    if (aj1.age1 > 30 && aj1.age1 <= 60)
                    {
                        DateTime testdate  = Convert.ToDateTime(db.Margin_Over_time.Where(cc4 => cc4.BaseID == strJobNumber).Select(cc4 => cc4.BatchDate).Min());
                        DateTime testdate2 = Convert.ToDateTime(db.Margin_Over_time.Where(cc4 => cc4.BaseID == strJobNumber).Select(cc4 => cc4.BatchDate).Max());
                        cc1.PrimaryXAxis.DateTimeRange = new Syncfusion.Windows.Forms.Chart.ChartDateTimeRange(testdate, testdate2, 10, Syncfusion.Windows.Forms.Chart.ChartDateTimeIntervalType.Days);
                    }

                    if (aj1.age1 > 60 && aj1.age1 <= 150)
                    {
                        DateTime testdate  = Convert.ToDateTime(db.Margin_Over_time.Where(cc4 => cc4.BaseID == strJobNumber).Select(cc4 => cc4.BatchDate).Min());
                        DateTime testdate2 = Convert.ToDateTime(db.Margin_Over_time.Where(cc4 => cc4.BaseID == strJobNumber).Select(cc4 => cc4.BatchDate).Max());
                        cc1.PrimaryXAxis.DateTimeRange = new Syncfusion.Windows.Forms.Chart.ChartDateTimeRange(testdate, testdate2, 1, Syncfusion.Windows.Forms.Chart.ChartDateTimeIntervalType.Months);
                    }

                    if (aj1.age1 > 150 && aj1.age1 <= 365)
                    {
                        DateTime testdate  = Convert.ToDateTime(db.Margin_Over_time.Where(cc4 => cc4.BaseID == strJobNumber).Select(cc4 => cc4.BatchDate).Min());
                        DateTime testdate2 = Convert.ToDateTime(db.Margin_Over_time.Where(cc4 => cc4.BaseID == strJobNumber).Select(cc4 => cc4.BatchDate).Max());
                        cc1.PrimaryXAxis.DateTimeRange = new Syncfusion.Windows.Forms.Chart.ChartDateTimeRange(testdate, testdate2, 2, Syncfusion.Windows.Forms.Chart.ChartDateTimeIntervalType.Months);
                    }

                    if (aj1.age1 > 365)
                    {
                        DateTime testdate  = Convert.ToDateTime(db.Margin_Over_time.Where(cc4 => cc4.BaseID == strJobNumber).Select(cc4 => cc4.BatchDate).Min());
                        DateTime testdate2 = Convert.ToDateTime(db.Margin_Over_time.Where(cc4 => cc4.BaseID == strJobNumber).Select(cc4 => cc4.BatchDate).Max());
                        cc1.PrimaryXAxis.DateTimeRange = new Syncfusion.Windows.Forms.Chart.ChartDateTimeRange(testdate, testdate2, 3, Syncfusion.Windows.Forms.Chart.ChartDateTimeIntervalType.Months);
                    }

                    #endregion



                    this.Text = strJobNumber;
                }
            }
        }
Example #13
0
        public team2(string jobnumber)
        {
            InitializeComponent();

            strjobnumber = jobnumber;

            using (var db = new TestEntities())
            {
                Team tTeam = db.Teams.Find(strjobnumber);



                if (tTeam != null)
                {
                    if (tTeam.ProgramManager != null)
                    {
                        cmbPM.Text = tTeam.ProgramManager.Trim();
                    }
                    if (tTeam.Processor != null)
                    {
                        cmbProcessor.Text = tTeam.Processor.Trim();
                    }

                    if (tTeam.BuildLeader != null)
                    {
                        cmbBl.Text = tTeam.BuildLeader.Trim();
                    }

                    if (tTeam.QA != null)
                    {
                        cmbQa.Text = tTeam.QA.Trim();
                    }



                    if (tTeam.PODate != null)
                    {
                        dtpPoDate.Value = Convert.ToDateTime(tTeam.PODate);
                    }
                    if (tTeam.KickOff != null)
                    {
                        chkKickoff.Checked = true;
                        dtpKickoff.Value   = Convert.ToDateTime(tTeam.KickOff);
                    }
                    if (tTeam.DataRelease != null)
                    {
                        chkDataRelease.Checked = true;
                        dtpDataRelease.Value   = Convert.ToDateTime(tTeam.DataRelease);
                    }
                    if (tTeam.Folder != null)
                    {
                        chkFolder.Checked       = true;
                        dtpFolderReceived.Value = Convert.ToDateTime(tTeam.Folder);
                    }

                    if (tTeam.Hold != null)
                    {
                        cmbHold.Text = tTeam.Hold.Trim();
                    }
                    else
                    {
                        cmbHold.Text = "Active";
                    }



                    //using (var bmpTemp = new Bitmap(findpic.Path))
                    //{

                    //    image = new Bitmap(bmpTemp);
                    //    pbJob.Image = image;

                    //}
                }
            }
        }
Example #14
0
        private void btnSubmit2_Click(object sender, EventArgs e)
        {
            using (var db = new TestEntities())
            {
                Team tTeam = db.Teams.Find(strjobnumber);

                if (tTeam == null)
                {
                    Team tTeam2 = new Team();
                    tTeam2.JobNumber = strjobnumber;

                    if (cmbPM.SelectedIndex != -1)
                    {
                        tTeam2.ProgramManager = cmbPM.SelectedItem.ToString();
                    }
                    if (cmbProcessor.SelectedIndex != -1)
                    {
                        tTeam2.Processor = cmbProcessor.SelectedItem.ToString();
                    }

                    if (cmbBl.SelectedIndex != -1)
                    {
                        tTeam2.BuildLeader = cmbBl.SelectedItem.ToString();
                    }

                    if (cmbQa.SelectedIndex != -1)
                    {
                        tTeam2.QA = cmbQa.SelectedItem.ToString();
                    }

                    if (chkKickoff.Checked == true)
                    {
                        tTeam2.KickOff = dtpKickoff.Value;
                    }
                    if (chkDataRelease.Checked == true)
                    {
                        tTeam2.DataRelease = dtpDataRelease.Value;
                    }
                    if (chkFolder.Checked == true)
                    {
                        tTeam2.Folder = dtpFolderReceived.Value;
                    }

                    tTeam2.PODate = dtpPoDate.Value;

                    string hold = "";
                    hold = cmbHold.Text;

                    tTeam2.Hold = hold;

                    db.Teams.Add(tTeam2);
                    db.SaveChanges();
                    MessageBox.Show("Team Created!");
                    this.Close();
                }

                else
                {
                    tTeam.JobNumber      = strjobnumber;
                    tTeam.ProgramManager = Convert.ToString(cmbPM.Text);
                    tTeam.BuildLeader    = Convert.ToString(cmbBl.Text);
                    tTeam.Processor      = Convert.ToString(cmbProcessor.Text);
                    tTeam.QA             = Convert.ToString(cmbQa.Text);
                    if (chkKickoff.Checked == true)
                    {
                        tTeam.KickOff = dtpKickoff.Value;
                    }
                    if (chkDataRelease.Checked == true)
                    {
                        tTeam.DataRelease = dtpDataRelease.Value;
                    }
                    if (chkFolder.Checked == true)
                    {
                        tTeam.Folder = dtpFolderReceived.Value;
                    }

                    tTeam.PODate = dtpPoDate.Value;


                    string hold = "";
                    hold = cmbHold.Text;

                    tTeam.Hold = hold;

                    db.SaveChanges();

                    MessageBox.Show("Team Updated!");
                    this.Close();
                }
            }
        }
Example #15
0
        private void testgrid2_Load(object sender, EventArgs e)
        {
            gc1.ShowGroupDropArea = true;
            // gc1.DataSource = ds_activejobs;
            activeJobsTableAdapter.Fill(this.ds_activejobs.ActiveJobs);

            gc1.TableModel.ReadOnly = true;

            zoom = new ZoomGroupingGrid(gc1);

            // gc1.DataMember = ds_activejobs.ActiveJobs;

            Syncfusion.Grouping.SortColumnDescriptor cd = new Syncfusion.Grouping.SortColumnDescriptor("ShipDate");

            cd.Categorizer = new CustomCategorizer();
            this.gc1.TableDescriptor.GroupedColumns.Add(cd);
            //   this.gc1.QueryCellText += gc1_QueryCellText;

            //Summary Columns

            TestEntities db       = new TestEntities();
            DateTime     maxbatch = db.Batches.Max(p => p.BatchTime);


            lblTimeStamp.Text = "Data Accurate as of: " + maxbatch.ToString();

            #region summary columns

            gc1.TableDescriptor.VisibleColumns.Remove("ShipMonth");
            gc1.TableDescriptor.VisibleColumns.Remove("Batch");
            gc1.TableDescriptor.Columns["ShipDate"].Appearance.AnyRecordFieldCell.Format = "MM/dd/yyyy";

            gc1.TableDescriptor.Appearance.AnyRecordFieldCell.WrapText = true;

            gc1.TableModel.RowHeights.ResizeToFit(GridRangeInfo.Table());

            GridSummaryColumnDescriptor sc1 = new GridSummaryColumnDescriptor();
            sc1.Appearance.AnySummaryCell.Interior = new Syncfusion.Drawing.BrushInfo(Color.FromArgb(192, 255, 165));
            sc1.DataMember  = "RemainingRev";
            sc1.Format      = "{Sum}";
            sc1.Name        = "Remaining Revenue";
            sc1.SummaryType = SummaryType.Int32Aggregate;



            GridSummaryColumnDescriptor sc2 = new GridSummaryColumnDescriptor();
            sc2.Appearance.AnySummaryCell.Interior = new Syncfusion.Drawing.BrushInfo(Color.FromArgb(192, 255, 165));
            sc2.DataMember  = "POValue";
            sc2.Format      = "{Sum}";
            sc2.Name        = "Purchase Order Value";
            sc2.SummaryType = SummaryType.Int32Aggregate;


            //   sc2.TableDescriptor.Columns[0].Appearance.AnyRecordFieldCell.Format = "C";


            GridSummaryColumnDescriptor sc3 = new GridSummaryColumnDescriptor();
            sc3.Appearance.AnySummaryCell.Interior = new Syncfusion.Drawing.BrushInfo(Color.FromArgb(192, 255, 165));
            sc3.DataMember  = "Actual";
            sc3.Format      = "{Sum}";
            sc3.Name        = "Actual";
            sc3.SummaryType = SummaryType.Int32Aggregate;

            sc1.Appearance.AnySummaryCell.Format = "c";
            sc2.Appearance.AnySummaryCell.Format = "c";
            sc3.Appearance.AnySummaryCell.Format = "c";

            GridSummaryColumnDescriptor sc4 = new GridSummaryColumnDescriptor();
            sc4.Appearance.AnySummaryCell.Interior = new Syncfusion.Drawing.BrushInfo(Color.FromArgb(192, 255, 165));
            sc4.DataMember  = "Weld";
            sc4.Format      = "{Sum}";
            sc4.Name        = "Weld Hours Remaining";
            sc4.SummaryType = SummaryType.Int32Aggregate;

            GridSummaryColumnDescriptor sc5 = new GridSummaryColumnDescriptor();
            sc5.Appearance.AnySummaryCell.Interior = new Syncfusion.Drawing.BrushInfo(Color.FromArgb(192, 255, 165));
            sc5.DataMember  = "Machine";
            sc5.Format      = "{Sum}";
            sc5.Name        = "Machine Hours Remaining";
            sc5.SummaryType = SummaryType.Int32Aggregate;

            GridSummaryColumnDescriptor sc6 = new GridSummaryColumnDescriptor();
            sc6.Appearance.AnySummaryCell.Interior = new Syncfusion.Drawing.BrushInfo(Color.FromArgb(192, 255, 165));
            sc6.DataMember  = "Design";
            sc6.Format      = "{Sum}";
            sc6.Name        = "Design Hours Remaining";
            sc6.SummaryType = SummaryType.Int32Aggregate;

            GridSummaryColumnDescriptor sc7 = new GridSummaryColumnDescriptor();
            sc7.Appearance.AnySummaryCell.Interior = new Syncfusion.Drawing.BrushInfo(Color.FromArgb(192, 255, 165));
            sc7.DataMember  = "Tracker";
            sc7.Format      = "{Sum}";
            sc7.Name        = "Tracker Hours Remaining";
            sc7.SummaryType = SummaryType.Int32Aggregate;

            GridSummaryColumnDescriptor sc8 = new GridSummaryColumnDescriptor();
            sc8.Appearance.AnySummaryCell.Interior = new Syncfusion.Drawing.BrushInfo(Color.FromArgb(192, 255, 165));
            sc8.DataMember  = "Build";
            sc8.Format      = "{Sum}";
            sc8.Name        = "Build Hours Remaining";
            sc8.SummaryType = SummaryType.Int32Aggregate;


            GridSummaryRowDescriptor sr1 = new GridSummaryRowDescriptor();
            sr1.SummaryColumns.Add(sc1);
            sr1.SummaryColumns.Add(sc2);
            sr1.SummaryColumns.Add(sc3);
            sr1.SummaryColumns.Add(sc4);
            sr1.SummaryColumns.Add(sc5);
            sr1.SummaryColumns.Add(sc6);
            sr1.SummaryColumns.Add(sc7);
            sr1.SummaryColumns.Add(sc8);

            gc1.Appearance.AnySummaryCell.HorizontalAlignment = GridHorizontalAlignment.Right;

            sr1.Appearance.AnySummaryCell.Interior = new Syncfusion.Drawing.BrushInfo(Color.FromArgb(255, 231, 162));

            gc1.TableDescriptor.SummaryRows.Add(sr1);

            #endregion


            //   gc1.TableControl.PrepareViewStyleInfo += new;

            gc1.TableControl.CommentTipShowing += new CommentTipShowingEventHandler(TableControl_CommentTipShowing);



            //GridConditionalFormatDescriptor f1 = new GridConditionalFormatDescriptor();
            f1.Appearance.AnyRecordFieldCell.Interior  = new Syncfusion.Drawing.BrushInfo(Color.FromArgb(220, 20, 60));
            f1.Appearance.AnyRecordFieldCell.TextColor = Color.White;
            f1.Expression = "[age1] > 10 and [Comp] < 20";
            f1.Name       = "Format1";

            //GridConditionalFormatDescriptor f2 = new GridConditionalFormatDescriptor();
            f2.Appearance.AnyRecordFieldCell.Interior  = new Syncfusion.Drawing.BrushInfo(Color.FromArgb(30, 144, 255));
            f2.Appearance.AnyRecordFieldCell.TextColor = Color.White;
            f2.Expression = "[age1] < 10";
            f2.Name       = "Format2";

            gc1.TableDescriptor.ConditionalFormats.Add(f1);
            gc1.TableDescriptor.ConditionalFormats.Add(f2);

            gc1.QueryCellStyleInfo             += new GridTableCellStyleInfoEventHandler(gc1_QueryCellStyleInfo);
            gc1.SourceListListChangedCompleted += Gc1_SourceListListChangedCompleted;

            GridColumnDescriptor desc1 = new GridColumnDescriptor();

            desc1.MappingName = "BaseID";
            desc1.Appearance.AnyRecordFieldCell.Interior = new Syncfusion.Drawing.BrushInfo(Color.FromArgb(237, 240, 246));

            gc1.TableControl.HScroll = true;
            gc1.TableControl.VScroll = true;

            if (gc1.TableControl.HScrollBar.InnerScrollBar != null && gc1.TableControl.VScrollBar != null)
            {
                gc1.TableControl.HScrollBar.InnerScrollBar.Height = 50;
                gc1.TableControl.VScrollBar.InnerScrollBar.Height = 50;
            }


            gc1.TableControl.ControlAdded += TableControl_ControlAdded;
        }
Example #16
0
        public frmRedTag()
        {
            InitializeComponent();

            using (var db2 = new TestEntities())
            {
                var defectCodes = (from em in db2.Reasons
                                   where em.Code.StartsWith("D")
                                   select new { Code = em.Code, Description = em.Detail });


                var scripts = (from em in db2.Reasons
                               where em.Code.StartsWith("D")
                               select em.Detail).ToArray();

                // cmbDefect.DataSource = (from em in db2.Reasons
                //                            where em.Code.StartsWith("D")
                //                         select em).ToList();
                cmbDefect.DataSource    = defectCodes.ToList();
                cmbDefect.DisplayMember = "Description";

                AutoCompleteStringCollection autoc = new AutoCompleteStringCollection();

                autoc.AddRange(scripts);

                cmbDefect.AutoCompleteMode         = AutoCompleteMode.SuggestAppend;
                cmbDefect.AutoCompleteCustomSource = autoc;
                cmbDefect.AutoCompleteSource       = AutoCompleteSource.CustomSource;

                var causeCodes = (from em in db2.Reasons
                                  where em.Code.StartsWith("C")
                                  select new { Code = em.Code, Description = em.Detail });
                scripts = (from em in db2.Reasons
                           where em.Code.StartsWith("C")
                           select em.Detail).ToArray();

                cmbCause.DataSource    = causeCodes.ToList();
                cmbCause.DisplayMember = "Description";

                AutoCompleteStringCollection autoc2 = new AutoCompleteStringCollection();


                autoc2.AddRange(scripts);

                cmbCause.AutoCompleteMode         = AutoCompleteMode.SuggestAppend;
                cmbCause.AutoCompleteCustomSource = autoc2;
                cmbCause.AutoCompleteSource       = AutoCompleteSource.CustomSource;



                var deptCodes = (from em in db2.Reasons
                                 where em.Code.StartsWith("R")
                                 select new { Code = em.Code, Description = em.Detail });
                scripts = (from em in db2.Reasons
                           where em.Code.StartsWith("R")
                           select em.Detail).ToArray();



                cmbDept.DataSource    = deptCodes.ToList();
                cmbDept.DisplayMember = "Description";

                AutoCompleteStringCollection autoc3 = new AutoCompleteStringCollection();


                autoc3.AddRange(scripts);

                cmbDept.AutoCompleteMode         = AutoCompleteMode.SuggestAppend;
                cmbDept.AutoCompleteCustomSource = autoc3;
                cmbDept.AutoCompleteSource       = AutoCompleteSource.CustomSource;
            }
        }
Example #17
0
        private void btnDates_Click(object sender, EventArgs e)
        {
            //    dtMaterial;
            //public DateTime dtFabrication;
            //public DateTime dtHeat;
            //public DateTime dtMachining;
            //public DateTime dtAssembly;

            dtMaterial     = dtpMaterial.Value.Date;
            dtFabrication  = dtpFab.Value.Date;
            dtHeat         = dtpHt.Value.Date;
            dtMachining    = dtpMachine.Value.Date;
            dtAssembly     = dtpAssy.Value.Date;
            dtMachComplete = dtpMachineComp.Value.Date;
            dtCheck        = dtpRdyChk.Value.Date;
            dtSrc          = dtpSrc.Value.Date;
            dtDesRel       = dtpDesRel.Value.Date;

            //   CommentEntities db = new CommentEntities();
            //   ImportantDate iDate = new ImportantDate();

            using (var db = new TestEntities())
            {
                ImportantDate iDate = db.ImportantDates.Find(strJobNumber);
                if (iDate != null)
                {
                    iDate.BaseID         = strJobNumber;
                    iDate.RecvMaterial   = dtMaterial;
                    iDate.StartFab       = dtFabrication;
                    iDate.HeatTreat      = dtHeat;
                    iDate.StartMachining = dtMachining;
                    iDate.StartAssy      = dtAssembly;
                    iDate.MachComp       = dtMachComplete;
                    iDate.RdyChk         = dtCheck;
                    iDate.RdySrc         = dtSrc;
                    iDate.DesRel         = dtDesRel;
                    MessageBox.Show("Dates Updates. GREAT JOB!");
                }
                else
                {
                    ImportantDate iDate2 = new ImportantDate();
                    iDate2.BaseID         = strJobNumber;
                    iDate2.RecvMaterial   = dtMaterial;
                    iDate2.StartFab       = dtFabrication;
                    iDate2.HeatTreat      = dtHeat;
                    iDate2.StartMachining = dtMachining;
                    iDate2.StartAssy      = dtAssembly;
                    iDate2.MachComp       = dtMachComplete;
                    iDate2.RdyChk         = dtCheck;
                    iDate2.RdySrc         = dtSrc;
                    iDate2.DesRel         = dtDesRel;
                    db.ImportantDates.Add(iDate2);
                }

                db.SaveChanges();
                MessageBox.Show("Dates Saved. GREAT JOB!");
            }



            //try
            //{
            //    db.SaveChanges();
            //    MessageBox.Show("Dates Saved. GREAT JOB!");
            //}

            //catch (Exception ex)
            //{
            //    MessageBox.Show("Something went wrong. Call Jacob. Give him this error: " + ex);

            //}
        }
Example #18
0
        public frmRedTag(int tagnumber)
        {
            InitializeComponent();
            int iTagnumber = Convert.ToInt16(tagnumber);

            TestEntities db = new TestEntities();

            tblRedTag rt1 = db.tblRedTags.Find(iTagnumber);

            Reason rs1 = new Reason();

            using (var db2 = new TestEntities())
            {
                cmbDefect.DataSource = db2.Reasons.SqlQuery("select Code from dbo.reasons where code like '%D'");
            }

            if (rt1 != null)
            {
                txtTag.Text = rt1.ID.ToString();

                if (rt1.JOB != null)
                {
                    txtJob.Text = rt1.JOB;
                }

                if (rt1.Detail != null)
                {
                    txtTool.Text = rt1.Detail;
                }

                if (rt1.Initiator != null)
                {
                    cmbInitiator.Text = rt1.Initiator;
                }
                if (rt1.Dept != null)
                {
                    cmbDept.Text = rt1.Dept;
                }
                if (rt1.Spec != null)
                {
                    txtSpec.Text = rt1.Spec;
                }

                if (rt1.Condition != null)
                {
                    txtCondition.Text = rt1.Condition;
                }


                if (rt1.Date != null)
                {
                    dtpInspection.Text = rt1.Date.ToString();
                }

                if (rt1.Defect != null)
                {
                    cmbDefect.Text = rt1.Defect;
                }

                if (rt1.Cause != null)
                {
                    cmbCause.Text = rt1.Cause;
                }

                if (rt1.Reinspection != null)
                {
                    dtpReinspection.Text = rt1.Reinspection.ToString();
                }

                if (rt1.Cost != null)
                {
                    txtRework.Text = rt1.Cost.ToString();
                }


                if (rt1.InstanceCost != null)
                {
                    txtInstance.Text = rt1.InstanceCost.ToString();
                }


                if (rt1.ScrapCost != null)
                {
                    txtScrap.Text = rt1.ScrapCost.ToString();
                }

                if (rt1.VendorPO != null)
                {
                    txtVendor.Text = rt1.VendorPO;
                }

                if (rt1.Instructions != null)
                {
                    txtInstructions.Text = rt1.Instructions;
                }

                if (rt1.Comment != null)
                {
                    txtComments.Text = rt1.Comment;
                }



                // cmbDisposition.Text = rt1.
            }
        }
Example #19
0
        public void schedule_Load(object sender, EventArgs e)
        {
            int xx1 = 12;
            int xx2 = 127;
            int xx3 = 237;
            int xx4 = 354;
            int yy  = 24;

            if (department == "fab")
            {
                lblCategory.Text  = "Start Fab";
                lblfinsih.Visible = false;

                using (var context = new TestEntities())
                {
                    var jobs = from b in context.ImportantDates

                               .Where(b => b.StartFab.ToString() != "0001-01-01")
                               .OrderBy(x => x.StartFab)

                               select b;
                    var result = jobs.ToList();
                    var count  = jobs.Count();


                    for (int i = 0; i < count; i++)
                    {
                        Controls.Add(new Label {
                            Location = new Point(xx1, yy), AutoSize = true, Text = result[i].BaseID.ToString()
                        });
                        Controls.Add(new Label {
                            Location = new Point(xx2, yy), AutoSize = true, Text = result[i].StartFab.ToString()
                        });
                        //   Controls.Add(new Label { Location = new Point(xx3, yy), AutoSize = true, Text = result[i].h})
                        yy += 20;
                    }
                }
            }
            if (department == "machine")
            {
                lblCategory.Text = "Start Machine";
                lblfinsih.Text   = "Machine Complete";


                using (var context = new TestEntities())
                {
                    var jobs = from b in context.ImportantDates

                               .Where(b => b.StartMachining.ToString() != "0001-01-01")
                               .OrderBy(x => x.StartMachining)

                               select b;
                    var result = jobs.ToList();
                    var count  = jobs.Count();


                    for (int i = 0; i < count; i++)
                    {
                        Controls.Add(new Label {
                            Location = new Point(xx1, yy), AutoSize = true, Text = result[i].BaseID.ToString()
                        });
                        Controls.Add(new Label {
                            Location = new Point(xx2, yy), AutoSize = true, Text = Convert.ToDateTime(result[i].StartMachining).ToString("MM/dd/yyyy")
                        });
                        Controls.Add(new Label {
                            Location = new Point(xx3, yy), AutoSize = true, Text = Convert.ToDateTime(result[i].MachComp).ToString("MM/dd/yyyy")
                        });
                        yy += 20;
                    }
                }
            }
        }