public ActionResult get_IPBill_PT_Information(long billno)
        {
            IPBillCorrectionDB _DB = new IPBillCorrectionDB();
            IPBillInfo         _RE = _DB.get_IPBill_PT_Information(billno);
            var serializer         = new JavaScriptSerializer {
                MaxJsonLength = Int32.MaxValue
            };
            var result = new ContentResult
            {
                Content     = serializer.Serialize(new { Res = _RE ?? new IPBillInfo(), rcode = _DB.ret, rmsg = _DB.retmsg }),
                ContentType = "application/json"
            };

            return(result);
        }
 public IPBillInfo get_IPBill_PT_Information(long billno)
 {
     try
     {
         DB.param = new SqlParameter[] {
             new SqlParameter("@billno", billno),
             new SqlParameter("@retcode", SqlDbType.Int),
             new SqlParameter("@retmsgs", SqlDbType.VarChar, 500)
         };
         DB.param[1].Direction = ParameterDirection.Output;
         DB.param[2].Direction = ParameterDirection.Output;
         IPBillInfo DD = DB
                         .ExecuteSPAndReturnDataTable("aripbilling.get_ipbill_info")
                         .DataTableToList <IPBillInfo>().FirstOrDefault();
         this.ret    = int.Parse(DB.param[1].Value.ToString());
         this.retmsg = DB.param[2].Value.ToString();
         return(DD);
     }
     catch (Exception ex)
     {
         eLOG.LogError(ex);
         throw new ApplicationException("Error Message:</b> <br /> " + ex.Message + "<br /><br /><b>Stack Trace:</b><br /> " + ex.StackTrace);
     }
 }