private static PSP.Terminal BuildTerminal(XmlDocument xmlUser) { PSP.Terminal ter = new PSP.Terminal(); ter.isdn = ""; try { if (xmlUser.SelectSingleNode("//returncode").InnerText.Equals("0")) { ter.isdn = xmlUser.SelectSingleNode("//msisdn").InnerText; if (ter.isdn.StartsWith("976")) ter.isdn = ter.isdn.Remove(0, 3); ter.sclass = xmlUser.SelectSingleNode("//sclass").InnerText; if (ter.sclass.Equals("APS")) ter.balance = Convert.ToSingle(xmlUser.SelectSingleNode("//balance").InnerText); else ter.balance = Convert.ToSingle(xmlUser.SelectSingleNode("//balance").InnerText) / 1000.0f; ter.status = Convert.ToInt32(xmlUser.SelectSingleNode("//status").InnerText); ter.begdate = ConvertToDate(xmlUser.SelectSingleNode("//begindate").InnerText); ter.enddate = ConvertToDate(xmlUser.SelectSingleNode("//enddate").InnerText); if (ter.status == 1) ter.status = 0; // idle else if (DateTime.Now <= ter.enddate) ter.status = 1; // active else if (DateTime.Now.AddDays(-104) > ter.enddate) ter.status = 4; // retired else if (DateTime.Now.AddDays(-14) > ter.enddate) ter.status = 3; // disabled else if (DateTime.Now > ter.enddate) ter.status = 2; // suspend } } catch { ter.isdn = ""; } return ter; }
public static PSP.Terminal UpdateINUser(string isdn, int day, float amount) { PSP.Terminal ter = new PSP.Terminal(); try { if (!isdn.StartsWith("976")) isdn = "976" + isdn; HttpWebRequest req = (HttpWebRequest)WebRequest.Create("http://192.168.2.239/rtcgw.jsp?USERNAME=psp&PASSWORD=smspsp2sms&TYPE=2&day=" + day + "&msisdn=" + isdn + "&amount=" + amount); HttpWebResponse res = (HttpWebResponse)req.GetResponse(); XmlDocument xmlUser = new XmlDocument(); xmlUser.Load(res.GetResponseStream()); ter = BuildTerminal(xmlUser); } catch { ter.isdn = ""; } return ter; }
public static PSP.Terminal GetTerminal(string isdn) { PSP.Terminal t = new PSP.Terminal(); t.isdn = ""; OracleConnection con = new OracleConnection(CerCon.strCon); if (sqlGetTerminal == null) { sqlGetTerminal = new OracleCommand("select ACCESS_NO, TARIFF_CODE, ASSOC_ACCESS_NO from ACCESS_NUMBERS where ACCESS_NO=:isdn"); sqlGetTerminal.Parameters.Add(":isdn", OracleType.VarChar, 8); } try { sqlGetTerminal.Connection = con; con.Open(); if (isdn.StartsWith("976")) isdn = isdn.Remove(0, 3); sqlGetTerminal.Parameters[":isdn"].Value = isdn; OracleDataReader reader = sqlGetTerminal.ExecuteReader(); while (reader.Read()) { t.isdn = isdn; t.sclass= reader["tariff_code"].ToString(); t.imsi = reader["assoc_access_no"].ToString(); } reader.Close(); } catch (Exception ex) { Console.WriteLine("GetTerminalInfo error: " + ex); } finally { con.Close(); } return t; }
private void SaveTerminalData() { DataTable tableInput = Session["tableInput"] as DataTable; if (tableInput != null) { for (int i=0; i<tableInput.Rows.Count; i++) { try { PSP.Terminal t = new PSP.Terminal(); t.isdn = tableInput.Rows[i]["c_isdn"].ToString(); t.imsi = tableInput.Rows[i]["c_imsi"].ToString(); this.PspProxy.SaveTerminal(t, 1); // new subscriber only tableInput.Rows[i].BeginEdit(); tableInput.Rows[i]["c_error"] = "Ok"; tableInput.Rows[i].EndEdit(); } catch (Exception ex) { tableInput.Rows[i].BeginEdit(); tableInput.Rows[i]["c_error"] = ex.Message; tableInput.Rows[i].EndEdit(); } } gridTerminal.DataSource = tableInput; this.DataBind(); } }