public void ComboBoxItemLoad(DevExpress.Xpf.Editors.ComboBoxEdit devComboBox, string query)
{
devComboBox.Items.Clear();
DataTable tempDataTable = new DataTable();
MySqlNaceassaryElement mysqlNecessaryFunction = new MySqlNaceassaryElement();
tempDataTable = mysqlNecessaryFunction.DataReader(query);
foreach (DataRow comboItems in tempDataTable.Rows)
{
devComboBox.Items.Add(comboItems[0]);
}
}
//ProductID Finder
public string ProductIDFinder(string companyName, string productName, string modelNumber)
{
DataTable tempDataTable = new MySqlNaceassaryElement().DataReader(string.Format("SELECT {0} FROM {1} WHERE {2}='{3}' AND {4}='{5}' AND {6}='{7}'", Variables.COLUMN_NAME[4], Variables.TABLE_NAME[11], Variables.COLUMN_NAME[7], companyName, Variables.COLUMN_NAME[10], productName, Variables.COLUMN_NAME[11], modelNumber));
if (tempDataTable.Rows.Count > 0)
{
DataRow productIDDataRow = tempDataTable.Rows[0];
return (string)productIDDataRow[0];
}
else
{
return "";
}
}
//Debtors Creditors Account Info Viewer
public void DebtorsCreditorsAccountInfoViewer(TextBlock contractPerson, TextBlock phone, TextBlock Email, TextBlock Address, TextBlock Amount, string userID)
{
DataTable temDataTable = new MySqlNaceassaryElement().DataReader(string.Format("SELECT * FROM {0},{1} WHERE {0}.{2}='{3}' AND {0}.{2}={1}.{2}", Variables.TABLE_NAME[10],Variables.TABLE_NAME[9], Variables.COLUMN_NAME[3], userID));
if (temDataTable.Rows.Count > 0)
{
DataRow temDataRow = temDataTable.Rows[0];
contractPerson.Text = temDataRow[4].ToString();
phone.Text = temDataRow[2].ToString();
Email.Text = temDataRow[3].ToString();
Address.Text = temDataRow[5].ToString();
Amount.Text = temDataRow[7].ToString();
}
temDataTable.Dispose();
}
//Sock info Quantity and Rate
public void StockInfoLoad(TextBlock productID, TextBlock textBlockQuantity, TextBlock textBlockWaitAndAvarageRate, string ProductID)
{
DataTable tempDataTable = new MySqlNaceassaryElement().DataReader(string.Format("SELECT * FROM {0} WHERE {1} ='{2}'", Variables.TABLE_NAME[4], Variables.COLUMN_NAME[4], ProductID));
if (tempDataTable.Rows.Count > 0)
{
DataRow tempDataRow = tempDataTable.Rows[0];
productID.Text = Convert.ToString(tempDataRow[0]);
textBlockQuantity.Text =Convert.ToString(tempDataRow[1]);
textBlockWaitAndAvarageRate.Text = Convert.ToString(tempDataRow[2]);
}
else
{
return;
}
}
//Debtor and Creditors Account Info Loader
public bool DebtorAndCreditorAccountLoader(TextBlock amount, string userName)
{
DataTable tempDataTable = new MySqlNaceassaryElement().DataReader(string.Format("SELECT * FROM {0} WHERE {1}='{2}'", Variables.TABLE_NAME[9], Variables.COLUMN_NAME[3], userName));
if (tempDataTable.Rows.Count > 0)
{
DataRow temDataRow = tempDataTable.Rows[0];
amount.Text = temDataRow[1].ToString();
tempDataTable.Dispose();
return true;
}
else
{
tempDataTable.Dispose();
return false;
}
}
//Stock Info By Group
public bool StockInfoByGroup(WrapPanel panelStockInfo, string query)
{
try
{
panelStockInfo.Children.Clear();
DataTable tempDataTable = new MySqlNaceassaryElement().DataReader(query);
foreach (DataRow tempDatRow in tempDataTable.Rows)
{
StockInfoByGroup tempStockInfoGroup = new StockInfoByGroup();
tempStockInfoGroup.StockInfoGroupDataContext(tempDatRow);
panelStockInfo.Children.Add(tempStockInfoGroup);
}
tempDataTable.Dispose();
return true;
}
catch
{
return false;
}
}
private void startupWorker(object sender, DoWorkEventArgs e)
{
Thread.Sleep(800);
stratupWindowLogingMessages.AnimationText = "Connecting....";
stratupBackgroundWorker.ReportProgress(1);
Thread.Sleep(1000);
MySqlNaceassaryElement.DatabaseConnectionInfo[0] = Properties.Settings.Default.DatabaseServerip;
MySqlNaceassaryElement.DatabaseConnectionInfo[1] = Properties.Settings.Default.DatabasePortNumber;
MySqlNaceassaryElement.DatabaseConnectionInfo[2] = "petunia2.0";
MySqlNaceassaryElement.DatabaseConnectionInfo[3] = Properties.Settings.Default.DatabaseUserName;
MySqlNaceassaryElement.DatabaseConnectionInfo[4] = Properties.Settings.Default.DatabasePassword;
bool databaseConnectionTest;
try
{
databaseConnectionTest = new MySqlNaceassaryElement().ConnectToMysql(Properties.Settings.Default.DarabaseDefultDatabase, Properties.Settings.Default.DatabaseServerip, Properties.Settings.Default.DatabasePortNumber, Properties.Settings.Default.DatabaseUserName, Properties.Settings.Default.DatabasePassword);
}
catch
{
databaseConnectionTest = false;
}
if (databaseConnectionTest)
{
stratupBackgroundWorker.ReportProgress(2);
Thread.Sleep(1000);
stratupWindowLogingMessages.AnimationText = "Loading....";
stratupBackgroundWorker.ReportProgress(3);
Thread.Sleep(2000);
stratupBackgroundWorker.ReportProgress(4);
Thread.Sleep(500);
stratupBackgroundWorker.ReportProgress(5);
Thread.Sleep(600);
}
else
{
stratupBackgroundWorker.ReportProgress(6);
}
}
private void strtaupProcess(object sender, ProgressChangedEventArgs e)
{
if (e.ProgressPercentage.Equals(1))
{
stratupWindowLogingMessages.AnimationArrivalBegin = true;
}
else if (e.ProgressPercentage.Equals(2))
{
stratupWindowLogingMessages.AnimationLeaveBegin = true;
}
else if (e.ProgressPercentage.Equals(3))
{
stratupWindowLogingMessages.AnimationArrivalBegin = true;
}
else if (e.ProgressPercentage.Equals(4))
{
MySqlNaceassaryElement mysqlNecessaryFunction = new MySqlNaceassaryElement();
MysqlBackupVariablesClass.MYSQL_CONNECTION_STRING[0] = Properties.Settings.Default.DatabaseServerip;
MysqlBackupVariablesClass.MYSQL_CONNECTION_STRING[1]=Properties.Settings.Default.DatabasePortNumber;
MysqlBackupVariablesClass.MYSQL_CONNECTION_STRING[2] = Properties.Settings.Default.DarabaseDefultDatabase;
MysqlBackupVariablesClass.MYSQL_CONNECTION_STRING[3]=Properties.Settings.Default.DatabaseUserName;
MysqlBackupVariablesClass.MYSQL_CONNECTION_STRING[4]=Properties.Settings.Default.DatabasePassword;
new MysqlDataBackupRestoreClass().DataBaseRestore("Petunia2.0");
new Variables().InitializeLoaclData();
new AccountClass().StartupDataBaseChecker(new DBQueres(mysqlNecessaryFunction.DatabaseOperation), new DatabaseRead(mysqlNecessaryFunction.DataReader), new MysqlRowCounter(mysqlNecessaryFunction.MysqlRowsIs));
}
else if (e.ProgressPercentage.Equals(5))
{
stratupWindowLogingMessages.AnimationLeaveBegin = true;
}
else if (e.ProgressPercentage.Equals(6))
{
flagDatabaseError = true;
Microsoft.Windows.Controls.MessageBox.Show(Variables.ERROR_MESSAGES[0, 1], Variables.ERROR_MESSAGES[0, 0], MessageBoxButton.OK, MessageBoxImage.Error);
new WindowDataBaseSetting().ShowDialog();
this.Close();
}
}
//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;
}
}
//Edit NewProduct Search Button
private void EditNewProductSearchClick(object sender, System.Windows.RoutedEventArgs e)
{
this.EditNewProductButtonSearch.IsEnabled = false;
Mouse.OverrideCursor = Cursors.Wait;
string mysqlQuery = string.Empty;
DataTable tempDataTable = new DataTable();
try
{
if (EditNewProductRadioButtonByProductInfo.IsChecked.Equals(true))
{
if (this.EditNewProductProductInfo.CompanyNameIs != string.Empty && this.EditNewProductProductInfo.ProductNameIs != string.Empty && this.EditNewProductProductInfo.ModelNumberIs != string.Empty)
{
mysqlQuery = string.Format("SELECT * FROM {0} WHERE {1}='{2}' AND {3}='{4}' AND {5}='{6}'", Variables.TABLE_NAME[11], Variables.COLUMN_NAME[7], this.EditNewProductProductInfo.CompanyNameIs, Variables.COLUMN_NAME[10], this.EditNewProductProductInfo.ProductNameIs, Variables.COLUMN_NAME[11], this.EditNewProductProductInfo.ModelNumberIs);
}
else
{
throw new PetuniaException(Variables.ERROR_MESSAGES[0, 5]);
}
}
if (EditNewProductRadioButtonByProductID.IsChecked.Equals(true))
{
if (EditNewProductTextBoxProductID.Text != string.Empty)
{
mysqlQuery = string.Format("SELECT * FROM {0} WHERE {1}='{2}'", Variables.TABLE_NAME[11], Variables.COLUMN_NAME[4], new NecessaryFunction().SixDigitNumber(this.EditNewProductTextBoxProductID.Text));
}
else
{
throw new PetuniaException(Variables.ERROR_MESSAGES[0, 5]);
}
}
tempDataTable = new MySqlNaceassaryElement().DataReader(mysqlQuery);
if (tempDataTable.Rows.Count > (0))
{
DataRow tempTableRow = tempDataTable.Rows[0];
this.EditNewProductTextBoxCompanyName.Text = tempTableRow[2].ToString();
this.EditNewProductTextBoxProductName.Text = tempTableRow[3].ToString();
this.EditNewProductTextBoxModelNumber.Text = tempTableRow[4].ToString();
this.EditNewProductTextBoxDescription.Text = tempTableRow[5].ToString();
this.EditNewProductLabelProductID.Text = tempTableRow[0].ToString();
this.EditNewProductButtonSearch.IsEnabled = true;
}
else
{
throw new PetuniaException(Variables.ERROR_MESSAGES[1, 10]);
}
}
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;
tempDataTable.Dispose();
mysqlQuery = null;
this.EditNewProductButtonSearch.IsEnabled = true;
}
}
//Debtor Payment Search Button Click
private void DebtorPaymentButtonSearchClick(object sender, System.Windows.RoutedEventArgs e)
{
this.DebtorsCredtorsPaymentButtonSearch.IsEnabled = false;
Mouse.OverrideCursor = Cursors.Wait;
try
{
if (this.DebtorsCredtorsPaymentTextBoxName.Text != string.Empty)
{
DataTable tempDataTable = new MySqlNaceassaryElement().DataReader(string.Format("SELECT * FROM {0} WHERE {1}='{2}' AND {3}='{4}'", Variables.TABLE_NAME[10], Variables.COLUMN_NAME[3], this.DebtorsCredtorsPaymentTextBoxName.Text, Variables.COLUMN_NAME[12], this.DebtorCredtorsPaymentLabelHeader.Text));
if (tempDataTable.Rows.Count > 0)
{
this.DebtorsCredtorsPaymentComboBoxName.Text = this.DebtorsCredtorsPaymentTextBoxName.Text;
tempDataTable.Dispose();
}
else
{
tempDataTable.Dispose();
throw new PetuniaException(Variables.ERROR_MESSAGES[1, 8]);
}
}
else
{
throw new PetuniaException(Variables.ERROR_MESSAGES[0, 5]);
}
}
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;
this.DebtorsCredtorsPaymentButtonSearch.IsEnabled = true;
}
}
//Debtor Payment Payment Click
private void DebtorPaymentButtonPamentClick(object sender, System.Windows.RoutedEventArgs e)
{
this.DebtorsCredtorsPaymentButtonPayment.IsEnabled = false;
Mouse.OverrideCursor = Cursors.Wait;
DataSetPetunia commonDataUse = new DataSetPetunia();
bool debtors = false;
try
{
if (this.DebtorsCredtorsPaymentComboBoxName.Text != string.Empty && this.DebtorsCredtorsPaymentNumberBoxPaymentAmount.Text != string.Empty)
{
if (operationType.Equals(Variables.OperationTrypes.Debtors))
{
debtors = true;
}
DataTable tempadataTable = new MySqlNaceassaryElement().DataReader(string.Format("SELECT {0} FROM {1} WHERE {2}='{3}' ORDER BY {4}", Variables.COLUMN_NAME[4], Variables.TABLE_NAME[3], Variables.COLUMN_NAME[3], this.DebtorsCredtorsPaymentComboBoxName.Text, Variables.COLUMN_NAME[0]));
if (tempadataTable.Rows.Count > 0)
{
DataRow tempDataRow = tempadataTable.Rows[0];
commonDataUse.PetuniaCommonUse.Rows.Add(this.DebtorsCredtorsPaymentComboBoxName.Text, tempDataRow[0], new PetuniaNecessaryFunction().DateFromRadDatePicker(this.DebtorsCredtorsPaymentDateAndTimePicker), new NecessaryFunction().ComaSpriter(this.DebtorsCredtorsPaymentNumberBoxPaymentAmount.Text));
if (debtors ? new AccountClass().CreditorsAndDebtorsPayment(commonDataUse.PetuniaCommonUse, TransactionType.debt, new DatabaseRead(new MySqlNaceassaryElement().DataReader), new DBQueres(new MySqlNaceassaryElement().DatabaseOperation)) : new AccountClass().CreditorsAndDebtorsPayment(commonDataUse.PetuniaCommonUse, TransactionType.Credit, new DatabaseRead(new MySqlNaceassaryElement().DataReader), new DBQueres(new MySqlNaceassaryElement().DatabaseOperation)))
{
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, 2]);
}
}
else
{
throw new PetuniaException(Variables.ERROR_MESSAGES[0, 2]);
}
}
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
{
commonDataUse.Dispose();
this.DebtorsCredtorsPaymentButtonPayment.IsEnabled = true;
Mouse.OverrideCursor = null;
}
}
//Edit Party Info User ID Select Index Change
private void EditPartyInfoUserIDIndexChaged(object sender, System.Windows.RoutedEventArgs e)
{
Mouse.OverrideCursor = Cursors.Wait;
DataTable tempDatatable = new DataTable();
tempDatatable = new MySqlNaceassaryElement().DataReader(string.Format("SELECT * FROM {0} WHERE {1}='{2}'",Variables.TABLE_NAME[10],Variables.COLUMN_NAME[3],this.EditPartyInfoComboBoxUserID.Text));
if (tempDatatable.Rows.Count > 0)
{
DataRow tempDataRow = tempDatatable.Rows[0];
this.EditPartyInfoComboBoxAccountType.Text = tempDataRow[1].ToString();
this.EditPartyInfoTextBoxControctPerson.Text = tempDataRow[4].ToString();
this.EditParyInfoTextBoxPhoneNumber.Text = tempDataRow[2].ToString();
this.EditPartyInfoTextBoxEmail.Text = tempDataRow[3].ToString();
this.EditPartyInfoTextBoxAddress.Text = tempDataRow[5].ToString();
tempDatatable.Dispose();
Mouse.OverrideCursor = null;
return;
}
else
{
tempDatatable.Dispose();
Mouse.OverrideCursor = null;
return;
}
}
private void RechargeAmountComBoxBoxCompayNameSelectIndexChange(object sender, System.Windows.RoutedEventArgs e)
{
DataTable tempDataTable = new MySqlNaceassaryElement().DataReader(string.Format("SELECT {0} FROM {1} WHERE {2}='{3}'", Variables.COLUMN_NAME[1], Variables.TABLE_NAME[17], Variables.COLUMN_NAME[7], this.RechargeAmountComBoxBoxCompayName.Text));
if (tempDataTable.Rows.Count>0)
{
this.RechargeAmountTextBlockStockAmount.Text = tempDataTable.Rows[0][0].ToString();
}
}
//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();
}
}
//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;
}
}
// Add stock Update Button
private void AddStockUpdateClick(object sender, System.Windows.RoutedEventArgs e)
{
this.AddStockButtonAdd.IsEnabled = false;
Mouse.OverrideCursor = Cursors.Wait;
MySqlNaceassaryElement mysqlNecessaryFunction = new MySqlNaceassaryElement();
DataSetPetunia commonUseDataSet = new DataSetPetunia();
try
{
if (this.StockAddProductInfo.CompanyNameIs != string.Empty && this.StockAddProductInfo.ProductNameIs != string.Empty && this.StockAddProductInfo.ModelNumberIs != string.Empty && AddStockLabelProductIDInfo.Text != string.Empty && AddStockNumericUpDown.Value > 0 && AddStockTextBoxRate.Text != string.Empty && AddStockTextBoxInvoiceNUmber.Text != string.Empty && Convert.ToDouble(this.AddStockTextBoxRate.Text) > 0)
{
commonUseDataSet.PetuniaCommonUse.Rows.Add(this.AddStockLabelProductIDInfo.Text, new PetuniaNecessaryFunction().DateFromRadDatePicker(this.AddStockDatePicker), this.AddStockNumericUpDown.Value.ToString(), this.AddStockLabelRateInfo.Text, new NecessaryFunction().ComaSpriter(this.AddStockTextBoxRate.Text), this.AddStockLabelAmountNewInfo.Text, this.AddStockTextBoxInvoiceNote.Text, this.AddStockComboBoxCreditorsName.Text, this.AddStockTextBoxIssueName.Text, this.AddStockTextBoxInvoiceNUmber.Text, this.AddStockLabelCreditAmount.Text, new NecessaryFunction().ComaSpriter(this.AddStockTextBoxPaymentAmount.Text));
if (this.AddStockRadioButtonCash.IsChecked.Equals(true))
{
if (new AccountClass().Purchase(commonUseDataSet.PetuniaCommonUse, TransactionType.Cash, new DBQueres(mysqlNecessaryFunction.DatabaseOperation), new DatabaseRead(mysqlNecessaryFunction.DataReader)))
{
this.AddStockTextBoxInvoiceNUmber.Text = string.Empty;
throw new SuccessfullException(Variables.ERROR_MESSAGES[0, 11]);
}
else
{
throw new PetuniaException(Variables.ERROR_MESSAGES[0, 2]);
}
}
else if (this.AddStockRadioButtonCheeck.IsChecked.Equals(true))
{
if (new AccountClass().Purchase(commonUseDataSet.PetuniaCommonUse, TransactionType.check, new DBQueres(mysqlNecessaryFunction.DatabaseOperation), new DatabaseRead(mysqlNecessaryFunction.DataReader)))
{
this.AddStockTextBoxInvoiceNUmber.Text = string.Empty;
throw new SuccessfullException(Variables.ERROR_MESSAGES[0, 11]);
}
else
{
throw new PetuniaException(Variables.ERROR_MESSAGES[0, 2]);
}
}
else if (this.AddStockReadioButtonCredit.IsChecked.Equals(true))
{
if (this.AddStockComboBoxCreditorsName.Text != string.Empty && this.AddStockTextBoxPaymentAmount.Text != string.Empty && this.AddStockLabelCreditAmount.Text != string.Empty && Convert.ToDouble(this.AddStockLabelCreditAmount.Text) >= 0)
{
if (new AccountClass().Purchase(commonUseDataSet.PetuniaCommonUse, TransactionType.Credit, new DBQueres(mysqlNecessaryFunction.DatabaseOperation), new DatabaseRead(mysqlNecessaryFunction.DataReader)))
{
this.AddStockTextBoxInvoiceNUmber.Text = string.Empty;
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]);
}
}
else
{
throw new PetuniaException(Variables.ERROR_MESSAGES[1, 4]);
}
}
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;
this.AddStockButtonAdd.IsEnabled = true;
mysqlNecessaryFunction.Dispose();
commonUseDataSet.Dispose();
}
}
private void EditRechagreComboBoxCompanyNameSelectIndexChange(object sender, System.Windows.RoutedEventArgs e)
{
DataTable tempDataTable = new MySqlNaceassaryElement().DataReader(string.Format("SELECT * FROM {0} WHERE {1}='{2}'", Variables.TABLE_NAME[16], Variables.COLUMN_NAME[7], this.EditRechagreComboBoxCompanyName.Text));
if (tempDataTable.Rows.Count>0)
{
DataRow tempDataRow=tempDataTable.Rows[0];
this.EditRechagreTextBoxContractPerson.Text = tempDataRow[2].ToString();
this.EditRechagreTextBoxPhoneNumber.Text = tempDataRow[3].ToString();
}
tempDataTable.Dispose();
}
//Return Product Sales Search Click
private void ReturnProductSalesButtonSearchClick(object sender, System.Windows.RoutedEventArgs e)
{
this.ReturnProductSalesButtonSearch.IsEnabled = false;
Mouse.OverrideCursor = Cursors.Wait;
DataTable tempDataTable=new DataTable();
string tableName;
try
{
if (this.ReturnProductSalesLabelProductID.Text != string.Empty)
{
if (operationType.Equals(Variables.OperationTrypes.PurchaseReturn))
{
tableName = Variables.TABLE_NAME[12];
}
else if (operationType.Equals(Variables.OperationTrypes.SalesReturn))
{
tableName = Variables.TABLE_NAME[14];
}
else
{
throw new PetuniaException(Variables.ERROR_MESSAGES[0, 2]);
}
if (this.ReturnProductSalesRadioButtonbyAll.IsChecked.Equals(true))
{
tempDataTable = new MySqlNaceassaryElement().DataReader(string.Format("SELECT {11}.{0},{10}.{1},{10}.{2},{10}.{3},{11}.{4},{11}.{5},{11}.{6},{11}.{7},{11}.{8},{11}.{9} FROM {10},{11} WHERE {11}.{4}='{12}' AND {10}.{4}={11}.{4} ORDER BY {0}", Variables.COLUMN_NAME[0], Variables.COLUMN_NAME[7], Variables.COLUMN_NAME[10], Variables.COLUMN_NAME[11], Variables.COLUMN_NAME[4], Variables.COLUMN_NAME[6], Variables.COLUMN_NAME[5], Variables.COLUMN_NAME[1], Variables.COLUMN_NAME[15], Variables.COLUMN_NAME[13], Variables.TABLE_NAME[11], tableName, this.ReturnProductSalesLabelProductID.Text));
GridViewLoadProductHistory.Clear();
foreach (DataRow tempDataRow in tempDataTable.Rows)
{
GridViewLoadProductHistory.Add(new ProductHistory(tempDataRow[0].ToString().Substring(0, 9), tempDataRow[2].ToString(), tempDataRow[1].ToString(), tempDataRow[3].ToString(), tempDataRow[4].ToString(), tempDataRow[5].ToString(), tempDataRow[6].ToString(), tempDataRow[7].ToString(), tempDataRow[8].ToString(), tempDataRow[9].ToString()));
}
}
else if (this.ReturnProductSalesRadioButtonByDate.IsChecked.Equals(true))
{
tempDataTable = new MySqlNaceassaryElement().DataReader(string.Format("SELECT {11}.{0},{10}.{1},{10}.{2},{10}.{3},{11}.{4},{11}.{5},{11}.{6},{11}.{7},{11}.{8},{11}.{9} FROM {10},{11} WHERE {11}.{0}='{12}' AND {10}.{4}={11}.{4} ORDER BY {0}", Variables.COLUMN_NAME[0], Variables.COLUMN_NAME[7], Variables.COLUMN_NAME[10], Variables.COLUMN_NAME[11], Variables.COLUMN_NAME[4], Variables.COLUMN_NAME[6], Variables.COLUMN_NAME[5], Variables.COLUMN_NAME[1], Variables.COLUMN_NAME[15], Variables.COLUMN_NAME[13], Variables.TABLE_NAME[11], tableName, new PetuniaNecessaryFunction().DateFromRadDatePicker(this.ReturnProductSalesDateAndTime)));
GridViewLoadProductHistory.Clear();
foreach (DataRow tempDataRow in tempDataTable.Rows)
{
GridViewLoadProductHistory.Add(new ProductHistory(tempDataRow[0].ToString().Substring(0, 9), tempDataRow[2].ToString(), tempDataRow[1].ToString(), tempDataRow[3].ToString(), tempDataRow[4].ToString(), tempDataRow[5].ToString(), tempDataRow[6].ToString(), tempDataRow[7].ToString(), tempDataRow[8].ToString(), tempDataRow[9].ToString()));
}
}
else
{
throw new PetuniaException(Variables.ERROR_MESSAGES[1, 5]);
}
}
else
{
throw new PetuniaException(Variables.ERROR_MESSAGES[0, 5]);
}
}
catch (Exception error)
{
Mouse.OverrideCursor = null;
Microsoft.Windows.Controls.MessageBox.Show(error.Message, Variables.ERROR_MESSAGES[0, 0], MessageBoxButton.OK, MessageBoxImage.Stop);
}
finally
{
tempDataTable.Dispose();
tableName = null;
Mouse.OverrideCursor = null;
this.ReturnProductSalesButtonSearch.IsEnabled = true;
}
}
//check database string
private void DatabaseSettingConnectButtonClick(object sender, System.Windows.RoutedEventArgs e)
{
MySqlNaceassaryElement mysqlNecessaryFunction = new MySqlNaceassaryElement();
NecessaryFunction necessaryElement = new NecessaryFunction();
this.DatabaseSettingConnectButton.IsEnabled = false;
if (DatabaseSettingtextboxUsername.Text != string.Empty && DatabaseSettingtextboxPassword.Password != string.Empty && DatabaseSettingtextboxConformPassword.Password != string.Empty && DatabaseSettingtextboxHostIP.Text != string.Empty && DatabaseSettingtextboxPortNumber.Text != string.Empty && DatabaseSettingtextboxPortNumber.Text != string.Empty && DatabaseSettingtextboxDatabaseName.Text != string.Empty && necessaryElement.PasswordIs(DatabaseSettingtextboxPassword.Password, DatabaseSettingtextboxConformPassword.Password))
{
if (mysqlNecessaryFunction.ConnectToMysql(this.DatabaseSettingtextboxDatabaseName.Text,this.DatabaseSettingtextboxHostIP.Text,this.DatabaseSettingtextboxPortNumber.Text,this.DatabaseSettingtextboxUsername.Text,this.DatabaseSettingtextboxConformPassword.Password))
{
Properties.Settings.Default.DatabaseServerip = this.DatabaseSettingtextboxHostIP.Text;
Properties.Settings.Default.DatabasePortNumber = this.DatabaseSettingtextboxPortNumber.Text;
Properties.Settings.Default.DarabaseDefultDatabase = this.DatabaseSettingtextboxDatabaseName.Text;
Properties.Settings.Default.DatabaseUserName = this.DatabaseSettingtextboxUsername.Text;
Properties.Settings.Default.DatabasePassword = DatabaseSettingtextboxConformPassword.Password;
Properties.Settings.Default.Save();
Microsoft.Windows.Controls.MessageBox.Show(ProcestaVariables.Variables.ERROR_MESSAGES[0, 8], ProcestaVariables.Variables.ERROR_MESSAGES[0, 0], MessageBoxButton.OK, MessageBoxImage.Information);
System.Windows.Forms.Application.Restart();
Application.Current.Shutdown();
}
else
{
Microsoft.Windows.Controls.MessageBox.Show(ProcestaVariables.Variables.ERROR_MESSAGES[0, 1], ProcestaVariables.Variables.ERROR_MESSAGES[0, 0], MessageBoxButton.OK, MessageBoxImage.Error);
this.DatabaseSettingConnectButton.IsEnabled = true;
}
}
else
{
Microsoft.Windows.Controls.MessageBox.Show(ProcestaVariables.Variables.ERROR_MESSAGES[0, 1] + Environment.NewLine + ProcestaVariables.Variables.ERROR_MESSAGES[0, 7], ProcestaVariables.Variables.ERROR_MESSAGES[0, 0], MessageBoxButton.OK, MessageBoxImage.Stop);
this.DatabaseSettingConnectButton.IsEnabled = true;
}
}
// Stock info All
public void StockInfoLoad(TextBlock productID, TextBlock quantity, TextBlock WaitAndAvarageRate, TextBlock Dabit, string ProductIDInternal)
{
DataTable tempDataTable = new MySqlNaceassaryElement().DataReader(string.Format("SELECT * FROM {0} WHERE {1} ='{2}'", Variables.TABLE_NAME[4], Variables.COLUMN_NAME[4], ProductIDInternal));
if (tempDataTable.Rows.Count > 0)
{
DataRow tempDataRow = tempDataTable.Rows[0];
productID.Text = (string)tempDataRow[0];
quantity.Text = (string)(tempDataRow[1]).ToString();
WaitAndAvarageRate.Text = (string)(tempDataRow[3]).ToString();
Dabit.Text = (string)(tempDataRow[2]).ToString();
tempDataTable.Dispose();
}
else
{
tempDataTable.Dispose();
return;
}
}
private void SummaryButtonSearchClick(object sender, System.Windows.RoutedEventArgs e)
{
this.SummaryButtonSearch.IsEnabled = false;
Mouse.OverrideCursor = Cursors.Wait;
DataTable tempdateTable = new DataTable();
MySqlNaceassaryElement mysqElement = new MySqlNaceassaryElement();
try
{
if (this.SummaryDate.SelectedDate.ToString() != string.Empty)
{
string tempDate = new PetuniaNecessaryFunction().DateFromRadDatePicker(this.SummaryDate);
tempdateTable = mysqElement.DataReader(string.Format("SELECT {0} FROM {1} WHERE {2} BETWEEN '{3}' AND '{4}'", Variables.COLUMN_NAME[1], Variables.TABLE_NAME[2], Variables.COLUMN_NAME[0], new NecessaryFunction().MysqlDateFormate(((DateTime)this.SummaryDate.SelectedDate).AddDays(-1).ToString()), tempDate));
if (tempdateTable.Rows.Count > 0)
{
DataRow tempDataRow = tempdateTable.Rows[0];
this.TotalSummary.EndingCash = tempDataRow[0].ToString();
try
{
tempDataRow = tempdateTable.Rows[1];
this.TotalSummary.StartingCash = tempDataRow[0].ToString();
}
catch
{
this.TotalSummary.StartingCash = Variables.ERROR_MESSAGES[2, 1];
}
}
tempdateTable = mysqElement.DataReader(string.Format("SELECT SUM({0}),SUM({1}) FROM {2} WHERE {3}='{4}'", Variables.COLUMN_NAME[6], Variables.COLUMN_NAME[1], Variables.TABLE_NAME[12], Variables.COLUMN_NAME[0], tempDate));
if (tempdateTable.Rows.Count > 0)
{
DataRow tempDataRow = tempdateTable.Rows[0];
this.TotalSummary.PurchasQuantity = tempDataRow[0].ToString();
this.TotalSummary.PurchaseAmount = tempDataRow[1].ToString();
}
tempdateTable = mysqElement.DataReader(string.Format("SELECT SUM({0}),SUM({1}) FROM {2} WHERE {3}='{4}'", Variables.COLUMN_NAME[6], Variables.COLUMN_NAME[1], Variables.TABLE_NAME[14], Variables.COLUMN_NAME[0], tempDate));
if (tempdateTable.Rows.Count > 0)
{
DataRow tempDataRow = tempdateTable.Rows[0];
this.TotalSummary.SalesQuantity = tempDataRow[0].ToString();
this.TotalSummary.SalesAmount = tempDataRow[1].ToString();
}
tempdateTable = mysqElement.DataReader(string.Format("SELECT SUM({0}) FROM {1} WHERE {2}='{3}'", Variables.COLUMN_NAME[1], Variables.TABLE_NAME[6], Variables.COLUMN_NAME[0], tempDate));
if (tempdateTable.Rows.Count > 0)
{
DataRow tempDataRow = tempdateTable.Rows[0];
this.TotalSummary.Expanses = tempDataRow[0].ToString();
}
tempdateTable = mysqElement.DataReader(string.Format("SELECT SUM({0}),SUM({1}) FROM {2} WHERE {3}='{4}' AND {5}='Return'", Variables.COLUMN_NAME[6], Variables.COLUMN_NAME[1], Variables.TABLE_NAME[12], Variables.COLUMN_NAME[0], tempDate, Variables.COLUMN_NAME[14]));
if (tempdateTable.Rows.Count > 0)
{
DataRow tempDataRow = tempdateTable.Rows[0];
this.TotalSummary.PuchaseReturnQuantity = tempDataRow[0].ToString();
this.TotalSummary.PuchaseReturnAmount = tempDataRow[1].ToString();
}
tempdateTable = mysqElement.DataReader(string.Format("SELECT SUM({0}),SUM({1}) FROM {2} WHERE {3}='{4}' AND {5}='Return'", Variables.COLUMN_NAME[6], Variables.COLUMN_NAME[1], Variables.TABLE_NAME[14], Variables.COLUMN_NAME[0], tempDate, Variables.COLUMN_NAME[14]));
if (tempdateTable.Rows.Count > 0)
{
DataRow tempDataRow = tempdateTable.Rows[0];
this.TotalSummary.SalesReturnQuantity = tempDataRow[0].ToString();
this.TotalSummary.SalesReurnAmount = tempDataRow[1].ToString();
}
}
else
{
throw new PetuniaException(Variables.ERROR_MESSAGES[0, 5]);
}
}
catch (Exception error)
{
Mouse.OverrideCursor = null;
Microsoft.Windows.Controls.MessageBox.Show(error.Message, Variables.ERROR_MESSAGES[0, 0], MessageBoxButton.OK, MessageBoxImage.Hand);
}
finally
{
tempdateTable.Dispose();
mysqElement.Dispose();
Mouse.OverrideCursor = null;
this.SummaryButtonSearch.IsEnabled = true;
}
}
