protected void ButtonUploadFile_OnClick(Object sender, EventArgs eventArgs)
        {
            Boolean validFile = true;


            ndcImportTable = new DataTable();

            List <String> ndcCategory = new List <String> ();


            SaveResponseLabel.Text = String.Empty;

            if (TelerikUpload.UploadedFiles.Count != 1)
            {
                validFile = false;

                SaveResponseLabel.Text = "Invalid number of files detected.";
            }

            else
            {
                try {
                    System.IO.StreamReader textReader = new System.IO.StreamReader(TelerikUpload.UploadedFiles [0].InputStream);


                    // 2009 FORMAT

                    //ndcImportTable.Columns.Add ("ndc_code");

                    //ndcImportTable.Columns.Add ("brand_name");

                    //ndcImportTable.Columns.Add ("generic_product_name");

                    //ndcImportTable.Columns.Add ("route");

                    //ndcImportTable.Columns.Add ("category");

                    //ndcImportTable.Columns.Add ("obsolete_date");

                    //ndcImportTable.Columns.Add ("drug_id");

                    // 2011 FORMAT

                    ndcImportTable.Columns.Add("NDC Code");

                    ndcImportTable.Columns.Add("Brand Name");

                    ndcImportTable.Columns.Add("Generic Product Name");

                    ndcImportTable.Columns.Add("Route");

                    ndcImportTable.Columns.Add("Category");

                    ndcImportTable.Columns.Add("Drug ID");


                    String header = textReader.ReadLine();  // read header line

                    Dictionary <Int32, String> headerColumns = new Dictionary <Int32, String> ();


                    Int32 currentColumnIndex = 0;

                    foreach (String currentColumnName in header.Split('\t'))
                    {
                        headerColumns.Add(currentColumnIndex, currentColumnName);

                        currentColumnIndex = currentColumnIndex + 1;
                    }



                    String inputLine = textReader.ReadLine();

                    while (inputLine != null)
                    {
                        currentColumnIndex = 0;

                        System.Data.DataRow importRow = ndcImportTable.Rows.Add(String.Empty, String.Empty, String.Empty, String.Empty, String.Empty, String.Empty);

                        foreach (String currentColumn in inputLine.Split('\t'))
                        {
                            importRow[headerColumns[currentColumnIndex]] = currentColumn;

                            currentColumnIndex = currentColumnIndex + 1;

//                            if (currentColumnIndex == importRow.Table.Columns.Count) { break; }
                        }

                        inputLine = textReader.ReadLine();
                    }
                }

                catch (Exception applicationException) {
                    System.Diagnostics.Debug.WriteLine(applicationException.Message);

                    validFile = false;

                    SaveResponseLabel.Text = "Invalid Configuration File.";
                }
            }


            if (!validFile)
            {
                FileUploadSection.Style.Add("display", "inline");

                ConfigurationProcessSection.Style.Add("display", "none");
            }

            else
            {
                TelerikUpload.UploadedFiles.Clear();

                Session[SessionCachePrefix + "NdcImportTable" + SessionCacheSuffix] = ndcImportTable;


                System.Data.DataTable importResultsTable = new DataTable();

                importResultsTable.Columns.Add("ObjectType");

                importResultsTable.Columns.Add("ObjectName");

                importResultsTable.Columns.Add("Success");

                importResultsTable.Columns.Add("Exception");

                importResultsTable.Columns.Add("Id");

                foreach (System.Data.DataRow currentRow in ndcImportTable.Rows)
                {
                    String categoryName = System.Threading.Thread.CurrentThread.CurrentCulture.TextInfo.ToTitleCase(currentRow["category"].ToString());

                    categoryName = categoryName.Replace("\"", "");

                    String serviceName = "Medication - " + categoryName;

                    if (!ndcCategory.Contains(serviceName))
                    {
                        ndcCategory.Add(serviceName);

                        importResultsTable.Rows.Add(

                            "Singleton",

                            serviceName,

                            String.Empty,

                            String.Empty,

                            application.MedicalServiceGetIdByName(serviceName)

                            );
                    }
                }

                System.Data.DataView importResultsView = new DataView(importResultsTable);

                importResultsView.Sort = "ObjectType, ObjectName";

                ImportResultsGrid.DataSource = importResultsView;

                ImportResultsGrid.Rebind();

                ButtonImport.Visible = true;
            }

            return;
        }
