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