protected void GetProductRequisitionProductListById(string productRequisitionId) { ProductRequisitionBLL productRequisition = new ProductRequisitionBLL(); try { //Need to solve DataTable dt = productRequisition.GetProductRequisitionProductListById(productRequisitionId,""); if (dt.Rows.Count > 0) { productRequisitionProductListGridView.DataSource = dt; productRequisitionProductListGridView.DataBind(); if (productRequisitionProductListGridView.Rows.Count > 0) { productRequisitionProductListGridView.UseAccessibleHeader = true; productRequisitionProductListGridView.HeaderRow.TableSection = TableRowSection.TableHeader; } } else { msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = ""; } } catch (Exception ex) { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message; } finally { productRequisition = null; } }
protected void GetProductRequisitionProductListById(string productRequisitionId, string reqType) { ProductRequisitionBLL productRequisition = new ProductRequisitionBLL(); try { DataTable dt = productRequisition.GetProductRequisitionProductListById(productRequisitionId, reqType); if (dt.Rows.Count > 0) { productRequisitionProductListGridView.DataSource = dt; productRequisitionProductListGridView.DataBind(); if (productRequisitionProductListGridView.Rows.Count > 0) { approveButton.Enabled = true; productRequisitionProductListGridView.UseAccessibleHeader = true; productRequisitionProductListGridView.HeaderRow.TableSection = TableRowSection.TableHeader; TextBox approveQuantityTextBox; for (int i = 0; i < productRequisitionProductListGridView.Rows.Count; i++) { approveQuantityTextBox = (TextBox)productRequisitionProductListGridView.Rows[i].FindControl("approveQuantityTextBox"); //approveQuantityTextBox.Text = productRequisitionProductListGridView.Rows[i].Cells[3].Text.ToString(); approveQuantityTextBox.Text = dt.Rows[i][3].ToString(); } } else { approveButton.Enabled = false; } } else { msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = ""; } } catch (Exception ex) { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message; } finally { productRequisition = null; } }