public void SaveTerminal(Terminal t, int flag) {
ValidatePermission("PhoneInfo.Edit");
SqlConnection con = new SqlConnection(strCon);
daTerminal.UpdateCommand.Connection = con;
try {
con.Open();
daTerminal.UpdateCommand.Parameters["@isdn"].Value = t.isdn;
daTerminal.UpdateCommand.Parameters["@imsi"].Value = t.imsi;
daTerminal.UpdateCommand.Parameters["@flag"].Value = flag;
daTerminal.UpdateCommand.ExecuteNonQuery();
}
catch (Exception ex) {
AsyncLogWriter("SaveTerminal:" + ex);
}
finally {
con.Close();
}
}
protected void buttonSave_Click(object sender, System.EventArgs e) {
PSP.Terminal t = new Terminal();
t.isdn = textPhone.Text;
t.imsi = textIMSI.Text;
try {
this.PspProxy.SaveTerminal(t, 0); // update imsi
}
catch {}
}
public Terminal GetTerminal(string isdn) {
ValidatePermission("PhoneInfo.View");
Terminal t = new Terminal();
t.isdn = "";
SqlConnection con = new SqlConnection(strCon);
daTerminal.SelectCommand.Connection = con;
try {
con.Open();
if (isdn.Length == 6) isdn = "99" + isdn;
daTerminal.SelectCommand.Parameters["@isdn"].Value = isdn;
SqlDataReader reader = daTerminal.SelectCommand.ExecuteReader();
while (reader.Read()) {
t.isdn = isdn;
t.sclass= reader["c_sclass"].ToString();
t.price = reader["c_price"].ToString();
t.balance = Convert.ToSingle(reader["c_balance"]);
t.status = Convert.ToInt32(reader["c_status"]);
t.begdate = Convert.ToDateTime(reader["c_begindate"]);
t.enddate = Convert.ToDateTime(reader["c_enddate"]);
t.expdate = Convert.ToDateTime(reader["c_expiredate"]);
t.imsi = reader["c_imsi"].ToString();
try {
t.pin = reader["c_pin"].ToString();
t.puk = reader["c_puk"].ToString();
t.kappli = reader["c_kappli"].ToString();
t.simref = reader["c_simref"].ToString();
}
catch {}
}
reader.Close();
}
catch (Exception ex) {
Console.WriteLine("GetTerminal :" + ex);
}
finally {
con.Close();
}
return t;
}
private void PopulateTerminal(Terminal t) {
textSclass.Text = t.sclass;
textPrice.Text = t.price;
textBalance.Text = t.balance.ToString();
comboStatus.SelectedIndex = t.status;
textIMSI.Text = t.imsi;
textPin.Text = t.pin;
textPuk.Text = t.puk;
textSimRef.Text = t.simref;
textBeginDate.Text = t.begdate.ToString("yyyy-MM-dd");
textEndDate.Text = t.enddate.ToString("yyyy-MM-dd");
textExpireDate.Text = t.expdate.ToString("yyyy-MM-dd");
}
