/// <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 CreatePurchaseOrderDetails
/// </summary>
/// <param name="poId">The poId<see cref="int"/></param>
private void CreatePurchaseOrderDetails(int poId)
{
foreach (var item in _purchaseOrderDto.productDetail)
{
object[,] objParams = new object[, ] {
{ "poId", poId },
{ "prodId", item.Id },
{ "prodAmount", item.Amount },
{ "prodQty", item.Qty }
};
using (SqlConnection conn = new SqlConnection(DatabaseProcessor.DatabaseConnectionString))
{
var results = new DatabaseProcessor().Process("CreatePurchaseOrderDetail", objParams, conn);
if (results != null)
{
results.Close();
}
}
}
Invoke((MethodInvoker) delegate
{
Close();
});
}
/// <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());
}
}
/// <summary>
/// The RemovePurchaseOrderItem
/// </summary>
/// <param name="PurchaseOrderItemId">The PurchaseOrderItemId<see cref="int"/></param>
private void RemovePurchaseOrderItem(int PurchaseOrderItemId)
{
Task.Factory.StartNew(() =>
{
using (SqlConnection conn = new SqlConnection(DatabaseProcessor.DatabaseConnectionString))
{
var results = new DatabaseProcessor().Process("RemovePurchaseOrderItem", new object[, ] {
{ "poId", PurchaseOrderItemId }
}, conn);
if (results != null)
{
Invoke((MethodInvoker) delegate
{
MessageBox.Show("Purchase order item removed", "Removed", MessageBoxButtons.OK, MessageBoxIcon.Information);
RetrievePurchaseOrderDetail();
});
results.Close();
}
}
});
}
/// <summary>
/// The UpdatePurchaseOrder
/// </summary>
private void UpdatePurchaseOrder()
{
var newRows = _purchaseOrderDto.productDetail.Where(p => p.NewItem == true).ToList();
if (newRows != null)
{
Task.Factory.StartNew(() =>
{
foreach (var item in newRows)
{
object[,] objParams = new object[, ] {
{ "poId", item.PurchaseOrderId },
{ "prodId", item.ProductId },
{ "prodAmount", item.Amount },
{ "prodQty", item.Qty }
};
using (SqlConnection conn = new SqlConnection(DatabaseProcessor.DatabaseConnectionString))
{
var results = new DatabaseProcessor().Process("CreatePurchaseOrderDetail", objParams, conn);
if (results != null)
{
results.Close();
}
}
}
Invoke((MethodInvoker) delegate
{
MessageBox.Show("Purchase order updated", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
RetrievePurchaseOrderDetail();
});
});
}
}
