/// <summary> /// The SaveSupplier /// </summary> private void SaveSupplier() { object[,] objParams = new object[,] { { "suppName", txtSuppName.Text } }; try { using (SqlConnection conn = new SqlConnection(DatabaseProcessor.DatabaseConnectionString)) { var results = new DatabaseProcessor().Process("CreateSupplier", objParams, conn); if (results != null) { if (results.HasRows) { MessageBox.Show(results.GetString(0), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show("Supplier created", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); Invoke((MethodInvoker)delegate { Close(); }); } } results.Close(); } } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } }
/// <summary> /// The UpdateProduct /// </summary> private void UpdateProduct() { var prodCode = string.Empty; var prodDescr = string.Empty; var prodAmount = 0D; var prodSuppId = 0; Invoke((MethodInvoker) delegate { prodCode = txtProdId.Text; prodDescr = txtProdDescr.Text; prodAmount = Convert.ToDouble(txtProdPrice.Text); prodSuppId = Convert.ToInt32(cboSupps.SelectedValue); }); object[,] objParams = new object[, ] { { "prodDescr", prodDescr }, { "prodAmount", prodAmount }, { "prodSuppId", prodSuppId }, { "prodCode", prodCode }, { "prodId", _product.Id } }; try { using (SqlConnection conn = new SqlConnection(DatabaseProcessor.DatabaseConnectionString)) { var results = new DatabaseProcessor().Process("UpdateProduct", objParams, conn); if (results != null) { if (results.HasRows) { MessageBox.Show(results.GetString(0), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show("Product updated", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); Invoke((MethodInvoker) delegate { Close(); }); } } results.Close(); } } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } }