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;
}
