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