private void button5_Click(object sender, EventArgs e)
{
OleDbConnection conexiune = new OleDbConnection(provider);
OleDbCommand comanda = new OleDbCommand();
string nume = null;
foreach (ListViewItem item in lvw.Items)
{
if (item.Selected == true)
{
nume = item.SubItems[1].Text;
}
}
FisierVideo fis = new FisierVideo();
foreach (FisierVideo fisier in listafisiere)
{
if (fisier.denumireFisier.CompareTo(nume) == 0)
{
fis = fisier;
}
}
Form3 frm = new Form3(fis);
frm.ShowDialog();
foreach (ListViewItem item in lvw.Items)
{
if (item.Selected == true)
{
try
{
conexiune.Open();
int cod = Convert.ToInt32(item.SubItems[0].Text);
string viz = null;
if (fis.vizualizat == true)
{
viz = "da";
}
else
{
viz = "nu";
}
comanda.CommandText = "update fisierevideo set Gen='" + fis.gen + "', Rating='" +
fis.rating + "', Vizualizat='" + viz + "' where Cod=" + cod;
comanda.Connection = conexiune;
comanda.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conexiune.Close();
}
}
//listView1.Items.Clear();
}
}
public Form3(FisierVideo fis)
{
InitializeComponent();
fisier = fis;
tbDenumire.Text = fis.denumireFisier;
tbDimensiune.Text = fis.dimensiuneFisier.ToString();
tbCale.Text = fis.caleFisier;
tbExtensie.Text = fis.extensie;
}
private void button1_Click(object sender, EventArgs e)
{
OleDbConnection conexiune = new OleDbConnection(provider);
OleDbCommand comanda = new OleDbCommand("SELECT * FROM fisierevideo", conexiune);
lvw.Items.Clear();
listafisiere.Clear();
try
{
conexiune.Open();
OleDbDataReader reader = comanda.ExecuteReader();
while (reader.Read())
{
FisierVideo fis = new FisierVideo();
ListViewItem itm = new ListViewItem(reader["Cod"].ToString());
itm.SubItems.Add(reader["Denumire Fisier"].ToString());
fis.denumireFisier = reader["Denumire Fisier"].ToString();
itm.SubItems.Add(reader["Cale Fisier"].ToString());
fis.caleFisier = reader["Cale Fisier"].ToString();
itm.SubItems.Add(reader["Extensie"].ToString());
fis.extensie = reader["Extensie"].ToString();
itm.SubItems.Add(reader["Gen"].ToString());
fis.gen = reader["Gen"].ToString();
itm.SubItems.Add(reader["Dimensiune"].ToString());
fis.dimensiuneFisier = Convert.ToDouble(reader["Dimensiune"].ToString());
itm.SubItems.Add(reader["Rating"].ToString());
fis.rating = (float)Convert.ToDouble(reader["Rating"]);
itm.SubItems.Add(reader["Vizualizat"].ToString());
if (reader["Vizualizat"].ToString() == "Da")
{
fis.vizualizat = true;
}
else
{
fis.vizualizat = false;
}
lvw.Items.Add(itm);
listafisiere.Add(fis);
}
reader.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conexiune.Close();
}
}
private void insertVideo(FisierVideo fis)
{
OleDbConnection conexiune = new OleDbConnection(provider);
OleDbCommand comanda = new OleDbCommand();
try
{
conexiune.Open();
int cod;
comanda.Connection = conexiune;
comanda.CommandText = "select count(*) from fisierevideo";
int check = Convert.ToInt32(comanda.ExecuteScalar());
comanda.CommandText = "select max(cod) from fisierevideo";
if (check != 0)
{
cod = Convert.ToInt32(comanda.ExecuteScalar());
}
else
{
cod = 0;
}
comanda.CommandText = "insert into fisierevideo values(?,?,?,?,?,?,?,?)";
comanda.Parameters.Add("Cod", OleDbType.Integer).Value = cod + 1;
comanda.Parameters.Add("Denumire Fisier", OleDbType.Char, 30).Value = fis.denumireFisier;
comanda.Parameters.Add("Cale Fisier", OleDbType.Char, 150).Value = fis.caleFisier;
comanda.Parameters.Add("Extensie", OleDbType.Char, 4).Value = fis.extensie;
comanda.Parameters.Add("Gen", OleDbType.Char, 150).Value = fis.gen;
comanda.Parameters.Add("Dimensiune", OleDbType.Integer, 150).Value = fis.dimensiuneFisier;
comanda.Parameters.Add("Rating", OleDbType.Integer).Value = fis.rating;
if (fis.vizualizat == false)
{
comanda.Parameters.Add("Vizualizat", OleDbType.Char, 3).Value = "Nu";
}
else
{
comanda.Parameters.Add("Vizualizat", OleDbType.Char, 3).Value = "Da";
}
comanda.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conexiune.Close();
}
}
static void Main(string[] args)
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(new Form1());
#region OldProgramTest
FisierVideo fis1 = new FisierVideo();
fis1.denumireFisier = "fisier1";
fis1.caleFisier = "E:/movie";
fis1.vizualizat = true;
FisierVideo fis2 = new FisierVideo();
fis2.denumireFisier = "fisier2";
fis2.caleFisier = "E:/movies";
fis2.vizualizat = false;
FisierVideo fis3 = (FisierVideo)fis2.Clone();
FisierVideo[] fisiere = new FisierVideo[] { fis1, fis2, fis3 };
DirectorVideo dir = new DirectorVideo("director1", "E:/", fisiere);
Console.WriteLine(dir);
foreach (FisierVideo fisier in fisiere)
{
Console.WriteLine(fisier);
}
DimensiuneEvent myDim = new DimensiuneEvent();
DimensiuneHandler handler = new DimensiuneHandler(myDim);
DimensiuneEventArgs e1 = new DimensiuneEventArgs("Fisier1", 3000);
DimensiuneEventArgs e2 = new DimensiuneEventArgs("Fisier2", 100);
DimensiuneEventArgs e3 = new DimensiuneEventArgs("Fisier3", 100000);
//lansare evenimente
myDim.VerificaDim(e1);
myDim.VerificaDim(e2);
myDim.VerificaDim(e3);
#endregion
}
private void editToolStripMenuItem_Click(object sender, EventArgs e)
{
string nume = null;
foreach (ListViewItem item in lvFisiere.Items)
{
if (item.Selected == true)
{
nume = item.SubItems[1].Text;
}
}
FisierVideo fis = new FisierVideo();
foreach (FisierVideo fisier in listaFisiere)
{
if (fisier.denumireFisier.CompareTo(nume) == 0)
{
fis = fisier;
}
}
Form3 frm = new Form3(fis);
frm.ShowDialog();
}
private void GetSubDirectoryNodes(TreeNode parentNode)
{
if (stop == 0)
{
DirectoryInfo di = new DirectoryInfo(parentNode.FullPath);
if ((di.Attributes & FileAttributes.Directory) == 0)
{
return;
}
parentNode.Nodes.Clear();
try
{
string[] arSubs = Directory.GetDirectories(parentNode.FullPath);
foreach (var subDir in arSubs)
{
DirectoryInfo dirInfo = new DirectoryInfo(subDir);
if ((dirInfo.Attributes & FileAttributes.Hidden) != 0)
{
continue;
}
TreeNode subNode = new TreeNode(dirInfo.Name);
parentNode.Nodes.Add(subNode);
}
string[] files = Directory.GetFiles(parentNode.FullPath);
foreach (string str in files)
{
FileInfo fi = new FileInfo(str);
TreeNode fileNode = new TreeNode(fi.Name);
bool verificare1 = fi.Name.EndsWith(".mkv");
bool verificare2 = fi.Name.EndsWith(".flv");
bool verificare3 = fi.Name.EndsWith(".avi");
bool verificare4 = fi.Name.EndsWith(".wmv");
bool verificare5 = fi.Name.EndsWith(".mp4");
bool verificare6 = fi.Name.EndsWith(".vob");
if ((verificare1 || verificare2 || verificare3 ||
verificare4 || verificare5 || verificare6))
{
//parentNode.Nodes.Clear();
parentNode.Nodes.Add(fileNode);
FisierVideo fis = new FisierVideo();
fis.denumireFisier = fileNode.Text.Split('.')[0];
fis.caleFisier = fileNode.FullPath;
fis.dimensiuneFisier = fi.Length / 1000000;
fis.extensie = fi.Extension;
fis.gen = "necunoscut";
fis.rating = 0;
fis.vizualizat = false;
listaFisiere.Add(fis);
}
int j = 0;
director.fisiereVideo = new FisierVideo[listaFisiere.Count];
foreach (FisierVideo fis in listaFisiere)
{
director.fisiereVideo[j] = fis;
j++;
}
director.nrFisiere = j - 1;
}
}
catch (UnauthorizedAccessException)
{
}
}
}
