private void OnAddSubcriber_Click(object sender, RoutedEventArgs e) { string currentMSISDN = this.SubscriberMSISDN.Text; string currentName = this.SubscriberName.Text; string currentEGN = this.SubscriberEGN.Text; string currentTariffPlan = defaultTariffPlan; double account = 0; Subscriber currentSubscriber = new Subscriber(currentMSISDN, currentName, currentEGN); //work with Hashset Subscriber.AddSubscriber(currentSubscriber); if (this.SubscriberTariffPlan.SelectedItem != null) { currentTariffPlan = this.SubscriberTariffPlan.SelectedItem.ToString(); currentSubscriber.ChangeTariffPlan(currentTariffPlan); } if (this.SubscriberAccount.Text != null) { account = double.Parse(this.SubscriberAccount.Text.ToString()); currentSubscriber.UpdateAccount(account); } billingSystemDB.InsertSubscriber(currentSubscriber); SubscriberAllTextBoxInit(sender, e); }
//Select statement public Subscriber SelectSubscriber(string msisdnOrEgn, bool byEGN = false) { string query = string.Empty; if (byEGN) query = string.Format("SELECT subscriber_msisdn, subscriber_name, subscriber_egn, subscriber_tariffplan, subscriber_account FROM subscriber WHERE subscriber_egn='{0}'", msisdnOrEgn); else query = string.Format("SELECT subscriber_msisdn, subscriber_name, subscriber_egn, subscriber_tariffplan, subscriber_account FROM subscriber WHERE subscriber_msisdn='{0}'", msisdnOrEgn); Subscriber subscriber = new Subscriber(); if (this.OpenConnection() == true) { MySqlCommand cmd = new MySqlCommand(query, connection); MySqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { string msisdn = dataReader["subscriber_msisdn"] as string; string name = dataReader["subscriber_name"] as string; string egn = dataReader["subscriber_egn"] as string; subscriber = new Subscriber(msisdn, name, egn); subscriber.ChangeTariffPlan(dataReader["subscriber_tariffplan"] as string); subscriber.UpdateAccount((double)dataReader["subscriber_account"]); } dataReader.Close(); this.CloseConnection(); } return subscriber; }