public GetEndpointSettings LoadDB() //public GetEndpointSettings LoadDBMultiRow() { GetEndpointSettings ret = null; try { Sqlconn.Open(); string sqlquery; sqlquery = string.Format(@"SELECT * FROM [Settings]"); using (SqlCommand comm = new SqlCommand(sqlquery, Sqlconn)) { IDataReader resAdd = comm.ExecuteReader(); if (resAdd.Read()) { ret = (GetEndpointSettings) new JavaScriptSerializer().Deserialize(resAdd.GetString(resAdd.GetOrdinal("Setting")), typeof(GetEndpointSettings)); } } } catch (Exception ex) { Logger.Warn(ex.Message, ex); throw new Exception(string.Format(ErrorOccuredMess, ex.Message)); } finally { Sqlconn.Close(); } return(ret); }
public GetEndpointSettings Load() { GetEndpointSettings ret = null; if (Sqlconn != null) { //ret = LoadDB(); ret = LoadWS(); } else { ret = LoadFile(); } return(ret); }
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 ActionResult UpdOpt() { try { GetEndpointSettings PostDataArrived = CS.GetPostData <GetEndpointSettings>(this.Request); if (connectionStringSetting == null || string.IsNullOrEmpty(connectionStringSetting.ConnectionString)) { throw new Exception("ConnectionString not set"); } SettingsWidget qw = new SettingsWidget(connectionStringSetting.ConnectionString); return(CS.ReturnForJQuery(qw.UpdateSettingsOPT(PostDataArrived) ? JSONConst.Success : JSONConst.Error)); } catch (Exception ex) { return(CS.ReturnForJQuery(JSONConst.Error)); } }
public bool UpdateSettingsOPT(GetEndpointSettings PostDataArrived) { bool success = false; try { if (PostDataArrived == null) { throw new Exception("Input Error"); } Sqlconn.Open(); string sqlquery; sqlquery = string.Format(@"UPDATE [SettingsOPT] SET [View_tree]='{0}', [View_tree_req]='{1}',[View_tree_select]='{2}',[View_login]={3} WHERE [IdOPT]=1", PostDataArrived.settings.view_tree?1:0, PostDataArrived.settings.view_tree_req?1:0, PostDataArrived.settings.view_tree_select?1:0, PostDataArrived.settings.view_login?1:0 ); using (SqlCommand comm = new SqlCommand(sqlquery, Sqlconn)) { int resAdd = comm.ExecuteNonQuery(); if (resAdd == 0) { success = false; throw new Exception("Setting not update"); } } success = true; } catch (Exception ex) { Logger.Warn(ex.Message, ex); throw new Exception(string.Format(ErrorOccuredMess, ex.Message)); } finally { Sqlconn.Close(); } return(success); }
public bool SaveWS(GetEndpointSettings PostDataArrived) { bool success = false; try { if (PostDataArrived == null) { throw new Exception("Input Error"); } Sqlconn.Open(); foreach (EndpointSettings endpointSetting in PostDataArrived.endpoints) { string sqlquery; sqlquery = string.Format(@"UPDATE SettingsWS SET [Ordering]='{0}', [Active]='{1}' WHERE [SettingId]='{2}'", endpointSetting.Ordinamento, (endpointSetting.Active)?1:0, endpointSetting.SettingID); using (SqlCommand comm = new SqlCommand(sqlquery, Sqlconn)) { int resAdd = comm.ExecuteNonQuery(); if (resAdd == 0) { success = false; throw new Exception("Setting not update"); } } } success = true; } catch (Exception ex) { Logger.Warn(ex.Message, ex); throw new Exception(string.Format(ErrorOccuredMess, ex.Message)); } finally { Sqlconn.Close(); } return(success); }
public bool Save(GetEndpointSettings PostDataArrived) { bool success = false; try { if (PostDataArrived == null) { throw new Exception("Input Error"); } Sqlconn.Open(); string sqlquery; 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); }
public GetEndpointSettings LoadWS() { 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 = true; EndpointSettings endpointSetting = new EndpointSettings(); ret.endpoints = new List <EndpointSettings>(); try { Sqlconn.Open(); string sqlquery = string.Format(@"SELECT * FROM [SettingsOPT]"); using (SqlCommand comm = new SqlCommand(sqlquery, Sqlconn)) { IDataReader resAdd = comm.ExecuteReader(); if (resAdd.Read()) { ret.settings.view_tree = (resAdd["view_tree"].ToString() == "True") ? true : false; ret.settings.view_tree_req = (resAdd["view_tree_req"].ToString() == "True") ? true : false; ret.settings.view_tree_select = (resAdd["view_tree_select"].ToString() == "True") ? true : false; ret.settings.view_login = (resAdd["view_login"].ToString() == "True") ? true : false; } resAdd.Close(); } sqlquery = string.Format(@"SELECT * FROM [SettingsWS] ORDER BY [Ordering],[SettingId]"); DataTable dtres = new DataTable(); using (SqlCommand comm = new SqlCommand(sqlquery, Sqlconn)) { using (SqlDataAdapter da = new SqlDataAdapter(comm)) { da.Fill(dtres); } } foreach (DataRow query in dtres.Rows) { endpointSetting = new EndpointSettings(); endpointSetting.Locale = query["Locale"].ToString(); endpointSetting.IDNode = query["IDNode"].ToString(); endpointSetting.Title = query["Title"].ToString(); endpointSetting.DecimalSeparator = query["DecimalSeparator"].ToString(); endpointSetting.Domain = query["Domain"].ToString(); endpointSetting.EnableHTTPAuthentication = (query["EnableHTTPAuthentication"].ToString() == "True") ? true : false; endpointSetting.EnableProxy = (query["EnableProxy"].ToString() == "True") ? true : false; endpointSetting.EndPoint = query["EndPoint"].ToString(); endpointSetting.EndPointV20 = query["EndPointV20"].ToString(); endpointSetting.EndPointType = query["EndPointType"].ToString(); endpointSetting.EndPointSource = query["EndPointSource"].ToString(); endpointSetting.Password = query["Password"].ToString(); endpointSetting.Prefix = query["Prefix"].ToString(); endpointSetting.ProxyPassword = query["ProxyPassword"].ToString(); endpointSetting.ProxyServer = query["ProxyServer"].ToString(); endpointSetting.ProxyServerPort = Convert.ToInt32(query["ProxyServerPort"].ToString()); endpointSetting.ProxyUserName = query["ProxyUserName"].ToString(); endpointSetting.UseSystemProxy = (query["UseSystemProxy"].ToString() == "True") ? true : false; endpointSetting.UserName = query["UserName"].ToString(); endpointSetting.Wsdl = query["Wsdl"].ToString(); endpointSetting.Active = (query["Active"].ToString() == "True") ? true : false; endpointSetting.UseUncategorysed = (query["UseUncategorysed"].ToString() == "1") ? true : false; endpointSetting.UseVirtualDf = (query["UseVirtualDf"].ToString() == "1") ? true : false; endpointSetting.Ordinamento = Convert.ToInt32(query["Ordering"].ToString()); endpointSetting.SettingID = Convert.ToInt32(query["SettingID"].ToString()); //ret.endpoints.Add(new EndpointSettings(endpointSetting)); ret.endpoints.Add(endpointSetting); } } catch (Exception ex) { Logger.Warn(ex.Message, ex); throw new Exception(string.Format(ErrorOccuredMess, ex.Message)); } finally { Sqlconn.Close(); } return(ret); }