コード例 #1
0
ファイル: Program.cs プロジェクト: diego-maquill/MovieRental
        static void ShowListOfAllCustomers()
        {
            var ShowAllCustomers = new Customer_Video_Connection(_iconfiguration);
            var Customers        = ShowAllCustomers.GetListAllCustomers();

            Console.WriteLine();
            Console.WriteLine("In this table we have the following Customers:");
            Customers.ForEach(item =>
            {
                Console.WriteLine(item.Name);
            });
            Console.WriteLine();
            Console.WriteLine("Press any key to stop.");
            Console.ReadKey();
        }
コード例 #2
0
ファイル: Program.cs プロジェクト: diego-maquill/MovieRental
        static void ShowSingleCustomer()
        {
            var ShowSingleCustomer = new Customer_Video_Connection(_iconfiguration);

            Console.WriteLine();
            Console.Write("Type the id number of the person you wish to see: ");
            int userInput      = Convert.ToInt32(Console.ReadLine());
            var singleCustomer = ShowSingleCustomer.GetSingleCustomer(userInput);

            if (userInput > 0)
            {
                Console.WriteLine($"You typed customerId: {singleCustomer.Id}, it belongs to: {singleCustomer.Name}");
            }
            else
            {
                Console.WriteLine("You wrote a negative number or 0");
            }
            Console.WriteLine();
            Console.WriteLine("Press any key to stop.");
            Console.ReadKey();
        }
コード例 #3
0
ファイル: Program.cs プロジェクト: diego-maquill/MovieRental
        static void ShowAllActiveRentals()
        {
            var ShowAllActiveRentals = new Customer_Video_Connection(_iconfiguration);

            Console.WriteLine();
            Console.WriteLine("The active rentals are:");
            Console.WriteLine();
            DataSet ds = ShowAllActiveRentals.GeActiveRentals_ds();
            //    var ds = ShowAllActiveRentals.DataSet(new GetActiveRentals());

            /*
             *     string currentLine = "";
             *     var nameLengths = new int[ds.Tables[0].Columns.Count];
             *     var i = 0;
             *     foreach (var col in ds.Tables[0].Columns)
             *     {
             *         var colName = col.ToString();
             *         nameLengths[i] = colName.Length;
             *         currentLine += " " + colName;
             *         i++;
             *     }
             *     Console.WriteLine(currentLine);
             */
            // var dataLength = new int[ds.Tables[0].Columns.Count];
            int nCols      = ds.Tables[0].Columns.Count;
            var dataWidths = ds.Tables[0].Columns.Cast <DataColumn>().Select(x => x.ColumnName.Length).ToList();

            foreach (DataRow row in ds.Tables[0].Rows)
            {
                for (int i = 0; i < nCols; i++)
                {
                    dataWidths[i] = Math.Max(dataWidths[i], row.ItemArray[i].ToString().Length);
                }
            }

            var colFormats = dataWidths.Select(x => $"{{0,{-x}}}").ToList();

            var sb = new StringBuilder();

            sb.AppendLine(string.Join(" ", ds.Tables[0].Columns.Cast <DataColumn>().Select((x, i) => string.Format(colFormats[i], x.ColumnName))));

            foreach (DataRow row in ds.Tables[0].Rows)
            {
                sb.AppendLine(string.Join(" ", row.ItemArray.Select((x, i) => string.Format(colFormats[i], x))));
            }

            Console.WriteLine(sb.ToString());

            /*
             *          foreach (DataRow row in ds.Tables[0].Rows)
             *          //foreach (DataRow row in ds.Rows)
             *          {
             *              //Console.WriteLine($"{row[0]}, {row[1]}, {row[2]}, {row[3]}, {row[4]}");
             *              currentLine = "";
             *              i = 0;
             *              foreach (var item in row.ItemArray)
             *              {
             *                  var field = item.ToString();
             *                  //      dataLength[i] = field.Length;
             *                  //currentLine += " " + field.PadRight(nameLengths[i], ' ');
             *                  currentLine += " " + field.PadRight(nameLengths[i], ' ');
             *                  i++;
             *              }
             *              Console.WriteLine(currentLine);
             *          }
             */
            Console.WriteLine();
            Console.WriteLine("Press any key to stop.");
            Console.ReadKey();
        }