Esempio n. 1
0
 public ProjProdAssign_View(Form parentView, int projectID)
 {
     this.parentView   = parentView;
     ProjectId         = projectID;
     this.projProdCont = new ProjectProductController();
     InitializeComponent();
 }
Esempio n. 2
0
        /// <summary>
        /// Handles the Load event of the ProjProdAssign_Form control.
        /// </summary>
        /// <param name="sender">The source of the event.</param>
        /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param>
        /// Erstellt von Veit Berg, am 27.01.16
        private void ProjProdAssign_Form_Load(object sender, EventArgs e)
        {
            try
            {
                using (ProjectProductController proProCont = new ProjectProductController())
                {
                    ProjProds = proProCont.GetAllProjectProductsForOneProject(ProjectId);
                    using (ProductController prodCon = new ProductController())
                    {
                        foreach (ProjectProduct projProd in ProjProds)
                        {
                            var singleProdId = prodCon.GetProductById(projProd.Product_Id);
                            projProd.Name = singleProdId.Name.ToString();
                        }
                    }
                }


                using (ProductController prodCont = new ProductController())
                {
                    AllProds = prodCont.GetAllProductsFromDb();

                    if (ProjProds.Count != 0)
                    {
                        foreach (ProjectProduct projProd in ProjProds)
                        {
                            Product allocatedProd = AllProds.Single(prod => prod.Product_Id == projProd.Product_Id);
                            AllProds.Remove(allocatedProd);
                        }
                    }
                }
                dataGridView_prodAvail.Rows.Clear();
                var ProdBindingList = new BindingList <Product>(AllProds);
                var prodSource      = new BindingSource(ProdBindingList, null);
                dataGridView_prodAvail.DataSource = AllProds;
                dataGridView_prodAvail.Columns["Producer"].HeaderText   = "Hersteller";
                dataGridView_prodAvail.Columns["Product_Id"].HeaderText = "Produkt ID";
                dataGridView_prodAvail.Columns["Price"].HeaderText      = "Preis";

                dataGridView_ProjProd.Rows.Clear();

                var ProjProdBindingList = new BindingList <ProjectProduct>(ProjProds);
                var projProdSource      = new BindingSource(ProjProdBindingList, null);
                dataGridView_ProjProd.DataSource = ProjProds;
                dataGridView_ProjProd.Columns.Remove("Project_Id");
                dataGridView_ProjProd.Columns.Remove("Product");
                dataGridView_ProjProd.Columns.Remove("Project");
                dataGridView_ProjProd.Columns["Product_Id"].HeaderText = "Produkt ID";
                dataGridView_ProjProd.Columns[1].Width = 200;
                this.FormClosing += new FormClosingEventHandler(ProjProdAssign_View_FormClosing);
            }
            catch (Exception i)
            {
                MessageBox.Show(i.Message);
            }
        }
        //Methode um das Grundgerüst der Tabellen zu erstellen
        private PdfPTable GetNewProductTable(List <AnalysedProduct> productsForThisTable, int firstProdId, int tableNumber)
        {
            ProjectProductController projprodContr = new ProjectProductController();
            int numberOfallProductsForThisProject  = projprodContr.GetAllProjectProductsForOneProject(this.Project.Project_Id).Count;

            int numOfProdsInThisTable = productsForThisTable.Count;

            //Überschrift und nötige Formatierung setzen (Schriftart, Fett Druck, Schriftgröße)
            Font arialBold = FontFactory.GetFont("Arial_BOLD", 10, Font.BOLD);
            Font products  = FontFactory.GetFont("Arial_BOLD", 7, Font.NORMAL);
            //Erstellen einer Pdf Tabelle in der die Daten aus der Datenbank ausgegeben werden

            //Erstellen der PdfTable
            PdfPTable CritTable = new PdfPTable(numOfProdsInThisTable + 4);


            //int der die Anzahl der festen Spalten und die variable Anzahl der Produkte enthält
            int numberOfCells = numOfProdsInThisTable + 4;

            // Je nach Anzahl der Produkte in der Datenbank wir die relative Spaltenbreite gesetzt
            if (numberOfCells == 3)
            {
                float[] widths = { 20f, 2f, 2f, }; CritTable.SetWidths(widths);;
            }
            if (numberOfCells == 4)
            {
                float[] widths = { 20f, 2f, 1f, 3f, }; CritTable.SetWidths(widths);;
            }
            if (numberOfCells == 5)
            {
                float[] widths = { 20, 2f, 2f, 3f, 3f }; CritTable.SetWidths(widths);;
            }
            if (numberOfCells == 6)
            {
                float[] widths = { 20, 2f, 2f, 3f, 3f, 3f }; CritTable.SetWidths(widths);;
            }
            if (numberOfCells == 7)
            {
                float[] widths = { 20f, 2f, 2f, 3f, 3f, 3f, 3f }; CritTable.SetWidths(widths);;
            }
            if (numberOfCells == 8)
            {
                float[] widths = { 20f, 2f, 2f, 3f, 3f, 3f, 3f, 3f }; CritTable.SetWidths(widths);;
            }
            if (numberOfCells == 9)
            {
                float[] widths = { 20f, 2f, 2f, 3f, 3f, 3f, 3f, 3f, 3f }; CritTable.SetWidths(widths);;
            }

            // Die Grenzen der Tabelle unsichtbar machen
            CritTable.DefaultCell.Border = 1;
            //Anzeigen der ersten Zeilen als Überschrift auf jeder Seite des Dokuments
            CritTable.HeaderRows = 1;
            //Platz zwischen Produktlegende und der Tabelle
            CritTable.SpacingBefore = 20f;

            //if-Abfrage für die, je nach Anzahl der Produkte, korrekte "Überschrift der Tabelle"
            if (numberOfallProductsForThisProject > 5)
            {
                CritTable.AddCell(new Paragraph(String.Format("Nutzwert - Analyse   [{0}. Teil]", tableNumber), arialBold));
            }
            else
            {
                CritTable.AddCell(new Paragraph("Nutzwert - Analyse", arialBold));
            }

            CritTable.AddCell(new Paragraph(" "));                   //Leere Zelle sorgt für Abstand zwischen Header und Erfüllungen
            CritTable.AddCell(new Paragraph("Gew.", products));      //Spaltenüberschriften
            CritTable.AddCell(new Paragraph("Proz.", products));

            foreach (AnalysedProduct analysedProd in productsForThisTable)
            {
                string prodHeader = "Prd." + firstProdId.ToString();
                CritTable.AddCell(new Paragraph(prodHeader, products));
                firstProdId++;
            }

            CritTable.HorizontalAlignment = 0;
            //Totale Breite der "Tabelle"
            CritTable.TotalWidth  = 700f;
            CritTable.LockedWidth = true;

            return(CritTable);
        }
        /// <summary>
        /// Methode um Pdf erstellen etc.
        /// </summary>
        ///
        /// Erstellt von Adrian Glasnek

        public void CreateFulfillmentForEveryProductPdf()
        {
            ProjectProductController projprodContr = new ProjectProductController();

            this.AllProductsForThisProject = projprodContr.GetAllProjectProductsForOneProject(this.Project.Project_Id);
            List <ProjectCriterion> baseCriterions = this.ProjCritContr.GetBaseProjectCriterions(this.Project.Project_Id); //Get all base Criterions

            SfdFulfillment.Filter = "Pdf File |*.pdf";
            if (SfdFulfillment.ShowDialog() == DialogResult.OK)
            {
                FulfillmentPrinter.SetMargins(50, 200, 50, 125); //Seitenränder definieren
                try                                              //try catch um Fehler abzufangen wenn eine gleichnamige PDF noch geöffnet ist
                {
                    PdfWriter writer = PdfWriter.GetInstance(FulfillmentPrinter, new FileStream(SfdFulfillment.FileName, FileMode.Create));
                    writer.PageEvent = new PdfPageEvents();
                }
                catch (Exception) { throw new Exception("Bitte schließen Sie das geöffnete Pdf!"); }

                //Dokument öffnen um es bearbeiten zu können
                FulfillmentPrinter.Open();

                ////int der die Anzahl der festen Spalten und die variable Anzahl der Produkte enthält
                int countProducts = AllProductsForThisProject.Count();

                int prodCounter = 1;
                //Zählt wieviele Produkte in der Datenbank liegen und schreibt dementsprechend viele Spalten auf das Pdf
                foreach (ProjectProduct Prod in AllProductsForThisProject)
                {
                    //Paragraph um Namen der Produkte mit den Abkürzungen in der Tabelle verbinden zu können
                    //Font für die Ausgabe der Produktlegende
                    Paragraph productName  = new Paragraph();
                    Font      prodNameFont = FontFactory.GetFont("Arial", 9);
                    productName.Font = prodNameFont;
                    productName.Add("Prd. " + prodCounter.ToString() + "     -     " + Prod.Product.Name + "\n");
                    FulfillmentPrinter.Add(productName);   //Produktname der vergliechenen Produkte auf dem Dokument anzeige

                    prodCounter++;
                }


                //Bei einer Anzahl von mehr als 5 Produkten innerhalb eines NWA-Projekts werden jeweils weitere Tabellen mit den restlichen Produkten generiert
                List <List <ProjectProduct> > tableLists = GetProdTableLists();
                int firstProdId = 1;
                int tableNumber = 1;
                foreach (List <ProjectProduct> prodsInTable in tableLists)
                {
                    PdfPTable CritTable = GetNewProductTable(prodsInTable, firstProdId, tableNumber);

                    //Methodenaufruf
                    PrintCriterionStructure(ref CritTable, prodsInTable);

                    //Tabelle zum Dokument Adden
                    FulfillmentPrinter.Add(CritTable);

                    // Neue Seite ab jedem neuem "Teil" der tabellarischen Ansicht
                    FulfillmentPrinter.NewPage();

                    firstProdId += this.maxProductsInTable;
                    tableNumber++;
                }

                //Close Dokument - Bearbeitung Beenden
                FulfillmentPrinter.Close();

                //Aufrufen der Hilfsmethode (aus Klasse CriterionStructurePrinter)- Seitenzahl und den Projektnamen auf Pdf
                GetPageNumber(SfdFulfillment, 800);

                //Erfolgsmeldung
                MessageBox.Show("Pdf erfolgreich erstellt!");

                //PDf wird automatisch geöffnet nach der erfolgreichen Speicherung
                System.Diagnostics.Process.Start(SfdFulfillment.FileName);
            }
        }
