private void ThemedWindow_Loaded(object sender, RoutedEventArgs e)
{
coolBlue.vendorDataSet VendorDataSet = ((coolBlue.vendorDataSet)(this.FindResource("vendorDataSet")));
coolBlue.vendorDataSetTableAdapters.USP_getOneVendorTableAdapter vendorDataSetUSP_getOneVendorTableAdapter = new coolBlue.vendorDataSetTableAdapters.USP_getOneVendorTableAdapter();
//DataRowView drv = (DataRowView)uSP_getAllAccountTypesUSP_getAllAccountsViewSource.View.CurrentItem;
// int vendorCurrent = (drv == null ? 0 : DBNull.Value.Equals(drv["ID"]) == true ? 0 : (int)drv["ID"]);
VendorDataSet.EnforceConstraints = false;
vendorDataSetUSP_getOneVendorTableAdapter.Fill(VendorDataSet.USP_getOneVendor, nVendorID);
VendorDataSet.EnforceConstraints = true;
System.Windows.Data.CollectionViewSource uSP_getOneVendorViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getOneVendorViewSource")));
uSP_getOneVendorViewSource.View.MoveCurrentToFirst();
}
private void BarButtonItem_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
//int TransactID1 = 0;
string notes = "";
string account_no = "";
string address1 = "";
string address2 = "";
string city = "";
string state = "";
string state_other = "";
string zip = "";
string country = "";
string postal_code = "";
string areacode = "";
string phone = "";
string email = "";
string website = "";
string rep = "";
string name = "";
System.Windows.Data.CollectionViewSource uSP_getOneVendorViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("uSP_getOneVendorViewSource")));
coolBlue.vendorDataSet VendorDataSet = ((coolBlue.vendorDataSet)(this.FindResource("vendorDataSet")));
//int accountCurrent = 0;
int wasnull = 0;
wasnull = (uSP_getOneVendorViewSource.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_getOneVendorViewSource.View.CurrentItem;
//accountCurrent = (drv == null ? 0 : DBNull.Value.Equals(drv["ID"]) == true ? 0 : (int)drv["ID"]);
notes = (DBNull.Value.Equals(drv["notes"]) == true ? "" : (string)drv["notes"]);
account_no = (DBNull.Value.Equals(drv["account_no"]) == true ? "" : (string)drv["account_no"]);
address1 = (DBNull.Value.Equals(drv["address1"]) == true ? "" : (string)drv["address1"]);
address2 = (DBNull.Value.Equals(drv["address2"]) == true ? "" : (string)drv["address2"]);
city = (DBNull.Value.Equals(drv["city"]) == true ? "" : (string)drv["city"]);
state = (DBNull.Value.Equals(drv["state"]) == true ? "" : (string)drv["state"]);
state_other = (DBNull.Value.Equals(drv["state_other"]) == true ? "" : (string)drv["state_other"]);
zip = (DBNull.Value.Equals(drv["zip"]) == true ? "" : (string)drv["zip"]);
country = (DBNull.Value.Equals(drv["country"]) == true ? "" : (string)drv["country"]);
postal_code = (DBNull.Value.Equals(drv["postal_code"]) == true ? "" : (string)drv["postal_code"]);
areacode = (DBNull.Value.Equals(drv["areacode"]) == true ? "" : (string)drv["areacode"]);
phone = (DBNull.Value.Equals(drv["phone"]) == true ? "" : (string)drv["phone"]);
email = (DBNull.Value.Equals(drv["email"]) == true ? "" : (string)drv["email"]);
website = (DBNull.Value.Equals(drv["website"]) == true ? "" : (string)drv["website"]);
rep = (DBNull.Value.Equals(drv["rep"]) == true ? "" : (string)drv["rep"]);
name = (DBNull.Value.Equals(drv["name"]) == true ? "" : (string)drv["name"]);
}
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_updateVendor";
cmd3.Parameters.AddWithValue("@ID", nVendorID);
cmd3.Parameters.AddWithValue("@notes", notes);
cmd3.Parameters.AddWithValue("@account_no", account_no);
cmd3.Parameters.AddWithValue("@address1", address1);
cmd3.Parameters.AddWithValue("@address2", address2);
cmd3.Parameters.AddWithValue("@city", city);
cmd3.Parameters.AddWithValue("@state", state);
cmd3.Parameters.AddWithValue("@state_other", state_other);
cmd3.Parameters.AddWithValue("@zip", zip);
cmd3.Parameters.AddWithValue("@country", country);
cmd3.Parameters.AddWithValue("@postal_code", postal_code);
cmd3.Parameters.AddWithValue("@areacode", areacode);
cmd3.Parameters.AddWithValue("@phone", phone);
cmd3.Parameters.AddWithValue("@email", email);
cmd3.Parameters.AddWithValue("@website", website);
cmd3.Parameters.AddWithValue("@rep", rep);
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();
}
}
