public static List <LectieModel> GetLectii() { List <LectieModel> lectii = new List <LectieModel>(); using (SqlConnection con = new SqlConnection(ConnectionString)) { con.Open(); string cmdText = "Select * from Lectii"; using (SqlCommand cmd = new SqlCommand(cmdText, con)) { using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { LectieModel lectie = new LectieModel { IdLectie = (int)reader["IdLectie"], IdUtilizator = (int)reader["IdUtilizator"], TitluLectie = reader["TitluLectie"].ToString(), Regiune = reader["Regiune"].ToString(), Datacreare = (DateTime)reader["DataCreare"], NumeImagine = reader["NumeImagine"].ToString() }; lectii.Add(lectie); } } } } return(lectii); }
private void button1_Click(object sender, EventArgs e) { if (listBox1.SelectedItem != null) { LectieModel lectiaSelectata = lectii.Find(x => x.IdLectie == listBox1.SelectedIndex + 1); Bitmap imageToDisplay = new Bitmap("ContinutLectii\\" + lectiaSelectata.NumeImagine); pictureBox1.Image = imageToDisplay; UserModel utilizatorCreator = DataAcces.GetUser(lectiaSelectata.IdUtilizator); label4.Text = utilizatorCreator.Nume; label5.Text = utilizatorCreator.Email; label6.Text = lectiaSelectata.Regiune; label7.Text = lectiaSelectata.Datacreare.ToString(); } else { MessageBox.Show("Selectati lectia!"); } }
public static void InitializeDB() { ClearDB(); string filePath = "Utilizatori.txt"; using (StreamReader file = new StreamReader(filePath)) { int i = 1; while (file.Peek() >= 0) { string[] tokens = file.ReadLine().Split('*').ToArray(); UserModel utilizator = new UserModel { Nume = tokens[0], Parola = tokens[1], Email = tokens[2], IdUtilizator = i }; using (SqlConnection con = new SqlConnection(connectionString)) { con.Open(); string cmdText = "Insert into Utilizatori(IdUtilizator,Nume,Parola,Email) values (@idutilizator,@nume,@parola,@email)"; using (SqlCommand cmd = new SqlCommand(cmdText, con)) { cmd.Parameters.AddWithValue("idutilizator", utilizator.IdUtilizator); cmd.Parameters.AddWithValue("nume", utilizator.Nume); cmd.Parameters.AddWithValue("parola", utilizator.Parola); cmd.Parameters.AddWithValue("email", utilizator.Email); cmd.ExecuteNonQuery(); } } i++; } } filePath = "Lectii.txt"; using (StreamReader file = new StreamReader(filePath)) { int i = 1; while (file.Peek() >= 0) { string[] tokens = file.ReadLine().Split('*').ToArray(); LectieModel lectie; if (tokens.Length == 5) { lectie = new LectieModel { IdLectie = i, IdUtilizator = Int32.Parse(tokens[0]), TitluLectie = tokens[1], Regiune = tokens[2], NumeImagine = tokens[3], Datacreare = DateTime.ParseExact(tokens[4], "M/d/yyyy h:mm:ss tt", CultureInfo.InvariantCulture) }; } else { lectie = new LectieModel { IdLectie = i, IdUtilizator = Int32.Parse(tokens[0]), TitluLectie = "", Regiune = tokens[1], NumeImagine = tokens[2], Datacreare = DateTime.ParseExact(tokens[3], "M/d/yyyy h:mm:ss tt", CultureInfo.InvariantCulture) }; } using (SqlConnection con = new SqlConnection(connectionString)) { con.Open(); string cmdText = "Insert into Lectii(IdLectie,IdUtilizator,TitluLectie,Regiune,DataCreare,NumeImagine) " + "values (@idlectie,@idutlizator,@titlulectie,@regiune,@datacreare,@numeimagine)"; using (SqlCommand cmd = new SqlCommand(cmdText, con)) { cmd.Parameters.AddWithValue("idlectie", lectie.IdLectie); cmd.Parameters.AddWithValue("idutlizator", lectie.IdUtilizator); cmd.Parameters.AddWithValue("titlulectie", lectie.TitluLectie); cmd.Parameters.AddWithValue("regiune", lectie.Regiune); cmd.Parameters.AddWithValue("datacreare", lectie.Datacreare); cmd.Parameters.AddWithValue("numeimagine", lectie.NumeImagine + ".bmp"); cmd.ExecuteNonQuery(); } } i++; } } }