public static bool setPersonData(PersonDataDTO model)
{
try
{
using (var cmd = connection.CreateCommand())
{
//UPDATE table_name
//SET column1 = value1, column2 = value2, ...
//WHERE id = 0;
var hash = model.Hastighed.ToString().Replace(",", ".");
var crack = model.Acceleration.ToString().Replace(",", ".");
cmd.CommandText = $@"insert into PersonData
(Hastighed, Acceleration, Tid, FK_Person) VALUES
({hash}, {crack},'{model.Tid}', {model.FK_Person})";
cmd.ExecuteNonQuery();
}
return(true);
}
catch (Exception e)
{
return(false);
}
}
public static bool setPersonData(PersonDataDTO model)
{
try
{
using (var cmd = connection.CreateCommand())
{
var hastighedCalculator = model.Hastighed.ToString().Replace(",", ".");
var AccelCalculator = model.Acceleration.ToString().Replace(",", ".");
cmd.CommandText = $@"insert into PersonData
(Hastighed, Acceleration, Tid, FK_Email) VALUES
({hastighedCalculator}, {AccelCalculator},'{model.Tid}', '{model.FK_Email}')";
cmd.ExecuteNonQuery();
}
return(true);
}
catch (Exception e)
{
return(false);
}
}
