private void GeneratePayment(dsCore ds)
{
dsCore dt = new dsCore();
dt.EnforceConstraints = false;
// copy master record
dt.Orders.Rows.Add(ds.Orders[0].ItemArray);
// ubah jenis transaksi
dt.Orders[0].ParentID = ds.Orders[0].ID;
dt.Orders[0].OrderNo = DbHelper.GenerateNewOrderID(TransactionTypes.TX_PURCHASE_PAYMENT, dt.Orders[0].OrderDate.Year);
dt.Orders[0].OrderType = TransactionTypes.TX_PURCHASE_PAYMENT;
dt.Orders[0].OrderValue = Convert.ToDouble(c1NumericEdit1.Value);
// detail payment
dsCore.OrderDetailsRow row = dt.OrderDetails.NewOrderDetailsRow();
row.OrderID = dt.Orders[0].ID;
row.ReferenceID = InvoiceID;
row.UnitPrice = Convert.ToDouble(c1NumericEdit1.Value);
row.Quantity = 1;
row.TaxPct = 0;
if (!dt.Orders[0].IsRemarksNull())
{
row.Remarks = ds.Orders[0].Remarks;
}
dt.OrderDetails.AddOrderDetailsRow(row);
// persist changes to database
daOrders1.Update(dt.Orders);
daOrderDetails1.Update(dt.OrderDetails);
// remember result
PaymentID = dt.Orders[0].ID;
PaymentNum = dt.Orders[0].OrderNo;
}
private void c1Combo2_SelectedValueChanged(object sender, EventArgs e)
{
if (txMode == DataEntryModes.Add)
{
try
{
// get data
dsCore ds = new dsCore();
OrdersTableAdapter od = new OrdersTableAdapter();
OrderDetailsTableAdapter ta = new OrderDetailsTableAdapter();
ds.EnforceConstraints = false;
od.Connection = AppHelper.GetDbConnection();
od.FillByID(ds.Orders, (int)c1Combo2.SelectedValue);
ta.Connection = AppHelper.GetDbConnection();
ta.FillNotCompleted(ds.OrderDetails, (int)c1Combo2.SelectedValue);
// clear grid
dsCore1.OrderDetails.Clear();
// fill grid with new data
_grid.Redraw = false;
DataRowView dv = (DataRowView)this.BindingContext[dsCore1, "Orders"].Current;
dv["CompanyID"] = ds.Orders[0].CompanyID;
dv["CurrencyID"] = ds.Orders[0].CurrencyID;
if (!ds.Orders[0].IsCompanyIDNull())
{
c1Combo1.SelectedValue = ds.Orders[0].CompanyID;
}
if (!ds.Orders[0].IsCurrencyIDNull())
{
c1Combo3.SelectedValue = ds.Orders[0].CurrencyID;
}
foreach (dsCore.OrderDetailsRow src in ds.OrderDetails.Rows)
{
dsCore.OrderDetailsRow row = dsCore1.OrderDetails.NewOrderDetailsRow();
row.OrderID = (int)dv["ID"];
row.ItemID = src.ItemID;
row.ItemCode = src.ItemCode;
row.ItemName = src.ItemName;
row.Quantity = src.Quantity;
row.UnitPrice = src.UnitPrice;
row.TaxPct = src.TaxPct;
row.Remarks = src.Remarks;
row.MeasureCode = src.MeasureCode;
dsCore1.OrderDetails.AddOrderDetailsRow(row);
}
// redraw grid
_grid.Redraw = true;
_grid.Refresh();
// recalculate order value
c1Label1.Value = CountDetails();
}
catch (Exception ex)
{
// textfile logging
Logger.ErrorRoutine(ex);
// screen logging
RibbonMessageBox.Show("ERROR Retrieving Detail Data: \n" + ex.Message,
Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
}
private void GenerateInvoice(dsCore ds)
{
dsCore dt = new dsCore();
dt.EnforceConstraints = false;
// copy master record
dt.Orders.Rows.Add(ds.Orders[0].ItemArray);
// copy juga detail record dari main dataset
for (int i = 0; i < ds.OrderDetails.Rows.Count; i++)
{
dt.OrderDetails.Rows.Add(ds.OrderDetails.Rows[i].ItemArray);
}
// ubah jenis transaksi
dt.Orders[0].ParentID = ds.Orders[0].ID;
dt.Orders[0].OrderNo = DbHelper.GenerateNewOrderID(TransactionTypes.TX_PURCHASE_INVOICE, dt.Orders[0].OrderDate.Year);
dt.Orders[0].OrderType = TransactionTypes.TX_PURCHASE_INVOICE;
dt.Orders[0].OrderValue = ds.Orders[0].OrderValue;
// persist changes to database
daOrders1.Update(dt.Orders);
daOrderDetails1.Update(dt.OrderDetails);
// remember result
InvoiceID = dt.Orders[0].ID;
InvoiceNum = dt.Orders[0].OrderNo;
}
private void c1Combo1_SelectedValueChanged(object sender, EventArgs e)
{
if (txMode == DataEntryModes.Add)
{
try
{
// prevent redraw
_grid.Redraw = false;
// get data
dsCore ds = new dsCore();
OrdersTableAdapter od = new OrdersTableAdapter();
ds.EnforceConstraints = false;
od.Connection = AppHelper.GetDbConnection();
od.FillOutstandingSalesInvoices(ds.Orders, (int)c1Combo1.SelectedValue);
// clear grid
dsCore1.OrderDetails.Clear();
// fill grid with new data
DataRowView dv = (DataRowView)this.BindingContext[dsCore1, "Orders"].Current;
foreach (dsCore.OrdersRow src in ds.Orders.Rows)
{
dsCore.OrderDetailsRow row = dsCore1.OrderDetails.NewOrderDetailsRow();
row.OrderID = (int)dv["ID"];
row.ReferenceID = src.ID;
row.ReferenceNo = src.OrderNo;
row.ReferenceDate = src.OrderDate;
row.ReferenceValue = src.OutstandingValue;
row.UnitPrice = src.OutstandingValue;
row.Quantity = 1;
row.TaxPct = 0;
if (!src.IsRemarksNull())
{
row.Remarks = src.Remarks;
}
dsCore1.OrderDetails.AddOrderDetailsRow(row);
}
// recalculate
CountDetails();
// redraw grid
_grid.Redraw = true;
_grid.Refresh();
}
catch (Exception ex)
{
// textfile logging
Logger.ErrorRoutine(ex);
// screen logging
RibbonMessageBox.Show("ERROR Retrieving Detail Data: \n" + ex.Message,
Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
dsCore ds = new dsCore();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace)) {
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length)) {
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length)
&& (s1.ReadByte() == s2.ReadByte())); ) {
;
}
if ((s1.Position == s1.Length)) {
return type;
}
}
}
}
finally {
if ((s1 != null)) {
s1.Close();
}
if ((s2 != null)) {
s2.Close();
}
}
}
xs.Add(dsSchema);
return type;
}
private void btnSave_Click(object sender, EventArgs e)
{
// Validate all required field(s)
if (!ValidateUserInput())
{
return;
}
// if you get here, it means that all user input has been validated
Cursor = Cursors.AppStarting;
try
{
// End editing
BindingContext[dsCore1, "Orders"].EndCurrentEdit();
BindingContext[dsCore1, "OrderDetails"].EndCurrentEdit();
// There are changes that need to be made, so attempt to update the datasource by
// calling the update method and passing the dataset and any parameters.
if (txMode == DataEntryModes.Add)
{
// copy master record dari main dataset
// harus dilakukan krena main dataset sebelumnya sudah
// AcceptChanges padahal belum diupdate ke database
dsChanges = new dsCore();
dsChanges.EnforceConstraints = false;
dsChanges.Orders.Rows.Add(((DataRowView)this.BindingContext[dsCore1, "Orders"].Current).Row.ItemArray);
// persist changes to database
daOrders1.Update(dsChanges.Orders);
// inform user, successful
RibbonMessageBox.Show("Data SUCCESFULLY saved to database",
Application.ProductName, MessageBoxButtons.YesNo, MessageBoxIcon.Information);
}
else
{
// persist changes to database
daOrders1.Update(dsCore1.Orders);
// inform user for successful update
RibbonMessageBox.Show("Changes SUCCESFULLY saved to database",
Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
// success, close form
btnClose.PerformClick();
}
catch (SqlException ex)
{
// textfile logging
Logger.ErrorRoutine(ex);
// screen logging
if (ex.Number != 2601)
{
RibbonMessageBox.Show("ERROR Saving Data: \n" + ex.Message,
Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
RibbonMessageBox.Show("ERROR Saving Data:\n" +
"Document number [" + c1TextBox1.Text + "]already existed in database\n" +
"Please change this document number and try saving again.",
Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception ex)
{
// textfile logging
Logger.ErrorRoutine(ex);
// screen logging
RibbonMessageBox.Show("ERROR Saving Data: \n" + ex.Message,
Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
Cursor = Cursors.Default;
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
dsCore ds = new dsCore();
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "CurrenciesDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace)) {
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length)) {
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length)
&& (s1.ReadByte() == s2.ReadByte())); ) {
;
}
if ((s1.Position == s1.Length)) {
return type;
}
}
}
}
finally {
if ((s1 != null)) {
s1.Close();
}
if ((s2 != null)) {
s2.Close();
}
}
}
xs.Add(dsSchema);
return type;
}
public virtual int Update(dsCore.ItemsDataTable dataTable) {
return this.Adapter.Update(dataTable);
}
public virtual int FillByID(dsCore.ItemsDataTable dataTable, int p1) {
this.Adapter.SelectCommand = this.CommandCollection[3];
this.Adapter.SelectCommand.Parameters[0].Value = ((int)(p1));
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public virtual int Update(dsCore dataSet) {
return this.Adapter.Update(dataSet, "Currencies");
}
public virtual int FillDeveloper(dsCore.CompaniesDataTable dataTable) {
this.Adapter.SelectCommand = this.CommandCollection[5];
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public virtual int Update(dsCore dataSet) {
return this.Adapter.Update(dataSet, "Warehouses");
}
public virtual int Update(dsCore.WarehousesDataTable dataTable) {
return this.Adapter.Update(dataTable);
}
public virtual int Update(dsCore dataSet) {
return this.Adapter.Update(dataSet, "UnitMeasures");
}
public virtual int Update(dsCore.UnitMeasuresDataTable dataTable) {
return this.Adapter.Update(dataTable);
}
public virtual int FillActive(dsCore.CurrenciesDataTable dataTable) {
this.Adapter.SelectCommand = this.CommandCollection[1];
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public virtual int Update(dsCore.CurrenciesDataTable dataTable) {
return this.Adapter.Update(dataTable);
}
public virtual int Update(dsCore.OrderDetailsDataTable dataTable) {
return this.Adapter.Update(dataTable);
}
public virtual int FillByCode(dsCore.ItemsDataTable dataTable, string p1) {
this.Adapter.SelectCommand = this.CommandCollection[2];
if ((p1 == null)) {
throw new global::System.ArgumentNullException("p1");
}
else {
this.Adapter.SelectCommand.Parameters[0].Value = ((string)(p1));
}
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public virtual int Update(dsCore dataSet) {
return this.Adapter.Update(dataSet, "OrderDetails");
}
public virtual int FillDenormalized(dsCore.ItemsDataTable dataTable) {
this.Adapter.SelectCommand = this.CommandCollection[4];
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public virtual int FillOutstandingSalesInvoices(dsCore.OrdersDataTable dataTable, global::System.Nullable<int> p1) {
this.Adapter.SelectCommand = this.CommandCollection[10];
if ((p1.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[0].Value = ((int)(p1.Value));
}
else {
this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
}
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public virtual int Update(dsCore dataSet) {
return this.Adapter.Update(dataSet, "Items");
}
public virtual int FillPurchaseInvoiceAll(dsCore.OrdersDataTable dataTable) {
this.Adapter.SelectCommand = this.CommandCollection[13];
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
private void btnSave_Click(object sender, EventArgs e)
{
// Validate all required field(s)
if (!ValidateUserInput())
{
return;
}
// if you get here, it means that all user input has been validated
Cursor = Cursors.AppStarting;
try
{
// End editing
BindingContext[dsCore1, "Orders"].EndCurrentEdit();
BindingContext[dsCore1, "OrderDetails"].EndCurrentEdit();
// There are changes that need to be made, so attempt to update the datasource by
// calling the update method and passing the dataset and any parameters.
if (txMode == DataEntryModes.Add)
{
// copy master record dari main dataset
// harus dilakukan krena main dataset sebelumnya sudah
// AcceptChanges padahal belum diupdate ke database
dsChanges = new dsCore();
dsChanges.EnforceConstraints = false;
dsChanges.Orders.Rows.Add(((DataRowView)this.BindingContext[dsCore1, "Orders"].Current).Row.ItemArray);
// copy juga detail record dari main dataset
for (int i = 0; i < dsCore1.OrderDetails.Rows.Count; i++)
{
dsChanges.OrderDetails.Rows.Add(dsCore1.OrderDetails.Rows[i].ItemArray);
}
// persist changes to database
daOrders1.Update(dsChanges.Orders);
daOrderDetails1.Update(dsChanges.OrderDetails);
// only generate invoice
GenerateInvoice(dsChanges);
// generate payment record for cash payment
if (radioButton1.Checked || Convert.ToDouble(c1NumericEdit1.Value) > 0)
{
GeneratePayment(dsChanges);
}
// inform user, successful
DialogResult dr = RibbonMessageBox.Show("Data SUCCESFULLY saved to database\n" +
(InvoiceID < 0 ? "" : "New Invoice Voucher [" + InvoiceNum + "] created automatically\n") +
(PaymentID < 0 ? "" : "New Payment Voucher [" + PaymentNum + "] created automatically\n") +
"Do you want to print this document?\n",
Application.ProductName, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
// ask user for voucher print
if (dr == DialogResult.Yes)
{
Cursor = Cursors.AppStarting;
Form fx = new frmReportViewer1(ReportHelper1.LoadPurchaseOrderForm(c1TextBox1.Text));
fx.WindowState = FormWindowState.Maximized;
fx.ShowDialog();
Cursor = Cursors.Default;
}
}
else
{
// persist changes to database
daOrders1.Update(dsCore1.Orders);
daOrderDetails1.Update(dsCore1.OrderDetails);
// inform user for successful update
RibbonMessageBox.Show("Changes SUCCESFULLY saved to database",
Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
// success, close form
btnClose.PerformClick();
}
catch (SqlException ex)
{
// textfile logging
Logger.ErrorRoutine(ex);
// screen logging
if (ex.Number != 2601)
{
RibbonMessageBox.Show("ERROR Saving Data: \n" + ex.Message,
Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
RibbonMessageBox.Show("ERROR Saving Data:\n" +
"Document number [" + c1TextBox1.Text + "]already existed in database\n" +
"Please change this document number and try saving again.",
Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception ex)
{
// textfile logging
Logger.ErrorRoutine(ex);
// screen logging
RibbonMessageBox.Show("ERROR Saving Data: \n" + ex.Message,
Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
Cursor = Cursors.Default;
}
public virtual int FillSalesQuotation(dsCore.OrdersDataTable dataTable, global::System.Nullable<global::System.DateTime> date1, global::System.Nullable<global::System.DateTime> date2) {
this.Adapter.SelectCommand = this.CommandCollection[24];
if ((date1.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[0].Value = ((System.DateTime)(date1.Value));
}
else {
this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
}
if ((date2.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(date2.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public virtual int FillSalesQuotationAll(dsCore.OrdersDataTable dataTable) {
this.Adapter.SelectCommand = this.CommandCollection[25];
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
private void btnSave_Click(object sender, EventArgs e)
{
// Validate all required field(s)
if (!ValidateUserInput())
{
return;
}
// if you get here, it means that all user input has been validated
Cursor = Cursors.AppStarting;
try
{
// End editing
BindingContext[dsCore1, "Orders"].EndCurrentEdit();
BindingContext[dsCore1, "OrderDetails"].EndCurrentEdit();
// Validaton Check order detail item -> by K
if (dsCore1.OrderDetails.Rows.Count == 0)
{
RibbonMessageBox.Show("No item inventory in this order\n" +
"Please input item at least one item\n",
Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
// End Validation -> by K
// There are changes that need to be made, so attempt to update the datasource by
// calling the update method and passing the dataset and any parameters.
if (txMode == DataEntryModes.Add)
{
// copy master record dari main dataset
// harus dilakukan krena main dataset sebelumnya sudah
// AcceptChanges padahal belum diupdate ke database
dsChanges = new dsCore();
dsChanges.EnforceConstraints = false;
// Possible NULL value dataRowView .:By K:.
var dataRowView = (DataRowView)BindingContext[dsCore1, "Orders"].Current;
if (dataRowView != null)
{
dsChanges.Orders.Rows.Add(dataRowView.Row.ItemArray);
}
// copy juga detail record dari main dataset
for (var i = 0; i < dsCore1.OrderDetails.Rows.Count; i++)
{
dsChanges.OrderDetails.Rows.Add(dsCore1.OrderDetails.Rows[i].ItemArray);
}
// persist changes to database
daOrders1.Update(dsChanges.Orders);
daOrderDetails1.Update(dsChanges.OrderDetails);
// inform user, successful
DialogResult dr = RibbonMessageBox.Show("Data SUCCESFULLY saved to database\n" +
"Do you want to print this document?\n",
Application.ProductName, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
// ask user for voucher print
if (dr == DialogResult.Yes)
{
Cursor = Cursors.AppStarting;
Form fx = new frmReportViewer1(ReportHelper1.LoadSalesQuotationForm(c1TextBox1.Text));
fx.WindowState = FormWindowState.Maximized;
fx.ShowDialog();
Cursor = Cursors.Default;
}
}
else
{
// persist changes to database
daOrders1.Update(dsCore1.Orders);
daOrderDetails1.Update(dsCore1.OrderDetails);
// inform user for successful update
RibbonMessageBox.Show("Changes SUCCESFULLY saved to database",
Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
// success, close form
btnClose.PerformClick();
}
catch (SqlException ex)
{
// textfile logging
Logger.ErrorRoutine(ex);
// screen logging
if (ex.Number != 2601)
{
RibbonMessageBox.Show("ERROR Saving Data: \n" + ex.Message,
Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
RibbonMessageBox.Show("ERROR Saving Data:\n" +
"Document number [" + c1TextBox1.Text + "]already existed in database\n" +
"Please change this document number and try saving again.",
Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception ex)
{
// textfile logging
Logger.ErrorRoutine(ex);
// screen logging
RibbonMessageBox.Show("ERROR Saving Data: \n" + ex.Message,
Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
Cursor = Cursors.Default;
}
