private void ListFilteredStock()
{
try
{
pnlList.Visible = true;
grdList.Visible = true;
grdList.Rows.Clear();
StockReconcolitationDB sdb = new StockReconcolitationDB();
List <stockreconcolitation> stockList = StockReconcolitationDB.GetStockReconcolitationList();
foreach (stockreconcolitation st in stockList)
{
grdList.Rows.Add();
grdList.Rows[grdList.RowCount - 1].Cells["StockItemID"].Value = st.StockItemID;
grdList.Rows[grdList.RowCount - 1].Cells["StockItemName"].Value = st.StockItemName;
grdList.Rows[grdList.RowCount - 1].Cells["Reciept"].Value = st.Reciept;
grdList.Rows[grdList.RowCount - 1].Cells["Issue"].Value = st.Issue;
grdList.Rows[grdList.RowCount - 1].Cells["Balance"].Value = st.PresentStock;
}
if (grdList.RowCount > 0)
{
txtSearch.Visible = true;
lblSearch.Visible = true;
btnExportToExcel.Visible = true;
}
}
catch (Exception ex)
{
MessageBox.Show("Error in Stock listing");
}
}
//----------------
//private void setdgvStyle()
//{
// dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
// dataGridViewCellStyle2.BackColor = System.Drawing.SystemColors.Highlight;
// dataGridViewCellStyle2.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
// dataGridViewCellStyle2.ForeColor = System.Drawing.SystemColors.WindowText;
// dataGridViewCellStyle2.SelectionBackColor = System.Drawing.SystemColors.Highlight;
// dataGridViewCellStyle2.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
// dataGridViewCellStyle2.WrapMode = System.Windows.Forms.DataGridViewTriState.True;
// this.grdList.AllowUserToAddRows = false;
// this.grdList.AllowUserToDeleteRows = false;
// this.grdList.AllowUserToOrderColumns = true;
// //dataGridViewCellStyle1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(255)))), ((int)(((byte)(255)))));
// //this.grdList.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle1;
// this.grdList.BackgroundColor = System.Drawing.SystemColors.GradientActiveCaption;
// this.grdList.BorderStyle = System.Windows.Forms.BorderStyle.None;
// dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
// dataGridViewCellStyle2.BackColor = System.Drawing.SystemColors.Highlight;
// dataGridViewCellStyle2.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
// dataGridViewCellStyle2.ForeColor = System.Drawing.SystemColors.WindowText;
// dataGridViewCellStyle2.SelectionBackColor = System.Drawing.SystemColors.Highlight;
// dataGridViewCellStyle2.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
// dataGridViewCellStyle2.WrapMode = System.Windows.Forms.DataGridViewTriState.True;
//}
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 dgvtx1 = new DataGridViewTextBoxColumn();
dgvtx1.Name = "DocumentDate";
grdDetail.Columns.Add(dgvtx1);
DataGridViewTextBoxColumn dgvtx2 = new DataGridViewTextBoxColumn();
dgvtx2.Name = "DocumentID";
dgvtx2.Width = 150;
grdDetail.Columns.Add(dgvtx2);
DataGridViewTextBoxColumn dgvtx3 = new DataGridViewTextBoxColumn();
dgvtx3.Name = "DocumentNo";
grdDetail.Columns.Add(dgvtx3);
DataGridViewTextBoxColumn dgvtx4 = new DataGridViewTextBoxColumn();
dgvtx4.Name = "Receipt";
grdDetail.Columns.Add(dgvtx4);
DataGridViewTextBoxColumn dgvtx5 = new DataGridViewTextBoxColumn();
dgvtx5.Name = "Issue";
grdDetail.Columns.Add(dgvtx5);
DataGridViewTextBoxColumn dgvtx6 = new DataGridViewTextBoxColumn();
dgvtx6.Name = "Balance";
grdDetail.Columns.Add(dgvtx6);
StockReconcolitationDB sdb = new StockReconcolitationDB();
List <stockreconcolitation> stockList = StockReconcolitationDB.GetStockReconcolitationDetailList(stockitemid);
int i = 0;
foreach (stockreconcolitation st in stockList)
{
grdDetail.Rows.Add();
grdDetail.Rows[i].Cells["DocumentDate"].Value = st.DocumentDate.Date.ToString("dd-MM-yyyy");
grdDetail.Rows[i].Cells["DocumentID"].Value = st.DocumentID;
grdDetail.Rows[i].Cells["DocumentNo"].Value = st.DocumentNo;
grdDetail.Rows[i].Cells["Receipt"].Value = st.Reciept;
grdDetail.Rows[i].Cells["Issue"].Value = st.Issue;
i++;
}
}
catch (Exception ex)
{
MessageBox.Show("Error in Stock listing");
}
return(grdDetail);
}
