private void ThemedWindow_Loaded(object sender, RoutedEventArgs e)
{
coolBlue.CategoriesDataSet categoriesDataSet = ((coolBlue.CategoriesDataSet)(this.FindResource("categoriesDataSet")));
// TODO: Add code here to load data into the table USP_getOneCat.
// This code could not be generated, because the categoriesDataSetUSP_getOneCatTableAdapter.Fill method is missing, or has unrecognized parameters.
coolBlue.CategoriesDataSetTableAdapters.USP_getOneSubCatTableAdapter categoriesDataSetUSP_getOneSubCatTableAdapter = new coolBlue.CategoriesDataSetTableAdapters.USP_getOneSubCatTableAdapter();
coolBlue.CategoriesDataSetTableAdapters.USP_getAllCatsTableAdapter categoriesDataSetUSP_getAllCatsTableAdapter = new coolBlue.CategoriesDataSetTableAdapters.USP_getAllCatsTableAdapter();
categoriesDataSet.EnforceConstraints = false;
categoriesDataSetUSP_getOneSubCatTableAdapter.Fill(categoriesDataSet.USP_getOneSubCat, nSubCatID);
categoriesDataSetUSP_getAllCatsTableAdapter.Fill(categoriesDataSet.USP_getAllCats);
categoriesDataSet.EnforceConstraints = true;
System.Windows.Data.CollectionViewSource uSP_getOneSubCatViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getOneSubCatViewSource")));
uSP_getOneSubCatViewSource.View.MoveCurrentToFirst();
// TODO: Add code here to load data into the table USP_getAllCats.
// This code could not be generated, because the categoriesDataSetUSP_getAllCatsTableAdapter.Fill method is missing, or has unrecognized parameters.
// coolBlue.CategoriesDataSetTableAdapters.USP_getAllCatsTableAdapter categoriesDataSetUSP_getAllCatsTableAdapter = new coolBlue.CategoriesDataSetTableAdapters.USP_getAllCatsTableAdapter();
System.Windows.Data.CollectionViewSource uSP_getAllCatsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllCatsViewSource")));
uSP_getAllCatsViewSource.View.MoveCurrentToFirst();
DataRowView drv = (DataRowView)uSP_getOneSubCatViewSource.View.CurrentItem;
int catID = (drv == null ? 0 : DBNull.Value.Equals(drv["nCatID"]) == true ? 0 : (int)drv["nCatID"]);
LookupEditCat.EditValue = catID;
}
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.CategoriesDataSet categoriesDataSet = ((coolBlue.CategoriesDataSet)(this.FindResource("categoriesDataSet")));
coolBlue.CategoriesDataSetTableAdapters.USP_getAllCatsTableAdapter categoriesDataSetUSP_getAllCatsTableAdapter = new coolBlue.CategoriesDataSetTableAdapters.USP_getAllCatsTableAdapter();
coolBlue.CategoriesDataSetTableAdapters.USP_getAllSubCatsTableAdapter categoriesDataSetUSP_getAllSubCatsTableAdapter = new coolBlue.CategoriesDataSetTableAdapters.USP_getAllSubCatsTableAdapter();
categoriesDataSetUSP_getAllCatsTableAdapter.Fill(categoriesDataSet.USP_getAllCats);
categoriesDataSetUSP_getAllSubCatsTableAdapter.Fill(categoriesDataSet.USP_getAllSubCats);
System.Windows.Data.CollectionViewSource uSP_getAllCatsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllCatsViewSource")));
System.Windows.Data.CollectionViewSource uSP_getAllCatsUSP_getAllSubCatsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllCatsUSP_getAllSubCatsViewSource")));
uSP_getAllCatsViewSource.View.MoveCurrentToFirst();
uSP_getAllCatsUSP_getAllSubCatsViewSource.View.MoveCurrentToFirst();
}
private void ThemedWindow_Loaded(object sender, RoutedEventArgs e)
{
coolBlue.CategoriesDataSet categoriesDataSet = ((coolBlue.CategoriesDataSet)(this.FindResource("categoriesDataSet")));
// TODO: Add code here to load data into the table USP_getOneCat.
// This code could not be generated, because the categoriesDataSetUSP_getOneCatTableAdapter.Fill method is missing, or has unrecognized parameters.
coolBlue.CategoriesDataSetTableAdapters.USP_getOneCatTableAdapter categoriesDataSetUSP_getOneCatTableAdapter = new coolBlue.CategoriesDataSetTableAdapters.USP_getOneCatTableAdapter();
categoriesDataSet.EnforceConstraints = false;
categoriesDataSetUSP_getOneCatTableAdapter.Fill(categoriesDataSet.USP_getOneCat, nCatID);
categoriesDataSet.EnforceConstraints = true;
System.Windows.Data.CollectionViewSource uSP_getOneCatViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getOneCatViewSource")));
uSP_getOneCatViewSource.View.MoveCurrentToFirst();
}
private void BarButtonItem_ItemClick_2(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
System.Windows.Data.CollectionViewSource uSP_getAllCatsUSP_getAllSubCatsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllCatsUSP_getAllSubCatsViewSource")));
DataRowView drv = (DataRowView)uSP_getAllCatsUSP_getAllSubCatsViewSource.View.CurrentItem;
int SubcatCurrent = (drv == null ? 0 : DBNull.Value.Equals(drv["ID"]) == true ? 0 : (int)drv["ID"]);
editSubCat editSubCat1 = new editSubCat(SubcatCurrent);
editSubCat1.ShowDialog();
coolBlue.CategoriesDataSet categoriesDataSet = ((coolBlue.CategoriesDataSet)(this.FindResource("categoriesDataSet")));
coolBlue.CategoriesDataSetTableAdapters.USP_getAllSubCatsTableAdapter categoriesDataSetUSP_getAllSubCatsTableAdapter = new coolBlue.CategoriesDataSetTableAdapters.USP_getAllSubCatsTableAdapter();
categoriesDataSet.EnforceConstraints = false;
categoriesDataSetUSP_getAllSubCatsTableAdapter.Fill(categoriesDataSet.USP_getAllSubCats);
categoriesDataSet.EnforceConstraints = true;
uSP_getAllCatsUSP_getAllSubCatsViewSource.View.MoveCurrentToFirst();
}
private void goDetails()
{
System.Windows.Data.CollectionViewSource uSP_getAllCatsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getAllCatsViewSource")));
DataRowView drv = (DataRowView)uSP_getAllCatsViewSource.View.CurrentItem;
int catCurrent = (drv == null ? 0 : DBNull.Value.Equals(drv["ID"]) == true ? 0 : (int)drv["ID"]);
editCat editCat1 = new editCat(catCurrent);
editCat1.ShowDialog();
coolBlue.CategoriesDataSet categoriesDataSet = ((coolBlue.CategoriesDataSet)(this.FindResource("categoriesDataSet")));
coolBlue.CategoriesDataSetTableAdapters.USP_getAllCatsTableAdapter categoriesDataSetUSP_getAllCatsTableAdapter = new coolBlue.CategoriesDataSetTableAdapters.USP_getAllCatsTableAdapter();
categoriesDataSet.EnforceConstraints = false;
categoriesDataSetUSP_getAllCatsTableAdapter.Fill(categoriesDataSet.USP_getAllCats);
categoriesDataSet.EnforceConstraints = true;
uSP_getAllCatsViewSource.View.MoveCurrentToFirst();
}
private void BarButtonItem_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
//int TransactID1 = 0;
string notes = "";
string name = "";
System.Windows.Data.CollectionViewSource uSP_getOneCatViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getOneCatViewSource")));
coolBlue.CategoriesDataSet categoriesDataSet = ((coolBlue.CategoriesDataSet)(this.FindResource("categoriesDataSet")));
//int accountCurrent = 0;
int wasnull = 0;
wasnull = (uSP_getOneCatViewSource.View == null ? 1 : 0);
if (wasnull == 1)
{
// MessageBox.Show("Warning: uSP_getLineViewSource is null", "CoolBlue");
string message = "Warning:uSP_getOneVendorViewSource 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_getOneCatViewSource.View.CurrentItem;
//accountCurrent = (drv == null ? 0 : DBNull.Value.Equals(drv["ID"]) == true ? 0 : (int)drv["ID"]);
notes = (DBNull.Value.Equals(drv["cNote"]) == true ? "" : (string)drv["cNote"]);
name = (DBNull.Value.Equals(drv["cName"]) == true ? "" : (string)drv["cName"]);
}
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_updateCat";
cmd3.Parameters.AddWithValue("@ID", nCatID);
cmd3.Parameters.AddWithValue("@notes", notes);
cmd3.Parameters.AddWithValue("@name", name);
//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();
}
//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();
}
}
