Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using System.IO;
- using System.Windows.Forms;
- using System.Data.OleDb;
- namespace freebook
- {
- public partial class frmMain : Form
- {
- public frmMain()
- {
- InitializeComponent();
- }
- /// carti.txt
- public void deleteC()
- {
- OleDbConnection connection = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data source=freebook.accdb;");
- connection.Open();
- string cmdText = "delete from carti;";
- OleDbCommand cmd = new OleDbCommand(cmdText, connection);
- cmd.ExecuteNonQuery();
- connection.Close();
- }
- public void insertbooks()
- {
- deleteC();
- OleDbConnection connection = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data source=freebook.accdb;");
- connection.Open();
- string cmdText = "insert into carti (titlu, autor, gen) values (@titlu, @autor, @gen)";
- OleDbCommand cmd = new OleDbCommand(cmdText, connection);
- string[] Lines = File.ReadAllLines("E:/Programming/C#/OJTI 2019/freebook/freebook/bin/Debug/carti.txt");
- cmd.Parameters.AddWithValue("titlu", "");
- cmd.Parameters.AddWithValue("autor", "");
- cmd.Parameters.AddWithValue("gen", "");
- foreach (string Line in Lines)
- {
- string[] CurentLine = Line.Split('*');
- cmd.Parameters["titlu"].Value = CurentLine[0].ToString();
- cmd.Parameters["autor"].Value = CurentLine[1].ToString();
- cmd.Parameters["gen"].Value = CurentLine[2].ToString();
- cmd.ExecuteNonQuery();
- }
- connection.Close();
- }
- /// users.txt
- public void deleteU()
- {
- OleDbConnection connection = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data source=freebook.accdb;");
- connection.Open();
- string cmdText = "delete from utilizatori;";
- OleDbCommand cmd = new OleDbCommand(cmdText, connection);
- cmd.ExecuteNonQuery();
- connection.Close();
- }
- public void insertusers()
- {
- deleteU();
- OleDbConnection connection = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data source=freebook.accdb;");
- connection.Open();
- string cmdText = "insert into utilizatori (email, parola, nume, prenume) values (@email, @parola, @nume, @prenume)";
- OleDbCommand cmd = new OleDbCommand(cmdText, connection);
- string[] Lines = File.ReadAllLines("E:/Programming/C#/OJTI 2019/freebook/freebook/bin/Debug/utilizatori.txt");
- cmd.Parameters.AddWithValue("email", "");
- cmd.Parameters.AddWithValue("parola", "");
- cmd.Parameters.AddWithValue("nume", "");
- cmd.Parameters.AddWithValue("prenume", "");
- foreach (string Line in Lines)
- {
- string[] CurentLine = Line.Split('*');
- cmd.Parameters["email"].Value = CurentLine[0].ToString();
- cmd.Parameters["parola"].Value = CurentLine[1].ToString();
- cmd.Parameters["nume"].Value = CurentLine[2].ToString();
- cmd.Parameters["prenume"].Value = CurentLine[3].ToString();
- cmd.ExecuteNonQuery();
- }
- connection.Close();
- }
- /// imprumuturi.txt
- public void deleteI()
- {
- OleDbConnection connection = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data source=freebook.accdb;");
- connection.Open();
- string cmdText = "delete from imprumut;";
- OleDbCommand cmd = new OleDbCommand(cmdText, connection);
- cmd.ExecuteNonQuery();
- connection.Close();
- }
- public void insertimpr()
- {
- deleteI();
- OleDbConnection connection = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data source=freebook.accdb;");
- connection.Open();
- string cmdText = "insert into imprumut (id_carte, email, data_imprumut) values (@id_carte, @email, @data_imprumut);";
- OleDbCommand cmd = new OleDbCommand(cmdText, connection);
- string[] Lines = File.ReadAllLines("E:/Programming/C#/OJTI 2019/freebook/freebook/bin/Debug/imprumuturi.txt");
- cmd.Parameters.AddWithValue("id_carte", "");
- cmd.Parameters.AddWithValue("email", "");
- cmd.Parameters.AddWithValue("data_imprumut", "");
- foreach (string Line in Lines)
- {
- string[] CurentLine = Line.Split('*');
- cmd.Parameters["id_carte"].Value = CurentLine[0].ToString();
- cmd.Parameters["email"].Value = CurentLine[1].ToString();
- cmd.Parameters["data_imprumut"].Value = CurentLine[2].ToString();
- cmd.ExecuteNonQuery();
- }
- connection.Close();
- }
- private void frmMain_Load(object sender, EventArgs e)
- {
- insertbooks();
- insertusers();
- insertimpr();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment