/// <summary>
/// Aktualisieren der neuen Werte für einen Benutzer
/// </summary>
/// <param name="user">zu aktualisierender Benutzer</param>
/// <returns></returns>
internal bool Update(User user)
{
string com = $"UPDATE User_Info SET " +
$"GeaendertAm = '{DateTime.Now:yyyy-MM-dd HH:mm:ss}', " +
$"Infotext = '{user.InfoText}'," +
$"OnlyCustomName = '{StaticDB.ConvertBoolToByte(user.OnlyCustomName)}'," +
$"CustomName = '{user.CustomName}' " +
$"WHERE Nutzername = '{user.Nutzername}';";
bool result = StaticDB.RunSQL(com);
if (result == false)
{
return(result);
}
try
{
com = $"UPDATE User_Bild SET " +
$"Bild = @bild " +
$"WHERE Nutzername = '{user.Nutzername}';";
StaticDB.Connect();
SqlCommand command = new SqlCommand(com, StaticDB.Connection);
StaticDB.Connection.Open();
command.Parameters.Add("@bild", System.Data.SqlDbType.VarBinary).Value = user.ProfilBild;
command.ExecuteNonQuery();
StaticDB.Connection.Close();
return(true);
}
catch (Exception ex)
{
_ = ex.Message;
if (StaticDB.Connection != null)
{
if (StaticDB.Connection.State != System.Data.ConnectionState.Closed)
{
StaticDB.Connection.Close();
}
}
return(false);
}
}
