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; } }
//Invoice item Clear private void InvoiceItemClear() { this.InvoiceTextBoxCustomerName.Text = string.Empty; this.InvoiceTextBoxBillTo.Text = string.Empty; this.InvoiceProductInfo.ClearAllText(); this.InvoiceLabelProductIDInfo.Text = string.Empty; this.InvoiceLabelQuantityInfo.Text = string.Empty; this.InvoiceRadioButtonCash.IsChecked = true; this.InvoiceComboBoxDebtorName.Text = string.Empty; this.GridViewInvoice.Clear(); invoiceNumber = new PetuniaNecessaryFunction().InvoiceNumbers(); this.InvoiceTextBoxIssueName.Text = string.Empty; this.InvoiceNumberBoxRate.Text = "0"; this.InvoieLabelCreditAmount.Text = string.Empty; this.InvoiceNumberBoxPaidAmount.Text = "0"; this.InvoiceLabelRateinfo.Text = string.Empty; }