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; }