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