//Edit button pressed
private void editTapeEditButton_Click(object sender, EventArgs e)
{
//check to see if project ID is a number
if (commonMethod.StringIsANumber(editProjectIDTextbox.Text))
{
AddToDatabase editDB = new AddToDatabase();
string projectNameEdit = "";
if (editProjectNameLabel.Text.Length > 0)
{
projectNameEdit = editProjectNameLabel.Text;
}
else
{
projectNameEdit = editTapeNameTextbox.Text;
}
//if there is text in tags textbox then add it on the end of the tag string
if (editTagsTextbox.TextLength > 0 && !editTagList.Contains(editTagsTextbox.Text.ToLower().Replace(",", "")))
{
editTagList.Add(editTagsTextbox.Text);
}
//Create new TapeDatabaseValues for edited entry
TapeDatabaseValues newTapeValues = new TapeDatabaseValues(
editTapeNameTextbox.Text, editTapeNumberUpDown.Value.ToString(), editProjectIDTextbox.Text, projectNameEdit,
commonMethod.GetCameraNumber(editCameraDropdown.Text), String.Join(",", editTagList), commonMethod.ConvertDateFromDropdownForDB(editDateShotDate.Value),
editTapeMasterListLabel.Text, editPersonDropdown.Text);
//Check if user made a change
if (CompareOldEditValues(newTapeValues))
{
//Update entry and check to make sure it is updated
if (editDB.UpdateTapeDatabase(newTapeValues, tapeValues))
{
//Enrty Update Successful
ClearEditControls();
tapeValues.Clear();
PopulateTapeList();
MakeBoxesVisible();
tapeListListView.Focus();
updateStatus.UpdateStatusBar("Values Updated in Database", mainform);
}
else
{
//Entry Update Unsuccessful
updateStatus.UpdateStatusBar("There Was A Problem Updated Entry", mainform);
}
}
else
{
//User Needs to change a value
updateStatus.UpdateStatusBar("Must Change At Least One Value", mainform);
}
}else
{
//project ID was NOT a number
updateStatus.UpdateStatusBar("Project ID must be a number", mainform);
}
}
