public DataTable GetArogyaRakshaStatus_data_helper(AppStatus obj)
        {
            try
            {
                var comd = new OracleCommand();

                comd.InitialLONGFetchSize = 1000;
                comd.CommandType          = CommandType.StoredProcedure;
                comd.CommandText          = "ct_schema.gsws_check_status";
                comd.Parameters.Add("ftype", OracleDbType.Varchar2).Value      = obj.ftype;
                comd.Parameters.Add("fdpart_id", OracleDbType.Varchar2).Value  = obj.fdpart_id;
                comd.Parameters.Add("fadhar_no", OracleDbType.Varchar2).Value  = obj.fadhar_no;
                comd.Parameters.Add("P_CUR", OracleDbType.RefCursor).Direction = ParameterDirection.Output;

                DataTable data = GetspsDataAdapter(comd);
                if (data != null && data.Rows.Count > 0)
                {
                    return(data);
                }
                else
                {
                    return(null);
                }
            }
            catch (WebException wex)
            {
                string mappath   = HttpContext.Current.Server.MapPath("ArogyaRakshaExceptionLogs");
                Task   WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_Log_Exception(mappath, "Error Arogya Raksha App Status API:" + wex.Message.ToString()));
                throw new Exception(wex.Message);
            }
        }
        public IHttpActionResult GetKantiVeluguStatus(dynamic data)
        {
            string value = token_gen.Authorize_aesdecrpty(data);

            try
            {
                //string value = JsonConvert.SerializeObject(data);
                AppStatus rootobj = JsonConvert.DeserializeObject <AppStatus>(value);
                if (Utils.IsAlphaNumeric(rootobj.student_id))
                {
                    return(Ok(heahel.GetMethod("http://drysrkv.ap.gov.in/API/KantiVelugu/API_GS_APKV_STUDENT_REPORT/" + rootobj.student_id)));
                }
                else
                {
                    CatchData.Status = 102;
                    CatchData.Reason = "Student Number does not contain special charactes";
                    return(Ok(CatchData));
                }
            }
            catch (Exception ex)
            {
                Common_Health_Error(ex.Message.ToString(), "http://drysrkv.ap.gov.in/API/KantiVelugu/API_GS_APKV_STUDENT_REPORT/", "2");
                CatchData.Status = 102;
                CatchData.Reason = HealthHelper.ThirdpartyMessage;
                return(Ok(CatchData));
            }
        }
        public IHttpActionResult GetArogyaRakshaStatus(dynamic data)
        {
            string value = token_gen.Authorize_aesdecrpty(data);

            try
            {
                //string value = JsonConvert.SerializeObject(data);
                AppStatus rootobj = JsonConvert.DeserializeObject <AppStatus>(value);
                return(Ok(heahel.GetArogyaRakshaStatus_helper(rootobj)));
            }
            catch (Exception ex)
            {
                CatchData.Status = 102;
                CatchData.Reason = "Error Occured";
                return(Ok(CatchData));
            }
        }
        public dynamic GetArogyaRakshaStatus_helper(AppStatus root)
        {
            dynamic obj = new ExpandoObject();

            try
            {
                if (Utils.IsAlphaNumeric(root.fadhar_no))
                {
                    DataTable data = GetArogyaRakshaStatus_data_helper(root);


                    if (data != null)
                    {
                        obj.Status  = 100;
                        obj.Reason  = "Data Loaded Successfully.";
                        obj.Details = data;
                    }
                    else
                    {
                        obj.Status = 101;
                        obj.Reason = "No Data Found";
                    }
                }
                else
                {
                    obj.Status = 102;
                    obj.Reason = "Does not contain special characters";
                }
            }
            catch (Exception ex)
            {
                obj.Status = 102;
                obj.Reason = "Error Occured";
            }

            return(obj);
        }