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