private void REPORT_Register_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) { string cName = ""; int nAccountID = 0; DevExpress.XtraReports.Parameters.Parameter param = (DevExpress.XtraReports.Parameters.Parameter)((DevExpress.XtraReports.UI.XtraReport)sender). Parameters["accountID"]; if (param != null) { //REPORT_Register xafParameter = // (REPORT_Register)param.Value; nAccountID = (int)param.Value; } DataSet xx = new coolBlue.AccountsDataSet(); coolBlue.AccountsDataSet.USP_getAllAccountsDataTable dt = new coolBlue.AccountsDataSet.USP_getAllAccountsDataTable(); coolBlue.AccountsDataSetTableAdapters.USP_getAllAccountsTableAdapter accountsDataSetUSP_getAllAccountsTableAdapter = new coolBlue.AccountsDataSetTableAdapters.USP_getAllAccountsTableAdapter(); accountsDataSetUSP_getAllAccountsTableAdapter.Connection.ConnectionString = ProgramSettings.coolblueconnectionString; accountsDataSetUSP_getAllAccountsTableAdapter.Fill(dt); // DataRow[] foundRowC = xx.Tables[USP_getAllAccountsforAccounts].Select("ID = " + nAccountID.ToString()); DataRow[] foundRowC = dt.Select("ID = " + nAccountID.ToString()); if (foundRowC.Count() > 0) { cName = (string)foundRowC[0]["cName"]; xrLabelAccountName.Text = cName; } }
private void ThemedWindow_Loaded(object sender, RoutedEventArgs e) { coolBlue.AccountsDataSet accountsDataSet = ((coolBlue.AccountsDataSet)(this.FindResource("accountsDataSet"))); coolBlue.CategoriesDataSet categoriesDataSet = ((coolBlue.CategoriesDataSet)(this.FindResource("categoriesDataSet"))); coolBlue.RegisterDataSet registerDataSet = ((coolBlue.RegisterDataSet)(this.FindResource("registerDataSet"))); coolBlue.AccountsDataSetTableAdapters.USP_getOneAccountTableAdapter accountsDataSetUSP_getOneAccountTableAdapter = new coolBlue.AccountsDataSetTableAdapters.USP_getOneAccountTableAdapter(); coolBlue.AccountsDataSetTableAdapters.USP_getAllAccountTypesTableAdapter accountsDataSetUSP_getAllAccountTypesTableAdapter = new coolBlue.AccountsDataSetTableAdapters.USP_getAllAccountTypesTableAdapter(); coolBlue.CategoriesDataSetTableAdapters.USP_getAllCatsTableAdapter categoriesDataSetUSP_getAllCatsTableAdapter = new coolBlue.CategoriesDataSetTableAdapters.USP_getAllCatsTableAdapter(); coolBlue.RegisterDataSetTableAdapters.USP_getAllCurrencyTableAdapter registerDataSetUSP_getAllCurrencyTableAdapter = new coolBlue.RegisterDataSetTableAdapters.USP_getAllCurrencyTableAdapter(); accountsDataSet.EnforceConstraints = false; accountsDataSetUSP_getOneAccountTableAdapter.Fill(accountsDataSet.USP_getOneAccount, nAccountID); accountsDataSetUSP_getAllAccountTypesTableAdapter.Fill(accountsDataSet.USP_getAllAccountTypes); accountsDataSet.EnforceConstraints = true; categoriesDataSet.EnforceConstraints = false; categoriesDataSetUSP_getAllCatsTableAdapter.Fill(categoriesDataSet.USP_getAllCats); categoriesDataSet.EnforceConstraints = true; registerDataSet.EnforceConstraints = false; registerDataSetUSP_getAllCurrencyTableAdapter.Fill(registerDataSet.USP_getAllCurrency); registerDataSet.EnforceConstraints = true; System.Windows.Data.CollectionViewSource uSP_getOneAccountViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getOneAccountViewSource"))); uSP_getOneAccountViewSource.View.MoveCurrentToFirst(); System.Windows.Data.CollectionViewSource uSP_getAllAccountTypesViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllAccountTypesViewSource"))); uSP_getAllAccountTypesViewSource.View.MoveCurrentToFirst(); System.Windows.Data.CollectionViewSource uSP_getAllCatsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllCatsViewSource"))); uSP_getAllCatsViewSource.View.MoveCurrentToFirst(); System.Windows.Data.CollectionViewSource uSP_getAllCurrencyViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllCurrencyViewSource"))); uSP_getAllCurrencyViewSource.View.MoveCurrentToFirst(); DataRowView drv = (DataRowView)uSP_getOneAccountViewSource.View.CurrentItem; int catID = (drv == null ? 0 : DBNull.Value.Equals(drv["nCatID"]) == true ? 0 : (int)drv["nCatID"]); LookupEditCat.EditValue = catID; int currencyID = (drv == null ? 0 : DBNull.Value.Equals(drv["nCurrencyID"]) == true ? 0 : (int)drv["nCurrencyID"]); LookupEditCurrency.EditValue = currencyID; int accountTypeID = (drv == null ? 0 : DBNull.Value.Equals(drv["nAccountTypeID"]) == true ? 0 : (int)drv["nAccountTypeID"]); LookupEditAccountType.EditValue = accountTypeID; cOrigName = (drv == null ? "" : DBNull.Value.Equals(drv["cName"]) == true ? "" : (string)drv["cName"]); }
private void ThemedWindow_Loaded(object sender, RoutedEventArgs e) { coolBlue.AccountsDataSet accountsDataSet = ((coolBlue.AccountsDataSet)(this.FindResource("accountsDataSet"))); // TODO: Add code here to load data into the table USP_getAllAccountTypes. // This code could not be generated, because the accountsDataSetUSP_getAllAccountTypesTableAdapter.Fill method is missing, or has unrecognized parameters. coolBlue.AccountsDataSetTableAdapters.USP_getAllAccountTypesTableAdapter accountsDataSetUSP_getAllAccountTypesTableAdapter = new coolBlue.AccountsDataSetTableAdapters.USP_getAllAccountTypesTableAdapter(); System.Windows.Data.CollectionViewSource uSP_getAllAccountTypesViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllAccountTypesViewSource"))); uSP_getAllAccountTypesViewSource.View.MoveCurrentToFirst(); // TODO: Add code here to load data into the table USP_getAllAccounts. // This code could not be generated, because the accountsDataSetUSP_getAllAccountsTableAdapter.Fill method is missing, or has unrecognized parameters. coolBlue.AccountsDataSetTableAdapters.USP_getAllAccountsTableAdapter accountsDataSetUSP_getAllAccountsTableAdapter = new coolBlue.AccountsDataSetTableAdapters.USP_getAllAccountsTableAdapter(); System.Windows.Data.CollectionViewSource uSP_getAllAccountTypesUSP_getAllAccountsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllAccountTypesUSP_getAllAccountsViewSource"))); uSP_getAllAccountTypesUSP_getAllAccountsViewSource.View.MoveCurrentToFirst(); }
private void BarButtonItem_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e) { //int TransactID1 = 0; string cNote = ""; string cName = ""; string cDesc = ""; string cComment = ""; string cDecryptedPIN = ""; string cDecryptedCV = ""; string expiry_Decrypted = ""; string cDecryptedAcctNum = ""; int nCatID = 0; int nAccountTypeID = 0; int nCurrencyID = 0; int nBillDate = 0; decimal nCreditLimit = 0m; decimal nForeignConversionFee = 0m; string cUsername = ""; string nRoutingNumber = ""; string cDecryptedCardNum = ""; string cPassword = ""; string cInstitutionNum = ""; string cTransitNum = ""; string cSwiftCode = ""; string cContactName = ""; string cURL = ""; string cContactEmail = ""; string cContactPhone = ""; string cDecryptedPIN2 = ""; string cDecryptedCV2 = ""; string cDecryptedExpiry2 = ""; string cDecryptedCardNum2 = ""; string cAccountHolderName1 = ""; string cAccountHolderName2 = ""; System.Windows.Data.CollectionViewSource uSP_getOneAccountViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getOneAccountViewSource"))); coolBlue.AccountsDataSet accountsDataSet = ((coolBlue.AccountsDataSet)(this.FindResource("accountsDataSet"))); //int accountCurrent = 0; int wasnull = 0; wasnull = (uSP_getOneAccountViewSource.View == null ? 1 : 0); if (wasnull == 1) { // MessageBox.Show("Warning: uSP_getLineViewSource is null", "CoolBlue"); string message = "Warning:uSP_getOneAccountViewSource is null"; string caption = "CoolBlue"; MessageBoxButton buttons = MessageBoxButton.OK; MessageBoxImage icon = MessageBoxImage.Information; MessageBoxResult defaultResult = MessageBoxResult.OK; MessageBoxOptions options = MessageBoxOptions.RtlReading; // Show message box // MessageBoxResult result = MessageBox.Show(message, caption, buttons, icon, defaultResult, options); // Displays the MessageBox. MessageBoxResult result = MessageBox.Show(message, caption, buttons, icon, defaultResult, options); if (result == MessageBoxResult.OK) { // Closes the parent form. //this.Close(); } return; } else { DataRowView drv = (DataRowView)uSP_getOneAccountViewSource.View.CurrentItem; //accountCurrent = (drv == null ? 0 : DBNull.Value.Equals(drv["ID"]) == true ? 0 : (int)drv["ID"]); cNote = (DBNull.Value.Equals(drv["cNote"]) == true ? "" : (string)drv["cNote"]); cName = (DBNull.Value.Equals(drv["cName"]) == true ? "" : (string)drv["cName"]); cDesc = (DBNull.Value.Equals(drv["cDesc"]) == true ? "" : (string)drv["cDesc"]); cComment = (DBNull.Value.Equals(drv["cComment"]) == true ? "" : (string)drv["cComment"]); cDecryptedPIN = (DBNull.Value.Equals(drv["cDecryptedPIN"]) == true ? "" : (string)drv["cDecryptedPIN"]); cDecryptedCV = (DBNull.Value.Equals(drv["cDecryptedCV"]) == true ? "" : (string)drv["cDecryptedCV"]); expiry_Decrypted = (DBNull.Value.Equals(drv["cDecryptedExpiry"]) == true ? "" : (string)drv["cDecryptedExpiry"]); cDecryptedAcctNum = (DBNull.Value.Equals(drv["cDecryptedAcctNum"]) == true ? "" : (string)drv["cDecryptedAcctNum"]); nCreditLimit = (DBNull.Value.Equals(drv["nCreditLimit"]) == true ? 0m : (decimal)drv["nCreditLimit"]); cUsername = (DBNull.Value.Equals(drv["cDecryptedUsername"]) == true ? "" : (string)drv["cDecryptedUsername"]); cDecryptedCardNum = (DBNull.Value.Equals(drv["cDecryptedCardNum"]) == true ? "" : (string)drv["cDecryptedCardNum"]); cPassword = (DBNull.Value.Equals(drv["cDecryptedPassword"]) == true ? "" : (string)drv["cDecryptedPassword"]); cDecryptedCV = (DBNull.Value.Equals(drv["cDecryptedCV"]) == true ? "" : (string)drv["cDecryptedCV"]); nRoutingNumber = (DBNull.Value.Equals(drv["nRoutingNumber"]) == true ? "" : (string)drv["nRoutingNumber"]); nBillDate = (drv == null ? 0 : DBNull.Value.Equals(drv["nBillDate"]) == true ? 0 : (int)drv["nBillDate"]); nForeignConversionFee = (DBNull.Value.Equals(drv["nForeignConversionFee"]) == true ? 0m : (decimal)drv["nForeignConversionFee"]); cInstitutionNum = (DBNull.Value.Equals(drv["cInstitutionNum"]) == true ? "" : (string)drv["cInstitutionNum"]); cTransitNum = (DBNull.Value.Equals(drv["cTransitNum"]) == true ? "" : (string)drv["cTransitNum"]); cSwiftCode = (DBNull.Value.Equals(drv["cSwiftCode"]) == true ? "" : (string)drv["cSwiftCode"]); cContactName = (DBNull.Value.Equals(drv["cContactName"]) == true ? "" : (string)drv["cContactName"]); cURL = (DBNull.Value.Equals(drv["cURL"]) == true ? "" : (string)drv["cURL"]); cContactEmail = (DBNull.Value.Equals(drv["cContactEmail"]) == true ? "" : (string)drv["cContactEmail"]); cContactPhone = (DBNull.Value.Equals(drv["cContactPhone"]) == true ? "" : (string)drv["cContactPhone"]); cDecryptedPIN2 = (DBNull.Value.Equals(drv["cDecryptedPIN2"]) == true ? "" : (string)drv["cDecryptedPIN2"]); cDecryptedCV2 = (DBNull.Value.Equals(drv["cDecryptedCV2"]) == true ? "" : (string)drv["cDecryptedCV2"]); cDecryptedExpiry2 = (DBNull.Value.Equals(drv["cDecryptedExpiry2"]) == true ? "" : (string)drv["cDecryptedExpiry2"]); cDecryptedCardNum2 = (DBNull.Value.Equals(drv["cDecryptedCardNum2"]) == true ? "" : (string)drv["cDecryptedCardNum2"]); cAccountHolderName1 = (DBNull.Value.Equals(drv["cAccountHolderName1"]) == true ? "" : (string)drv["cAccountHolderName1"]); cAccountHolderName2 = (DBNull.Value.Equals(drv["cAccountHolderName2"]) == true ? "" : (string)drv["cAccountHolderName2"]); // nAccountTypeID = (int)LookupEditAccountType.EditValue; //nAccountTypeID = (DBNull.Value.Equals(LookupEditAccountType.EditValue) == true ? 0 : (int)LookupEditAccountType.EditValue); //nCatID = (int)LookupEditCat.EditValue; //nCatID = (DBNull.Value.Equals(LookupEditCat.EditValue) == true ? 0 : (int)LookupEditCat.EditValue); //nCurrencyID = (int)LookupEditCurrency.EditValue; //nCurrencyID = (DBNull.Value.Equals(LookupEditCurrency.EditValue) == true ? 0 : (int)LookupEditCurrency.EditValue); nAccountTypeID = (LookupEditAccountType.EditValue == null ? 0 : DBNull.Value.Equals(LookupEditAccountType.EditValue) == true ? 0 : (int)LookupEditAccountType.EditValue); nCatID = (LookupEditCat.EditValue == null ? 0 : DBNull.Value.Equals(LookupEditCat.EditValue) == true ? 0 : (int)LookupEditCat.EditValue); nCurrencyID = (LookupEditCurrency.EditValue == null ? 0 : DBNull.Value.Equals(LookupEditCurrency.EditValue) == true ? 0 : (int)LookupEditCurrency.EditValue); } SqlConnection conn = new SqlConnection() { ConnectionString = ProgramSettings.coolblueconnectionString }; try { using (SqlCommand cmd3 = new SqlCommand() { Connection = conn, CommandType = CommandType.StoredProcedure }) { //cmd3.Transaction = trans1; cmd3.Parameters.Clear(); cmd3.CommandText = "dbo.USP_updateAccount"; cmd3.Parameters.AddWithValue("@ID", nAccountID); cmd3.Parameters.AddWithValue("@cNote", cNote); cmd3.Parameters.AddWithValue("@cName", cName); cmd3.Parameters.AddWithValue("@nAccountTypeID", nAccountTypeID); cmd3.Parameters.AddWithValue("@cDesc", cDesc); cmd3.Parameters.AddWithValue("@cComment", cComment); cmd3.Parameters.AddWithValue("@nCatID", nCatID); cmd3.Parameters.AddWithValue("@nCurrencyID", nCurrencyID); cmd3.Parameters.AddWithValue("@cDecryptedPIN", cDecryptedPIN); cmd3.Parameters.AddWithValue("@cDecryptedCV", cDecryptedCV); cmd3.Parameters.AddWithValue("@expiry_Decrypted", expiry_Decrypted); cmd3.Parameters.AddWithValue("@cDecryptedAcctNum", cDecryptedAcctNum); cmd3.Parameters.AddWithValue("@cDecryptedCardNum", cDecryptedCardNum); cmd3.Parameters.AddWithValue("@cInstitutionNum", cInstitutionNum); cmd3.Parameters.AddWithValue("@cTransitNum", cTransitNum); cmd3.Parameters.AddWithValue("@cUsername", cUsername); cmd3.Parameters.AddWithValue("@cPassword", cPassword); cmd3.Parameters.AddWithValue("@cSwiftCode", cSwiftCode); cmd3.Parameters.AddWithValue("@nCreditLimit", nCreditLimit); cmd3.Parameters.AddWithValue("@cContactName", cContactName); cmd3.Parameters.AddWithValue("@cURL", cURL); cmd3.Parameters.AddWithValue("@cContactEmail", cContactEmail); cmd3.Parameters.AddWithValue("@cContactPhone", cContactPhone); cmd3.Parameters.AddWithValue("@nBillDate", nBillDate); cmd3.Parameters.AddWithValue("@nForeignConversionFee", nForeignConversionFee); cmd3.Parameters.AddWithValue("@nRoutingNumber", nRoutingNumber); cmd3.Parameters.AddWithValue("@cDecryptedPIN2", cDecryptedPIN2); cmd3.Parameters.AddWithValue("@cDecryptedCV2", cDecryptedCV2); cmd3.Parameters.AddWithValue("@expiry_Decrypted2", cDecryptedExpiry2); cmd3.Parameters.AddWithValue("@cDecryptedCardNum2", cDecryptedCardNum2); cmd3.Parameters.AddWithValue("@cAccountHolderName1", cAccountHolderName1); cmd3.Parameters.AddWithValue("@cAccountHolderName2", cAccountHolderName2); //SqlParameter retval = cmd3.Parameters.Add("@transactIdentity", SqlDbType.Int); //retval.Direction = ParameterDirection.Output; conn.Open(); cmd3.ExecuteNonQuery(); //TransactID1 = (int)cmd3.Parameters["@transactIdentity"].Value; } } catch (Exception ex) { //utilities.errorLog(System.Reflection.MethodInfo.GetCurrentMethod().Name, ex); System.ArgumentException argEx = new System.ArgumentException("New Line", "", ex); throw argEx; } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } if (cOrigName == cName) { this.bNameChanged = false; } else { this.bNameChanged = true; } //VendorDataSet.EnforceConstraints = false; //coolBlue.vendorDataSetTableAdapters.USP_getOneVendorTableAdapter vendorDataSetUSP_getOneVendorTableAdapter = new coolBlue.vendorDataSetTableAdapters.USP_getOneVendorTableAdapter(); //vendorDataSetUSP_getOneVendorTableAdapter.Fill(VendorDataSet.USP_getOneVendor, nVendorID); //VendorDataSet.EnforceConstraints = true; //uSP_getLineDataGrid. //uSP_getAllAccountTypesUSP_getAllAccountsViewSource.View.MoveCurrentToPosition(0); //resetButtons(); // LocateNewLine(TransactID1); this.Close(); } }