Exemple #2
0
        protected void ButtonUploadFile_OnClick(Object sender, EventArgs eventArgs)
        {
            Boolean validFile = true;


            SaveResponseLabel.Text = String.Empty;

            if (TelerikUpload.UploadedFiles.Count != 1)
            {
                validFile = false;

                SaveResponseLabel.Text = "Invalid number of files detected.";
            }

            else
            {
                try {
                    configurationDocument = new System.Xml.XmlDocument();

                    System.IO.StreamReader streamReader = new System.IO.StreamReader(TelerikUpload.UploadedFiles[0].InputStream);

                    configurationDocument.LoadXml(streamReader.ReadToEnd());
                }

                catch (Exception applicationException) {
                    System.Diagnostics.Debug.WriteLine(applicationException.Message);

                    validFile = false;

                    SaveResponseLabel.Text = "Invalid Configuration File.";
                }
            }


            if (!validFile)
            {
                FileUploadSection.Style.Add("display", "inline");

                ConfigurationProcessSection.Style.Add("display", "none");
            }

            else
            {
                Mercury.Server.Application.ImportExportResponse importResponse;

                importResponse = MercuryApplication.CoreObject_XmlImport(configurationDocument.OuterXml);


                System.Data.DataTable importResultsTable = new DataTable();

                importResultsTable.Columns.Add("ObjectType");

                importResultsTable.Columns.Add("ObjectName");

                importResultsTable.Columns.Add("Success");

                importResultsTable.Columns.Add("Exception");

                importResultsTable.Columns.Add("Id");

                if (MercuryApplication.LastException == null)
                {
                    foreach (Mercury.Server.Application.ImportExportResult currentResult  in importResponse.Results)
                    {
                        importResultsTable.Rows.Add(

                            currentResult.ObjectType,

                            currentResult.ObjectName,

                            currentResult.Success.ToString(),

                            (currentResult.HasException) ? currentResult.Exception.Message : String.Empty,

                            currentResult.Id.ToString()

                            );
                    }
                }

                else
                {
                    importResultsTable.Rows.Add("Error", "Import Error", "False", MercuryApplication.LastException.Message, 0);
                }

                ImportResultsGrid.DataSource = importResultsTable;

                ImportResultsGrid.Rebind();
            }

            return;
        }
        protected void ButtonImport_OnClick(Object sender, EventArgs eventArgs)
        {
            System.Data.DataView sortedNdcView = new DataView(ndcImportTable);

            // sortedNdcView.Sort = "category, ndc_code"; // 2009

            sortedNdcView.Sort = "[Category], [NDC Code]"; // 2011

            Boolean allowOverwrite = false;

            Boolean allowMerge = true;

            Boolean processNdc = false;

            Boolean serviceProcess = true;



            String currentServiceName = String.Empty;

            Client.Core.MedicalServices.ServiceSingleton currentSingleton = null;

            Client.Core.MedicalServices.Definitions.ServiceSingletonDefinition currentSingletonDefinition = null;



            System.Data.DataTable importResultsTable = new DataTable();

            importResultsTable.Columns.Add("ObjectType");

            importResultsTable.Columns.Add("ObjectName");

            importResultsTable.Columns.Add("Success");

            importResultsTable.Columns.Add("Exception");

            importResultsTable.Columns.Add("Id");



            foreach (System.Data.DataRow currentRow in sortedNdcView.ToTable().Rows)
            {
                String categoryName = System.Threading.Thread.CurrentThread.CurrentCulture.TextInfo.ToTitleCase(currentRow["category"].ToString());

                categoryName = categoryName.Replace("\"", "");

                String serviceName = "Medication - " + categoryName;

                if (currentServiceName != serviceName)
                {
                    #region New Services based on Change in Medication Name

                    if (currentSingleton != null)
                    {
                        #region If Working on Previous Service, Save before Continuing

                        if (currentSingletonDefinition != null)
                        {
                            if (!String.IsNullOrEmpty(currentSingletonDefinition.NdcCodeCriteria))
                            {
                                currentSingletonDefinition.NdcCodeCriteria = currentSingletonDefinition.NdcCodeCriteria.Replace("}{", ", ");

                                currentSingletonDefinition.NdcCodeCriteria = currentSingletonDefinition.NdcCodeCriteria.Replace("{", "");

                                currentSingletonDefinition.NdcCodeCriteria = currentSingletonDefinition.NdcCodeCriteria.Replace("}", "");

                                currentSingletonDefinition.NdcCodeCriteria.Trim();

                                if (!String.IsNullOrWhiteSpace(currentSingletonDefinition.NdcCodeCriteria))
                                {
                                    currentSingleton.Definitions.Add(currentSingletonDefinition);
                                }
                            }
                        }

                        Mercury.Server.Application.ObjectSaveResponse saveResponse = application.MedicalServiceSave(currentSingleton);

                        importResultsTable.Rows.Add(

                            "Singleton",

                            currentSingleton.Name,

                            saveResponse.Success,

                            (saveResponse.HasException) ? saveResponse.Exception.Message : String.Empty,

                            saveResponse.Id

                            );

                        #endregion
                    }

                    serviceProcess = true;

                    currentServiceName = serviceName;

                    currentSingleton = application.MedicalServiceSingletonGet(application.MedicalServiceGetIdByName(currentServiceName));

                    if (currentSingleton == null)
                    {
                        serviceProcess = true;

                        currentSingleton = new Mercury.Client.Core.MedicalServices.ServiceSingleton(application);

                        currentSingleton.Name = currentServiceName;

                        currentSingleton.Description = currentServiceName;

                        currentSingleton.ServiceType = Mercury.Server.Application.MedicalServiceType.Singleton;

                        currentSingleton.ServiceClassification = Mercury.Server.Application.ServiceClassification.Medication;
                    }

                    else
                    {
                        serviceProcess = allowOverwrite || allowMerge;

                        if (allowOverwrite)
                        {
                            foreach (Client.Core.MedicalServices.Definitions.ServiceSingletonDefinition currentDefinition in currentSingleton.Definitions)
                            {
                                currentDefinition.Enabled = false;
                            }
                        }
                    }

                    currentSingletonDefinition = null;

                    #endregion
                }


                if (currentSingletonDefinition != null)
                {
                    #region Current Definition Exists for Appending, check Length for cutoff

                    if (currentSingletonDefinition.NdcCodeCriteria.Length > 800)
                    {
                        currentSingletonDefinition.NdcCodeCriteria = currentSingletonDefinition.NdcCodeCriteria.Replace("}{", ", ");

                        currentSingletonDefinition.NdcCodeCriteria = currentSingletonDefinition.NdcCodeCriteria.Replace("{", "");

                        currentSingletonDefinition.NdcCodeCriteria = currentSingletonDefinition.NdcCodeCriteria.Replace("}", "");

                        currentSingletonDefinition.NdcCodeCriteria.Trim();

                        if (!String.IsNullOrWhiteSpace(currentSingletonDefinition.NdcCodeCriteria))
                        {
                            currentSingleton.Definitions.Add(currentSingletonDefinition);
                        }

                        currentSingletonDefinition = null;
                    }

                    #endregion
                }


                if (currentSingletonDefinition == null)   // MUST REMAIN AS ITS OWN VALIDATION SINCE A CUTOFF WILL SET CURRENT BACK TO NULL

                {
                    #region No Current Definition to Append To, Create New Definition

                    currentSingletonDefinition = new Client.Core.MedicalServices.Definitions.ServiceSingletonDefinition(MercuryApplication);

                    currentSingletonDefinition.DataSourceType = Mercury.Server.Application.ServiceDataSourceType.Pharmacy;

                    #endregion
                }

                if (serviceProcess)
                {
                    // VALIDATE THAT THE SINGLETON DOES NOT ALREADY CONTAIN THE NDC IN ANOTHER DEFINITION

                    if (!currentSingleton.ContainsNdc(currentRow["NDC Code"].ToString().Trim()))
                    {
                        // 2009: currentSingletonDefinition.NdcCodeCriteria = currentSingletonDefinition.NdcCodeCriteria + "{" + (currentRow["ndc_code"].ToString ().Trim ()) + "}";

                        currentSingletonDefinition.NdcCodeCriteria = currentSingletonDefinition.NdcCodeCriteria + "{" + (currentRow["NDC Code"].ToString().Trim()) + "}";   // 2011
                    }
                }
            }


            if ((currentSingleton != null) && (currentSingletonDefinition != null))
            {
                #region SAVE ANY LEFT OVER SERVICE AND DEFINITION FROM LOOP

                currentSingletonDefinition.NdcCodeCriteria = currentSingletonDefinition.NdcCodeCriteria.Replace("}{", ", ");

                currentSingletonDefinition.NdcCodeCriteria = currentSingletonDefinition.NdcCodeCriteria.Replace("{", "");

                currentSingletonDefinition.NdcCodeCriteria = currentSingletonDefinition.NdcCodeCriteria.Replace("}", "");

                currentSingletonDefinition.NdcCodeCriteria.Trim();

                if (!String.IsNullOrWhiteSpace(currentSingletonDefinition.NdcCodeCriteria))
                {
                    currentSingleton.Definitions.Add(currentSingletonDefinition);
                }


                Mercury.Server.Application.ObjectSaveResponse saveResponse = application.MedicalServiceSave(currentSingleton);

                importResultsTable.Rows.Add(

                    "Singleton",

                    currentSingleton.Name,

                    saveResponse.Success,

                    (saveResponse.HasException) ? saveResponse.Exception.Message : String.Empty,

                    saveResponse.Id

                    );

                #endregion
            }

            System.Data.DataView importResultsView = new DataView(importResultsTable);

            importResultsView.Sort = "ObjectType, ObjectName";

            ImportResultsGrid.DataSource = importResultsView;

            ImportResultsGrid.Rebind();

            ButtonImport.Visible = false;


            return;
        }