public string GetGridModel(string query, int idCurrentProject) { ConnectionDB connect; if (User.Identity.IsAuthenticated) { var connectionsCurrentProject = _serviceConnection.GetConnectionDBs(idCurrentProject); connect = connectionsCurrentProject.FirstOrDefault(); } else { connect = new ConnectionDB { DatabaseName = DefaultDatabaseConstants.DatabaseName, LoginDB = DefaultDatabaseConstants.Login, ServerName = DefaultDatabaseConstants.ServerName, PasswordDB = Rijndael.EncryptStringToBytes(DefaultDatabaseConstants.Password) }; } var dataTable = new DataTable(); if (connect != null) { var connectionString = $"Data source= {connect.ServerName};Initial catalog= {connect.DatabaseName}; UID= {connect.LoginDB}; Password= {Rijndael.DecryptStringFromBytes(connect.PasswordDB)};"; var resultQuery = SqlExecuteData.SqlReturnDataFromQuery(query, connectionString); if (!resultQuery.HasError) { dataTable = resultQuery.ResultData; } else { return(JsonConvert.SerializeObject(resultQuery.ErrorText)); } } Session["datatableForGrid"] = dataTable; var header = (from DataColumn column in dataTable.Columns select new DataGridModel { Name = column.ColumnName, Index = column.ColumnName, Sortable = true, Align = "center" }).ToList(); if (User.Identity.IsAuthenticated) { _queryHistoryModel.QueryDate = DateTime.Now; _queryHistoryModel.QueryBody = query; _queryHistoryModel.ProjectID = idCurrentProject; var newQuery = Mapper.Map <QueryHistoryViewModel, QueryHistory>(_queryHistoryModel); _serviceQueryHistory.SaveQueryHistory(newQuery); } return(JsonConvert.SerializeObject(header)); }
private void ClickMethodRunQuerryCommand() { ResultTable = SqlExecuteData.SqlReturnDataFromQuery(SqlQuerry, MainWindowData.StringConnect).ResultData; OnPropertyChanged("ResultTable"); }