public PreferencesForm(TNG_Database.MainForm parent)
{
InitializeComponent();
this.MdiParent = parent;
mainform = parent;
//load stats
LoadStats();
importPrefDirTexbox.Text = Path.GetFullPath(Properties.TNG_Settings.Default.ImportFolder);
exportPrefDirTexbox.Text = Path.GetFullPath(Properties.TNG_Settings.Default.ExportFolder);
databaseBackupCombobox.Items.AddRange(new string[] { "Day", "Week", "2 Weeks", "30 Days", "90 Days", "180 Days", "Year" });
databaseBackupCombobox.Text = GetNameOfBackupNumber();
}
//Open Form Constructor
public MasterListForm(TNG_Database.MainForm parent, bool addMaster = false)
{
InitializeComponent();
this.MdiParent = parent;
mainform = parent;
//Load data into listbox
PopulateMasterList();
MakeGroupboxesInvisible();
//Set Locations for all groupboxes
addMasterListGroupBox.Location = boxLocation;
editMasterListGroupBox.Location = boxLocation;
deleteMasterListGroupBox.Location = boxLocation;
//make edit and delete buttons disabled
masterListEditButton.Enabled = false;
masterListDeleteButton.Enabled = false;
//make labels for tape invisible
defaultArchiveMasterListLabel.Visible = false;
defaultCameraMasterListLabel.Visible = false;
defaultArchiveNameMasterListLabel.Visible = false;
defaultCameraNameMasterListLabel.Visible = false;
//Focus changed methods
addMasterListNameTextbox.GotFocus += AddMasterListNameTextbox_GotFocus;
editNewNameMasterTextbox.GotFocus += EditNewNameMasterTextbox_GotFocus;
addMasterListNameTextbox.LostFocus += AddMasterListNameTextbox_LostFocus;
editNewNameMasterTextbox.LostFocus += EditNewNameMasterTextbox_LostFocus;
//Change name of default GB and make default label visible
defaultMasterGroupBox.Text = "";
defaultMasterGroupBox.Height = 41;
defaultMasterListLabel.Visible = true;
//Load all the dropdowns
LoadDropdowns();
SetDefaultColors("all");
//set bool value
clickAddButton = addMaster;
}
/// <summary>
/// Enables outside methods to add strings to status bar update list
/// </summary>
/// <param name="update">The update.</param>
/// <param name="mainForm">The main form.</param>
public void UpdateStatusBar(string update, TNG_Database.MainForm mainForm, int time = 2000)
{
//mainForm.applicationStatusLabel.Text = update;
homeForm = mainForm;
//set values to be added to list
UpdateStatusValues statusValues = new UpdateStatusValues(update, time);
//if list is null create new list
if(statusList == null)
{
statusList = new List<UpdateStatusValues>();
}
//add string to list
statusList.Add(statusValues);
//start background worker thread
if (statusWorker.IsBusy != true)
{
statusWorker.RunWorkerAsync();
}
}
/// <summary>
/// Updates the progress bar.
/// </summary>
/// <param name="add">The add.</param>
/// <param name="mainForm">The main form.</param>
public void UpdateProgressBar(int add, TNG_Database.MainForm mainForm)
{
mainForm.mainFormProgressBar.Increment(add);
}
public TapeListForm(TNG_Database.MainForm parent, bool addEntry = false)
{
InitializeComponent();
this.MdiParent = parent;
mainform = parent;
PopulateTapeList();
tapeListEditEntryButton.Enabled = false;
tapeListDeleteEntryButton.Enabled = false;
//set default items to appropriate visibility
defaultItemsPanel.Visible = false;
defaultNoItemSelectedLabel.Visible = true;
//set default label to default value
defaultNoItemSelectedLabel.Text = defaultNoText;
defaultNoItemSelectedLabel.Visible = true;
//disable all groupboxes except default
addTapeGroupbox.Visible = false;
deleteTapeGroupbox.Visible = false;
editTapeGroupbox.Visible = false;
defaultTapeGroupbox.Visible = true;
//Populate all dropdowns
LoadDropdowns();
//Attach all add textboxes to an event
addProjectIDTextbox.TextChanged += addTextBoxes_TextChanged;
addTapeNameTextbox.TextChanged += addTextBoxes_TextChanged;
addTagsTextbox.TextChanged += addTextBoxes_TextChanged;
addCameraComboBox.SelectedIndexChanged += addTextBoxes_TextChanged;
addTapeNumUpDown.ValueChanged += addTextBoxes_TextChanged;
addDateDateTime.ValueChanged += addTextBoxes_TextChanged;
//Project ID lost focus
addProjectIDTextbox.LostFocus += AddProjectIDTextbox_LostFocus;
editProjectIDTextbox.LostFocus += EditProjectIDTextbox_LostFocus;
//Attach all edit textboxes to an event
editProjectIDTextbox.TextChanged += editTextBoxes_TextChanged;
editTapeNameTextbox.TextChanged += editTextBoxes_TextChanged;
editTagsTextbox.TextChanged += editTextBoxes_TextChanged;
editCameraDropdown.SelectedIndexChanged += editTextBoxes_TextChanged;
editTapeNumberUpDown.ValueChanged += editTextBoxes_TextChanged;
editDateShotDate.ValueChanged += editTextBoxes_TextChanged;
//focus given to to tag textbox
addTagsTextbox.GotFocus += AddTagsTextbox_GotFocus;
editTagsTextbox.GotFocus += AddTagsTextbox_GotFocus;
//losing focus
addTagsTextbox.LostFocus += AddTagsTextbox_LostFocus;
editTagsTextbox.LostFocus += AddTagsTextbox_LostFocus;
//set lost focus for all other controls.
addTapeNameTextbox.LostFocus += AddTapeNameTextbox_LostFocus;
addCameraComboBox.LostFocus += AddCameraComboBox_LostFocus;
addTapeNumUpDown.LostFocus += AddTapeNumUpDown_LostFocus;
addDateDateTime.LostFocus += AddDateDateTime_LostFocus;
editTapeNameTextbox.LostFocus += EditTapeNameTextbox_LostFocus;
editCameraDropdown.LostFocus += EditCameraDropdown_LostFocus;
editTapeNumberUpDown.LostFocus += EditTapeNumberUpDown_LostFocus;
editDateShotDate.LostFocus += EditDateShotDate_LostFocus;
//set Got Focus methods
addProjectIDTextbox.GotFocus += Controls_GotFocus;
addTapeNameTextbox.GotFocus += Controls_GotFocus;
addCameraComboBox.GotFocus += Controls_GotFocus;
addTapeNumUpDown.GotFocus += Controls_GotFocus;
addDateDateTime.GotFocus += Controls_GotFocus;
editProjectIDTextbox.GotFocus += Controls_GotFocus;
editTapeNameTextbox.GotFocus += Controls_GotFocus;
editCameraDropdown.GotFocus += Controls_GotFocus;
editTapeNumberUpDown.GotFocus += Controls_GotFocus;
editDateShotDate.GotFocus += Controls_GotFocus;
//Tooltips
//add
addTagsTextbox.MouseHover += AddTagsTextbox_MouseHover;
addTagsTextbox.MouseLeave += AddTagsTextbox_MouseLeave;
//edit
editTagsTextbox.MouseHover += AddTagsTextbox_MouseHover;
editTagsTextbox.MouseLeave += AddTagsTextbox_MouseLeave;
//keep items highlighted
tapeListListView.HideSelection = false;
//Clear all controls
ClearAddControls();
ClearDeleteLabels();
ClearDeleteLabels();
//Event for sorting each column
CommonMethods.ListViewItemComparer.SortColumn = -1;
tapeListListView.ColumnClick += new ColumnClickEventHandler(CommonMethods.ListViewItemComparer.SearchListView_ColumnClick);
buttonToPress = addEntry;
}
private static void UpdateProgess(float progress, TNG_Database.MainForm mainForm)
{
updateStatus.UpdateProgressBar(Convert.ToInt32(progress), mainForm);
}
/// <summary>
/// Gets all tables from imported database and inserts the information into the default database
/// </summary>
/// <param name="file">The file.</param>
/// <param name="mainForm">The main form.</param>
public static void GetTableName(string file, TNG_Database.MainForm mainForm)
{
List<string> allTables = new List<string>();
Debug.WriteLine("Starting to import");
//new database filename
string fileDatabase = "Data Source=" + file + ";Version=3;";
Debug.WriteLine(fileDatabase);
//progressbar status for each table
int everyTable = 0;
int progress = 0;
try
{
//command to get all tables in database
const string GET_TABLES_QUERY = "select name from sqlite_master where type='table'";
SQLiteConnection connection = new SQLiteConnection(fileDatabase);
connection.Open();
SQLiteCommand command = new SQLiteCommand(GET_TABLES_QUERY, connection);
using (SQLiteDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
Debug.WriteLine("import has tables");
while (reader.Read())
{
if (TNGTables.Contains(reader.GetString(0)))
{
allTables.Add(reader.GetString(0));
}
}
}
}
//close connection
connection.Close();
}catch(SQLiteException e)
{
MainForm.LogFile("SQLite Error: " + e.Message);
Debug.WriteLine("SQLite Error: " + e.Message);
}
try
{
//check to see if there are any tables returned
if (!allTables.Count.Equals(0))
{
//set progressbar status to division on count of tables
everyTable = 100 / allTables.Count;
Debug.WriteLine("Table Number #: " + everyTable);
AddToDatabase addDB = new AddToDatabase();
foreach (string table in allTables)
{
//connection for new database
SQLiteConnection connect = new SQLiteConnection(fileDatabase);
connect.Open();
SQLiteCommand command = new SQLiteCommand(connect);
command.CommandText = "Select * from " + table;
switch (table)
{
case "TapeDatabase":
case "DeleteTapeDatabase":
//create values object
List<TapeDatabaseValues> tapeList = new List<TapeDatabaseValues>();
TapeDatabaseValues tapeValues = new TapeDatabaseValues();
//execute query
using (SQLiteDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
tapeValues.Clear();
tapeValues.ProjectId = reader["project_id"].ToString();
tapeValues.ProjectName = reader["project_name"].ToString();
tapeValues.TapeName = reader["tape_name"].ToString();
tapeValues.TapeNumber = reader["tape_number"].ToString();
tapeValues.Camera = Convert.ToInt32(reader["camera"]);
tapeValues.TapeTags = reader["tape_tags"].ToString();
tapeValues.DateShot = reader["date_shot"].ToString();
tapeValues.MasterArchive = reader["master_archive"].ToString();
tapeValues.PersonEntered = reader["person_entered"].ToString();
//add values to list
tapeList.Add(tapeValues);
}
}
}
//Close import connection
connect.Close();
//iterate over values to add to database
foreach (TapeDatabaseValues values in tapeList)
{
if (table == "TapeDatabase")
{
//add value to database
addDB.AddTapeDatabase(values);
}
else if(table == "DeleteTapeDatabase")
{
//Open up new connection
SQLiteConnection deleteConnect = new SQLiteConnection(database);
deleteConnect.Open();
command.Connection = deleteConnect;
command.CommandText = "select count(*) from DeleteTapeDatabase where lower(project_name) = @projectName and project_id = @projectID";
command.Parameters.Clear();
command.Parameters.AddWithValue("@projectID", values.ProjectId);
command.Parameters.AddWithValue("@projectName", values.ProjectName.ToLower());
Int32 check = Convert.ToInt32(command.ExecuteScalar());
//Make sure that entry doesn't exist already
if (check < 1)
{
//add value to deleted database
//There is not an entry go ahead and insert new row
command.CommandText = "insert into DeleteTapeDatabase (tape_name, tape_number, project_id, project_name, camera, tape_tags, date_shot, master_archive, person_entered) values (@tapeName, @tapeNumber, @projectID, @projectName, @camera, @tapeTags, @dateShot, @masterArchive, @personEntered)";
command.Parameters.Clear();
command.Parameters.AddWithValue("@tapeName", values.TapeName);
command.Parameters.AddWithValue("@tapeNumber", values.TapeNumber);
command.Parameters.AddWithValue("@projectID", values.ProjectId);
command.Parameters.AddWithValue("@projectName", values.ProjectName);
command.Parameters.AddWithValue("@camera", values.Camera);
command.Parameters.AddWithValue("@tapeTags", values.TapeTags);
command.Parameters.AddWithValue("@dateShot", values.DateShot);
command.Parameters.AddWithValue("@masterArchive", values.MasterArchive);
command.Parameters.AddWithValue("@personEntered", values.PersonEntered);
command.ExecuteNonQuery();
}
deleteConnect.Close();
}
}
UpdateProgess(everyTable, mainForm);
progress += everyTable;
break;
case "Projects":
case "DeleteProjects":
//create values object
List<ProjectValues> projectList = new List<ProjectValues>();
ProjectValues projectValues = new ProjectValues();
//execute query
using (SQLiteDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
projectValues.Clear();
projectValues.ProjectID = reader["project_id"].ToString();
projectValues.Projectname = reader["project_name"].ToString();
//add values to list
projectList.Add(projectValues);
}
}
}
//Close import connection
connect.Close();
//iterate over values to add to database
foreach (ProjectValues values in projectList)
{
if (table == "Projects")
{
//add value to database
addDB.AddProjects(values);
}
else if (table == "DeleteProjects")
{
//Open up new connection
SQLiteConnection deleteConnect = new SQLiteConnection(database);
deleteConnect.Open();
command.Connection = deleteConnect;
command.CommandText = "select count(*) from DeleteProjects where lower(project_name) = @projectName and project_id = @projectID";
command.Parameters.Clear();
command.Parameters.AddWithValue("@projectID", values.ProjectID);
command.Parameters.AddWithValue("@projectName", values.Projectname.ToLower());
Int32 check = Convert.ToInt32(command.ExecuteScalar());
//Make sure that entry doesn't exist already
if (check < 1)
{
//add value to deleted database
//There is not an entry go ahead and insert new row
command.CommandText = "insert into DeleteProjects (project_id, project_name) values (@projectID, @projectName)";
command.Parameters.Clear();
command.Parameters.AddWithValue("@projectID", values.ProjectID);
command.Parameters.AddWithValue("@projectName", values.Projectname);
command.ExecuteNonQuery();
}
deleteConnect.Close();
}
}
UpdateProgess(everyTable, mainForm);
progress += everyTable;
break;
case "People":
case "DeletePeople":
//create values object
List<PeopleValues> peopleList = new List<PeopleValues>();
PeopleValues peopleValues = new PeopleValues();
//execute query
using (SQLiteDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
peopleValues.Clear();
peopleValues.PersonName = reader["person_name"].ToString();
//add values to list
peopleList.Add(peopleValues);
}
}
}
//Close import connection
connect.Close();
//iterate over values to add to database
foreach (PeopleValues values in peopleList)
{
if (table == "People")
{
//add value to database
addDB.AddPerson(values);
}
else if (table == "DeletePeople")
{
//Open up new connection
SQLiteConnection deleteConnect = new SQLiteConnection(database);
deleteConnect.Open();
command.Connection = deleteConnect;
command.CommandText = "select count(*) from DeletePeople where lower(person_name) = @personName";
command.Parameters.Clear();
command.Parameters.AddWithValue("@personName", values.PersonName.ToLower());
Int32 check = Convert.ToInt32(command.ExecuteScalar());
//Make sure that entry doesn't exist already
if (check < 1)
{
//add value to deleted database
//There is not an entry go ahead and insert new row
command.CommandText = "insert into DeletePeole (person_name) values (@personName)";
command.Parameters.Clear();
command.Parameters.AddWithValue("@personName", values.PersonName);
command.ExecuteNonQuery();
}
deleteConnect.Close();
}
}
UpdateProgess(everyTable, mainForm);
progress += everyTable;
break;
case "MasterList":
case "DeleteMasterList":
//create values object
List<MasterListValues> masterTapeList = new List<MasterListValues>();
MasterListValues masterTapeValues = new MasterListValues();
//execute query
using (SQLiteDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
masterTapeValues.Clear();
masterTapeValues.MasterArchive = reader["master_archive"].ToString();
masterTapeValues.MasterMedia = Convert.ToInt32(reader["master_media"]);
//add values to list
masterTapeList.Add(masterTapeValues);
}
}
}
//Close import connection
connect.Close();
//iterate over values to add to database
foreach (MasterListValues values in masterTapeList)
{
if (table == "MasterList")
{
//add value to database
addDB.AddMasterList(values);
}
else if (table == "DeleteMasterList")
{
//Open up new connection
SQLiteConnection deleteConnect = new SQLiteConnection(database);
deleteConnect.Open();
command.Connection = deleteConnect;
command.CommandText = "select count(*) from DeleteMasterList where lower(master_archive) = @masterArchive and master_media = @masterMedia";
command.Parameters.Clear();
command.Parameters.AddWithValue("@masterArchive", values.MasterArchive.ToLower());
command.Parameters.AddWithValue("@masterMedia", values.MasterMedia);
Int32 check = Convert.ToInt32(command.ExecuteScalar());
//Make sure that entry doesn't exist already
if (check < 1)
{
//add value to deleted database
//There is not an entry go ahead and insert new row
command.CommandText = "insert into DeleteMasterList (master_archive, master_media) values (@masterArchive, @masterMedia)";
command.Parameters.Clear();
command.Parameters.AddWithValue("@masterArchive", values.MasterArchive);
command.Parameters.AddWithValue("@masterMedia", values.MasterMedia);
command.ExecuteNonQuery();
}
deleteConnect.Close();
}
}
UpdateProgess(everyTable, mainForm);
progress += everyTable;
break;
case "MasterArchiveVideos":
case "DeleteMasterArchiveVideos":
//create values object
List<MasterArchiveVideoValues> masterArchiveVideoList = new List<MasterArchiveVideoValues>();
MasterArchiveVideoValues MasterArchiveVideoValues = new MasterArchiveVideoValues();
//execute query
using (SQLiteDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
MasterArchiveVideoValues.Clear();
MasterArchiveVideoValues.ProjectId = reader["project_id"].ToString();
MasterArchiveVideoValues.VideoName = reader["video_name"].ToString();
MasterArchiveVideoValues.MasterTape = reader["master_tape"].ToString();
MasterArchiveVideoValues.ClipNumber = reader["clip_number"].ToString();
//add values to list
masterArchiveVideoList.Add(MasterArchiveVideoValues);
}
}
}
//Close import connection
connect.Close();
//iterate over values to add to database
foreach (MasterArchiveVideoValues values in masterArchiveVideoList)
{
if (table == "MasterArchiveVideos")
{
//add value to database
addDB.AddMasterArchiveVideo(values);
}
else if (table == "DeleteMasterArchiveVideos")
{
//Open up new connection
SQLiteConnection deleteConnect = new SQLiteConnection(database);
deleteConnect.Open();
command.Connection = deleteConnect;
command.CommandText = "select count(*) from DeleteMasterArchiveVideos where project_id = @projectID and video_name = @videoName and clip_number = @clipNumber and master_tape = @masterTape";
command.Parameters.Clear();
command.Parameters.AddWithValue("@projectID", values.ProjectId);
command.Parameters.AddWithValue("@videoName", values.VideoName);
command.Parameters.AddWithValue("@masterTape", values.MasterTape);
command.Parameters.AddWithValue("@clipNumber", values.ClipNumber);
Int32 check = Convert.ToInt32(command.ExecuteScalar());
//Make sure that entry doesn't exist already
if (check < 1)
{
//add value to deleted database
//There is not an entry go ahead and insert new row
command.CommandText = "insert into DeleteMasterArchiveVideos (project_id, video_name, master_tape, clip_number) values (@projectID, @videoName, @masterTape, @clipNumber)";
command.Parameters.Clear();
command.Parameters.AddWithValue("@projectID", values.ProjectId);
command.Parameters.AddWithValue("@videoName", values.VideoName);
command.Parameters.AddWithValue("@masterTape", values.MasterTape);
command.Parameters.AddWithValue("@clipNumber", values.ClipNumber);
command.ExecuteNonQuery();
}
deleteConnect.Close();
}
}
UpdateProgess(everyTable, mainForm);
progress += everyTable;
break;
case "ComputerInfo":
//create values object
List<ComputerInfoValues> computerInfoList = new List<ComputerInfoValues>();
ComputerInfoValues computerInfoValues = new ComputerInfoValues();
//execute query
using (SQLiteDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
computerInfoValues.Clear();
computerInfoValues.UniqueHash = reader["computer_hash"].ToString();
computerInfoValues.ComputerName = reader["computer_name"].ToString();
computerInfoValues.ComputerUser = reader["computer_user"].ToString();
//add values to list
computerInfoList.Add(computerInfoValues);
}
}
}
//Close import connection
connect.Close();
//iterate over values to add to database
foreach (ComputerInfoValues values in computerInfoList)
{
//add value to database
addDB.AddComputerInfo(values);
}
UpdateProgess(everyTable, mainForm);
progress += everyTable;
break;
}
}
}
}catch(SQLiteException e)
{
MainForm.LogFile("SQLite Error: " + e.Message);
Debug.WriteLine("SQLite Table Error: " + e.Message);
}
if((100 - progress) > 0)
{
UpdateProgess((100-progress), mainForm);
}
}