Esempio n. 5
0
        /// <summary>
        /// Handles the Load event of the ProjCritProdFulfilment_Form control.
        /// </summary>
        /// <param name="sender">The source of the event.</param>
        /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param>
        /// Erstellt von Veit Berg, am 27.01.16
        private void ProjCritProdFulfilment_Form_Load(object sender, EventArgs e)
        {
            try{
                formloaded = 1;
                using (ProjectProductController Projverw = new ProjectProductController())
                {
                    ProjectProduct        projprod     = (ProjectProduct)comboBox_ProjCritProdFulf.SelectedItem;
                    List <ProjectProduct> ProdList     = Projverw.GetAllProjectProductsForOneProject(Project.Project_Id);
                    List <Product>        productsList = new List <Product>();
                    foreach (ProjectProduct projProd in ProdList)
                    {
                        productsList.Add(projProd.Product);
                    }
                    comboBox_ProjCritProdFulf.DataSource = productsList;

                    comboBox_ProjCritProdFulf.DisplayMember = "Name";
                    comboBox_ProjCritProdFulf.SelectedIndex = -1;
                }
                using (ProjectCriterionController proCriCont = new ProjectCriterionController())
                {
                    ProjCrits = proCriCont.GetSortedCriterionStructure(Project.Project_Id);
                    using (CriterionController critCon = new CriterionController())
                    {
                        foreach (ProjectCriterion projCrit in ProjCrits)
                        {
                            var singleCritId = critCon.GetCriterionById(projCrit.Criterion_Id);
                            projCrit.Name = singleCritId.Name.ToString();
                        }
                    }
                    var CritBindingList = new BindingList <ProjectCriterion>(ProjCrits);
                    var CritSource      = new BindingSource(CritBindingList, null);
                    dataGridView_ProjCritProdFulf.DataSource = ProjCrits;
                    dataGridView_ProjCritProdFulf.Columns.Remove("Project_Id");
                    dataGridView_ProjCritProdFulf.Columns.Remove("Weighting_Cardinal");
                    dataGridView_ProjCritProdFulf.Columns.Remove("Weighting_Percentage_Layer");
                    dataGridView_ProjCritProdFulf.Columns.Remove("Weighting_Percentage_Project");
                    dataGridView_ProjCritProdFulf.Columns.Remove("Criterion");
                    dataGridView_ProjCritProdFulf.Columns.Remove("ParentCriterion");
                    dataGridView_ProjCritProdFulf.Columns.Remove("Project");
                    DataGridViewCheckBoxColumn chk = new DataGridViewCheckBoxColumn();
                    dataGridView_ProjCritProdFulf.Columns.Add(chk);
                    chk.Name = "Erfüllung";
                    DataGridViewTextBoxColumn bem = new DataGridViewTextBoxColumn();
                    bem.Name = "Bemerkung";
                    dataGridView_ProjCritProdFulf.Columns.Add(bem);
                    dataGridView_ProjCritProdFulf.Columns[4].DisplayIndex                 = 0;
                    dataGridView_ProjCritProdFulf.Columns[3].DisplayIndex                 = 1;
                    dataGridView_ProjCritProdFulf.Columns[5].DisplayIndex                 = 2;
                    dataGridView_ProjCritProdFulf.Columns[1].DisplayIndex                 = 3;
                    dataGridView_ProjCritProdFulf.Columns[0].DisplayIndex                 = 4;
                    dataGridView_ProjCritProdFulf.Columns[2].DisplayIndex                 = 5;
                    dataGridView_ProjCritProdFulf.Columns[0].HeaderText                   = "C-ID";
                    dataGridView_ProjCritProdFulf.Columns[1].HeaderText                   = "Layer";
                    dataGridView_ProjCritProdFulf.Columns[2].HeaderText                   = "P-ID";
                    dataGridView_ProjCritProdFulf.Columns[3].HeaderText                   = "Name";
                    dataGridView_ProjCritProdFulf.Columns[4].Name                         = "Erfüllung";
                    dataGridView_ProjCritProdFulf.Columns["Name"].ReadOnly                = true;
                    dataGridView_ProjCritProdFulf.Columns["Layer_Depth"].ReadOnly         = true;
                    dataGridView_ProjCritProdFulf.Columns["Criterion_ID"].ReadOnly        = true;
                    dataGridView_ProjCritProdFulf.Columns["Parent_Criterion_Id"].ReadOnly = true;
                    dataGridView_ProjCritProdFulf.Columns[0].Width                        = 50;
                    dataGridView_ProjCritProdFulf.Columns[1].Width                        = 50;
                    dataGridView_ProjCritProdFulf.Columns[2].Width                        = 50;
                    dataGridView_ProjCritProdFulf.Columns[4].Width                        = 50;
                    dataGridView_ProjCritProdFulf.Columns[3].Width                        = 150;
                    dataGridView_ProjCritProdFulf.Columns[5].Width                        = 200;
                    foreach (DataGridViewRow row in dataGridView_ProjCritProdFulf.Rows)
                    {
                        row.Cells["Erfüllung"].Value = false;
                    }
                }
            }
            catch (Exception i)
            {
                MessageBox.Show(i.Message);
            }
            this.dataGridView_ProjCritProdFulf.CellValidating += new
                                                                 DataGridViewCellValidatingEventHandler(dataGridView_ProjCritProdFulf_CellValidating);
            this.FormClosing += new FormClosingEventHandler(ProjCritProdFulfillment_View_FormClosing);
        }