public GetEndpointSettings LoadFile()
        {
            GetEndpointSettings ret = new GetEndpointSettings();
            ret.settings = new Settings();
            ret.settings.view_tree = true;
            ret.settings.view_tree_req = true;
            ret.settings.view_tree_select = true;
            ret.settings.view_login = false;

            EndpointSettings endpointSetting = new EndpointSettings();
            ret.endpoints = new List<EndpointSettings>();
            foreach (EndPointElement endPointEl in IRConfiguration.Config.EndPoints)
            {
                endpointSetting = new EndpointSettings();
                endpointSetting.Locale = endPointEl.Locale;
                endpointSetting.IDNode = endPointEl.IDNode;
                endpointSetting.Title = endPointEl.Title;
                endpointSetting.DecimalSeparator = endPointEl.DecimalSeparator;
                endpointSetting.Domain = endPointEl.Domain;
                endpointSetting.EnableHTTPAuthentication = endPointEl.EnableHTTPAuthentication;
                endpointSetting.EnableProxy = endPointEl.EnableProxy;
                endpointSetting.EndPoint = endPointEl.EndPoint;
                endpointSetting.EndPointV20 = endPointEl.EndPointV20;
                endpointSetting.EndPointType = endPointEl.EndPointType;
                endpointSetting.EndPointSource = endPointEl.EndPointSource;
                endpointSetting.Password = endPointEl.Password;
                endpointSetting.Prefix = endPointEl.Prefix;
                endpointSetting.ProxyPassword = endPointEl.ProxyPassword;
                endpointSetting.ProxyServer = endPointEl.ProxyServer;
                endpointSetting.ProxyServerPort = endPointEl.ProxyServerPort;
                endpointSetting.ProxyUserName = endPointEl.ProxyUserName;
                endpointSetting.UseSystemProxy = endPointEl.UseSystemProxy;
                endpointSetting.UserName = endPointEl.UserName;
                endpointSetting.Wsdl = endPointEl.Wsdl;
                endpointSetting.Active = endPointEl.Active;
                endpointSetting.UseUncategorysed = endPointEl.UseUncategorysed;
                endpointSetting.UseVirtualDf = endPointEl.UseVirtualDf;
                endpointSetting.Ordinamento = endPointEl.Ordinamento;
                //endpointSetting._TypeEndpoint = endPointEl._TypeEndpoint;
                //ret.endpoints.Add(new EndpointSettings(endpointSetting));
                ret.endpoints.Add(endpointSetting);
            }

            return ret;
        }
        public bool Save(GetEndpointSettings PostDataArrived)
        {
            bool success = false;
            try
            {
                if (PostDataArrived == null) throw new Exception("Input Error");

                Sqlconn.Open();

                string sqlquery;

                sqlquery = string.Format(@"DELETE FROM [Settings]");
                using (SqlCommand comm = new SqlCommand(sqlquery, Sqlconn))
                {
                    int resAdd = comm.ExecuteNonQuery();

                }

                sqlquery = string.Format(@"INSERT INTO [Settings] ([Setting]) VALUES('{0}')",new JavaScriptSerializer().Serialize(PostDataArrived).Replace("'", "''"));
                using (SqlCommand comm = new SqlCommand(sqlquery, Sqlconn))
                {
                    int resAdd = comm.ExecuteNonQuery();
                    if (resAdd == 0)
                    {
                        success = false;
                        throw new Exception("Setting not insert");
                    }
                }

                success=true;
            }
            catch (Exception ex)
            {
                Logger.Warn(ex.Message, ex);
                throw new Exception(string.Format(ErrorOccuredMess, ex.Message));
            }
            finally
            {
                Sqlconn.Close();
            }
            return success;
        }