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