private void ListQtyDetails()
{
try
{
pnlList.Visible = true;
grdList.Visible = true;
grdList.Rows.Clear();
ReportPOvsInvoiceQtyDB sdb = new ReportPOvsInvoiceQtyDB();
List <reportpendingsupplyqty> qtylist = ReportPendingSupplyDB.QtyList();
List <TotalStock> tStock = StockDB.TotalStock(Main.MainStore);
List <reportpendingsupplyqty> PendingSupList = ReportPendingSupplyDB.getPendingSupplyList();
foreach (reportpendingsupplyqty poqty in qtylist)
{
if (poqty.BalanceQty > 0)
{
try
{
grdList.Rows.Add();
grdList.Rows[grdList.RowCount - 1].Cells["StockItemID"].Value = poqty.StockItemID;
grdList.Rows[grdList.RowCount - 1].Cells["StockItemName"].Value = poqty.StockItemName;
grdList.Rows[grdList.RowCount - 1].Cells["POQty"].Value = poqty.POQty;
grdList.Rows[grdList.RowCount - 1].Cells["BilledQty"].Value = poqty.BilledQty;
grdList.Rows[grdList.RowCount - 1].Cells["BalanceQty"].Value = poqty.BalanceQty;
List <reportpendingsupplyqty> pList = PendingSupList.Where(x => x.StockItemID == poqty.StockItemID).ToList();
double total = pList.Sum(item => item.BalanceQty);
if (total != 0)
{
grdList.Rows[grdList.RowCount - 1].Cells["PendingPOQty"].Value = total; //For Pending Supply
}
else
{
grdList.Rows[grdList.RowCount - 1].Cells["PendingPOQty"].Value = Convert.ToDouble(0);
}
try
{
TotalStock tstk = tStock.Single(s => s.StockItemID == poqty.StockItemID);
if (tstk != null)
{
grdList.Rows[grdList.RowCount - 1].Cells["PresentStock"].Value = tstk.Stock;
}
if (poqty.BalanceQty <= tstk.Stock)
{
grdList.Rows[grdList.RowCount - 1].Cells["PresentStock"].Style.BackColor = Color.Yellow;
}
}
catch (Exception ex)
{
grdList.Rows[grdList.RowCount - 1].Cells["PresentStock"].Value = Convert.ToDouble(0);
}
double qtytobeproceured = 0.0;
try
{
qtytobeproceured =
Convert.ToDouble(grdList.Rows[grdList.RowCount - 1].Cells["BalanceQty"].Value) -
(Convert.ToDouble(grdList.Rows[grdList.RowCount - 1].Cells["PresentStock"].Value) +
Convert.ToDouble(grdList.Rows[grdList.RowCount - 1].Cells["PendingPOQty"].Value));
}
catch (Exception ex)
{
qtytobeproceured = 0.0;
}
if (qtytobeproceured > 0)
{
grdList.Rows[grdList.RowCount - 1].Cells["QtyToBeProcured"].Value = qtytobeproceured;
}
}
catch (Exception ex)
{
}
}
}
if (grdList.RowCount > 0)
{
txtSearch.Visible = true;
lblSearch.Visible = true;
btnExportToExcel.Visible = true;
}
}
catch (Exception ex)
{
MessageBox.Show("Error in Stock listing");
}
}
private DataGridView fillgrddetailForIntransit(string stockitemid)
{
DataGridView grdDetail = new DataGridView();
try
{
grdDetail.RowHeadersVisible = false;
DataGridViewTextBoxColumn dgvtx4 = new DataGridViewTextBoxColumn();
dgvtx4.Name = "PONo";
dgvtx4.HeaderText = "PO No";
dgvtx4.Width = 100;
grdDetail.Columns.Add(dgvtx4);
DataGridViewTextBoxColumn dgvtx5 = new DataGridViewTextBoxColumn();
dgvtx5.Name = "PODate";
dgvtx5.HeaderText = "PO Date";
dgvtx5.Width = 100;
grdDetail.Columns.Add(dgvtx5);
DataGridViewTextBoxColumn dgvtx10 = new DataGridViewTextBoxColumn();
dgvtx10.Name = "TargetDate";
dgvtx10.HeaderText = "Target Date";
dgvtx10.Width = 100;
grdDetail.Columns.Add(dgvtx10);
DataGridViewTextBoxColumn dgvtx6 = new DataGridViewTextBoxColumn();
dgvtx6.Width = 290;
dgvtx6.Name = "CustomerName";
dgvtx6.HeaderText = "Customer";
grdDetail.Columns.Add(dgvtx6);
DataGridViewTextBoxColumn dgvtx7 = new DataGridViewTextBoxColumn();
dgvtx7.Name = "OrderedQty";
dgvtx7.HeaderText = "Ordered Qty";
grdDetail.Columns.Add(dgvtx7);
DataGridViewTextBoxColumn dgvtx8 = new DataGridViewTextBoxColumn();
dgvtx8.Name = "ReceivedQty";
dgvtx8.HeaderText = "Received Qty";
grdDetail.Columns.Add(dgvtx8);
DataGridViewTextBoxColumn dgvtx9 = new DataGridViewTextBoxColumn();
dgvtx9.Name = "InTransitQty";
dgvtx9.HeaderText = "In-Transit Qty";
grdDetail.Columns.Add(dgvtx9);
List <reportpendingsupplyqty> qtyList = ReportPendingSupplyDB.GetInTransitQtyDetail(stockitemid);
int i = 0;
foreach (reportpendingsupplyqty qty in qtyList)
{
if (qty.POQty - qty.BilledQty > 0) // (Ordered Qunatity - ReceivedQunatity) > 0
{
grdDetail.Rows.Add();
grdDetail.Rows[i].Cells["PONo"].Value = qty.TrackingNo;
grdDetail.Rows[i].Cells["PODate"].Value = qty.TrackingDate.Date.ToString("dd-MM-yyyy");
grdDetail.Rows[i].Cells["CustomerName"].Value = qty.CustomerName;
grdDetail.Rows[i].Cells["TargetDate"].Value = qty.CustomerPODate.Date.ToString("dd-MM-yyyy");
grdDetail.Rows[i].Cells["OrderedQty"].Value = qty.POQty; //Ordered Quant
grdDetail.Rows[i].Cells["ReceivedQty"].Value = qty.BilledQty; //Received Quant
grdDetail.Rows[i].Cells["InTransitQty"].Value = qty.BalanceQty; //Supply Pending Quant
i++;
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error in Quantity listing");
}
return(grdDetail);
}
private DataGridView fillgrddetail(string stockitemid)
{
DataGridView grdDetail = new DataGridView();
try
{
grdDetail.RowHeadersVisible = false;
////DataGridViewLinkColumn dgvlc = new DataGridViewLinkColumn();
////dgvlc.SortMode = DataGridViewColumnSortMode.Automatic;
////grdDetail.Columns.Add(dgvlc);
DataGridViewTextBoxColumn dgvtx3 = new DataGridViewTextBoxColumn();
dgvtx3.Name = "ReferenceNo";
dgvtx3.Width = 80;
grdDetail.Columns.Add(dgvtx3);
DataGridViewTextBoxColumn dgvtx4 = new DataGridViewTextBoxColumn();
dgvtx4.Name = "CustomerPONo";
dgvtx4.Width = 80;
grdDetail.Columns.Add(dgvtx4);
DataGridViewTextBoxColumn dgvtx5 = new DataGridViewTextBoxColumn();
dgvtx5.Name = "CustomerPODate";
dgvtx5.Width = 90;
grdDetail.Columns.Add(dgvtx5);
DataGridViewTextBoxColumn dgvtx6 = new DataGridViewTextBoxColumn();
dgvtx6.Width = 200;
dgvtx6.Name = "CustomerName";
grdDetail.Columns.Add(dgvtx6);
DataGridViewTextBoxColumn dgvtx7 = new DataGridViewTextBoxColumn();
dgvtx7.Name = "POQty";
grdDetail.Columns.Add(dgvtx7);
DataGridViewTextBoxColumn dgvtx8 = new DataGridViewTextBoxColumn();
dgvtx8.Name = "BilledQty";
grdDetail.Columns.Add(dgvtx8);
DataGridViewTextBoxColumn dgvtx9 = new DataGridViewTextBoxColumn();
dgvtx9.Name = "BalanceQty";
grdDetail.Columns.Add(dgvtx9);
DataGridViewTextBoxColumn dgvtx0 = new DataGridViewTextBoxColumn();
dgvtx0.Name = "DocumentID";
grdDetail.Columns.Add(dgvtx0);
DataGridViewTextBoxColumn dgvtx1 = new DataGridViewTextBoxColumn();
dgvtx1.Name = "TrackingNo";
dgvtx1.Width = 70;
grdDetail.Columns.Add(dgvtx1);
DataGridViewTextBoxColumn dgvtx2 = new DataGridViewTextBoxColumn();
dgvtx2.Name = "TrackingDate";
dgvtx2.Width = 80;
grdDetail.Columns.Add(dgvtx2);
////////StockReconcolitationDB sdb = new StockReconcolitationDB();
List <reportpendingsupplyqty> qtyList = ReportPendingSupplyDB.GetQtyDetail(stockitemid);
int i = 0;
foreach (reportpendingsupplyqty qty in qtyList)
{
if (qty.POQty - qty.BilledQty > 0)
{
grdDetail.Rows.Add();
grdDetail.Rows[i].Cells["DocumentID"].Value = qty.DocumentID;
grdDetail.Rows[i].Cells["TrackingNo"].Value = qty.TrackingNo;
grdDetail.Rows[i].Cells["TrackingDate"].Value = qty.TrackingDate.Date.ToString("dd-MM-yyyy");
grdDetail.Rows[i].Cells["ReferenceNo"].Value = qty.ReferenceNo;
grdDetail.Rows[i].Cells["CustomerPoNo"].Value = qty.CustomerPoNo;
grdDetail.Rows[i].Cells["CustomerPODate"].Value = qty.CustomerPODate.Date.ToString("dd-MM-yyyy");
grdDetail.Rows[i].Cells["POQty"].Value = qty.POQty;
grdDetail.Rows[i].Cells["BilledQty"].Value = qty.BilledQty;
grdDetail.Rows[i].Cells["CustomerName"].Value = qty.CustomerName;
i++;
}
}
//btnExit.Visible = false;
}
catch (Exception ex)
{
MessageBox.Show("Error in Quantity listing");
}
return(grdDetail);
}
