/// <summary>
/// Einfügen eines Status
/// </summary>
/// <param name="status">Der einzufügende Status</param>
/// <returns></returns>
public bool Insert(Status status)
{
string com = $"INSERT INTO Feed_Base VALUES('{status.Beschreibung}');";
bool result = StaticDB.RunSQL(com);
if (result == false)
{
return(false);
}
int id = StaticDB.GetID($"SELECT ID FROM Feed_Base WHERE Beschreibung = '{status.Beschreibung}'");
com = $"INSERT INTO Feed_Info VALUES('{id}', '{status.ErstelltAm:yyyy-MM-dd HH:mm:ss}', '{status.ErstelltVon.Nutzername}')";
result = StaticDB.RunSQL(com);
if (result == false)
{
return(false);
}
if (status.Foto != null)
{
com = $"INSERT INTO Feed_Fotos VALUES('{id}', @bild);";
StaticDB.Connect();
SqlCommand command = new SqlCommand(com, StaticDB.Connection);
command.Parameters.Add("@bild", System.Data.SqlDbType.VarBinary).Value = status.Foto;
StaticDB.Connection.Open();
int count = command.ExecuteNonQuery();
StaticDB.Connection.Close();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
return(true);
}
/// <summary>
/// Einen Beitrag liken
/// </summary>
/// <param name="id">ID des Beitrages</param>
/// <param name="user">Benutzer, der den Beitrag geliked hat</param>
/// <returns></returns>
public bool?Like(string id, User user)
{
bool isdone = false;
string com = $"SELECT Feed_ID FROM Feed_Likes WHERE Feed_ID = '{id}' AND [User] = '{user.Nutzername}'";
int result = StaticDB.GetID(com);
if (result == -1)
{
com = $"INSERT INTO Feed_Likes VALUES('{id}', '{user.Nutzername}')";
isdone = StaticDB.RunSQL(com);
if (isdone == true)
{
return(true);
}
else
{
return(null);
}
}
else if (result > 0)
{
com = $"DELETE FROM Feed_Likes WHERE Feed_ID = '{id}' AND [User] = '{user.Nutzername}'";
isdone = StaticDB.RunSQL(com);
if (isdone == true)
{
return(false);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
/// <summary>
/// Fügt einen Trainingsplan zu der Datenbank hinzu.
/// </summary>
/// <param name="trainingsplan">Objekt vom Typ Trainingsplan</param>
/// <returns>Gibt bei erfolgreichem Ausführen true zurück und bei einem Fehler false</returns>
public bool AddTrainingsplan(Trainingsplan trainingsplan)
{
try
{
StaticDB.Connect();
string com = $"INSERT INTO TP_Base (Titel) values ('{trainingsplan.Titel}'); " +
"SELECT CAST(SCOPE_IDENTITY() AS INT)";
SqlCommand command = new SqlCommand(com, StaticDB.Connection);
StaticDB.Connection.Open();
int lastID = (int)command.ExecuteScalar();
StaticDB.Connection.Close();
if (trainingsplan.GeAendertAm != default)
{
com = $"INSERT INTO TP_Info (ID, ErstelltAm, ErstelltVon, GeaendertAm, Kategorie) VALUES ({lastID}, '{trainingsplan.ErstelltAm:yyyy-dd-MM HH:mm:ss}', '{trainingsplan.Ersteller.Nutzername}', '{trainingsplan.GeAendertAm:yyyy-dd-MM HH:mm:ss}', '{trainingsplan.Kategorie}');";
}
else
{
com = $"INSERT INTO TP_Info (ID, ErstelltAm, ErstelltVon, Kategorie) VALUES ({lastID}, '{trainingsplan.ErstelltAm:yyyy-dd-MM HH:mm:ss}', '{trainingsplan.Ersteller.Nutzername}', '{trainingsplan.Kategorie}');";
}
bool result = StaticDB.RunSQL(com);
if (result == false)
{
com = $"DELETE FROM TP_Base WHERE ID = '{lastID}'";
StaticDB.RunSQL(com);
return(false);
}
foreach (var uebung in trainingsplan.UebungList)
{
string checkEx = $"SELECT * FROM TP_Uebungen WHERE Name='{uebung.Name}' AND Gewicht={uebung.Menge.ToString().Replace(",", ".")} AND Repetition={uebung.Wiederholungen} AND Sets={uebung.Sätze}";
if (StaticDB.CheckExistenz(checkEx) == true)
{
int uebID = StaticDB.GetID(checkEx);
string comTpLink = $"INSERT INTO TP_Link_BaseUebung (ID_Base, ID_Uebung) VALUES({lastID}, {uebID})";
StaticDB.RunSQL(comTpLink);
}
else
{
com = $"INSERT INTO TP_Uebungen (Name, Gewicht, Repetition, Sets, Einheit) VALUES ('{uebung.Name}', {uebung.Menge.ToString().Replace(",", ".")}, {uebung.Wiederholungen}, {uebung.Sätze}, '{uebung.Einheit}'); " +
"SELECT CAST(SCOPE_IDENTITY() AS INT)";
SqlCommand insertUeb = new SqlCommand(com, StaticDB.Connection);
StaticDB.Connection.Open();
int lastUebID = (int)insertUeb.ExecuteScalar();
StaticDB.Connection.Close();
string comTpLink = $"INSERT INTO TP_Link_BaseUebung (ID_Base, ID_Uebung) VALUES({lastID}, {lastUebID})";
StaticDB.RunSQL(comTpLink);
}
}
StaticDB.Connection.Close();
return(true);
}
catch (Exception ex)
{
_ = ex.Message;
if (StaticDB.Connection != null)
{
if (StaticDB.Connection.State != ConnectionState.Closed)
{
StaticDB.Connection.Close();
}
}
return(false);
}
}
public bool AddErnährungsplan(Ernährungsplan ernährungsplan)
{
try
{
StaticDB.Connect();
StaticDB.Connection.Open();
string com = $"INSERT INTO EP_Base (Titel) VALUES ('{ernährungsplan.Titel}'); SELECT CAST(SCOPE_IDENTITY() AS INT)";
SqlCommand sqlCommand = new SqlCommand(com, StaticDB.Connection);
int ID = (int)sqlCommand.ExecuteScalar();
StaticDB.Connection.Close();
if (ernährungsplan.GeAendertAm != default)
{
com = $"INSERT INTO EP_Info (ID, ErstelltAm, ErstelltVon, GeaendertAm, Kategorie) VALUES ({ID}, '{ernährungsplan.ErstelltAm:yyyy-dd-MM HH:mm:ss}', '{ernährungsplan.Ersteller.Nutzername}', '{ernährungsplan.GeAendertAm:yyyy-dd-MM HH:mm:ss}', '{ernährungsplan.Kategorie}');";
}
else
{
com = $"INSERT INTO EP_Info (ID, ErstelltAm, ErstelltVon, Kategorie) VALUES ({ID}, '{ernährungsplan.ErstelltAm:yyyy-dd-MM HH:mm:ss}', '{ernährungsplan.Ersteller.Nutzername}', '{ernährungsplan.Kategorie}');";
}
bool result = StaticDB.RunSQL(com);
if (result == false)
{
com = $"DELETE FROM EP_Base WHERE ID = '{ID}'";
StaticDB.RunSQL(com);
return(false);
}
foreach (var mahlzeit in ernährungsplan.MahlzeitenList)
{
string checkEx = $"SELECT * FROM EP_Mahlzeiten WHERE Nahrungsmittel='{mahlzeit.Nahrungsmittel}' AND Menge={mahlzeit.Menge.ToString().Replace(",", ".")} AND Einheit='{mahlzeit.Einheit}'";
if (StaticDB.CheckExistenz(checkEx) == true)
{
int mahlID = StaticDB.GetID(checkEx);
string comEpLink = $"INSERT INTO EP_Link_BaseMahlzeiten (ID_Base, ID_Mahlzeit) VALUES({ID}, {mahlID})";
StaticDB.RunSQL(comEpLink);
}
else
{
com = $"INSERT INTO EP_Mahlzeiten (Nahrungsmittel, Menge, Einheit) VALUES ('{mahlzeit.Nahrungsmittel}', {mahlzeit.Menge.ToString().Replace(",", ".")}, '{mahlzeit.Einheit}'); " +
"SELECT CAST(SCOPE_IDENTITY() AS INT)";
SqlCommand insertMahl = new SqlCommand(com, StaticDB.Connection);
StaticDB.Connection.Open();
int lastMahlID = (int)insertMahl.ExecuteScalar();
StaticDB.Connection.Close();
string comTpLink = $"INSERT INTO EP_Link_BaseMahlzeiten (ID_Base, ID_Mahlzeit) VALUES({ID}, {lastMahlID})";
StaticDB.RunSQL(comTpLink);
}
}
StaticDB.Connection.Close();
return(true);
}
catch (Exception ex)
{
_ = ex.Message;
if (StaticDB.Connection != null)
{
if (StaticDB.Connection.State != ConnectionState.Closed)
{
StaticDB.Connection.Close();
}
}
return(false);
}
}
