public AddPurchasesForm(PurchaseOrderDataModel purchase)
{
InitializeComponent();
init();
supplierNameComboBox.Text = purchase.supplierName;
statusComboBox.Text = purchase.status;
dateCreatedDateTimePicker.Value = purchase.dateCreated;
expectedDateofDeliveryDateTimePicker.Value = purchase.deliveryDate;
orderRefTextBox.Text = purchase.orderNo;
grandTotalPricetextBox.Text = FormatPrice.format(purchase.grandTotalPrice);
grandTotalQuantitytextBox.Text = purchase.grandTotalQuantity.ToString();
grandTotalQuantity = purchase.grandTotalQuantity;
grandTotalPrice = purchase.grandTotalPrice;
addProductToDatagridView(purchase.productsList);
saveButton.Enabled = false;
deleteButton.Enabled = true;
editbutton.Enabled = true;
purchasedStocks = purchase.productsList;
this.purchases = purchase;
}
public Reports(PurchaseOrderDataModel purchases, List <StockDataModel> stocks, SupplierDataModel suppliers, ClientDataModel clients)
{
InitializeComponent();
ClientDataModelBindingSource.DataSource = clients;
SupplierDataModelBindingSource.DataSource = suppliers;
PurchaseOrderDataModelBindingSource.DataSource = purchases;
StockDataModelBindingSource.DataSource = stocks;
}
private async void print(PurchaseOrderDataModel order)
{
var supplier = getSupplier();
var client = getClient();
var stocks = await getStocks(purchasedStocks);
Reports rv = new Reports(order, stocks, supplier, client);
rv.Show();
//new Reports().Show();
}
private async void getData(string _orderId)
{
progressBar1.Visible = true;
string orderId = _orderId;
if (!_orderId.Contains("PO-"))
{
orderId = "PO-" + _orderId;
}
purchaseOrder = await DatabaseOperations.getPurchaseOderByOrderId(orderId);
if (purchaseOrder != null)
{
supplierNameTextBox.Text = purchaseOrder.supplierName;
statusTextBox.Text = purchaseOrder.status;
dateCreatedTextBox.Text = purchaseOrder.dateCreated.ToString();
deliveryDateTextBox.Text = purchaseOrder.deliveryDate.ToString();
grandTotalPriceTextBox.Text = FormatPrice.format(purchaseOrder.grandTotalPrice);
grandTotalQuantityTextBox.Text = purchaseOrder.grandTotalQuantity.ToString();
if (purchaseOrder.productsList != null && purchaseOrder.productsList.Any())
{
foreach (var data in purchaseOrder.productsList)
{
quantityOnPurchaseOrder.Add(data.quantityToSupply);
stocksOnPurchaseOrder.Add(await DatabaseOperations.getStockById(data.stockId));
}
updateDataGrid.addPurchaseToDataGrid(stocksOnPurchaseOrder, quantityOnPurchaseOrder, dataGridView1);
}
saveButton.Enabled = true;
addAllButton.Enabled = true;
}
else
{
MessageBox.Show("The order ref does not exist. You can check Purchases page for the correct purchase orderId");
}
progressBar1.Visible = false;
}
private async void processData(bool isEdit)
{
string supplierName = getSupplier().name;
string status = statusComboBox.Text;
DateTime dateCreated = dateCreatedDateTimePicker.Value;
DateTime deliveryDate = expectedDateofDeliveryDateTimePicker.Value;
string order = orderRefTextBox.Text;
string clientId = getClient().id;
string supplierId = getSupplier().id;
string staffName = clientComboBox.Text;
if (isEdit)
{
if (!MessagePrompt.displayPrompt("Edit", "edit this purchase order"))
{
return;
}
purchases.productsList = purchasedStocks;
purchases.supplierName = supplierName;
purchases.supplierId = supplierId;
purchases.status = status;
purchases.dateCreated = dateCreated;
purchases.deliveryDate = deliveryDate;
purchases.orderNo = order;
purchases.staffName = staffName;
purchases.staffId = clientId;
purchases.grandTotalPrice = grandTotalPrice;
purchases.grandTotalQuantity = grandTotalQuantity;
MessageBox.Show(await DatabaseOperations.editpurchases(this.purchases) ? "Data updated successfully" :
"Data updating failed");
if (MessagePrompt.printPrompt("purchase order"))
{
print(purchases);
}
}
else
{
if (!MessagePrompt.displayPrompt("Create New", "Create new purchase order"))
{
return;
}
var purchaseOrder = new PurchaseOrderDataModel();
purchaseOrder.supplierName = supplierName;
purchaseOrder.staffName = staffName;
purchaseOrder.status = status;
purchaseOrder.dateCreated = dateCreated;
purchaseOrder.deliveryDate = deliveryDate;
purchaseOrder.orderNo = order;
purchaseOrder.staffId = clientId;
purchaseOrder.supplierId = supplierId;
purchaseOrder.grandTotalPrice = grandTotalPrice;
purchaseOrder.grandTotalQuantity = grandTotalQuantity;
purchaseOrder.productsList = purchasedStocks;
DatabaseOperations.addPurchases(purchaseOrder);
MessageBox.Show("Purchase saved successfull");
if (MessagePrompt.printPrompt("purchase order"))
{
print(purchaseOrder);
}
this.orderRefTextBox.Text = GenerateIDs.purchaseOrderId();
this.dataGridView1.Rows.Clear();
grandTotalPrice = 0;
grandTotalQuantity = 0;
totalPriceTextBox.Text = FormatPrice.format(getTotalPrice(quantityToSupplytextBox.Text));
grandTotalQuantitytextBox.Text = getTotalQuantity(quantityToSupplytextBox.Text);
grandTotalPricetextBox.Text = FormatPrice.format(getTotalPrice(quantityToSupplytextBox.Text));
}
}
private async void getEditData(string _orderId)
{
progressBar1.Visible = true;
string orderId = _orderId;
if (!_orderId.Contains("PO-"))
{
orderId = "PO-" + _orderId;
}
purchaseOrder = await DatabaseOperations.getPurchaseOderByOrderId(orderId);
if (purchaseOrder != null)
{
supplierNameTextBox.Text = purchaseOrder.supplierName;
statusTextBox.Text = purchaseOrder.status;
dateCreatedTextBox.Text = purchaseOrder.dateCreated.ToString();
deliveryDateTextBox.Text = purchaseOrder.deliveryDate.ToString();
grandTotalPriceTextBox.Text = FormatPrice.format(purchaseOrder.grandTotalPrice);
grandTotalQuantityTextBox.Text = purchaseOrder.grandTotalQuantity.ToString();
if (purchaseOrder.productsList != null && purchaseOrder.productsList.Any())
{
var purchaseStocks = purchaseOrder.productsList;
var purchasedStockList = new List <string>();
var receivedStockList = new List <string>();
var purchaseQuantityList = new List <int>();
foreach (var ds in purchaseStocks)
{
purchasedStockList.Add(ds.stockId);
purchaseQuantityList.Add(ds.quantityToSupply);
}
if (receivedNotes != null && receivedNotes.goodsReceived != null && receivedNotes.goodsReceived.Any())
{
var receivedStocks = receivedNotes.goodsReceived;
foreach (var dr in receivedStocks)
{
receivedStockList.Add(dr.stockId);
}
for (int i = 0; i < receivedStockList.Count(); i++)
{
if (purchasedStockList.Contains(receivedStockList.ElementAt(i)))
{
purchaseQuantityList.RemoveAt(purchasedStockList.IndexOf(receivedStockList.ElementAt(i)));
purchasedStockList.Remove(receivedStockList.ElementAt(i));
}
}
}
quantityOnPurchaseOrder.AddRange(purchaseQuantityList);
foreach (var stockId in purchasedStockList)
{
stocksOnPurchaseOrder.Add(await DatabaseOperations.getStockById(stockId));
}
updateDataGrid.addPurchaseToDataGrid(stocksOnPurchaseOrder, quantityOnPurchaseOrder, dataGridView1);
updateDataGrid.addSelectedNoteToDataGridView(selectedStocks, selectedQuantity, dataGridView2);
}
}
else
{
MessageBox.Show("The order ref does not exist. You can check Purchases page for the correct purchase orderId");
}
progressBar1.Visible = false;
}
