private void ThemedWindow_Loaded(object sender, RoutedEventArgs e)
{
coolBlue.EditDataSet editDataSet = ((coolBlue.EditDataSet)(this.FindResource("editDataSet")));
coolBlue.EditDataSetTableAdapters.USP_getAllTagsTableAdapter editDataSetUSP_getAllTagsTableAdapter = new coolBlue.EditDataSetTableAdapters.USP_getAllTagsTableAdapter();
editDataSetUSP_getAllTagsTableAdapter.Fill(editDataSet.USP_getAllTags);
System.Windows.Data.CollectionViewSource uSP_getAllTagsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllTagsViewSource")));
uSP_getAllTagsViewSource.View.MoveCurrentToFirst();
}
private void goDetails()
{
System.Windows.Data.CollectionViewSource uSP_getAllAccountTypesforAccountsUSP_getAllAccountsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllAccountTypesforAccountsUSP_getAllAccountsViewSource")));
DataRowView drv = (DataRowView)uSP_getAllAccountTypesforAccountsUSP_getAllAccountsViewSource.View.CurrentItem;
int accountCurrent = (drv == null ? 0 : DBNull.Value.Equals(drv["ID"]) == true ? 0 : (int)drv["ID"]);
if (accountCurrent == 0)
{
string message = "Please select an account";
string caption = "CoolBlue";
MessageBoxButton buttons = MessageBoxButton.OK;
MessageBoxImage icon = MessageBoxImage.Information;
MessageBoxResult defaultResult = MessageBoxResult.OK;
MessageBoxOptions options = MessageBoxOptions.RtlReading;
MessageBoxResult result = MessageBox.Show(message, caption, buttons, icon, defaultResult, options);
if (result == MessageBoxResult.OK)
{
}
return;
}
editAccount editAccount1 = new editAccount(accountCurrent);
editAccount1.ShowDialog();
coolBlue.EditDataSet editDataSet = ((coolBlue.EditDataSet)(this.FindResource("editDataSet")));
System.Windows.Data.CollectionViewSource uSP_getAllAccountTypesforAccountsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllAccountTypesforAccountsViewSource")));
//System.Windows.Data.CollectionViewSource uSP_getAllAccountTypesUSP_getAllAccountsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllAccountTypesUSP_getAllAccountsViewSource")));
//System.Windows.Data.CollectionViewSource uSP_getAllAccountsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllAccountsViewSource")));
//System.Windows.Data.CollectionViewSource uSP_getAllAccountTypesUSP_getAllAccountsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllAccountTypesUSP_getAllAccountsViewSource")));
//coolBlue.EditDataSetTableAdapters.USP_getAllAccountTypesTableAdapter editDataSetUSP_getAllAccountTypesforAccountsTableAdapter = new coolBlue.EditDataSetTableAdapters.USP_getAllAccountTypesforAccountsTableAdapter();
coolBlue.EditDataSetTableAdapters.USP_getAllAccountsTableAdapter editDataSetUSP_getAllAccountsTableAdapter = new coolBlue.EditDataSetTableAdapters.USP_getAllAccountsTableAdapter();
editDataSet.EnforceConstraints = false;
//editDataSetUSP_getAllAccountTypesTableAdapter.Fill(editDataSet.USP_getAllAccountTypes);
editDataSetUSP_getAllAccountsTableAdapter.Fill(editDataSet.USP_getAllAccounts);
editDataSet.EnforceConstraints = true;
// uSP_getAllAccountTypesViewSource.View.MoveCurrentToFirst();
}
private void goDetails()
{
System.Windows.Data.CollectionViewSource uSP_getAllVendorsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllVendorsViewSource")));
DataRowView drv = (DataRowView)uSP_getAllVendorsViewSource.View.CurrentItem;
int vendorCurrent = (drv == null ? 0 : DBNull.Value.Equals(drv["vendors_id"]) == true ? 0 : (int)drv["vendors_id"]);
editVendor editVendor1 = new editVendor(vendorCurrent);
editVendor1.ShowDialog();
coolBlue.EditDataSet editDataSet = ((coolBlue.EditDataSet)(this.FindResource("editDataSet")));
coolBlue.EditDataSetTableAdapters.USP_getAllVendorsTableAdapter editDataSetUSP_getAllVendorsTableAdapter = new coolBlue.EditDataSetTableAdapters.USP_getAllVendorsTableAdapter();
editDataSetUSP_getAllVendorsTableAdapter.Fill(editDataSet.USP_getAllVendors);
uSP_getAllVendorsViewSource.View.MoveCurrentToFirst();
}
private void goDetails()
{
System.Windows.Data.CollectionViewSource uSP_getAllTagsViewSource = (System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllTagsViewSource"));
DataRowView drv = (DataRowView)uSP_getAllTagsViewSource.View.CurrentItem;
int tagCurrent = (drv == null ? 0 : DBNull.Value.Equals(drv["ID"]) == true ? 0 : (int)drv["ID"]);
editTag editTag1 = new editTag(tagCurrent);
editTag1.ShowDialog();
coolBlue.EditDataSet editDataSet = ((coolBlue.EditDataSet)(this.FindResource("editDataSet")));
coolBlue.EditDataSetTableAdapters.USP_getAllTagsTableAdapter editDataSetUSP_getAllTagsTableAdapter = new coolBlue.EditDataSetTableAdapters.USP_getAllTagsTableAdapter();
editDataSet.EnforceConstraints = false;
editDataSetUSP_getAllTagsTableAdapter.Fill(editDataSet.USP_getAllTags);
editDataSet.EnforceConstraints = true;
uSP_getAllTagsViewSource.View.MoveCurrentToFirst();
}
private void ThemedWindow_Loaded(object sender, RoutedEventArgs e)
{
coolBlue.EditDataSet editDataSet = ((coolBlue.EditDataSet)(this.FindResource("editDataSet")));
System.Windows.Data.CollectionViewSource uSP_getAllAccountTypesforAccountsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllAccountTypesforAccountsViewSource")));
//System.Windows.Data.CollectionViewSource uSP_getAllAccountTypesUSP_getAllAccountsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllAccountTypesUSP_getAllAccountsViewSource")));
//System.Windows.Data.CollectionViewSource uSP_getAllAccountsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllAccountsViewSource")));
System.Windows.Data.CollectionViewSource uSP_getAllAccountTypesforAccountsUSP_getAllAccountsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllAccountTypesforAccountsUSP_getAllAccountsViewSource")));
coolBlue.EditDataSetTableAdapters.USP_getAllAccountTypesforAccountsTableAdapter editDataSetUSP_getAllAccountTypesforAccountsTableAdapter = new coolBlue.EditDataSetTableAdapters.USP_getAllAccountTypesforAccountsTableAdapter();
coolBlue.EditDataSetTableAdapters.USP_getAllAccountsTableAdapter editDataSetUSP_getAllAccountsTableAdapter = new coolBlue.EditDataSetTableAdapters.USP_getAllAccountsTableAdapter();
//editDataSet.EnforceConstraints = false;
editDataSetUSP_getAllAccountTypesforAccountsTableAdapter.Connection.ConnectionString = ProgramSettings.coolblueconnectionString;
editDataSetUSP_getAllAccountsTableAdapter.Connection.ConnectionString = ProgramSettings.coolblueconnectionString;
editDataSetUSP_getAllAccountTypesforAccountsTableAdapter.Fill(editDataSet.USP_getAllAccountTypesforAccounts);
editDataSetUSP_getAllAccountsTableAdapter.Fill(editDataSet.USP_getAllAccounts);
//editDataSet.EnforceConstraints = true;
uSP_getAllAccountTypesforAccountsViewSource.View.MoveCurrentToFirst();
//uSP_getAllAccountTypesUSP_getAllAccountsViewSource.View.MoveCurrentToFirst();
//uSP_getAllAccountsViewSource.View.MoveCurrentToFirst();
// uSP_getAllAccountTypesDataGrid.FilterString = "[Note] = 'haha'"; //doesn't work
}
private void BarButtonItem_ItemClick_1(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
int TransactID1 = 0;
System.Windows.Data.CollectionViewSource uSP_getAllTagsViewSource = (System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllTagsViewSource"));
//coolBlue.RegisterDataSet registerDataSet = ((coolBlue.RegisterDataSet)(this.FindResource("registerDataSet")));
// int accountCurrent = 0;
int wasnull = 0;
// wasnull = (uSP_getAllAccountTypesUSP_getAllAccountsViewSource.View == null ? 1 : 0);
if (wasnull == 1)
{
// MessageBox.Show("Warning: uSP_getLineViewSource is null", "CoolBlue");
string message = "Warning: uSP_getAllTagsViewSource 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_getAllAccountTypesUSP_getAllAccountsViewSource.View.CurrentItem;
//accountCurrent = (drv == null ? 0 : DBNull.Value.Equals(drv["ID"]) == true ? 0 : (int)drv["ID"]);
}
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_insertTag";
//cmd3.Parameters.AddWithValue("@nAccount", accountCurrent);
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();
}
int tagCurrent = TransactID1;
editTag editTag1 = new editTag(tagCurrent);
editTag1.ShowDialog();
coolBlue.EditDataSet editDataSet = ((coolBlue.EditDataSet)(this.FindResource("editDataSet")));
coolBlue.EditDataSetTableAdapters.USP_getAllTagsTableAdapter editDataSetUSP_getAllTagsTableAdapter = new coolBlue.EditDataSetTableAdapters.USP_getAllTagsTableAdapter();
editDataSet.EnforceConstraints = false;
editDataSetUSP_getAllTagsTableAdapter.Fill(editDataSet.USP_getAllTags);
editDataSet.EnforceConstraints = true;
uSP_getAllTagsViewSource.View.MoveCurrentToFirst();
}
}
private void BarButtonitemNewAccount_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
int TransactID1 = 0;
//int nAccountTypeID = 0;
//int nCatID = 0;
//int nCurrencyID = 0;
System.Windows.Data.CollectionViewSource uSP_getAllAccountTypesforAccountsUSP_getAllAccountsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllAccountTypesforAccountsUSP_getAllAccountsViewSource")));
//coolBlue.RegisterDataSet registerDataSet = ((coolBlue.RegisterDataSet)(this.FindResource("registerDataSet")));
DataRowView drv = (DataRowView)uSP_getAllAccountTypesforAccountsUSP_getAllAccountsViewSource.View.CurrentItem;
int accountCurrent = (drv == null ? 0 : DBNull.Value.Equals(drv["ID"]) == true ? 0 : (int)drv["ID"]);
int nAccountTypeID = (drv == null ? 0 : DBNull.Value.Equals(drv["nAccountTypeID"]) == true ? 0 : (int)drv["nAccountTypeID"]);
int nCatID = (drv == null ? 0 : DBNull.Value.Equals(drv["nCatID"]) == true ? 0 : (int)drv["nCatID"]);
int nCurrencyID = (drv == null ? 0 : DBNull.Value.Equals(drv["nCurrencyID"]) == true ? 0 : (int)drv["nCurrencyID"]);
System.Windows.Data.CollectionViewSource uSP_getAllAccountTypesforAccountsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllAccountTypesforAccountsViewSource")));
DataRowView drv1 = (DataRowView)uSP_getAllAccountTypesforAccountsViewSource.View.CurrentItem;
int nID = (drv1 == null ? 0 : DBNull.Value.Equals(drv1["ID"]) == true ? 0 : (int)drv1["ID"]);
string cPIN = "";
string cCV = "";
string cExpiry = "";
string cAcctNum = "";
// int accountCurrent = 0;
// int wasnull = 0;
if (nID == 0)
{
string message = "Account Type Required";
string caption = "CoolBlue";
MessageBoxButton buttons = MessageBoxButton.OK;
MessageBoxImage icon = MessageBoxImage.Information;
MessageBoxResult defaultResult = MessageBoxResult.OK;
MessageBoxOptions options = MessageBoxOptions.RtlReading;
MessageBoxResult result = MessageBox.Show(message, caption, buttons, icon, defaultResult, options);
if (result == MessageBoxResult.OK)
{
}
// return;
}
else
{
//DataRowView drv = (DataRowView)uSP_getAllAccountTypesUSP_getAllAccountsViewSource.View.CurrentItem;
//accountCurrent = (drv == null ? 0 : DBNull.Value.Equals(drv["ID"]) == true ? 0 : (int)drv["ID"]);
}
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_insertAccount";
cmd3.Parameters.AddWithValue("@nAccountTypeID", nID);
cmd3.Parameters.AddWithValue("@nCatID", nCatID);
cmd3.Parameters.AddWithValue("@nCurrencyID", nCurrencyID);
cmd3.Parameters.AddWithValue("cPIN", cPIN);
cmd3.Parameters.AddWithValue("cCV", cCV);
cmd3.Parameters.AddWithValue("cExpiry", cExpiry);
cmd3.Parameters.AddWithValue("cAcctNum", cAcctNum);
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();
}
//registerDataSet.EnforceConstraints = false;
//registerDataSetUSP_getSplitTableAdapter.Fill(registerDataSet.USP_getSplit, accountCurrent);
//registerDataSetUSP_getLineTableAdapter.Fill(registerDataSet.USP_getLine, accountCurrent);
// registerDataSet.EnforceConstraints = true;
//uSP_getLineDataGrid.
//uSP_getAllAccountTypesUSP_getAllAccountsViewSource.View.MoveCurrentToPosition(0);
//resetButtons();
//LocateNewLine(TransactID1);
int nAccountCurrent = TransactID1;
editAccount editAccount1 = new editAccount(nAccountCurrent);
editAccount1.ShowDialog();
coolBlue.EditDataSet editDataSet = ((coolBlue.EditDataSet)(this.FindResource("editDataSet")));
//System.Windows.Data.CollectionViewSource uSP_getAllAccountTypesViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllAccountTypesViewSource")));
//System.Windows.Data.CollectionViewSource uSP_getAllAccountTypesUSP_getAllAccountsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllAccountTypesUSP_getAllAccountsViewSource")));
//System.Windows.Data.CollectionViewSource uSP_getAllAccountsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllAccountsViewSource")));
// System.Windows.Data.CollectionViewSource uSP_getAllAccountTypesUSP_getAllAccountsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllAccountTypesUSP_getAllAccountsViewSource")));
// coolBlue.EditDataSetTableAdapters.USP_getAllAccountTypesTableAdapter editDataSetUSP_getAllAccountTypesTableAdapter = new coolBlue.EditDataSetTableAdapters.USP_getAllAccountTypesTableAdapter();
coolBlue.EditDataSetTableAdapters.USP_getAllAccountsTableAdapter editDataSetUSP_getAllAccountsTableAdapter = new coolBlue.EditDataSetTableAdapters.USP_getAllAccountsTableAdapter();
editDataSet.EnforceConstraints = false;
//editDataSetUSP_getAllAccountTypesTableAdapter.Fill(editDataSet.USP_getAllAccountTypes);
editDataSetUSP_getAllAccountsTableAdapter.Fill(editDataSet.USP_getAllAccounts);
editDataSet.EnforceConstraints = true;
//uSP_getAllAccountTypesViewSource.View.MoveCurrentToFirst();
}
}
