private void dgvTransactionDetails_CellValidated(object sender, DataGridViewCellEventArgs e)
{
if (dgvTransactionDetails.Columns[e.ColumnIndex].Name == "TransactCostColumn" && e.RowIndex >= 0)
{
TransactionDataSet.TransactionDetailsRow tr = (TransactionDataSet.TransactionDetailsRow)((DataRowView)(dgvTransactionDetails.Rows[e.RowIndex].DataBoundItem)).Row;
tr.TotalCost = tr.TransactCost * tr.TransactQuantity;
InventoryStoreDataSetTableAdapters.tblInventoryTableAdapter adp = new InventoryStoreDataSetTableAdapters.tblInventoryTableAdapter();
Decimal OldQty = Convert.ToDecimal(adp.GetQuantity(tr.ProductID, tr.FromWareHouseID, tr.TransactCost));
TransactionDataSet.TransactionStockInformationRow trs = (TransactionDataSet.TransactionStockInformationRow)dtTransactionStockInformation.Select("TransactionDetailID=" + tr.TransactionDetailID)[0];
trs.Cost = tr.TransactCost;
trs.OldQuantity = OldQty;
trs.NewQuantity = OldQty + tr.TransactQuantity;
dgvTransactionDetails.Refresh();
}
//else if (dgvTransactionDetails.Columns[e.ColumnIndex].Name == "TransactQuantityColumn" && e.RowIndex >= 0)
//{
// TransactionDataSet.TransactionDetailsRow tr = (TransactionDataSet.TransactionDetailsRow)((DataRowView)(dgvTransactionDetails.Rows[e.RowIndex].DataBoundItem)).Row;
// tr.TotalCost = tr.TransactCost * tr.TransactQuantity;
// TransactionDataSet.TransactionStockInformationRow trs = (TransactionDataSet.TransactionStockInformationRow)dtTransactionStockInformation.Select("TransactionDetailID=" + tr.TransactionDetailID)[0];
// trs.TransactQuantity = tr.TransactQuantity;
// trs.NewQuantity = trs.OldQuantity + tr.TransactQuantity;
// dgvTransactionDetails.Refresh();
//}
}
private void btnAddToTransaction_Click(object sender, EventArgs e)
{
if (ValidateTransactionDetails())
{
DataRowView drProduct;
DataRowView drWareHouse;
drProduct = cmbProducts.SelectedItem as DataRowView;
int ProductID = Convert.ToInt32(drProduct.Row["ProductID"]);
drWareHouse = cmbWareHouse.SelectedItem as DataRowView;
int WareHouseID = Convert.ToInt32(drWareHouse.Row["WareHouseID"]);
Decimal TransactCost = Convert.ToDecimal(txtCost.Text.Trim());
Decimal TransactQuantity = Convert.ToDecimal(txtQuantity.Text.Trim());
InventoryStoreDataSetTableAdapters.tblInventoryTableAdapter adp = new InventoryStoreDataSetTableAdapters.tblInventoryTableAdapter();
InventoryStoreDataSet.tblInventoryDataTable dtInventory = adp.GetDataByProductAndWareHouse(ProductID, WareHouseID);
TransactionDataSet.TransactionDetailsRow drTransactionDetail = dtTransactionDetails.NewTransactionDetailsRow();
drTransactionDetail.ProductID = ProductID;
drTransactionDetail.ProductName = drProduct.Row["ProductName"].ToString();
drTransactionDetail.Manufacturer = drProduct.Row["Manufacturer"].ToString();
drTransactionDetail.FromWareHouseID = WareHouseID;
drTransactionDetail.FromWareHouseName = drWareHouse.Row["WareHouseName"].ToString();
drTransactionDetail.SetToWareHouseIDNull();
drTransactionDetail.SetToWareHouseNameNull();
drTransactionDetail.TransactQuantity = TransactQuantity;
drTransactionDetail.TransactCost = TransactCost;
drTransactionDetail.TotalCost = TransactCost * TransactQuantity;
drTransactionDetail.TransactionID = 0;
dtTransactionDetails.AddTransactionDetailsRow(drTransactionDetail);
foreach (InventoryStoreDataSet.tblInventoryRow drInventory in dtInventory.Rows)
{
Decimal OldQty = drInventory.Quantity;
TransactionDataSet.TransactionStockInformationRow drTransactionStockInformation = dtTransactionStockInformation.NewTransactionStockInformationRow();
drTransactionStockInformation.Cost = drInventory.Cost;
drTransactionStockInformation.OldQuantity = OldQty;
drTransactionStockInformation.NewQuantity = (TransactQuantity > OldQty) ? 0 : OldQty - TransactQuantity;
drTransactionStockInformation.TransactionDetailID = drTransactionDetail.TransactionDetailID;
drTransactionStockInformation.TransactQuantity = (TransactQuantity > OldQty) ? OldQty : TransactQuantity;
drTransactionStockInformation.IsFromWareHouse = true;
dtTransactionStockInformation.AddTransactionStockInformationRow(drTransactionStockInformation);
if (TransactQuantity > OldQty)
{
TransactQuantity = TransactQuantity - OldQty;
}
else
{
TransactQuantity = 0;
}
}
dgvTransactionDetails.Refresh();
}
}
private void dgvFromWareHouseStockInfo_CellValidated(object sender, DataGridViewCellEventArgs e)
{
if (dgvFromWareHouseStockInfo.Columns[e.ColumnIndex].Name == "TransactQuantity" && e.RowIndex >= 0)
{
TransactionDataSet.TransactionStockInformationRow trsFromWareHouse = (TransactionDataSet.TransactionStockInformationRow)((DataRowView)(dgvFromWareHouseStockInfo.Rows[e.RowIndex].DataBoundItem)).Row;
TransactionDataSet.TransactionStockInformationRow trsToWareHouse = (TransactionDataSet.TransactionStockInformationRow)((DataRowView)(dgvToWareHouseStockInfo.Rows[e.RowIndex].DataBoundItem)).Row;
trsFromWareHouse.NewQuantity = trsFromWareHouse.OldQuantity - trsFromWareHouse.TransactQuantity;
trsToWareHouse.NewQuantity = trsToWareHouse.OldQuantity + trsFromWareHouse.TransactQuantity;
trsToWareHouse.TransactQuantity = trsFromWareHouse.TransactQuantity;
dgvFromWareHouseStockInfo.Refresh();
dgvToWareHouseStockInfo.Refresh();
}
}
private void btnAddToTransaction_Click(object sender, EventArgs e)
{
if (ValidateTransactionDetails())
{
DataRowView drProduct;
DataRowView drWareHouse;
drProduct = cmbProducts.SelectedItem as DataRowView;
int ProductID = Convert.ToInt32(drProduct.Row["ProductID"]);
drWareHouse = cmbWareHouse.SelectedItem as DataRowView;
int WareHouseID = Convert.ToInt32(drWareHouse.Row["WareHouseID"]);
Decimal TransactCost = Convert.ToDecimal(txtCost.Text.Trim());
Decimal TransactQuantity = Convert.ToDecimal(txtQuantity.Text.Trim());
InventoryStoreDataSetTableAdapters.tblInventoryTableAdapter adp = new InventoryStoreDataSetTableAdapters.tblInventoryTableAdapter();
Decimal OldQty = Convert.ToDecimal(adp.GetQuantity(ProductID, WareHouseID, TransactCost));
TransactionDataSet.TransactionDetailsRow drTransactionDetail = dtTransactionDetails.NewTransactionDetailsRow();
TransactionDataSet.TransactionStockInformationRow drTransactionStockInformation = dtTransactionStockInformation.NewTransactionStockInformationRow();
drTransactionDetail.ProductID = ProductID;
drTransactionDetail.ProductName = drProduct.Row["ProductName"].ToString();
drTransactionDetail.Manufacturer = drProduct.Row["Manufacturer"].ToString();
drTransactionDetail.FromWareHouseID = WareHouseID;
drTransactionDetail.FromWareHouseName = drWareHouse.Row["WareHouseName"].ToString();
drTransactionDetail.SetToWareHouseIDNull();
drTransactionDetail.SetToWareHouseNameNull();
drTransactionDetail.TransactQuantity = TransactQuantity;
drTransactionDetail.TransactCost = TransactCost;
drTransactionDetail.TotalCost = TransactCost * TransactQuantity;
drTransactionDetail.TransactionID = 0;
//Object objTrID = dt.Compute("MAX(TransactionDetailID)", "");
//tr.TransactionDetailID = Convert.ToInt32(objTrID == DBNull.Value ? 0 : objTrID) + 1;
dtTransactionDetails.AddTransactionDetailsRow(drTransactionDetail);
drTransactionStockInformation.Cost = TransactCost;
drTransactionStockInformation.OldQuantity = OldQty;
drTransactionStockInformation.NewQuantity = OldQty + TransactQuantity;
drTransactionStockInformation.TransactionDetailID = drTransactionDetail.TransactionDetailID;
drTransactionStockInformation.TransactQuantity = TransactQuantity;
drTransactionStockInformation.IsFromWareHouse = true;
dtTransactionStockInformation.AddTransactionStockInformationRow(drTransactionStockInformation);
dgvTransactionDetails.Refresh();
}
}
private void dgvStockInfo_CellValidated(object sender, DataGridViewCellEventArgs e)
{
if (dgvStockInfo.Columns[e.ColumnIndex].Name == "TransactQuantity" && e.RowIndex >= 0)
{
TransactionDataSet.TransactionStockInformationRow trs = (TransactionDataSet.TransactionStockInformationRow)((DataRowView)(dgvStockInfo.Rows[e.RowIndex].DataBoundItem)).Row;
if (ActionType == WhistlingPalms.ActionType.Addition.ToString())
{
trs.NewQuantity = trs.OldQuantity + trs.TransactQuantity;
}
else if (ActionType == WhistlingPalms.ActionType.Deduction.ToString())
{
trs.NewQuantity = trs.OldQuantity - trs.TransactQuantity;
}
dgvStockInfo.Refresh();
}
}
