/// <summary>
        /// Make company Inactive
        /// </summary>
        /// <param name="companyId"></param>
        /// <param name="status"></param>
        /// <param name="message"></param>
        public void StockCompany_DeActivate(int? companyId, out int status, out string message)
        {
            string msg;
            int stat = 0;

            var outStatusId = new ObjectParameter("o_Status", typeof(int));
            var outMessage = new ObjectParameter("o_Message", typeof(string));

            using (var db = new StockMonitorEntities())
            {
                db.spStockCompany_DeActivate(companyId, outStatusId, outMessage);

                stat = (int)outStatusId.Value;
                msg = (string)outMessage.Value;
            }
            status = stat;
            message = msg;
        }
 public StoreQueryRepository()
 {
     _store = new StockMonitorEntities();
 }
        /// <summary>
        /// Register new company
        /// </summary>
        /// <param name="ticker"></param>
        /// <param name="companyName"></param>
        /// <param name="exchangeName"></param>
        /// <param name="industryName"></param>
        /// <param name="sectorName"></param>
        /// <param name="exchangeId"></param>
        /// <param name="industryId"></param>
        /// <param name="sectorId"></param>
        /// <param name="companyId"></param>
        /// <param name="message"></param>
        /// <returns></returns>
        public void StockCompany_Register(string ticker, string companyName, string exchangeName, string industryName, string sectorName, int? exchangeId, int? industryId, int? sectorId, out int companyId, out string message)
        {
            string msg;
            int id = 0;

            var outCompanyId = new ObjectParameter("o_Company", typeof(int));
            var outMessage = new ObjectParameter("o_Message", typeof(string));

            using (var db = new StockMonitorEntities())
            {
                db.spStockCompany_Register(ticker, companyName, exchangeName, industryName, sectorName, exchangeId,
                                           industryId, sectorId, outCompanyId, outMessage);

                id = (int)outCompanyId.Value;
                msg = (string)outMessage.Value;
            }
            companyId = id;
            message = msg;
        }