private void ListQtyDetails()
{
try
{
pnlList.Visible = true;
grdList.Visible = true;
grdList.Rows.Clear();
ReportPOvsInvoiceQtyDB sdb = new ReportPOvsInvoiceQtyDB();
List <reportpovsinvoiceqty> qtylist = ReportPOvsInvoiceQtyDB.QtyList();
List <TotalStock> tStock = StockDB.TotalStock(Main.MainStore);
foreach (reportpovsinvoiceqty 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;
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 = 0;
}
}
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 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";
grdDetail.Columns.Add(dgvtx3);
DataGridViewTextBoxColumn dgvtx4 = new DataGridViewTextBoxColumn();
dgvtx4.Name = "CustomerPONo";
grdDetail.Columns.Add(dgvtx4);
DataGridViewTextBoxColumn dgvtx5 = new DataGridViewTextBoxColumn();
dgvtx5.Name = "CustomerPODate";
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";
grdDetail.Columns.Add(dgvtx1);
DataGridViewTextBoxColumn dgvtx2 = new DataGridViewTextBoxColumn();
dgvtx2.Name = "TrackingDate";
dgvtx2.Width = 100;
grdDetail.Columns.Add(dgvtx2);
////////StockReconcolitationDB sdb = new StockReconcolitationDB();
List <reportpovsinvoiceqty> qtyList = ReportPOvsInvoiceQtyDB.GetQtyDetail(stockitemid);
int i = 0;
foreach (reportpovsinvoiceqty 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);
}
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");
}
}
