private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
UpdateDog();
}
catch (Exception ex)
{
UIMethods.ErrorHandler(ex);
}
}
private void cmbOwnerOwners_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
LoadOwnership();
}
catch (Exception ex)
{
UIMethods.ErrorHandler(ex);
}
}
private void lstColours_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
GetColourInfo();
}
catch (Exception ex)
{
UIMethods.ErrorHandler(ex);
}
}
private void btnDeleteOwner_Click(object sender, EventArgs e)
{
try
{
DeleteOwner();
}
catch (Exception ex)
{
UIMethods.ErrorHandler(ex);
}
}
private void frmChangeOwnership_Load(object sender, EventArgs e)
{
try
{
Reload();
}
catch (Exception ex)
{
UIMethods.ErrorHandler(ex);
}
}
private void btnNewShow_Click(object sender, EventArgs e)
{
try
{
UIMethods.OpenForm(MdiParent, new frmAddDogShow());
}
catch (Exception ex)
{
UIMethods.ErrorHandler(ex);
}
}
private void btnNewOwner_Click(object sender, EventArgs e)
{
try
{
UIMethods.OpenForm(this.MdiParent, new frmAddOwner());
}
catch (Exception ex)
{
UIMethods.ErrorHandler(ex);
}
}
private void lstDogs_DoubleClick(object sender, EventArgs e)
{
try
{
OpenDogInfo();
}
catch (Exception ex)
{
UIMethods.ErrorHandler(ex);
}
}
private void btnCancel_Click(object sender, EventArgs e)
{
try
{
Close();
}
catch (Exception ex)
{
UIMethods.ErrorHandler(ex);
}
}
private void frmUpdateDog_Load(object sender, EventArgs e)
{
try
{
Reload();
}
catch (Exception ex)
{
UIMethods.ErrorHandler(ex);
}
}
private void btnChangeOwner_Click(object sender, EventArgs e)
{
try
{
Form form = UIMethods.OpenForm(MdiParent, new frmUpdateOwner());
((ListBox)form.Controls["grpOwners"].Controls["lstOwners"]).SelectedValue = cmbSelectOwner.SelectedValue;
}
catch (Exception ex)
{
UIMethods.ErrorHandler(ex);
}
}
private void btnChangeOwnership_Click(object sender, EventArgs e)
{
try
{
Form form = UIMethods.OpenForm(MdiParent, new frmChangeOwnership());
((ComboBox)form.Controls["grpByOwner"].Controls["grpNames"].Controls["cmbOwners"]).SelectedValue = cmbSelectOwner.SelectedValue;
}
catch (Exception ex)
{
UIMethods.ErrorHandler(ex);
}
}
/// <summary>
/// Open the info on the dog that is currently selected in the dogs list
/// </summary>
private void OpenDogInfo()
{
try
{
Form form = UIMethods.OpenForm(MdiParent, new frmDogs());
((ListBox)form.Controls["grpDogs"].Controls["lstDogs"]).SelectedValue = lstDogs.SelectedValue;
}
catch (Exception ex)
{
UIMethods.ErrorHandler(ex);
}
}
private void btnChangeDogShow_Click(object sender, EventArgs e)
{
try
{
Form form = UIMethods.OpenForm(MdiParent, new frmChangeDogShow());
((ComboBox)form.Controls["grpDogShow"].Controls["cmbSelectedDogShow"]).SelectedValue = cmbDogShows.SelectedValue;
}
catch (Exception ex)
{
UIMethods.ErrorHandler(ex);
}
}
private void cmbSelectOwner_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
currentID = Convert.ToInt32(cmbSelectOwner.SelectedValue);
LoadOwnerDetails();
}
catch (Exception ex)
{
UIMethods.ErrorHandler(ex);
}
}
private void DeleteOwner()
{
if (DatabaseHelper.ValueExists("OwnerID", currentID.ToString(), "DogOwnership"))
{
MessageBox.Show("Cannot remove an owner which is listed owning dogs.", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
string sql = $"DELETE FROM Owners WHERE OwnerID = {currentID};";
int rowsAffected = DatabaseHelper.SendData(sql);
UIMethods.DisplayStatusMessage(((MDIParent)MdiParent).GetStatusLabel(), $"{rowsAffected} row(s) deleted");
}
void Start()
{
Debug.Log("Start bliver kaldt igen");
barCodeReader = new BarcodeReader();
uiMethods = FindObjectOfType <UIMethods>();
uiMethods.Hide(GameObject.Find("Canvas full"));
uiMethods.Show(GameObject.Find("Canvas Start"));
StartCoroutine(InitializeCamera());
}
/// <summary>
/// Update the class
/// </summary>
private void UpdateClass()
{
int id = Convert.ToInt32(lstClasses.SelectedValue);
if (ValidateFields())
{
string sql = $"UPDATE Classes SET Class = '{className}' WHERE ClassID = {id};";
int rowsAffected = DatabaseHelper.SendData(sql);
UIMethods.DisplayStatusMessage(((frmMDIParent)MdiParent).GetStatusLabel(), $"{rowsAffected} row(s) affected");
((frmMDIParent)MdiParent).ReloadAllChildForms();
}
}
private void ConditionsTextBox_TextChanged(object sender, TextChangedEventArgs e)
{
if (_indexOfConstructorTextBoxEdittedByTheMoment != -1)
{
Grid ConstructorConditionGrid =
UIMethods.GetUIElementChildByNumberFromTemplatedListBox(Constructor, _indexOfConstructorTextBoxEdittedByTheMoment, 0) as Grid;
TextBox ConstructorConditionTextBox = ConstructorConditionGrid.Children[1] as TextBox;
ConstructorConditionTextBox.Text = ConditionsTextBox.Text;
}
}
/// <summary>
/// Insert the owner info into the database
/// </summary>
private void InsertOwner()
{
string sql = $@"INSERT INTO Owners
(FirstName, MiddleName, LastName, DOB, DateOfRetirement, Retired)
VALUES
('{fName}', {mName}, '{lName}', '{dob}', {dateOfRetirement}, {isRetired});" ;
int rowsAffected = DatabaseHelper.SendData(sql);
UIMethods.DisplayStatusMessage(((frmMDIParent)MdiParent).GetStatusLabel(), $"{rowsAffected} row(s) added");
UIMethods.ClearControls(Controls);
((frmMDIParent)MdiParent).ReloadAllChildForms();
}
// Use this for initialization
void Start()
{
featureMatcher = new FeatureMatcher();
imageList = new ImageList();
ui = GameObject.Find("UIScripts").GetComponent <UIMethods>();
ui.Hide(GameObject.Find("Panel"));
InAppBrowserBridge bridge = GameObject.Find("InAppBrowserBridge").GetComponent <InAppBrowserBridge>();
bridge.onJSCallback.AddListener(OnMessageFromJS);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
Form form = UIMethods.OpenForm(MdiParent, new frmUpdateDog());
((ComboBox)form.Controls["grpDogInfo"].Controls["cmbDogToUpdate"]).SelectedValue = lstDogs.SelectedValue;
}
catch (Exception ex)
{
UIMethods.ErrorHandler(ex);
}
}
public InvoiceManagement()
{
InitializeComponent();
Column staffIDCol = DB.Tables.Where(t => t.Name == "Dog").First().Columns[1];
tbxClientID = (ValidatedTextbox)UIMethods.GenAppropriateElement(staffIDCol, out _);
tbxClientID.AddTextChangedEvent(TbxClientID_TextChanged);
tbxClientID.Text = "0";
tbxClientID.Margin = new Thickness(110, 5, 0, 0);
grd.Children.Add(tbxClientID);
}
private void btnPrev_Click(object sender, EventArgs e)
{
try
{
int previousID = Convert.ToInt32(OwnerNavigation()["PreviousID"]);
currentID = previousID != -1 ? previousID : Convert.ToInt32(OwnerNavigation()["LastID"]);
cmbSelectOwner.SelectedValue = currentID;
}
catch (Exception ex)
{
UIMethods.ErrorHandler(ex);
}
}
private void btnNext_Click(object sender, EventArgs e)
{
try
{
int nextId = Convert.ToInt32(OwnerNavigation()["NextID"]);
currentID = nextId != -1 ? nextId : Convert.ToInt32(OwnerNavigation()["FirstID"]);
cmbSelectOwner.SelectedValue = currentID;
}
catch (Exception ex)
{
UIMethods.ErrorHandler(ex);
}
}
private bool AreTheTextFieldsFilledDifferently()
{
var textResultsBodies = _textResults.Select(textR => textR.Body.ToUpperInvariant());
if (GeneralMethods.AreThereSameElementsInTheStringCollection(textResultsBodies, out string textResultElement))
{
UIMethods.FindCurrentTextInTextBoxesOfTheTemplatedListBox(PossibleResultTextsListBox, 1, textResultElement, "По крайней мере два текстовых результата совпадают. Удалите ненужные либо переименуйте.");
return(false);
}
return(true);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
Form form = UIMethods.OpenForm(MdiParent, new frmUpdateBreed());
((ListBox)form.Controls["grpBreeds"].Controls["lstBreeds"]).SelectedValue = lstBreeds.SelectedValue;
}
catch (Exception ex)
{
UIMethods.ErrorHandler(ex);
}
}
/// <summary>
/// Load program data on from load
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmSplashScreen_Load(object sender, EventArgs e)
{
try
{
lblName.Text = Application.ProductName;
lblCompany.Text = Application.CompanyName;
lblVersion.Text = Application.ProductVersion;
}
catch (Exception ex)
{
UIMethods.ErrorHandler(ex);
}
}
/// <summary>
/// Insert the breed info into the database
/// </summary>
private void AddBreed()
{
string sql = $@"
INSERT INTO Breeds
(Breed, PrimaryCoatColour, SecondaryCoatColour, [Classification])
Values
('{breedName}', {primaryId}, {secondaryId}, {classId});" ;
int rowsAffected = DatabaseHelper.SendData(sql);
UIMethods.DisplayStatusMessage(((frmMDIParent)MdiParent).GetStatusLabel(), $"{rowsAffected} row(s) added");
UIMethods.ClearControls(Controls);
((frmMDIParent)MdiParent).ReloadAllChildForms();
}
/// <summary>
/// Set the enabled property of the datetimepickers to the equivelent checkbox
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void EnableDateTimePickers(object sender, EventArgs e)
{
try
{
dtpChampionshipDate.Enabled = chkChampion.Checked;
dtpDateBanned.Enabled = chkBanned.Checked;
dtpDateOfRetirement.Enabled = chkRetired.Checked;
}
catch (Exception ex)
{
UIMethods.ErrorHandler(ex);
}
}
