Ejemplo n.º 1
0
        public async Task Update_Website_URL()
        {
            // var devAppConfigName = "SmartAgentDev";
            var productionDatabase = "SmartAgentProd";

            IDbConnection db     = new SqlConnection(ConfigurationManager.ConnectionStrings[productionDatabase].ConnectionString);
            IKernel       kernel = new StandardKernel(new RepoTestsModule(db));

            var websiteRepo = kernel.Get <IAsyncRepository <WebsiteMaster> >();
            var website     = WebsiteMaster.CreateWebsiteMaster(
                "Allied Physicians Submit",
                "https://portal.nmm.cc/Portal",
                "CFC",
                new Guid("e6b9299a-f903-4120-a481-3e5952fb98bc"),
                122
                );


            await websiteRepo.UpdateAsync(website);

            var websites = await websiteRepo.GetAllAsync();

            var unitedHealthCare = websites.Where(site => site.WebsiteDomain == website.WebsiteDomain).FirstOrDefault();

            Console.WriteLine(unitedHealthCare);
        }
Ejemplo n.º 2
0
        public async Task Create_Website_Test()
        {
            Guid websitekey = Guid.NewGuid();
            var  container  = new UnityContainer();

            var websiteMaster = WebsiteMaster.CreateWebsiteMaster(
                "Emdeon Script",
                "http://portal.nmm.cc/nmm/en/index.jsp",
                "CFC",
                Guid.NewGuid(),
                117
                );

            Func <WebsiteMaster, string, Task <Guid> > CreateWebsiteRecord = async(website, connectionString) =>
            {
                using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings[connectionString].ConnectionString))
                {
                    container.RegisterType <ISmartAgentRepo, CreateSmartAgentUserRepo>(new InjectionConstructor(db));
                    var repo = container.Resolve <ISmartAgentRepo>();
                    return(await repo.CreateWebsiteMasterRecord(website));
                }
            };

            Func <string, string, Task <WebsiteMaster> > FindWebsiteRecord = async(searchTerm, connectionString) =>
            {
                using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings[connectionString].ConnectionString))
                {
                    container.RegisterType <ISmartAgentRepo, CreateSmartAgentUserRepo>(new InjectionConstructor(db));
                    var repo = container.Resolve <ISmartAgentRepo>();
                    return(await repo.FindWebsiteRecord(searchTerm));
                }
            };

            var dataSource     = _devSmartAgent;
            var prodDataSource = _prodSmartAgentDb;

            var result = await FindWebsiteRecord(websiteMaster.WebsiteDescription, dataSource);

            if (result == null)
            {
                websitekey = await CreateWebsiteRecord(websiteMaster, dataSource);

                write(websitekey);
            }
            write(result.WebsiteDescription + " " + result.WebsiteKey);

            var result2 = await FindWebsiteRecord(websiteMaster.WebsiteDescription, prodDataSource);

            if (result2 == null)
            {
                websitekey = await CreateWebsiteRecord(websiteMaster, prodDataSource);

                write(websitekey);
            }
            write(result.WebsiteDescription + " " + result.WebsiteKey);
        }
Ejemplo n.º 3
0
        public async Task <Guid> CreateWebsiteMasterRecord(WebsiteMaster website)
        {
            if (String.IsNullOrWhiteSpace(website.WebsiteDescription))
            {
                throw new ArgumentNullException("Need website description to process.");
            }
            var webSiteExsits = await CheckForWebsiteRecord(website.WebsiteDescription);

            if (webSiteExsits)
            {
                return(new Guid("00000000-0000-0000-0000-000000000000"));
            }
            var query = @"IF NOT EXISTS 
                          (SELECT websiteDescription FROM dsa_websiteMaster 
                            WHERE websiteDescription = @websiteDescription)
                           BEGIN
                          INSERT INTO [ScriptingAgentDatabase].dbo.dsa_websiteMaster(
                            dateAdded,dateChanged,lastUserID, 
                            deviceID
                           , websitekey
                           , websiteDescription, 
                            websiteDomain, DontValidateHCPCS)
	                        VALUES (GetDate(),GetDate(),
                                    'kris.lindsey' ,@deviceId
                                    ,@websiteKey 
                                    ,@websiteDescription ,@websiteDomain ,0)
                            SELECT websiteKey FROM [ScriptingAgentDatabase].dbo.dsa_websiteMaster WHERE websiteDescription = @websiteDescription
                          END";

            var p = new DynamicParameters();

            p.Add("@deviceId", website.DeviceId);
            p.Add("@websiteDescription", website.WebsiteDescription);
            p.Add("@websiteDomain", website.WebsiteDomain);
            p.Add("@websiteKey", website.WebsiteKey);

            try
            {
                var websiteKey = await _db.QueryAsync <Guid>(query, p);

                return(websiteKey.SingleOrDefault());
            }
            catch (SqlException)
            {
                throw;
            }
        }
Ejemplo n.º 4
0
        public async Task Update_Website_Url_Test()
        {
            IDbConnection prodDb = new SqlConnection(ConfigurationManager.ConnectionStrings[_prodSmartAgentDb].ConnectionString);
            IDbConnection devDb  = new SqlConnection(ConfigurationManager.ConnectionStrings[_devSmartAgent].ConnectionString);

            var uhc = WebsiteMaster.CreateWebsiteMaster(
                "Community Family Care",
                "https://www.capcms.com/capconnect/login.aspx",
                "CFC",
                Guid.NewGuid(),
                101
                );

            var container = new UnityContainer();

            container.RegisterType <IAsyncRepository <WebsiteMaster>, WebsiteMasterAsyncRepository>(new InjectionConstructor(devDb));
            var repo = container.Resolve <IAsyncRepository <WebsiteMaster> >();
            await repo.UpdateAsync(uhc);

            Console.WriteLine();
        }
Ejemplo n.º 5
0
        public async Task Create_Website()
        {
            Func <WebsiteMaster, string, Task <Guid> > CreateRecord = async(newRecord, dbConfig) =>
            {
                using (IDbConnection smartAgentDb = new SqlConnection(ConfigurationManager.ConnectionStrings[dbConfig].ConnectionString))
                {
                    IKernel kernel = new StandardKernel(new RepoTestsModule(smartAgentDb));
                    var     repo   = kernel.Get <ISmartAgentRepo>();
                    return(await repo.CreateWebsiteMasterRecord(newRecord));
                }
            };

            var smartAgentDevelopmentDb = "SmartAgentDev";
            var smartAgentProdDb        = "SmartAgentProd";

            var websitesToAdd = new List <WebsiteMaster>();

            var website = WebsiteMaster.CreateWebsiteMaster(
                websiteDesription: "Maverick Medical Group Submit",
                websiteDoman: "https://aerial.carecoordination.medecision.com/pmg/physician/LoginDefault.aspx",
                deviceId: "MMG",
                websiteKey: Guid.NewGuid(),
                portalId: 3
                );

            websitesToAdd.Add(website);


            var result = await CreateRecord(website, smartAgentDevelopmentDb);

            Console.WriteLine(result);

            var prodResult = await CreateRecord(website, smartAgentProdDb);

            Console.WriteLine(prodResult);
        }