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();
}
}
