//New Product Button Click
private void NewProductCreateButton_Click(object sender, RoutedEventArgs e)
{
this.NewProductCreateButton.IsEnabled = false;
Mouse.OverrideCursor = Cursors.Wait;
MySqlNaceassaryElement mysqlNecessaryFunction = new MySqlNaceassaryElement();
try
{
if (this.NewProductTextBoxCompanyName.Text != string.Empty && this.NewProductTextBoxProductName.Text != string.Empty && this.NewProductTextBoxModelNumber.Text != string.Empty && (this.NewProductTextBoxProductID.Text != string.Empty || this.NewProductCheckBoxAutoGenerate.IsChecked.Equals(true)))
{
if (!this.NewProductCheckBoxAutoGenerate.IsChecked.Equals(true))
{
if (this.NewProductTextBoxProductID.Text != string.Empty)
{
if (!mysqlNecessaryFunction.MysqlValueChecker(string.Format("SELECT * FROM {0} WHERE {1}='{2}'", Variables.TABLE_NAME[11], Variables.COLUMN_NAME[4], this.NewProductTextBoxProductID.Text)))
{
throw new PetuniaException(Variables.ERROR_MESSAGES[0, 9]);
}
}
else
{
throw new PetuniaException(Variables.ERROR_MESSAGES[0, 5]);
}
}
else
{
this.NewProductTextBoxProductID.Text = mysqlNecessaryFunction.ProductIDIs(Variables.TABLE_NAME[11], Variables.COLUMN_NAME[4]);
}
this.NewProductTextBoxProductID.Text = new NecessaryFunction().SixDigitNumber(this.NewProductTextBoxProductID.Text);
if (!mysqlNecessaryFunction.MysqlValueChecker(string.Format("SELECT * FROM {0} WHERE {1}='{2}' AND {3}='{4}' AND {5}='{6}'", Variables.TABLE_NAME[11], Variables.COLUMN_NAME[7], this.NewProductTextBoxCompanyName.Text, Variables.COLUMN_NAME[10], this.NewProductTextBoxProductName.Text, Variables.COLUMN_NAME[11], this.NewProductTextBoxModelNumber.Text)) | !mysqlNecessaryFunction.DatabaseOperation(string.Format("SELECT * FROM {0} WHERE {1}='{2}'", Variables.TABLE_NAME[4], Variables.COLUMN_NAME[4], this.NewProductTextBoxProductID.Text)))
{
throw new PetuniaException(Variables.ERROR_MESSAGES[0, 10]);
}
else
{
if (mysqlNecessaryFunction.DatabaseOperation(string.Format("INSERT INTO {0} VALUES ('{1}','{2}','{3}','{4}','{5}','{6}')", Variables.TABLE_NAME[11], this.NewProductTextBoxProductID.Text, DateTime.Now.ToString("yyyy-MM-dd"), this.NewProductTextBoxCompanyName.Text, this.NewProductTextBoxProductName.Text, this.NewProductTextBoxModelNumber.Text, this.NewProductTextBoxDescription.Text)))
{
mysqlNecessaryFunction.DatabaseOperation(string.Format("INSERT INTO {0} VALUES ('{1}',0,0,0,NULL)", Variables.TABLE_NAME[4], this.NewProductTextBoxProductID.Text));
throw new SuccessfullException(Variables.ERROR_MESSAGES[0, 11]);
}
else
{
throw new PetuniaException(Variables.ERROR_MESSAGES[0, 2]);
}
}
}
else
{
throw new PetuniaException(Variables.ERROR_MESSAGES[0, 5]);
}
}
catch (SuccessfullException success)
{
Mouse.OverrideCursor = null;
Microsoft.Windows.Controls.MessageBox.Show(success.Message, ProcestaVariables.Variables.ERROR_MESSAGES[0, 0], MessageBoxButton.OK, MessageBoxImage.Information);
}
catch (Exception error)
{
Mouse.OverrideCursor = null;
Microsoft.Windows.Controls.MessageBox.Show(error.Message, ProcestaVariables.Variables.ERROR_MESSAGES[0, 0], MessageBoxButton.OK, MessageBoxImage.Stop);
}
finally
{
Mouse.OverrideCursor = null;
this.NewProductCreateButton.IsEnabled = true;
mysqlNecessaryFunction.Dispose();
}
}
//Edit NewProduct Update Button
private void EditNewProductUpdateClick(object sender, System.Windows.RoutedEventArgs e)
{
this.EditNewProductButtonUpdate.IsEnabled = false;
MySqlNaceassaryElement mysqlNecessaryFunction = new MySqlNaceassaryElement();
try
{
MessageBoxResult tempDiglogBoxResult = Microsoft.Windows.Controls.MessageBox.Show(Variables.ERROR_MESSAGES[1, 11], Variables.ERROR_MESSAGES[0, 0], MessageBoxButton.YesNo, MessageBoxImage.Question);
Mouse.OverrideCursor = Cursors.Wait;
if (tempDiglogBoxResult.Equals(MessageBoxResult.Yes))
{
if (this.EditNewProductTextBoxCompanyName.Text != string.Empty && this.EditNewProductTextBoxProductName.Text != string.Empty && this.EditNewProductTextBoxModelNumber.Text != string.Empty && this.EditNewProductProductInfo.ModelNumberIs != string.Empty)
{
if (mysqlNecessaryFunction.MysqlValueChecker(string.Format("SELECT * FROM {0} WHERE {1}='{2}' AND {3}='{4}' AND {5}='{6}'", Variables.TABLE_NAME[11], Variables.COLUMN_NAME[7], this.EditNewProductTextBoxCompanyName.Text, Variables.COLUMN_NAME[10], this.EditNewProductTextBoxProductName.Text, Variables.COLUMN_NAME[11], this.EditNewProductTextBoxModelNumber.Text)))
{
mysqlNecessaryFunction.DatabaseOperation(string.Format("UPDATE {0} SET {1}='{2}',{3}='{4}',{5}='{6}' WHERE {7}='{8}'", Variables.TABLE_NAME[11], Variables.COLUMN_NAME[7], this.EditNewProductTextBoxCompanyName.Text, Variables.COLUMN_NAME[10], this.EditNewProductTextBoxProductName.Text, Variables.COLUMN_NAME[11], this.EditNewProductTextBoxModelNumber.Text, Variables.COLUMN_NAME[4], this.EditNewProductLabelProductID.Text));
this.EditNewProductProductInfo.CompanyNameLoader();
throw new SuccessfullException(Variables.ERROR_MESSAGES[0, 11]);
}
else
{
throw new PetuniaException(Variables.ERROR_MESSAGES[0, 10]);
}
}
else
{
throw new PetuniaException(Variables.ERROR_MESSAGES[0, 5]);
}
}
}
catch (SuccessfullException success)
{
Mouse.OverrideCursor = null;
Microsoft.Windows.Controls.MessageBox.Show(success.Message, Variables.ERROR_MESSAGES[0, 0], MessageBoxButton.OK, MessageBoxImage.Information);
}
catch (Exception error)
{
Mouse.OverrideCursor = null;
Microsoft.Windows.Controls.MessageBox.Show(error.Message, Variables.ERROR_MESSAGES[0, 0], MessageBoxButton.OK, MessageBoxImage.Stop);
}
finally
{
Mouse.OverrideCursor = null;
mysqlNecessaryFunction.Dispose();
this.EditNewProductButtonUpdate.IsEnabled = true;
}
}
//New Party Create Button
private void NewPartyCreateClick(object sender, System.Windows.RoutedEventArgs e)
{
this.NewParyButtonCreate.IsEnabled = false;
Mouse.OverrideCursor = Cursors.Wait;
MySqlNaceassaryElement mysqlNecessaryFunction = new MySqlNaceassaryElement();
try
{
if (this.NewParyTextBoxUserID.Text != string.Empty && this.NewParyComboBoxAccountType.Text != string.Empty)
{
if (mysqlNecessaryFunction.MysqlValueChecker(string.Format("SELECT * FROM {0} WHERE {1}='{2}'", Variables.TABLE_NAME[10], Variables.COLUMN_NAME[3], this.NewParyTextBoxUserID.Text)))
{
mysqlNecessaryFunction.DatabaseOperation(string.Format("INSERT {0} VALUES ('{1}','{2}','{3}','{4}','{5}','{6}')", Variables.TABLE_NAME[10], this.NewParyTextBoxUserID.Text, this.NewParyComboBoxAccountType.Text, this.NewPartyTextBoxPhoneNumber.Text, this.NewPartyTextBoxEmail.Text, this.NewPartyTextBoxContractPerson.Text, this.NewpartyTextBoxAddress.Text));
mysqlNecessaryFunction.DatabaseOperation(string.Format("INSERT INTO {0} VALUES ('{1}',0)", Variables.TABLE_NAME[9], this.NewParyTextBoxUserID.Text));
throw new SuccessfullException(Variables.ERROR_MESSAGES[0, 11]);
}
else
{
throw new PetuniaException(Variables.ERROR_MESSAGES[1, 5]);
}
}
else
{
throw new PetuniaException(Variables.ERROR_MESSAGES[0, 5]);
}
}
catch (SuccessfullException success)
{
Mouse.OverrideCursor = null;
Microsoft.Windows.Controls.MessageBox.Show(success.Message, Variables.ERROR_MESSAGES[0, 0], MessageBoxButton.OK, MessageBoxImage.Information);
}
catch (Exception error)
{
Mouse.OverrideCursor = null;
Microsoft.Windows.Controls.MessageBox.Show(error.Message, Variables.ERROR_MESSAGES[0, 0], MessageBoxButton.OK, MessageBoxImage.Error);
}
finally
{
mysqlNecessaryFunction.Dispose();
this.NewParyButtonCreate.IsEnabled = true;
Mouse.OverrideCursor = null;
}
}