public static string GetBillingStatus(string token) { string ret = "Error"; if (token != secKey) { return("Ivalid Token."); } try { DB_Utility objDBUTil = new DB_Utility(conStr); DataTable dt = objDBUTil.getBillingStatus(); utility util = new utility(); ret = util.DataTableToJSONWithStringBuilder(dt); } catch (Exception ex) { ret = ex.ToString(); } return(ret); }
public string GetBillStatus(string token) { string secKey = System.Configuration.ConfigurationManager.AppSettings["SECKEY"].ToString(); string conStr = System.Configuration.ConfigurationManager.ConnectionStrings["CONSTR"].ToString(); string ret = "Error"; if (token != secKey) { return("Ivalid Token."); } try { DB_Utility objDBUTil = new DB_Utility(conStr); DataTable dt = objDBUTil.getBillingStatus(); utility util = new utility(); ret = util.DataTableToJSONWithStringBuilder(dt); } catch (Exception ex) { ret = ex.ToString(); } return(ret); }