public SelezioneDocumentiAllegatiUI(Business.Interface.DocumentoFilter filterDocumenti)
        {
            InitializeComponent();
            inizializza();

            _filterDocumenti = filterDocumenti;
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="objInvestorLog"></param>
        /// <returns></returns>
        internal int AddNewInvestorLog(Business.InvestorLog objInvestorLog)
        {
            int Result = -1;
            System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
            DSTableAdapters.InvestorLogTableAdapter adap = new DSTableAdapters.InvestorLogTableAdapter();

            try
            {
                conn.Open();
                adap.Connection = conn;
                Result = int.Parse(adap.AddNewInvestorLog(objInvestorLog.InvestorInstance.InvestorID, objInvestorLog.Time, objInvestorLog.IP, objInvestorLog.Message,
                                    objInvestorLog.Status).ToString());
            }
            catch (Exception ex)
            {
                return -1;
            }
            finally
            {
                adap.Connection.Close();
                conn.Close();
            }

            return Result;
        }

        public override bool IsRequired(Business.Test.AccessionOrder accessionOrder)
        {
            bool result = false;
            YellowstonePathology.Business.Test.ThinPrepPap.ThinPrepPapTest panelSetThinPrep = new YellowstonePathology.Business.Test.ThinPrepPap.ThinPrepPapTest();
            if (accessionOrder.PanelSetOrderCollection.Exists(panelSetThinPrep.PanelSetId) == true)
            {
                YellowstonePathology.Business.Test.ThinPrepPap.PanelSetOrderCytology panelSetOrderCytology = (YellowstonePathology.Business.Test.ThinPrepPap.PanelSetOrderCytology)accessionOrder.PanelSetOrderCollection.GetPanelSetOrder(panelSetThinPrep.PanelSetId);
                if (panelSetOrderCytology.Final == true)
                {
                    if (YellowstonePathology.Business.Cytology.Model.CytologyResultCode.IsDiagnosisThreeOrBetter(panelSetOrderCytology.ResultCode) == true)
                    {
                        YellowstonePathology.Business.Domain.PatientHistory patientHistory = YellowstonePathology.Business.Gateway.AccessionOrderGateway.GetPatientHistory(accessionOrder.PatientId);
                        Nullable<DateTime> dateOfLastHPV = patientHistory.GetDateOfPreviousHpv(accessionOrder.AccessionDate.Value);

                        if (dateOfLastHPV.HasValue == true)
                        {
                            if (dateOfLastHPV < DateTime.Today.AddDays(-330))
                            {
                                result = true;
                            }
                        }
                        else
                        {
                            result = true;
                        }
                    }
                }
            }
            return result;
        }

 private void InitData(Business.Meeting meeting)
 {
     foreach (ac.uk.brunel.contextaware.Note noteItem in meeting.Slides)
     {
         txtMeetingNotes.Text += noteItem.message + SEPARATOR;
     }
 }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="objInvestorGroup"></param>
        /// <returns></returns>
        internal int AddNewInvestorGroup(Business.InvestorGroup objInvestorGroup)
        {
            int Result = -1;
            System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
            DSTableAdapters.InvestorGroupTableAdapter adap = new DSTableAdapters.InvestorGroupTableAdapter();

            try
            {
                conn.Open();
                adap.Connection = conn;

                Result = int.Parse(adap.AddNewInvestorGroup(objInvestorGroup.Name, objInvestorGroup.Owner, objInvestorGroup.DefautDeposite).ToString());
            }
            catch (Exception ex)
            {
                return -1;
            }
            finally
            {
                adap.Connection.Close();
                conn.Close();
            }

            return Result;
        }

 // This constructor will take a product ID and display that product's information
 // This form will show edit buttons
 public frmProducts(String EditingItemID, Business business)
 {
     this.business = business;
     this.EditingItemID = EditingItemID;
     InitializeComponent();
     this.Text = "Editing: PorductID " + EditingItemID;
 }

 public ClientBillingFacility(Facility performaingFacility, Facility defaultBillingFacility, Business.Client.Model.ClientGroupClientCollection clientGroupClientCollection, string facilityComponent)
 {
     this.m_PerformingFacility = performaingFacility;
     this.m_DefaultBillingFacility = defaultBillingFacility;
     this.m_ClientGroupClientCollection = clientGroupClientCollection;
     this.m_FacilityComponent = facilityComponent;
 }

        public override bool IsRequired(Business.Test.AccessionOrder accessionOrder)
        {
            bool result = false;

            YellowstonePathology.Business.Test.HPV.HPVTest panelSetHPV = new YellowstonePathology.Business.Test.HPV.HPVTest();
               YellowstonePathology.Business.Test.HPV1618.HPV1618Test panelSetHPV1618 = new YellowstonePathology.Business.Test.HPV1618.HPV1618Test();
            YellowstonePathology.Business.Test.ThinPrepPap.ThinPrepPapTest panelSetThinPrepPap = new YellowstonePathology.Business.Test.ThinPrepPap.ThinPrepPapTest();

            if(accessionOrder.PanelSetOrderCollection.Exists(panelSetThinPrepPap.PanelSetId) == true)
            {
                YellowstonePathology.Business.Test.ThinPrepPap.PanelSetOrderCytology panelsetOrderCytology = (YellowstonePathology.Business.Test.ThinPrepPap.PanelSetOrderCytology)accessionOrder.PanelSetOrderCollection.GetPanelSetOrder(panelSetThinPrepPap.PanelSetId);
                if (panelsetOrderCytology.Final == true)
                {
                    string papResultCode = panelsetOrderCytology.ResultCode;
                    if (YellowstonePathology.Business.Cytology.Model.CytologyResultCode.IsResultCodeNormal(papResultCode) == true || YellowstonePathology.Business.Cytology.Model.CytologyResultCode.IsResultCodeReactive(papResultCode) == true)
                    {
                        if (accessionOrder.PanelSetOrderCollection.Exists(panelSetHPV.PanelSetId) == true)
                        {
                            YellowstonePathology.Business.Test.HPV.HPVTestOrder hpvTestOrder = (YellowstonePathology.Business.Test.HPV.HPVTestOrder)accessionOrder.PanelSetOrderCollection.GetPanelSetOrder(panelSetHPV.PanelSetId);
                            if (hpvTestOrder.ResultCode == YellowstonePathology.Business.Test.HPV.HPVResult.OveralResultCodePositive)
                            {
                                result = true;
                            }
                        }
                    }
                }
            }

            return result;
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="objSymbol"></param>
        /// <param name="SymbolID"></param>
        /// <returns></returns>
        public string SelectSymbolByIDReferenceInSymbolList(Business.Symbol objSymbol, int SymbolID)
        {
            string result = string.Empty;
            if (objSymbol != null)
            {
                int count = objSymbol.RefSymbol.Count;
                for (int i = 0; i < count; i++)
                {
                    if (objSymbol.RefSymbol[i].SymbolID == SymbolID)
                    {
                        result = objSymbol.RefSymbol[i].SymbolID.ToString() + "," + objSymbol.RefSymbol[i].SecurityID.ToString() + "," + objSymbol.SymbolID.ToString() + "," +
                                    objSymbol.RefSymbol[i].MarketAreaRef.IMarketAreaID.ToString() + "," + objSymbol.RefSymbol[i].Name;

                        break;
                    }

                    if (objSymbol.RefSymbol[i].RefSymbol != null)
                    {
                        result += this.SelectSymbolByIDReferenceInSymbolList(objSymbol.RefSymbol[i], SymbolID);
                    }
                }
            }

            return result;
        }

        /// <summary>
        /// Permanently delete the profile records associated with the specified <paramref name="gallery" />.
        /// </summary>
        /// <param name="gallery">The gallery.</param>
        /// <exception cref="ArgumentNullException">Thrown when <paramref name="gallery" /> is null.</exception>
        public static void DeleteProfileForGallery(Business.Gallery gallery)
        {
            if (gallery == null)
                throw new ArgumentNullException("gallery");

            Factory.GetDataProvider().Profile_DeleteProfilesForGallery(gallery.GalleryId);
        }

        public override bool IsRequired(Business.Test.AccessionOrder accessionOrder)
        {
            bool result = false;
            YellowstonePathology.Business.Test.ThinPrepPap.ThinPrepPapTest panelSetThinPrep = new YellowstonePathology.Business.Test.ThinPrepPap.ThinPrepPapTest();
            if (accessionOrder.PanelSetOrderCollection.Exists(panelSetThinPrep.PanelSetId) == true)
            {
                YellowstonePathology.Business.Test.ThinPrepPap.PanelSetOrderCytology panelSetOrderCytology = (YellowstonePathology.Business.Test.ThinPrepPap.PanelSetOrderCytology)accessionOrder.PanelSetOrderCollection.GetPanelSetOrder(panelSetThinPrep.PanelSetId);
                if (panelSetOrderCytology.Final == true)
                {
                    if (YellowstonePathology.Business.Cytology.Model.CytologyResultCode.IsResultCodeNormal(panelSetOrderCytology.ResultCode) == true ||
                        YellowstonePathology.Business.Cytology.Model.CytologyResultCode.IsResultCodeReactive(panelSetOrderCytology.ResultCode) == true)
                    {
                        if (YellowstonePathology.Business.Cytology.Model.CytologyResultCode.IsResultCodeTZoneAbsent(panelSetOrderCytology.ResultCode) == true)
                        {
                            if (accessionOrder.PBirthdate < DateTime.Today.AddYears(-30))
                            {
                                result = true;
                            }
                        }
                    }
                }
            }

            return result;
        }

        public void Add(Business.Entity.Modulo Modulo)
        {
            using (AcademiaEntities context = new AcademiaEntities())
            {
                if(!validateDesc (Modulo.Descripcion))
                {
                    throw new Exception();
                }
                modulo oMod ;
                try
                {
                    oMod = new modulo();
                    oMod.desc_modulo = Modulo.Descripcion;

                    context.modulos.Add(oMod);
                    context.SaveChanges();

                }
                catch (Exception ex)
                {
                    throw ex;
                }
                finally
                {
                    oMod = null;
                }
            }
        }

 public static IResultView GetResultView(string reportNo, Business.Test.AccessionOrder accessionOrder, int clientId, bool testing)
 {
     IResultView resultView = null;
     switch (clientId)
     {
         case 558:
         case 820:
         case 723:
         case 33:
         case 1417:
         case 650:
         case 1421:
         case 649:
         case 230:
         case 123:
         case 126:
         case 242:
         case 253:
         case 1313:
         case 1096:
         case 287:
         case 968:
         case 250:
         case 57:
         case 313:
         case 1025:
         case 1321:
         case 25:
         case 90:
         case 505:
         case 154:
         case 184:
         case 969:
         case 1422:
         case 1456:
         case 1279:
         case 67:
         case 673:
         case 149:
         case 1119:
             resultView = new Business.HL7View.EPIC.EpicResultView(reportNo, accessionOrder, testing);
             break;
         case 203: //Richard Taylor
         case 1177: //Spring Creek
         case 196: //Central Montana
         case 209: //Laura Bennett
         case 954: // Barb Miller
         case 1471: //Marchion
         //case 219:
             resultView = new HL7View.CMMC.CMMCResultView(reportNo, accessionOrder);
             break;
         case 1337:
             resultView = new HL7View.CDC.MTDohResultView(reportNo, accessionOrder);
             break;
         case 1203:
             resultView = new HL7View.ECW.ECWResultView(reportNo, accessionOrder, testing);
             break;
     }
     return resultView;
 }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="objVirtualDealer"></param>
        /// <returns></returns>
        internal string AddNewVirtualDealer(Business.VirtualDealer objVirtualDealer)
        {
            string result = "-1";
            System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
            System.Data.SqlClient.SqlTransaction trans = null;
            DSTableAdapters.VirtualDealerTableAdapter virtualDealerAdap = new DSTableAdapters.VirtualDealerTableAdapter();
            DSTableAdapters.VirtualDealerConfigTableAdapter dealerConfigAdap = new DSTableAdapters.VirtualDealerConfigTableAdapter();
            DSTableAdapters.IVirtualDealerTableAdapter iVirtualDealerAdap = new DSTableAdapters.IVirtualDealerTableAdapter();
            try
            {
                conn.Open();
                trans = conn.BeginTransaction();

                virtualDealerAdap.Connection = conn;
                virtualDealerAdap.Transaction = trans;
                int id = int.Parse(virtualDealerAdap.AddNewVirtualDealer(objVirtualDealer.Name, "").ToString());
                result = id.ToString();
                if (id == -1)
                {
                    throw new Exception("Data error");
                }

                dealerConfigAdap.Connection = conn;
                dealerConfigAdap.Transaction = trans;
                DateTime DateValue = DateTime.Parse("1753-01-01 00:00:00.000");
                dealerConfigAdap.Insert(null, "Profit max pip", id, "VD01", -1, "NaN", objVirtualDealer.ProfitMaxPip.ToString(), DateValue);
                dealerConfigAdap.Insert(null, "Loss max pip", id, "VD02", -1, "NaN", objVirtualDealer.LossMaxPip.ToString(), DateValue);
                dealerConfigAdap.Insert(null, "Min volume", id, "VD03", -1, "NaN", objVirtualDealer.StartVolume.ToString(), DateValue);
                dealerConfigAdap.Insert(null, "Max volume", id, "VD04", -1, "NaN", objVirtualDealer.EndVolume.ToString(), DateValue);
                dealerConfigAdap.Insert(null, "Delay", id, "VD05", -1, "NaN", objVirtualDealer.Delay.ToString(), DateValue);
                dealerConfigAdap.Insert(null, "Additional pip", id, "VD06", -1, "NaN", objVirtualDealer.AdditionalPip.ToString(), DateValue);
                dealerConfigAdap.Insert(null, "Mode", id, "VD07", -1, "NaN", objVirtualDealer.Mode.ToString(), DateValue);
                dealerConfigAdap.Insert(null, "IsEnable", id, "VD08", objVirtualDealer.IsEnable ? 1 : 0, "NaN", "NaN", DateValue);
                dealerConfigAdap.Insert(null, "IsLimitAuto", id, "VD09", objVirtualDealer.IsLimitAuto ? 1 : 0, "NaN", "NaN", DateValue);
                dealerConfigAdap.Insert(null, "IsStopAuto", id, "VD10", objVirtualDealer.IsStopAuto ? 1 : 0, "NaN", "NaN", DateValue);
                dealerConfigAdap.Insert(null, "IsStopSlippage", id, "VD11", objVirtualDealer.IsStopSlippage ? 1 : 0, "NaN", "NaN", DateValue);
                dealerConfigAdap.Insert(null, "GroupCondition", id, "VD12", -1, objVirtualDealer.GroupCondition, "NaN", DateValue);
                dealerConfigAdap.Insert(null, "SymbolCodition", id, "VD13", -1, objVirtualDealer.SymbolCondition, "NaN", DateValue);
                iVirtualDealerAdap.Connection = conn;
                iVirtualDealerAdap.Transaction = trans;
                for (int i = 0; i < objVirtualDealer.IVirtualDealer.Count; i++)
                {
                    iVirtualDealerAdap.Insert(objVirtualDealer.IVirtualDealer[i].InvestorGroupID, objVirtualDealer.IVirtualDealer[i].SymbolID, id);
                }
                trans.Commit();
            }
            catch (Exception ex)
            {
                trans.Rollback();
                return "Data error";
            }
            finally
            {
                virtualDealerAdap.Connection.Close();
                dealerConfigAdap.Connection.Close();
                iVirtualDealerAdap.Connection.Close();
                conn.Close();
            }
            return result;
        }

        public static void AddGallery(Business.Gallery gallery)
        {
            if (gallery == null)
                throw new ArgumentNullException("gallery");

            gallery.Save();
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="objInvestorProfile"></param>
        /// <returns></returns>
        internal int AddNewInvestor(Business.Investor objInvestor)
        {
            int Result = -1;
            System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
            DSTableAdapters.InvestorTableAdapter adap = new DSTableAdapters.InvestorTableAdapter();
            DSTableAdapters.InvestorProfileTableAdapter adapInvestorProfile = new DSTableAdapters.InvestorProfileTableAdapter();

            try
            {
                conn.Open();
                adap.Connection = conn;
                adapInvestorProfile.Connection = conn;

                //string hashPwd = TradingServer.Model.ValidateCheck.GetEncodedString(objInvestor.PrimaryPwd);
                //string hashPwd = TradingServer.Model.ValidateCheck.Encrypt(objInvestor.PrimaryPwd);
                //string hashReadPwd = TradingServer.Model.ValidateCheck.GetEncodedString(objInvestor.ReadOnlyPwd);
                //string hashReadPwd = TradingServer.Model.ValidateCheck.Encrypt(objInvestor.ReadOnlyPwd);
                //string hashPhonePwd = TradingServer.Model.ValidateCheck.GetEncodedString(objInvestor.PhonePwd);
                //string hashPhonePwd = TradingServer.Model.ValidateCheck.Encrypt(objInvestor.PhonePwd);

                if ((objInvestor.InvestorStatusID == -1) && (objInvestor.InvestorGroupInstance.InvestorGroupID == -1) && (string.IsNullOrEmpty(objInvestor.AgentID)))
                {
                    Result = int.Parse(adap.AddNewInvestor(null, null, objInvestor.Balance, objInvestor.Credit, objInvestor.Code, objInvestor.PrimaryPwd, objInvestor.ReadOnlyPwd, objInvestor.PhonePwd,
                        true, objInvestor.TaxRate, objInvestor.Leverage, objInvestor.AllowChangePwd, objInvestor.ReadOnly, objInvestor.SendReport, "0", 0, "", objInvestor.RefInvestorID,
                        objInvestor.AgentRefID, "", "").ToString());
                }
                else
                {
                    int? resultFind = 0;
                    resultFind = adap.FindAgentWithAgentID(objInvestor.AgentID);
                    if (resultFind > 0)
                    {
                        Result = int.Parse(adap.AddNewInvestor(objInvestor.InvestorStatusID, objInvestor.InvestorGroupInstance.InvestorGroupID, objInvestor.Balance,
                            objInvestor.Credit, objInvestor.Code, objInvestor.PrimaryPwd, objInvestor.ReadOnlyPwd, objInvestor.PhonePwd, objInvestor.IsDisable, objInvestor.TaxRate, objInvestor.Leverage,
                            objInvestor.AllowChangePwd, objInvestor.ReadOnly, objInvestor.SendReport, objInvestor.AgentID, 0, "", objInvestor.RefInvestorID, objInvestor.AgentRefID, "", "").ToString());
                    }
                    else
                    {
                        Result = int.Parse(adap.AddNewInvestor(objInvestor.InvestorStatusID, objInvestor.InvestorGroupInstance.InvestorGroupID, objInvestor.Balance,
                            objInvestor.Credit, objInvestor.Code, objInvestor.PrimaryPwd, objInvestor.ReadOnlyPwd, objInvestor.PhonePwd, objInvestor.IsDisable, objInvestor.TaxRate, objInvestor.Leverage,
                            objInvestor.AllowChangePwd, objInvestor.ReadOnly, objInvestor.SendReport, "0", 0, "", objInvestor.RefInvestorID, objInvestor.AgentRefID, "", "").ToString());
                    }
                }

                //int.Parse(adapInvestorProfile.AddNewInvestorProfile(Result, objInvestor.Address, objInvestor.Phone, objInvestor.City, objInvestor.Country, objInvestor.Email,
                //                        objInvestor.ZipCode, objInvestor.RegisterDay, objInvestor.Comment, objInvestor.State, objInvestor.NickName).ToString());

            }
            catch (Exception ex)
            {
                return Result;
            }
            finally
            {
                adap.Connection.Close();
                conn.Close();
            }

            return Result;
        }

 public void SetBusiness(Business bus)
 {
     myBusiness = bus;
     adName.text = bus.name;
     adDesc.text = bus.desc;
     adLogo.mainTexture = bus.logo;
 }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="objInvestor"></param>
        /// <returns></returns>
        internal int AddNewInvestorProfile(Business.Investor objInvestor)
        {
            int Result = -1;
            System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
            DSTableAdapters.InvestorProfileTableAdapter adap = new DSTableAdapters.InvestorProfileTableAdapter();

            try
            {
                conn.Open();
                adap.Connection = conn;
                Result = int.Parse(adap.AddNewInvestorProfile(objInvestor.InvestorID, objInvestor.Address, objInvestor.Phone, objInvestor.City,
                                            objInvestor.Country, objInvestor.Email, objInvestor.ZipCode, objInvestor.RegisterDay,
                                            objInvestor.InvestorComment, objInvestor.State, objInvestor.NickName, objInvestor.IDPassport).ToString());
            }
            catch (Exception ex)
            {
                return -1;
            }
            finally
            {
                adap.Connection.Close();
                conn.Close();
            }

            return Result;
        }

        public void createURLNotification(string url, 
Business.AppointmentVO appVO)
        {
            string subject = "";
            if(appVO._Id != null)
                subject = appVO._Subject;
            notificationURL = url;
            _notification = new Notification();
            _notification.Caption = "News: ";
            _notification.Critical = false;
            //
            StringBuilder HTMLString = new StringBuilder();
            HTMLString.Append("<html><body>");
            HTMLString.Append("<font color=\"#0000FF\">Information); availiable for:</font><br>");
            HTMLString.Append("<font color=\"#0000FF\"><b>Appointment: " + subject + "</b></font><br/>");
            HTMLString.Append("<form method=\"GET\" action=notify>");
            HTMLString.Append("<br/><input type=button name='show' value='Show info'>");
            HTMLString.Append("<input type=button name='cancel' value='Cancel'/>");
            HTMLString.Append("</body></html>");
            _notification.Text = HTMLString.ToString();
            //
            _notification.BalloonChanged += new
            BalloonChangedEventHandler(_notification_BalloonChanged);
            _notification.ResponseSubmitted += new
            ResponseSubmittedEventHandler(_notification_ResponseSubmitted);
            _notification.InitialDuration = 20;
            _notification.Visible = true;
        }

        private void AddProjectToCroolProject(Business.Entities.CroolProject croolProject, Project p)
        {
            string projectName = string.IsNullOrEmpty(p.FullName) ? p.Name : p.FullName;

            if (!string.IsNullOrEmpty(projectName))
            {
                int lastSlash = projectName.LastIndexOf('\\');
                lastSlash = lastSlash == -1 ? 0 : lastSlash;
                string pathToProject = projectName;

                if (lastSlash != 0)
                {
                    pathToProject = projectName.Substring(0, lastSlash);
                }

                var project = new Business.Entities.Project
                {
                    Name = p.UniqueName
                };

                croolProject.Projects.Add(project);

                this.LoadProjectFiles(croolProject, p.ProjectItems, project, pathToProject);
            }
        }