private List <Eveniment> getAllEvenimente(string user)
{
var dbCon = DBConnection.Instance();
dbCon.DatabaseName = "mybd";
if (dbCon.IsConnect())
{
List <Eveniment> evenimenteleObtinute = new List <Eveniment>();
dbCon.Connection.Open();
string query = $"SELECT * FROM mydb.evenimentele_useri WHERE loginNume = '{user}';";
var cmd = new MySqlCommand(query, dbCon.Connection);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
int idEveniment = reader.GetInt16(0);
string numeEveniment = reader.GetString(1);
string tipEveniment = reader.GetString(2);
string descriereEveniment = reader.GetString(3);
DateTime inceputEveniment = reader.GetDateTime(4);
DateTime sfarsitEveniment = reader.GetDateTime(5);
Eveniment ev = new Eveniment(idEveniment, numeEveniment, descriereEveniment,
tipEveniment, inceputEveniment, sfarsitEveniment);
evenimenteleObtinute.Add(ev);
}
dbCon.Close();
return(evenimenteleObtinute);
}
else
{
dbCon.Close();
return(null);
}
}
public object ToggleEveniment(Eveniment ev)
{
if (ev.tip == "unic")
{
ev.tip = "terminat";
}
else if (ev.tip == "terminat")
{
ev.tip = "unic";
}
return(ev);
}