Esempio n. 1
0
        public dynamic GetMeesevaAppStatucData(MEESEVASTATUSMODEL objStatus)
        {
            dynamic objdata = new ExpandoObject();

            try
            {
                DataTable dt1 = GetMeesevaStatusCheck_SP(objStatus);
                if (dt1 != null && dt1.Rows.Count > 0)
                {
                    objdata.Status     = 100;
                    objdata.StatusList = dt1;
                    objdata.Reason     = "";
                }
                else
                {
                    objdata.Status     = 102;
                    objdata.StatusList = new DataTable();
                    objdata.Reason     = "This Application Number Data is Not Available";
                }
            }
            catch (Exception ex)
            {
                string mappath   = HttpContext.Current.Server.MapPath("MeesevaInitiateExceptionLogs");
                Task   WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_ReportLog_Exception(mappath, ex.Message.ToString()));

                objdata.Status     = 102;
                objdata.StatusList = new DataTable();
                objdata.Reason     = ErrMessage;
            }
            return(objdata);
        }
        public IHttpActionResult GetMeesevaAppStatus(dynamic data)
        {
            string value = token_gen.Authorize_aesdecrpty(data);

            try
            {
                string             json    = JsonConvert.SerializeObject(value);
                MEESEVASTATUSMODEL _rotobj = JsonConvert.DeserializeObject <MEESEVASTATUSMODEL>(json);
                return(Ok(_objemeesva.GetMeesevaAppStatucData(_rotobj)));
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Esempio n. 3
0
        public DataTable GetMeesevaStatusCheck_SP(MEESEVASTATUSMODEL obj3)
        {
            OracleCommand cmd = new OracleCommand();

            try
            {
                cmd.InitialLONGFetchSize = 1000;
                cmd.CommandType          = CommandType.StoredProcedure;
                cmd.CommandText          = "GSWS_MEESEVA_STATUS_CHECK";
                cmd.Parameters.Add("ptype", OracleDbType.Varchar2).Value            = obj3.Ftype;
                cmd.Parameters.Add("pDEPTRECIEPTCODE", OracleDbType.Varchar2).Value = obj3.DeptrecieptCode;
                cmd.Parameters.Add("pstatus_code", OracleDbType.Varchar2).Value     = obj3.Statuscode;
                cmd.Parameters.Add("pstatus_msg", OracleDbType.Varchar2).Value      = obj3.Statusmsg;
                cmd.Parameters.Add("p_cur", OracleDbType.RefCursor).Direction       = ParameterDirection.Output;
                DataTable dt = GetgswsDataAdapter(cmd);
                return(dt);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }