コード例 #1
0
ファイル: DALContainer.cs プロジェクト: JustinAarden/CSC
        /// <summary>
        /// The get containers.
        /// </summary>
        /// <param name="ship">
        /// The ship.
        /// </param>
        /// <param name="port">
        /// The port.
        /// </param>
        /// <returns>
        /// The <see cref="List"/>.
        /// </returns>
        public List<Container> GetContainers(string ship, string port)
        {
            var containerlist = new List<Container>();

            using (var db = new Database())
            {
                Container containers = null;
                db.OpenConnection();
                db.CreateCommand(
                    "Select Container.*,Company.Name AS name,Ship.type AS shiptype from Container,Ship,Port,Company WHERE Ship.Type LIKE @ship AND Port.Name LIKE @port AND Company.ID = Container.Company_ID AND Ship.ID = Container.Ship_ID");
                db.AddParameter("@ship", ship);
                db.AddParameter("@port", port);

                MySqlDataReader dr = db.Command.ExecuteReader();

                while (dr.Read())
                {
                    containers = new Container();
                    containers.id = (int)dr["id"];
                    containers.type = (string)dr["type"];
                    containers.weight = (int)dr["weight"];
                    containers.onship = (string)dr["shiptype"];
                    containers.companyname = (string)dr["name"];
                    containerlist.Add(containers);
                }
            }

            return containerlist;
        }
コード例 #2
0
ファイル: CSC.cs プロジェクト: JustinAarden/CSC
        /// <summary>
        /// The bt export_ click.
        /// </summary>
        /// <param name="sender">
        /// The sender.
        /// </param>
        /// <param name="e">
        /// The e.
        /// </param>
        private void btExport_Click(object sender, EventArgs e)
        {
            {
                var folderBrowserDialog1 = new FolderBrowserDialog();

                // Set the help text description for the FolderBrowserDialog.
                folderBrowserDialog1.Description = "Selecteer waar u het bestand wilt opslaan.";

                // Do not allow the user to create new files via the FolderBrowserDialog.
                folderBrowserDialog1.ShowNewFolderButton = false;

                // Default to the My Documents folder.
                folderBrowserDialog1.RootFolder = Environment.SpecialFolder.Personal;

                if (folderBrowserDialog1.ShowDialog() == DialogResult.OK)
                {
                    // Set a variable to the My Documents path.
                    string comboship = this.comboTypeSchip.SelectedItem.ToString();
                    string port = this.comboBestemming.SelectedItem.ToString();
                    var company = new Company();
                    var container = new Container();
                    string date = DateTime.Now.ToString("dd-MM-yyyy"); //sets the date
                    List<Container> containers = BLContainer.GetContainers(comboship, port);
                    string mydocpath = folderBrowserDialog1.SelectedPath;
                    var str = new StringBuilder();

                    containers = containers.OrderBy(o => container.companyname).ToList(); //sorts the list on companyname
                    str.AppendLine("Gemaakt op:  " + date); //sets date in document
                    str.AppendLine();
                    str.AppendLine("Bestemming:  " + port);//sets selected desination
                    str.AppendLine();
                    str.AppendLine("Schip type:  " + comboship); //sets selected ship
                    str.AppendLine();

                    foreach (Container containerlist in containers)
                    {
                        str.AppendLine(
                            string.Format(
                                "{0}: Container ID:{1}  -  X:{2}  Y:{3}  Z:{4}",
                                containerlist.companyname,
                                containerlist.id,
                                containerlist.x,
                                containerlist.y,
                                containerlist.z));
                    }

                    using (var outfile = new StreamWriter(mydocpath + @"\CSC Export.txt"))
                    {
                        outfile.Write(str.ToString());
                    }
                }
            }
        }