public bool SetEmailConfirmed(string username, bool confirmed) { try { try { SqlExecutionInstance.ExecuteNonQuery(new SqlCommand("SetUserEmailConfirmed") { CommandType = System.Data.CommandType.StoredProcedure }, new SqlParameter[] { new SqlParameter("email_confirmed", confirmed), new SqlParameter("username", username) }, new SqlConnection(this.connectionString)); } catch (Exception exception) { CoreContainers.LogsRepository.LogError(exception, Core.Database.Logs.LogTrigger.DataAccess); return(false); } return(true); } catch (Exception exception) { CoreContainers.LogsRepository.LogError(exception, Core.Database.Logs.LogTrigger.DataAccess); return(false); } }
public bool UpdateDatasetRepresentationLimits(string datasetName, string username, decimal?minimumHeight, decimal?maximumHeight, decimal?minimumDeformationRate, decimal?maximumDeformationRate, decimal?minimumStdDev, decimal?maximumStdDev) { try { SqlExecutionInstance.ExecuteNonQuery(new SqlCommand("UpdatePointsDatasetLimits") { CommandType = System.Data.CommandType.StoredProcedure }, new SqlParameter[] { new SqlParameter("datasetName", datasetName), new SqlParameter("username", username), new SqlParameter("minimum_height", minimumHeight), new SqlParameter("minimum_def_rate", minimumDeformationRate), new SqlParameter("minimum_std_dev", minimumStdDev), new SqlParameter("maximum_height", maximumHeight), new SqlParameter("maximum_def_rate", maximumDeformationRate), new SqlParameter("maximum_std_dev", maximumStdDev) }, new SqlConnection(this.connectionString)); } catch (Exception exception) { return(false); } return(true); }
private void log(string message, string stacktrace, LogTrigger logTrigger, LogType logType) { try { var query = new Query(logTable) .AsInsert(new { stacktrace, message, log_type = logType.ToString(), log_trigger = logTrigger.ToString(), creation_date = DateTime.Now, }); SqlResult queryResult = new SqlServerCompiler().Compile(query); SqlExecutionInstance.ExecuteNonQuery(new SqlCommand(queryResult.Sql), new SqlParameter[] { new SqlParameter("p0", queryResult.Bindings[0]), new SqlParameter("p1", queryResult.Bindings[1]), new SqlParameter("p2", queryResult.Bindings[2]), new SqlParameter("p3", queryResult.Bindings[3]), new SqlParameter("p4", queryResult.Bindings[4]) }, new SqlConnection(this.connectionString)); } catch { } }
public bool RemovePointsDatasetFromUser(string datasetName, string datasetUser, string username) { try { SqlExecutionInstance.ExecuteNonQuery(new SqlCommand("RemoveDatapointsFromUser") { CommandType = System.Data.CommandType.StoredProcedure }, new SqlParameter[] { new SqlParameter("dataset_name", datasetName), new SqlParameter("dataset_user", datasetUser), new SqlParameter("username", username), }, new SqlConnection(this.connectionString)); } catch (Exception exception) { CoreContainers.LogsRepository.LogError(exception, Core.Database.Logs.LogTrigger.DataAccess); return(false); } return(true); }
public bool UpdateDatasetStatus(string datasetName, DatasetStatus status, string username) { try { SqlExecutionInstance.ExecuteNonQuery(new SqlCommand("UpdatePointsDatasetStatus") { CommandType = System.Data.CommandType.StoredProcedure }, new SqlParameter[] { new SqlParameter("datasetName", datasetName), new SqlParameter("statusId", (int)status), new SqlParameter("username", username) }, new SqlConnection(this.connectionString)); } catch (Exception exception) { CoreContainers.LogsRepository.LogError(exception, Core.Database.Logs.LogTrigger.DataAccess); return(false); } return(true); }
public bool CreateColorMap(string username, ColorMap colorMap) { try { SqlExecutionInstance.ExecuteNonQuery(new SqlCommand("InsertColorPalette") { CommandType = System.Data.CommandType.StoredProcedure }, new SqlParameter[] { new SqlParameter("username", username), new SqlParameter("palette_name", colorMap.Name), new SqlParameter("palette_serialization", colorMap.Intervals.JSONSerialize()), new SqlParameter("main_color_critera", colorMap.MainColorCriteria) }, new SqlConnection(this.connectionString)); } catch (Exception exception) { CoreContainers.LogsRepository.LogError(exception, Core.Database.Logs.LogTrigger.DataAccess); return(false); } return(true); }
public bool UpdateDatasetLimits(string datasetName, string username, decimal?minimumLatitude, decimal?minimumLongitude, decimal?maximumLatitude, decimal?maximumLongitude) { try { SqlExecutionInstance.ExecuteNonQuery(new SqlCommand("UpdatePointsDatasetLimits") { CommandType = System.Data.CommandType.StoredProcedure }, new SqlParameter[] { new SqlParameter("datasetName", datasetName), new SqlParameter("username", username), new SqlParameter("minimum_latitude", minimumLatitude), new SqlParameter("minimum_longitude", minimumLongitude), new SqlParameter("maximum_latitude", maximumLatitude), new SqlParameter("maximum_longitude", maximumLongitude) }, new SqlConnection(this.connectionString)); } catch (Exception exception) { return(false); } return(true); }
public bool UpdateUser(User user) { try { SqlExecutionInstance.ExecuteNonQuery(new SqlCommand("UpdateUser") { CommandType = System.Data.CommandType.StoredProcedure }, new SqlParameter[] { new SqlParameter("username", user.Username), new SqlParameter("first_name", user.FirstName), new SqlParameter("last_name", user.LastName), new SqlParameter("secure_stamp", user.SecurityStamp), new SqlParameter("email", user.Email) }, new SqlConnection(this.connectionString)); } catch (Exception exception) { CoreContainers.LogsRepository.LogError(exception, Core.Database.Logs.LogTrigger.DataAccess); return(false); } return(true); }