private void fillGrid(string str)
{
try
{
//clear the gridview if there are any rows
grd_editStockEntry.DataSource = null;
grd_editStockEntry.Refresh();
DataGridViewButtonColumn col = new DataGridViewButtonColumn();
col.DataPropertyName = "stockEntryId";
col.Name = "stockEntryId";
col.HeaderText = "Stock Entry Id";
grd_editStockEntry.Columns.Add(col);
grd_editStockEntry.DataSource = MANAGEDB.getStockDetails(str);
grd_editStockEntry.ColumnHeadersDefaultCellStyle.Font = new Font(DataGridView.DefaultFont, FontStyle.Bold);
//arrange the gridview
grd_editStockEntry.Columns["stockEntryId"].DisplayIndex = 0;
grd_editStockEntry.Columns["itemCode"].DisplayIndex = 1;
grd_editStockEntry.Columns["itemName"].DisplayIndex = 2;
grd_editStockEntry.Columns["quantity"].DisplayIndex = 3;
grd_editStockEntry.Columns["remainQuantity"].DisplayIndex = 4;
grd_editStockEntry.Columns["misPlacedQty"].DisplayIndex = 5;
grd_editStockEntry.Columns["buyingUnitPrice"].DisplayIndex = 6;
grd_editStockEntry.Columns["totalValue"].DisplayIndex = 7;
grd_editStockEntry.Columns["sellingUnitPrice"].DisplayIndex = 8;
grd_editStockEntry.Columns["createDate"].DisplayIndex = 9;
//grd_editStockEntry.Columns["updateDate"].DisplayIndex = 10;
//grd_editStockEntry.Columns["stockEntryDate"].DisplayIndex = 11;
//grd_editStockEntry.Columns["expirationDate"].DisplayIndex = 12;
grd_editStockEntry.Columns["dealerName"].DisplayIndex = 10;
//change headers
grd_editStockEntry.Columns["stockEntryId"].HeaderText = "Stock_Entry_ID";
grd_editStockEntry.Columns["itemCode"].HeaderText = "Item_Code";
grd_editStockEntry.Columns["itemName"].HeaderText = "Item_Name";
grd_editStockEntry.Columns["quantity"].HeaderText = "Qty";
grd_editStockEntry.Columns["remainQuantity"].HeaderText = "Remain_Qty";
grd_editStockEntry.Columns["misPlacedQty"].HeaderText = "MIsplaced_Qty";
grd_editStockEntry.Columns["buyingUnitPrice"].HeaderText = "Unit_Price(Buy)";
grd_editStockEntry.Columns["totalValue"].HeaderText = "Total_Val";
grd_editStockEntry.Columns["sellingUnitPrice"].HeaderText = "Unit_Price(Sell)";
grd_editStockEntry.Columns["createDate"].HeaderText = "Create_Date";
//grd_editStockEntry.Columns["updateDate"].HeaderText = "Update";
//grd_editStockEntry.Columns["stockEntryDate"].HeaderText = "Entry_Date";
//grd_editStockEntry.Columns["expirationDate"].HeaderText = "Expire";
grd_editStockEntry.Columns["dealerName"].HeaderText = "Dealer";
//hide columns
grd_editStockEntry.Columns["updateDate"].Visible = false;
grd_editStockEntry.Columns["stockEntryDate"].Visible = false;
grd_editStockEntry.Columns["expirationDate"].Visible = false;
grd_editStockEntry.Columns["itemId"].Visible = false;
grd_editStockEntry.Columns["priceAfterDiscount"].Visible = false;
grd_editStockEntry.Columns["comment"].Visible = false;
grd_editStockEntry.Columns["releaseFlg"].Visible = false;
grd_editStockEntry.Columns["dealerId"].Visible = false;
}
catch (Exception ex)
{
COM_MESSAGE.exceptionMessage(ex.Message);
}
}
