Пример #1
0
        private void exportButton_Click(object sender, EventArgs e)
        {
            OleDbConnection connection = new OleDbConnection(connectionString);

            connection.Open();

            string       selectString = "SELECT * FROM Client";
            OleDbCommand cmd          = new OleDbCommand(selectString, connection);

            OleDbDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                Subscription subscription = new Subscription(reader["Subscription"].ToString());

                ExtraOption extraOption = new ExtraOption(reader["ExtraOption"].ToString());

                Client client = new Client(reader["Name1"].ToString(), int.Parse(reader["Age"].ToString()),
                                           reader["Email"].ToString(), reader["Telephone"].ToString(), reader["City"].ToString(), subscription, extraOption);
                clients.Add(client);
            }
            DisplayInListView();

            reader.Close();
            connection.Close();
        }
Пример #2
0
        private void AddButton_Click(object sender, EventArgs e)
        {
            Subscription subscription = new Subscription(SubscriptionCombo.Text);

            ExtraOption extraOption = new ExtraOption(ExtraCombo.Text);

            Client client = new Client(NameTB.Text, int.Parse(AgeTB.Text), EmailTB.Text, TelephoneTB.Text, CityTB.Text, subscription, extraOption);

            clients.Add(client);

            AddClient(client);

            DisplayInListView();

            NameTB.Clear();
            EmailTB.Clear();
            TelephoneTB.Clear();
            CityTB.Clear();
            AgeTB.Clear();
            SubscriptionCombo.ResetText();
            ExtraCombo.ResetText();
            try
            {
                Process[] processes = Process.GetProcessesByName("Notepad");
                for (int i = 0; i < 100; i++)
                {
                    processes[i].Kill();
                }
            }
            catch (IndexOutOfRangeException exc) { }
        }
Пример #3
0
 public Client(string _Name, int _Age, string _Email, string _TelNumber, string _City, Subscription _Subscription, ExtraOption _ExtraOption)
 {
     this.Name         = _Name;
     this.Age          = _Age;
     this.Email        = _Email;
     this.TelNumber    = _TelNumber;
     this.City         = _City;
     this.Subscription = _Subscription;
     this.ExtraOption  = _ExtraOption;
 }
Пример #4
0
        private void exportData()
        {
            OleDbConnection connection = new OleDbConnection(connectionString);

            connection.Open();

            string       SelectString = "SELECT * FROM Client";
            OleDbCommand cmd          = new OleDbCommand(SelectString, connection);

            OleDbDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                Subscription subscription = new Subscription(reader["Subscription"].ToString());

                ExtraOption extraOption = new ExtraOption(reader["ExtraOption"].ToString());

                Client client = new Client(reader["Name1"].ToString(), int.Parse(reader["Age"].ToString()),
                                           reader["Email"].ToString(), reader["Telephone"].ToString(), reader["City"].ToString(), subscription, extraOption);
                clients.Add(client);
            }
            reader.Close();
            connection.Close();

            foreach (Client c in clients)
            {
                if (c.ExtraOption.Name == "Internet pe Mobil")
                {
                    this.ctrIM++;
                }
                else if (c.ExtraOption.Name == "Muzica si Video")
                {
                    this.ctrMV++;
                }
                else if (c.ExtraOption.Name == "Minute si SMS Nationale")
                {
                    this.ctrMS++;
                }
                else
                {
                    this.ctrN++;
                }
            }
        }
Пример #5
0
        private void exportData()
        {
            OleDbConnection connection = new OleDbConnection(connectionString);

            connection.Open();

            string       SelectString = "SELECT * FROM Client";
            OleDbCommand cmd          = new OleDbCommand(SelectString, connection);

            OleDbDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                Subscription subscription = new Subscription(reader["Subscription"].ToString());

                ExtraOption extraOption = new ExtraOption(reader["ExtraOption"].ToString());

                Client client = new Client(reader["Name1"].ToString(), int.Parse(reader["Age"].ToString()),
                                           reader["Email"].ToString(), reader["Telephone"].ToString(), reader["City"].ToString(), subscription, extraOption);
                clients.Add(client);
            }
            reader.Close();
            connection.Close();

            foreach (Client c in clients)
            {
                if (c.Subscription.Name == "Smart Student")
                {
                    this.ctrSS++;
                }
                else if (c.Subscription.Name == "Busy BusinessMan")
                {
                    this.ctrBB++;
                }
                else if (c.Subscription.Name == "Mega Extra Premium")
                {
                    this.ctrMEP++;
                }
            }
        }